/// <summary> /// 查詢資料庫取得資料 /// </summary> private void databind() { //抓取本頁初次登記的時間 string SessionIDName = "SYS061_" + PageTimeStamp.Value; SYSModel.MaintainProgram BCO = new SYSModel.MaintainProgram(ConntionDB); ParameterList.Clear(); ParameterList.Add(TextBoxCode.Text.Trim()); ParameterList.Add(TextBoxName.Text.Trim()); ParameterList.Add(TextBoxCreateDate.StartDate.Trim()); ParameterList.Add(TextBoxCreateDate.EndDate.Trim()); ParameterList.Add(TextBoxCreateUID.Text.Trim()); ParameterList.Add(TextBoxUpdateDate.StartDate.Trim()); ParameterList.Add(TextBoxUpdateDate.EndDate.Trim()); ParameterList.Add(TextBoxUpdateUID.Text.Trim()); ParameterList.Add(TextBoxDescription.Text.Trim()); ParameterList.Add(TextBoxSystemCode.Text.Trim()); ParameterList.Add(TextBoxParentCode.Text.Trim()); ParameterList.Add(TextBoxLinkUrl.Text.Trim()); ParameterList.Add(((DropDownList)TextBoxDisplayOrder.FindControl("D1")).SelectedValue);//operator ParameterList.Add(TextBoxDisplayOrder.Text.Trim()); ParameterList.Add(((DropDownList)SLP_ProgramType.FindControl("D1")).SelectedValue); ParameterList.Add("1");// (SLP_IsVisual.Text.Trim()); ParameterList.Add("1");//SLP_Enable.Text.Trim()); ParameterList.Add(TextBoxRowCountLimit.Text.Trim()); DataTable Dt = BCO.QueryRow(ParameterList, CheckBoxLikeSearch.Checked); 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(); #region 將Key值存到Session中 ArrayList arl_Key = new ArrayList(); foreach (DataRow drRow in Dt.Rows) { arl_Key.Add("id=" + drRow["ID"].ToString()); } Session["SYS06_SortKey" + this.PageTimeStamp.Value] = arl_Key; #endregion if (Dt.Rows.Count == 0) { this.ErrorMsgLabel.Text = "查無資料"; } }