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