Beispiel #1
0
        private void Page_Load(object sender, System.EventArgs e)
        {
            //try
            //{
            ReportViewerControl.LocalReport.ReportPath = _functions.GetValueFromConfig("SQLRS.DefaultPath") + ".rdlc";
            if (Request["Report"] != null)
                ReportViewerControl.LocalReport.ReportPath = Request["Report"] + ".rdlc";

            ReportViewerControl.LocalReport.EnableExternalImages = true;

            clsWorkOrders wo = new clsWorkOrders();

            if (!string.IsNullOrEmpty(Request["OrgId"]))
                wo.iOrgId = Convert.ToInt32(Request["OrgId"]);

            if (!string.IsNullOrEmpty(Request["OrderId"]))
                wo.iId = Convert.ToInt32(Request["OrderId"]);

            if (!string.IsNullOrEmpty(Request["InspectId"]))
                wo.iInspectionId = Convert.ToInt32(Request["InspectId"]);

            string url = string.Empty;
            if (!string.IsNullOrEmpty(Request["URL"]))
                url = Request["URL"];

            foreach (string dataSource in ReportViewerControl.LocalReport.GetDataSourceNames())
            {
                switch (dataSource)
                {
                    case "ReportedIssueList":
                        DataSet ds = wo.GetReportedIssueLists();
                        if (ds != null && ds.Tables.Count > 0)
                            ReportViewerControl.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource(dataSource, ds.Tables[0]));
                        break;
                    case "PMItemList":
                        ReportViewerControl.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource(dataSource, wo.GetPMServicesListForWorkOrder()));
                        break;
                    case "InspectionsList":
                        ReportViewerControl.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource(dataSource, wo.GetInspectionsListForWorkOrder()));
                        break;
                    case "WorkOrderDetail":
                        ReportViewerControl.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource(dataSource, wo.GetDetailsForWorkOrder()));
                        break;
                    case "CreationNotesList":
                        wo.iNoteTypeId = 1;
                        ReportViewerControl.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource(dataSource, wo.GetNotesList()));
                        break;
                    case "OperatorNotesList":
                        wo.iNoteTypeId = 2;
                        ReportViewerControl.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource(dataSource, wo.GetNotesList()));
                        break;
                    case "PartsList":
                        ReportViewerControl.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource(dataSource, wo.GetPartsUsedListForReport()));
                        break;
                    case "ReportedIssuesList":
                        ReportViewerControl.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource(dataSource, wo.GetReportedIssues()));
                        break;
                    case "PMItemsList":
                        ReportViewerControl.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource(dataSource, wo.GetPMItemsList()));
                        break;
                    case "RepairsList":
                        ReportViewerControl.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource(dataSource, wo.GetRepairsListForReport()));
                        break;
                    case "TechNotesList":
                        wo.iNoteTypeId = 3;
                        ReportViewerControl.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource(dataSource, wo.GetNotesList()));
                        break;
                    case "CheckOutNotesList":
                        wo.iNoteTypeId = 4;
                        ReportViewerControl.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource(dataSource, wo.GetNotesList()));
                        break;
                    case "CheckInDetails":
                        ReportViewerControl.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource(dataSource, wo.CheckInDetailsForReport(url)));
                        break;
                    case "InstructionList":
                        ReportViewerControl.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource(dataSource, wo.GetInstructionByCheckIn()));
                        break;
                    case "InspectionDetail":
                        ReportViewerControl.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource(dataSource, wo.GetInspectionDetailForReport()));
                        break;
                    case "InspectionItemsList":
                        ReportViewerControl.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource(dataSource, wo.GetInspectionItemsListForReport()));
                        break;
                    case "InspectionList":
                        ReportViewerControl.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource(dataSource, wo.GetInspectionListForReport()));
                        break;
                }
            }
        }