public ActionResult List() { using (var db = new XkSystem.Models.DbContext()) { var vm = new Models.StudentChange.List(); var tb = from p in db.Table <Student.Entity.tbStudentChange>() select p; if (string.IsNullOrEmpty(vm.SearchText) == false) { tb = tb.Where(d => d.tbStudentChangeType.StudentChangeTypeName.Contains(vm.SearchText) || d.tbSysUser.UserCode.Contains(vm.SearchText) || d.tbSysUser.UserName.Contains(vm.SearchText) || d.tbStudent.StudentCode.Contains(vm.SearchText) || d.tbStudent.StudentName.Contains(vm.SearchText) || d.tbStudent.StudentNameEn.Contains(vm.SearchText)); } vm.StudentChangeList = (from p in tb orderby p.InputDate descending select new Dto.StudentChange.List { Id = p.Id, StudentCode = p.tbStudent.StudentCode, StudentName = p.tbStudent.StudentName, StudentChangeTypeName = p.tbStudentChangeType.StudentChangeTypeName, InputDate = p.InputDate, UserName = p.tbSysUser.UserName, StudentChangeType = p.tbStudentChangeType.StudentChangeType }).ToPageList(vm.Page); return(View(vm)); } }
public ActionResult List(Models.StudentChange.List vm) { return(Code.MvcHelper.Post(null, Url.Action("List", new { searchText = vm.SearchText, pageIndex = vm.Page.PageIndex, pageSize = vm.Page.PageSize }))); }