SQL Server 触发器：Inter_PurchaseOrder 表更新后的操作

ALTER TRIGGER [dbo].[Inter_PurchaseOrder_Update] ON [dbo].[Inter_PurchaseOrder] AFTER UPDATE AS BEGIN declare @FrozenStateNew int,@UpdateState int declare @FinterID int,--采购申请主键 @FMangerID int,--采购经理ID @FHeadSelfP0271 varchar(50),--采购经理 @FHeadSelfP0258 varchar(50),--采购副总 @FHeadSelfP0261 varchar(50),--总经理 @FHeadSelfP0260 varchar(50),--董事长 @FCheckerID int,--审核人（终审） @FCheckdate datetime,--审核日期 @FHeadSelfP0270 varchar(50) --OA单号 --取值 select @FHeadSelfP0271=Manager,--采购经理 @FHeadSelfP0258=DeputyGeneralManager ,--采购副总 @FHeadSelfP0261=GeneralManager ,--总经理 @FHeadSelfP0260=Chairman ,--董事长 @FCheckerID=b.FUserID,--审核人（终审） @FCheckdate =ReviewDate,--审核日期 @FHeadSelfP0270 = OANo,--OA单号 @FrozenStateNew = FrozenState, @FinterID =FinterID, @UpdateState = UpdateState from inserted a inner join t_user b on a.ReviewUser=b.FName if(@FrozenStateNew=1) begin update POOrder set FHeadSelfP0271 =@FHeadSelfP0271, FHeadSelfP0258 =@FHeadSelfP0258, FHeadSelfP0261 =@FHeadSelfP0261, FHeadSelfP0260 =@FHeadSelfP0260, FCheckerID=@FCheckerID, FCheckdate=@FCheckdate, FHeadSelfP0270=@FHeadSelfP0270, FStatus = 1 --审核通过 where FInterID =@FinterID if(@UpdateState = 0) begin update Inter_PurchaseOrder set UpdateState = 1 where FinterID = @FinterID end end END