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