1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64
| set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
ALTER procedure [dbo].[PR_Insert_All_QR]
(@DMSATransactionID nvarchar(10),
@TABSTransactionID nvarchar(10),
@ClientID nchar(10) ,
@CustomerID nvarchar(10),
@Action_Date datetime,
@InvoiceNo nvarchar(10),
@TABSAccountNo nvarchar(10),
@ProductID numeric(18, 0),
@Expire_Date datetime,
@AgentID nvarchar(10),
@PU nvarchar(10),
@Quantity numeric(18, 0),
@MNT_HT_Prd nvarchar(10),
@Distrib float,
@zone nvarchar(15),
@flag nchar(10),
@day int,
@Resultat nvarchar(10),
@Date_Now datetime,
@User_Name nvarchar(10),
@Date_Entry datetime,
@User_Entry numeric,
@Patche nvarchar(50),
@Mnt_HT numeric,
@Mnt_TTC1 numeric,
@Mnt_TTC2 numeric,
@Nom nvarchar(50),
@Adresse nvarchar(250),
@Wilaya nvarchar(50),
@commune nvarchar(50),
@code_postal nchar(10),
@MainPhone nvarchar(10),
@HommePhonne nvarchar(9),
@Comments nvarchar(50),
@Date_Collecte datetime,
@Patche_Ref int)
AS
declare @ref_fact nvarchar (8)
if not exists (select ref_fact from facture where InvoiceNo=@InvoiceNo and ClientID=@ClientID)
begin
exec @ref_fact = dbo.QR_FN_GetNewRef_fact Get_DT_Server
exec PR_Insert_Facture_QR @Ref_fact,@InvoiceNo,@CustomerID,@Nom,@ClientID
,@Adresse ,@commune ,@Wilaya ,@code_postal ,@Action_Date ,@Expire_Date
,@MainPhone, @HommePhonne, @Distrib ,@zone ,@flag, @day, @Resultat
,@Date_Collecte ,@Date_Entry ,@User_Entry , Get_DT_Server,@User_Name
,@Patche ,@Mnt_HT ,@Mnt_TTC1 ,@Mnt_TTC2
end
set @ref_fact=(select ref_fact from facture where InvoiceNo=@InvoiceNo and ClientID=@ClientID )
exec PR_Insert_Ligne_Fact @DMSATransactionID , @TABSTransactionID ,
@CustomerID ,@TABSAccountNo ,@InvoiceNo ,@ProductID ,
@AgentID , @PU ,@MNT_HT_Prd , @Quantity ,@Ref_Fact ,@Patche_Ref |
Partager