From 5402ccf6d9f8bb3d75e837d457d74cbfc2243c3a Mon Sep 17 00:00:00 2001
From: zrg <z18737863051@163.com>
Date: 星期二, 25 三月 2025 08:44:35 +0800
Subject: [PATCH] 注释一个工序负荷分析汇总报表 没有权限的查询
---
DAL/生产管理/ClsSc_QualityReportBill.cs | 18 ++++++++++++------
1 files changed, 12 insertions(+), 6 deletions(-)
diff --git "a/DAL/\347\224\237\344\272\247\347\256\241\347\220\206/ClsSc_QualityReportBill.cs" "b/DAL/\347\224\237\344\272\247\347\256\241\347\220\206/ClsSc_QualityReportBill.cs"
index 30f3306..fd1373c 100644
--- "a/DAL/\347\224\237\344\272\247\347\256\241\347\220\206/ClsSc_QualityReportBill.cs"
+++ "b/DAL/\347\224\237\344\272\247\347\256\241\347\220\206/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);
}
--
Gitblit v1.9.1