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