public static string SendReport2Message(string BUS_YM_S,
string BUS_YM_E,
string Z_O1,
string SAL_ID1,
string AC_ID1,
string GROUP_NO_S1,
string GROUP_NO_E1,
string PAY_RFNO1,
string RFNO1,
string PROFIT_NO_S1,
string PROFIT_NO_E1,
string STORE1,
string ROOTNO1,
string ROLE,
string REPORT_KIND1_2,
string REPORT_KIND2_2,
string AC_CLOSE,
string Z_O_NAME1,
string SAL_ID_NAME1,
string AC_ID_NAME1,
string GROUP_NO_S_NAME1,
string GROUP_NO_E_NAME1,
string STORE_NAME1,
string ROOTNO_NAME1,
string ROLE_NAME,
string PROFIT_NAME_S1,
string PROFIT_NAME_E1,
string UID,
string UNAME,
string ReportFormat
)
{
ReportParameter[] DBParameter = new ReportParameter[17];
#region DB需要的變數
DBParameter[0].ParameterName = "營業所";
DBParameter[0].ParameterValue = Z_O1;
DBParameter[1].ParameterName = "營業人員";
DBParameter[1].ParameterValue = SAL_ID1;
DBParameter[2].ParameterName = "店群起";
DBParameter[2].ParameterValue = GROUP_NO_S1;
DBParameter[3].ParameterName = "店群迄";
DBParameter[3].ParameterValue = GROUP_NO_E1;
DBParameter[4].ParameterName = "結帳統編";
DBParameter[4].ParameterValue = PAY_RFNO1;
DBParameter[5].ParameterName = "統一編號";
DBParameter[5].ParameterValue = RFNO1;
DBParameter[6].ParameterName = "店號";
DBParameter[6].ParameterValue = STORE1;
DBParameter[7].ParameterName = "商品群";
DBParameter[7].ParameterValue = ROOTNO1;
DBParameter[8].ParameterName = "結算年月起";
DBParameter[8].ParameterValue = BUS_YM_S;
DBParameter[9].ParameterName = "結算年月迄";
DBParameter[9].ParameterValue = BUS_YM_E;
DBParameter[10].ParameterName = "權責單位";
DBParameter[10].ParameterValue = ROLE;
DBParameter[11].ParameterName = "結帳";
DBParameter[11].ParameterValue = AC_CLOSE;
DBParameter[12].ParameterName = "報表類型1";
DBParameter[12].ParameterValue = REPORT_KIND1_2;
DBParameter[13].ParameterName = "報表類型2";
DBParameter[13].ParameterValue = REPORT_KIND2_2;
DBParameter[14].ParameterName = "帳務人員";
DBParameter[14].ParameterValue = AC_ID1;
DBParameter[15].ParameterName = "利潤中心起";
DBParameter[15].ParameterValue = PROFIT_NO_S1;
DBParameter[16].ParameterName = "利潤中心迄";
DBParameter[16].ParameterValue = PROFIT_NO_E1;
#endregion
ReportParameter[] CryReportParameter = new ReportParameter[15];
string strReportName = "";
string strFileName = "";
#region 報表變數
if (REPORT_KIND1_2 == "0")//彙總
{
if (REPORT_KIND2_2 == "0")//金額
{
strReportName = "CAM08R06";
strFileName = "CAM08R06_結算月報表_彙總金額";
}
else//數量
{
strReportName = "CAM08R12";
strFileName = "CAM08R12_結算月報表_彙總數量";
}
}
else//明細
{
if (REPORT_KIND2_2 == "0")//金額
{
strReportName = "CAM08R05";
strFileName = "CAM08R05_結算月報表_明細金額";
}
else//數量
{
strReportName = "CAM08R11";
strFileName = "CAM08R11_結算月報表_明細數量";
}
}
CryReportParameter[0].ParameterName = "par_Program_ID";
CryReportParameter[0].ParameterValue = strReportName;
CryReportParameter[1].ParameterName = "par_LoginUser";
CryReportParameter[1].ParameterValue = UID + UNAME;
CryReportParameter[2].ParameterName = "par_Z_O";
CryReportParameter[2].ParameterValue = Z_O1 + Z_O_NAME1;
CryReportParameter[3].ParameterName = "par_SAL_ID";
CryReportParameter[3].ParameterValue = SAL_ID1 + SAL_ID_NAME1;
CryReportParameter[4].ParameterName = "par_GROUP_NO";
CryReportParameter[4].ParameterValue = GROUP_NO_S1 + GROUP_NO_S_NAME1 + "~" + GROUP_NO_E1 + GROUP_NO_E_NAME1;
CryReportParameter[5].ParameterName = "par_PAY_RFNO";
CryReportParameter[5].ParameterValue = PAY_RFNO1;
CryReportParameter[6].ParameterName = "par_RFNO";
CryReportParameter[6].ParameterValue = RFNO1;
CryReportParameter[7].ParameterName = "par_STORE";
CryReportParameter[7].ParameterValue = STORE1 + STORE_NAME1;
CryReportParameter[8].ParameterName = "par_ROOTNO";
CryReportParameter[8].ParameterValue = ROOTNO1 + ROOTNO_NAME1;
CryReportParameter[9].ParameterName = "par_BUS_DATE";
CryReportParameter[9].ParameterValue = BUS_YM_S + "~" + BUS_YM_E;
CryReportParameter[10].ParameterName = "par_REPORT_TYPE";
CryReportParameter[10].ParameterValue = (REPORT_KIND1_2 == "0" ? "彙總" : "明細") + "/" + (REPORT_KIND2_2 == "0" ? "金額" : "數量"); ;
CryReportParameter[11].ParameterName = "par_ROLE";
CryReportParameter[11].ParameterValue = ROLE + ROLE_NAME;
CryReportParameter[12].ParameterName = "par_AC_CLOSE";
CryReportParameter[12].ParameterValue = (AC_CLOSE == "1" ? "已結帳" : "未結帳");
CryReportParameter[13].ParameterName = "par_AC_ID";
CryReportParameter[13].ParameterValue = AC_ID1 + AC_ID_NAME1;
string strTemp = string.Empty;
if (PROFIT_NO_S1 != "")
strTemp = PROFIT_NO_S1 + " " + PROFIT_NAME_S1;
if (PROFIT_NO_E1 != "")
{
if (strTemp != "")
strTemp += " ~ ";
strTemp += PROFIT_NO_E1 + " " + PROFIT_NAME_E1;
}
CryReportParameter[14].ParameterName = "par_PROFIT";
CryReportParameter[14].ParameterValue = strTemp;
#endregion
#region 產生報表處理的XML檔
string ReportCode = "CAM08_2";
string ProcessLogFile = "";
CAM_CAM081 CAMRPTPage1 = new CAM_CAM081();
CAMRPTPage1.GenerReportConfigXML("CAM",
"CAM081.aspx",
ReportCode,
CAMRPTPage1.Server.MapPath("REPORT\\CAM08\\" + strReportName + ".rpt"),
DBParameter,
CryReportParameter,
(ReportFormat == "PDF") ? ReportOutputFormat.PDF : ReportOutputFormat.EXCEL,
strFileName,
ref ProcessLogFile
);
CAMRPTPage1.Dispose();
#endregion
return ProcessLogFile;
}
public static string SendReport1Message(string BUS_DATE_S,
string BUS_DATE_E,
string Z_O,
string SAL_ID,
string GROUP_NO_S,
string GROUP_NO_E,
string PAY_RFNO,
string RFNO,
string PROFIT_NO_S,
string PROFIT_NO_E,
string STORE,
string ROOTNO,
string REPORT_KIND1_1,
string REPORT_KIND2_1,
string Z_O_NAME,
string SAL_ID_NAME,
string GROUP_NO_S_NAME,
string GROUP_NO_E_NAME,
string STORE_NAME,
string ROOTNO_NAME,
string PROFIT_NAME_S,
string PROFIT_NAME_E,
string UID,
string UNAME,
string ReportFormat
)
{
ReportParameter[] DBParameter = new ReportParameter[14];
#region DB需要的變數
DBParameter[0].ParameterName = "營業所";
DBParameter[0].ParameterValue = Z_O;
DBParameter[1].ParameterName = "營業人員";
DBParameter[1].ParameterValue = SAL_ID;
DBParameter[2].ParameterName = "店群起";
DBParameter[2].ParameterValue = GROUP_NO_S;
DBParameter[3].ParameterName = "店群迄";
DBParameter[3].ParameterValue = GROUP_NO_E;
DBParameter[4].ParameterName = "結帳統編";
DBParameter[4].ParameterValue = PAY_RFNO;
DBParameter[5].ParameterName = "統一編號";
DBParameter[5].ParameterValue = RFNO;
DBParameter[6].ParameterName = "店號";
DBParameter[6].ParameterValue = STORE;
DBParameter[7].ParameterName = "商品群";
DBParameter[7].ParameterValue = ROOTNO;
DBParameter[8].ParameterName = "銷貨日期起";
DBParameter[8].ParameterValue = BUS_DATE_S;
DBParameter[9].ParameterName = "銷貨日期迄";
DBParameter[9].ParameterValue = BUS_DATE_E;
DBParameter[10].ParameterName = "報表類型1";
DBParameter[10].ParameterValue = REPORT_KIND1_1;
DBParameter[11].ParameterName = "報表類型2";
DBParameter[11].ParameterValue = REPORT_KIND2_1;
DBParameter[12].ParameterName = "利潤中心起";
DBParameter[12].ParameterValue = PROFIT_NO_S;
DBParameter[13].ParameterName = "利潤中心迄";
DBParameter[13].ParameterValue = PROFIT_NO_E;
#endregion
ReportParameter[] CryReportParameter = new ReportParameter[13];
string strReportName = "";
string strFileName = "";
#region 報表變數
if (REPORT_KIND1_1 == "0")//彙總
{
if (REPORT_KIND2_1 == "0")//金額(牌價)
{
strReportName = "CAM08R01";
strFileName = "CAM08R01_銷貨月報表_彙總金額_牌價";
}
else if (REPORT_KIND2_1 == "2")//金額(成本)
{
strReportName = "CAM08R13";
strFileName = "CAM08R01_銷貨月報表_彙總金額_成本";
}
else//數量
{
strReportName = "CAM08R07";
strFileName = "CAM08R07_銷貨月報表_彙總數量";
}
}
else//明細
{
if (REPORT_KIND2_1 == "0")//金額(牌價)
{
strReportName = "CAM08R02";
strFileName = "CAM08R02_銷貨月報表_明細金額_牌價";
}
else if (REPORT_KIND2_1 == "2")//金額(成本)
{
strReportName = "CAM08R14";
strFileName = "CAM08R02_銷貨月報表_明細金額_成本";
}
else//數量
{
strReportName = "CAM08R08";
strFileName = "CAM08R08_銷貨月報表_明細數量";
}
}
string strTemp = string.Empty;
CryReportParameter[0].ParameterName = "par_Program_ID";
CryReportParameter[0].ParameterValue = strReportName;
CryReportParameter[1].ParameterName = "par_LoginUser";
CryReportParameter[1].ParameterValue = UID + UNAME;
CryReportParameter[2].ParameterName = "par_Z_O";
CryReportParameter[2].ParameterValue = Z_O + Z_O_NAME;
CryReportParameter[3].ParameterName = "par_SAL_ID";
CryReportParameter[3].ParameterValue = SAL_ID + SAL_ID_NAME;
CryReportParameter[4].ParameterName = "par_GROUP_NO";
CryReportParameter[4].ParameterValue = GROUP_NO_S + GROUP_NO_S_NAME + "~" + GROUP_NO_E + GROUP_NO_E_NAME;
CryReportParameter[5].ParameterName = "par_PAY_RFNO";
CryReportParameter[5].ParameterValue = PAY_RFNO;
CryReportParameter[6].ParameterName = "par_RFNO";
CryReportParameter[6].ParameterValue = RFNO;
CryReportParameter[7].ParameterName = "par_STORE";
CryReportParameter[7].ParameterValue = STORE + STORE_NAME;
CryReportParameter[8].ParameterName = "par_ROOTNO";
CryReportParameter[8].ParameterValue = ROOTNO + ROOTNO_NAME;
CryReportParameter[9].ParameterName = "par_BUS_DATE";
CryReportParameter[9].ParameterValue = BUS_DATE_S + "~" + BUS_DATE_E;
CryReportParameter[10].ParameterName = "par_REPORT_TYPE";
if (REPORT_KIND2_1 == "0")
strTemp = "金額_牌價";
else if (REPORT_KIND2_1 == "0")
strTemp = "金額_成本";
else
strTemp = "數量";
CryReportParameter[10].ParameterValue = (REPORT_KIND1_1 == "0" ? "彙總" : "明細") + "/" + strTemp;
strTemp = "";
if (PROFIT_NO_S != "")
strTemp = PROFIT_NO_S + " " + PROFIT_NAME_S;
if (PROFIT_NO_E != "")
{
if (strTemp != "")
strTemp += " ~ ";
strTemp += PROFIT_NO_E + " " + PROFIT_NAME_E;
}
CryReportParameter[11].ParameterName = "par_PROFIT";
CryReportParameter[11].ParameterValue = strTemp;
#endregion
#region 產生報表處理的XML檔
string ReportCode = "CAM08_1";
string ProcessLogFile = "";
CAM_CAM081 CAMRPTPage1 = new CAM_CAM081();
CAMRPTPage1.GenerReportConfigXML("CAM",
"CAM081.aspx",
ReportCode,
CAMRPTPage1.Server.MapPath("REPORT\\CAM08\\" + strReportName + ".rpt"),
DBParameter,
CryReportParameter,
(ReportFormat == "PDF") ? ReportOutputFormat.PDF : ReportOutputFormat.EXCEL,
strFileName,
ref ProcessLogFile
);
CAMRPTPage1.Dispose();
#endregion
return ProcessLogFile;
}
