BOM插入记录

最新推荐文章于 2021-02-18 19:19:32 发布

雁过留香

最新推荐文章于 2021-02-18 19:19:32 发布

阅读量277

点赞数

CC 4.0 BY-SA版权

分类专栏： SQL触发器

本文链接：https://blog.youkuaiyun.com/qq_41969460/article/details/87880223

SQL触发器专栏收录该内容

10 篇文章

订阅专栏

本文深入探讨了SQL触发器的应用，特别是在更新操作时如何通过触发器实现自动化的业务逻辑执行，如在特定条件下进行数据的自动插入。通过一个具体的示例，展示了如何在更新字段状态时触发子数据的插入流程。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

alter TRIGGER [GF_BOM插入记录]
ON [dbo].[t_bominserted]
FOR update
AS
SET ANSI_WARNINGS OFF

declare @FID int,@FMultiCheckStatus int,@FOldStatus int

select @FID = FID,@FMultiCheckStatus = FMultiCheckStatus from inserted
select @FOldStatus = FMultiCheckStatus from deleted

if update (FMultiCheckStatus) and @FOldStatus = 4 and @FMultiCheckStatus = 16 --单据审核时
begin
insert into icbomchild (FBRNO,FEntryID,FinterID,FitemID,Fauxqty,Fqty,Fscrap,Fopersn,Foperid,FMaterielType,FMarshalType,
Fpercent,Fbeginday,Fendday,Foffsetday,FbackFlush,FspID,Fsupply,FunitID)

   select 0,t2.FMaxEntryID + b.Findex,a.FID_SRC1,b.FitemID,1,1,0,0,0,371,385,100,'1900-01-01 00:00:00.000','2100-01-01 00:00:00.000',
   0,1059,0,0,b.FunitID from t_bominserted a
   inner join t_bominsertedentry b on a.FID= b.FID
   inner join icbom t1 on a.FID_SRC1 = t1.FinterID
   inner join (select FinterID,max(FEntryID) as FMaxEntryID from icbomchild group by FinterID) t2 on t1.FinterID = t2.FinterID
   where a.FID = @FID
end