您好,请备份数据库之后,执行以下语句
--审核所有未审核的调价单
update t_pc_price_flow_master SET approve_flag ='1' WHERE approve_flag = '0' AND trans_no = 'PX'
--审核所有未审核的库存调整单
update t_im_sheet_master SET approve_flag ='1' WHERE approve_flag = '0' AND trans_no = 'OO'
您好,请备份数据库之后,执行以下语句
--审核所有未审核的调价单
update t_pc_price_flow_master SET approve_flag ='1' WHERE approve_flag = '0' AND trans_no = 'PX'
--审核所有未审核的库存调整单
update t_im_sheet_master SET approve_flag ='1' WHERE approve_flag = '0' AND trans_no = 'OO'