public ActionResult DeanIndex(string searchName, string orderField = "State desc", int pageIndex = 1)
{
if (Session["type"] == null || (int)Session["type"] != 3)
{
return(Redirect("/TBsys/Login/Index"));
}
if (TimeChecked())
{
ViewBag.flag = 1;
}
else
{
ViewBag.flag = 0;
}
T_SH_Teacher teacher = (T_SH_Teacher)Session["person"];
IEnumerable <T_TB_Choose> query = db.T_TB_Choose.Where(m => m.T_TB_TeachingTask.DepartmentId == teacher.DepartmentId);
if (string.IsNullOrEmpty(searchName))
{
}
else
{
query = query.Where(m => m.T_TB_TeachingTask.CourseName.Contains(searchName));
}
#region 排序逻辑
// orderField
switch (orderField)
{
case "Id desc":
query = query.OrderByDescending(m => m.Id);
break;
case "State desc":
query = query.OrderBy(m => m.State);
break;
default:
break;
}
#endregion
#region 分页实现
int recordCount = query.Count();
query = query.Skip((pageIndex - 1) * pageSize).Take(pageSize);
ViewBag.pageIndex = pageIndex;
ViewBag.pageSize = pageSize;
ViewBag.recordCount = recordCount;
#endregion
ViewBag.list = query.ToList();
return(View());
}
public JsonResult UpdatePwd(string oldpwd, string newpwd, string newpwd2)
{
string stuId = (string)Session["Id"];
T_SH_Teacher person = db.T_SH_Teacher.Find(stuId);
if (!person.Password.Equals(oldpwd))
{
return(Json(new { code = 1 }, JsonRequestBehavior.AllowGet));
}
else if (!newpwd.Equals(newpwd2))
{
return(Json(new { code = 2 }, JsonRequestBehavior.AllowGet));
}
else if (newpwd.Equals("") || newpwd2.Equals(""))
{
return(Json(new { code = 3 }, JsonRequestBehavior.AllowGet));
}
else
{
person.Password = newpwd;
db.SaveChanges();
return(Json(new { code = 0 }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult NoBookList(string orderField = "Index desc", int pageIndex = 1)
{
if (Session["type"] == null || (int)Session["type"] != 3)
{
return(Redirect("/TBsys/Login/Index"));
}
T_SH_Teacher teacher = (T_SH_Teacher)Session["person"];
var query = db.T_TB_TeachingTask.Where(m => m.DepartmentId == teacher.DepartmentId && m.State != 4);
#region 排序逻辑
// orderField
switch (orderField)
{
case "Index desc":
query = query.OrderBy(m => m.TeacherId);
break;
default:
break;
}
#endregion
#region 分页实现
int recordCount = query.Count();
query = query.Skip((pageIndex - 1) * pageSize).Take(pageSize);
ViewBag.pageIndex = pageIndex;
ViewBag.pageSize = pageSize;
ViewBag.recordCount = recordCount;
#endregion
ViewBag.list = query.ToList();
return(View());
}