From 0d2ca8ff5be7f7a8caf611bd200ed35282156bda Mon Sep 17 00:00:00 2001 From: yangle <admin@YINMOU> Date: 星期四, 29 十二月 2022 14:07:44 +0800 Subject: [PATCH] 维修管理 --- Model/生产管理/设备管理/ClsSb_EquipRepairCheckBillMain.cs | 1 + WebAPI/DLL/ClsSb_EquipRepairCheckBill.cs | 7 ++++--- 2 files changed, 5 insertions(+), 3 deletions(-) diff --git "a/Model/\347\224\237\344\272\247\347\256\241\347\220\206/\350\256\276\345\244\207\347\256\241\347\220\206/ClsSb_EquipRepairCheckBillMain.cs" "b/Model/\347\224\237\344\272\247\347\256\241\347\220\206/\350\256\276\345\244\207\347\256\241\347\220\206/ClsSb_EquipRepairCheckBillMain.cs" index c804663..b67a346 100644 --- "a/Model/\347\224\237\344\272\247\347\256\241\347\220\206/\350\256\276\345\244\207\347\256\241\347\220\206/ClsSb_EquipRepairCheckBillMain.cs" +++ "b/Model/\347\224\237\344\272\247\347\256\241\347\220\206/\350\256\276\345\244\207\347\256\241\347\220\206/ClsSb_EquipRepairCheckBillMain.cs" @@ -14,6 +14,7 @@ public string HCheckResult; public string HExplanation; public string HInnerBillNo; + public int HMouldRepairWorkID; } } diff --git a/WebAPI/DLL/ClsSb_EquipRepairCheckBill.cs b/WebAPI/DLL/ClsSb_EquipRepairCheckBill.cs index 97d6272..85ce358 100644 --- a/WebAPI/DLL/ClsSb_EquipRepairCheckBill.cs +++ b/WebAPI/DLL/ClsSb_EquipRepairCheckBill.cs @@ -39,7 +39,7 @@ //鏇存柊涓昏〃 oCn.RunProc("UpDate Sb_EquipRepairCheckBillMain set " + " HBillNo='" + omodel.HBillNo + "'" + //鍥哄畾璧嬪��=============== - ",HDate='" + omodel.HDate + "'" + + //",HDate='" + omodel.HDate + "'" + ",HYear='" + omodel.HYear.ToString() + "'" + ",HPeriod='" + omodel.HPeriod.ToString() + "'" + ",HRemark='" + omodel.HRemark + "'" + @@ -51,6 +51,7 @@ ",HManagerID=" + omodel.HManagerID.ToString() + ",HDeptID=" + omodel.HDeptID.ToString() + ",HCheckBeginDate='" + omodel.HCheckBeginDate + "'" + + ",HMouldRepairWorkID='" + omodel.HMouldRepairWorkID + "'" + ",HCheckResult='" + omodel.HCheckResult + "'" + ",HExplanation='" + omodel.HExplanation + "'" + ",HInnerBillNo='" + omodel.HInnerBillNo + "'" + @@ -98,12 +99,12 @@ "(HBillType,HBillSubType,HInterID,HBillNo,HDate" + ",HYear,HPeriod,HRemark,HMaker,HMakeDate" + ",HEquipID,HExplanation,HInnerBillNo,HEmpID" + - ",HManagerID,HDeptID,HCheckResult,HCheckBeginDate" + + ",HManagerID,HDeptID,HCheckResult,HCheckBeginDate,HMouldRepairWorkID" + ") " + " 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.HExplanation + "','" + omodel.HInnerBillNo + "'," + omodel.HEmpID.ToString() + - "," + omodel.HManagerID.ToString() + "," + omodel.HDeptID.ToString() + ",'" + omodel.HCheckResult + "','" + omodel.HCheckBeginDate + "'" + + "," + omodel.HManagerID.ToString() + "," + omodel.HDeptID.ToString() + ",'" + omodel.HCheckResult + "','" + omodel.HCheckBeginDate + "'," + omodel.HMouldRepairWorkID + ") "); ////鎻掑叆瀛愯〃 foreach (Model.ClsSb_EquipRepairCheckBillSub oSub in DetailColl) -- Gitblit v1.9.1