修改制单人
--销售订单/采购订单
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)