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