JW/EMiS.DataLogic/SelectCourse/SelectCourseResult/SelectCourseListDAL.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using EMIS.DataLogic.Repositories;
using EMIS.DataLogic.SystemDAL;
using System.Linq.Expressions;
using EMIS.ViewModel.SelectCourse.SelectCourseResult;
using EMIS.Entities;
using EMIS.DataLogic.Common.CalendarManage;

namespace EMIS.DataLogic.SelectCourse.SelectCourseResult
{
    public class SelectCourseListDAL
    {
        public FinallyScoreRepository FinallyScoreRepository { get; set; }
        public StudentRepository StudentRepository { get; set; }
        public ClassmajorRepository ClassmajorRepository { get; set; }
        public GrademajorRepository GrademajorRepository { get; set; }
        public FacultymajorRepository FacultymajorRepository { get; set; }
        public SpecialtyRepository SpecialtyRepository { get; set; }
        public DictionaryItemRepository DictionaryItemRepository { get; set; }
        public SchoolyearRepository schoolyearRepository { get; set; }
        public SelectCourseTypeSettingRepository SelectCourseTypeSettingRepository { get; set; }
        public SelectCourseOpenControlSettingRepository SelectCourseOpenControlSettingRepository { get; set; }
        public Lazy<ParameterDAL> ParamterDAL { get; set; }
        public Lazy<SchoolYearDAL> SchoolYearDAL { get; set; }
        public CampusRepository campusRepository { get; set; }
        public CollegeRepository collegeRepository { get; set; }
        public DepartmentRepository departmentRepository { get; set; }
        public CoursematerialRepository CoursematerialRepository { get; set; }
        public ExecutableOptionalCourseRepository ExecutableOptionalCourseRepository { get; set; }//限选设定
        public ExecutableFreeSelectionCouseRepository ExecutableFreeSelectionCouseRepository { get; set; }//任选设定
        public OptionalCoursePlanRepository OptionalCoursePlanRepository { get; set; }  //限修计划
        public FreeSelectionCourseGradeYearSettingRepository FreeSelectionCourseGradeYearSettingRepository { get; set; }    //任选控制表
        public ExecutableOptionalCourseTeacherRepository ExecutableOptionalCourseTeacherRepository { get; set; }    //限选设定任课老师表
        public ExecutableOptionalCourseTeachingModeRepository ExecutableOptionalCourseTeachingModeRepository { get; set; }  //限选设定授课方式表
        public ExecutableOptionalCourseTeachingSettingRepository ExecutableOptionalCourseTeachingSettingRepository { get; set; }    //限选设定教学设置表
        public ExecutableFreeSelectionCouseTeacherRepository ExecutableFreeSelectionCouseTeacherRepository { get; set; }    //任选课程教师表
        public ExecutableFreeSelectionCouseTeachingModeRepository ExecutableFreeSelectionCouseTeachingModeRepository { get; set; }  //任选设定授课方式表
        public ExecutableFreeSelectionCouseTeachingSettingRepository ExecutableFreeSelectionCouseTeachingSettingRepository { get; set; }    //任选设定教学设置表
        public ExecutableFreeSelectionCouseSpecialtyRepository ExecutableFreeSelectionCouseSpecialtyRepository { get; set; }
        public ExecutableFreeSelectionCouseGradeYearRepository ExecutableFreeSelectionCouseGradeYearRepository { get; set; }
        public ExecutableFreeSelectionCouseSchedulingRepository ExecutableFreeSelectionCouseSchedulingRepository { get; set; }
        public CoursesTimeRepository coursesTimeRepository { get; set; }
        public ClassroomRepository ClassroomRepository { get; set; }
        public UserRepository UserRepository { get; set; }

        /// <summary>
        /// 查询选课结果名单，0为限选，1为任选
        /// </summary>
        /// <param name="eocExp"></param>
        /// <param name="efsExp"></param>
        /// <returns></returns>
        public IQueryable<SelectCourseListView> GetSelectCourseListViewQueryable(Expression<Func<EM_ExecutableOptionalCourse, bool>>
            eocExp, Expression<Func<EM_ExecutableFreeSelectionCouse, bool>> efsExp)
        {
            //1.0 获取限选设定的所有学生数据
            var executableOptionalCourseResult = (from eoc in ExecutableOptionalCourseRepository.GetList(eocExp)
                                                  from stu in eoc.CF_Student
                                                  join user in UserRepository.Entities on stu.UserID equals user.UserID
                                                  join cla in ClassmajorRepository.Entities on stu.ClassmajorID equals cla.ClassmajorID
                                                  select new SelectCourseListView
                                                  {
                                                      UserID = user.UserID,
                                                      LoginID = user.LoginID,
                                                      UserName = user.Name,
                                                      ClassMajorID = cla.ClassmajorID,
                                                      ClassMajorName = cla.Name,
                                                      ClassroomName = "",
                                                      ID = eoc.ExecutableOptionalCourseID,
                                                      StudentTotalNum = eoc.CF_Student.Count(),
                                                      PeopleNumlower = eoc.PeopleNumlower,
                                                      PeopleNumlimit = eoc.PeopleNumlimit,
                                                      SchoolyearID = eoc.SchoolyearID,
                                                      SchoolYearCode = null,
                                                      CollegeID = eoc.CF_Grademajor.CF_Facultymajor.CollegeID,
                                                      DepartmentID = eoc.DepartmentID,
                                                      DepartmentName = eoc.EM_OptionalCoursePlan.CF_Department.Name,
                                                      DefaultClassName = eoc.DefaultClassName,
                                                      CoursematerialID = eoc.EM_OptionalCoursePlan.CoursematerialID,
                                                      CourseCode = eoc.EM_OptionalCoursePlan.EM_Coursematerial.CourseCode,
                                                      CourseName = eoc.EM_OptionalCoursePlan.EM_Coursematerial.CourseName,
                                                      CourseTypeID = eoc.CourseTypeID,
                                                      CourseQualityID = eoc.CourseQualityID,
                                                      SelectCourseType = 0,
                                                      TheoryCourse = eoc.EM_ExecutableOptionalCourseTeachingSetting.TheoryCourse ?? 0,
                                                      Practicehours = eoc.EM_ExecutableOptionalCourseTeachingSetting.Practicehours ?? 0,
                                                      Trialhours = eoc.EM_ExecutableOptionalCourseTeachingSetting.Trialhours ?? 0,
                                                      Credit = eoc.EM_ExecutableOptionalCourseTeachingSetting.Credit ?? 0,
                                                      StartWeeklyNum = eoc.EM_ExecutableOptionalCourseTeachingSetting.StartWeeklyNum ?? 0,
                                                      EndWeeklyNum = eoc.EM_ExecutableOptionalCourseTeachingSetting.EndWeeklyNum ?? 0,
                                                      SchoolcodeID = eoc.EM_OptionalCoursePlan.SchoolcodeID,
                                                      TeacherUserID = null,
                                                      TeacherName = "",
                                                      RecordStatus = eoc.RecordStatus,
                                                      IsOpened = eoc.IsOpened.Value,
                                                  });

            //2.0 获取任选设定的所有学生数据
            var executableFreeSelectionCouseResult = (from efs in ExecutableFreeSelectionCouseRepository.GetList(efsExp)
                                                      from stu in efs.CF_Student
                                                      join user in UserRepository.Entities on stu.UserID equals user.UserID
                                                      join cla in ClassmajorRepository.Entities on stu.ClassmajorID equals cla.ClassmajorID
                                                      join Scheduling in
                                                          (from sc in ExecutableFreeSelectionCouseSchedulingRepository.Entities
                                                           join d in ClassroomRepository.Entities on sc.ClassroomID equals d.ClassroomID
                                                           group d by new { sc.ExecutableFreeSelectionCouseID } into g
                                                           select new
                                                           {
                                                               ExecutableFreeSelectionCouseID = g.Key.ExecutableFreeSelectionCouseID,
                                                               ClassroomName = g.Select(x => x.Name).FirstOrDefault(),
                                                           }) on efs.ExecutableFreeSelectionCouseID equals Scheduling.ExecutableFreeSelectionCouseID
                                                      into lj
                                                      from Scheduling in lj.DefaultIfEmpty()
                                                      select new SelectCourseListView
                                                      {
                                                          UserID = user.UserID,
                                                          LoginID = user.LoginID,
                                                          UserName = user.Name,
                                                          ClassMajorID = cla.ClassmajorID,
                                                          ClassMajorName = cla.Name,
                                                          ClassroomName = Scheduling.ClassroomName,
                                                          ID = efs.ExecutableFreeSelectionCouseID,
                                                          StudentTotalNum = efs.CF_Student.Count(),
                                                          PeopleNumlower = efs.PeopleNumlower,
                                                          PeopleNumlimit = efs.PeopleNumlimit,
                                                          SchoolyearID = efs.SchoolyearID,
                                                          SchoolYearCode = null,
                                                          CollegeID = efs.CF_Department.CollegeID,
                                                          DepartmentID = efs.DepartmentID,
                                                          DepartmentName = efs.EM_FreeSelectionCouse.CF_Department.Name,
                                                          DefaultClassName = efs.DefaultClassName,
                                                          CoursematerialID = efs.EM_FreeSelectionCouse.CoursematerialID,
                                                          CourseCode = efs.EM_FreeSelectionCouse.EM_Coursematerial.CourseCode,
                                                          CourseName = efs.EM_FreeSelectionCouse.EM_Coursematerial.CourseName,
                                                          CourseTypeID = efs.CourseTypeID,
                                                          CourseQualityID = efs.CourseQualityID,
                                                          SelectCourseType = 1,
                                                          TheoryCourse = efs.EM_ExecutableFreeSelectionCouseTeachingSetting.TheoryCourse ?? 0,
                                                          Practicehours = efs.EM_ExecutableFreeSelectionCouseTeachingSetting.Practicehours ?? 0,
                                                          Trialhours = efs.EM_ExecutableFreeSelectionCouseTeachingSetting.Trialhours ?? 0,
                                                          Credit = efs.EM_ExecutableFreeSelectionCouseTeachingSetting.Credit ?? 0,
                                                          StartWeeklyNum = efs.EM_ExecutableFreeSelectionCouseTeachingSetting.StartWeeklyNum ?? 0,
                                                          EndWeeklyNum = efs.EM_ExecutableFreeSelectionCouseTeachingSetting.EndWeeklyNum ?? 0,
                                                          SchoolcodeID = efs.EM_FreeSelectionCouse.SchoolcodeID,
                                                          TeacherUserID = null,
                                                          TeacherName = "",
                                                          RecordStatus = efs.RecordStatus,
                                                          IsOpened = true,
                                                      });
            //3.0 合并限选/任选 
            var result = from a in executableOptionalCourseResult.Concat(executableFreeSelectionCouseResult)
                         join s in schoolyearRepository.Entities on a.SchoolyearID equals s.SchoolyearID
                         select new SelectCourseListView
                         {
                             UserID = a.UserID,
                             LoginID = a.LoginID,
                             UserName = a.UserName,
                             ClassMajorID = a.ClassMajorID,
                             ClassMajorName = a.ClassMajorName,
                             ClassroomName = a.ClassroomName,
                             ID = a.ID,
                             StudentTotalNum = a.StudentTotalNum,
                             PeopleNumlower = a.PeopleNumlower,
                             PeopleNumlimit = a.PeopleNumlimit,
                             SchoolyearID = a.SchoolyearID,
                             SchoolYearCode = s.Code,
                             CollegeID = a.CollegeID,
                             DepartmentID = a.DepartmentID,
                             DepartmentName = a.DepartmentName,
                             DefaultClassName = a.DefaultClassName,
                             CoursematerialID = a.CoursematerialID,
                             CourseCode = a.CourseCode,
                             CourseName = a.CourseName,
                             CourseTypeID = a.CourseTypeID,
                             CourseQualityID = a.CourseQualityID,
                             SelectCourseType = a.SelectCourseType,
                             TheoryCourse = a.TheoryCourse ?? 0,
                             Practicehours = a.Practicehours ?? 0,
                             Trialhours = a.Trialhours ?? 0,
                             Credit = a.Credit ?? 0,
                             StartWeeklyNum = a.StartWeeklyNum ?? 0,
                             EndWeeklyNum = a.EndWeeklyNum ?? 0,
                             SchoolcodeID = a.SchoolcodeID,
                             TeacherUserID = null,
                             TeacherName = a.TeacherName,
                             RecordStatus = a.RecordStatus,
                             IsOpened = a.IsOpened,
                         };

            return result;
        }
    }
}