public MD_ReportGuideLineDefine GetReportGuideLineDefine(string _id) { MD_ReportGuideLineDefine _ret = null; using (OracleConnection cn = OracleHelper.OpenConnection()) { OracleParameter[] _param = { new OracleParameter(":ID", OracleDbType.Decimal) }; _param[0].Value = decimal.Parse(_id); OracleDataReader _dr = OracleHelper.ExecuteReader(cn, CommandType.Text, SQL_GetReportGuideLineDefine, _param); while (_dr.Read()) { _ret = new MD_ReportGuideLineDefine( _dr.IsDBNull(0) ? "" : _dr.GetDecimal(0).ToString(), _dr.IsDBNull(1) ? "" : _dr.GetDecimal(1).ToString(), _dr.IsDBNull(2) ? "" : _dr.GetString(2), _dr.IsDBNull(3) ? "" : _dr.GetString(3), _dr.IsDBNull(4) ? "" : _dr.GetString(4), _dr.IsDBNull(5) ? "" : _dr.GetString(5) ); } _dr.Close(); cn.Close(); } return(_ret); }
public DataTable GetReportGuideLineDetailData(MD_ReportGuideLineDefine ReportGuideLineDefine, DateTime StartDate, DateTime EndDate, string DWDM) { DataTable _ret = new DataTable(); _ret.TableName = "RESULT"; string _zbsf = ReportGuideLineDefine.DetialMethod.Trim(); try { using (OracleConnection cn = OracleHelper.OpenConnection()) { _zbsf = _zbsf.Replace("dtBegin", string.Format("to_date('{0}01','YYYYMMDD')", StartDate.ToString("yyyMM"))); _zbsf = _zbsf.Replace("dtEnd", string.Format("to_date('{0}235959','YYYYMMDDhh24miss')", EndDate.ToString("yyyMMdd"))); _zbsf = _zbsf.Replace("strTJDW", string.Format("'{0}'", DWDM)); _ret = OracleHelper.FillDataTable(cn, CommandType.Text, _zbsf); cn.Close(); } return(_ret); } catch (Exception e) { string _errmsg = string.Format("执行报表指标{2}[{3}]的详细记录查询出错,错误信息为:{0}!\n查询语句为:{1}\n", e.Message, _zbsf, ReportGuideLineDefine.DisplayName, ReportGuideLineDefine.ID); OralceLogWriter.WriteSystemLog(_errmsg, "ERROR"); return(_ret); } }
public DataSet GetReportGuideLineDetailData(MD_ReportGuideLineDefine ReportGuideLineDefine, DateTime StartDate, DateTime EndDate, string DWDM) { DataSet _ds = new DataSet(); OraReportFactroy _of = new OraReportFactroy(); DataTable _dt = _of.GetReportGuideLineDetailData(ReportGuideLineDefine, StartDate, EndDate, DWDM); _ds.Tables.Add(_dt); return(_ds); }
private void backgroundWorker1_DoWork(object sender, DoWorkEventArgs e) { runningGuideLineID = this.currentGuideLine.ID; using (SinoSZClientBase.ReportService.ReportServiceClient _rsc = new SinoSZClientBase.ReportService.ReportServiceClient()) { currentDefine = _rsc.GetReportGuideLineDefine(this.currentGuideLine.ID); fieldDict = CreateFieldDictionary(currentDefine.ZBMeta); DataSet _ds = _rsc.GetReportGuideLineData(this.currentDefine, StartDate, EndDate, DWDM); _zbData = (_ds.Tables.Count > 0) ? _ds.Tables[0] : null; DataSet _detailds = _rsc.GetReportGuideLineDetailData(this.currentDefine, StartDate, EndDate, DWDM); _detailData = (_detailds.Tables.Count > 0) ? _detailds.Tables[0] : null; } }
public DataTable GetReportGuideLineDetailData(MD_ReportGuideLineDefine ReportGuideLineDefine, DateTime StartDate, DateTime EndDate, string DWDM) { return(ReportFactroy.GetReportGuideLineDetailData(ReportGuideLineDefine, StartDate, EndDate, DWDM)); }
public System.Data.DataTable GetReportGuideLineDetailData(MD_ReportGuideLineDefine ReportGuideLineDefine, DateTime StartDate, DateTime EndDate, string DWDM) { throw new Exception("The method or operation is not implemented."); }