public ActionResult List() { using (var db = new XkSystem.Models.DbContext()) { var vm = new Models.ExamRoom.List(); var tb = from p in db.Table <Exam.Entity.tbExamRoom>() where p.tbExamCourse.IsDeleted == false && p.tbExamCourse.tbCourse.IsDeleted == false && p.tbRoom.IsDeleted == false && p.tbExamCourse.Id == vm.ExamCourseId select p; if (string.IsNullOrEmpty(vm.SearchText) == false) { tb = tb.Where(d => d.ExamRoomName.Contains(vm.SearchText)); } vm.ExamRoomList = (from p in tb orderby p.No descending select new Dto.ExamRoom.List { Id = p.Id, ExamCourseName = p.tbExamCourse.tbCourse.CourseName, ExamRoomName = p.ExamRoomName, RoomName = p.tbRoom.RoomName, RowSeat = p.RowSeat }).ToList(); return(View(vm)); } }
public ActionResult ExamRoomStudentList() { using (var db = new XkSystem.Models.DbContext()) { var vm = new Models.ExamRoom.List(); vm.ExamList = Exam.Controllers.ExamController.SelectList(); if (vm.ExamId == 0 && vm.ExamList.Count > 0) { vm.ExamId = vm.ExamList.FirstOrDefault().Value.ConvertToInt(); } var tb = from p in db.Table <Exam.Entity.tbExamRoom>() where p.tbExamCourse.IsDeleted == false && p.tbExamCourse.tbCourse.IsDeleted == false && p.tbRoom.IsDeleted == false && p.tbExamCourse.tbExamSchedule.IsDeleted == false && p.tbExamCourse.tbExamSchedule.tbExam.Id == vm.ExamId select p; if (string.IsNullOrEmpty(vm.SearchText) == false) { tb = tb.Where(d => d.ExamRoomName.Contains(vm.SearchText)); } //考场学生 vm.StudentList = (from p in db.Table <Exam.Entity.tbExamStudent>() where p.tbStudent.IsDeleted == false && p.tbExamRoom.IsDeleted == false select new Dto.ExamRoom.List { Id = p.tbExamRoom.Id, StudentCode = p.tbStudent.StudentCode, StudentName = p.tbStudent.StudentName }).Distinct().ToList(); //监考教师 vm.ExamTeacherList = (from p in db.Table <Exam.Entity.tbExamTeacher>() where p.tbExamRoom.IsDeleted == false && p.tbTeacher.IsDeleted == false select new Dto.ExamRoom.List { Id = p.tbExamRoom.Id, TeacherCode = p.tbTeacher.TeacherCode, TeacherName = p.tbTeacher.TeacherName }).Distinct().ToList(); vm.ExamRoomList = (from p in tb orderby p.No descending select new Dto.ExamRoom.List { Id = p.Id, ExamCourseName = p.tbExamCourse.tbCourse.CourseName, ExamRoomName = p.ExamRoomName, RoomName = p.tbRoom.RoomName, RowSeat = p.RowSeat }).ToList(); return(View(vm)); } }
public ActionResult ExamRoomStudentList(Models.ExamRoom.List vm) { return(Code.MvcHelper.Post(null, Url.Action("ExamRoomStudentList", new { searchText = vm.SearchText, ExamId = vm.ExamId }))); }
public ActionResult List(Models.ExamRoom.List vm) { return(Code.MvcHelper.Post(null, Url.Action("List", new { searchText = vm.SearchText, ExamCourseId = vm.ExamCourseId, ScheduleId = vm.ScheduleId, ExamId = vm.ExamId }))); }