60 lines
1.4 KiB
Transact-SQL
60 lines
1.4 KiB
Transact-SQL
CREATE PROCEDURE AjouterLSTArticle
|
|
@ID int OUTPUT,
|
|
@PanierID int,
|
|
@ArticleID int,
|
|
@Quantite int,
|
|
@PrixHTVA money,
|
|
@TVA int
|
|
AS
|
|
INSERT INTO LSTArticle(PanierID,ArticleID,Quantite,PrixHTVA,TVA)
|
|
VALUES(@PanierID,@ArticleID,@Quantite,@PrixHTVA,@TVA)
|
|
SET @ID=@@IDENTITY
|
|
RETURN
|
|
GO
|
|
CREATE PROCEDURE ModifierLSTArticle
|
|
@ID int,
|
|
@PanierID int,
|
|
@ArticleID int,
|
|
@Quantite int,
|
|
@PrixHTVA money,
|
|
@TVA int
|
|
AS
|
|
IF(@ID IS NULL OR @ID=0)
|
|
RAISERROR('Identifiant requis !',16,1)
|
|
ELSE UPDATE LSTArticle
|
|
SET PanierID=@PanierID,ArticleID=@ArticleID,Quantite=@Quantite,PrixHTVA=@PrixHTVA,TVA=@TVA
|
|
WHERE ID=@ID
|
|
RETURN
|
|
GO
|
|
CREATE PROCEDURE SelectionnerLSTArticle
|
|
@Index VARCHAR(10)
|
|
AS
|
|
IF(@Index='PanierID') SELECT * FROM LSTArticle ORDER BY PanierID
|
|
ELSE IF(@Index='ArticleID') SELECT * FROM LSTArticle ORDER BY ArticleID
|
|
ELSE IF(@Index='Quantite') SELECT * FROM LSTArticle ORDER BY Quantite
|
|
ELSE IF(@Index='PrixHTVA') SELECT * FROM LSTArticle ORDER BY PrixHTVA
|
|
ELSE IF(@Index='TVA') SELECT * FROM LSTArticle ORDER BY TVA
|
|
ELSE SELECT * FROM LSTArticle ORDER BY ID
|
|
RETURN
|
|
GO
|
|
CREATE PROCEDURE SelectionnerLSTArticle_ID
|
|
@ID int
|
|
AS
|
|
IF(@ID IS NULL)
|
|
RAISERROR('Identifiant requis !',16,1)
|
|
ELSE
|
|
SELECT ID,PanierID,ArticleID,Quantite,PrixHTVA,TVA
|
|
FROM LSTArticle
|
|
WHERE @ID=ID
|
|
RETURN
|
|
GO
|
|
CREATE PROCEDURE SupprimerLSTArticle
|
|
@ID int
|
|
AS
|
|
IF(@ID IS NULL)
|
|
RAISERROR('Identifiant requis !',16,1)
|
|
ELSE
|
|
DELETE FROM LSTArticle WHERE @ID=ID
|
|
RETURN
|
|
GO
|