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