}//Page_Load
private void QueryData()
{
#region
string SessionIDName = string.Format("{0}_{1}", strPrefixed, PageTimeStamp.Value);
DataTable dt = new DataTable();
ALOModel.QueryALOCommon BCO = new ALOModel.QueryALOCommon(ConnectionDB);
string strQueryType = GetQueryTypeOfCalssAndItem();
string strWhere = "";
strWhere = GetQuerySQLStatement();
ArrayList ParameterList = new ArrayList();
ParameterList.Clear();
ParameterList.Add(strWhere);
Int32 iTopRowNum;
Int32.TryParse(TextBoxRowCountLimit.Text.Trim(), out iTopRowNum);
ParameterList.Add(iTopRowNum);
switch (strQueryType)
{
#region
case "1":
if (SLP_Item1.Text.Trim() == "" && SLP_Item2.Text.Trim() == "")
{
//選擇大分類查詢結果，且商品起迄輸入為空值時
dt = BCO.QuerySwitch(PIC.VDS2G.BSM.ALO.QueryALOCommon.QueryTypeOfCalssAndItem.PMA, ParameterList);
}
else
{
//選擇大分類查詢結果，且商品起迄輸入不為空值時
dt = BCO.QuerySwitch(PIC.VDS2G.BSM.ALO.QueryALOCommon.QueryTypeOfCalssAndItem.PMA2, ParameterList);
}
break;
case "2":
if (SLP_Item1.Text.Trim() == "" && SLP_Item2.Text.Trim() == "")
{
//選擇Pattern查詢結果，且商品起迄輸入為空值時
dt = BCO.QuerySwitch(PIC.VDS2G.BSM.ALO.QueryALOCommon.QueryTypeOfCalssAndItem.PATTERN, ParameterList);
}
else
{
//選擇Pattern查詢結果，且商品起迄輸入不為空值時
dt = BCO.QuerySwitch(PIC.VDS2G.BSM.ALO.QueryALOCommon.QueryTypeOfCalssAndItem.PATTERN2, ParameterList);
}
break;
case "3":
//選擇商品查詢結果時
dt = BCO.QuerySwitch(PIC.VDS2G.BSM.ALO.QueryALOCommon.QueryTypeOfCalssAndItem.ITEM, ParameterList);
break;
default:
dt = BCO.QuerySwitch(PIC.VDS2G.BSM.ALO.QueryALOCommon.QueryTypeOfCalssAndItem.EMPTY, ParameterList);
break;
#endregion
}
bAfterQueryDataBinding = true;
if (!dt.Columns.Contains("CHECKED"))//增加欄位以方便判別是否可
dt.Columns.Add("CHECKED");
if (!dt.Columns.Contains("ROWID"))//2010/03/09 added:增加欄位以判別勾選與否
dt.Columns.Add("ROWID");
hidden_RowID_MaxID.Value = dt == null ? "-1" : (dt.Rows.Count - 1).ToString();//2010/03/09 added:記錄最大ROWID
hidden_RowID_Selected.Value = "";//2010/03/09 added:清空已選ROWID
Session[SessionIDName] = dt;
SetRowIDToDataTable(true);//2010/03/09 added:設定ROWID
GridView1.DataSource = dt;
GridView1.PageSize = (TextBoxPagesize.Text == "") ? 10 : (int.Parse(TextBoxPagesize.Text) <= 0) ? 10 : int.Parse(TextBoxPagesize.Text);
GridView1.PageIndex = 0;
GridView1.DataBind();
GridView1.SelectedIndex = -1;
GridView2.DataSource = null;
GridView2.DataBind();
bAfterQueryDataBinding = false;
LabelQueryRecordCount.Text = string.Format(" {0} Rows ", dt.Rows.Count.ToString());
if (dt == null || (dt != null && dt.Rows.Count <= 0))
{
ResultMsgLabel.Text = "查無資料";
}
#endregion
}
