Exemple #1
0
        protected override void BandingReport()
        {
            //定义报表参数对象
            List <ReportParameter>      parameterList = new List <ReportParameter>();
            Dictionary <string, string> paramDic      = RdlcParam();

            foreach (var key in paramDic.Keys)
            {
                parameterList.Add(new ReportParameter(key, paramDic[key]));
            }
            parameterList.Add(new ReportParameter("PollutionName", PollutionName));
            parameterList.Add(new ReportParameter("PollutionNo", PollutionNo));

            string ReportPath = "Areas\\Report\\Template\\AirYear.rdlc";

            ReportViewer1.LocalReport.ReportPath             = ReportPath;
            ReportViewer1.LocalReport.ReportEmbeddedResource = "Tablix1";
            ReportViewer1.LocalReport.SetParameters(parameterList);
            DataTable table = MonitorData.GetMonitorDataForReportAir(Request.QueryString["dataFrom"], startTime, endTime, Request.QueryString["type"], Request.QueryString["id"], "month");

            DataHandle.TableDataStyle(table, "DATA_TIME", Request.QueryString["rdlcType"]);
            ReportDataSource rds = new ReportDataSource("AirHour", table); //指定数据源GetTestDataTable()

            ReportViewer1.LocalReport.DataSources.Clear();                 //报表数据源清除,必须
            ReportViewer1.LocalReport.DataSources.Add(rds);                //报表数据源增加
            ReportViewer1.LocalReport.Refresh();                           //刷新报表
        }
        protected override void BandingReport()
        {
            //定义报表参数对象
            List <ReportParameter> parameterList = new List <ReportParameter>();
            var paramDic = RdlcParam(Request.QueryString["rdlcType"]);

            foreach (var key in paramDic.Keys)
            {
                parameterList.Add(new ReportParameter(key, paramDic[key]));
            }
            string ReportPath = "Areas\\Report\\Template\\PollutionCompanyWarn.rdlc";

            ReportViewer1.LocalReport.ReportPath             = ReportPath;
            ReportViewer1.LocalReport.ReportEmbeddedResource = "Tablix1";
            ReportViewer1.LocalReport.SetParameters(parameterList);

            DataTable table = MonitorData.GetPollutionWarnData(startTime, endTime, Request.QueryString["type"], Request.QueryString["id"], dataType);

            DataHandle.TableDataStyle(table, "DATA_TIME", Request.QueryString["rdlcType"]);
            ReportDataSource rds = new ReportDataSource("PollutionCompanyWarn", table); //指定数据源GetTestDataTable()

            ReportViewer1.LocalReport.DataSources.Clear();                              //报表数据源清除,必须
            ReportViewer1.LocalReport.DataSources.Add(rds);                             //报表数据源增加
            ReportViewer1.LocalReport.Refresh();                                        //刷新报表
        }
Exemple #3
0
        protected override void BandingReport()
        {
            //定义报表参数对象
            List <ReportParameter> parameterList = new List <ReportParameter>();
            var paramDic = RdlcParam(Request.QueryString["rdlcType"]);

            foreach (var key in paramDic.Keys)
            {
                parameterList.Add(new ReportParameter(key, paramDic[key]));
            }
            dynamic companyInfo = BaseCommonInfo.GetCompanyOrPK(Request.QueryString["type"], Request.QueryString["id"]);

            parameterList.Add(new ReportParameter("PollutionName", companyInfo.Name));
            parameterList.Add(new ReportParameter("PollutionNo", companyInfo.Code));


            string ReportPath = "Areas\\Report\\Template\\VocsHour.rdlc";

            ReportViewer1.LocalReport.ReportPath             = ReportPath;
            ReportViewer1.LocalReport.ReportEmbeddedResource = "Tablix1";
            ReportViewer1.LocalReport.SetParameters(parameterList);

            DataTable table = MonitorData.GetMonitorDataForReportVocs(Request.QueryString["dataFrom"], startTime, endTime, Request.QueryString["type"], Request.QueryString["id"], dataType);

            DataHandle.TableDataStyle(table, "DATA_TIME", Request.QueryString["rdlcType"]);
            ReportDataSource rds = new ReportDataSource("VocsMonitor", table); //指定数据源GetTestDataTable()

            ReportViewer1.LocalReport.DataSources.Clear();                     //报表数据源清除,必须
            ReportViewer1.LocalReport.DataSources.Add(rds);                    //报表数据源增加
            ReportViewer1.LocalReport.Refresh();                               //刷新报表
        }