/// <summary> /// 获取列表 /// </summary> /// <returns></returns> public static List <VModel.SyClass.Grid> GetGrid(VModel.SyClass.Index m) { List <VModel.SyClass.Grid> list = new List <VModel.SyClass.Grid>(); IQueryable <sy_class> dbList = null; using (var db = new fz_basicEntities()) { dbList = db.sy_class.Where(w => w.sy_grade.IsEnabled == true && w.sy_grade.IsGraduate == false).OrderByDescending(o => o.sy_grade.Year).ThenBy(o => o.Sort); if (m.GradeId != null) { dbList = dbList.Where(w => w.GradeId == m.GradeId); } if (!string.IsNullOrWhiteSpace(m.Key)) { IQueryable <int> tIds = db.sy_teacher.Where(w => w.Name.Contains(m.Key)).Select(s => s.Id); IQueryable <int> cIds = db.sy_teacher_and_class_and_subject.Where(w => tIds.Contains(w.TeacherId)).Select(s => s.ClassId).Distinct(); dbList = dbList.Where(w => cIds.Contains(w.Id)); } list = dbList.Select(s => new VModel.SyClass.Grid { Id = s.Id, Name = s.Name, GradeName = s.sy_grade.Name, Year = s.sy_grade.Year, Sort = s.Sort, StudentCount = s.sy_student.Where(w => w.UserId != null && w.sy_user.IsEnabled).Count(), IsEnabled = s.IsEnabled, _GridTCS = s.sy_teacher_and_class_and_subject.Select(s1 => new VModel.SyClass.GridTCS { Subject = s1.Subject, TeacherId = s1.TeacherId }).ToList() }).ToList(); } return(list); }
public ActionResult Index(VModel.SyClass.Index m) { m.Grades = Bll.SyGradeBll.GetSelect(); m.Grid = Bll.SyClassBll.GetGrid(m); return(View(m)); }