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));
}
}
