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;
}
}
}
