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