不良评审申请单,选着工序流转卡,查询数据增加过滤条件,设备故障登记单,生产质量汇报单,异常反馈单, 取样单,增加字段保存

zrg

2024-07-24 f0b15e2fc7bdccb18d27cba0c9dfd667e36c20a6

 DAL/生产管理/ClsSc_QualityReportBill.cs

@@ -87,7 +87,7 @@
                      ",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney" +
                      ",HMaterID,HUnitID,HQty,HResult,HEmpID,HSourceID,HBadReasonID" +
                      ",HICMOInterID,HICMOEntryID,HICMOBillNo,HProcExchInterID,HProcExchEntryID,HProcExchBillNo" +
                      ",HBarCode,HReportType" +
                      ",HBarCode,HReportType,HBadProcID" +
                      ",HAddr,HMaker,HMakeDate" +
                      ") values(" +
                      "" + omodel.HInterID.ToString() + "" +
@@ -118,7 +118,8 @@
                      ",'" + oSub.HBarCode + "'" +

                      "," + oSub.HReportType.ToString() +
                      ",'" + oSub.HAddr + "'" +
                      ",'" + oSub.HBadProcID.ToString() +
                      "','" + oSub.HAddr + "'" +
                      ",'" + oSub.HMaker + "'" +
                      ",'" + oSub.HMakeDate.ToShortDateString() + "'" +
                      ") ";
@@ -219,7 +220,7 @@
                      ",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney" +
                      ",HMaterID,HUnitID,HQty,HResult,HEmpID,HSourceID,HBadReasonID" +
                      ",HICMOInterID,HICMOEntryID,HICMOBillNo,HProcExchInterID,HProcExchEntryID,HProcExchBillNo" +
                      ",HBarCode,HReportType" +
                      ",HBarCode,HReportType,HBadProcID" +
                      ",HAddr,HMaker,HMakeDate" +
                      ") values(" +
                      "" + omodel.HInterID.ToString() + "" +
@@ -250,6 +251,7 @@
                      ",'" + oSub.HBarCode + "'" +

                      "," + oSub.HReportType.ToString() +
                      "," + oSub.HBadProcID.ToString() +
                      ",'" + oSub.HAddr + "'" +
                      ",'" + oSub.HMaker + "'" +
                      ",'" + oSub.HMakeDate.ToShortDateString() + "'" +