生产质量汇报单,增加HNowProcID int //当前工序字段,不良品台账增加过滤条件

zrg

2024-10-23 c2b52ca1156888dc4d63f19be5515f56eb2954dd

 DAL/生产管理/ClsSc_QualityReportBill.cs

@@ -88,7 +88,7 @@
                      ",HMaterID,HUnitID,HQty,HResult,HEmpID,HSourceID,HBadReasonID" +
                      ",HICMOInterID,HICMOEntryID,HICMOBillNo,HProcExchInterID,HProcExchEntryID,HProcExchBillNo" +
                      ",HBarCode,HReportType,HBadProcID" +
                      ",HAddr,HMaker,HMakeDate,HProcID" +
                      ",HAddr,HMaker,HMakeDate,HProcID,HNowProcID" +
                      ") values(" +
                      "" + omodel.HInterID.ToString() + "" +
                      "," + oSub.HEntryID.ToString() + "" +
@@ -122,7 +122,8 @@
                      "','" + oSub.HAddr + "'" +
                      ",'" + oSub.HMaker + "'" +
                      ",'" + oSub.HMakeDate.ToShortDateString() + "'" +
                      "," + oSub.HProcID +
                      "," + oSub.HProcID.ToString() +
                      "," + oSub.HNowProcID.ToString() +
                      ") ";
                    oCn.RunProc(subSql);
                }
@@ -222,7 +223,7 @@
                      ",HMaterID,HUnitID,HQty,HResult,HEmpID,HSourceID,HBadReasonID" +
                      ",HICMOInterID,HICMOEntryID,HICMOBillNo,HProcExchInterID,HProcExchEntryID,HProcExchBillNo" +
                      ",HBarCode,HReportType,HBadProcID" +
                      ",HAddr,HMaker,HMakeDate,HProcID" +
                      ",HAddr,HMaker,HMakeDate,HProcID,HNowProcID" +
                      ") values(" +
                      "" + omodel.HInterID.ToString() + "" +
                      "," + oSub.HEntryID.ToString() + "" +
@@ -256,7 +257,8 @@
                      ",'" + oSub.HAddr + "'" +
                      ",'" + oSub.HMaker + "'" +
                      ",'" + oSub.HMakeDate.ToShortDateString() + "'" +
                      "," + oSub.HProcID +
                      "," + oSub.HProcID.ToString() +
                      "," + oSub.HNowProcID.ToString() +
                      ") ";
                    oCn.RunProc(subSql);
                }