From 8854c0d9ed2542a2a4b7f0eb5d69a9375a0c9ea6 Mon Sep 17 00:00:00 2001 From: wtt <1985833171@qq.com> Date: 星期三, 25 九月 2024 16:22:02 +0800 Subject: [PATCH] 工种导入 --- WebAPI/DLL/ClsGy_Material_Ctl.cs | 6 +++++- 1 files changed, 5 insertions(+), 1 deletions(-) diff --git a/WebAPI/DLL/ClsGy_Material_Ctl.cs b/WebAPI/DLL/ClsGy_Material_Ctl.cs index 35045bb..c0adc2c 100644 --- a/WebAPI/DLL/ClsGy_Material_Ctl.cs +++ b/WebAPI/DLL/ClsGy_Material_Ctl.cs @@ -28,7 +28,9 @@ ",HSALEUNITID,HSALEPRICEUNITID,HBASEUNITID,HSTOREUNITID,HCHECKINCOMING,HCHECKPRODUCT,HPERUNITSTANDHOUR" + ",HSTDLABORPREPARETIME,HSTDMACHINEPREPARETIME,HWidth,HWeight,HColorRemark,HQCSchemeID_Fst,HQCSchemeID_Proc,HQCSchemeID_Patrol" + ",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,HProjectBillMainID,HDivisionID" + + ",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 + "'" + @@ -51,6 +53,7 @@ "," + oModel.HMoneyDec + "," + oModel.HTaxRate + "," + oModel.HProfitRate + + "," + oModel.HLotcardQty + ",'" + oModel.HProjectBillMainID + "','" + oModel.HDivisionID + "')", ref DBUtility.ClsPub.sExeReturnInfo); @@ -223,6 +226,7 @@ ",HProfitRate=" + oModel.HProfitRate.ToString() + ",HProjectBillMainID='" + oModel.HProjectBillMainID + "'" + ",HDivisionID='" + oModel.HDivisionID + "'" + + ",HLotcardQty='" + oModel.HLotcardQty + "'" + " 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