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(); //刷新报表 }
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(); //刷新报表 }