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