From cf46a6e4beb7e83af331a28065c96077fa2f1e15 Mon Sep 17 00:00:00 2001 From: zrg <z18737863051@163.com> Date: 星期三, 11 十二月 2024 09:47:08 +0800 Subject: [PATCH] 完善出厂检验单,人员履历查询增加一个物料参数 --- WebAPI/DLL/ClsSb_EquipRepairWorkBill.cs | 7 ++++++- 1 files changed, 6 insertions(+), 1 deletions(-) diff --git a/WebAPI/DLL/ClsSb_EquipRepairWorkBill.cs b/WebAPI/DLL/ClsSb_EquipRepairWorkBill.cs index 658339a..bd1cce7 100644 --- a/WebAPI/DLL/ClsSb_EquipRepairWorkBill.cs +++ b/WebAPI/DLL/ClsSb_EquipRepairWorkBill.cs @@ -75,6 +75,10 @@ ",HPlanTimes=" + omodel.HPlanTimes.ToString() + ",HDeptID=" + omodel.HDeptID.ToString() + ",HExplanation='" + omodel.HExplanation + "'" + + ",HRepairCategory='" + omodel.HRepairCategory + "'" + + ",HUrgenLevel='" + omodel.HUrgenLevel + "'" + + ",HRepairer='" + omodel.HRepairer + "'" + + ",HIsCapacityImpact='" + omodel.HIsCapacityImpact + "'" + ",HInnerBillNo='" + omodel.HInnerBillNo + "'" + ",HRepairContent='" + omodel.HRepairContent + "'" + ",HMainSourceBillType='"+ omodel.HMainSourceBillType+"'"+ @@ -194,13 +198,14 @@ ",HYear,HPeriod,HRemark,HMaker,HMakeDate" + ",HEquipID,HRepairID,HPlanTimes,HEmpID,HManagerID,HTimes" + ",HDeptID,HExplanation,HInnerBillNo,HRepairBeginDate,HRepairEndDate,HRepairContent,HCycleUnit,HMainSourceBillType,HMainSourceInterID,HMainSourceEntryID" + + ",HRepairCategory,HUrgenLevel,HRepairer,HIsCapacityImpact" + ") " + " values('" + this.BillType + "','" + this.HBillSubType + "'," +omodel.HInterID.ToString() + ",'" + omodel.HBillNo + "','" + omodel.HDate + "'" + ", " + omodel.HYear.ToString() + "," + omodel.HPeriod.ToString() + ",'" + omodel.HRemark + "','" + omodel.HMaker + "',getdate()" + ", " + omodel.HEquipID.ToString() + "," + omodel.HRepairID.ToString() + "," + omodel.HPlanTimes.ToString() + "," + omodel.HEmpID.ToString() + "," + omodel.HManagerID.ToString() + "," + omodel.HTimes.ToString() + ", " + omodel.HDeptID.ToString() + ",'" + omodel.HExplanation + "','" + omodel.HInnerBillNo + "','" + omodel.HRepairBeginDate + "','" + omodel.HRepairEndDate + "','" + omodel.HRepairContent + "','" + omodel.HCycleUnit + "','" + omodel.HMainSourceBillType+"',"+ omodel.HMainSourceInterID.ToString()+","+ omodel.HMainSourceEntryID.ToString() + - ") "); + ",'"+ omodel.HRepairCategory + "','" + omodel.HUrgenLevel + "','" + omodel.HRepairer + "','" + omodel.HIsCapacityImpact + "') "); //鎻掑叆瀛愯〃 foreach (Models.ClsSb_EquipRepairWorkBillSub oSub in DetailColl) { -- Gitblit v1.9.1