| | |
| | | ",HGroupID =" + omodel.HGroupID.ToString() + |
| | | ",HGroupLeaderID =" + omodel.HGroupLeaderID.ToString() + |
| | | ",HStdEmpQty =" + omodel.HStdEmpQty.ToString() + |
| | | ",HPlanShutdownTimes =" + omodel.HPlanShutdownTimes.ToString() + |
| | | |
| | | " where HInterID=" + lngBillKey.ToString()); |
| | | //鍒犻櫎鍏宠仈 |
| | |
| | | //涓昏〃 |
| | | string mainSql = "insert into Sc_ShiftsBeginInfoBillMain" + |
| | | "(HYear,HPeriod,HBillType,HBillSubType,HInterID,HDate,HBillNo,HRemark,HMaker,HMakeDate" + |
| | | ",HDeptID,HWorkCenterID,HShiftsID,HSourceID,HGroupID,HGroupLeaderID,HStdEmpQty) " + |
| | | ",HDeptID,HWorkCenterID,HShiftsID,HSourceID,HGroupID,HGroupLeaderID,HStdEmpQty,HPlanShutdownTimes) " + |
| | | "values(" + |
| | | "" + (omodel.HYear.ToString() != "0" ? omodel.HYear.ToString() : DateTime.Now.Year.ToString()) + |
| | | "," + omodel.HPeriod.ToString() + |
| | |
| | | "','" + omodel.HGroupID + |
| | | "','" + omodel.HGroupLeaderID + |
| | | "','" + omodel.HStdEmpQty + |
| | | |
| | | "','" + omodel.HPlanShutdownTimes + |
| | | "')"; |
| | | |
| | | oCn.RunProc(mainSql); |