//初始 public void ListBind() { DatalistDis.DataSource = CreateSource(); DatalistDis.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 Class.ClassName,Unit.UnitName,DiscussUnit.DiscussContent,DiscussUnit.DiscussTime,DiscussUnit.DisscusID,Student.StudentName,Department.DepartmentName FROM Manager LEFT JOIN Manager_Class ON Manager_Class.ManagerID=Manager.ManagerID LEFT JOIN Class on Class.ClassID=Manager_Class.ClassID LEFT JOIN Unit on Unit.ClassID=Class.ClassID LEFT JOIN DiscussUnit on DiscussUnit.UnitID=Unit.UnitID LEFT JOIN Student on Student.StudentID=DiscussUnit.StudentID LEFT JOIN Department on Department.DepartmentID=Student.DepartmentID where (Manager.ManagerID='" + managerid + "'and DiscussUnit.DiscussContent is not 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); DatalistDis.DataSource = ds; DatalistDis.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 Class.ClassName,Unit.UnitName,DiscussUnit.DiscussContent,DiscussUnit.DiscussTime,DiscussUnit.DisscusID,Student.StudentName,Department.DepartmentName FROM Manager LEFT JOIN Manager_Class ON Manager_Class.ManagerID=Manager.ManagerID LEFT JOIN Class on Class.ClassID=Manager_Class.ClassID LEFT JOIN Unit on Unit.ClassID=Class.ClassID LEFT JOIN DiscussUnit on DiscussUnit.UnitID=Unit.UnitID LEFT JOIN Student on Student.StudentID=DiscussUnit.StudentID LEFT JOIN Department on Department.DepartmentID=Student.DepartmentID where (Manager.ManagerID='" + managerid + "'and DiscussUnit.DiscussContent is not null and DiscussContent 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); DatalistDis.DataSource = ds; DatalistDis.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>"); } }