/// <summary> /// 取得商品儲區擷轉明細 /// </summary> private DataTable QueryData() { #region #region 傳入參數 ArrayList ParameterList = new ArrayList(); ParameterList.Clear(); ParameterList.Add(GetValueSetParameter(slp_TRANS_DATE.Text, "date", false)); ParameterList.Add(GetValueSetParameter(slp_ST_ACCEPT_DATE.Text, "date", false)); ParameterList.Add(GetValueSetParameter(SLP_RootNo1.Text.Trim(), "int", false)); ParameterList.Add(GetValueSetParameter(slp_IS_OVERDUE.SelectedValue, "int", false)); ParameterList.Add(GetValueSetParameter(txt_TRANS_NO_B.Text, "string", false)); ParameterList.Add(GetValueSetParameter(txt_TRANS_NO_E.Text, "string", false)); ParameterList.Add(Session["UID"].ToString()); if (!IsPostBack) { ParameterList.Add(GetValueSetParameter("9999", "int", false)); } else { ParameterList.Add(GetValueSetParameter(TextBoxRowCountLimit.Text.Trim(), "int", false)); } #endregion #region 取得資料 DataTable dt_Return = new DataTable(); BCO.QueryCRMCommon bco = new BCO.QueryCRMCommon(ConntionDB); try { dt_Return = bco.QUERY_NON_TRANSDATA(ParameterList); } catch (Exception ex) { ErrorMsgLabel.Text = ex.Message; } #endregion #region 資料與GridView繫結 string SessionIDName = "CRM071A_" + PageTimeStamp.Value; Session["SessionID"] = SessionIDName; Session[SessionIDName] = dt_Return; this.gv_TransErrData.DataSource = dt_Return; this.gv_TransErrData.PageSize = (this.TextBoxPagesize.Text == string.Empty) ? 10 : (int.Parse(this.TextBoxPagesize.Text) <= 0) ? 10 : int.Parse(this.TextBoxPagesize.Text); this.gv_TransErrData.PageIndex = 0; this.gv_TransErrData.DataBind(); #endregion return dt_Return; #endregion }