From 93ac95d0202fc17fbb6c429c4d4ffab8593e2428 Mon Sep 17 00:00:00 2001
From: zrg <z1873@LAPTOP-EAVL132E>
Date: 星期二, 27 一月 2026 13:08:24 +0800
Subject: [PATCH] 修复车员工签到单app扫码功能
---
DAL/车间管理/ClsSc_EmployeeSignInNoteBill.cs | 16 +++++++++-------
1 files changed, 9 insertions(+), 7 deletions(-)
diff --git "a/DAL/\350\275\246\351\227\264\347\256\241\347\220\206/ClsSc_EmployeeSignInNoteBill.cs" "b/DAL/\350\275\246\351\227\264\347\256\241\347\220\206/ClsSc_EmployeeSignInNoteBill.cs"
index 32d2976..026a219 100644
--- "a/DAL/\350\275\246\351\227\264\347\256\241\347\220\206/ClsSc_EmployeeSignInNoteBill.cs"
+++ "b/DAL/\350\275\246\351\227\264\347\256\241\347\220\206/ClsSc_EmployeeSignInNoteBill.cs"
@@ -42,7 +42,7 @@
//淇濆瓨鍓嶆帶鍒�=========================================
string HBillNote = "";
- DataSet ds = oCn.RunProcReturn("Exec h_p_Gy_QCVerificationBill_BeforeSaveCtrl " + omodel.HInterID.ToString() + ", '" + omodel.HBillNo + "','" + HBillNote + "',2 ", "h_p_Gy_QCVerificationBill_BeforeSaveCtrl");
+ DataSet ds = oCn.RunProcReturn("Exec Sc_EmployeeSignInNoteBill_BeforeSaveCtrl " + omodel.HInterID.ToString() + ", '" + omodel.HBillNo + "','" + HBillNote + "',2 ", "Sc_EmployeeSignInNoteBill_BeforeSaveCtrl");
if (ds == null)
{
sReturn = "淇濆瓨鍓嶅垽鏂け璐ワ紒";
@@ -77,7 +77,9 @@
",HGroupID =" + omodel.HGroupID.ToString()+
",HShiftsID =" + omodel.HShiftsID.ToString()+
",HSignInReason ='" + omodel.HSignInReason.ToString()+"'"+
+ ",HSignRemark ='" + omodel.HSignRemark.ToString()+"'"+
",HEmpID ='" + omodel.HEmpID.ToString()+ "'" +
+ ",HMouldRelQty ='" + omodel.HMouldRelQty.ToString() + "'" +
" where HInterID=" + lngBillKey.ToString());
//鍒犻櫎鍏宠仈
DeleteRelation(ref sReturn, lngBillKey);
@@ -96,7 +98,7 @@
}
//=========================淇濆瓨鍚庢帶鍒�
- DataSet ds2 = oCn.RunProcReturn("Exec h_p_Gy_QCVerificationBill_AfterSaveCtrl " + omodel.HInterID.ToString() + ", '" + omodel.HBillNo + "',2 ", "h_p_Gy_QCVerificationBill_AfterSaveCtrl");
+ DataSet ds2 = oCn.RunProcReturn("Exec Sc_EmployeeSignInNoteBill_AfterSaveCtrl " + omodel.HInterID.ToString() + ", '" + omodel.HBillNo + "',2 ", "Sc_EmployeeSignInNoteBill_AfterSaveCtrl");
if (ds2 == null)
@@ -134,7 +136,7 @@
//淇濆瓨鍓嶆帶鍒�=========================================
string HBillNote = "";
- DataSet ds = oCn.RunProcReturn("Exec h_p_Gy_QCVerificationBill_BeforeSaveCtrl " + omodel.HInterID.ToString() + ", '" + omodel.HBillNo + "','" + HBillNote + "',1 ", "h_p_Gy_QCVerificationBill_BeforeSaveCtrl");
+ DataSet ds = oCn.RunProcReturn("Exec Sc_EmployeeSignInNoteBill_BeforeSaveCtrl " + omodel.HInterID.ToString() + ", '" + omodel.HBillNo + "','" + HBillNote + "',1 ", "Sc_EmployeeSignInNoteBill_BeforeSaveCtrl");
if (ds == null)
{
sReturn = "淇濆瓨鍓嶅垽鏂け璐ワ紒";
@@ -146,7 +148,7 @@
return false;
}
//=========================================================
-
+ // (omodel.HCheckEmp.ToString() ?? "0") + "," +
oCn.BeginTran();
oCn.RunProc("Insert Into Sc_EmployeeSignInNoteBillMain " +
@@ -154,7 +156,7 @@
",HYear,HPeriod,HRemark,HMaker,HMakeDate," +
"HMainSourceBillType,HMainSourceBillNo,HMainSourceInterID,HMainSourceEntryID," +
"HEquipID,HMouldID,HSourceID,HProcID,HGroupID,HShiftsID,HSignInReason,HSignRemark," +
- "HChecker,HDeptID,HEmpID,HOrgID) " +
+ "HDeptID,HEmpID,HMouldRelQty,HOrgID) " +
"values('" + (this.BillType ?? "") + "','" + (this.HBillSubType ?? "") + "'," +
"'" + (omodel.HBillNo ?? "") + "','" + (omodel.HDate.ToString() ?? "") + "'" +
"," + (omodel.HYear.ToString() ?? "0") + "," + (omodel.HPeriod.ToString() ?? "0") +
@@ -165,7 +167,7 @@
(omodel.HSourceID.ToString() ?? "0") + "," + (omodel.HProcID.ToString() ?? "0") + "," +
(omodel.HGroupID.ToString() ?? "0") + "," + (omodel.HShiftsID.ToString() ?? "0") + ",'" +
(omodel.HSignInReason?.ToString() ?? "0") + "','" + (omodel.HSignRemark?.ToString() ?? "") + "'," +
- (omodel.HCheckEmp.ToString() ?? "0") + "," + (omodel.HDeptID.ToString() ?? "0") + "," + (omodel.HEmpID.ToString() ?? "0") + "," + (omodel.HOrgID.ToString() ?? "0") + ")");
+ (omodel.HDeptID.ToString() ?? "0") + "," + (omodel.HEmpID.ToString() ?? "0") + "," + (omodel.HMouldRelQty.ToString() ?? "0") + "," + (omodel.HOrgID.ToString() ?? "0") + ")");
//涓昏〃
//鎻掑叆瀛愯〃
@@ -182,7 +184,7 @@
}
//=========================淇濆瓨鍚庢帶鍒�
- DataSet ds2 = oCn.RunProcReturn("Exec h_p_Gy_QCVerificationBill_AfterSaveCtrl " + omodel.HInterID.ToString() + ", '" + omodel.HBillNo + "',1", "h_p_Gy_QCVerificationBill_AfterSaveCtrl");
+ DataSet ds2 = oCn.RunProcReturn("Exec Sc_EmployeeSignInNoteBill_AfterSaveCtrl " + omodel.HInterID.ToString() + ", '" + omodel.HBillNo + "',1", "Sc_EmployeeSignInNoteBill_AfterSaveCtrl");
if (ds2 == null)
{
--
Gitblit v1.9.1