public ActionResult List() { var vm = new Models.DormTeacher.List(); vm.BuildList = Areas.Basis.Controllers.BuildController.SelectList(); using (var db = new XkSystem.Models.DbContext()) { var tb = db.Table <Dorm.Entity.tbDormTeacher>(); if (!string.IsNullOrEmpty(vm.SearchText)) { tb = tb.Where(d => d.tbRoom.RoomName.Contains(vm.SearchText) || d.tbTeacher.TeacherName.Contains(vm.SearchText) || d.tbTeacher.TeacherCode.Contains(vm.SearchText)); } if (vm.BuildId > 0) { tb = tb.Where(d => d.tbRoom.tbBuild.Id == vm.BuildId); } vm.DormTeacherList = (from p in tb orderby p.No select new Dto.DormTeacher.List() { Id = p.Id, No = p.No, BuildName = p.tbRoom.tbBuild.BuildName, RoomName = p.tbRoom.RoomName, TeacherCode = p.tbTeacher.TeacherCode, TeacherName = p.tbTeacher.TeacherName }).ToPageList(vm.Page); } return(View(vm)); }
public ActionResult List(Models.DormTeacher.List vm) { return(Code.MvcHelper.Post(null, Url.Action("List", new { SearchText = vm.SearchText, BuildId = vm.BuildId, pageIndex = vm.Page.PageIndex, pageSize = vm.Page.PageSize }))); }