BOM删除记录

最新推荐文章于 2024-11-12 10:14:22 发布

原创最新推荐文章于 2024-11-12 10:14:22 发布 · 613 阅读

0 ·

CC 4.0 BY-SA版权

SQL触发器专栏收录该内容

10 篇文章

订阅专栏

本文介绍了一个SQL触发器的实现细节，该触发器用于在BOM删除记录更新时，根据特定条件删除相关联的icbomchild表中的记录。触发器检查FMultiCheckStatus字段的变化，当其从4变为16时，执行删除操作。

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

create TRIGGER [GF_BOM删除记录]
ON [dbo].[t_bomdeleted]
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
delete from icbomchild
where
finterid in (select b.finterid from t_bomdeleted t1
inner join t_bomdeletedentry t2 on t1.fid = t2.fid
inner join icbomchild b on t2.fid_src = b.finterid and t2.fitemid = b.fitemid
where t1.fid = @FID)
and
fitemid in (select b.fitemid from t_bomdeleted t1
inner join t_bomdeletedentry t2 on t1.fid = t2.fid
inner join icbomchild b on t2.fid_src = b.finterid and t2.fitemid = b.fitemid
where t1.fid = @FID)

end