/// <summary> /// 从数据库中获取所有课程 /// </summary> /// <returns>所有课程</returns> public Courses GetAllCourses() { // 要返回的结果 Courses AllCourses = new Courses(); // 从本地数据库获取数据 var Database = new DataContext(); List <DbCourse> TempDbCourses = Database.DbCourses .Include(DbCourse => DbCourse.DbLocTimes) .ToList <DbCourse>(); foreach (DbCourse TempDbCourse in TempDbCourses) { Course TempCourse = new Course(); TempCourse.Name = TempDbCourse.Name; TempCourse.Teacher = TempDbCourse.Teacher; TempCourse.Notes = TempDbCourse.Notes; AllCourses.Add(TempCourse); if (TempDbCourse.DbLocTimes == null) { continue; } foreach (DbLocTime TempDbLocTime in TempDbCourse.DbLocTimes) { LocTime TempLocTime = new LocTime( TempDbLocTime.Location, TempDbLocTime.Week, TempDbLocTime.WeekDay, TempDbLocTime.BeginTime, TempDbLocTime.EndTime, 0); AllCourses.AddLocTime(TempDbCourse.Name, TempLocTime); } } return(AllCourses); }