员工签到表修复

llj

2026-01-20 e221873aafe6f0f7a0736934e8d8e572807ded30

员工签到表修复

 DAL/车间管理/ClsSc_EmployeeSignInNoteBill.cs

@@ -77,6 +77,7 @@
                ",HGroupID =" + omodel.HGroupID.ToString()+
                ",HShiftsID  =" + omodel.HShiftsID.ToString()+
                ",HSignInReason  ='" + omodel.HSignInReason.ToString()+"'"+
                ",HSignRemark  ='" + omodel.HSignRemark.ToString()+"'"+
                ",HEmpID  ='" + omodel.HEmpID.ToString()+ "'" +
                " where HInterID=" + lngBillKey.ToString());
                //鍒犻櫎鍏宠仈
@@ -146,7 +147,7 @@
                    return false;
                }
                //=========================================================

                // (omodel.HCheckEmp.ToString() ?? "0") + "," + 

                oCn.BeginTran();
                oCn.RunProc("Insert Into Sc_EmployeeSignInNoteBillMain " +
@@ -154,7 +155,7 @@
                           ",HYear,HPeriod,HRemark,HMaker,HMakeDate," +
                           "HMainSourceBillType,HMainSourceBillNo,HMainSourceInterID,HMainSourceEntryID," +
                           "HEquipID,HMouldID,HSourceID,HProcID,HGroupID,HShiftsID,HSignInReason,HSignRemark," +
                           "HChecker,HDeptID,HEmpID,HOrgID) " +
                           "HDeptID,HEmpID,HOrgID) " +
                           "values('" + (this.BillType ?? "") + "','" + (this.HBillSubType ?? "") + "'," +
                           "'" + (omodel.HBillNo ?? "") + "','" + (omodel.HDate.ToString() ?? "") + "'" +
                           "," + (omodel.HYear.ToString() ?? "0") + "," + (omodel.HPeriod.ToString() ?? "0") +
@@ -165,7 +166,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.HOrgID.ToString() ?? "0") + ")");
                //涓昏〃              
                //鎻掑叆瀛愯〃