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; }
///
/// 查询对应的校对记录信息CheckingHistoryView
///
///
///
public IQueryable GetCheckingHistoryViewQueryable(Expression> 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;
}
///
/// 查询对应的校对记录信息CheckingHistoryView
///
///
///
///
///
public IQueryable GetCheckingHistoryViewQueryable(Expression> expStudentRecordChangeHistory,
Expression> expStudentContrast, Expression> 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;
}
}
}