Exemple #1
0
        public ActionResult List()
        {
            using (var db = new XkSystem.Models.DbContext())
            {
                var vm = new Models.ExamStudent.List();

                var tb = from p in db.Table <Exam.Entity.tbExamStudent>()
                         where  p.tbExamRoom.Id == vm.ExamRoomId &&
                         p.tbStudent.IsDeleted == false
                         select p;

                if (string.IsNullOrEmpty(vm.SearchText) == false)
                {
                    tb = tb.Where(d => d.tbStudent.StudentCode.Contains(vm.SearchText) || d.tbStudent.StudentName.Contains(vm.SearchText));
                }

                vm.ExamStudentList = (from p in tb
                                      orderby p.tbStudent.StudentCode
                                      select new Dto.ExamStudent.List
                {
                    Id = p.Id,
                    StudentCode = p.tbStudent.StudentCode,
                    StudentName = p.tbStudent.StudentName,
                }).ToList();
                return(View(vm));
            }
        }
Exemple #2
0
 public ActionResult List(Models.ExamStudent.List vm)
 {
     return(Code.MvcHelper.Post(null, Url.Action("List", new { searchText = vm.SearchText, ExamRoomId = vm.ExamRoomId, examCourseId = vm.ExamCourseId, scheduleId = vm.ScheduleId })));
 }