/// <summary> /// 取得商品儲區擷轉明細 /// </summary> private DataTable Get_Data(string s_Page_Load) { #region 傳入參數 ArrayList ParameterList_Session = new ArrayList(); ArrayList ParameterList = new ArrayList();//20091118 if (s_Page_Load == "IS_PAGE_LOAD") { ParameterList_Session = (ArrayList)Session["POP_CRMTransError2_ParameterList"]; if (ParameterList_Session != null) { this.slp_TRANS_DATE.Text = ((DateTime)ParameterList_Session[0]).ToString("yyyy/MM/dd"); this.slp_ST_ACCEPT_DATE.Text = ((DateTime)ParameterList_Session[1]).ToString("yyyy/MM/dd"); this.SLP_RootNo1.Text = ParameterList_Session[2].ToString(); this.slp_IS_OVERDUE.SelectedValue = ParameterList_Session[3].ToString(); this.txt_TRANS_NO_B.Text = ParameterList_Session[4].ToString(); this.txt_TRANS_NO_E.Text = ParameterList_Session[5].ToString(); ParameterList.Add(Session["UID"].ToString()); ParameterList_Session.Add(GetValueSetParameter("9999", "int", false)); } } else if (s_Page_Load == "NOT_PAGE_LOAD") { ParameterList.Clear(); ParameterList.Add(GetValueSetParameter(this.slp_TRANS_DATE.Text, "date", false)); ParameterList.Add(GetValueSetParameter(this.slp_ST_ACCEPT_DATE.Text, "date", false)); ParameterList.Add(GetValueSetParameter(this.SLP_RootNo1.Text.Trim(), "int", false)); ParameterList.Add(GetValueSetParameter(this.slp_IS_OVERDUE.SelectedValue, "int", false)); ParameterList.Add(GetValueSetParameter(this.txt_TRANS_NO_B.Text, "string", false)); ParameterList.Add(GetValueSetParameter(this.txt_TRANS_NO_E.Text, "string", false)); ParameterList.Add(Session["UID"].ToString()); ParameterList.Add(GetValueSetParameter(this.TextBoxRowCountLimit.Text.Trim(), "int", false)); } #endregion #region 取得資料 DataTable dt_Return = new DataTable(); BCO.QueryCRMCommon bco = new BCO.QueryCRMCommon(ConntionDB); try { if (s_Page_Load == "IS_PAGE_LOAD") { dt_Return = bco.QueryTransErrorData(ParameterList_Session); } else if (s_Page_Load == "NOT_PAGE_LOAD") { dt_Return = bco.QueryTransErrorData(ParameterList); } } catch (Exception ex) { throw ex; } #endregion #region 資料與GridView繫結 //抓取本頁初次登記的時間 string SessionIDName = "CRM071_POP_" + 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; }