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.");
}