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
| BEGIN
declare @PINCODE as varchar(10);
declare @PCVISVALIDE as varchar(10);
declare @PCVNUM as varchar(50);
declare @shell as varchar(8000);
declare ins_cur cursor FAST_FORWARD for (select PCVNUM from inserted);
declare @sqlCommand as Nvarchar(4000);
declare @numdevis as VARCHAR(50);
declare @pcvnumcde as varchar(50);
set @pcvnumcde = (SELECT PCVNUM from inserted);
set @sqlCommand ='SELECT TOP (1) @numdevis = Entete_Devis.PCVNUM FROM PIECEVENTELIGNES AS Ligne_Devis INNER JOIN
PIECEVENTES AS Entete_Devis ON Ligne_Devis.PCVID = Entete_Devis.PCVID INNER JOIN
PIECEVENTELIGNES AS Ligne_Cde ON Ligne_Devis.PLVID = Ligne_Cde.PLVIDORG INNER JOIN
PIECEVENTES AS Entete_CDE ON Ligne_Cde.PCVID = Entete_CDE.PCVID
where Entete_CDE.PCVNUM=@pcvnumcde';
EXEC sp_executesql @sqlCommand, N'@pcvnumcde VARCHAR(50), @numdevis VARCHAR(50) OUTPUT',
@pcvnumcde=@pcvnumcde, @numdevis=@numdevis OUTPUT
SELECT @numdevis ReturnedName
IF UPDATE (PCVNUM)
BEGIN
SELECT @PINCODE=I.PINCODE, @PCVNUM=I.PCVNUM FROM INSERTED I;
IF @PINCODE = 'CDECLI'
/* set @shell = 'echo EP;' + @PCVNUM + '>> "\\192.168.1.9\data srvlx\Factures\"PDF' + @PCVNUM + '.txt';*/
set @shell = 'echo ' + @numdevis + ';1''>> "H:\Site Web\Out\orders_in\"accepted' + @pcvnumcde + '.csv';
exec master..xp_cmdshell @shell;
end
end; |
Partager