/// <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> /// 初始檢視&編輯模式 /// </summary> private void Page_Status_VIEW_EDIT_LOAD() { if (this.hid_Page_Status.Value == "VIEW" || this.hid_Page_Status.Value == "EDIT") { #region 清空所有欄位 this.slp_SAL_DATE.Text = string.Empty;//營業日期 this.txt_COLL_DATE.Text = string.Empty;//交易日期 this.txt_COLL_TIME.Text = string.Empty;//交易時間 this.txt_COLL_SEQNO.Text = string.Empty;//交易序號 this.txt_COLL_AMT.Text = string.Empty;//交易金額 this.txt_REMAIN_AMT.Text = string.Empty;//沖帳餘額 this.slp_CHARGE.Text = string.Empty;//手續費 this.slp_STORE_ID.Text = string.Empty;//客戶編號 this.txt_PAY_CHKNO.Text = string.Empty;//繳款識別碼 this.slp_GROUP_NO.Text = string.Empty;//店群 this.txt_COLL_NO.Text = string.Empty;//收款單號 this.txt_MEMO.Text = string.Empty;//原因說明 #endregion #region 取得檢視資料 string strCode = string.Empty; try { if (Request["V_ID"] == null) { throw new Exception("載入頁面失敗!"); } else { strCode = Request["V_ID"].ToString(); } } catch { } ParameterList.Clear(); ParameterList.Add(strCode); //V_ID CAAModel.MaintainCollRecord BCO = new CAAModel.MaintainCollRecord(ConntionDB); dt = BCO.QueryCollRecordByFind(ParameterList); string s_RequestString = Request.QueryString["CAA102_Type"]; if (dt.Rows.Count != 1 && s_RequestString != "ToolBar") { throw new Exception("查無收款單號:" + strCode + "的相關資料"); } else if (dt.Rows.Count != 1 && s_RequestString == "ToolBar") { throw new Exception("查無此筆資料或已被其他使用者刪除,請點選上一筆/下一筆鈕或回查詢頁重新查詢!"); } #endregion #region 將資料寫入頁面 this.slp_SAL_DATE.Text = dt.Rows[0]["SAL_DATE"].ToString();//營業日期 this.txt_COLL_DATE.Text = dt.Rows[0]["COLL_DATE"].ToString();//交易日期/時間 this.txt_COLL_TIME.Text = dt.Rows[0]["COLL_TIME"].ToString(); this.txt_COLL_SEQNO.Text = dt.Rows[0]["COLL_SEQNO"].ToString();//交易序號 this.txt_COLL_AMT.Text = dt.Rows[0]["COLL_AMT"].ToString();//交易金額 this.txt_REMAIN_AMT.Text = dt.Rows[0]["COLL_REMAIN_AMT"].ToString();//沖帳餘額 this.slp_CHARGE.Text = dt.Rows[0]["CHARGE"].ToString();//手續費 this.slp_STORE_ID.Text = dt.Rows[0]["STORE_ID"].ToString();//客戶編號 this.txt_PAY_CHKNO.Text = dt.Rows[0]["PAY_CHKNO"].ToString();//繳款識別碼 this.slp_GROUP_NO.Text = dt.Rows[0]["GROUP_NO"].ToString();//店群 this.txt_COLL_NO.Text = dt.Rows[0]["COLL_NO"].ToString();//收款單號 this.txt_MEMO.Text = dt.Rows[0]["MEMO"].ToString();//收款單號 #endregion #region 設定ReadOnly #region 檢視模式 if (this.hid_Page_Status.Value == "VIEW") { this.slp_SAL_DATE.ReadOnly = true;//營業日期 this.txt_COLL_DATE.ReadOnly = true;//交易日期 this.txt_COLL_DATE.CssClass = "readtxtbox"; this.txt_COLL_TIME.ReadOnly = true;//交易時間 this.txt_COLL_TIME.CssClass = "readtxtbox"; this.txt_COLL_SEQNO.ReadOnly = true;//交易序號 this.txt_COLL_SEQNO.CssClass = "readtxtbox"; this.txt_COLL_AMT.ReadOnly = true;//交易金額 this.txt_COLL_AMT.CssClass = "readtxtbox"; this.txt_REMAIN_AMT.ReadOnly = true;//沖帳餘額 this.txt_REMAIN_AMT.CssClass = "readtxtbox"; this.slp_CHARGE.ReadOnly = true;//手續費 this.slp_STORE_ID.ReadOnly = true;//客戶編號 this.txt_PAY_CHKNO.ReadOnly = true;//繳款識別碼 this.txt_PAY_CHKNO.CssClass = "readtxtbox"; this.slp_GROUP_NO.ReadOnly = true;//店群 this.txt_COLL_NO.ReadOnly = true;//收款單號 this.txt_COLL_NO.CssClass = "readtxtbox"; this.txt_MEMO.ReadOnly = true;//原因說明 this.txt_MEMO.CssClass = "readtxtbox"; } #endregion #region 編輯模式 if (this.hid_Page_Status.Value == "EDIT") { if (OnlyEditMemo() == false) { this.txt_COLL_AMT.ReadOnly = true;//交易金額 this.txt_COLL_AMT.CssClass = "readtxtbox"; this.txt_COLL_NO.ReadOnly = true;//收款單號 this.txt_COLL_NO.CssClass = "readtxtbox"; this.slp_GROUP_NO.ReadOnly = true;//店群 this.txt_REMAIN_AMT.ReadOnly = true;//沖帳餘額 this.txt_REMAIN_AMT.CssClass = "readtxtbox"; } else { this.slp_SAL_DATE.ReadOnly = true;//營業日期 this.txt_COLL_DATE.ReadOnly = true;//交易日期 this.txt_COLL_DATE.CssClass = "readtxtbox"; this.txt_COLL_TIME.ReadOnly = true;//交易時間 this.txt_COLL_TIME.CssClass = "readtxtbox"; this.txt_COLL_SEQNO.ReadOnly = true;//交易序號 this.txt_COLL_SEQNO.CssClass = "readtxtbox"; this.txt_COLL_AMT.ReadOnly = true;//交易金額 this.txt_COLL_AMT.CssClass = "readtxtbox"; this.txt_REMAIN_AMT.ReadOnly = true;//沖帳餘額 this.txt_REMAIN_AMT.CssClass = "readtxtbox"; this.slp_CHARGE.ReadOnly = true;//手續費 this.slp_STORE_ID.ReadOnly = true;//客戶編號 this.txt_PAY_CHKNO.ReadOnly = true;//繳款識別碼 this.txt_PAY_CHKNO.CssClass = "readtxtbox"; this.slp_GROUP_NO.ReadOnly = true;//店群 this.txt_COLL_NO.ReadOnly = true;//收款單號 this.txt_COLL_NO.CssClass = "readtxtbox"; } } #endregion #endregion } }
protected void btnSave_Click(object sender, EventArgs e) { try { if (this.hid_Page_Status.Value == "EDIT") { #region 檢查條件 CAAModel.CAACommon CAAComm = new CAAModel.CAACommon(); ArrayList arl_Check_Condition = Check_Condition("BUTTON [儲存]鈕,編輯狀態"); #region 如果檢查有誤,則Return if (arl_Check_Condition[1].ToString() != string.Empty) { #region 錯誤訊息 this.ErrorMsgLabel.Text = arl_Check_Condition[1].ToString(); #endregion #region Focus欄位 if (arl_Check_Condition[0].ToString() != string.Empty) { string s_ScriptManager_Script = CAAComm.ToMakeUp_SetFocus_Script(arl_Check_Condition[0].ToString(), true); ScriptManager.RegisterStartupScript(this.up_ErrorMsg, typeof(UpdatePanel), "CAA102", s_ScriptManager_Script, true); } #endregion return; } #endregion #endregion if (this.slp_SAL_DATE.ReadOnly == false) { //檢查該筆資料是否月結 if (CheckClose() == true) { this.ErrorMsgLabel.Text = "此營業日期已月結,故不允許修改!"; return; } //檢查該筆資料是否沖帳 if (CheckWASH_YN() == true) //"此代收已沖帳,不允許修改!" { this.ErrorMsgLabel.Text = "此代收已沖帳,不允許修改!"; return; } } CAAModel.MaintainCollRecord BCO = new CAAModel.MaintainCollRecord(ConntionDB); string strMsg = string.Empty; string strNowDate = DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss"); string strID = dt.Rows[0]["ID"].ToString(); ; if (OnlyEditMemo() == false) //是否只更新MEMO欄位 { ParameterList.Clear(); ParameterList.Add(CAAComm.GetValueSetParameter(this.txt_COLL_NO.Text, "string", false)); //V_COLL_NO ParameterList.Add(CAAComm.GetValueSetParameter(this.slp_SAL_DATE.Text, "date", false)); //D_NEW_SAL_DATE ParameterList.Add(CAAComm.GetValueSetParameter(this.txt_COLL_DATE.Text, "date", false)); //D_NEW_COLL_DATE ParameterList.Add(CAAComm.GetValueSetParameter(this.txt_COLL_TIME.Text.Replace(":", ""), "string", false)); //V_NEW_COLL_TIME ParameterList.Add(CAAComm.GetValueSetParameter(this.txt_COLL_SEQNO.Text, "string", false)); //V_NEW_COLL_SEQNO ParameterList.Add(CAAComm.GetValueSetParameter(this.slp_CHARGE.Text, "int", false)); //手續費 ParameterList.Add(CAAComm.GetValueSetParameter(this.slp_STORE_ID.Text, "string", false)); //V_NEW_STORE_ID ParameterList.Add(CAAComm.GetValueSetParameter(this.txt_PAY_CHKNO.Text, "string", false)); //V_NEW_PAY_CHKNO ParameterList.Add(CAAComm.GetValueSetParameter(Session["UID"].ToString(), "string", false)); //V_NEW_UPDATEUID ParameterList.Add(CAAComm.GetValueSetParameter(strNowDate, "datetime", false)); //D_NEW_UPDATEDATE ParameterList.Add(CAAComm.GetValueSetParameter(dt.Rows[0]["CREATEUID"].ToString(), "string", false)); //V_OLD_CREATEUID ParameterList.Add(CAAComm.GetValueSetParameter(dt.Rows[0]["CREATEDATE"].ToString(), "datetime", false)); //D_OLD_CREATEDATE ParameterList.Add(CAAComm.GetValueSetParameter(dt.Rows[0]["UPDATEUID"].ToString(), "string", false)); //V_OLD_UPDATEUID ParameterList.Add(CAAComm.GetValueSetParameter(dt.Rows[0]["UPDATEDATE"].ToString(), "datetime", false)); //D_OLD_UPDATEDATE ParameterList.Add(CAAComm.GetValueSetParameter(this.txt_MEMO.Text, "string", false)); //V_MEMO ArrayList aryUpd = BCO.UpdateCollRecord(ParameterList, null); #region 組合跳轉頁面字串 string s_ADDLocation_Replace_String = string.Empty; try { int i_Count = int.Parse(Request.QueryString["CAA102_COUNT"]); string s_Request_Key = Request.QueryString["CAA102_PageTimeStamp"]; s_ADDLocation_Replace_String = "&CAA102_COUNT=" + i_Count.ToString() + "&CAA102_PageTimeStamp=" + s_Request_Key; } catch { s_ADDLocation_Replace_String = string.Empty; } #endregion if (aryUpd[1].ToString() == "1") { strMsg = "alert('儲存成功!');location.replace('CAA102.aspx?V_ID=" + strID + "&mode=VIEW&Code=CAA10" + s_ADDLocation_Replace_String + "');"; } else { strMsg = "alert('" + aryUpd[0].ToString() + "');location.replace('CAA102.aspx?V_ID=" + strID + "&mode=VIEW&Code=CAA10" + s_ADDLocation_Replace_String + "');"; } ScriptManager.RegisterStartupScript(this.btnSave, this.GetType(), "TO_CAA102.aspx", strMsg, true); } else { ParameterList.Clear(); ParameterList.Add(CAAComm.GetValueSetParameter(this.txt_COLL_NO.Text, "string", false)); //V_COLL_NO ParameterList.Add(CAAComm.GetValueSetParameter(Session["UID"].ToString(), "string", false)); //V_NEW_UPDATEUID ParameterList.Add(CAAComm.GetValueSetParameter(strNowDate, "datetime", false)); //D_NEW_UPDATEDATE ParameterList.Add(CAAComm.GetValueSetParameter(dt.Rows[0]["CREATEUID"].ToString(), "string", false)); //V_OLD_CREATEUID ParameterList.Add(CAAComm.GetValueSetParameter(dt.Rows[0]["CREATEDATE"].ToString(), "datetime", false)); //D_OLD_CREATEDATE ParameterList.Add(CAAComm.GetValueSetParameter(dt.Rows[0]["UPDATEUID"].ToString(), "string", false)); //V_OLD_UPDATEUID ParameterList.Add(CAAComm.GetValueSetParameter(dt.Rows[0]["UPDATEDATE"].ToString(), "datetime", false)); //D_OLD_UPDATEDATE ParameterList.Add(CAAComm.GetValueSetParameter(this.txt_MEMO.Text, "string", false)); //V_MEMO BCO.UpdateMemo(ParameterList, null); #region 組合跳轉頁面字串 string s_ADDLocation_Replace_String = string.Empty; try { int i_Count = int.Parse(Request.QueryString["CAA102_COUNT"]); string s_Request_Key = Request.QueryString["CAA102_PageTimeStamp"]; s_ADDLocation_Replace_String = "&CAA102_COUNT=" + i_Count.ToString() + "&CAA102_PageTimeStamp=" + s_Request_Key; } catch { s_ADDLocation_Replace_String = string.Empty; } #endregion strMsg = "alert('儲存成功!');location.replace('CAA102.aspx?V_ID=" + strID + "&mode=VIEW&Code=CAA10" + s_ADDLocation_Replace_String + "');"; ScriptManager.RegisterStartupScript(this.btnSave, this.GetType(), "TO_CAA102.aspx", strMsg, true); } } } catch (Exception ex) { WaringLogProcess(ex.Message); this.ErrorMsgLabel.Text = ex.Message; } finally { } }
private bool CheckWASH_YN() //檢查是否沖帳 { bool bResult = false; if (this.hid_Page_Status.Value == "VIEW" || this.hid_Page_Status.Value == "EDIT") { string strCode = string.Empty; try { if (Request["V_ID"] == null) { throw new Exception("載入頁面失敗!"); } else { strCode = Request["V_ID"].ToString(); } } catch { } ParameterList.Clear(); ParameterList.Add(strCode); //V_ID CAAModel.MaintainCollRecord BCO = new CAAModel.MaintainCollRecord(ConntionDB); dt = BCO.QueryCollRecordByFind(ParameterList); if (dt.Rows[0]["COLL_REMAIN_AMT"].ToString() != dt.Rows[0]["CHK_REMAIN_AMT"].ToString()) bResult = true; } return bResult; }
/// <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; } }