}//ButtonQuery_Click
private void databind()
{
//抓取本頁初次登記的時間
string SessionIDName = "SYS_CodeFile_" + PageTimeStamp.Value;
ParameterList.Clear();
SYSModel.MaintainCodeFile BCO = new SYSModel.MaintainCodeFile(ConntionDB);
//ParameterList.Add(TextBoxCode.Text);
ParameterList.Add(Category); //CATEGORY
ParameterList.Add(TextBoxName.Text); //NAME
ParameterList.Add(TextBoxScode.Text); //SCODE
ParameterList.Add(TextBoxExplain.Text); //EXPLAIN
ParameterList.Add(TextBoxRowCountLimit.Text.Trim());
DataTable Dt = BCO.QueryByLikeForSLP(ParameterList);
firstpage = 0;
firstindex = -1;
//DataTable Dt = BCO.QueryLineSwitch(SYSModel.MaintainCodeFile.QueryType.CODE,
// ParameterList
// );
Session[SessionIDName] = Dt;
GridView1.DataSource = Dt;
//設定分頁大小
if (TextBoxPagesize.Text == "0")
{
GridView1.PageSize = 1;
}
else
{
GridView1.PageSize = (TextBoxPagesize.Text == "") ? 10 : (int.Parse(TextBoxPagesize.Text) < 0) ? 10 : int.Parse(TextBoxPagesize.Text);
}
GridView1.PageIndex = 0;
GridView1.DataBind();
GridView1.SelectedIndex = -1;
}//databind
private DataTable GetCodeFile(string strCategory)
{
ParameterList.Clear();
SYSModel.MaintainCodeFile BCO = new SYSModel.MaintainCodeFile(ConntionDB);
ParameterList.Add(strCategory); //CATEGORY
ParameterList.Add(""); //NAME
ParameterList.Add(""); //SCODE
ParameterList.Add(""); //EXPLAIN
ParameterList.Add(9999);
return BCO.QueryByLikeForSLP(ParameterList);
}
