From 7dc6e90fbead3ff0c42ccb0836fd3ce147c1ef94 Mon Sep 17 00:00:00 2001 From: wtt <1985833171@qq.com> Date: 星期一, 12 八月 2024 15:34:39 +0800 Subject: [PATCH] Merge branch 'master' of http://101.37.171.70:10101/r/MES-WEB-API --- DAL/生产管理/设备管理/ClsSB_EquipICMOTechParamBill.cs | 9 +++++---- 1 files changed, 5 insertions(+), 4 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_EquipICMOTechParamBill.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_EquipICMOTechParamBill.cs" index 96d3642..604e2c9 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_EquipICMOTechParamBill.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_EquipICMOTechParamBill.cs" @@ -130,16 +130,17 @@ DeleteBillSub(lngBillKey); //鎻掑叆瀛愯〃 omodel.HInterID = lngBillKey; + //鎻掑叆瀛愯〃 foreach (Model.ClsSB_EquipICMOTechParamBillSub oSub in DetailColl) { oCn.RunProc("Insert into SB_EquipICMOTechParamBillSub " + " (HInterID,HEntryID,HRemark,HRelationQty,HRelationMoney" + ",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HBillNo_bak" + - ",HTechParamID,HTechParamUnitID,HVaule,HStd,HMax,HMin,HResult" + + ",HTechParamID,HTechParamUnitID,HVaule,HStd,HMax,HMin,HResult,HTechParamIDStd,HResultStd,HTechParamClassID,HSNO" + ") values(" + omodel.HInterID.ToString() + "," + oSub.HEntryID.ToString() + ",'" + oSub.HRemark + "'," + oSub.HRelationQty.ToString() + "," + oSub.HRelationMoney.ToString() + "," + oSub.HSourceInterID.ToString() + "," + oSub.HSourceEntryID.ToString() + ",'" + oSub.HSourceBillNo + "','" + oSub.HSourceBillType + "','" + omodel.HBillNo + "'" + - "," + oSub.HTechParamID.ToString() + "," + oSub.HTechParamUnitID.ToString() + ",'" + oSub.HVaule + "','" + oSub.HStd + "','" + oSub.HMax + "','" + oSub.HMin + "','" + oSub.HResult + "'" + + "," + oSub.HTechParamID.ToString() + "," + oSub.HTechParamUnitID.ToString() + ",'" + oSub.HVaule + "','" + oSub.HStd + "','" + oSub.HMax + "','" + oSub.HMin + "','" + oSub.HResult + "','" + oSub.HTechParamIDStd + "','" + oSub.HResultStd + "','" + oSub.HTechParamClassID + "','" + oSub.HSNO + "'" + ") "); } //淇濆瓨鍚庢帶鍒� @@ -199,11 +200,11 @@ oCn.RunProc("Insert into SB_EquipICMOTechParamBillSub " + " (HInterID,HEntryID,HRemark,HRelationQty,HRelationMoney" + ",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HBillNo_bak" + - ",HTechParamID,HTechParamUnitID,HVaule,HStd,HMax,HMin,HResult" + + ",HTechParamID,HTechParamUnitID,HVaule,HStd,HMax,HMin,HResult,HTechParamIDStd,HResultStd,HTechParamClassID,HSNO" + ") values(" + omodel.HInterID.ToString() + "," + oSub.HEntryID.ToString() + ",'" + oSub.HRemark + "'," + oSub.HRelationQty.ToString() + "," + oSub.HRelationMoney.ToString() + "," + oSub.HSourceInterID.ToString() + "," + oSub.HSourceEntryID.ToString() + ",'" + oSub.HSourceBillNo + "','" + oSub.HSourceBillType + "','" + omodel.HBillNo + "'" + - "," + oSub.HTechParamID.ToString() + "," + oSub.HTechParamUnitID.ToString() + ",'" + oSub.HVaule + "','" + oSub.HStd + "','" + oSub.HMax + "','" + oSub.HMin + "','" + oSub.HResult + "'" + + "," + oSub.HTechParamID.ToString() + "," + oSub.HTechParamUnitID.ToString() + ",'" + oSub.HVaule + "','" + oSub.HStd + "','" + oSub.HMax + "','" + oSub.HMin + "','" + oSub.HResult + "','" + oSub.HTechParamIDStd + "','" + oSub.HResultStd + "','" + oSub.HTechParamClassID + "','" + oSub.HSNO + "'" + ") "); } //淇濆瓨鍚庢帶鍒� -- Gitblit v1.9.1