| | |
| | | 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; |
| | | |
| | | |
| | | |
| | | 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 + |
| | | ")"; |
| | | |
| | | //涓昏〃 |
| | |
| | | "',HMaker = '" + HMaker + |
| | | "',HMakeDate = '" + HMakerDate + |
| | | "',HOrgID = " + HOrgID + |
| | | ",HReportEmpID = " + HReportEmpID + |
| | | " where HInterID = " + HInterID; |
| | | |
| | | oCN.RunProc(sql); |