public ActionResult List(Models.ClassAllotStudent.List vm) { return(Code.MvcHelper.Post(null, Url.Action("List", new { searchText = vm.SearchText, yearId = vm.YearId, sexId = vm.SexId, classTypeId = vm.ClassTypeId, pageIndex = vm.Page.PageIndex, pageSize = vm.Page.PageSize }))); }
public ActionResult List() { using (var db = new XkSystem.Models.DbContext()) { var vm = new Models.ClassAllotStudent.List(); vm.YearList = YearController.SelectList(Code.EnumHelper.YearType.Year); if (vm.YearId == 0 && vm.YearList.Count > 0) { vm.YearId = vm.YearList.OrderByDescending(d => d.Selected).FirstOrDefault().Value.ConvertToInt(); } vm.ClassTypeList = ClassTypeController.SelectList(); vm.SexList = Dict.Controllers.DictSexController.SelectList(); var tb = from p in db.Table <Basis.Entity.tbClassAllotStudent>() where p.tbYear.Id == vm.YearId select p; if (!string.IsNullOrEmpty(vm.SearchText)) { tb = tb.Where(d => d.tbStudent.StudentName.Contains(vm.SearchText) || d.tbStudent.StudentCode.Contains(vm.SearchText)); } if (vm.ClassTypeId != 0) { tb = tb.Where(d => d.tbClassType.Id == vm.ClassTypeId); } if (vm.SexId != 0) { tb = tb.Where(d => d.tbStudent.tbSysUser.tbSex.Id == vm.SexId); } vm.ClassAllotStudentList = (from p in tb orderby p.tbStudent.StudentCode, p.tbStudent.StudentName select new Dto.ClassAllotStudent.List { Id = p.Id, Score = p.Score, ClassTypeName = p.tbClassType.ClassTypeName, GradeName = p.tbGrade.GradeName, StudentCode = p.tbStudent.StudentCode, StudentName = p.tbStudent.StudentName, Sex = p.tbStudent.tbSysUser.tbSex.SexName }).ToPageList(vm.Page); return(View(vm)); } }