protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { try { int siteId = int.Parse(Request.QueryString["SiteId"]); int plantId = int.Parse(Request.QueryString["PlantId"]); int lineId = int.Parse(Request.QueryString["LineId"]); int machineId = 0; int.TryParse(Request.QueryString["MachineId"], out machineId); // int machineId = (Request.QueryString["MachineId"] != ""? int.Parse(Request.QueryString["MachineId"]):0) ; DateTime startDate = DateTime.Parse(Request.QueryString["StartDate"]); DateTime endDate = DateTime.Parse(Request.QueryString["EndDate"]); //string year = Request.QueryString["year"]; BreakDownReportService _breakDownReportService = new BreakDownReportService(); var dataSource = _breakDownReportService.GetHistoryReportGridData(siteId, plantId, lineId, machineId, startDate, endDate, true); //var dataSource = _breakDownReportService.GetHistoryReportGridData(siteId, plantId, lineId, year); String reportFolder = System.Configuration.ConfigurationManager.AppSettings["SSRSReportsFolder"].ToString(); if (dataSource.Count > 0) { rvSiteMapping.Visible = true; pnlNoData.Visible = false; rvSiteMapping.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Local; // rvSiteMapping.ServerReport.ReportPath = String.Format(@"\{0}\{1}", reportFolder, Request["ReportName"].ToString()); // Customers dsCustomers = GetData("select top 20 * from customers"); //ReportDataSource datasource = new ReportDataSource(); //datasource.Name = "DataSet1"; //rvSiteMapping.LocalReport.DataSources.Clear(); //rvSiteMapping.LocalReport.DataSources.Add(datasource); Microsoft.Reporting.WebForms.ReportDataSource datasrc = new Microsoft.Reporting.WebForms.ReportDataSource("DataSet1", dataSource); datasrc.Name = "DataSet1"; //datasrc.DataSourceId= rvSiteMapping.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource("DataSet1", dataSource)); this.rvSiteMapping.LocalReport.SetParameters(new Microsoft.Reporting.WebForms.ReportParameter("DateFrom", startDate.ToString())); this.rvSiteMapping.LocalReport.SetParameters(new Microsoft.Reporting.WebForms.ReportParameter("DateTo", endDate.ToString())); this.rvSiteMapping.LocalReport.SetParameters(new Microsoft.Reporting.WebForms.ReportParameter("LineName", dataSource.Select(f => f.LineName).FirstOrDefault())); } else { rvSiteMapping.Visible = false; pnlNoData.Visible = true; Microsoft.Reporting.WebForms.ReportDataSource datasrc = new Microsoft.Reporting.WebForms.ReportDataSource("DataSet1", dataSource); datasrc.Name = "DataSet1"; //datasrc.DataSourceId= rvSiteMapping.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource("DataSet1", dataSource)); //this.rvSiteMapping.LocalReport.SetParameters(new Microsoft.Reporting.WebForms.ReportParameter("DateFrom", DateTime.Now.ToString())); //this.rvSiteMapping.LocalReport.SetParameters(new Microsoft.Reporting.WebForms.ReportParameter("DateTo", DateTime.Now.ToString())); // this.rvSiteMapping.LocalReport.SetParameters(new Microsoft.Reporting.WebForms.ReportParameter("LineName", "P1")); } rvSiteMapping.LocalReport.Refresh(); } catch (Exception ex) { } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { try { int siteId = int.Parse(Request.QueryString["SiteId"]); int plantId = int.Parse(Request.QueryString["PlantId"]); int lineId = 0; //int.Parse(Request.QueryString["LineId"]); int month = 0; string year = "2017"; //Request.QueryString["year"]; BreakDownReportService _breakDownReportService = new BreakDownReportService(); //List<Services.Models.BreakDownMonthlySummaryDataSet> dataSource = _breakDownReportService.GetBreakdownDataGroupByType(1, plantId, 12, startDate, endDate); List <Services.Models.BreakDownMonthlySummaryDataSet> dataSource = _breakDownReportService.GetBreakdownDataGroupByType(siteId, plantId, 0, year, month); //new DateTime(dateTime.Year, dateTime.Month, 1) if (dataSource.Count > 0) { rvSiteMapping.Visible = true; pnlNoData.Visible = false; int maxMonth = ((from d in dataSource select d.Date.Value).Max()).Month; int minMonth = ((from d in dataSource select d.Date.Value).Min()).Month; List <string> BreakDownType = new List <string> { "Electrical", "Mechanical", "Instrumentation", "Utility", "Power", "Process", "PRV", "Idle" }; List <string> lines = new List <string>(); if (lineId == 0) { lines = _breakDownReportService.getLineNamesByPlantId(plantId); } else { lines.Add(dataSource[0].LineName); } string plantName = _breakDownReportService.getPlantNameBylantId(plantId); for (int i = 1; i <= 12; i++) { foreach (string lineName in lines) { foreach (string type in BreakDownType) { dataSource.Add(new Services.Models.BreakDownMonthlySummaryDataSet { Date = new DateTime(int.Parse(year), i, 1), DaysInMonth = DateTime.DaysInMonth(int.Parse(year), i), TotalTime = 0, PlantName = plantName, LineName = lineName, BreakDownType = type }); } } } String reportFolder = System.Configuration.ConfigurationManager.AppSettings["SSRSReportsFolder"].ToString(); rvSiteMapping.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Local; Microsoft.Reporting.WebForms.ReportDataSource datasrc = new Microsoft.Reporting.WebForms.ReportDataSource("DataSet1", dataSource); datasrc.Name = "DataSet1"; rvSiteMapping.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource("DataSet1", dataSource)); this.rvSiteMapping.LocalReport.SetParameters(new Microsoft.Reporting.WebForms.ReportParameter("Year", DateTime.Now.ToString())); } else { rvSiteMapping.Visible = false; pnlNoData.Visible = true; Microsoft.Reporting.WebForms.ReportDataSource datasrc = new Microsoft.Reporting.WebForms.ReportDataSource("DataSet1", dataSource); datasrc.Name = "DataSet1"; rvSiteMapping.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource("DataSet1", dataSource)); } rvSiteMapping.LocalReport.Refresh(); } catch (Exception ex) { } } }