public ActionResult List() { using (var db = new XkSystem.Models.DbContext()) { var vm = new Models.ClassAllotClass.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(); } var tb = from p in db.Table <Basis.Entity.tbClassAllotClass>() select p; if (!string.IsNullOrEmpty(vm.SearchText)) { tb = tb.Where(d => d.ClassName.Contains(vm.SearchText)); } if (vm.YearId > 0) { tb = tb.Where(d => d.tbYear.Id == vm.YearId); } vm.ClassAllotClassList = (from p in tb orderby p.No, p.ClassName select new Dto.ClassAllotClass.List { Id = p.Id, No = p.No, ClassName = p.ClassName, ClassTypeName = p.tbClassType.ClassTypeName, GradeName = p.tbGrade.GradeName, YearName = p.tbYear.YearName }).ToList(); return(View(vm)); } }
public ActionResult List(Models.ClassAllotClass.List vm) { return(Code.MvcHelper.Post(null, Url.Action("List", new { searchText = vm.SearchText, yearId = vm.YearId }))); }