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