public static string SendReportMessage(string ChainNoStart, string ChainNoEnd, string CalcDateStart, string CalcDateEnd, string RankCode, string UID, string TopRownum, string StoreStart, string StoreEnd, string RootNo, string PMAStart, string PMAEnd, string PatternStart, string PatternEnd, string ExportName ) { #region string ReportCode = "ALO03_1"; string ExcelName = ExportName.Trim().ToLower().Replace(".xls", ""); ALO_ALO031 ALORPTPage = new ALO_ALO031(); string ProcessLogFile = ""; #region #region DB需要的變數 ReportParameter[] DBParameter = new ReportParameter[15]; DBParameter[0].ParameterName = "通路起"; DBParameter[0].ParameterValue = ChainNoStart; DBParameter[1].ParameterName = "通路迄"; DBParameter[1].ParameterValue = ChainNoEnd; DBParameter[2].ParameterName = "計算日起"; DBParameter[2].ParameterValue = CalcDateStart; DBParameter[3].ParameterName = "計算日迄"; DBParameter[3].ParameterValue = CalcDateEnd; DBParameter[4].ParameterName = "Rank類別"; DBParameter[4].ParameterValue = RankCode; DBParameter[5].ParameterName = "使用者"; DBParameter[5].ParameterValue = UID; DBParameter[6].ParameterName = "處理開始時間"; DBParameter[6].ParameterValue = DateTime.Today.ToString("yyyyMMddHHmmss"); DBParameter[7].ParameterName = "TopRow的筆數"; DBParameter[7].ParameterValue = TopRownum; DBParameter[8].ParameterName = "門市起"; DBParameter[8].ParameterValue = StoreStart; DBParameter[9].ParameterName = "門市迄"; DBParameter[9].ParameterValue = StoreEnd; DBParameter[10].ParameterName = "群分類"; DBParameter[10].ParameterValue = RootNo; DBParameter[11].ParameterName = "大分類起"; DBParameter[11].ParameterValue = PMAStart; DBParameter[12].ParameterName = "大分類迄"; DBParameter[12].ParameterValue = PMAEnd; DBParameter[13].ParameterName = "Pattern起"; DBParameter[13].ParameterValue = PatternStart; DBParameter[14].ParameterName = "Pattern迄"; DBParameter[14].ParameterValue = PatternEnd; #endregion #region 報表變數 送出產生報表 ALORPTPage.GenerReportConfigXML("ALO", "ALO031.aspx", ReportCode, "", DBParameter, null, ReportOutputFormat.EXCEL, ExcelName, ref ProcessLogFile ); ALORPTPage.Dispose(); #endregion #endregion ALORPTPage.Dispose(); return ProcessLogFile; #endregion }
public static string SendJobMessage(string ChainNoStart, string ChainNoEnd, string CalcDateStart, string CalcDateEnd, string RankCode, string UID, string TopRownum, string StoreStart, string StoreEnd, string RootNo, string PMAStart, string PMAEnd, string PatternStart, string PatternEnd ) { #region JobParameter[] DBParameter = new JobParameter[15]; DBParameter[0].ParameterName = "通路起"; DBParameter[0].ParameterValue = ChainNoStart; DBParameter[1].ParameterName = "通路迄"; DBParameter[1].ParameterValue = ChainNoEnd; DBParameter[2].ParameterName = "計算日起"; DBParameter[2].ParameterValue = CalcDateStart; DBParameter[3].ParameterName = "計算日迄"; DBParameter[3].ParameterValue = CalcDateEnd; DBParameter[4].ParameterName = "Rank類別"; DBParameter[4].ParameterValue = RankCode; DBParameter[5].ParameterName = "使用者"; DBParameter[5].ParameterValue = UID; DBParameter[6].ParameterName = "處理開始時間"; DBParameter[6].ParameterValue = DateTime.Today.ToString("yyyyMMddHHmmss"); DBParameter[7].ParameterName = "TopRow的筆數"; DBParameter[7].ParameterValue = TopRownum; DBParameter[8].ParameterName = "門市起"; DBParameter[8].ParameterValue = StoreStart; DBParameter[9].ParameterName = "門市迄"; DBParameter[9].ParameterValue = StoreEnd; DBParameter[10].ParameterName = "群分類"; DBParameter[10].ParameterValue = RootNo; DBParameter[11].ParameterName = "大分類起"; DBParameter[11].ParameterValue = PMAStart; DBParameter[12].ParameterName = "大分類迄"; DBParameter[12].ParameterValue = PMAEnd; DBParameter[13].ParameterName = "Pattern起"; DBParameter[13].ParameterValue = PatternStart; DBParameter[14].ParameterName = "Pattern迄"; DBParameter[14].ParameterValue = PatternEnd; string JobCode = "ALO03_1"; string ProcessLogFile = ""; //this.GenerReportConfigXML ALO_ALO031 ALOJOBPage = new ALO_ALO031(); ALOJOBPage.GenerJobConfigXML("ALO", "ALO031.aspx", JobCode, DBParameter, JobOutputFormat.None, ref ProcessLogFile ); ALOJOBPage.Dispose(); return ProcessLogFile; #endregion }