JW/EMiS.DataLogic/StudentManage/OnlineChecking/CheckingCollectDAL.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Linq.Expressions;
using EMIS.Entities;
using EMIS.DataLogic.Repositories;
using EMIS.ViewModel.StudentManage.OnlineChecking;
using EMIS.ViewModel.StudentManage.StudentProfile;

namespace EMIS.DataLogic.StudentManage.OnlineChecking
{
    public class CheckingCollectDAL
    {
        public StudentRecordChangeHistoryRepository StudentRecordChangeHistoryRepository { get; set; }
        public StudentEditColumnDescriptionRepository StudentEditColumnDescriptionRepository { get; set; }
        public StudentContrastRepository StudentContrastRepository { get; set; }
        public StudentSourceRepository StudentSourceRepository { get; set; }
        public StudentRepository StudentRepository { get; set; }
        public StudentProfileRepository StudentProfileRepository { get; set; }
        public StudentProfileContrastRepository StudentProfileContrastRepository { get; set; }
        public StudentProfileSourceRepository StudentProfileSourceRepository { get; set; }
        public StudentContactRepository StudentContactRepository { get; set; }
        public StudentContactContrastRepository StudentContactContrastRepository { get; set; }
        public StudentContactSourceRepository StudentContactSourceRepository { get; set; }
        public StudentAccountRepository StudentAccountRepository { get; set; }
        public StudentAccountContrastRepository StudentAccountContrastRepository { get; set; }
        public StudentAccountSourceRepository StudentAccountSourceRepository { get; set; }
        public RecruitstudentsRepository RecruitstudentsRepository { get; set; }
        public RecruitstudentsContrastRepository RecruitstudentsContrastRepository { get; set; }
        public RecruitstudentsSourceRepository RecruitstudentsSourceRepository { get; set; }
        public ClassmajorRepository ClassmajorRepository { get; set; }
        public GrademajorRepository GrademajorRepository { get; set; }
        public FacultymajorRepository FacultymajorRepository { get; set; }
        public CollegeRepository CollegeRepository { get; set; }
        public CampusRepository CampusRepository { get; set; }
        public UserRepository UserRepository { get; set; }
        public UserContrastRepository UserContrastRepository { get; set; }
        public UserSourceRepository UserSourceRepository { get; set; }

        /// <summary>
        /// 查询对应的校对记录信息CheckingHistoryView
        /// </summary>
        /// <param name="expStudentRecordChangeHistory"></param>
        /// <returns></returns>
        public IQueryable<CheckingHistoryView> GetCheckingHistoryViewQueryable(Expression<Func<CF_StudentRecordChangeHistory, bool>> expStudentRecordChangeHistory)
        {
            var query = from stuhis in StudentRecordChangeHistoryRepository.GetList(expStudentRecordChangeHistory)
                        join stucst in StudentContrastRepository.Entities
                        on stuhis.StudentContrastID equals stucst.StudentContrastID
                        join stu in StudentRepository.Entities
                        on stucst.UserID equals stu.UserID
                        join stusou in StudentSourceRepository.Entities
                        on stucst.StudentContrastID equals stusou.StudentContrastID
                        join uscst in UserContrastRepository.Entities
                        on stucst.StudentContrastID equals uscst.StudentContrastID
                        join ussou in UserSourceRepository.Entities
                        on stucst.StudentContrastID equals ussou.StudentContrastID
                        join stupfcst in StudentProfileContrastRepository.Entities
                        on stucst.StudentContrastID equals stupfcst.StudentContrastID
                        join stupfsou in StudentProfileSourceRepository.Entities
                        on stucst.StudentContrastID equals stupfsou.StudentContrastID
                        join stuctcst in StudentContactContrastRepository.Entities
                        on stucst.StudentContrastID equals stuctcst.StudentContrastID
                        join stuctsou in StudentContactSourceRepository.Entities
                        on stucst.StudentContrastID equals stuctsou.StudentContrastID
                        join stuaccst in StudentAccountContrastRepository.Entities
                        on stucst.StudentContrastID equals stuaccst.StudentContrastID
                        join stuacsou in StudentAccountSourceRepository.Entities
                        on stucst.StudentContrastID equals stuacsou.StudentContrastID
                        join sturtcst in RecruitstudentsContrastRepository.Entities
                        on stucst.StudentContrastID equals sturtcst.StudentContrastID
                        join sturtsou in RecruitstudentsSourceRepository.Entities
                        on stucst.StudentContrastID equals sturtsou.StudentContrastID
                        join pf in StudentProfileRepository.Entities
                        on stu.UserID equals pf.UserID into temppf
                        from stupf in temppf.DefaultIfEmpty()
                        join ct in StudentContactRepository.Entities
                        on stu.UserID equals ct.UserID into tempct
                        from stuct in tempct.DefaultIfEmpty()
                        join ac in StudentAccountRepository.Entities
                        on stu.UserID equals ac.UserID into tempac
                        from stuac in tempac.DefaultIfEmpty()
                        join rt in RecruitstudentsRepository.Entities
                        on stu.UserID equals rt.UserID into temprt
                        from sturt in temprt.DefaultIfEmpty()
                        join cl in ClassmajorRepository.Entities
                        on stu.ClassmajorID equals cl.ClassmajorID
                        join gr in GrademajorRepository.Entities
                        on cl.GrademajorID equals gr.GrademajorID
                        join fa in FacultymajorRepository.Entities
                        on gr.FacultymajorID equals fa.FacultymajorID
                        join col in CollegeRepository.Entities
                        on fa.CollegeID equals col.CollegeID
                        join cam in CampusRepository.Entities
                        on col.CampusID equals cam.CampusID
                        join us in UserRepository.Entities
                        on stu.UserID equals us.UserID
                        join ecd in StudentEditColumnDescriptionRepository.Entities
                        on new { stuhis.TableName, stuhis.ColumnName } equals new { ecd.TableName, ecd.ColumnName } into tempecd
                        from stuecd in tempecd.DefaultIfEmpty()
                        select new CheckingHistoryView
                        {
                            StudentRecordChangeHistoryID = stuhis.StudentRecordChangeHistoryID,
                            StudentContrastID = stucst.StudentContrastID,
                            TableName = stuhis.TableName,
                            ColumnName = stuhis.ColumnName,
                            DisplayPropertyName = stuecd.DisplayPropertyName,
                            Description = stuecd.Description,
                            CheckingTypeID = stuhis.CheckingTypeID,
                            UserID = stu.UserID,
                            StudentNo = us.LoginID,
                            LoginID = us.LoginID,
                            ExamineeNum = sturt.ExamineeNum,
                            AdmissionTicketNo = sturt.AdmissionTicketNo,
                            Name = us.Name,
                            UserName = us.Name,
                            UsedName = stupf.UsedName,
                            ClassmajorID = stu.ClassmajorID,
                            ClassmajorNo = cl.No,
                            ClassmajorName = cl.Name,
                            ClassNum = cl.ClassNum,
                            StandardID = fa.StandardID,
                            EducationID = fa.EducationID,
                            LearningformID = fa.LearningformID,
                            LearnSystem = fa.LearnSystem,
                            FacultymajorID = gr.FacultymajorID,
                            FacultymajorCode = fa.Code,
                            FacultymajorName = fa.Name,
                            GradeID = gr.GradeID,
                            SemesterID = gr.SemesterID,
                            GrademajorID = cl.GrademajorID,
                            GrademajorCode = gr.Code,
                            GrademajorName = gr.Name,
                            CollegeID = fa.CollegeID,
                            CollegeNo = col.No,
                            CollegeName = col.Name,
                            CampusID = col.CampusID,
                            CampusCode = cam.No,
                            CampusName = cam.Name,
                            Country = stupf.Country,
                            Place = stupf.Place,
                            BornPlace = stupf.BornPlace,
                            SexID = stu.SexID,
                            BirthDate = stu.BirthDate,
                            NationID = stu.NationID,
                            PoliticsID = stu.PoliticsID,
                            CertificatesType = stu.CertificatesType,
                            IDNumber = stu.IDNumber,
                            StudentType = stu.StudentType,
                            InSchoolStatusID = stu.InSchoolStatusID,
                            StudentStatus = stu.StudentStatus,
                            ExamineeType = sturt.ExamineeType,
                            EntranceDate = sturt.EntranceDate,
                            LiteracyLevelID = stupf.LiteracyLevelID,
                            CultureModelID = stupf.CultureModelID,
                            IsDreamProject = stupf.IsDreamProject ?? false,
                            Email = stuct.Email,
                            Telephone = stuct.Telephone,
                            Mobile = stuct.Mobile,
                            ZIPCode = stuct.ZIPCode,
                            WeChatNum = stuct.WeChatNum,
                            QQ = stuct.QQ,
                            HealthStateID = stupf.HealthStateID,
                            BloodGroup = stupf.BloodGroup,
                            Specialty = stupf.Specialty,
                            Height = stupf.Height,
                            Weight = stupf.Weight,
                            DirectorName = stupf.DirectorName,
                            Score = sturt.Score,
                            EntranceWayID = sturt.EntranceWayID,
                            FeaturesID = sturt.FeaturesID,
                            TerritorialID = sturt.TerritorialID,
                            Area = sturt.Area,
                            HomeAddress = stuct.HomeAddress,
                            WorkUnit = stuct.WorkUnit,
                            Address = stuct.Address,
                            Recipient = stuct.Recipient,
                            Dormitory = stuct.Dormitory,
                            BankName = stuac.BankName,
                            CardNo = stuac.CardNo,
                            StudentCardNo = stu.StudentCardNo,
                            PhotoUrl = stu.PhotoUrl,
                            PlanningGraduateDate = stu.PlanningGraduateDate,
                            GraduateDate = stu.GraduateDate,
                            GraduateCardNo = stu.GraduateCardNo,
                            ReplaceGraduateNo = stu.ReplaceGraduateNo,
                            DegreeStatus = stu.DegreeStatus ?? false,
                            GraduationPictureUrl = stu.GraduationPictureUrl,
                            Career = stu.Career,
                            IsProofread = stu.IsProofread ?? false,
                            Remark = stu.Remark,
                            IP = stucst.IP,
                            ApprovalStatus = stucst.ApprovalStatus,
                            Comment = stucst.Comment,
                            ApprovalTime = stucst.ModifyTime,
                            StudentViewSource = new StudentView()
                            {
                                UserID = stucst.UserID,
                                StudentNo = ussou.LoginID,
                                LoginID = ussou.LoginID,
                                ExamineeNum = sturtsou.ExamineeNum,
                                AdmissionTicketNo = sturtsou.AdmissionTicketNo,
                                Name = ussou.Name,
                                UserName = ussou.Name,
                                UsedName = stupfsou.UsedName,
                                ClassmajorID = stu.ClassmajorID,
                                ClassmajorNo = cl.No,
                                ClassmajorName = cl.Name,
                                ClassNum = cl.ClassNum,
                                StandardID = fa.StandardID,
                                EducationID = fa.EducationID,
                                LearningformID = fa.LearningformID,
                                LearnSystem = fa.LearnSystem,
                                FacultymajorID = gr.FacultymajorID,
                                FacultymajorCode = fa.Code,
                                FacultymajorName = fa.Name,
                                GradeID = gr.GradeID,
                                SemesterID = gr.SemesterID,
                                GrademajorID = cl.GrademajorID,
                                GrademajorCode = gr.Code,
                                GrademajorName = gr.Name,
                                CollegeID = fa.CollegeID,
                                CollegeNo = col.No,
                                CollegeName = col.Name,
                                CampusID = col.CampusID,
                                CampusCode = cam.No,
                                CampusName = cam.Name,
                                Country = stupfsou.Country,
                                Place = stupfsou.Place,
                                BornPlace = stupfsou.BornPlace,
                                SexID = stusou.SexID,
                                BirthDate = stusou.BirthDate,
                                NationID = stusou.NationID,
                                PoliticsID = stusou.PoliticsID,
                                CertificatesType = stusou.CertificatesType,
                                IDNumber = stusou.IDNumber,
                                StudentType = stusou.StudentType,
                                InSchoolStatusID = stusou.InSchoolStatusID,
                                StudentStatus = stusou.StudentStatus,
                                ExamineeType = sturtsou.ExamineeType,
                                EntranceDate = sturtsou.EntranceDate,
                                LiteracyLevelID = stupfsou.LiteracyLevelID,
                                CultureModelID = stupfsou.CultureModelID,
                                IsDreamProject = stupfsou.IsDreamProject ?? false,
                                Email = stuctsou.Email,
                                Telephone = stuctsou.Telephone,
                                Mobile = stuctsou.Mobile,
                                ZIPCode = stuctsou.ZIPCode,
                                WeChatNum = stuctsou.WeChatNum,
                                QQ = stuctsou.QQ,
                                HealthStateID = stupfsou.HealthStateID,
                                BloodGroup = stupfsou.BloodGroup,
                                Specialty = stupfsou.Specialty,
                                Height = stupfsou.Height,
                                Weight = stupfsou.Weight,
                                DirectorName = stupfsou.DirectorName,
                                Score = sturtsou.Score,
                                EntranceWayID = sturtsou.EntranceWayID,
                                FeaturesID = sturtsou.FeaturesID,
                                TerritorialID = sturtsou.TerritorialID,
                                Area = sturtsou.Area,
                                HomeAddress = stuctsou.HomeAddress,
                                WorkUnit = stuctsou.WorkUnit,
                                Address = stuctsou.Address,
                                Recipient = stuctsou.Recipient,
                                Dormitory = stuctsou.Dormitory,
                                BankName = stuacsou.BankName,
                                CardNo = stuacsou.CardNo,
                                RecruitPictureUrl = sturtsou.RecruitPictureUrl,
                                StudentCardNo = stusou.StudentCardNo,
                                PhotoUrl = stusou.PhotoUrl,
                                PlanningGraduateDate = stusou.PlanningGraduateDate,
                                GraduateDate = stusou.GraduateDate,
                                GraduateCardNo = stusou.GraduateCardNo,
                                ReplaceGraduateNo = stusou.ReplaceGraduateNo,
                                DegreeStatus = stusou.DegreeStatus ?? false,
                                GraduationPictureUrl = stusou.GraduationPictureUrl,
                                Career = stusou.Career,
                                IsPhotoComparison = stusou.IsPhotoComparison ?? false,
                                IsProofread = stusou.IsProofread ?? false,
                                Remark = stusou.Remark
                            },
                            StudentViewContrast = new StudentView()
                            {
                                UserID = stucst.UserID,
                                StudentNo = uscst.LoginID,
                                LoginID = uscst.LoginID,
                                ExamineeNum = sturtcst.ExamineeNum,
                                AdmissionTicketNo = sturtcst.AdmissionTicketNo,
                                Name = uscst.Name,
                                UserName = uscst.Name,
                                UsedName = stupfcst.UsedName,
                                ClassmajorID = stu.ClassmajorID,
                                ClassmajorNo = cl.No,
                                ClassmajorName = cl.Name,
                                ClassNum = cl.ClassNum,
                                StandardID = fa.StandardID,
                                EducationID = fa.EducationID,
                                LearningformID = fa.LearningformID,
                                LearnSystem = fa.LearnSystem,
                                FacultymajorID = gr.FacultymajorID,
                                FacultymajorCode = fa.Code,
                                FacultymajorName = fa.Name,
                                GradeID = gr.GradeID,
                                SemesterID = gr.SemesterID,
                                GrademajorID = cl.GrademajorID,
                                GrademajorCode = gr.Code,
                                GrademajorName = gr.Name,
                                CollegeID = fa.CollegeID,
                                CollegeNo = col.No,
                                CollegeName = col.Name,
                                CampusID = col.CampusID,
                                CampusCode = cam.No,
                                CampusName = cam.Name,
                                Country = stupfcst.Country,
                                Place = stupfcst.Place,
                                BornPlace = stupfcst.BornPlace,
                                SexID = stucst.SexID,
                                BirthDate = stucst.BirthDate,
                                NationID = stucst.NationID,
                                PoliticsID = stucst.PoliticsID,
                                CertificatesType = stucst.CertificatesType,
                                IDNumber = stucst.IDNumber,
                                StudentType = stucst.StudentType,
                                InSchoolStatusID = stucst.InSchoolStatusID,
                                StudentStatus = stucst.StudentStatus,
                                ExamineeType = sturtcst.ExamineeType,
                                EntranceDate = sturtcst.EntranceDate,
                                LiteracyLevelID = stupfcst.LiteracyLevelID,
                                CultureModelID = stupfcst.CultureModelID,
                                IsDreamProject = stupfcst.IsDreamProject ?? false,
                                Email = stuctcst.Email,
                                Telephone = stuctcst.Telephone,
                                Mobile = stuctcst.Mobile,
                                ZIPCode = stuctcst.ZIPCode,
                                WeChatNum = stuctcst.WeChatNum,
                                QQ = stuctcst.QQ,
                                HealthStateID = stupfcst.HealthStateID,
                                BloodGroup = stupfcst.BloodGroup,
                                Specialty = stupfcst.Specialty,
                                Height = stupfcst.Height,
                                Weight = stupfcst.Weight,
                                DirectorName = stupfcst.DirectorName,
                                Score = sturtcst.Score,
                                EntranceWayID = sturtcst.EntranceWayID,
                                FeaturesID = sturtcst.FeaturesID,
                                TerritorialID = sturtcst.TerritorialID,
                                Area = sturtcst.Area,
                                HomeAddress = stuctcst.HomeAddress,
                                WorkUnit = stuctcst.WorkUnit,
                                Address = stuctcst.Address,
                                Recipient = stuctcst.Recipient,
                                Dormitory = stuctcst.Dormitory,
                                BankName = stuaccst.BankName,
                                CardNo = stuaccst.CardNo,
                                RecruitPictureUrl = sturtcst.RecruitPictureUrl,
                                StudentCardNo = stucst.StudentCardNo,
                                PhotoUrl = stucst.PhotoUrl,
                                PlanningGraduateDate = stucst.PlanningGraduateDate,
                                GraduateDate = stucst.GraduateDate,
                                GraduateCardNo = stucst.GraduateCardNo,
                                ReplaceGraduateNo = stucst.ReplaceGraduateNo,
                                DegreeStatus = stucst.DegreeStatus ?? false,
                                GraduationPictureUrl = stucst.GraduationPictureUrl,
                                Career = stucst.Career,
                                IsPhotoComparison = stucst.IsPhotoComparison ?? false,
                                IsProofread = stucst.IsProofread ?? false,
                                Remark = stucst.Remark
                            },
                            RecordStatus = stuhis.RecordStatus,
                            CreateUserID = stuhis.CreateUserID,
                            CreateTime = stuhis.CreateTime,
                            ModifyUserID = stuhis.ModifyUserID,
                            ModifyTime = stuhis.ModifyTime
                        };

            return query;
        }

        /// <summary>
        /// 查询对应的校对记录信息CheckingHistoryView
        /// </summary>
        /// <param name="expStudentRecordChangeHistory"></param>
        /// <param name="expStudentContrast"></param>
        /// <param name="expStudent"></param>
        /// <returns></returns>
        public IQueryable<CheckingHistoryView> GetCheckingHistoryViewQueryable(Expression<Func<CF_StudentRecordChangeHistory, bool>> expStudentRecordChangeHistory, 
                Expression<Func<CF_StudentContrast, bool>> expStudentContrast, Expression<Func<CF_Student, bool>> expStudent)
        {
            var query = from stuhis in StudentRecordChangeHistoryRepository.GetList(expStudentRecordChangeHistory)
                        join stucst in StudentContrastRepository.GetList(expStudentContrast)
                        on stuhis.StudentContrastID equals stucst.StudentContrastID
                        join stu in StudentRepository.GetList(expStudent)
                        on stucst.UserID equals stu.UserID
                        join stusou in StudentSourceRepository.Entities
                        on stucst.StudentContrastID equals stusou.StudentContrastID
                        join uscst in UserContrastRepository.Entities
                        on stucst.StudentContrastID equals uscst.StudentContrastID
                        join ussou in UserSourceRepository.Entities
                        on stucst.StudentContrastID equals ussou.StudentContrastID
                        join stupfcst in StudentProfileContrastRepository.Entities
                        on stucst.StudentContrastID equals stupfcst.StudentContrastID
                        join stupfsou in StudentProfileSourceRepository.Entities
                        on stucst.StudentContrastID equals stupfsou.StudentContrastID
                        join stuctcst in StudentContactContrastRepository.Entities
                        on stucst.StudentContrastID equals stuctcst.StudentContrastID
                        join stuctsou in StudentContactSourceRepository.Entities
                        on stucst.StudentContrastID equals stuctsou.StudentContrastID
                        join stuaccst in StudentAccountContrastRepository.Entities
                        on stucst.StudentContrastID equals stuaccst.StudentContrastID
                        join stuacsou in StudentAccountSourceRepository.Entities
                        on stucst.StudentContrastID equals stuacsou.StudentContrastID
                        join sturtcst in RecruitstudentsContrastRepository.Entities
                        on stucst.StudentContrastID equals sturtcst.StudentContrastID
                        join sturtsou in RecruitstudentsSourceRepository.Entities
                        on stucst.StudentContrastID equals sturtsou.StudentContrastID
                        join pf in StudentProfileRepository.Entities
                        on stu.UserID equals pf.UserID into temppf
                        from stupf in temppf.DefaultIfEmpty()
                        join ct in StudentContactRepository.Entities
                        on stu.UserID equals ct.UserID into tempct
                        from stuct in tempct.DefaultIfEmpty()
                        join ac in StudentAccountRepository.Entities
                        on stu.UserID equals ac.UserID into tempac
                        from stuac in tempac.DefaultIfEmpty()
                        join rt in RecruitstudentsRepository.Entities
                        on stu.UserID equals rt.UserID into temprt
                        from sturt in temprt.DefaultIfEmpty()
                        join cl in ClassmajorRepository.Entities
                        on stu.ClassmajorID equals cl.ClassmajorID
                        join gr in GrademajorRepository.Entities
                        on cl.GrademajorID equals gr.GrademajorID
                        join fa in FacultymajorRepository.Entities
                        on gr.FacultymajorID equals fa.FacultymajorID
                        join col in CollegeRepository.Entities
                        on fa.CollegeID equals col.CollegeID
                        join cam in CampusRepository.Entities
                        on col.CampusID equals cam.CampusID
                        join us in UserRepository.Entities
                        on stu.UserID equals us.UserID
                        join ecd in StudentEditColumnDescriptionRepository.Entities
                        on new { stuhis.TableName, stuhis.ColumnName } equals new { ecd.TableName, ecd.ColumnName } into tempecd
                        from stuecd in tempecd.DefaultIfEmpty()
                        select new CheckingHistoryView
                        {
                            StudentRecordChangeHistoryID = stuhis.StudentRecordChangeHistoryID,
                            StudentContrastID = stucst.StudentContrastID,
                            TableName = stuhis.TableName,
                            ColumnName = stuhis.ColumnName,
                            DisplayPropertyName = stuecd.DisplayPropertyName,
                            Description = stuecd.Description,
                            CheckingTypeID = stuhis.CheckingTypeID,
                            UserID = stu.UserID,
                            StudentNo = us.LoginID,
                            LoginID = us.LoginID,
                            ExamineeNum = sturt.ExamineeNum,
                            AdmissionTicketNo = sturt.AdmissionTicketNo,
                            Name = us.Name,
                            UserName = us.Name,
                            UsedName = stupf.UsedName,
                            ClassmajorID = stu.ClassmajorID,
                            ClassmajorNo = cl.No,
                            ClassmajorName = cl.Name,
                            ClassNum = cl.ClassNum,
                            StandardID = fa.StandardID,
                            EducationID = fa.EducationID,
                            LearningformID = fa.LearningformID,
                            LearnSystem = fa.LearnSystem,
                            FacultymajorID = gr.FacultymajorID,
                            FacultymajorCode = fa.Code,
                            FacultymajorName = fa.Name,
                            GradeID = gr.GradeID,
                            SemesterID = gr.SemesterID,
                            GrademajorID = cl.GrademajorID,
                            GrademajorCode = gr.Code,
                            GrademajorName = gr.Name,
                            CollegeID = fa.CollegeID,
                            CollegeNo = col.No,
                            CollegeName = col.Name,
                            CampusID = col.CampusID,
                            CampusCode = cam.No,
                            CampusName = cam.Name,
                            Country = stupf.Country,
                            Place = stupf.Place,
                            BornPlace = stupf.BornPlace,
                            SexID = stu.SexID,
                            BirthDate = stu.BirthDate,
                            NationID = stu.NationID,
                            PoliticsID = stu.PoliticsID,
                            CertificatesType = stu.CertificatesType,
                            IDNumber = stu.IDNumber,
                            StudentType = stu.StudentType,
                            InSchoolStatusID = stu.InSchoolStatusID,
                            StudentStatus = stu.StudentStatus,
                            ExamineeType = sturt.ExamineeType,
                            EntranceDate = sturt.EntranceDate,
                            LiteracyLevelID = stupf.LiteracyLevelID,
                            CultureModelID = stupf.CultureModelID,
                            IsDreamProject = stupf.IsDreamProject ?? false,
                            Email = stuct.Email,
                            Telephone = stuct.Telephone,
                            Mobile = stuct.Mobile,
                            ZIPCode = stuct.ZIPCode,
                            WeChatNum = stuct.WeChatNum,
                            QQ = stuct.QQ,
                            HealthStateID = stupf.HealthStateID,
                            BloodGroup = stupf.BloodGroup,
                            Specialty = stupf.Specialty,
                            Height = stupf.Height,
                            Weight = stupf.Weight,
                            DirectorName = stupf.DirectorName,
                            Score = sturt.Score,
                            EntranceWayID = sturt.EntranceWayID,
                            FeaturesID = sturt.FeaturesID,
                            TerritorialID = sturt.TerritorialID,
                            Area = sturt.Area,
                            HomeAddress = stuct.HomeAddress,
                            WorkUnit = stuct.WorkUnit,
                            Address = stuct.Address,
                            Recipient = stuct.Recipient,
                            Dormitory = stuct.Dormitory,
                            BankName = stuac.BankName,
                            CardNo = stuac.CardNo,
                            StudentCardNo = stu.StudentCardNo,
                            PhotoUrl = stu.PhotoUrl,
                            PlanningGraduateDate = stu.PlanningGraduateDate,
                            GraduateDate = stu.GraduateDate,
                            GraduateCardNo = stu.GraduateCardNo,
                            ReplaceGraduateNo = stu.ReplaceGraduateNo,
                            DegreeStatus = stu.DegreeStatus ?? false,
                            GraduationPictureUrl = stu.GraduationPictureUrl,
                            Career = stu.Career,
                            IsProofread = stu.IsProofread ?? false,
                            Remark = stu.Remark,
                            IP = stucst.IP,
                            ApprovalStatus = stucst.ApprovalStatus,
                            Comment = stucst.Comment,
                            ApprovalTime = stucst.ModifyTime,
                            StudentViewSource = new StudentView()
                            {
                                UserID = stucst.UserID,
                                StudentNo = ussou.LoginID,
                                LoginID = ussou.LoginID,
                                ExamineeNum = sturtsou.ExamineeNum,
                                AdmissionTicketNo = sturtsou.AdmissionTicketNo,
                                Name = ussou.Name,
                                UserName = ussou.Name,
                                UsedName = stupfsou.UsedName,
                                ClassmajorID = stu.ClassmajorID,
                                ClassmajorNo = cl.No,
                                ClassmajorName = cl.Name,
                                ClassNum = cl.ClassNum,
                                StandardID = fa.StandardID,
                                EducationID = fa.EducationID,
                                LearningformID = fa.LearningformID,
                                LearnSystem = fa.LearnSystem,
                                FacultymajorID = gr.FacultymajorID,
                                FacultymajorCode = fa.Code,
                                FacultymajorName = fa.Name,
                                GradeID = gr.GradeID,
                                SemesterID = gr.SemesterID,
                                GrademajorID = cl.GrademajorID,
                                GrademajorCode = gr.Code,
                                GrademajorName = gr.Name,
                                CollegeID = fa.CollegeID,
                                CollegeNo = col.No,
                                CollegeName = col.Name,
                                CampusID = col.CampusID,
                                CampusCode = cam.No,
                                CampusName = cam.Name,
                                Country = stupfsou.Country,
                                Place = stupfsou.Place,
                                BornPlace = stupfsou.BornPlace,
                                SexID = stusou.SexID,
                                BirthDate = stusou.BirthDate,
                                NationID = stusou.NationID,
                                PoliticsID = stusou.PoliticsID,
                                CertificatesType = stusou.CertificatesType,
                                IDNumber = stusou.IDNumber,
                                StudentType = stusou.StudentType,
                                InSchoolStatusID = stusou.InSchoolStatusID,
                                StudentStatus = stusou.StudentStatus,
                                ExamineeType = sturtsou.ExamineeType,
                                EntranceDate = sturtsou.EntranceDate,
                                LiteracyLevelID = stupfsou.LiteracyLevelID,
                                CultureModelID = stupfsou.CultureModelID,
                                IsDreamProject = stupfsou.IsDreamProject ?? false,
                                Email = stuctsou.Email,
                                Telephone = stuctsou.Telephone,
                                Mobile = stuctsou.Mobile,
                                ZIPCode = stuctsou.ZIPCode,
                                WeChatNum = stuctsou.WeChatNum,
                                QQ = stuctsou.QQ,
                                HealthStateID = stupfsou.HealthStateID,
                                BloodGroup = stupfsou.BloodGroup,
                                Specialty = stupfsou.Specialty,
                                Height = stupfsou.Height,
                                Weight = stupfsou.Weight,
                                DirectorName = stupfsou.DirectorName,
                                Score = sturtsou.Score,
                                EntranceWayID = sturtsou.EntranceWayID,
                                FeaturesID = sturtsou.FeaturesID,
                                TerritorialID = sturtsou.TerritorialID,
                                Area = sturtsou.Area,
                                HomeAddress = stuctsou.HomeAddress,
                                WorkUnit = stuctsou.WorkUnit,
                                Address = stuctsou.Address,
                                Recipient = stuctsou.Recipient,
                                Dormitory = stuctsou.Dormitory,
                                BankName = stuacsou.BankName,
                                CardNo = stuacsou.CardNo,
                                RecruitPictureUrl = sturtsou.RecruitPictureUrl,
                                StudentCardNo = stusou.StudentCardNo,
                                PhotoUrl = stusou.PhotoUrl,
                                PlanningGraduateDate = stusou.PlanningGraduateDate,
                                GraduateDate = stusou.GraduateDate,
                                GraduateCardNo = stusou.GraduateCardNo,
                                ReplaceGraduateNo = stusou.ReplaceGraduateNo,
                                DegreeStatus = stusou.DegreeStatus ?? false,
                                GraduationPictureUrl = stusou.GraduationPictureUrl,
                                Career = stusou.Career,
                                IsPhotoComparison = stusou.IsPhotoComparison ?? false,
                                IsProofread = stusou.IsProofread ?? false,
                                Remark = stusou.Remark
                            },
                            StudentViewContrast = new StudentView()
                            {
                                UserID = stucst.UserID,
                                StudentNo = uscst.LoginID,
                                LoginID = uscst.LoginID,
                                ExamineeNum = sturtcst.ExamineeNum,
                                AdmissionTicketNo = sturtcst.AdmissionTicketNo,
                                Name = uscst.Name,
                                UserName = uscst.Name,
                                UsedName = stupfcst.UsedName,
                                ClassmajorID = stu.ClassmajorID,
                                ClassmajorNo = cl.No,
                                ClassmajorName = cl.Name,
                                ClassNum = cl.ClassNum,
                                StandardID = fa.StandardID,
                                EducationID = fa.EducationID,
                                LearningformID = fa.LearningformID,
                                LearnSystem = fa.LearnSystem,
                                FacultymajorID = gr.FacultymajorID,
                                FacultymajorCode = fa.Code,
                                FacultymajorName = fa.Name,
                                GradeID = gr.GradeID,
                                SemesterID = gr.SemesterID,
                                GrademajorID = cl.GrademajorID,
                                GrademajorCode = gr.Code,
                                GrademajorName = gr.Name,
                                CollegeID = fa.CollegeID,
                                CollegeNo = col.No,
                                CollegeName = col.Name,
                                CampusID = col.CampusID,
                                CampusCode = cam.No,
                                CampusName = cam.Name,
                                Country = stupfcst.Country,
                                Place = stupfcst.Place,
                                BornPlace = stupfcst.BornPlace,
                                SexID = stucst.SexID,
                                BirthDate = stucst.BirthDate,
                                NationID = stucst.NationID,
                                PoliticsID = stucst.PoliticsID,
                                CertificatesType = stucst.CertificatesType,
                                IDNumber = stucst.IDNumber,
                                StudentType = stucst.StudentType,
                                InSchoolStatusID = stucst.InSchoolStatusID,
                                StudentStatus = stucst.StudentStatus,
                                ExamineeType = sturtcst.ExamineeType,
                                EntranceDate = sturtcst.EntranceDate,
                                LiteracyLevelID = stupfcst.LiteracyLevelID,
                                CultureModelID = stupfcst.CultureModelID,
                                IsDreamProject = stupfcst.IsDreamProject ?? false,
                                Email = stuctcst.Email,
                                Telephone = stuctcst.Telephone,
                                Mobile = stuctcst.Mobile,
                                ZIPCode = stuctcst.ZIPCode,
                                WeChatNum = stuctcst.WeChatNum,
                                QQ = stuctcst.QQ,
                                HealthStateID = stupfcst.HealthStateID,
                                BloodGroup = stupfcst.BloodGroup,
                                Specialty = stupfcst.Specialty,
                                Height = stupfcst.Height,
                                Weight = stupfcst.Weight,
                                DirectorName = stupfcst.DirectorName,
                                Score = sturtcst.Score,
                                EntranceWayID = sturtcst.EntranceWayID,
                                FeaturesID = sturtcst.FeaturesID,
                                TerritorialID = sturtcst.TerritorialID,
                                Area = sturtcst.Area,
                                HomeAddress = stuctcst.HomeAddress,
                                WorkUnit = stuctcst.WorkUnit,
                                Address = stuctcst.Address,
                                Recipient = stuctcst.Recipient,
                                Dormitory = stuctcst.Dormitory,
                                BankName = stuaccst.BankName,
                                CardNo = stuaccst.CardNo,
                                RecruitPictureUrl = sturtcst.RecruitPictureUrl,
                                StudentCardNo = stucst.StudentCardNo,
                                PhotoUrl = stucst.PhotoUrl,
                                PlanningGraduateDate = stucst.PlanningGraduateDate,
                                GraduateDate = stucst.GraduateDate,
                                GraduateCardNo = stucst.GraduateCardNo,
                                ReplaceGraduateNo = stucst.ReplaceGraduateNo,
                                DegreeStatus = stucst.DegreeStatus ?? false,
                                GraduationPictureUrl = stucst.GraduationPictureUrl,
                                Career = stucst.Career,
                                IsPhotoComparison = stucst.IsPhotoComparison ?? false,
                                IsProofread = stucst.IsProofread ?? false,
                                Remark = stucst.Remark
                            },
                            RecordStatus = stuhis.RecordStatus,
                            CreateUserID = stuhis.CreateUserID,
                            CreateTime = stuhis.CreateTime,
                            ModifyUserID = stuhis.ModifyUserID,
                            ModifyTime = stuhis.ModifyTime
                        };

            return query;
        }

    }
}