| | |
| | | public string HBacker; |
| | | public string HBackerDate; |
| | | public string HBackRemark; |
| | | public string HChangeType; |
| | | public string HChangeValue; |
| | | } |
| | | #endregion |
| | | #region å表 |
| | |
| | | string HBacker = mainList[0].HBacker; |
| | | string HBackerDate = mainList[0].HBackerDate; |
| | | string HBackRemark = mainList[0].HBackRemark; |
| | | |
| | | string HChangeType = mainList[0].HChangeType; |
| | | string HChangeValue = mainList[0].HChangeValue; |
| | | //ä¿ååæ§å¶ |
| | | DataSet BeforeDs = oCn.RunProcReturn("Exec h_p_Pay_ProcPriceRequestBill_BeforeSaveCtrl " + HInterID.ToString() + ",'" + HBillNo + "'," + OperationType.ToString(), "h_p_Pay_ProcPriceRequestBill_BeforeSaveCtrl"); |
| | | if (BeforeDs == null || BeforeDs.Tables[0].Rows.Count == 0) |
| | |
| | | { |
| | | string sql = "insert into Pay_ProcPriceRequestBillMain" + |
| | | "(HYear,HPeriod,HBillType,HBillSubType,HBillStatus,HInterID,HBillNo,HDate,HInnerBillNo,HDeptID" + |
| | | ",HExplanation,HRemark,HMaker,HMakeDate) " + |
| | | ",HExplanation,HRemark,HMaker,HMakeDate,HChangeType,HChangeValue) " + |
| | | "values(" + |
| | | "" + HYear + |
| | | "," + HPeriod + |
| | |
| | | "','" + HRemark + |
| | | "','" + HMaker + |
| | | "','" + HMakerDate + |
| | | "')"; |
| | | "','" + HChangeType + |
| | | "'," + HChangeValue + |
| | | ")"; |
| | | |
| | | //主表 |
| | | oCn.RunProc(sql); |
| | |
| | | "', HRemark = '" + HRemark + |
| | | "', HUpdater = '" + HUpdater + |
| | | "', HUpdateDate = '" + HUpdaterDate + |
| | | "' where HInterID = " + HInterID; |
| | | "', HChangeType = '" + HChangeType + |
| | | "', HChangeValue = " + HChangeValue + |
| | | " where HInterID = " + HInterID; |
| | | |
| | | oCn.RunProc(sql); |
| | | |