public ActionResult Edit(int id = 0) { using (var db = new XkSystem.Models.DbContext()) { var vm = new Models.ClassAllotStudent.Edit(); vm.GradeList = GradeController.SelectList(); vm.ClassTypeList = ClassTypeController.SelectList(); vm.YearList = YearController.SelectList(Code.EnumHelper.YearType.Year); if (vm.ClassAllotStudentEdit.YearId == 0 && vm.YearList.Count > 0) { vm.ClassAllotStudentEdit.YearId = vm.YearList.OrderByDescending(d => d.Selected).FirstOrDefault().Value.ConvertToInt(); } if (id != 0) { vm.ClassAllotStudentEdit = (from p in db.Table <Basis.Entity.tbClassAllotStudent>() where p.Id == id select new Dto.ClassAllotStudent.Edit { Id = p.Id, YearId = p.tbYear.Id, ClassTypeId = p.tbClassType.Id, GradeId = p.tbGrade.Id, Score = p.Score, StudentCode = p.tbStudent.StudentCode, StudentName = p.tbStudent.StudentName }).FirstOrDefault(); } return(View(vm)); } }
public ActionResult ClassStudentList() { var vm = new Models.ClassStudent.ClassStudentList(); using (var db = new XkSystem.Models.DbContext()) { vm.ClassTypeList = ClassTypeController.SelectList(); vm.GradeList = GradeController.SelectList(); vm.YearList = YearController.SelectList(Code.EnumHelper.YearType.Year); if (vm.YearId == 0 && vm.YearList.Count > 0) { vm.YearId = vm.YearList.OrderByDescending(d => d.Selected).FirstOrDefault().Value.ConvertToInt(); } vm.ClassList = ClassController.SelectList(vm.YearId ?? 0, vm.GradeId); var tb = db.Table <Basis.Entity.tbClassStudent>(); if (vm.ClassTypeId > 0) { tb = tb.Where(d => d.tbClass.tbClassType.Id == vm.ClassTypeId); } if (vm.GradeId > 0) { tb = tb.Where(d => d.tbClass.tbGrade.Id == vm.GradeId); } if (vm.YearId > 0) { tb = tb.Where(d => d.tbClass.tbYear.Id == vm.YearId); } if (vm.ClassId != 0) { tb = tb.Where(d => d.tbClass.Id == vm.ClassId); } if (!string.IsNullOrEmpty(vm.SearchText)) { tb = tb.Where(d => d.tbStudent.StudentCode.Contains(vm.SearchText) || d.tbStudent.StudentName.Contains(vm.SearchText)); } vm.List = (from p in tb orderby p.tbClass.No, p.tbStudent.StudentCode select new Dto.ClassStudent.ClassStudentList() { ClassId = p.tbClass.Id, ClassName = p.tbClass.ClassName, GradeName = p.tbClass.tbGrade.GradeName, Id = p.Id, No = p.No, SexName = p.tbStudent.tbSysUser.tbSex.SexName, StudentCode = p.tbStudent.StudentCode, StudentId = p.tbStudent.Id, StudentName = p.tbStudent.StudentName }).ToPageList(vm.Page); } return(View(vm)); }
public ActionResult Batch() { using (var db = new XkSystem.Models.DbContext()) { var vm = new Models.ClassAllotClass.Batch(); vm.YearList = YearController.SelectList(Code.EnumHelper.YearType.Year); if (vm.BatchEdit.YearId == 0 && vm.YearList.Count > 0) { vm.BatchEdit.YearId = vm.YearList.OrderByDescending(d => d.Selected).FirstOrDefault().Value.ConvertToInt(); } vm.GradeList = GradeController.SelectList(); vm.ClassTypeList = ClassTypeController.SelectList(); return(View(vm)); } }
public ActionResult List() { using (var db = new XkSystem.Models.DbContext()) { var vm = new Models.ClassAllotStudent.List(); vm.YearList = YearController.SelectList(Code.EnumHelper.YearType.Year); if (vm.YearId == 0 && vm.YearList.Count > 0) { vm.YearId = vm.YearList.OrderByDescending(d => d.Selected).FirstOrDefault().Value.ConvertToInt(); } vm.ClassTypeList = ClassTypeController.SelectList(); vm.SexList = Dict.Controllers.DictSexController.SelectList(); var tb = from p in db.Table <Basis.Entity.tbClassAllotStudent>() where p.tbYear.Id == vm.YearId select p; if (!string.IsNullOrEmpty(vm.SearchText)) { tb = tb.Where(d => d.tbStudent.StudentName.Contains(vm.SearchText) || d.tbStudent.StudentCode.Contains(vm.SearchText)); } if (vm.ClassTypeId != 0) { tb = tb.Where(d => d.tbClassType.Id == vm.ClassTypeId); } if (vm.SexId != 0) { tb = tb.Where(d => d.tbStudent.tbSysUser.tbSex.Id == vm.SexId); } vm.ClassAllotStudentList = (from p in tb orderby p.tbStudent.StudentCode, p.tbStudent.StudentName select new Dto.ClassAllotStudent.List { Id = p.Id, Score = p.Score, ClassTypeName = p.tbClassType.ClassTypeName, GradeName = p.tbGrade.GradeName, StudentCode = p.tbStudent.StudentCode, StudentName = p.tbStudent.StudentName, Sex = p.tbStudent.tbSysUser.tbSex.SexName }).ToPageList(vm.Page); return(View(vm)); } }