Пример #1
0
    public static string SendReportMessage(string TabContainerControl, //頁籤
                                           string txt_T1_YearMonth_SControl, //結帳年月起T1
                                           string txt_T1_YearMonth_EControl, //結帳年月迄T1
                                           string SLP_T1_ProfitCenter_SControl, //利潤中心起T1
                                           string SLP_T1_ProfitCenter_EControl, //利潤中心迄T1
                                           string txt_T2_YearMonth_SControl, //結帳年月起T2
                                           string txt_T2_YearMonth_EControl, //結帳年月迄T2
                                           string SLP_T2_DUE_DATEControl, //帳款到期日T2
                                           string SLP_T2_DUE_DATE_RANGE_SControl, //帳款區間起T2
                                           string SLP_T2_DUE_DATE_RANGE_EControl, //帳款區間迄T2
                                           string SLP_T2_INV_DATE_SControl, //憑證開立日起T2
                                           string SLP_T2_INV_DATE_EControl, //憑證開立日迄T2
                                           string SLP_T2_ProfitCenter_SControl, //利潤中心起T2
                                           string SLP_T2_ProfitCenter_EControl, //利潤中心迄T2
                                           string SLP_T2_StoreGroup_SControl, //店群起T2
                                           string SLP_T2_StoreGroup_EControl, //店群迄T2
                                           string txt_T2_RFNOControl, //結帳統編T2
                                           string txt_T2_VOUCH_RFNOControl, //統一編號T2
                                           string SLP_T2_Z_O_SControl, //營業所起T2
                                           string SLP_T2_Z_O_EControl, //營業所迄T2
                                           string SLP_T2_STORE_IDControl, //店號T2
                                           string SLP_T2_RootNoControl, //商品群分類T2
                                           string SLP_T2_SAL_IDControl, //營業人員T2
                                           string SLP_T2_AC_IDControl, //帳務人員T2
                                           string rbl_T2_CLOSEControl, //是否結案(=2為已結案,<>2為未結案)T2
                                           string txt_T3_YearMonth_SControl, //結帳年月起T3
                                           string txt_T3_YearMonth_EControl, //結帳年月迄T3
                                           string SLP_T3_DUE_DATEControl, //帳款到期日T3
                                           string SLP_T3_DUE_DATE_RANGE_SControl, //帳款區間起T3
                                           string SLP_T3_DUE_DATE_RANGE_EControl, //帳款區間迄T3
                                           string SLP_T3_INV_DATE_SControl, //憑證開立日起T3
                                           string SLP_T3_INV_DATE_EControl, //憑證開立日迄T3
                                           string SLP_T3_ProfitCenter_SControl, //利潤中心起T3
                                           string SLP_T3_ProfitCenter_EControl, //利潤中心迄T3
                                           string SLP_T3_StoreGroup_SControl, //店群起T3
                                           string SLP_T3_StoreGroup_EControl, //店群迄T3
                                           string txt_T3_RFNOControl, //結帳統編T3
                                           string txt_T3_VOUCH_RFNOControl, //統一編號T3
                                           string SLP_T3_Z_O_SControl, //營業所起T3
                                           string SLP_T3_Z_O_EControl, //營業所迄T3
                                           string SLP_T3_STORE_IDControl, //店號T3
                                           string SLP_T3_RootNoControl, //商品群分類T3
                                           string SLP_T3_SAL_IDControl, //營業人員T3
                                           string SLP_T3_AC_IDControl, //帳務人員T3
                                           string rbl_T3_CLOSEControl, //是否結案(=2為已結案,<>2為未結案)T3
                                           string txt_T4_YearMonth_SControl, //結帳年月起T4
                                           string txt_T4_YearMonth_EControl, //結帳年月迄T4
                                           string SLP_T4_APLDATE_RANGE_SControl, //生活日起T4
                                           string SLP_T4_APLDATE_RANGE_EControl, //生活日迄T4
                                           string SLP_T4_StoreGroup_SControl, //店群起T4
                                           string SLP_T4_StoreGroup_EControl, //店群迄T4
                                           string txt_T4_RFNOControl, //結帳統編T4
                                           string txt_T4_VOUCH_RFNOControl, //統一編號T4
                                           string SLP_T4_Z_O_SControl, //營業所起T4
                                           string SLP_T4_Z_O_EControl, //營業所迄T4
                                           string SLP_T4_STORE_IDControl, //店號T4
                                           string SLP_T4_RootNoControl, //商品群分類T4
                                           string SLP_T4_SAL_IDControl, //營業人員T4
                                           string SLP_T4_AC_IDControl, //帳務人員T4
                                           string rbl_T4_CLOSEControl, //是否結案(=2為已結案,<>2為未結案)T4
                                           string txt_T6_YearMonth_SControl, //結帳年月起T6
                                           string txt_T6_YearMonth_EControl, //結帳年月迄T6
                                           string SLP_T6_DUE_DATEControl, //帳款到期日T6
                                           string SLP_T6_DUE_DATE_RANGE_SControl, //帳款區間起T6
                                           string SLP_T6_DUE_DATE_RANGE_EControl, //帳款區間迄T6
                                           string SLP_T6_StoreGroup_SControl, //店群起T6
                                           string SLP_T6_StoreGroup_EControl, //店群迄T6
                                           string txt_T6_RFNOControl, //結帳統編T6
                                           string txt_T6_VOUCH_RFNOControl, //統一編號T6
                                           string SLP_T6_Z_O_SControl, //營業所起T6
                                           string SLP_T6_Z_O_EControl, //營業所迄T6
                                           string SLP_T6_STORE_IDControl, //店號T6
                                           string SLP_T6_SAL_IDControl, //營業人員T6
                                           string SLP_T6_AC_IDControl, //帳務人員T6
                                           string rbl_T6_CLOSEControl, //是否結案(=2為已結案,<>2為未結案)T6
                                           string UserIdControl,
                                           string UserNameControl,
                                           string N_SLP_T1_ProfitCenter_SControl, //利潤中心起T1
                                           string N_SLP_T1_ProfitCenter_EControl, //利潤中心迄T1
                                           string N_SLP_T2_ProfitCenter_SControl, //利潤中心起T2
                                           string N_SLP_T2_ProfitCenter_EControl, //利潤中心迄T2
                                           string N_SLP_T2_StoreGroup_SControl, //店群起T2
                                           string N_SLP_T2_StoreGroup_EControl, //店群迄T2
                                           string N_SLP_T2_STORE_IDControl, //店號T2
                                           string N_SLP_T2_RootNoControl, //商品群類類T2
                                           string N_SLP_T2_SAL_IDControl, //營業人員T2
                                           string N_SLP_T2_AC_IDControl, //帳務人員T2
                                           string N_SLP_T3_ProfitCenter_SControl, //利潤中心起T3
                                           string N_SLP_T3_ProfitCenter_EControl, //利潤中心迄T3
                                           string N_SLP_T3_StoreGroup_SControl, //店群起T3
                                           string N_SLP_T3_StoreGroup_EControl, //店群迄T3
                                           string N_SLP_T3_STORE_IDControl, //店號T3
                                           string N_SLP_T3_RootNoControl, //商品群類類T3
                                           string N_SLP_T3_SAL_IDControl, //營業人員T3
                                           string N_SLP_T3_AC_IDControl, //帳務人員T3
                                           string N_SLP_T4_StoreGroup_SControl, //店群起T4
                                           string N_SLP_T4_StoreGroup_EControl, //店群迄T4
                                           string N_SLP_T4_STORE_IDControl, //店號T4
                                           string N_SLP_T4_RootNoControl, //商品群類類T4   
                                           string N_SLP_T4_SAL_IDControl, //營業人員T4
                                           string N_SLP_T4_AC_IDControl, //帳務人員T4
                                           string N_SLP_T6_StoreGroup_SControl, //店群起T6
                                           string N_SLP_T6_StoreGroup_EControl, //店群迄T6
                                           string N_SLP_T6_STORE_IDControl, //店號T6
                                           string N_SLP_T6_SAL_IDControl, //營業人員T6
                                           string N_SLP_T6_AC_IDControl, //帳務人員T6
                                           string txt_T3_AcctYearMonth_SControl, //結帳年月-財會起T3
                                           string txt_T3_AcctYearMonth_EControl, //結帳年月-財會迄T3
                                           string txt_T2_AcctYearMonth_SControl, //結帳年月-財會起T2
                                           string txt_T2_AcctYearMonth_EControl, //結帳年月-財會迄T2
                                           string rbl_T4_MonthTypeControl,//查詢方式T4 
                                           string src)
    {
        string ReportCode = "CAA31_1";

        #region DB需要的變數、報表變數 送出產生報表

        string ProcessLogFile = "";
        CAA_CAA311 CAARPTPage = new CAA_CAA311();
        string ReportPath = "", ReportName = "";
        ReportParameter[] DBParameter = new ReportParameter[0];
        ReportParameter[] CryReportParameter = new ReportParameter[0];

        switch (TabContainerControl)
        {
            case "0": //Tab1
                DBParameter = new ReportParameter[5];
                DBParameter[0].ParameterName = "結帳年月起T1";
                DBParameter[0].ParameterValue = EmptyPar(txt_T1_YearMonth_SControl, txt_T1_YearMonth_EControl);
                DBParameter[1].ParameterName = "結帳年月迄T1";
                DBParameter[1].ParameterValue = EmptyPar(txt_T1_YearMonth_EControl, txt_T1_YearMonth_SControl);
                DBParameter[2].ParameterName = "利潤中心起T1";
                DBParameter[2].ParameterValue = EmptyPar(SLP_T1_ProfitCenter_SControl, SLP_T1_ProfitCenter_EControl);
                DBParameter[3].ParameterName = "利潤中心迄T1";
                DBParameter[3].ParameterValue = EmptyPar(SLP_T1_ProfitCenter_EControl, SLP_T1_ProfitCenter_SControl);
                DBParameter[4].ParameterName = "TabContainerT1";
                DBParameter[4].ParameterValue = TabContainerControl; //傳給ReportService以便判斷使用那個Procedure


                if (src == "1")
                {
                    CryReportParameter = new ReportParameter[5];
                    CryReportParameter[0].ParameterName = "par_Program_ID";
                    CryReportParameter[0].ParameterValue = "CAA31R02";
                    CryReportParameter[1].ParameterName = "par_LoginUser";
                    CryReportParameter[1].ParameterValue = UserIdControl;
                    CryReportParameter[2].ParameterName = "par_LoginName";
                    CryReportParameter[2].ParameterValue = UserNameControl;
                    CryReportParameter[3].ParameterName = "par_1";
                    CryReportParameter[3].ParameterValue = Merge2Para(txt_T1_YearMonth_SControl, txt_T1_YearMonth_EControl);
                    CryReportParameter[4].ParameterName = "par_2";
                    CryReportParameter[4].ParameterValue = Merge2Para((SLP_T1_ProfitCenter_SControl == "" ? "" : (SLP_T1_ProfitCenter_SControl + " " + N_SLP_T1_ProfitCenter_SControl)), (SLP_T1_ProfitCenter_EControl == "" ? "" : (SLP_T1_ProfitCenter_EControl + " " + N_SLP_T1_ProfitCenter_EControl)));

                    ReportPath = "./REPORT/CAA311/CAA31R02.rpt";
                }
                else
                { ReportPath = "./REPORT/CAA311/CAA31R02xls.rpt"; }

                ReportName = "應收/應付帳款餘額";

                break;
            case "1": //Tab2

                DBParameter = new ReportParameter[23];
                DBParameter[0].ParameterName = "結帳年月起T2";
                DBParameter[0].ParameterValue = EmptyPar(txt_T2_YearMonth_SControl, txt_T2_YearMonth_EControl);
                DBParameter[1].ParameterName = "結帳年月迄T2";
                DBParameter[1].ParameterValue = EmptyPar(txt_T2_YearMonth_EControl, txt_T2_YearMonth_SControl);
                DBParameter[2].ParameterName = "帳款到期日T2";
                DBParameter[2].ParameterValue = SLP_T2_DUE_DATEControl;
                DBParameter[3].ParameterName = "帳款區間起T2";
                DBParameter[3].ParameterValue = SLP_T2_DUE_DATE_RANGE_SControl;
                DBParameter[4].ParameterName = "帳款區間迄T2";
                DBParameter[4].ParameterValue = SLP_T2_DUE_DATE_RANGE_EControl;
                DBParameter[5].ParameterName = "憑證開立日起T2";
                DBParameter[5].ParameterValue = EmptyPar(SLP_T2_INV_DATE_SControl, SLP_T2_INV_DATE_EControl); ;
                DBParameter[6].ParameterName = "憑證開立日迄T2";
                DBParameter[6].ParameterValue = EmptyPar(SLP_T2_INV_DATE_EControl, SLP_T2_INV_DATE_SControl); ;
                DBParameter[7].ParameterName = "利潤中心起T2";
                DBParameter[7].ParameterValue = EmptyPar(SLP_T2_ProfitCenter_SControl, SLP_T2_ProfitCenter_EControl);
                DBParameter[8].ParameterName = "利潤中心迄T2";
                DBParameter[8].ParameterValue = EmptyPar(SLP_T2_ProfitCenter_EControl, SLP_T2_ProfitCenter_SControl);
                DBParameter[9].ParameterName = "店群起T2";
                DBParameter[9].ParameterValue = EmptyPar(SLP_T2_StoreGroup_SControl, SLP_T2_StoreGroup_EControl); ;
                DBParameter[10].ParameterName = "店群迄T2";
                DBParameter[10].ParameterValue = EmptyPar(SLP_T2_StoreGroup_EControl, SLP_T2_StoreGroup_SControl); ;
                DBParameter[11].ParameterName = "結帳統編T2";
                DBParameter[11].ParameterValue = txt_T2_RFNOControl;
                DBParameter[12].ParameterName = "營業所起T2";
                DBParameter[12].ParameterValue = EmptyPar(SLP_T2_Z_O_SControl, SLP_T2_Z_O_EControl);
                DBParameter[13].ParameterName = "營業所迄T2";
                DBParameter[13].ParameterValue = EmptyPar(SLP_T2_Z_O_EControl, SLP_T2_Z_O_SControl); ;
                DBParameter[14].ParameterName = "店號T2";
                DBParameter[14].ParameterValue = SLP_T2_STORE_IDControl;
                DBParameter[15].ParameterName = "營業人員T2";
                DBParameter[15].ParameterValue = SLP_T2_SAL_IDControl;
                DBParameter[16].ParameterName = "帳務人員T2";
                DBParameter[16].ParameterValue = SLP_T2_AC_IDControl;
                DBParameter[17].ParameterName = "是否結案(=2為已結案,<>2為未結案)T2";
                DBParameter[17].ParameterValue = rbl_T2_CLOSEControl;
                DBParameter[18].ParameterName = "統一編號T2";
                DBParameter[18].ParameterValue = txt_T2_VOUCH_RFNOControl;                
                DBParameter[19].ParameterName = "商品群分類T2";
                DBParameter[19].ParameterValue = SLP_T2_RootNoControl;
                DBParameter[20].ParameterName = "結帳年月-財會起T2";
                DBParameter[20].ParameterValue = EmptyPar(txt_T2_AcctYearMonth_SControl, txt_T2_AcctYearMonth_EControl);
                DBParameter[21].ParameterName = "結帳年月-財會迄T2";
                DBParameter[21].ParameterValue = EmptyPar(txt_T2_AcctYearMonth_EControl, txt_T2_AcctYearMonth_SControl);
                DBParameter[22].ParameterName = "TabContainerT2";
                DBParameter[22].ParameterValue = TabContainerControl;

                if (src == "1")
                {
                    CryReportParameter = new ReportParameter[17];
                    CryReportParameter[0].ParameterName = "par_Program_ID";
                    CryReportParameter[0].ParameterValue = "CAA31R04";
                    CryReportParameter[1].ParameterName = "par_LoginUser";
                    CryReportParameter[1].ParameterValue = UserIdControl;
                    CryReportParameter[2].ParameterName = "par_LoginName";
                    CryReportParameter[2].ParameterValue = UserNameControl;
                    CryReportParameter[3].ParameterName = "par_1";
                    CryReportParameter[3].ParameterValue = Merge2Para(txt_T2_YearMonth_SControl, txt_T2_YearMonth_EControl);
                    CryReportParameter[4].ParameterName = "par_2";
                    CryReportParameter[4].ParameterValue = SLP_T2_DUE_DATEControl;
                    CryReportParameter[5].ParameterName = "par_3";
                    CryReportParameter[5].ParameterValue = Merge2Para(SLP_T2_DUE_DATE_RANGE_SControl, SLP_T2_DUE_DATE_RANGE_EControl);
                    CryReportParameter[6].ParameterName = "par_4";
                    CryReportParameter[6].ParameterValue = Merge2Para(SLP_T2_INV_DATE_SControl, SLP_T2_INV_DATE_EControl);
                    CryReportParameter[7].ParameterName = "par_5";
                    CryReportParameter[7].ParameterValue = CombineFromTo(SLP_T2_ProfitCenter_SControl, N_SLP_T2_ProfitCenter_SControl, SLP_T2_ProfitCenter_EControl, N_SLP_T2_ProfitCenter_EControl);
                    CryReportParameter[8].ParameterName = "par_6";
                    CryReportParameter[8].ParameterValue = CombineFromTo(SLP_T2_StoreGroup_SControl, N_SLP_T2_StoreGroup_SControl, SLP_T2_StoreGroup_EControl, N_SLP_T2_StoreGroup_EControl);
                    CryReportParameter[9].ParameterName = "par_7";
                    CryReportParameter[9].ParameterValue = txt_T2_RFNOControl;
                    CryReportParameter[10].ParameterName = "par_8";
                    CryReportParameter[10].ParameterValue = SLP_T2_STORE_IDControl + " " + N_SLP_T2_STORE_IDControl;
                    CryReportParameter[11].ParameterName = "par_9";
                    CryReportParameter[11].ParameterValue = Merge2Para(Get_Z_O_Name(SLP_T2_Z_O_SControl), Get_Z_O_Name(SLP_T2_Z_O_EControl));
                    CryReportParameter[12].ParameterName = "par_10";
                    CryReportParameter[12].ParameterValue = SLP_T2_SAL_IDControl + " " + N_SLP_T2_SAL_IDControl;
                    CryReportParameter[13].ParameterName = "par_11";
                    CryReportParameter[13].ParameterValue = SLP_T2_AC_IDControl + " " + N_SLP_T2_AC_IDControl;
                    CryReportParameter[14].ParameterName = "par_12";
                    CryReportParameter[14].ParameterValue = (rbl_T2_CLOSEControl == "1" ? "未結案" : (rbl_T2_CLOSEControl == "2" ? "已結案" : "全部"));
                    CryReportParameter[15].ParameterName = "par_13";
                    CryReportParameter[15].ParameterValue = SLP_T2_RootNoControl + " " + N_SLP_T2_RootNoControl;
                    CryReportParameter[16].ParameterName = "par_14";
                    CryReportParameter[16].ParameterValue = Merge2Para(txt_T2_AcctYearMonth_SControl, txt_T2_AcctYearMonth_EControl);

                    ReportPath = "./REPORT/CAA311/CAA31R04.rpt";
                }
                else
                { ReportPath = "./REPORT/CAA311/CAA31R04xls.rpt"; }

                ReportName = "應收帳款餘額明細表";

                break;
            case "2": //Tab3

                DBParameter = new ReportParameter[23];
                DBParameter[0].ParameterName = "結帳年月起T3";
                DBParameter[0].ParameterValue = EmptyPar(txt_T3_YearMonth_SControl, txt_T3_YearMonth_EControl);
                DBParameter[1].ParameterName = "結帳年月迄T3";
                DBParameter[1].ParameterValue = EmptyPar(txt_T3_YearMonth_EControl, txt_T3_YearMonth_SControl);
                DBParameter[2].ParameterName = "帳款到期日T3";
                DBParameter[2].ParameterValue = SLP_T3_DUE_DATEControl;
                DBParameter[3].ParameterName = "帳款區間起T3";
                DBParameter[3].ParameterValue = SLP_T3_DUE_DATE_RANGE_SControl;
                DBParameter[4].ParameterName = "帳款區間迄T3";
                DBParameter[4].ParameterValue = SLP_T3_DUE_DATE_RANGE_EControl;
                DBParameter[5].ParameterName = "憑證開立日起T3";
                DBParameter[5].ParameterValue = EmptyPar(SLP_T3_INV_DATE_SControl, SLP_T3_INV_DATE_EControl); ;
                DBParameter[6].ParameterName = "憑證開立日迄T3";
                DBParameter[6].ParameterValue = EmptyPar(SLP_T3_INV_DATE_EControl, SLP_T3_INV_DATE_SControl); ;
                DBParameter[7].ParameterName = "利潤中心起T3";
                DBParameter[7].ParameterValue = EmptyPar(SLP_T3_ProfitCenter_SControl, SLP_T3_ProfitCenter_EControl);
                DBParameter[8].ParameterName = "利潤中心迄T3";
                DBParameter[8].ParameterValue = EmptyPar(SLP_T3_ProfitCenter_EControl, SLP_T3_ProfitCenter_SControl);
                DBParameter[9].ParameterName = "店群起T3";
                DBParameter[9].ParameterValue = EmptyPar(SLP_T3_StoreGroup_SControl, SLP_T3_StoreGroup_EControl); ;
                DBParameter[10].ParameterName = "店群迄T3";
                DBParameter[10].ParameterValue = EmptyPar(SLP_T3_StoreGroup_EControl, SLP_T3_StoreGroup_SControl); ;
                DBParameter[11].ParameterName = "結帳統編T3";
                DBParameter[11].ParameterValue = txt_T3_RFNOControl;
                DBParameter[12].ParameterName = "營業所起T3";
                DBParameter[12].ParameterValue = EmptyPar(SLP_T3_Z_O_SControl, SLP_T3_Z_O_EControl);
                DBParameter[13].ParameterName = "營業所迄T3";
                DBParameter[13].ParameterValue = EmptyPar(SLP_T3_Z_O_EControl, SLP_T3_Z_O_SControl); ;
                DBParameter[14].ParameterName = "店號T3";
                DBParameter[14].ParameterValue = SLP_T3_STORE_IDControl;
                DBParameter[15].ParameterName = "營業人員T3";
                DBParameter[15].ParameterValue = SLP_T3_SAL_IDControl;
                DBParameter[16].ParameterName = "帳務人員T3";
                DBParameter[16].ParameterValue = SLP_T3_AC_IDControl;
                DBParameter[17].ParameterName = "是否結案(=2為已結案,<>2為未結案)T3";
                DBParameter[17].ParameterValue = rbl_T3_CLOSEControl;
                DBParameter[18].ParameterName = "統一編號T3";
                DBParameter[18].ParameterValue = txt_T3_VOUCH_RFNOControl;                
                DBParameter[19].ParameterName = "商品群分類T3";
                DBParameter[19].ParameterValue = SLP_T3_RootNoControl;
                DBParameter[20].ParameterName = "結帳年月-財會起T3";
                DBParameter[20].ParameterValue = EmptyPar(txt_T3_AcctYearMonth_SControl, txt_T3_AcctYearMonth_EControl);
                DBParameter[21].ParameterName = "結帳年月-財會迄T3";
                DBParameter[21].ParameterValue = EmptyPar(txt_T3_AcctYearMonth_EControl, txt_T3_AcctYearMonth_SControl);
                DBParameter[22].ParameterName = "TabContainerT3";
                DBParameter[22].ParameterValue = TabContainerControl;

                if (src == "1")
                {
                    CryReportParameter = new ReportParameter[17];
                    CryReportParameter[0].ParameterName = "par_Program_ID";
                    CryReportParameter[0].ParameterValue = "CAA31R03";
                    CryReportParameter[1].ParameterName = "par_LoginUser";
                    CryReportParameter[1].ParameterValue = UserIdControl;
                    CryReportParameter[2].ParameterName = "par_LoginName";
                    CryReportParameter[2].ParameterValue = UserNameControl;
                    CryReportParameter[3].ParameterName = "par_1";
                    CryReportParameter[3].ParameterValue = Merge2Para(txt_T3_YearMonth_SControl, txt_T3_YearMonth_EControl);
                    CryReportParameter[4].ParameterName = "par_2";
                    CryReportParameter[4].ParameterValue = SLP_T3_DUE_DATEControl;
                    CryReportParameter[5].ParameterName = "par_3";
                    CryReportParameter[5].ParameterValue = Merge2Para(SLP_T3_DUE_DATE_RANGE_SControl, SLP_T3_DUE_DATE_RANGE_EControl);
                    CryReportParameter[6].ParameterName = "par_4";
                    CryReportParameter[6].ParameterValue = Merge2Para(SLP_T3_INV_DATE_SControl, SLP_T3_INV_DATE_EControl);
                    CryReportParameter[7].ParameterName = "par_5";
                    CryReportParameter[7].ParameterValue = CombineFromTo(SLP_T3_ProfitCenter_SControl, N_SLP_T3_ProfitCenter_SControl, SLP_T3_ProfitCenter_EControl, N_SLP_T3_ProfitCenter_EControl);
                    CryReportParameter[8].ParameterName = "par_6";
                    CryReportParameter[8].ParameterValue = CombineFromTo(SLP_T3_StoreGroup_SControl, N_SLP_T3_StoreGroup_SControl, SLP_T3_StoreGroup_EControl, N_SLP_T3_StoreGroup_EControl);
                    CryReportParameter[9].ParameterName = "par_7";
                    CryReportParameter[9].ParameterValue = txt_T3_RFNOControl;
                    CryReportParameter[10].ParameterName = "par_8";
                    CryReportParameter[10].ParameterValue = SLP_T3_STORE_IDControl + " " + N_SLP_T3_STORE_IDControl;
                    CryReportParameter[11].ParameterName = "par_9";
                    CryReportParameter[11].ParameterValue = Merge2Para(Get_Z_O_Name(SLP_T3_Z_O_SControl), Get_Z_O_Name(SLP_T3_Z_O_EControl));
                    CryReportParameter[12].ParameterName = "par_10";
                    CryReportParameter[12].ParameterValue = SLP_T3_SAL_IDControl + " " + N_SLP_T3_SAL_IDControl;
                    CryReportParameter[13].ParameterName = "par_11";
                    CryReportParameter[13].ParameterValue = SLP_T3_AC_IDControl + " " + N_SLP_T3_AC_IDControl;
                    CryReportParameter[14].ParameterName = "par_12";
                    CryReportParameter[14].ParameterValue = (rbl_T3_CLOSEControl == "1" ? "未結案" : (rbl_T3_CLOSEControl == "2" ? "已結案" : "全部"));
                    CryReportParameter[15].ParameterName = "par_13";
                    CryReportParameter[15].ParameterValue = SLP_T3_RootNoControl + " " + N_SLP_T3_RootNoControl;
                    CryReportParameter[16].ParameterName = "par_14";
                    CryReportParameter[16].ParameterValue = Merge2Para(txt_T3_AcctYearMonth_SControl, txt_T3_AcctYearMonth_EControl);

                    ReportPath = "./REPORT/CAA311/CAA31R03.rpt";
                }
                else
                { ReportPath = "./REPORT/CAA311/CAA31R03xls.rpt"; }

                ReportName = "應付帳款餘額明細表";
                break;
            case "3": //Tab4

                DBParameter = new ReportParameter[18];
                DBParameter[0].ParameterName = "結帳年月起T4";
                DBParameter[0].ParameterValue = EmptyPar(txt_T4_YearMonth_SControl, txt_T4_YearMonth_EControl);
                DBParameter[1].ParameterName = "結帳年月迄T4";
                DBParameter[1].ParameterValue = EmptyPar(txt_T4_YearMonth_EControl, txt_T4_YearMonth_SControl);
                DBParameter[2].ParameterName = "生活日起T4";
                DBParameter[2].ParameterValue = EmptyPar(SLP_T4_APLDATE_RANGE_SControl, SLP_T4_APLDATE_RANGE_EControl);
                DBParameter[3].ParameterName = "生活日迄T4";
                DBParameter[3].ParameterValue = EmptyPar(SLP_T4_APLDATE_RANGE_EControl, SLP_T4_APLDATE_RANGE_SControl);
                DBParameter[4].ParameterName = "店群起T4";
                DBParameter[4].ParameterValue = EmptyPar(SLP_T4_StoreGroup_SControl, SLP_T4_StoreGroup_EControl); ;
                DBParameter[5].ParameterName = "店群迄T4";
                DBParameter[5].ParameterValue = EmptyPar(SLP_T4_StoreGroup_EControl, SLP_T4_StoreGroup_SControl); ;
                DBParameter[6].ParameterName = "結帳統編T4";
                DBParameter[6].ParameterValue = txt_T4_RFNOControl;
                DBParameter[7].ParameterName = "營業所起T4";
                DBParameter[7].ParameterValue = EmptyPar(SLP_T4_Z_O_SControl, SLP_T4_Z_O_EControl);
                DBParameter[8].ParameterName = "營業所迄T4";
                DBParameter[8].ParameterValue = EmptyPar(SLP_T4_Z_O_EControl, SLP_T4_Z_O_SControl); ;
                DBParameter[9].ParameterName = "店號T4";
                DBParameter[9].ParameterValue = SLP_T4_STORE_IDControl;
                DBParameter[10].ParameterName = "營業人員T4";
                DBParameter[10].ParameterValue = SLP_T4_SAL_IDControl;
                DBParameter[11].ParameterName = "帳務人員T4";
                DBParameter[11].ParameterValue = SLP_T4_AC_IDControl;
                DBParameter[12].ParameterName = "是否結案(=2為已結案,<>2為未結案)T4";
                DBParameter[12].ParameterValue = rbl_T4_CLOSEControl;
                DBParameter[13].ParameterName = "LoginUser";
                DBParameter[13].ParameterValue = UserIdControl;                
                DBParameter[14].ParameterName = "統一編號T4";
                DBParameter[14].ParameterValue = txt_T4_VOUCH_RFNOControl;
                DBParameter[15].ParameterName = "商品群分類T4";
                DBParameter[15].ParameterValue = SLP_T4_RootNoControl;
                DBParameter[16].ParameterName = "查詢方式";
                DBParameter[16].ParameterValue = rbl_T4_MonthTypeControl;
                DBParameter[17].ParameterName = "TabContainerT4";
                DBParameter[17].ParameterValue = TabContainerControl;

                if (src == "1")
                {
                    CryReportParameter = new ReportParameter[15];
                    CryReportParameter[0].ParameterName = "par_Program_ID";
                    CryReportParameter[0].ParameterValue = "CAA31R01";
                    CryReportParameter[1].ParameterName = "par_LoginUser";
                    CryReportParameter[1].ParameterValue = UserIdControl;
                    CryReportParameter[2].ParameterName = "par_LoginName";
                    CryReportParameter[2].ParameterValue = UserNameControl;
                    CryReportParameter[3].ParameterName = "par_1";
                    CryReportParameter[3].ParameterValue = Merge2Para(SLP_T4_APLDATE_RANGE_SControl, SLP_T4_APLDATE_RANGE_EControl);
                    CryReportParameter[4].ParameterName = "par_2";
                    CryReportParameter[4].ParameterValue = Merge2Para(txt_T4_YearMonth_SControl, txt_T4_YearMonth_EControl);
                    CryReportParameter[5].ParameterName = "par_3";
                    CryReportParameter[5].ParameterValue = CombineFromTo(SLP_T4_StoreGroup_SControl, N_SLP_T4_StoreGroup_SControl, SLP_T4_StoreGroup_EControl, N_SLP_T4_StoreGroup_EControl);
                    CryReportParameter[6].ParameterName = "par_4";
                    CryReportParameter[6].ParameterValue = txt_T4_RFNOControl;
                    CryReportParameter[7].ParameterName = "par_5";
                    CryReportParameter[7].ParameterValue = SLP_T4_STORE_IDControl + " " + N_SLP_T4_STORE_IDControl;
                    CryReportParameter[8].ParameterName = "par_6";
                    CryReportParameter[8].ParameterValue = Merge2Para(Get_Z_O_Name(SLP_T4_Z_O_SControl), Get_Z_O_Name(SLP_T4_Z_O_EControl));
                    CryReportParameter[9].ParameterName = "par_7";
                    CryReportParameter[9].ParameterValue = SLP_T4_SAL_IDControl + " " + N_SLP_T4_SAL_IDControl;
                    CryReportParameter[10].ParameterName = "par_8";
                    CryReportParameter[10].ParameterValue = SLP_T4_AC_IDControl + " " + N_SLP_T4_AC_IDControl;
                    CryReportParameter[11].ParameterName = "par_9";
                    CryReportParameter[11].ParameterValue = (rbl_T4_CLOSEControl == "1" ? "未結案" : (rbl_T4_CLOSEControl == "2" ? "已結案" : "全部"));
                    CryReportParameter[12].ParameterName = "par_10";
                    CryReportParameter[12].ParameterValue = txt_T4_VOUCH_RFNOControl;
                    CryReportParameter[13].ParameterName = "par_11";
                    CryReportParameter[13].ParameterValue = SLP_T4_RootNoControl + " " + N_SLP_T4_RootNoControl;

                    ReportPath = "./REPORT/CAA311/CAA31R01.rpt";
                }
                else
                { ReportPath = "./REPORT/CAA311/CAA31R01xls.rpt"; }

                ReportName = "應收應付帳款立沖帳";

                break;
            case "4": //Tab6
                DBParameter = new ReportParameter[16];
                DBParameter[0].ParameterName = "結帳年月起T6";
                DBParameter[0].ParameterValue = EmptyPar(txt_T6_YearMonth_SControl, txt_T6_YearMonth_EControl);
                DBParameter[1].ParameterName = "結帳年月迄T6";
                DBParameter[1].ParameterValue = EmptyPar(txt_T6_YearMonth_EControl, txt_T6_YearMonth_SControl);
                DBParameter[2].ParameterName = "帳款到期日T6";
                DBParameter[2].ParameterValue = SLP_T6_DUE_DATEControl;
                DBParameter[3].ParameterName = "帳款區間起T6";
                DBParameter[3].ParameterValue = SLP_T6_DUE_DATE_RANGE_SControl;
                DBParameter[4].ParameterName = "帳款區間迄T6";
                DBParameter[4].ParameterValue = SLP_T6_DUE_DATE_RANGE_EControl;
                DBParameter[5].ParameterName = "店群起T6";
                DBParameter[5].ParameterValue = EmptyPar(SLP_T6_StoreGroup_SControl, SLP_T6_StoreGroup_EControl); ;
                DBParameter[6].ParameterName = "店群迄T6";
                DBParameter[6].ParameterValue = EmptyPar(SLP_T6_StoreGroup_EControl, SLP_T6_StoreGroup_SControl); ;
                DBParameter[7].ParameterName = "結帳統編T6";
                DBParameter[7].ParameterValue = txt_T6_RFNOControl;
                DBParameter[8].ParameterName = "營業所起T6";
                DBParameter[8].ParameterValue = EmptyPar(SLP_T6_Z_O_SControl, SLP_T6_Z_O_EControl);
                DBParameter[9].ParameterName = "營業所迄T6";
                DBParameter[9].ParameterValue = EmptyPar(SLP_T6_Z_O_EControl, SLP_T6_Z_O_SControl); ;
                DBParameter[10].ParameterName = "店號T6";
                DBParameter[10].ParameterValue = SLP_T6_STORE_IDControl;
                DBParameter[11].ParameterName = "營業人員T6";
                DBParameter[11].ParameterValue = SLP_T6_SAL_IDControl;
                DBParameter[12].ParameterName = "帳務人員T6";
                DBParameter[12].ParameterValue = SLP_T6_AC_IDControl;
                DBParameter[13].ParameterName = "是否結案(=2為已結案,<>2為未結案)T6";
                DBParameter[13].ParameterValue = rbl_T6_CLOSEControl;
                DBParameter[14].ParameterName = "結帳統編T6";
                DBParameter[14].ParameterValue = txt_T6_VOUCH_RFNOControl;
                DBParameter[15].ParameterName = "TabContainerT6";
                DBParameter[15].ParameterValue = TabContainerControl;

                if (src == "1")
                {
                    CryReportParameter = new ReportParameter[13];
                    CryReportParameter[0].ParameterName = "par_Program_ID";
                    CryReportParameter[0].ParameterValue = "CAA31R06";
                    CryReportParameter[1].ParameterName = "par_LoginUser";
                    CryReportParameter[1].ParameterValue = UserIdControl;
                    CryReportParameter[2].ParameterName = "par_LoginName";
                    CryReportParameter[2].ParameterValue = UserNameControl;
                    CryReportParameter[3].ParameterName = "par_1";
                    CryReportParameter[3].ParameterValue = Merge2Para(txt_T6_YearMonth_SControl, txt_T6_YearMonth_EControl);
                    CryReportParameter[4].ParameterName = "par_2";
                    CryReportParameter[4].ParameterValue = SLP_T6_DUE_DATEControl;
                    CryReportParameter[5].ParameterName = "par_3";
                    CryReportParameter[5].ParameterValue = Merge2Para(SLP_T6_DUE_DATE_RANGE_SControl, SLP_T6_DUE_DATE_RANGE_EControl);
                    CryReportParameter[6].ParameterName = "par_4";
                    CryReportParameter[6].ParameterValue = CombineFromTo(SLP_T6_StoreGroup_SControl, N_SLP_T6_StoreGroup_SControl, SLP_T6_StoreGroup_EControl, N_SLP_T6_StoreGroup_EControl); ;
                    CryReportParameter[7].ParameterName = "par_5";
                    CryReportParameter[7].ParameterValue = txt_T6_RFNOControl;
                    CryReportParameter[8].ParameterName = "par_6";
                    CryReportParameter[8].ParameterValue = SLP_T6_STORE_IDControl + " " + N_SLP_T6_STORE_IDControl;
                    CryReportParameter[9].ParameterName = "par_7";
                    CryReportParameter[9].ParameterValue = Merge2Para(Get_Z_O_Name(SLP_T6_Z_O_SControl), Get_Z_O_Name(SLP_T6_Z_O_EControl));
                    CryReportParameter[10].ParameterName = "par_8";
                    CryReportParameter[10].ParameterValue = SLP_T6_SAL_IDControl + " " + N_SLP_T6_SAL_IDControl;
                    CryReportParameter[11].ParameterName = "par_9";
                    CryReportParameter[11].ParameterValue = SLP_T6_AC_IDControl + " " + N_SLP_T6_AC_IDControl;
                    CryReportParameter[12].ParameterName = "par_10";
                    CryReportParameter[12].ParameterValue = (rbl_T6_CLOSEControl == "1" ? "未結案" : (rbl_T6_CLOSEControl == "2" ? "已結案" : "全部"));

                    ReportPath = "./REPORT/CAA311/CAA31R06.rpt";
                }
                else
                { ReportPath = "./REPORT/CAA311/CAA31R06xls.rpt"; }

                ReportName = "暫收款餘額表";
                break;
        }

        CAARPTPage.GenerReportConfigXML("CAA",
                                        "CAA311.aspx",
                                        ReportCode,
                                        CAARPTPage.Server.MapPath(ReportPath),
                                        DBParameter,
                                        CryReportParameter,
                                        (src == "1") ? ReportOutputFormat.PDF : ReportOutputFormat.EXCEL,
                                        ReportName,
                                        ref ProcessLogFile
                                       );

        CAARPTPage.Dispose();

        #endregion

        return ProcessLogFile;
    }
Пример #2
0
    public static string SendReportMessage(string txt_T5_YearMonth_SControl,//結帳年月起 20110121純萍新增
                                           string txt_T5_YearMonth_EControl,//結帳年月迄 20110121純萍新增
                                           string txt_T5_YearMonth_S_Acct_Control,//結帳年月-財會起 20131002純萍新增
                                           string txt_T5_YearMonth_E_Acct_Control,//結帳年月-財會迄 20131002純萍新增 
                                           string SLP_T5_DUE_DATEControl,//帳款到期日 20110121純萍新增
                                           string SLP_T5_APLDATE_RANGE_SControl, //帳款區間起  
                                           string SLP_T5_APLDATE_RANGE_EControl, //帳款區間迄  
                                           string SLP_T5_INV_DATE_SControl, //發票日期起       
                                           string SLP_T5_INV_DATE_EControl, //發票日期迄       
                                           string SSLP_T5_OVERDUE_DAY_OPControl, //逾期天數(OP)
                                           string SLP_T5_OVERDUE_DAYControl, //逾期天數        
                                           string SLP_T5_INV_AMT_OPControl, //發票金額(OP)     
                                           string SLP_T5_INV_AMTControl, //發票金額            
                                           string ddl_T5_PAY_STATUSControl, //繳款狀態         
                                           string SLP_T5_StoreGroupSControl, //店群起          
                                           string SLP_T5_StoreGroupEControl, //店群迄          
                                           string txt_T5_RFNOControl, //結帳統編
                                           string txt_T5_VOUCH_RFNOControl,//統一編號   20110121純萍新增     
                                           string SLP_T5_STOREControl, //店號                  
                                           string SLP_T5_Z_O_SControl, //營業所起              
                                           string SLP_T5_Z_O_EControl, //營業所迄              
                                           string SLP_T5_SAL_IDControl, //營業人員             
                                           string SLP_T5_AC_IDControl, //帳務人員              
                                           string UserIdControl,                               
                                           string UserNameControl,                             
                                           string N_SLP_T5_StoreGroupSControl, //店群起        
                                           string N_SLP_T5_StoreGroupEControl, //店群迄        
                                           string N_SLP_T5_STOREControl, //店號                
                                           string N_SLP_T5_AC_IDControl, //帳務人員            
                                           string N_SLP_T5_SAL_IDControl, //營業人員           
                                           string src)
    {
        string ReportCode = "CAA26_1";

        #region DB需要的變數
        
        ReportParameter[] DBParameter = new ReportParameter[23];
        DBParameter[0].ParameterName = "帳務區間起";
        DBParameter[0].ParameterValue = EmptyPar(SLP_T5_APLDATE_RANGE_SControl, SLP_T5_APLDATE_RANGE_EControl);
        DBParameter[1].ParameterName = "帳務區間迄";
        DBParameter[1].ParameterValue = EmptyPar(SLP_T5_APLDATE_RANGE_EControl, SLP_T5_APLDATE_RANGE_SControl);
        DBParameter[2].ParameterName = "發票日期起";
        DBParameter[2].ParameterValue = EmptyPar(SLP_T5_INV_DATE_SControl, SLP_T5_INV_DATE_EControl);
        DBParameter[3].ParameterName = "發票日期迄";
        DBParameter[3].ParameterValue = EmptyPar(SLP_T5_INV_DATE_EControl, SLP_T5_INV_DATE_SControl);
        DBParameter[4].ParameterName = "逾期天數Operator";
        DBParameter[4].ParameterValue = SSLP_T5_OVERDUE_DAY_OPControl;
        DBParameter[5].ParameterName = "逾期天數";
        DBParameter[5].ParameterValue = SLP_T5_OVERDUE_DAYControl;
        DBParameter[6].ParameterName = "發票金額Operator";
        DBParameter[6].ParameterValue = SLP_T5_INV_AMT_OPControl;
        DBParameter[7].ParameterName = "發票金額";
        DBParameter[7].ParameterValue = SLP_T5_INV_AMTControl;
        DBParameter[8].ParameterName = "繳款狀態(0:未繳款 1:已繳款)";
        DBParameter[8].ParameterValue = ddl_T5_PAY_STATUSControl;
        DBParameter[9].ParameterName = "店群起";
        DBParameter[9].ParameterValue = EmptyPar(SLP_T5_StoreGroupSControl, SLP_T5_StoreGroupEControl);
        DBParameter[10].ParameterName = "店群迄";
        DBParameter[10].ParameterValue = EmptyPar(SLP_T5_StoreGroupEControl, SLP_T5_StoreGroupSControl);
        DBParameter[11].ParameterName = "結帳統編";
        DBParameter[11].ParameterValue = txt_T5_RFNOControl;
        DBParameter[12].ParameterName = "店號";
        DBParameter[12].ParameterValue = SLP_T5_STOREControl;
        DBParameter[13].ParameterName = "營業所起";
        DBParameter[13].ParameterValue = EmptyPar(SLP_T5_Z_O_SControl, SLP_T5_Z_O_EControl);
        DBParameter[14].ParameterName = "營業所迄";
        DBParameter[14].ParameterValue = EmptyPar(SLP_T5_Z_O_EControl, SLP_T5_Z_O_SControl);
        DBParameter[15].ParameterName = "營業人員";
        DBParameter[15].ParameterValue = SLP_T5_SAL_IDControl;
        DBParameter[16].ParameterName = "帳務人員";
        DBParameter[16].ParameterValue = SLP_T5_AC_IDControl;

        #region 20110121 純萍新增

        DBParameter[17].ParameterName = "結帳年月起";
        DBParameter[17].ParameterValue = EmptyPar(txt_T5_YearMonth_SControl, txt_T5_YearMonth_EControl);
        DBParameter[18].ParameterName = "結帳年月迄";
        DBParameter[18].ParameterValue = EmptyPar(txt_T5_YearMonth_EControl, txt_T5_YearMonth_SControl);
        DBParameter[19].ParameterName = "帳款到期日";
        DBParameter[19].ParameterValue = SLP_T5_DUE_DATEControl;
        DBParameter[20].ParameterName = "統一編號";
        DBParameter[20].ParameterValue = txt_T5_VOUCH_RFNOControl;

        #endregion

        #region 20131002 純萍新增

        DBParameter[21].ParameterName = "結帳年月-財會起";
        DBParameter[21].ParameterValue = EmptyPar(txt_T5_YearMonth_S_Acct_Control, txt_T5_YearMonth_E_Acct_Control);
        DBParameter[22].ParameterName = "結帳年月-財會迄";
        DBParameter[22].ParameterValue = EmptyPar(txt_T5_YearMonth_E_Acct_Control, txt_T5_YearMonth_S_Acct_Control);

        #endregion

        #endregion

        #region 報表變數 送出產生報表

        string ProcessLogFile = "";
        CAA_CAA311 CAARPTPage = new CAA_CAA311();

        ReportParameter[] CryReportParameter = new ReportParameter[18];
        CryReportParameter[0].ParameterName = "par_Program_ID";
        CryReportParameter[0].ParameterValue = "CAA26R01";
        CryReportParameter[1].ParameterName = "par_LoginUser";
        CryReportParameter[1].ParameterValue = UserIdControl;
        CryReportParameter[2].ParameterName = "par_LoginName";
        CryReportParameter[2].ParameterValue = UserNameControl;
        CryReportParameter[3].ParameterName = "par_1";
        CryReportParameter[3].ParameterValue = Merge2Para(SLP_T5_APLDATE_RANGE_SControl, SLP_T5_APLDATE_RANGE_EControl);
        CryReportParameter[4].ParameterName = "par_2";
        CryReportParameter[4].ParameterValue = Merge2Para(SLP_T5_INV_DATE_SControl, SLP_T5_INV_DATE_EControl);
        CryReportParameter[5].ParameterName = "par_3";
        CryReportParameter[5].ParameterValue = (SSLP_T5_OVERDUE_DAY_OPControl == "0" ? "< " : (SSLP_T5_OVERDUE_DAY_OPControl == "1" ? "= " : "> ")) + SLP_T5_OVERDUE_DAYControl;
        CryReportParameter[6].ParameterName = "par_4";
        CryReportParameter[6].ParameterValue = (SLP_T5_INV_AMT_OPControl == "0" ? "< " : (SLP_T5_INV_AMT_OPControl == "1" ? "= " : "> ")) + SLP_T5_INV_AMTControl;
        CryReportParameter[7].ParameterName = "par_5";
        CryReportParameter[7].ParameterValue = (ddl_T5_PAY_STATUSControl == "ALL" ? "ALL" : (ddl_T5_PAY_STATUSControl == "1" ? "己繳款" : "未繳款"));
        CryReportParameter[8].ParameterName = "par_6";
        CryReportParameter[8].ParameterValue = Merge2Para((SLP_T5_StoreGroupSControl == "" ? "" : (SLP_T5_StoreGroupSControl + " " + N_SLP_T5_StoreGroupSControl)), (SLP_T5_StoreGroupEControl == "" ? "" : (SLP_T5_StoreGroupEControl + " " + N_SLP_T5_StoreGroupEControl)));
        CryReportParameter[9].ParameterName = "par_7";
        CryReportParameter[9].ParameterValue = txt_T5_RFNOControl;
        CryReportParameter[10].ParameterName = "par_8";
        CryReportParameter[10].ParameterValue = SLP_T5_STOREControl + " " + N_SLP_T5_STOREControl;
        CryReportParameter[11].ParameterName = "par_9";
        CryReportParameter[11].ParameterValue = Merge2Para(Get_Z_O_Name(SLP_T5_Z_O_SControl), Get_Z_O_Name(SLP_T5_Z_O_EControl));
        CryReportParameter[12].ParameterName = "par_10";
        CryReportParameter[12].ParameterValue = SLP_T5_SAL_IDControl + " " + N_SLP_T5_AC_IDControl;
        CryReportParameter[13].ParameterName = "par_11";
        CryReportParameter[13].ParameterValue = SLP_T5_AC_IDControl + " " + N_SLP_T5_SAL_IDControl;

        #region 20110121 純萍新增
        CryReportParameter[14].ParameterName = "par_12";
        CryReportParameter[14].ParameterValue = Merge2Para(txt_T5_YearMonth_SControl, txt_T5_YearMonth_EControl);
        CryReportParameter[15].ParameterName = "par_13";
        CryReportParameter[15].ParameterValue = SLP_T5_DUE_DATEControl;
        CryReportParameter[16].ParameterName = "par_14";
        CryReportParameter[16].ParameterValue = txt_T5_VOUCH_RFNOControl;
        #endregion

        #region 20110121 純萍新增
        CryReportParameter[17].ParameterName = "par_15";
        CryReportParameter[17].ParameterValue = Merge2Para(txt_T5_YearMonth_S_Acct_Control, txt_T5_YearMonth_E_Acct_Control);
        #endregion


        CAARPTPage.GenerReportConfigXML("CAA",
                                        "CAA261.aspx",
                                        ReportCode,
                                        CAARPTPage.Server.MapPath("./REPORT/CAA311/CAA26R01.rpt"),
                                        DBParameter,
                                        CryReportParameter,
                                        (src == "1") ? ReportOutputFormat.PDF : ReportOutputFormat.EXCEL,
                                        "逾期未繳款報表",
                                        ref ProcessLogFile
                                       );

        CAARPTPage.Dispose();

        #endregion

        return ProcessLogFile;
    }