/// <summary> /// 获取学生详细信息 /// </summary> /// <param name="query"></param> /// <returns></returns> public TblStudent GetStudentDetail(TblStudentQuery query) { if (string.IsNullOrEmpty(query.StudentNum)) { return(new TblStudent()); } var student = XuanKeDB.TblStudent.FirstOrDefault(s => s.StudentNum == query.StudentNum); return(student); }
/// <summary> /// 查询所有数据 /// </summary> /// <returns></returns> public List <TblStudent> GetStudentsList(TblStudentQuery query) { List <TblStudent> students = new List <TblStudent>(); students = XuanKeDB.TblStudent .Skip(query.Page * (query.PageIndex - 1)) .Take(query.Page) .OrderByDescending(s => s.CreateTime) .ToList(); return(students); }
public IActionResult StudentResult() { ViewBag.Title = "学生选课系统-学生端-学生信息"; var query = new TblStudentQuery(); var stucode = HttpContext.Session.GetString(SessionCode.username); if (string.IsNullOrEmpty(stucode)) { return(Redirect("../Login/LoginResult")); } var da = new StudentDa { XuanKeDB = DBContext }; query.StudentNum = stucode; var student = da.GetStudentDetail(query); ViewBag.student = student; return(View()); }
public IActionResult StudentResult() { ViewBag.Title = "学生选课系统-后台管理-学生管理"; var admincode = HttpContext.Session.GetString(SessionCode.adminname); if (string.IsNullOrEmpty(admincode)) { return(Redirect("../Login/LoginAdminResult")); } StudentDa da = new StudentDa { XuanKeDB = DBContext }; var query = new TblStudentQuery { PageIndex = 1, Page = 20 }; List <TblStudent> students = da.GetStudentsList(query); ViewBag.students = students; return(View()); }