| | |
| | | "',HCopyEmp = '" + HCopyEmp + |
| | | "',HRemark = '" + HRemark + |
| | | "',HOrgID = " + HOrgID + |
| | | ",HMaker = '" + HMaker + |
| | | "',HMakeDate = '" + HMakerDate + |
| | | ",HUpdater = '" + HUpdater + |
| | | "',HUpdateDate = '" + HUpdaterDate + |
| | | "' where HInterID = " + HInterID; |
| | | |
| | | oCN.RunProc(sql); |
| | |
| | | public string HDeleteManDate; |
| | | public string HBackerDate; |
| | | public string HBackRemark; |
| | | public int HReportEmpID; |
| | | public string HReportEmpName; |
| | | } |
| | | #endregion |
| | | #region 浠诲姟姹囨姤 瀛愯〃鏁版嵁 |
| | |
| | | int HOrgID = mainList[0].HOrgID; |
| | | string HMaker = mainList[0].HMaker; |
| | | string HMakerDate = mainList[0].HMakerDate; |
| | | |
| | | int HReportEmpID = mainList[0].HReportEmpID; |
| | | string HReportEmpName = mainList[0].HReportEmpName; |
| | | string HUpdater = mainList[0].HUpdater; |
| | | string HUpdaterDate = mainList[0].HUpdaterDate; |
| | | |
| | | |
| | | |
| | | if (OperationType == 2) |
| | | { |
| | |
| | | if ((OperationType == 1 || OperationType == 2) && ds.Tables[0].Rows.Count == 0)//鏂板 |
| | | { |
| | | string sql = "insert into PM_WorkTaskReportBillMain" + |
| | | "(HYear,HPeriod,HBillType,HBillSubType,HInterID,HDate,HBillNo,HBillStatus,HRemark,HMaker,HMakeDate,HOrgID) " + |
| | | "(HYear,HPeriod,HBillType,HBillSubType,HInterID,HDate,HBillNo,HBillStatus,HRemark,HMaker,HMakeDate,HOrgID,HReportEmpID) " + |
| | | "values(" + |
| | | "" + HYear + |
| | | "," + HPeriod + |
| | |
| | | "','" + HMaker + |
| | | "','" + HMakerDate + |
| | | "'," + HOrgID + |
| | | "," + HReportEmpID + |
| | | ")"; |
| | | |
| | | //涓昏〃 |
| | |
| | | "',HBillNo = '" + HBillNo + |
| | | "',HBillStatus = " + HBillStatus + |
| | | ",HRemark = '" + HRemark + |
| | | "',HMaker = '" + HMaker + |
| | | "',HMakeDate = '" + HMakerDate + |
| | | "',HUpdater = '" + HUpdater + |
| | | "',HUpdateDate = '" + HUpdaterDate + |
| | | "',HOrgID = " + HOrgID + |
| | | ",HReportEmpID = " + HReportEmpID + |
| | | " where HInterID = " + HInterID; |
| | | |
| | | oCN.RunProc(sql); |