public List <Teacher> GetTeacher(TeacherQuery category, string keyWord)
{
List <Teacher> list = new List <Teacher>();
string sql = "SELECT * FROM Teacher where ";
if (String.Compare(category.ToString(), "教师编号", true) == 0)
{
sql = sql + " TeacherID LIKE '%" + keyWord + "%'";
}
else if (String.Compare(category.ToString(), "教师姓名", true) == 0)
{
sql = sql + " TeacherName LIKE '%" + keyWord + "%'";
}
else if (String.Compare(category.ToString(), "教授学科", true) == 0)
{
sql = sql + " TeacherSubject LIKE '%" + keyWord + "%'";
}
else if (String.Compare(category.ToString(), "教师职称", true) == 0)
{
sql = sql + " TeacherRank LIKE '%" + keyWord + "%'";
}
//DataSet ds = SqlHelper.ExecuteDataset(SqlHelper.ConnString, "sp_QueryTeachers", category, keyWord);
DataSet ds = SqlHelper.ExecuteDataset(SqlHelper.ConnString, CommandType.Text, sql);
if (ds.Tables.Count > 0)
{
DataTable dt = ds.Tables[0];
foreach (DataRow row in dt.Rows)
{
Teacher teacher = new Teacher();
teacher.TeacherID = (int)row["TeacherID"];
teacher.TeacherName = (string)row["TeacherName"];
teacher.TeacherSubject = (string)row["TeacherSubject"];
teacher.TeacherRank = (string)row["TeacherRank"];
teacher.TeacherTel = (string)row["TeacherTel"];
list.Add(teacher);
}
}
return(list);
}
