/// <summary> /// Loads the course examinations. /// </summary> /// <returns>The course examinations.</returns> /// <param name="courseId">Course identifier.</param> public List <ResCourseToExam> LoadCourseExaminations(int courseId) { var sqlwhere = "Res_CourseToExam.CourseId=" + courseId; var list = _dataAccess.GetList <ResCourseToExam>(sqlwhere); if (list.Count > 0) { var manager = new ExampaperManager(); var exampaperRedundancys = manager.GetAllExampaperRedundancy(list.Select(p => p.ExampaperId)); var sortmanager = new ExampaperSortManager(); var sortlist = sortmanager.GetAllExampaperSortList(exampaperRedundancys.First().TenantId); foreach (var exam in list) { var tmp = exampaperRedundancys.FirstOrDefault(p => p._id == exam.ExampaperId); if (tmp == null) { list.Remove(exam); continue; } exam.Exampaper = tmp; exam.ExampaperId = tmp.ExampaperId; exam.ExampaperRedundancyId = tmp._id; exam.SortName = sortlist.Any(p => p._id == tmp.ExamSortID) ? sortlist.Find(p => p._id == tmp.ExamSortID).Title : ""; } } return(list); }
//试题 public ActionResult ExampaperManager() { int total = 0; var exampaperList = new ExampaperManager().GetAllExampaperList(ref total, 0, CurrentTenant.TenantId, "", null, null, null, null, 99, 99, null, 5, 1); var sortList = new ExampaperSortManager().GetAllExampaperSortDictionary(CurrentTenant.TenantId); var dataList = new List <MExampaperShow>(); foreach (var item in exampaperList) { var exampaper = new MExampaperShow(); exampaper.id = item._id; exampaper.ExampaperTitle = item.ExampaperTitle; exampaper.LastUpdateTime = item.LastUpdateTime.ToLocalTime().ToString("yyyy-MM-dd"); exampaper.ExamSortTitle = sortList[item.ExamSortID].LevelPath; dataList.Add(exampaper); } ViewBag.total = total; return(View(dataList)); }