1

zrg

2025-10-17 82de67c48acaf472a6f8bb8b53f3f4feec9f5e54

 DAL/生产管理/ClsSc_QualityReportBill.cs

@@ -85,10 +85,10 @@
                    string subSql = "Insert into Sc_QualityReportBillSub " +
                      " (HInterID,HEntryID,HBillNo_bak,HRemark" +
                      ",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney" +
                      ",HMaterID,HUnitID,HQty,HResult,HEmpID,HSourceID,HBadReasonID" +
                      ",HMaterID,HUnitID,HQty,HResult,HEmpID,HSourceID,HBadReasonID,HBadPhenomenaID" +
                      ",HICMOInterID,HICMOEntryID,HICMOBillNo,HProcExchInterID,HProcExchEntryID,HProcExchBillNo" +
                      ",HBarCode,HReportType,HBadProcID" +
                      ",HAddr,HMaker,HMakeDate" +
                      ",HAddr,HMaker,HMakeDate,HProcID,HNowProcID" +
                      ") values(" +
                      "" + omodel.HInterID.ToString() + "" +
                      "," + oSub.HEntryID.ToString() + "" +
@@ -108,6 +108,7 @@
                      "," + oSub.HEmpID.ToString() + "" +
                      "," + oSub.HSourceID.ToString() + "" +
                      "," + oSub.HBadReasonID.ToString() + "" +
                      "," + oSub.HBadPhenomenaID.ToString() + "" +

                      "," + oSub.HICMOInterID.ToString() + "" +
                      "," + oSub.HICMOEntryID.ToString() + "" +
@@ -122,6 +123,8 @@
                      "','" + oSub.HAddr + "'" +
                      ",'" + oSub.HMaker + "'" +
                      ",'" + oSub.HMakeDate.ToShortDateString() + "'" +
                      "," + oSub.HProcID.ToString() +
                      "," + oSub.HNowProcID.ToString() +
                      ") ";
                    oCn.RunProc(subSql);
                }
@@ -189,7 +192,7 @@
                    ") " +
                    " values(" +
                    "'" + this.BillType + "'" +
                    ",'" + this.HBillSubType + "'" +
                    ",'" + omodel.HBillSubType + "'" +
                    "," + omodel.HInterID + "" +
                    ",'" + omodel.HBillNo + "'" +
                    ",'" + omodel.HDate + "'" +
@@ -218,10 +221,10 @@
                    string subSql = "Insert into Sc_QualityReportBillSub " +
                      " (HInterID,HEntryID,HBillNo_bak,HRemark" +
                      ",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney" +
                      ",HMaterID,HUnitID,HQty,HResult,HEmpID,HSourceID,HBadReasonID" +
                      ",HMaterID,HUnitID,HQty,HResult,HEmpID,HSourceID,HBadReasonID,HBadPhenomenaID" +
                      ",HICMOInterID,HICMOEntryID,HICMOBillNo,HProcExchInterID,HProcExchEntryID,HProcExchBillNo" +
                      ",HBarCode,HReportType,HBadProcID" +
                      ",HAddr,HMaker,HMakeDate" +
                      ",HAddr,HMaker,HMakeDate,HProcID,HNowProcID" +
                      ") values(" +
                      "" + omodel.HInterID.ToString() + "" +
                      "," + oSub.HEntryID.ToString() + "" +
@@ -241,7 +244,8 @@
                      "," + oSub.HEmpID.ToString() + "" +
                      "," + oSub.HSourceID.ToString() + "" +
                      "," + oSub.HBadReasonID.ToString() + "" +
                      
                      "," + oSub.HBadPhenomenaID.ToString() + "" +

                      "," + oSub.HICMOInterID.ToString() + "" +
                      "," + oSub.HICMOEntryID.ToString() + "" +
                      ",'" + oSub.HICMOBillNo + "'" +
@@ -255,6 +259,8 @@
                      ",'" + oSub.HAddr + "'" +
                      ",'" + oSub.HMaker + "'" +
                      ",'" + oSub.HMakeDate.ToShortDateString() + "'" +
                      "," + oSub.HProcID.ToString() +
                      "," + oSub.HNowProcID.ToString() +
                      ") ";
                    oCn.RunProc(subSql);
                }