public ActionResult ClassStudentList()
{
using (var db = new XkSystem.Models.DbContext())
{
var vm = new Models.StudentBest.ClassStudentList();
var studentBestIds = db.Table <Student.Entity.tbStudentBest>()
.Select(d => d.tbStudent.Id).ToList();
vm.DataList = (from p in db.Table <Basis.Entity.tbClassStudent>()
where p.tbClass.Id == vm.ClassId &&
(p.tbStudent.StudentName.Contains(vm.SearchText) || p.tbStudent.StudentCode.Contains(vm.SearchText))
orderby p.No
select new Dto.StudentBest.ClassStudentList()
{
Id = p.Id,
No = p.No,
StudentId = p.tbStudent.Id,
StudentCode = p.tbStudent.StudentCode,
StudentName = p.tbStudent.StudentName,
SexName = p.tbStudent.tbSysUser.tbSex.SexName,
IsBest = studentBestIds.Contains(p.tbStudent.Id) ? true : false
}).ToList();
//foreach(var v in )
return(View(vm));
}
}
public ActionResult ClassStudentList(Models.StudentBest.ClassStudentList vm)
{
return(Code.MvcHelper.Post(null, Url.Action("ClassStudentList", new
{
SearchText = vm.SearchText,
ClassId = vm.ClassId
})));
}
