-- =============================================
-- Author: <Author,,Name>
-- Create date: <Create Date,,>
-- Description: <Description,,>
-- =============================================
CREATE TRIGGER [dbo].[LB06-LA03]
ON [dbo].[ASMTH]
AFTER UPDATE
AS
IF EXISTS(SELECT * FROM inserted WHERE inserted.TH001 = 'LB06' AND inserted.TH009 = 'Y' AND inserted.TH201 > 0 AND inserted.TH201 IS NOT NULL)
AND UPDATE(TH009)
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON
INSERT ASMTF
(
FLAG,
TF001,
TF002,
TF003,
TF004,
TF005,
TF006,
TF007,
TF008,
TF009,
TF010,
--TF011,
TF012,
TF013,
--TF014,
--TF015,
TF016,
--TF017,
--TF018,
--TF019,
--TF020,
--TF021,
--TF022,
TF023,
TF024,
TF025,
TF026,
UDF01,
UDF02,
UDF03,
UDF11,
UDF05,
UDF12
)
SELECT
1,
'LA03',
TH002,
TH022,
TH004,
'JN01',
TH006,
'',
'0',
'N',
TH001 + '-' + TH002 + '配件交易单审核后自动生成',
--'',
TH201,
0,
--'',
--'',
0,
--'',
--'',
--'',
--'',
--'',
--'',
'',
'',
TH022,
TH022,
inserted.UDF01,
inserted.UDF02,
inserted.UDF03,
inserted.UDF12,
inserted.UDF10,
TH022
FROM inserted
WHERE inserted.TH001 = 'LB06' AND inserted.TH009 = 'Y'
INSERT ASMTG
(
FLAG,
TG001,
TG002,
TG003,
TG004,
TG005,
TG006,
TG007,
TG008,
TG009,
TG010,
TG011,
TG012,
TG013,
TG014,
TG015,
TG016,
TG017,
TG018,
TG019,
TG020,
TG021,
TG022,
TG023,
TG024,
TG025,
TG026,
--TG027,
--TG028,
--TG029,
--TG030,
--TG031,
--TG032,
TG033,
UDF03
)
SELECT
1,
'LA03',
TI002,
TI003,
ASMTI.UDF04,
ASMTI.UDF55,
MB004,
MB017,
'##########',
'',
'',
'',
'N',
'',
TI012,
'N',
'',
TI012,
'',
'',
ASMTI.UDF55,
0,
'',
ASMTI.UDF05,
ASMTI.UDF06,
0,
0,
--'',
--'',
--'',
--'',
--'',
--'',
1,
TI012
FROM inserted INNER JOIN ASMTI ON inserted.TH001 = ASMTI.TI001 AND inserted.TH002 = ASMTI.TI002
INNER JOIN INVMB ON ASMTI.UDF04 = INVMB.MB001
WHERE
inserted.TH001 = 'LB06' AND inserted.TH009 = 'Y' AND ASMTI.UDF02 = '是' AND ASMTI.UDF04 <> ''
-- Insert statements for trigger here
UPDATE ASMTH SET ASMTH.UDF51 = 1 FROM ASMTH LEFT JOIN inserted ON inserted.TH001 = ASMTH.TH001 AND inserted.TH002 = ASMTH.TH002
END