예제 #1
0
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            string ReportID;
            String Arg1, Arg2, Arg3;
            ReportID = Request.QueryString["ReportID"];
            Arg1     = Request.QueryString["Arg1"];
            Arg2     = Request.QueryString["Arg2"];
            Arg3     = Request.QueryString["Arg3"];
            Master.HeadingMessage = "Preview Report";
            switch (ReportID)
            {
            case "1":
                VIEW_MAT_RET_REPTableAdapter rep_1 = new VIEW_MAT_RET_REPTableAdapter();
                ReportPreview.LocalReport.ReportPath = "Material\\Reports\\Return_Summary.rdlc";
                ReportPreview.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource(
                                                              "DataSet1",
                                                              (DataTable)rep_1.GetData(decimal.Parse(Arg1))));
                break;

            case "9":
                VIEW_MRIR_SUMMARYTableAdapter mrir = new VIEW_MRIR_SUMMARYTableAdapter();
                ReportPreview.LocalReport.ReportPath = "Material\\Reports\\MRV_Report.rdlc";
                ReportPreview.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource(
                                                              "DataSet1",
                                                              (DataTable)mrir.GetData(decimal.Parse(Arg1))));
                break;

            case "10":
                VIEW_MRIR_ESDTableAdapter mrir_a = new VIEW_MRIR_ESDTableAdapter();
                //ReportPreview.LocalReport.ReportPath = "Material\\Reports\\Piping_MRIR_Summary.rdlc";
                ReportPreview.LocalReport.ReportPath = "Material\\Reports\\MIR_Report.rdlc";
                ReportPreview.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource(
                                                              "DataSet1",
                                                              (DataTable)mrir_a.GetData(decimal.Parse(Arg1))));
                break;

            case "10.1":
                VIEW_PRE_MRIRTableAdapter mrir_b = new VIEW_PRE_MRIRTableAdapter();
                ReportPreview.LocalReport.ReportPath = "Material\\Reports\\PRE_MIR_Report.rdlc";
                ReportPreview.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource(
                                                              "DataSet1",
                                                              (DataTable)mrir_b.GetData(decimal.Parse(Arg1))));
                break;

            case "11":
                VIEW_ADD_ISSUE_REPTableAdapter add_miv = new VIEW_ADD_ISSUE_REPTableAdapter();
                ReportPreview.LocalReport.ReportPath = "Material\\Reports\\AddMIV_Summary.rdlc";
                ReportPreview.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource(
                                                              "dsMatIssueA_VIEW_ADD_ISSUE_REP",
                                                              (DataTable)add_miv.GetData(decimal.Parse(Arg1))));
                break;

            case "12":
                VIEW_ADD_ISSUE_REM_REPTableAdapter add_miv_rem = new VIEW_ADD_ISSUE_REM_REPTableAdapter();
                ReportPreview.LocalReport.ReportPath = "Material\\Reports\\AddMIV_PipeRemain.rdlc";
                ReportPreview.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource(
                                                              "dsMatIssueA_VIEW_ADD_ISSUE_REM_REP",
                                                              (DataTable)add_miv_rem.GetData(decimal.Parse(Arg1))));
                break;

            case "12.1":
                VIEW_ADD_ISSUE_BOM_REPTableAdapter add_miv_bom = new VIEW_ADD_ISSUE_BOM_REPTableAdapter();
                ReportPreview.LocalReport.ReportPath = "Material\\Reports\\AddMIV_BOM.rdlc";
                ReportPreview.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource(
                                                              "dsMatIssueA_VIEW_ADD_ISSUE_BOM_REP",
                                                              (DataTable)add_miv_bom.GetData(decimal.Parse(Arg1))));
                break;

            case "13":
            case "13.1":
                VIEW_PAINT_BLK_REPTableAdapter blk_pnt = new VIEW_PAINT_BLK_REPTableAdapter();
                if (ReportID == "13")
                {
                    ReportPreview.LocalReport.ReportPath = "Material\\Reports\\Bulk_Paint.rdlc";
                }
                else
                {
                    ReportPreview.LocalReport.ReportPath = "Material\\Reports\\Bulk_Paint_MaterialReq.rdlc";
                }
                ReportPreview.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource(
                                                              "dsMatReportA_VIEW_PAINT_BLK_REP",
                                                              (DataTable)blk_pnt.GetData(Decimal.Parse(Arg1))));
                break;

            case "22":
                VIEW_MAT_TRANSF_REPTableAdapter mat_transf = new VIEW_MAT_TRANSF_REPTableAdapter();
                ReportPreview.LocalReport.ReportPath = "Material\\Reports\\Material_Transfer.rdlc";
                ReportPreview.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource(
                                                              "dsMatReportA_VIEW_MAT_TRANSF_REP",
                                                              (DataTable)mat_transf.GetData(Decimal.Parse(Arg1))));
                break;

            case "23":
                VIEW_TOTAL_SUBSTITUTETableAdapter mat_sub = new VIEW_TOTAL_SUBSTITUTETableAdapter();
                ReportPreview.LocalReport.ReportPath = "Material\\Reports\\Material_Substitution.rdlc";
                ReportPreview.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource(
                                                              "DataSet1",
                                                              (DataTable)mat_sub.GetData(Decimal.Parse(Arg1))));
                break;

            case "24":
                VIEW_MAT_REUSE_REPTableAdapter mat_reuse = new VIEW_MAT_REUSE_REPTableAdapter();
                ReportPreview.LocalReport.ReportPath = "Material\\Reports\\Material_Reuse.rdlc";
                ReportPreview.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource(
                                                              "DataSet1",
                                                              (DataTable)mat_reuse.GetData(Decimal.Parse(Arg1))));
                break;

            case "30":
                VIEW_TOTAL_POTableAdapter rep_30 = new VIEW_TOTAL_POTableAdapter();
                ReportPreview.LocalReport.ReportPath = "Material\\Reports\\PO_Report.rdlc";
                ReportPreview.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource(
                                                              "DataSet1",
                                                              (DataTable)rep_30.GetData(Decimal.Parse(Arg1))));
                break;

            case "31":
                //VIEW_TOTAL_POTableAdapter rep_31 = new VIEW_TOTAL_POTableAdapter();
                VIEW_MATERIAL_REQUEST_REPTableAdapter rep_31 = new VIEW_MATERIAL_REQUEST_REPTableAdapter();
                ReportPreview.LocalReport.ReportPath = "Material\\Reports\\Material_Request.rdlc";
                ReportPreview.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource(
                                                              "DataSet1",
                                                              (DataTable)rep_31.GetData(Decimal.Parse(Arg1))));
                break;

            case "32":
                dsMaterialDTableAdapters.VIEW_QUARANTINE_REPTableAdapter rep_32 = new dsMaterialDTableAdapters.VIEW_QUARANTINE_REPTableAdapter();
                ReportPreview.LocalReport.ReportPath = "Material\\Reports\\QuanrantineSummary.rdlc";
                ReportPreview.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource(
                                                              "DataSet1",
                                                              (DataTable)rep_32.GetData(Decimal.Parse(Arg1))));
                break;

            case "33":
                dsMaterialETableAdapters.VIEW_MAT_TRANSFER_RCV_REPTableAdapter rep_33 = new dsMaterialETableAdapters.VIEW_MAT_TRANSFER_RCV_REPTableAdapter();
                ReportPreview.LocalReport.ReportPath = "Material\\Reports\\MaterialReceive_MTN.rdlc";
                ReportPreview.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource(
                                                              "DataSet1",
                                                              (DataTable)rep_33.GetData(Decimal.Parse(Arg1))));
                break;

            case "34":
                dsMatReportATableAdapters.VIEW_ESD_REPORTTableAdapter esd = new VIEW_ESD_REPORTTableAdapter();
                ReportPreview.LocalReport.ReportPath = "Material\\Reports\\ESD_Report.rdlc";
                ReportPreview.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource(
                                                              "dsProcReps_B_VIEW_ESD_REPORT",
                                                              (DataTable)esd.GetData(Decimal.Parse(Arg1))));
                break;
            }
        }
    }
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            string ReportID;
            String Arg1, Arg2, Arg3;
            ReportID = Request.QueryString["ReportID"];
            Arg1     = Request.QueryString["Arg1"];
            Arg2     = Request.QueryString["Arg2"];
            Arg3     = Request.QueryString["Arg3"];
            Master.HeadingMessage = "Preview Report";
            switch (ReportID)
            {
            case "1":
                VIEW_MAT_RET_REPTableAdapter rep_1 = new VIEW_MAT_RET_REPTableAdapter();
                ReportPreview.LocalReport.ReportPath = "Material\\Reports\\Return_Summary.rdlc";
                ReportPreview.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource(
                                                              "DataSet1",
                                                              (DataTable)rep_1.GetData(decimal.Parse(Arg1))));
                break;

            case "5":
                VIEW_MATERIAL_REQ_REPTableAdapter mat_req = new VIEW_MATERIAL_REQ_REPTableAdapter();
                ReportPreview.LocalReport.ReportPath = "Material\\Reports\\MaterialRequestForm.rdlc";
                ReportPreview.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource(
                                                              "dsMaterialD_VIEW_MATERIAL_REQ_REP",
                                                              (DataTable)mat_req.GetData(Decimal.Parse(Arg1))));
                break;

            case "9":
                VIEW_MRIR_SUMMARYTableAdapter mrir = new VIEW_MRIR_SUMMARYTableAdapter();
                ReportPreview.LocalReport.ReportPath = "Material\\Reports\\JcMRIR_Summary.rdlc";
                ReportPreview.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource(
                                                              "dsPO_ReportsA_VIEW_MRIR_SUMMARY",
                                                              (DataTable)mrir.GetData(decimal.Parse(Arg1))));
                break;

            case "9.1":
                VIEW_MRIR_SUMMARYTableAdapter mrir91 = new VIEW_MRIR_SUMMARYTableAdapter();
                ReportPreview.LocalReport.ReportPath = "Material\\Reports\\Material_Receive_Report.rdlc";
                ReportPreview.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource(
                                                              "DataSet1",
                                                              (DataTable)mrir91.GetData(decimal.Parse(Arg1))));
                break;

            case "10":
                VIEW_MRIR_ESDTableAdapter mrir_a = new VIEW_MRIR_ESDTableAdapter();
                ReportPreview.LocalReport.ReportPath = "Material\\Reports\\Piping_MRIR_Summary.rdlc";
                ReportPreview.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource(
                                                              "DataSet1",
                                                              (DataTable)mrir_a.GetData(decimal.Parse(Arg1))));
                break;

            case "10.1":
                VIEW_MRIR_ESDTableAdapter mrir_b = new VIEW_MRIR_ESDTableAdapter();
                ReportPreview.LocalReport.ReportPath = "Material\\Reports\\MatInsp_cpecc.rdlc";
                ReportPreview.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource(
                                                              "DataSet1",
                                                              (DataTable)mrir_b.GetData(decimal.Parse(Arg1))));
                break;

            case "10.2":
                dsMaterialETableAdapters.VIEW_MAT_INSP_REQUEST_REPTableAdapter mrir_c = new dsMaterialETableAdapters.VIEW_MAT_INSP_REQUEST_REPTableAdapter();
                ReportPreview.LocalReport.ReportPath = "Material\\Reports\\MatInsp_cpecc.rdlc";
                ReportPreview.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource(
                                                              "DataSet1",
                                                              (DataTable)mrir_c.GetData(decimal.Parse(Arg1))));
                break;

            case "11":
                VIEW_ADD_ISSUE_REPTableAdapter add_miv = new VIEW_ADD_ISSUE_REPTableAdapter();
                ReportPreview.LocalReport.ReportPath = "Material\\Reports\\AddMIV_Summary.rdlc";
                ReportPreview.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource(
                                                              "dsMatIssueA_VIEW_ADD_ISSUE_REP",
                                                              (DataTable)add_miv.GetData(decimal.Parse(Arg1))));
                break;

            case "11.1":
                VIEW_ADD_ISSUE_REPTableAdapter add_miv1 = new VIEW_ADD_ISSUE_REPTableAdapter();
                ReportPreview.LocalReport.ReportPath = "Material\\Reports\\MaterialIssue_cpecc.rdlc";
                ReportPreview.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource(
                                                              "DataSet1",
                                                              (DataTable)add_miv1.GetData(decimal.Parse(Arg1))));
                break;

            case "12":
                VIEW_ADD_ISSUE_REM_REPTableAdapter add_miv_rem = new VIEW_ADD_ISSUE_REM_REPTableAdapter();
                ReportPreview.LocalReport.ReportPath = "Material\\Reports\\AddMIV_PipeRemain.rdlc";
                ReportPreview.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource(
                                                              "dsMatIssueA_VIEW_ADD_ISSUE_REM_REP",
                                                              (DataTable)add_miv_rem.GetData(decimal.Parse(Arg1))));
                break;

            case "12.1":
                VIEW_ADD_ISSUE_BOM_REPTableAdapter add_miv_bom = new VIEW_ADD_ISSUE_BOM_REPTableAdapter();
                ReportPreview.LocalReport.ReportPath = "Material\\Reports\\AddMIV_BOM.rdlc";
                ReportPreview.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource(
                                                              "dsMatIssueA_VIEW_ADD_ISSUE_BOM_REP",
                                                              (DataTable)add_miv_bom.GetData(decimal.Parse(Arg1))));
                break;

            case "13":
            case "13.1":
                VIEW_PAINT_BLK_REPTableAdapter blk_pnt = new VIEW_PAINT_BLK_REPTableAdapter();
                if (ReportID == "13")
                {
                    ReportPreview.LocalReport.ReportPath = "Material\\Reports\\Bulk_Paint.rdlc";
                }
                else
                {
                    ReportPreview.LocalReport.ReportPath = "Material\\Reports\\Bulk_Paint_MaterialReq.rdlc";
                }
                ReportPreview.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource(
                                                              "dsMatReportA_VIEW_PAINT_BLK_REP",
                                                              (DataTable)blk_pnt.GetData(Decimal.Parse(Arg1))));
                break;

            case "22":
                VIEW_MAT_TRANSF_REPTableAdapter mat_transf = new VIEW_MAT_TRANSF_REPTableAdapter();
                ReportPreview.LocalReport.ReportPath = "Material\\Reports\\Material_Transfer.rdlc";
                ReportPreview.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource(
                                                              "dsMatReportA_VIEW_MAT_TRANSF_REP",
                                                              (DataTable)mat_transf.GetData(Decimal.Parse(Arg1))));
                break;

            case "23":
                VIEW_TOTAL_SUBSTITUTETableAdapter mat_sub = new VIEW_TOTAL_SUBSTITUTETableAdapter();
                ReportPreview.LocalReport.ReportPath = "Material\\Reports\\Material_Substitution.rdlc";
                ReportPreview.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource(
                                                              "DataSet1",
                                                              (DataTable)mat_sub.GetData(Decimal.Parse(Arg1))));
                break;

            case "24":
                VIEW_MAT_REUSE_REPTableAdapter mat_reuse = new VIEW_MAT_REUSE_REPTableAdapter();
                ReportPreview.LocalReport.ReportPath = "Material\\Reports\\Material_Reuse.rdlc";
                ReportPreview.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource(
                                                              "DataSet1",
                                                              (DataTable)mat_reuse.GetData(Decimal.Parse(Arg1))));
                break;

            case "30":
                VIEW_TOTAL_POTableAdapter rep_30 = new VIEW_TOTAL_POTableAdapter();
                ReportPreview.LocalReport.ReportPath = "Material\\Reports\\PO_Report.rdlc";
                ReportPreview.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource(
                                                              "DataSet1",
                                                              (DataTable)rep_30.GetData(Decimal.Parse(Arg1))));
                break;

            case "32":
                dsMaterialDTableAdapters.VIEW_QUARANTINE_REPTableAdapter rep_32 = new dsMaterialDTableAdapters.VIEW_QUARANTINE_REPTableAdapter();
                ReportPreview.LocalReport.ReportPath = "Material\\Reports\\QuanrantineSummary.rdlc";
                ReportPreview.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource(
                                                              "DataSet1",
                                                              (DataTable)rep_32.GetData(Decimal.Parse(Arg1))));
                break;

            case "33":
                dsMaterialETableAdapters.VIEW_MAT_TRANSFER_RCV_REPTableAdapter rep_33 = new dsMaterialETableAdapters.VIEW_MAT_TRANSFER_RCV_REPTableAdapter();
                ReportPreview.LocalReport.ReportPath = "Material\\Reports\\MaterialReceive_MTN.rdlc";
                ReportPreview.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource(
                                                              "DataSet1",
                                                              (DataTable)rep_33.GetData(Decimal.Parse(Arg1))));
                break;

            case "34":
                dsMaterialBTableAdapters.VIEW_ESD_REPORTTableAdapter esd = new dsMaterialBTableAdapters.VIEW_ESD_REPORTTableAdapter();
                ReportPreview.LocalReport.ReportPath = "Material\\Reports\\ESD_Report.rdlc";
                ReportPreview.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource(
                                                              "dsProcReps_B_VIEW_ESD_REPORT",
                                                              (DataTable)esd.GetData(Decimal.Parse(Arg1))));
                break;

            case "35":     //MRR_Weekly_Report
                VIEW_MRR_WEEKLY_REPORTTableAdapter MRRWeekly_Rep = new VIEW_MRR_WEEKLY_REPORTTableAdapter();
                ReportPreview.LocalReport.ReportPath = "Material\\Reports\\MRR_Weekly_Report.rdlc";
                ReportPreview.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource(
                                                              "MRRWeeklyReport",
                                                              (DataTable)MRRWeekly_Rep.GetData(DateTime.Parse(Arg1),
                                                                                               DateTime.Parse(Arg2))));
                break;

            case "36":      //MIV_Weekly_Report
                dsPO_ShipmentATableAdapters.VIEW_ADAPTER_ISSUE_ADD_DETAILTableAdapter MIVreport = new dsPO_ShipmentATableAdapters.VIEW_ADAPTER_ISSUE_ADD_DETAILTableAdapter();
                ReportPreview.LocalReport.ReportPath = "Material\\Reports\\MIV_Weekly_Report.rdlc";
                ReportPreview.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource(
                                                              "MIVWeeklyReport",
                                                              (DataTable)MIVreport.GetData(DateTime.Parse(Arg1),
                                                                                           DateTime.Parse(Arg2))));
                break;

            case "37":     //VIEW_DPR_WEEKLY
                VIEW_DPR_WEEKLYTableAdapter DPRWeekly_Rep = new VIEW_DPR_WEEKLYTableAdapter();
                ReportPreview.LocalReport.ReportPath = "Material\\Reports\\DPR_Weekly_Report.rdlc";
                ReportPreview.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource(
                                                              "VIEW_DPR_WEEKLY",
                                                              (DataTable)DPRWeekly_Rep.GetData(Arg1, Arg2)));

                VIEW_DPR_PIP_WEEKLYTableAdapter DPRPIPWeekly_Rep = new VIEW_DPR_PIP_WEEKLYTableAdapter();
                ReportPreview.LocalReport.ReportPath = "Material\\Reports\\DPR_Weekly_Report.rdlc";
                ReportPreview.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource(
                                                              "VIEW_DPR_PIP_WEEKLY",
                                                              (DataTable)DPRPIPWeekly_Rep.GetData(Arg1, Arg2)));
                VIEW_DPR_ELEC_WEEKLYTableAdapter DPRelecWeekly_Rep = new VIEW_DPR_ELEC_WEEKLYTableAdapter();
                ReportPreview.LocalReport.ReportPath = "Material\\Reports\\DPR_Weekly_Report.rdlc";
                ReportPreview.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource(
                                                              "VIEW_DPR_ELEC_WEEKLY",
                                                              (DataTable)DPRelecWeekly_Rep.GetData(Arg1, Arg2)));
                break;
            }
        }
    }