public ActionResult GradeStudentList(Models.StudentBest.GradeStudentList vm)
{
return(Code.MvcHelper.Post(null, Url.Action("GradeStudentList", new
{
SearchText = vm.SearchText,
GradeId = vm.GradeId,
pageIndex = vm.Page.PageIndex,
pageSize = vm.Page.PageSize
})));
}
public ActionResult GradeStudentList()
{
using (var db = new XkSystem.Models.DbContext())
{
var vm = new Models.StudentBest.GradeStudentList();
var bestStudentIds = db.Table <Student.Entity.tbStudentBest>()
.Select(d => d.tbStudent.Id).ToList();
vm.GradeList = Basis.Controllers.GradeController.SelectList();
if (vm.GradeId <= 0)
{
vm.GradeList.FirstOrDefault().Selected = true;
vm.GradeId = vm.GradeList.FirstOrDefault().Value.ConvertToInt();
}
var tb = db.Table <Basis.Entity.tbClassStudent>();
if (vm.GradeId > 0)
{
tb = tb.Where(d => d.tbClass.tbGrade.Id == vm.GradeId);
}
if (string.IsNullOrWhiteSpace(vm.SearchText))
{
tb = tb.Where(d => d.tbClass.ClassName.Contains(vm.SearchText) ||
d.tbStudent.StudentName.Contains(vm.SearchText) ||
d.tbStudent.StudentCode.Contains(vm.SearchText));
}
vm.DataList = (from p in tb
orderby p.No
select new Dto.StudentBest.GradeStudentList()
{
ClassName = p.tbClass.ClassName,
StudentId = p.tbStudent.Id,
StudentCode = p.tbStudent.StudentCode,
StudentName = p.tbStudent.StudentName,
SexName = p.tbStudent.tbSysUser.tbSex.SexName
}).ToPageList(vm.Page);
foreach (var v in vm.DataList)
{
v.IsBest = bestStudentIds.Contains(v.StudentId) ? true : false;
}
return(View(vm));
}
}
