修改制单人
--销售订单/采购订单
select * from ordBillMain where (销售Flag=2 or 采购Flag=4)
update a set a.MakerID='8005',a.Maker='张顺利' from ordBillMain a where Flag=2
--销售出库单/采购入库单
select * from comBillAccounts where (采购Flag=102 or 销售Flag=502)
update a set a.MakerID='8001',a.Maker='朱娣' from comBillAccounts a where Flag=102
--其他出库单/其他入库单
select * from stkAdjustMain where (出库单Flag=355 or 入库单Flag=352)
update a set a.MakerID='803',a.Maker='李素珍' from stkAdjustMain a where Flag=355
修改复核人
--查询销售订单语法
select PermitterID,'8006',Permitter,'张薇' from ordBillMain where(销售Flag=2 or 采购Flag=4)
update a set PermitterID='8002',Permitter='李启艳' from ordBillMain a where Flag=4
--销售出库单/采购入库单
select * from comBillAccounts where (采购Flag=102 or 销售Flag=502)
update a set a.PermitterID='8006',a.Permitter='李启艳' from comBillAccounts a where Flag=102
--其他出库单/其他入库单
select * from stkAdjustMain where (Flag=355 or Flag=352)
update a set a.PermitterID='8004',a.Permitter='欧阳奇' from stkAdjustMain a where (Flag=355 or Flag=352)
[此贴子已经被作者于2023/7/25 11:20:43编辑过]
加好友 
发短信
Post By：2022/9/28 11:54:36 [只看该作者]
