快速复制新增物料

最新推荐文章于 2024-04-22 16:00:31 发布

原创

最新推荐文章于 2024-04-22 16:00:31 发布 · 467 阅读

0 ·

CC 4.0 BY-SA版权

alter TRIGGER GF_快速复制新增物料
ON t_copyitem
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 = 2 and @FMultiCheckStatus = 4 --单据启动审核时
Begin

--declare @FID int
--set @FID = 1001
               if object_id('tempdb..#A') is not null Begin
                               drop table #A
                           End
                           select * into #A from
                       (select 1 as FIndex,FNumber,FName,FCopyNumber,FID,
                       substring(FNumber,1,len(FNumber)-5) as FParentNumber
                           from t_copyitem where FID = @FID
                       union all
                       select 2 as FIndex,'1090'+substring(FNumber,5,99),FName+'半成品','1090'+substring(FCopyNumber,5,99),FID,
                       substring('1090'+substring(FNumber,5,99),1,len('1090'+substring(FNumber,5,99))-5) as FParentNumber
                           from t_copyitem where FID = @FID
                       union all
                       select 3 as FIndex,'1090'+substring(FNumber,5,99),FName+'半成品','1090'+substring(FCopyNumber,5,99),FID,
                       substring('1090'+substring(FNumber,5,99),1,len('1090'+substring(FNumber,5,99))-5) as FParentNumber
                           from t_copyitem where FID = @FID
                       union all
                       select b.Findex+3,b.FNumber,b.FName,'1090'+substring(FCopyNumber,5,99)+'.'+right(b.FNumber,4),a.FID,
                       substring(b.FNumber,1,len(b.FNumber)-5) as FParentNumber
                           from t_copyitem a
                       inner join t_copyitementry b on a.FID = b.FID where a.FID = @FID) a
--               select * from #A