/// <summary> /// CAA10 /// </summary> /// <param name="ParameterList"></param> /// <param name="s_Type"></param> /// <returns></returns> public DataTable CAA10_1(ArrayList ParameterList, string s_Type) { #region 宣告變數 BCO.CAACommon CAAComm = new BCO.CAACommon(); ArrayList arl_ReportService = new ArrayList(); DataTable dt_Return = new DataTable(); #endregion #region 取得資料 switch (s_Type) { #region 頁籤=通路繳款-專案代收 case "CAA10_1": #region 傳入參數 arl_ReportService.Clear(); arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[22].ToString(), "int", false));//[筆數] arl_ReportService.Add(CAAComm.GetValueSetParameter((ParameterList[23].ToString() == "true") ? "1" : "0", "string", false));//[關鍵字查詢],1=勾選關鍵字查詢,0=沒勾選關鍵字查詢 arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[0].ToString(), "string", false));//營業日期起 arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[1].ToString(), "string", false));//營業日期迄 arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[2].ToString(), "string", false));//交易日期起 arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[3].ToString(), "string", false));//交易日期迄 arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[4].ToString(), "string", false));//交易序號起 arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[5].ToString(), "string", false));//交易序號迄 arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[6].ToString(), "string", false));//交易金額Operator arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[7].ToString(), "int", false));//交易金額 arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[8].ToString(), "string", false));//客戶編號起 arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[9].ToString(), "string", false));//客戶編號迄 arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[10].ToString(), "string", false));//繳款識別碼起 arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[11].ToString(), "string", false));//繳款識別碼迄 arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[12].ToString(), "string", false));//店群起 arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[13].ToString(), "string", false));//店群迄 arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[14].ToString(), "string", false));//收款單號起 arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[15].ToString(), "string", false));//收款單號迄 arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[16].ToString(), "string", false));//建立日期起 arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[17].ToString(), "string", false));//建立日期迄 arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[18].ToString(), "string", false));//建立人員 arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[19].ToString(), "string", false));//維護日期起 arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[20].ToString(), "string", false));//維護日期迄 arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[21].ToString(), "string", false));//維護人員 arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[24].ToString(), "string", false));//交易金額Operator arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[25].ToString(), "int", false));//交易金額 #endregion #region 連結資料庫 BCO.MaintainCollRecord bco_1 = new BCO.MaintainCollRecord(ConntionDB); dt_Return = bco_1.QueryCollRecordByByLike(arl_ReportService); #endregion break; #endregion #region 頁籤=專案代收明細表 case "CAA10_2": #region 傳入參數 arl_ReportService.Clear(); arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[0].ToString(), "string", false));//[營業日期]起 arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[1].ToString(), "string", false));//[營業日期]迄 arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[2].ToString(), "string", false));//[交易日期]起 arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[3].ToString(), "string", false));//[交易日期]迄 arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[4].ToString(), "date", false));//[收款單號日期]起 arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[5].ToString(), "date", false));//[收款單號日期]迄 arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[6].ToString(), "string", false));//[繳款型態] arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[7].ToString(), "string", false));//[帳務人員]起 arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[8].ToString(), "string", false));//[帳務人員]迄 arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[9].ToString(), "string", false));//利潤中心起 arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[10].ToString(), "string", false));//利潤中心迄 arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[11].ToString(), "string", false));//店號 arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[12].ToString(), "string", false));//營業所起 arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[13].ToString(), "string", false));//營業所迄 arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[14].ToString(), "string", false));//營業人員起 arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[15].ToString(), "string", false));//營業人員迄 arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[16].ToString(), "string", false));//沖帳餘額OP arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[17].ToString(), "string", false));//沖帳餘額 arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[18].ToString(), "string", false));//結案狀態 #endregion #region 連結資料庫 BCO.ProcessCollReport bco_2 = new BCO.ProcessCollReport(ConntionDB); dt_Return = bco_2.QueryCollReport(arl_ReportService); #endregion break; #endregion } #endregion #region 檢查回傳資料 if (dt_Return.Rows.Count == 0) { throw new Exception("查無資料"); } #endregion return dt_Return; }
/// <summary> /// 頁籤=通路繳款-專案代收 BUTTON [查詢] /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnQuery_Click(object sender, EventArgs e) { try { #region 設定變數 BCO.CAACommon CAAComm = new BCO.CAACommon(); #endregion #region 傳入參數 ParameterList.Clear(); ParameterList.Add(CAAComm.GetValueSetParameter(this.TextBoxRowCountLimit.Text, "int", false)); //N_ROWNUM if (this.chb_Like_Search.Checked == true) { ParameterList.Add("1"); }//勾選關鍵字搜尋 else { ParameterList.Add("0"); }//沒有勾選關鍵字搜尋 ParameterList.Add(CAAComm.GetValueSetParameter(this.slp_SAL_DATE.StartDate, "string", false)); //V_SAL_DATE_S ParameterList.Add(CAAComm.GetValueSetParameter(this.slp_SAL_DATE.EndDate, "string", false)); //V_SAL_DATE_E ParameterList.Add(CAAComm.GetValueSetParameter(this.slp_COLL_DATE.StartDate, "string", false)); //V_COLL_DATE_S ParameterList.Add(CAAComm.GetValueSetParameter(this.slp_COLL_DATE.EndDate, "string", false)); //V_COLL_DATE_E ParameterList.Add(CAAComm.GetValueSetParameter(this.txt_COLL_SEQNO_B.Text, "string", false)); //V_COLL_SEQNO_S ParameterList.Add(CAAComm.GetValueSetParameter(this.txt_COLL_SEQNO_E.Text, "string", false)); //V_COLL_SEQNO_E ParameterList.Add(GetValueSetOP(this.slp_COLL_AMT.Operator)); //V_COLL_AMT_OP ParameterList.Add(CAAComm.GetValueSetParameter(this.slp_COLL_AMT.Text, "int", false)); //N_COLL_AMT ParameterList.Add(CAAComm.GetValueSetParameter(this.slp_STORE_ID_B.Text, "string", false)); //V_STORE_S ParameterList.Add(CAAComm.GetValueSetParameter(this.slp_STORE_ID_E.Text, "string", false)); //V_STORE_E ParameterList.Add(CAAComm.GetValueSetParameter(this.txt_PAY_CHKNO_B.Text, "string", false)); //V_PAT_CHKNO_S ParameterList.Add(CAAComm.GetValueSetParameter(this.txt_PAY_CHKNO_E.Text, "string", false)); //V_PAT_CHKNO_E ParameterList.Add(CAAComm.GetValueSetParameter(this.slp_GROUP_NO_B.Text, "string", false)); //V_GROUP_S ParameterList.Add(CAAComm.GetValueSetParameter(this.slp_GROUP_NO_E.Text, "string", false)); //V_GROUP_E ParameterList.Add(CAAComm.GetValueSetParameter(this.txt_COLL_NO_B.Text, "string", false)); //V_COLL_NO_S ParameterList.Add(CAAComm.GetValueSetParameter(this.txt_COLL_NO_E.Text, "string", false)); //V_COLL_NO_E ParameterList.Add(CAAComm.GetValueSetParameter(this.slp_CREATEDATE.StartDate, "string", false)); //V_CREATEDATE_S ParameterList.Add(CAAComm.GetValueSetParameter(this.slp_CREATEDATE.EndDate, "string", false)); //V_CREATEDATE_E ParameterList.Add(CAAComm.GetValueSetParameter(this.slp_CREATEUID.Text, "string", false)); //V_CREATEUID ParameterList.Add(CAAComm.GetValueSetParameter(this.slp_UPDATEDATE.StartDate, "string", false)); //V_UPDATEDATE_S ParameterList.Add(CAAComm.GetValueSetParameter(this.slp_UPDATEDATE.EndDate, "string", false)); //V_UPDATEDATE_E ParameterList.Add(CAAComm.GetValueSetParameter(this.slp_UPDATEUID.Text, "string", false)); //V_UPDATEUID ParameterList.Add(GetValueSetOP(this.slp_REMAIN_AMT.Operator)); //V_REMAIN_AMT_OP ParameterList.Add(CAAComm.GetValueSetParameter(this.slp_REMAIN_AMT.Text, "int", false)); //N_REMAIN_AMT #endregion #region 連結資料庫 DataTable dt = new DataTable(); BCO.MaintainCollRecord CAA10 = new BCO.MaintainCollRecord(ConntionDB); dt = CAA10.QueryCollRecordByByLike(ParameterList); #endregion #region 資料與GridView繫結 //抓取本頁初次登記的時間 string SessionIDName = "CAA101_" + PageTimeStamp.Value; Session["SessionID"] = SessionIDName; Session[SessionIDName] = dt; gv_COLL.DataSource = dt; gv_COLL.PageSize = (TextBoxPagesize.Text == "") ? 10 : (int.Parse(TextBoxPagesize.Text) < 0) ? 10 : int.Parse(TextBoxPagesize.Text); gv_COLL.PageIndex = 0; gv_COLL.DataBind(); #endregion #region 將Key值存到Session中 ArrayList arl_Key = new ArrayList(); foreach (DataRow drRow in dt.Rows) { arl_Key.Add(drRow["ID"].ToString()); } Session["CAA102_SortKey" + this.PageTimeStamp.Value] = arl_Key; #endregion #region 檢查回傳資料 if (dt.Rows.Count == 0) { this.ErrorMsgLabel.Text = "查無資料"; } #endregion } catch (Exception ex) { WaringLogProcess(ex.Message); this.ErrorMsgLabel.Text = ex.Message; } }