Ejemplo n.º 1
0
        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);
        }
Ejemplo n.º 2
0
        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);
            }
        }
Ejemplo n.º 3
0
        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);
        }
Ejemplo n.º 4
0
 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;
     }
 }
Ejemplo n.º 5
0
 public DataTable GetReportGuideLineDetailData(MD_ReportGuideLineDefine ReportGuideLineDefine, DateTime StartDate, DateTime EndDate, string DWDM)
 {
     return(ReportFactroy.GetReportGuideLineDetailData(ReportGuideLineDefine, StartDate, EndDate, DWDM));
 }
Ejemplo n.º 6
0
 public System.Data.DataTable GetReportGuideLineDetailData(MD_ReportGuideLineDefine ReportGuideLineDefine, DateTime StartDate, DateTime EndDate, string DWDM)
 {
     throw new Exception("The method or operation is not implemented.");
 }