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