public ActionResult GetTeacherByCourseList(int pIndex = 1) { int sysNo = TempData["SysNo"] != null ? (int)TempData["SysNo"] : 0; int teacherId = 0; if (sysNo > 0) { var date = userService.GetAccountData().FirstOrDefault(c => c.SysNO == sysNo); if (date != null) { teacherId = (int)date.Id; } } ViewBag.pageName = "TeacherByCourseList"; var input = new GetCourseInfoInput { SkipCount = (pIndex - 1) * PageSize, MaxResultCount = PageSize, TeacherId = teacherId }; var pagedata = courseInfoService.GetPagedCourseInfos(input); GetPageData(pagedata.TotalCount); return(PartialView("Shared/TeacherByCourseList", pagedata.Items)); }
/// <summary> /// 根据查询条件获取课程基本信息分页列表 /// </summary> public PagedResultDto <CourseInfoListDto> GetPagedCourseInfoForWap(GetCourseInfoInput input) { var query = from info in _courseInfoRepository.GetAll() .Where(t => t.Status != 1 && t.Status != 3).WhereIf(input.Type != 0, t => t.Type == input.Type).Where(t => t.DisplayPosition == 2 || t.DisplayPosition == 0) join cate in _categoryRepository.GetAll().WhereIf((input.Path != string.Empty && input.Path != null && input.Path != "0"), t => t.Path.StartsWith(input.Path)) on info.CategoryType equals cate.CategoryId into gc from gci in gc select new CourseInfoListDto() { Id = info.Id, CourseName = info.CourseName, Description = info.Description, Sort = info.Sort, Enabled = info.Enabled, Content = info.Content, Type = info.Type, StageName = info.StageName, Status = info.Status, ImageUrl = info.ImageUrl, TeacherId = info.TeacherId, TeacherName = info.TeacherName, LiveStatus = info.LiveStatus, StartTime = info.StartTime, EndTime = info.EndTime, CourseCategoryName = gci.CourseCategoryName, DisplayPosition = info.DisplayPosition, ReadTimes = info.ReadTimes, CollectionTimes = info.CollectionTimes, Enrollment = info.Enrollment, CreationTime = info.CreationTime, PollId = info.PollId, TypeName = info.TypeName }; //TODO:根据传入的参数添加过滤条件 var courseInfoCount = query.Count(); if (input.Sorting == null || input.Sorting == string.Empty) { query = query.OrderByDescending(t => t.CreationTime).OrderByDescending(t => t.Id); } if (input.Sorting == "ReadTimes") { query = query.OrderByDescending(t => t.ReadTimes); } if (input.Sorting == "CreationTime") { query = query.OrderByDescending(t => t.CreationTime); } var courseInfos = query .PageBy(input) .ToList(); var courseInfoListDtos = courseInfos.MapTo <List <CourseInfoListDto> >(); return(new PagedResultDto <CourseInfoListDto>( courseInfoCount, courseInfoListDtos )); }
//课程审核分页信息 public ActionResult GetCheckCourseDataList(string txtcname = "", string txttname = "", int txttype = 0, int txtcate = 0, int pIndex = 1) { ViewBag.pageName = "GetCheckCourseDataList"; var input = new GetCourseInfoInput() { FilterText = txtcname, TeacherName = txttname, Type = txttype, //CheckStatus = (int)CourseStatus.Pending, categoryType = txtcate, SkipCount = (pIndex - 1) * PageSize, MaxResultCount = PageSize }; var pagedata = _coreInfoService.GetPagedCourseInfos(input); GetPageData(pagedata.TotalCount); return(PartialView("Shared/CheckCourseDataList", pagedata)); }
// 课程管理分页信息 public ActionResult GetCurriManageDataList(string txtcname = "", string txttname = "", int txttype = 0, int txtcate = 0, int DepartmentId = 0, int jobPostId = 0, int pIndex = 1) { ViewBag.pageName = "GetCurriManageDataList"; var input = new GetCourseInfoInput() { FilterText = txtcname, TeacherName = txttname, Type = txttype, categoryType = txtcate, DepartmentId = DepartmentId, JobPostId = jobPostId, SkipCount = (pIndex - 1) * PageSize, MaxResultCount = PageSize }; var pagedata = _coreInfoService.GetPagedCourseInfos(input); GetPageData(pagedata.TotalCount); return(PartialView("Shared/CurriManageDataList", pagedata)); }
public JsonResult GetCourseList(GetCourseInfoInput inpt) { var course = _courseInfoAppService.GetPagedCourseInfoForWap(inpt); return(Json(course, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 根据查询条件获取课程基本信息分页列表 /// </summary> public PagedResultDto <CourseInfoListDto> GetPagedCourseInfos(GetCourseInfoInput input) { var query = from info in _courseInfoRepository.GetAll() join cate in _categoryRepository.GetAll() on info.CategoryType equals cate.CategoryId into gc join teach in _teacherRepository.GetAll() on info.TeacherId equals teach.Id into tc select new CourseInfoListDto() { Id = info.Id, CourseName = info.CourseName, Description = info.Description, Sort = info.Sort, Enabled = info.Enabled, Content = info.Content, Type = info.Type, StageName = info.StageName, Status = info.Status, ImageUrl = info.ImageUrl, TeacherId = info.TeacherId, TeacherName = info.TeacherName, LiveStatus = info.LiveStatus, StartTime = info.StartTime, EndTime = info.EndTime, CourseCategoryName = gc.FirstOrDefault().CourseCategoryName, DisplayPosition = info.DisplayPosition, ReadTimes = info.ReadTimes, CollectionTimes = info.CollectionTimes, CategoryType = gc.FirstOrDefault().CategoryId, DepartmentId = tc.FirstOrDefault().DepartmentId, JobPostId = tc.FirstOrDefault().JobpostId, CreationTime = info.CreationTime, Enrollment = info.Enrollment }; //into urJoined from ur in urJoined.DefaultIfEmpty() //group info by info into userGrouped select userGrouped.Key; //TODO:根据传入的参数添加过滤条件 if (!string.IsNullOrEmpty(input.FilterText)) { query = query.Where(c => c.CourseName.Contains(input.FilterText)); } if (!string.IsNullOrEmpty(input.TeacherName)) { query = query.Where(c => c.TeacherName.Contains(input.TeacherName)); } if (input.Type > 0) { query = query.Where(c => c.Type == input.Type); } if (input.categoryType > 0) { query = query.Where(c => c.CategoryType == input.categoryType); } if (input.CheckStatus > 0) { query = query.Where(c => c.Status == input.CheckStatus); } if (input.TeacherId > 0) { query = query.Where(c => c.TeacherId == input.TeacherId); } if (input.DepartmentId > 0) { query = query.Where(c => c.DepartmentId == input.DepartmentId); } if (input.JobPostId > 0) { query = query.Where(c => c.JobPostId == input.JobPostId); } var courseInfoCount = query.Count(); var courseInfos = query .OrderByDescending(t => t.CreationTime) .PageBy(input) .ToList(); var courseInfoListDtos = courseInfos.MapTo <List <CourseInfoListDto> >(); return(new PagedResultDto <CourseInfoListDto>( courseInfoCount, courseInfoListDtos )); }