protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { string ReportID; string Arg1, Arg2; string wo_name = ""; string issue_no = "", jc_miv_no = ""; ReportID = Request.QueryString["ReportID"]; Arg1 = Request.QueryString["Arg1"]; Arg2 = Request.QueryString["Arg2"]; Master.HeadingMessage = "Preview Report"; switch (ReportID) { case "1": case "2": case "3": case "5": case "6": case "7": case "8": case "10": case "21": wo_name = WebTools.GetExpr("WO_NAME", "PIP_WORK_ORD", "WO_ID=" + Arg1); break; case "15": case "15.1": case "16": case "17": case "17.1": case "18": case "19": case "20": issue_no = WebTools.GetExpr("WO_NAME", "VIEW_JC_MIV", "ISSUE_ID=" + Arg1); jc_miv_no = WebTools.GetExpr("ISSUE_NO", "VIEW_JC_MIV", "ISSUE_ID=" + Arg1); break; default: wo_name = ""; break; } switch (ReportID) { case "1": case "1.1": case "1.2": string mat_group = "XXX"; if (ReportID == "1.1") { mat_group = "PIPE"; } else if (ReportID == "1.2") { mat_group = "FITTING"; } VIEW_JC_MAT_SUMMARYTableAdapter rep_1_1 = new VIEW_JC_MAT_SUMMARYTableAdapter(); ReportPreview.LocalReport.DisplayName = wo_name + " Material Summary"; //ReportPreview.LocalReport.ReportPath = "SpoolFabJobCard\\Reports\\JcMat_Summary.rdlc"; ReportPreview.LocalReport.ReportPath = "SpoolFabJobCard\\Reports\\JcMat_Required_MIVR.rdlc"; ReportPreview.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource( "dsJcReports_VIEW_JC_MAT_SUMMARY", (DataTable)rep_1_1.GetData(decimal.Parse(Arg1), mat_group))); break; case "2": case "3": VIEW_JC_SPL_FABTableAdapter jc = new VIEW_JC_SPL_FABTableAdapter(); ReportPreview.LocalReport.DisplayName = wo_name + " Spool List"; if (ReportID == "2") { ReportPreview.LocalReport.ReportPath = "SpoolFabJobCard\\Reports\\JcSpoolList_Fab.rdlc"; } else // paint { ReportPreview.LocalReport.ReportPath = "SpoolFabJobCard\\Reports\\JcSpoolList_Paint.rdlc"; } ReportPreview.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource( "dsJcReports_VIEW_JC_SPL_FAB", (DataTable)jc.GetData(Decimal.Parse(Arg1)))); break; case "5": VIEW_JC_SPL_MATTableAdapter jc_spl_mat = new VIEW_JC_SPL_MATTableAdapter(); ReportPreview.LocalReport.DisplayName = wo_name + " Spool Materials"; ReportPreview.LocalReport.ReportPath = "SpoolFabJobCard\\Reports\\JcMat_Spool.rdlc"; ReportPreview.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource( "dsJcReports_VIEW_JC_SPL_MAT", (DataTable)jc_spl_mat.GetData(Decimal.Parse(Arg1)))); break; case "5.1": VIEW_JC_SPL_MAT_PIPETableAdapter jc_spl_mat_pipe = new VIEW_JC_SPL_MAT_PIPETableAdapter(); ReportPreview.LocalReport.DisplayName = wo_name + " Spool pipe cut list"; ReportPreview.LocalReport.ReportPath = "SpoolFabJobCard\\Reports\\JcMat_Spool_Pipe.rdlc"; ReportPreview.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource( "dsJcReports_VIEW_JC_SPL_MAT_PIPE", (DataTable)jc_spl_mat_pipe.GetData(Decimal.Parse(Arg1)))); break; case "6": VIEW_WORK_ORD_PLATE_REPTableAdapter rep_6 = new VIEW_WORK_ORD_PLATE_REPTableAdapter(); ReportPreview.LocalReport.DisplayName = wo_name + " Plate"; ReportPreview.LocalReport.ReportPath = @"SpoolFabJobCard\Reports\JcMat_Plate.rdlc"; ReportPreview.LocalReport.DataSources.Add( new Microsoft.Reporting.WebForms.ReportDataSource( "dsJcReports_A_VIEW_WORK_ORD_PLATE_REP", (DataTable)rep_6.GetData( Decimal.Parse(Arg1) ))); break; // new case "7": VIEW_JC_WELD_REPTableAdapter rep_7 = new VIEW_JC_WELD_REPTableAdapter(); ReportPreview.LocalReport.DisplayName = wo_name + " Welding"; ReportPreview.LocalReport.ReportPath = @"SpoolFabJobCard\Reports\JcWelding.rdlc"; ReportPreview.LocalReport.DataSources.Add( new Microsoft.Reporting.WebForms.ReportDataSource( "DataSet1", (DataTable)rep_7.GetData( decimal.Parse(Arg1) ))); break; case "15": VIEW_CUTLEN_REP_MAINTableAdapter cutlen_main = new VIEW_CUTLEN_REP_MAINTableAdapter(); ReportPreview.LocalReport.DisplayName = issue_no + " Cutting Plan Report"; ReportPreview.LocalReport.ReportPath = "SpoolFabJobCard\\Reports\\CuttingPlan_Main.rdlc"; ReportPreview.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource( "DataSet1", (DataTable)cutlen_main.GetData(Decimal.Parse(Arg1)))); break; case "16": VIEW_JC_MIV_ISSUE_SUMMARY_REPTableAdapter jc_miv = new VIEW_JC_MIV_ISSUE_SUMMARY_REPTableAdapter(); ReportPreview.LocalReport.DisplayName = issue_no + " Jobcard MIV Summary"; ReportPreview.LocalReport.ReportPath = "SpoolFabJobCard\\Reports\\JcMIV_Summary.rdlc"; ReportPreview.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource( "dsJcReports_VIEW_JC_MIV_ISSUE_SUMMARY_REP", (DataTable)jc_miv.GetData(decimal.Parse(Arg1)))); break; case "16.1": VIEW_JC_MIV_ISSUE_SUMMARY_REPTableAdapter jc_miv_rev = new VIEW_JC_MIV_ISSUE_SUMMARY_REPTableAdapter(); ReportPreview.LocalReport.DisplayName = issue_no + " Jobcard MIV Summary"; ReportPreview.LocalReport.ReportPath = "SpoolFabJobCard\\Reports\\JcMIV_Summary_Rev.rdlc"; ReportPreview.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource( "dsJcReports_VIEW_JC_MIV_ISSUE_SUMMARY_REP", (DataTable)jc_miv_rev.GetDataByRev(decimal.Parse(Arg1), decimal.Parse(Arg2)))); break; case "17": VIEW_JC_MIV_SPOOLTableAdapter jc_miv_spool = new VIEW_JC_MIV_SPOOLTableAdapter(); ReportPreview.LocalReport.DisplayName = issue_no + jc_miv_no + " Jobcard MIV Spools"; ReportPreview.LocalReport.ReportPath = "SpoolFabJobCard\\Reports\\JcMIV_Spool.rdlc"; ReportPreview.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource( "dsJcReports_VIEW_JC_MIV_SPOOL", (DataTable)jc_miv_spool.GetData(decimal.Parse(Arg1)))); break; case "18": VIEW_JC_MIV_REQUIREDTableAdapter jc_miv_req = new VIEW_JC_MIV_REQUIREDTableAdapter(); ReportPreview.LocalReport.DisplayName = issue_no + jc_miv_no + " Jobcard MIV Required Qty"; ReportPreview.LocalReport.ReportPath = "SpoolFabJobCard\\Reports\\JcMIV_Required.rdlc"; ReportPreview.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource( "dsJcReports_VIEW_JC_MIV_REQUIRED", (DataTable)jc_miv_req.GetData(decimal.Parse(Arg1)))); break; case "19": VIEW_CUTLEN_REP_MAIN_BTableAdapter cutlen_rem = new VIEW_CUTLEN_REP_MAIN_BTableAdapter(); ReportPreview.LocalReport.DisplayName = issue_no + " Cutting Plan Use Remains"; ReportPreview.LocalReport.ReportPath = "SpoolFabJobCard\\Reports\\CuttingPlan_UseRemain.rdlc"; ReportPreview.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource( "DataSet1", (DataTable)cutlen_rem.GetData(Decimal.Parse(Arg1)))); break; case "20": VIEW_CUTLEN_REP_REMAINSTableAdapter cutlen_rems = new VIEW_CUTLEN_REP_REMAINSTableAdapter(); ReportPreview.LocalReport.DisplayName = issue_no + " Cutting Plan Remains"; ReportPreview.LocalReport.ReportPath = "SpoolFabJobCard\\Reports\\CuttingPlan_RemOut.rdlc"; ReportPreview.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource( "DataSet1", (DataTable)cutlen_rems.GetData(Decimal.Parse(Arg1)))); break; case "21": VIEW_JCMIV_SPL_MAT_PIPETableAdapter jcmiv_spl_mat_pipe = new VIEW_JCMIV_SPL_MAT_PIPETableAdapter(); ReportPreview.LocalReport.DisplayName = issue_no + " Spool pipe cut list"; ReportPreview.LocalReport.ReportPath = "SpoolFabJobCard\\Reports\\JcMIVMat_Spool_Pipe.rdlc"; ReportPreview.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource( "dsJcReports_VIEW_JCMIV_SPL_MAT_PIPE", (DataTable)jcmiv_spl_mat_pipe.GetData(Decimal.Parse(Arg1)))); break; case "22": VIEW_JCMIV_WELD_REPTableAdapter rep_miv_weld = new VIEW_JCMIV_WELD_REPTableAdapter(); ReportPreview.LocalReport.DisplayName = issue_no + " MIV Welding"; ReportPreview.LocalReport.ReportPath = @"SpoolFabJobCard\Reports\JcMIVWelding.rdlc"; ReportPreview.LocalReport.DataSources.Add( new Microsoft.Reporting.WebForms.ReportDataSource( "DataSet1", (DataTable)rep_miv_weld.GetData( decimal.Parse(Arg1) ))); break; } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { string ReportID; string Site_jc_name = ""; String JC_ID; ReportID = Request.QueryString["ReportID"]; JC_ID = Request.QueryString["JC_ID"]; switch (ReportID) { case "2": case "3": case "12": Site_jc_name = WebTools.GetExpr("ISSUE_NO", "PIP_MAT_ISSUE_LOOSE", "JC_ID=" + JC_ID); break; default: Site_jc_name = ""; break; } switch (ReportID) { case "1": VIEW_SITE_JC_SPL_REPTableAdapter rep_1 = new VIEW_SITE_JC_SPL_REPTableAdapter(); ReportPreview.LocalReport.ReportPath = "Erection\\Reports\\Field_JC_Spool_Cleaning.rdlc"; ReportPreview.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource( "dsErectionRepsA_VIEW_SITE_JC_SPL_REP", (DataTable)rep_1.GetData(decimal.Parse(JC_ID)) )); break; case "2": VIEW_SITE_JC_MAT_SUMMARYTableAdapter site_miv_summary = new VIEW_SITE_JC_MAT_SUMMARYTableAdapter(); ReportPreview.LocalReport.DisplayName = Site_jc_name + "_Mat_MIVR"; //ReportPreview.LocalReport.ReportPath = "Erection\\Reports\\Field_JC_Summary.rdlc"; ReportPreview.LocalReport.ReportPath = "Erection\\Reports\\Field_JC_Mat_Required_MIVR.rdlc"; ReportPreview.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource( "dsJcReports_VIEW_JC_MAT_SUMMARY", (DataTable)site_miv_summary.GetData(decimal.Parse(JC_ID)) )); break; case "3": VIEW_SITE_JC_REP_CTableAdapter site_miv_iso = new VIEW_SITE_JC_REP_CTableAdapter(); ReportPreview.LocalReport.DisplayName = Site_jc_name + "_JC_Isometric"; ReportPreview.LocalReport.ReportPath = "Erection\\Reports\\Field_JC_Isometric.rdlc"; ReportPreview.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource( "dsErectionRepsB_VIEW_SITE_JC_REP_C", (DataTable)site_miv_iso.GetData(decimal.Parse(JC_ID) ))); break; case "4": VIEW_SITE_JCTableAdapter rep_4 = new VIEW_SITE_JCTableAdapter(); ReportPreview.LocalReport.ReportPath = "Erection\\Reports\\Field_JC_Punch_List.rdlc"; ReportPreview.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource( "dsErection_VIEW_SITE_JC", (DataTable)rep_4.GetDataByJC_ID(decimal.Parse(JC_ID)) )); break; case "5": VIEW_SITE_JCTableAdapter rep_5 = new VIEW_SITE_JCTableAdapter(); ReportPreview.LocalReport.ReportPath = "Erection\\Reports\\Field_JC_Remaining_Work.rdlc"; ReportPreview.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource( "dsErection_VIEW_SITE_JC", (DataTable)rep_5.GetDataByJC_ID(decimal.Parse(JC_ID)) )); break; case "6": VIEW_SITE_JC_TRANSTableAdapter site_miv_trans = new VIEW_SITE_JC_TRANSTableAdapter(); ReportPreview.LocalReport.ReportPath = "Erection\\Reports\\Field_JC_Transmittal.rdlc"; ReportPreview.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource( "dsErectionRepsB_VIEW_SITE_JC_TRANS", (DataTable)site_miv_trans.GetData(decimal.Parse(JC_ID)))); break; case "7": VIEW_SITE_JC_WELD_REPTableAdapter rep_7 = new VIEW_SITE_JC_WELD_REPTableAdapter(); ReportPreview.LocalReport.ReportPath = "Erection\\Reports\\Field_JC_WeldingReport.rdlc"; ReportPreview.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource( "dsErectionRepsA_VIEW_SITE_JC_WELD_REP", (DataTable)rep_7.GetData(decimal.Parse(JC_ID)) )); break; case "10": VIEW_JC_SPL_FABTableAdapter rep_10 = new VIEW_JC_SPL_FABTableAdapter(); ReportPreview.LocalReport.ReportPath = "Erection\\Reports\\Field_JC_SpoolList.rdlc"; ReportPreview.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource( "dsJcReports_VIEW_JC_SPL_FAB", (DataTable)rep_10.GetData(decimal.Parse(JC_ID)) )); break; case "11": VIEW_SITE_JC_REP_ETableAdapter site_miv_fabsupp = new VIEW_SITE_JC_REP_ETableAdapter(); ReportPreview.LocalReport.ReportPath = "Erection\\Reports\\Field_JC_FieldSupport.rdlc"; ReportPreview.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource( "dsErectionRepsA_VIEW_SITE_JC_REP_E", (DataTable)site_miv_fabsupp.GetData(decimal.Parse(JC_ID)) )); break; case "12": VIEW_SITE_JC_REP_FTableAdapter rep_12 = new VIEW_SITE_JC_REP_FTableAdapter(); ReportPreview.LocalReport.DisplayName = Site_jc_name + "_Field_JC"; ReportPreview.LocalReport.ReportPath = "Erection\\Reports\\Field_JC_Combined.rdlc"; ReportPreview.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource( "dsErectionRepsA_VIEW_SITE_JC_REP_F", (DataTable)rep_12.GetData(decimal.Parse(JC_ID) ))); break; case "13": VIEW_SITE_JC_REP_GTableAdapter rep_13 = new VIEW_SITE_JC_REP_GTableAdapter(); ReportPreview.LocalReport.ReportPath = "Erection\\Reports\\Field_JC_Installation.rdlc"; ReportPreview.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource( "dsErectionRepsA_VIEW_SITE_JC_REP_G", (DataTable)rep_13.GetData(decimal.Parse(JC_ID) ))); break; case "14": VIEW_SITE_JC_SHORTAGETableAdapter rep_14 = new VIEW_SITE_JC_SHORTAGETableAdapter(); ReportPreview.LocalReport.ReportPath = "Erection\\Reports\\Field_JC_Shortage.rdlc"; ReportPreview.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource( "dsErectionRepsC_VIEW_SITE_JC_SHORTAGE", (DataTable)rep_14.GetData(decimal.Parse(JC_ID) ))); break; case "100": VIEW_SITE_JC_AVAILTableAdapter rep_100 = new VIEW_SITE_JC_AVAILTableAdapter(); ReportPreview.LocalReport.ReportPath = "Erection\\Reports\\Field_JC_Avail.rdlc"; ReportPreview.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource( "dsErectionRepsC_VIEW_SITE_JC_AVAIL", (DataTable)rep_100.GetData(decimal.Parse(Session["PROJECT_ID"].ToString()) ))); break; case "15": VIEW_SITE_REM_WORK_REPTableAdapter rep_15 = new VIEW_SITE_REM_WORK_REPTableAdapter(); ReportPreview.LocalReport.ReportPath = "Erection\\Reports\\Remaining_Work_Report.rdlc"; ReportPreview.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource( "dsErectionRepsC_VIEW_SITE_REM_WORK_REP", (DataTable)rep_15.GetData( decimal.Parse(JC_ID) ))); break; case "16": VIEW_BOM_REQUEST_REPTableAdapter rep_16 = new VIEW_BOM_REQUEST_REPTableAdapter(); ReportPreview.LocalReport.ReportPath = "Erection\\Reports\\BomRequest.rdlc"; ReportPreview.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource( "dsErectionA_VIEW_BOM_REQUEST_REP", (DataTable)rep_16.GetData( decimal.Parse(Request.QueryString["REQ_ID"]) ))); break; case "17": VIEW_BOM_RECV_REPTableAdapter rep_17 = new VIEW_BOM_RECV_REPTableAdapter(); ReportPreview.LocalReport.ReportPath = "Erection\\Reports\\BomReceive.rdlc"; ReportPreview.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource( "dsErectionB_VIEW_BOM_RECV_REP", (DataTable)rep_17.GetData( decimal.Parse(Request.QueryString["RECV_ID"]) ))); break; case "18": string site_miv_no = WebTools.GetExpr("ISSUE_NO", "PIP_MAT_ISSUE_LOOSE", "JC_ID=" + Request.QueryString["SITE_MIV_ID"].ToString()); VIEW_SITE_MIV_ISSUE_DETAILTableAdapter site_miv = new VIEW_SITE_MIV_ISSUE_DETAILTableAdapter(); ReportPreview.LocalReport.DisplayName = site_miv_no + " Site MIV Report"; ReportPreview.LocalReport.ReportPath = "Erection\\Reports\\SiteMIVReport.rdlc"; ReportPreview.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource( "dsErectionRepsC_VIEW_SITE_MIV_ISSUE_DETAIL", (DataTable)site_miv.GetData(decimal.Parse(Request.QueryString["SITE_MIV_ID"])))); break; case "20": ReportPreview.ProcessingMode = ProcessingMode.Local; ReportPreview.LocalReport.ReportPath = "SpoolFabJobCard\\Reports\\Site_Joints_jobcard.rdlc"; string query = "SELECT * from VIEW_SITE_JNTS_JC_RDLC WHERE JC_ID=" + decimal.Parse(Request.QueryString["JC_ID"]); DataTable table1 = General_Functions.GetDataTable(query); ReportDataSource datasource = new ReportDataSource("VIEW_SITE_JNTS_JC_RDLC", table1); ReportPreview.LocalReport.DataSources.Clear(); ReportPreview.LocalReport.DataSources.Add(datasource); break; } } }