| | |
| | | public string HBackRemark; |
| | | public int HReportEmpID; |
| | | public string HReportEmpName; |
| | | public string HReceiveEmp; |
| | | public string HCopyEmp; |
| | | } |
| | | #endregion |
| | | #region 任塿±æ¥ åè¡¨æ°æ® |
| | |
| | | string HReportEmpName = mainList[0].HReportEmpName; |
| | | string HUpdater = mainList[0].HUpdater; |
| | | string HUpdaterDate = mainList[0].HUpdaterDate; |
| | | string HReceiveEmp = mainList[0].HReceiveEmp; |
| | | string HCopyEmp = mainList[0].HCopyEmp; |
| | | reportMan = HReportEmpName;//è·åæ±æ¥äººåç§° |
| | | //ä¿ååæ§å¶ |
| | | DataSet BeforeDs = oCN.RunProcReturn("Exec h_p_PM_WorkTaskReportBill_BeforeSaveCtrl " + HInterID.ToString() + ",'" + HBillNo + "'," + OperationType.ToString(), "h_p_PM_WorkTaskReportBill_BeforeSaveCtrl"); |
| | |
| | | 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,HReportEmpID) " + |
| | | "(HYear,HPeriod,HBillType,HBillSubType,HInterID,HDate,HBillNo,HBillStatus,HRemark,HMaker,HMakeDate,HOrgID,HReportEmpID,HReceiveEmp, HCopyEmp) " + |
| | | "values(" + |
| | | "" + HYear + |
| | | "," + HPeriod + |
| | |
| | | "','" + HMakerDate + |
| | | "'," + HOrgID + |
| | | "," + HReportEmpID + |
| | | ")"; |
| | | |
| | | ",N'" + HReceiveEmp + |
| | | "',N'" + HCopyEmp + |
| | | "')"; |
| | | LogService.Write(sql); |
| | | //主表 |
| | | oCN.RunProc(sql); |
| | | LogService.Write("ç¨æ·:" + user + ",æ¥æ:" + DateTime.Now + ",æ°å¢ä»»å¡æ±æ¥:" + HBillNo); |
| | |
| | | "',HUpdateDate = '" + HUpdaterDate + |
| | | "',HOrgID = " + HOrgID + |
| | | ",HReportEmpID = " + HReportEmpID + |
| | | ",HReceiveEmp = N'" + HReceiveEmp + "'" + |
| | | ",HCopyEmp = N'" + HCopyEmp + "'" + |
| | | " where HInterID = " + HInterID; |
| | | |
| | | oCN.RunProc(sql); |
| | | |
| | | //å é¤åè¡¨æ¶ åå¡«å·¥ä½ä»»å¡åå
³èæ°éãåæ®ç¶æ |