不良采集批量汇报方法,改成只插入一条,不进行循环插入

zrg

2024-07-02 4d25e6e0201601c001139328a1521392e5a12e9f

 WebAPI/Controllers/生产管理/质量汇报单/Sc_QualityReportBillController.cs

@@ -773,56 +773,51 @@
                int i = 0;
                foreach (Model.ClsSc_QualityReportBillSub oSub in ls)
                {
                  
                   
                    oSub.HMakeDate = DateTime.Now;
                    int qty = Convert.ToInt32(oSub.HQty);
                    for (int j = 0; j < qty; j++)
                    {
                        i++;
                        oSub.HEntryID = i;
                        string subSql = "Insert into Sc_QualityReportBillSub " +
                     " (HInterID,HEntryID,HBillNo_bak,HRemark" +
                     ",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney" +
                     ",HMaterID,HUnitID,HQty,HResult,HEmpID,HSourceID,HBadReasonID" +
                     ",HICMOInterID,HICMOEntryID,HICMOBillNo,HProcExchInterID,HProcExchEntryID,HProcExchBillNo" +
                     ",HBarCode,HReportType" +
                     ",HAddr,HMaker,HMakeDate" +
                     ") values(" +
                     "" + oSub.HInterID.ToString() + "" +
                     "," + oSub.HEntryID.ToString() + "" +
                     ",'" + oSub.HBillNo_bak + "'" +
                     ",'" + oSub.HRemark + "'" +
                     "," + oSub.HSourceInterID.ToString() + "" +
                     "," + oSub.HSourceEntryID.ToString() + "" +
                     ",'" + oSub.HSourceBillNo + "'" +
                     ",'" + oSub.HSourceBillType + "'" +
                     "," + oSub.HRelationQty.ToString() + "" +
                     "," + oSub.HRelationMoney.ToString() +

                     "," + oSub.HMaterID.ToString() + "" +
                     "," + oSub.HUnitID.ToString() + "" +
                     ",'" + 1 +
                     "','" + oSub.HResult + "'" +
                     "," + oSub.HEmpID.ToString() + "" +
                     "," + oSub.HSourceID.ToString() + "" +
                     "," + oSub.HBadReasonID.ToString() + "" +
                    i++;
                    oSub.HMakeDate = DateTime.Now;                   
                    oSub.HEntryID = i;
                    string subSql = "Insert into Sc_QualityReportBillSub " +
                 " (HInterID,HEntryID,HBillNo_bak,HRemark" +
                 ",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney" +
                 ",HMaterID,HUnitID,HQty,HResult,HEmpID,HSourceID,HBadReasonID" +
                 ",HICMOInterID,HICMOEntryID,HICMOBillNo,HProcExchInterID,HProcExchEntryID,HProcExchBillNo" +
                 ",HBarCode,HReportType" +
                 ",HAddr,HMaker,HMakeDate" +
                 ") values(" +
                 "" + oSub.HInterID.ToString() + "" +
                 "," + oSub.HEntryID.ToString() + "" +
                 ",'" + oSub.HBillNo_bak + "'" +
                 ",'" + oSub.HRemark + "'" +
                 "," + oSub.HSourceInterID.ToString() + "" +
                 "," + oSub.HSourceEntryID.ToString() + "" +
                 ",'" + oSub.HSourceBillNo + "'" +
                 ",'" + oSub.HSourceBillType + "'" +
                 "," + oSub.HRelationQty.ToString() + "" +
                 "," + oSub.HRelationMoney.ToString() +

                     "," + oSub.HICMOInterID.ToString() + "" +
                     "," + oSub.HICMOEntryID.ToString() + "" +
                     ",'" + oSub.HICMOBillNo + "'" +
                     "," + oSub.HProcExchInterID + "" +
                     "," + oSub.HProcExchEntryID + "" +
                     ",'" + oSub.HProcExchBillNo + "'" +
                     ",'" + oSub.HBarCode + "'" +
                 "," + oSub.HMaterID.ToString() + "" +
                 "," + oSub.HUnitID.ToString() + "" +
                 ",'" + oSub.HQty.ToString() +
                 "','" + oSub.HResult + "'" +
                 "," + oSub.HEmpID.ToString() + "" +
                 "," + oSub.HSourceID.ToString() + "" +
                 "," + oSub.HBadReasonID.ToString() + "" +

                     ",'" + 3 +
                     "','" + oSub.HAddr + "'" +
                     ",'" + msg4 + "'" +
                     ",'" + oSub.HMakeDate.ToShortDateString() + "'" +
                     ") ";
                        oCN.RunProc(subSql);
                    }
                 "," + oSub.HICMOInterID.ToString() + "" +
                 "," + oSub.HICMOEntryID.ToString() + "" +
                 ",'" + oSub.HICMOBillNo + "'" +
                 "," + oSub.HProcExchInterID + "" +
                 "," + oSub.HProcExchEntryID + "" +
                 ",'" + oSub.HProcExchBillNo + "'" +
                 ",'" + oSub.HBarCode + "'" +

                 ",'" + 3 +
                 "','" + oSub.HAddr + "'" +
                 ",'" + msg4 + "'" +
                 ",'" + oSub.HMakeDate.ToShortDateString() + "'" +
                 ") ";
                    oCN.RunProc(subSql);

                }
                objJsonResult.code = "0";