CREATE procedure [dbo].CpteCltHist_Insert
@CpteJumelle nvarchar (20) ,
@Denomination nvarchar (100) ,
@Devise nvarchar (3) ,
@DateOperation datetime ,
@Debit float ,
@Credit float ,
@RefOperation nvarchar (30) ,
@Employe smallint ,
@lect int=null output
as
Declare @Rows int,
@ErrNo Int,
@ErrMsg varchar(255),
@NumSerie numeric
Set Nocount off
Begin Transaction
Insert into CpteCltHist(CpteJumelle,Denomination,Devise,DateOperation,Debit,Credit,RefOperation,
Employe)values(@CpteJumelle,@Denomination,@Devise,@DateOperation,@Debit,@Credit,@RefOperation,
@Employe)
Set @ErrNo =@@error
If @ErrNo <> 0
Begin
Rollback Transaction
Set @lect=1
Set Nocount on
Return @lect --@ErrNo
End
Insert into AuditCpteCltHist(CpteJumelle,Denomination,Devise,SerieOp,DateOperation,Debit,Credit,RefOperation,
Employe,RowStatus)values(@CpteJumelle,@Denomination,@Devise,@DateOperation,@Debit,@Credit,@RefOperation,
@Employe,'I')
Set @ErrNo =@@error
If @ErrNo = 0
Begin
Commit Transaction
Set @lect=0
Set Nocount on
Return @lect --0
End
Else
Begin
Rollback Transaction
Set @lect=3
Set Nocount on
Return @lect --@ErrNo
End
'procedure pr inserer une operation de retrait d'argent
CREATE procedure [dbo].OpCaisA_Insert
@CpteClient nvarchar (20) ,
@DateOperation datetime ,
@Devise nvarchar (3) ,
@Debit float ,
@Credit float ,
@RefOperation nvarchar (20) ,
@Caisse nvarchar (10) ,
@CpteCaisse nvarchar (10) ,
@Description nvarchar (80) ,
@lect int=null output
as
Declare @Rows int,
@ErrNo Int,
@ErrMsg varchar(255)
Set Nocount off
Begin Transaction
Insert into OpCaisA(CpteClient,DateOperation,Devise,
Debit,Credit,RefOperation,Caisse,CpteCaisse,Employe,[Description]) values(@CpteClient,@DateOperation,@Devise,@Debit,@Credit,@RefOperation,@Caisse,@CpteCaisse,@Employe,@Description)
Set @ErrNo =@@error
If @ErrNo <> 0
Begin
Rollback Transaction
Set @lect=1
Set Nocount on
Return @lect
End
Insert into AuditOpCaisA(CpteClient,DateOperation,Devise,
Debit,Credit,RefOperation,Caisse,CpteCaisse,Employe,[Description],RowStatus) values(@CpteClient,@DateOperation,@Devise,@Debit,@Credit,@RefOperation,@Caisse,@CpteCaisse,@Employe,@Description,'I')
Set @ErrNo =@@error
If @ErrNo = 0
Begin
Commit Transaction
Set @lect=0
Set Nocount on
Return @lect
End
Else
Begin
Rollback Transaction
Set @lect=2
Set Nocount on
Return @lect --@ErrNo
End
Partager