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