From d586211dd69b25e73593576b1a36616a2ae294b7 Mon Sep 17 00:00:00 2001 From: yangle <admin@YINMOU> Date: 星期一, 10 三月 2025 19:15:52 +0800 Subject: [PATCH] 仓库列表 增加 仓库类型字段 班次 ,,点检项目,维修项目,维修验收项目,设备档案,器具主档维护,检验项目分类,检验项目,检验值,检验仪器,异常反馈类型,工艺路线大类,维修验收项目分类,维修项目分类,保养项目分类 审核 反审核 禁用 反禁用 删除前 删除后 控制 增加页签 增加字段 增加点检项目分类字段 保养项目 维修项目 维修验收项目 增加树形图 --- WebAPI/DLL/ClsGy_Material_Ctl.cs | 9 +++++++-- 1 files changed, 7 insertions(+), 2 deletions(-) diff --git a/WebAPI/DLL/ClsGy_Material_Ctl.cs b/WebAPI/DLL/ClsGy_Material_Ctl.cs index 66d96de..c0adc2c 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 + "'" + @@ -53,7 +54,9 @@ "," + 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 +224,9 @@ ",HMoneyDec=" + oModel.HMoneyDec.ToString() + ",HTaxRate=" + oModel.HTaxRate.ToString() + ",HProfitRate=" + oModel.HProfitRate.ToString() + - ",HLotcardQty=" + oModel.HLotcardQty.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