From db25c944428a0f857097aa05b7be1716e7a3751b Mon Sep 17 00:00:00 2001 From: zrg <z18737863051@163.com> Date: 星期五, 31 五月 2024 17:32:06 +0800 Subject: [PATCH] 1.采购入库单,生产入库单,委外加工入库单,其他入库单,分步式调入单,生产退料单,销售退货单 审核时 增加库存, 反审核时 减少库存; 2.销售出库单,生产领料单,分步式调出单,委外加工出库单,其他出库单,采购退料单,生产退库单 审核时 减少库存, 反审核时 增加 库存; (写在通用的方法中了,只有符合条件的才会进行更新,对原有审核/反审核无影响) --- WebAPI/DLL/ClsGy_PostSkill_Ctl.cs | 6 ++++-- 1 files changed, 4 insertions(+), 2 deletions(-) diff --git a/WebAPI/DLL/ClsGy_PostSkill_Ctl.cs b/WebAPI/DLL/ClsGy_PostSkill_Ctl.cs index 9af16c8..8d34add 100644 --- a/WebAPI/DLL/ClsGy_PostSkill_Ctl.cs +++ b/WebAPI/DLL/ClsGy_PostSkill_Ctl.cs @@ -20,9 +20,9 @@ oCn.BeginTran(); oCn.RunProc("Insert into " + MvarItemKey + " " + " (HNumber,HName,HHelpCode,HShortNumber,HParentID" + - ",HLevel,HEndFlag,HStopflag,HRemark,HMakeTime,HUSEORGID,HUseFlag,HMakeEmp,HCREATEORGID,HERPItemID) " + + ",HLevel,HEndFlag,HStopflag,HRemark,HMakeTime,HUSEORGID,HUseFlag,HMakeEmp,HCREATEORGID,HPostID,HProcID) " + " Values('" + oModel.HNumber + "','" + oModel.HName + "','" + oModel.HHelpCode + "','" + oModel.HShortNumber + "'," + oModel.HParentID.ToString() + - "," + oModel.HLevel.ToString() + "," + Convert.ToString(oModel.HEndFlag ? 1 : 0) + "," + Convert.ToString(oModel.HStopflag ? 1 : 0) + ",'" + oModel.HRemark + "','" +DateTime.Now+ "','" + oModel.HUSEORGID + "','" + oModel.HUseFlag + "','" + oModel.HMakeEmp+ "','" + oModel.HUSEORGID + "','" + 0 + "')", ref DBUtility.ClsPub.sExeReturnInfo); + "," + oModel.HLevel.ToString() + "," + Convert.ToString(oModel.HEndFlag ? 1 : 0) + "," + Convert.ToString(oModel.HStopflag ? 1 : 0) + ",'" + oModel.HRemark + "','" +DateTime.Now+ "','" + oModel.HUSEORGID + "','" + oModel.HUseFlag + "','" + oModel.HMakeEmp+ "','" + oModel.HUSEORGID + "','" +oModel.HPostID + "','" + oModel.HProcID + "')", ref DBUtility.ClsPub.sExeReturnInfo); //淇敼涓婄骇涓洪潪鏈骇浠g爜 oCn.RunProc("Update " + MvarItemKey + " set HEndflag=0 where HItemID=" + oModel.HParentID, ref DBUtility.ClsPub.sExeReturnInfo); oCn.Commit(); @@ -50,6 +50,8 @@ ",HModifyTime='" + DateTime.Now + "'" + ",HUSEORGID='" + oModel.HUSEORGID + "'" + ",HModifyEmp ='" + oModel.HMakeEmp + "'" + + ",HPostID ='" + oModel.HPostID + "'" + + ",HProcID ='" + oModel.HProcID + "'" + ",HUseFlag='" + oModel.HUseFlag + "'" + ",HStopflag=" + Convert.ToString(oModel.HStopflag ? 1 : 0) + ",HRemark= '" + oModel.HRemark + "' Where HItemID=" + sItemID, ref DBUtility.ClsPub.sExeReturnInfo); -- Gitblit v1.9.1