//初始 public void ListBind() { DatalistQ.DataSource = CreateSource(); DatalistQ.DataBind(); lbnNextPage.Enabled = true; lbnPrevPage.Enabled = true; if (CurrentPage == (PageCount - 1)) { lbnNextPage.Enabled = false; } if (CurrentPage == 0) { lbnPrevPage.Enabled = false; } lblCurrentPage.Text = (CurrentPage + 1).ToString(); }
//搜索功能 public void Search_OnClick(Object sender, CommandEventArgs e) { string searchStr = SearchText.Value.Trim(); if (searchStr == null || searchStr == "") { string connStr = "Data Source=59.110.235.44;Initial Catalog=hongruan;User ID=hrdev;Password=123hrdev456"; string sqlStr = "select * from QandA join unit on QandA.UnitID= Unit.UnitID join Class on Class.ClassID=Unit.ClassID join Manager_Class on Manager_Class.ClassID=Class.ClassID join Student on student.StudentID=QandA.StudentID join Department on Student.DepartmentID=Department.DepartmentID where (Manager_Class.ManagerID=1 and QandA.AnswerContent is null)"; SqlConnection conn = new SqlConnection(connStr); SqlCommand cmd = conn.CreateCommand(); conn.Open(); SqlDataAdapter sda = new SqlDataAdapter(sqlStr, conn); DataSet ds = new DataSet(); sda.Fill(ds); DatalistQ.DataSource = ds; DatalistQ.DataBind(); } else if (isSearchValid(searchStr)) { //准备编写查询数据库,绑定datalist的代码 //Response.Write(handleSearch(searchStr)); string connStr = "Data Source=59.110.235.44;Initial Catalog=hongruan;User ID=hrdev;Password=123hrdev456"; string sqlStr = "select * from QandA join unit on QandA.UnitID= Unit.UnitID join Class on Class.ClassID=Unit.ClassID join Manager_Class on Manager_Class.ClassID=Class.ClassID join Student on student.StudentID=QandA.StudentID join Department on Student.DepartmentID=Department.DepartmentID where (Manager_Class.ManagerID=1 and QandA.AnswerContent is null and (QuestionTitle like '" + handleSearch(searchStr) + "' or QuestionContent like '" + handleSearch(searchStr) + "'))"; SqlConnection conn = new SqlConnection(connStr); SqlCommand cmd = conn.CreateCommand(); conn.Open(); SqlDataAdapter sda = new SqlDataAdapter(sqlStr, conn); DataSet ds = new DataSet(); sda.Fill(ds); DatalistQ.DataSource = ds; DatalistQ.DataBind(); if (sda == null) { Response.Write("<script>alert('对不起,没有您想要的内容')</script>"); } conn.Close(); Page1.Attributes.Add("style", "display:none"); Page2.Attributes.Add("style", "display:none"); } else { Response.Write("<script>alert('搜索内容含有恶意字符')</script>"); } }