CREATE TRIGGER [dbo].[SendCOPMail]
ON [dbo].[COPTG]
after update
AS
SET NOCOUNT ON;
BEGIN
DECLARE @TG001 nvarchar(20)
DECLARE @NEW_TG002 nvarchar(20)
DECLARE @CONTENT nvarchar(max)
DECLARE @KHBH nvarchar(20)
DECLARE @KHMC nvarchar(40)
DECLARE @TG023 nvarchar(40)
DECLARE @TG004 nvarchar(40)
DECLARE @tableHTML NVARCHAR(MAX)
SELECT @TG001=TG001,@TG002=TG002,@TG023=TG023,@TG004=TG004 FROM inserted
BEGIN
if UPDATE(TG023) AND @TG023='Y'
BEGIN
SELECT @KHBH=MA001,@KHMC=MA002 FROM COPMA WHERE MA001=@TG004
DECLARE test_Cursor CURSOR SCROLL FOR
SELECT TH004,TH005,TH006,TH001,TH002,TH003,convert(varchar(20),convert(decimal(16,6),TH008)),TH037
FROM COPTH
WHERE TH001=@TG001 AND TH002=@TG002
OPEN test_Cursor
DECLARE @TH001 nvarchar(20)
DECLARE @TH002 nvarchar(20)
DECLARE @TH003 nvarchar(20)
DECLARE @TH008 nv
【易飞9.0】销货单触发器发送邮件存在问题
最新推荐文章于 2023-04-20 16:24:08 发布