From 97c43d459cb96e768948a44d9845a0b439bc2adc Mon Sep 17 00:00:00 2001 From: yangle <admin@YINMOU> Date: 星期四, 29 十二月 2022 10:07:10 +0800 Subject: [PATCH] 设备点检计划 记录 设备保养记录单 --- DAL/生产管理/设备管理/ClsSb_EquipDotCheckPlanBill.cs | 6 +++--- 1 files changed, 3 insertions(+), 3 deletions(-) diff --git "a/DAL/\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_EquipDotCheckPlanBill.cs" "b/DAL/\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_EquipDotCheckPlanBill.cs" index 07b7ef0..9fc7812 100644 --- "a/DAL/\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_EquipDotCheckPlanBill.cs" +++ "b/DAL/\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_EquipDotCheckPlanBill.cs" @@ -41,7 +41,6 @@ //鏇存柊涓昏〃 oCn.RunProc("UpDate Sb_EquipDotCheckPlanBillMain set " + " HBillNo='" + omodel.HBillNo + "'" + //鍥哄畾璧嬪��=============== - ",HDate='" + omodel.HDate + "'" + ",HYear='" + omodel.HYear.ToString() + "'" + ",HPeriod='" + omodel.HPeriod.ToString() + "'" + ",HRemark='" + omodel.HRemark + "'" + @@ -51,6 +50,7 @@ ",HEquipID=" + omodel.HEquipID.ToString() + ",HBeginDate='" + omodel.HBeginDate + "'" + ",HEndDate='" + omodel.HEndDate+"'" + + ",HMouldDotCheckRuleID='" + omodel.HMouldDotCheckRuleID + "'" + ",HCycleUnit='" + omodel.HCycleUnit + "'" + ",HCheckCycle=" + omodel.HCheckCycle.ToString() + ",HExplanation='" + omodel.HExplanation+"'" + @@ -114,11 +114,11 @@ oCn.RunProc("Insert Into Sb_EquipDotCheckPlanBillMain " + "(HBillType,HBillSubType,HInterID,HBillNo,HDate,HMaker,HMakeDate" + ",HYear,HPeriod,HRemark,HEquipID" + - ",HBeginDate,HEndDate,HCheckCycle,HCycleUnit,HExplanation,HInnerBillNo" + + ",HBeginDate,HEndDate,HCheckCycle,HCycleUnit,HExplanation,HInnerBillNo,HMouldDotCheckRuleID" + ") "+ " values('" + this.BillType + "','" + this.HBillSubType + "'," +omodel.HInterID.ToString() + ",'" + omodel.HBillNo + "','" + omodel.HDate + "','" + omodel.HMaker + "',getdate()" + "," + omodel.HYear.ToString() + "," + omodel.HPeriod.ToString() + ",'" + omodel.HRemark + "'," + omodel.HEquipID.ToString() + - ",'" + omodel.HBeginDate +"','" +omodel.HEndDate + "'," + omodel.HCheckCycle.ToString() +",'"+ omodel.HCycleUnit + "','" + omodel.HExplanation + "','" + omodel.HInnerBillNo +"'" + + ",'" + omodel.HBeginDate +"','" +omodel.HEndDate + "'," + omodel.HCheckCycle.ToString() +",'"+ omodel.HCycleUnit + "','" + omodel.HExplanation + "','" + omodel.HInnerBillNo +"','" + omodel.HMouldDotCheckRuleID + "'"+ ") "); //鎻掑叆瀛愯〃 foreach (Model.ClsSb_EquipDotCheckPlanBillSub oSub in DetailColl) -- Gitblit v1.9.1