优化拆分条码

zrg

2026-02-02 2ee2d1c8c05fce44e3e01ea8bcf8c81fab88afb0

 DAL/Öʼì¹ÜÀí/ClsQC_POStockInCheckBill.cs

@@ -84,6 +84,7 @@
                ",HErrTreatment='" + omodel.HErrTreatment + "'" +
                ",HBatchNo='" + omodel.HBatchNo + "'" +
                ",HRemarkSN='" + omodel.HRemarkSN + "'" +
                ",HCheckQty=" + omodel.HCheckQty +
                " where HInterID=" + lngBillKey.ToString());
                //删除关联
                DeleteRelation(ref sReturn, lngBillKey);
@@ -102,7 +103,7 @@
                      ",HMax,HMin,HAvg,HSampleSchemeID,HSampleQty,HSampleDamageQty,HAcceptQty" +
                      ",HRejectQty,HSampleUnRightQty,HStatus,HUnitID,HInspectVal,HTargetVal" +
                      ",HUpLimit,HDownLimit,HUpOffSet,HDownOffSet,HKeyInspect,HAnalysisMethod,HInspectInstruMentID,HInspectResult" +
                       ",HCompareSymbol, HQualityStdID,HInspectMethodID,HInspectBasisID" +
                       ",HCompareSymbol, HQualityStdID,HInspectMethodID,HInspectBasisID, HInspectValQ" +
                      ") values("
                      + omodel.HInterID.ToString() + ",'" + oSub.HBillNo_bak + "'," + oSub.HEntryID.ToString() + ",'" + oSub.HCloseMan + "'" +
                      ",getdate()," + Convert.ToString(oSub.HCloseType ? 1 : 0) + ",'" + oSub.HRemark + "'," + oSub.HSourceInterID.ToString() +
@@ -112,7 +113,7 @@
                      "," + oSub.HSampleDamageQty + "," + oSub.HAcceptQty + "," + oSub.HRejectQty + "," + oSub.HSampleUnRightQty + ",'" + oSub.HStatus +
                      "'," + oSub.HUnitID + ",'" + oSub.HInspectVal + "','" + oSub.HTargetVal + "','" + oSub.HUpLimit + "','" + oSub.HDownLimit +
                      "','" + oSub.HUpOffSet + "','" + oSub.HDownOffSet + "'," + oSub.HKeyInspect + ",'" + oSub.HAnalysisMethod + "'," + oSub.HInspectInstruMentID + ",'" + oSub.HInspectResult + "'" +
                      $@",'{oSub.HCompareSymbol}',{oSub.HQualityStdID},{oSub.HInspectMethodID},{oSub.HInspectBasisID}" +
                      $@",'{oSub.HCompareSymbol}',{oSub.HQualityStdID},{oSub.HInspectMethodID},{oSub.HInspectBasisID}, {oSub.HInspectValQ}" +
                      ") ");
                }
                //foreach (Model.ClsQC_POStockInCheckBillSub_Item oSub2 in DetailColl1)
@@ -142,6 +143,7 @@
                //        return false;
                //    }
                //}
                AddBadReason(ref sReturn);
                sReturn = "修改单据成功！";
                oCn.Commit();
                return true;
@@ -169,7 +171,7 @@
                ",HSourceID,HICMOInterID,HICMOBillNo,HICMOQty,HProcExchInterID,HProcExchEntryID" +
                ",HProcExchBillNo,HProcExchQty,HMaterID,HFirstCheckEmp,HLastResult" +
                ",HMainSourceInterID,HMainSourceEntryID,HMainSourceBillNo,HMainSourceBillType,HICMOEntryID,HQCSchemeID,HShiftsID,HErrTreatment,HBatchNo" +
                ",HTakeSampleCheckBillID,HTakeSampleCheckBillNo,HProcID, HRemarkSN" +
                ",HTakeSampleCheckBillID,HTakeSampleCheckBillNo,HProcID, HRemarkSN, HCheckQty" +
                ") " +
                " values('" + this.BillType + "','" + this.HBillSubType + "'," + omodel.HInterID.ToString() + ",'" + omodel.HBillNo + "'," + omodel.HBillStatus.ToString() + ",'" + omodel.HDate + "','" + omodel.HMaker + "',getdate()" +
                "," + omodel.HYear.ToString() + "," + omodel.HPeriod.ToString() + ",'" + omodel.HRemark + "'" +
@@ -177,7 +179,7 @@
                ",'" + omodel.HProcExchBillNo + "'," + omodel.HProcExchQty.ToString() + "," + omodel.HMaterID.ToString() + "," + omodel.HFirstCheckEmp.ToString() + ", " + DBUtility.ClsPub.BoolToString(omodel.HLastResult) +
                "," + omodel.HMainSourceInterID + "," + omodel.HMainSourceEntryID + ",'" + omodel.HMainSourceBillNo + "','" + omodel.HMainSourceBillType + "'," + omodel.HICMOEntryID + "," + omodel.HQCSchemeID + "," + omodel.HShiftsID + ",'" + omodel.HErrTreatment + "','" + omodel.HBatchNo + "'" +
                "," + omodel.HTakeSampleCheckBillID + ",'" + omodel.HTakeSampleCheckBillNo + "','" + omodel.HProcID + "'" +
                ",'" + omodel.HRemarkSN+ "') ");
                ",'" + omodel.HRemarkSN+ "',"+ omodel.HCheckQty +") ");
                //插入子表
                foreach (Model.ClsQC_POStockInCheckBillSub oSub in DetailColl)
                {
@@ -189,7 +191,7 @@
                      ",HMax,HMin,HAvg,HSampleSchemeID,HSampleQty,HSampleDamageQty,HAcceptQty" +
                      ",HRejectQty,HSampleUnRightQty,HStatus,HUnitID,HInspectVal,HTargetVal" +
                      ",HUpLimit,HDownLimit,HUpOffSet,HDownOffSet,HKeyInspect,HAnalysisMethod,HInspectInstruMentID,HInspectResult" +
                       ",HCompareSymbol, HQualityStdID,HInspectMethodID,HInspectBasisID" +
                       ",HCompareSymbol, HQualityStdID,HInspectMethodID,HInspectBasisID, HInspectValQ" +
                      ") values("
                      + omodel.HInterID.ToString() + ",'" + oSub.HBillNo_bak + "'," + oSub.HEntryID.ToString() + ",'" + oSub.HCloseMan + "'" +
                      ",getdate()," + Convert.ToString(oSub.HCloseType ? 1 : 0) + ",'" + oSub.HRemark + "'," + oSub.HSourceInterID.ToString() +
@@ -199,7 +201,7 @@
                      "," + oSub.HSampleDamageQty + "," + oSub.HAcceptQty + "," + oSub.HRejectQty + "," + oSub.HSampleUnRightQty + ",'" + oSub.HStatus +
                      "'," + oSub.HUnitID + ",'" + oSub.HInspectVal + "','" + oSub.HTargetVal + "','" + oSub.HUpLimit + "','" + oSub.HDownLimit +
                      "','" + oSub.HUpOffSet + "','" + oSub.HDownOffSet + "'," + oSub.HKeyInspect + ",'" + oSub.HAnalysisMethod + "'," + oSub.HInspectInstruMentID + ",'" + oSub.HInspectResult + "'" +
                      $@",'{oSub.HCompareSymbol}',{oSub.HQualityStdID},{oSub.HInspectMethodID},{oSub.HInspectBasisID}"+
                      $@",'{oSub.HCompareSymbol}',{oSub.HQualityStdID},{oSub.HInspectMethodID},{oSub.HInspectBasisID}, {oSub.HInspectValQ}" +
                      ") ");
                }
                //foreach (Model.ClsQC_POStockInCheckBillSub_Item oSub2 in DetailColl1)
@@ -468,9 +470,11 @@
        {
            try
            {
                oCn.BeginTran();

                oCn.RunProc("delete from QC_POStockInCheckBillSub_BadReason where HInterID = " + HInterID + " and HEntryID = " + HEntryID);
                if(DetailCol1_BadReason.Count == 0)
                {
                    return true;
                }
                oCn.RunProc("delete from QC_POStockInCheckBillSub_BadReason where HInterID = " + DetailCol1_BadReason[0].HInterID);

                //插入子表
                foreach (Model.ClsQC_POStockInCheckBillSub_BadReason reason in DetailCol1_BadReason)
@@ -479,18 +483,16 @@
                      " (HInterID,HEntryID,HBillNo_bak,HCloseMan" +
                      ",HRemark,HBadReasonID,HQty,HCheckTime" +
                      ") values("
                      + reason.HInterID + "," + reason.HEntryID + "," + reason.HBillNo_bak + ",''," +
                      reason.HRemark + "," + reason.HBadReasonID + ",'" + reason.HQty + "',getdate()" + 
                      + reason.HInterID + "," + reason.HEntryID + ",'" + reason.HBillNo_bak + "','','" +
                      reason.HRemark + "'," + reason.HBadReasonID + ",'" + reason.HQty + "',getdate()" + 
                      ") ");
                }
                sReturn = "新增检验值成功！";
                oCn.Commit();
                sReturn = "新增不良原因成功！";
                return true;
            }
            catch (Exception e)
            {
                sReturn = e.Message;
                oCn.RollBack();
                throw (e);
            }
        }