SQL Server 触发器 Inter_PurchaseOrder_Update 后更新操作

{"title":"ALTER TRIGGER [dbo].[Inter_PurchaseOrder_Update] \n ON [dbo].[Inter_PurchaseOrder] \n AFTER UPDATE\nAS \nBEGIN\n\tdeclare @FrozenStateNew int,@UpdateState int\n\n\tdeclare @FinterID int,--采购申请主键\n\t\t\t@FMangerID int,--采购经理ID \n\t\t\t@FHeadSelfP0271 varchar(50),\t--采购经理\n\t\t\t@FHeadSelfP0258 varchar(50),\t--采购副总\n\t\t\t@FHeadSelfP0261\tvarchar(50),\t--总经理\n\t\t\t@FHeadSelfP0260 varchar(50),\t--董事长\n\t\t\t@FCheckerID\tint,\t--审核人（终审）\n\t\t\t@FCheckdate\tdatetime,\t--审核日期\n\t\t\t@FHeadSelfP0270 varchar(50)\t--OA单号\n\t\t\n\t--取值 \n\tselect \n\t\t\t\n\t\t\t@FHeadSelfP0271=Manager,--采购经理\n\t\t\t@FHeadSelfP0258=DeputyGeneralManager ,\t--采购副总\n\t\t\t@FHeadSelfP0261=GeneralManager\t,\t--总经理\n\t\t\t@FHeadSelfP0260=Chairman ,\t--董事长\n\t\t\t@FCheckerID=b.FUserID,--审核人（终审）\n\t\t\t@FCheckdate =ReviewDate,\t--审核日期\n\t\t\t@FHeadSelfP0270 = OANo,\t--OA单号\n\t\t\t@FrozenStateNew = FrozenState,\n\t\t\t@FinterID =FinterID,\n\t\t\t@UpdateState = UpdateState\n\tfrom inserted a \n\tinner join t_user b on a.ReviewUser=b.FName\n\t\n\t\n\tif(@FrozenStateNew=1)\n\tbegin\n\n\t\tupdate POOrder set \n\t\tFHeadSelfP0271 =@FHeadSelfP0271,\n\t\tFHeadSelfP0258 =@FHeadSelfP0258,\n\t\tFHeadSelfP0261 =@FHeadSelfP0261,\n\t\tFHeadSelfP0260 =@FHeadSelfP0260,\n\t\tFCheckerID=@FCheckerID,\n\t\tFCheckdate=@FCheckdate,\n\t\tFHeadSelfP0270=@FHeadSelfP0270,\n\t\tFStatus = 1 --审核通过\n\t\twhere FInterID =@FinterID\n\t\t\n\t\tif(@UpdateState = 0)\n\t\tbegin\n\t\t\n\t\t\tupdate Inter_PurchaseOrder \n\t\t\tset UpdateState = 1\n\t\t\twhere FinterID = @FinterID\n\t\t\tend\n\n\tend\n\n\nEND"}