}//Page_Load
private void QueryData()
{
#region
string SessionIDName = string.Format("{0}_{1}", strPrefixed, PageTimeStamp.Value);
DataTable dt = new DataTable();
ALOModel.MaintainHistoryDaily BCO = new ALOModel.MaintainHistoryDaily(ConnectionDB);
ArrayList ParameterList = new ArrayList();
ParameterList.Clear();
ParameterList.Add(SLP_StoreChain1.Text.Trim());
ParameterList.Add(SLP_Store1.Text.Trim());
ParameterList.Add(SLP_SLPDate1.Text.Trim());
ParameterList.Add(SLP_SLPDate2.Text.Trim());
dt = BCO.QueryStoreAcceptItem(ParameterList);
//-----
bAfterQueryDataBinding = true;
if (!dt.Columns.Contains("CHECKED"))//增加欄位以方便判別是否可
dt.Columns.Add("CHECKED");
if (!dt.Columns.Contains("ROWID"))//2010/06/08 added:增加欄位以判別勾選與否
dt.Columns.Add("ROWID");
hidden_RowID_MaxID.Value = dt == null ? "-1" : (dt.Rows.Count - 1).ToString();//2010/06/08 added:記錄最大ROWID
hidden_RowID_Selected.Value = "";//2010/06/08 added:清空已選ROWID
//-----
Session[SessionIDName] = dt;
SetRowIDToDataTable(true);//2010/06/08 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 = "查無資料";
ScriptManager.RegisterStartupScript(UpdatePanel1, this.GetType(), "ClientScript", "alert('查無資料');", true);
}
#endregion
}
}//Page_Load
private void QueryData()
{
#region
string SessionIDName = string.Format("{0}_{1}", PAGE_DT_01, PageTimeStamp.Value);
DataTable Dt = new DataTable();
ALOModel.MaintainHistoryDaily BCO = new ALOModel.MaintainHistoryDaily(ConnectionDB);
ArrayList ParameterList = new ArrayList();//20091113
ParameterList.Clear();
ParameterList.Add(SLP_StoreChain1.Text.Trim());
ParameterList.Add(SLP_Store1.Text.Trim());
ParameterList.Add(SLP_SLPDate1.Text.Trim());
ParameterList.Add(SLP_SLPDate2.Text.Trim());
Dt = BCO.QueryStoreAcceptItem(ParameterList);
Session[SessionIDName] = Dt;
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;
LabelQueryRecordCount.Text = string.Format(" {0} Rows ", Dt.Rows.Count.ToString());
if (Dt == null || (Dt != null && Dt.Rows.Count <= 0))
{
ScriptManager.RegisterStartupScript(UpdatePanel1, this.GetType(), "ClientScript", "alert('查無資料');", true);
}
#endregion
}
