From b371b604a464e7249634bbdb45cda85dd5bd1f3a Mon Sep 17 00:00:00 2001 From: wtt <1985833171@qq.com> Date: 星期一, 21 四月 2025 15:52:37 +0800 Subject: [PATCH] 1 --- WebAPI/DLL/ClsGy_Source_Ctl.cs | 10 +++++++--- 1 files changed, 7 insertions(+), 3 deletions(-) diff --git a/WebAPI/DLL/ClsGy_Source_Ctl.cs b/WebAPI/DLL/ClsGy_Source_Ctl.cs index 42d5871..34911b4 100644 --- a/WebAPI/DLL/ClsGy_Source_Ctl.cs +++ b/WebAPI/DLL/ClsGy_Source_Ctl.cs @@ -37,13 +37,14 @@ ",HType,HRelationID,HCenterID,HEquipFileID_K3,HDeptID" + ",HLevel,HEndFlag,HStopflag,HUseFlag,HRemark,HProcID,HOverTimes " + ",HWorkTimes,HMaxWorkTimes,HMinAdd,HClassCount,HGroupID,HGroupK3ID," + - "HUSEORGID,HCREATEORGID,HMacAddr,HEmpID,HMakeEmp,HMakeTime)" + + "HUSEORGID,HCREATEORGID,HMacAddr,HEmpID,HMakeEmp,HMakeTime,HCubicleQty,HProdLinePeopleNum)" + " Values('" + oModel.HNumber + "','" + oModel.HName + "','" + oModel.HHelpCode + "','" + oModel.HShortNumber + "'," + oModel.HParentID.ToString() + ",'" + oModel.HType + "'," + oModel.HRelationID.ToString() + "," + oModel.HCenterID.ToString() + "," + oModel.HEquipFileID_K3.ToString() + "," + oModel.HDeptID.ToString() + "," + oModel.HLevel.ToString() + "," + Convert.ToString(oModel.HEndFlag ? 1 : 0) + "," + Convert.ToString(oModel.HStopflag ? 1 : 0) + ",'" + oModel.HUseFlag + "','" + oModel.HRemark + "'," + oModel.HProcID + "," + oModel.HOverTimes + "," + oModel.HWorkTimes + "," + oModel.HMaxWorkTimes + "," + oModel.HMinAdd + "," + oModel.HClassCount + "," + oModel.HGroupID.ToString() + "," + oModel.HGroupK3ID.ToString() + "," + - "" + oModel.HUSEORGID + "," + oModel.HCREATEORGID + ",'" + oModel.HMacAddr + "'," + oModel.HEmpID + ",'" + oModel.HMakeEmp + "',getdate())", ref DBUtility.ClsPub.sExeReturnInfo); + "" + oModel.HUSEORGID + "," + oModel.HCREATEORGID + ",'" + oModel.HMacAddr + "'," + oModel.HEmpID + ",'" + oModel.HMakeEmp + "',getdate()," + oModel.HCubicleQty + "," + oModel.HProdLinePeopleNum + ")", ref DBUtility.ClsPub.sExeReturnInfo); + //淇敼涓婄骇涓洪潪鏈骇浠g爜 oCn.RunProc("Update " + MvarItemKey + " set HEndflag=0 where HItemID=" + oModel.HParentID, ref DBUtility.ClsPub.sExeReturnInfo); @@ -124,8 +125,11 @@ ",HUSEORGID='" + oModel.HUSEORGID + "'" + ",HCREATEORGID='" + oModel.HCREATEORGID + "'" + ",HModifyEmp ='" + oModel.HMakeEmp + "'" + - ",HModifyTime=getdate()" + + ",HModifyTime=getdate()" + + ",HCubicleQty=" + oModel.HCubicleQty + + ",HProdLinePeopleNum=" + oModel.HProdLinePeopleNum + ",HRemark= '" + oModel.HRemark + "' Where HItemID=" + sItemID, ref DBUtility.ClsPub.sExeReturnInfo); + //淇敼瀛愰」鐩唬鐮� oCn.RunProc("exec h_p_Gy_UpdateNumber '" + MvarItemKey + "','" + oModel.HNumber + ".','" + this.HOldNumber + ".'", ref DBUtility.ClsPub.sExeReturnInfo); //灏嗕笂绾� 涓洪潪鏈骇 -- Gitblit v1.9.1