/// <summary>
/// 删除教师信息
/// </summary>
/// <param name="category">下拉列表传值</param>
/// <param name="keyWord">查询关键字</param>
/// <param name="pageIndex">每页索引数</param>
/// <returns></returns>
public ActionResult DeleteTeacher(string category, string keyWord, int pageIndex = 1)
{
int id = Convert.ToInt32(Request.QueryString["id"]);//获取教师id
TeacherManager manager = new TeacherManager();
manager.DeleteTeacherById(id); //调用删除教师方法
List <Teacher> teacher = new List <Teacher>(); //定义教师列表对象
//判断查询关键字是否为空
if (!String.IsNullOrEmpty(category))
{
TeacherQuery cate = (TeacherQuery)Enum.Parse(typeof(TeacherQuery), category);
teacher = new TeacherManager().GetTeacher(cate, keyWord);
}
else
{
teacher = new TeacherManager().GetTeacher();
}
//定义一个pagedList对象
PagedList <Teacher> pagedTeachers = new PagedList <Teacher>(teacher, pageIndex, pageSize);
//提供教师查询方式的下拉框
//调用查询方式
SetDropDownList1(category);
ViewData["keyWord"] = keyWord;
return(View("TeacherList", pagedTeachers));
}
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);
}
/// <summary>
///
/// </summary>
/// <param name="category">列表项</param>
/// <param name="keyWord">查询关键字</param>
/// <param name="pageIndex">列表索引值</param>
/// <returns></returns>
public ActionResult TeacherList(string category, string keyWord, int pageIndex = 1)
{
List <Teacher> teacher = new List <Teacher>();//定义教师列表对象
//判断查询关键字是否为空
if (!String.IsNullOrEmpty(category))
{
TeacherQuery cate = (TeacherQuery)Enum.Parse(typeof(TeacherQuery), category);
teacher = new TeacherManager().GetTeacher(cate, keyWord);
}
else
{
teacher = new TeacherManager().GetTeacher();
}
PagedList <Teacher> pagedTeachers = new PagedList <Teacher>(teacher, pageIndex, pageSize);
//提供书籍查询方式的下拉框书籍
//
SetDropDownList1(category);
//SetDropDownListCategory1();
ViewData["keyWord"] = keyWord;
return(View("TeacherList", pagedTeachers));
}
public List <Teacher> GetTeacher(TeacherQuery category, string keyWord)
{
return(new TeacherService().GetTeacher(category, keyWord));
}
