public ActionResult List() { using (var db = new XkSystem.Models.DbContext()) { var vm = new Models.ElectiveRule.List(); vm.ElectiveName = db.Table <Entity.tbElective>().FirstOrDefault(d => d.Id == vm.ElectiveId).ElectiveName; var tb = from p in db.Table <Entity.tbElectiveRule>() where p.tbElective.Id == vm.ElectiveId select p; if (string.IsNullOrEmpty(vm.SearchText) == false) { tb = tb.Where(d => d.tbCourse.CourseName.Contains(vm.SearchText)); } vm.ElectiveRuleList = (from p in tb orderby p.No select new Dto.ElectiveRule.List { Id = p.Id, No = p.No, CourseId = p.tbCourse.Id, CourseName = p.tbCourse.CourseName, CourseTarget = p.tbCourseTarget.CourseName, ElectiveRule = p.ElectiveRule }).ToList(); vm.CourseList = (from p in db.Table <Entity.tbElectiveOrg>() where p.tbElective.Id == vm.ElectiveId group p by new { p.tbCourse.Id, p.tbCourse.CourseCode, p.tbCourse.CourseName } into g select new Course.Dto.Course.SimpleInfo() { Id = g.Key.Id, CourseCode = g.Key.CourseCode, CourseName = g.Key.CourseName }).ToList(); return(View(vm)); } }
public ActionResult List(Models.ElectiveRule.List vm) { return(Code.MvcHelper.Post(null, Url.Action("List", new { searchText = vm.SearchText, electiveId = vm.ElectiveId }))); }