1

duhe

2026-03-02 c3b14901031d985ef750027d4952264369a1d7b0

 DAL/³µ¼ä¹ÜÀí/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)
                {