From e588f08454276e936751de2bac526231c3d9e381 Mon Sep 17 00:00:00 2001 From: yangle <admin@YINMOU> Date: 星期二, 10 九月 2024 09:34:31 +0800 Subject: [PATCH] 1 --- WebAPI/DLL/ClsGy_Material_Ctl.cs | 9 ++++++--- 1 files changed, 6 insertions(+), 3 deletions(-) diff --git a/WebAPI/DLL/ClsGy_Material_Ctl.cs b/WebAPI/DLL/ClsGy_Material_Ctl.cs index 66d96de..850658e 100644 --- a/WebAPI/DLL/ClsGy_Material_Ctl.cs +++ b/WebAPI/DLL/ClsGy_Material_Ctl.cs @@ -30,6 +30,7 @@ ",HMaterRuleType,HColorNo,HPieceMaxQty,HCommonUseFlag,HAvgStockPrice,HFootPrice,HTaxCost,HNoTaxCost,HOnceRightRate" + ",HHeight_M,HInches_M,HAl1Long_M,HDensity_M,HTela_M,HUnderTela_M,HSizing_M,HQtyDec,HPriceDec,HMoneyDec,HTaxRate,HProfitRate" + ",HLotcardQty" + + ",HProjectBillMainID,HDivisionID" + ") " + " 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 + "'" + @@ -52,8 +53,9 @@ "," + oModel.HMoneyDec + "," + oModel.HTaxRate + "," + oModel.HProfitRate + - "," + oModel.HLotcardQty + - ")", ref DBUtility.ClsPub.sExeReturnInfo); + ",'" + oModel.HProjectBillMainID + + "','" + oModel.HDivisionID + + "')", ref DBUtility.ClsPub.sExeReturnInfo); //淇敼涓婄骇涓洪潪鏈骇浠g爜 oCn.RunProc("Update " + MvarItemKey + " set HEndflag=0 where HItemID=" + oModel.HParentID, ref DBUtility.ClsPub.sExeReturnInfo); oCn.Commit(); @@ -221,7 +223,8 @@ ",HMoneyDec=" + oModel.HMoneyDec.ToString() + ",HTaxRate=" + oModel.HTaxRate.ToString() + ",HProfitRate=" + oModel.HProfitRate.ToString() + - ",HLotcardQty=" + oModel.HLotcardQty.ToString() + + ",HProjectBillMainID='" + oModel.HProjectBillMainID + "'" + + ",HDivisionID='" + oModel.HDivisionID + "'" + " 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