班次开班单：主表增加字段 实到岗人数 HRelEmpQty

duhe

2025-05-08 375f9ae4573688233a0259da687a5ec28b8961ea

 DAL/生产管理/ClsSc_ShiftsBeginInfoBill.cs

@@ -72,6 +72,7 @@
                ",HGroupID =" + omodel.HGroupID.ToString() +
                ",HGroupLeaderID =" + omodel.HGroupLeaderID.ToString() +
                ",HStdEmpQty =" + omodel.HStdEmpQty.ToString() +
                ",HRelEmpQty = " + omodel.HRelEmpQty.ToString() +
                ",HPlanShutdownTimes =" + omodel.HPlanShutdownTimes.ToString() +

                " where HInterID=" + lngBillKey.ToString());
@@ -170,7 +171,7 @@
                //涓昏〃
                string mainSql = "insert into Sc_ShiftsBeginInfoBillMain" +
                    "(HYear,HPeriod,HBillType,HBillSubType,HInterID,HDate,HBillNo,HRemark,HMaker,HMakeDate" +
                    ",HDeptID,HWorkCenterID,HShiftsID,HSourceID,HGroupID,HGroupLeaderID,HStdEmpQty,HPlanShutdownTimes) " +
                    ",HDeptID,HWorkCenterID,HShiftsID,HSourceID,HGroupID,HGroupLeaderID,HStdEmpQty,HRelEmpQty,HPlanShutdownTimes) " +
                    "values(" +
                    "" + (omodel.HYear.ToString() != "0" ? omodel.HYear.ToString() : DateTime.Now.Year.ToString()) +
                    "," + omodel.HPeriod.ToString() +
@@ -189,6 +190,7 @@
                    "','" + omodel.HGroupID +
                    "','" + omodel.HGroupLeaderID +
                    "','" + omodel.HStdEmpQty +
                    "','" + omodel.HRelEmpQty +
                    "','" + omodel.HPlanShutdownTimes +
                    "')";