public ActionResult List(Models.ElectiveApply.List vm) { return(Code.MvcHelper.Post(returnUrl: Url.Action("List", new { SearchText = vm.SearchText, PageIndex = vm.Page.PageIndex, PageSize = vm.Page.PageSize, ElectiveId = vm.ElectiveId }))); }
public ActionResult Approve() { var vm = new Models.ElectiveApply.List(); using (var db = new XkSystem.Models.DbContext()) { var tb = (from p in db.Table <Entity.tbElectiveApply>() select p); if (!string.IsNullOrWhiteSpace(vm.SearchText)) { tb = tb.Where(p => p.tbCourse.CourseName.Contains(vm.SearchText) || p.tbElective.ElectiveName.Contains(vm.SearchText)); } if (vm.ElectiveId > 0) { tb = tb.Where(p => p.tbElective.Id == vm.ElectiveId); } vm.ElectiveApplyList = (from p in tb orderby p.No select new Dto.ElectiveApply.List() { Id = p.Id, ElectiveName = p.tbElective.ElectiveName, CourseName = p.tbCourse.CourseName, InputTime = p.InputTime, Hour = p.Hour, Point = p.tbCourse.Point, CheckStatus = p.CheckStatus, CheckOpinion = p.CheckOpinion, MaxStudent = p.MaxStudent, RoomName = p.tbRoom.RoomName, UserName = p.tbSysUser.UserName, IsMultiClass = p.IsMultiClass //ElectiveApplyFileList = db.Set<Entity.tbElectiveApplyFile>().Where(c => c.tbElectiveApply.Id == p.Id).Select(c => new Dto.ElectiveApplyFile.List() //{ // FileName = c.FileName, // FileTitle = c.FileTitle //}).ToList(), //ElectiveApplyScheduleList = db.Set<Entity.tbElectiveApplySchedule>().Where(c => c.tbElectiveApply.Id == p.Id).Select(c => new Dto.ElectiveApplySchedule.List() //{ // WeekId = c.tbWeek.Id, // WeekName = c.tbWeek.WeekName, // PeriodId = c.tbPeriod.Id, // PeriodName = c.tbPeriod.PeriodName //}).ToList(), }).ToPageList(vm.Page); vm.ElectiveList = ElectiveController.SelectList(); vm.ElectiveList.Insert(0, new SelectListItem() { Text = "全部", Value = "0" }); } return(View(vm)); }