public ActionResult TeacherList(Models.OrgManager.TeacherList vm) { return(Code.MvcHelper.Post(null, Url.Action("TeacherList", new { searchText = vm.SearchText, pageIndex = vm.Page.PageIndex, pageSize = vm.Page.PageSize }))); }
public ActionResult TeacherList() { using (var db = new XkSystem.Models.DbContext()) { var vm = new Models.OrgManager.TeacherList(); var tb = from p in db.Table <Course.Entity.tbOrgManager>() select p; if (string.IsNullOrEmpty(vm.SearchText) == false) { tb = tb.Where(d => d.tbTeacher.TeacherName.Contains(vm.SearchText)); } vm.DataList = (from p in tb group p by new { p.tbTeacher.Id, p.tbTeacher.TeacherName } into g orderby g.Key.Id select new Dto.OrgManager.TeacherList { Id = g.Key.Id, TeacherId = g.Key.Id, TeacherName = g.Key.TeacherName }).ToPageList(vm.Page); var tbOrgManagerList = (from p in db.Table <Course.Entity.tbOrgManager>() select new Dto.OrgManager.TeacherOrgList { Id = p.tbTeacher.Id, OrgName = p.tbOrg.OrgName }).ToList(); var index = 0; foreach (var a in vm.DataList) { index++; a.No = index; a.OrgNames = string.Join(",", tbOrgManagerList.Where(d => d.Id == a.TeacherId).Select(d => d.OrgName)); } return(View(vm)); } }