JW/学校扩展文件/EMIS.ExtensionLogic.GZMS/ServiceLogic/StudentManage/StudentServices.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Text.RegularExpressions;
using System.Transactions;
using Bowin.Common.Utility;
using EMIS.Entities;
using EMIS.ViewModel;
using EMIS.ViewModel.CacheManage;
using EMIS.ViewModel.StudentManage.StudentProfile;

namespace EMIS.ExtensionLogic.ServiceLogic.StudentManage
{
    public class StudentServices : EMIS.CommonLogic.StudentManage.StudentProfile.StudentServices
    {
        /// <summary>
        /// 编辑（新增、修改，业务主键：学号或考生号唯一）
        /// 注：学号总位数问题(广州美术)
        /// </summary>
        /// <param name="studentView"></param>
        /// <param name="photoUrl"></param>
        public override void StudentEdit(StudentView studentView, string photoUrl)
        {
            try
            {
                //查询相关Web.config配置
                if (EMIS.Utility.Const.LOCAL_SETTING_PlanningGraduateDateSpringMonth == null)
                {
                    throw new Exception("预计毕业月（春季、上学期入学月）未配置，请检查。");
                }
                if (EMIS.Utility.Const.LOCAL_SETTING_PlanningGraduateDateSpringDay == null)
                {
                    throw new Exception("预计毕业日（春季、上学期入学日）未配置，请检查。");
                }
                if (EMIS.Utility.Const.LOCAL_SETTING_PlanningGraduateDateAutumnMonth == null)
                {
                    throw new Exception("预计毕业月（秋季、下学期入学月）未配置，请检查。");
                }
                if (EMIS.Utility.Const.LOCAL_SETTING_PlanningGraduateDateAutumnDay == null)
                {
                    throw new Exception("预计毕业日（秋季、下学期入学日）未配置，请检查。");
                }
                if (EMIS.Utility.Const.LOCAL_SETTING_ENTRANCESEMESTERID == null)
                {
                    throw new Exception("入学学期（春季、上学期、秋季、下学期）未配置，请检查。");
                }
                var studentNoTotal = EMIS.Utility.Const.LOCAL_SETTING_LOGINIDTOTAL;
                if (studentNoTotal == null)
                {
                    throw new Exception("学号总位数未配置，请检查。");
                }
                if (!string.IsNullOrEmpty(studentView.StudentNo))
                {
                    if (studentView.StudentNo.Trim().Length > Convert.ToInt32(studentNoTotal))
                    {
                        throw new Exception("输入的学号总位数有误，学号总位数应小于等于" + studentNoTotal + "位。");
                    }
                }
                else
                {
                    throw new Exception("学号不能为空，请输入学号。");
                }
                var userVerify = StudentDAL.Value.UserRepository.GetList(x => x.UserID != studentView.UserID && x.LoginID == studentView.StudentNo.Trim()).SingleOrDefault();
                if (userVerify == null)
                {
                    var newStudentVerify = StudentDAL.Value.NewStudentRepository.GetList(x => x.AssignStatus == (int)CF_AssignStatus.Assigned
                            && x.ExamineeNum != studentView.ExamineeNum && x.StudentNo == studentView.StudentNo.Trim()).SingleOrDefault();
                    if (newStudentVerify != null)
                    {
                        throw new Exception("录取名单中已存在相同的学号(学号重复)，请核查。");
                    }
                    if (!string.IsNullOrEmpty(studentView.ExamineeNum))
                    {
                        var examineeNumVerify = StudentDAL.Value.RecruitstudentsRepository.GetList(x => x.UserID != studentView.UserID
                                && x.ExamineeNum == studentView.ExamineeNum.Trim()).SingleOrDefault();
                        if (examineeNumVerify != null)
                        {
                            throw new Exception("已存在相同的考生号(考生号重复)，请核查。");
                        }
                    }
                    if (!string.IsNullOrEmpty(studentView.StudentCardNo))
                    {
                        var studentCardNoVerify = StudentDAL.Value.StudentRepository.GetList(x => x.UserID != studentView.UserID
                                && x.StudentCardNo == studentView.StudentCardNo.Trim()).SingleOrDefault();
                        if (studentCardNoVerify != null)
                        {
                            throw new Exception("已存在相同的学籍卡编号(学籍卡编号重复)，请核查。");
                        }
                    }
                    if (!string.IsNullOrEmpty(studentView.GraduateCardNo))
                    {
                        var graduateCardNoVerify = StudentDAL.Value.StudentRepository.GetList(x => x.UserID != studentView.UserID
                                && x.GraduateCardNo == studentView.GraduateCardNo.Trim()).SingleOrDefault();
                        if (graduateCardNoVerify != null)
                        {
                            throw new Exception("已存在相同的毕结业证书编号(毕结业证书编号重复)，请核查。");
                        }
                    }
                    if (!string.IsNullOrEmpty(studentView.ReplaceGraduateNo))
                    {
                        var replaceGraduateNoVerify = StudentDAL.Value.StudentRepository.GetList(x => x.UserID != studentView.UserID
                                && x.ReplaceGraduateNo == studentView.ReplaceGraduateNo.Trim()).SingleOrDefault();
                        if (replaceGraduateNoVerify != null)
                        {
                            throw new Exception("已存在相同的补证编号(补证编号重复)，请核查。");
                        }
                    }
                    var passwordParameter = StudentDAL.Value.ParameterRepository.GetSingle(x => x.ParameterTypeID == (int)ViewModel.CF_ParameterType.StudentInitPassword);
                    var roleList = StudentDAL.Value.RoleRepository.GetList(x => x.TypeID == (int)SYS_RoleType.Student, (x => x.CF_StudentRole)).ToList();

                    List<Sys_User> newUserInList = new List<Sys_User>();
                    List<Sys_User> newUserUpList = new List<Sys_User>();
                    List<CF_Student> newStudentInList = new List<CF_Student>();
                    List<CF_Student> newStudentUpList = new List<CF_Student>();
                    List<CF_StudentProfile> newStudentProfileInList = new List<CF_StudentProfile>();
                    List<CF_StudentProfile> newStudentProfileUpList = new List<CF_StudentProfile>();
                    List<CF_StudentContact> newStudentContactInList = new List<CF_StudentContact>();
                    List<CF_StudentContact> newStudentContactUpList = new List<CF_StudentContact>();
                    List<CF_StudentAccount> newStudentAccountInList = new List<CF_StudentAccount>();
                    List<CF_StudentAccount> newStudentAccountUpList = new List<CF_StudentAccount>();
                    List<CF_Recruitstudents> newRecruitstudentsInList = new List<CF_Recruitstudents>();
                    List<CF_Recruitstudents> newRecruitstudentsUpList = new List<CF_Recruitstudents>();

                    if (studentView.UserID != Guid.Empty)
                    {
                        //修改
                        var student = StudentDAL.Value.StudentRepository.GetList(x => x.UserID == studentView.UserID,
                                (x => x.CF_StudentProfile), (x => x.CF_StudentContact), (x => x.CF_StudentAccount),
                                (x => x.CF_Recruitstudents), (x => x.Sys_User)).SingleOrDefault();
                        if (student == null)
                        {
                            throw new Exception("数据有误，请核查。");
                        }
                        else
                        {
                            student.Sys_User.LoginID = studentView.StudentNo.Trim();
                            student.Sys_User.Name = studentView.Name.Trim();
                            this.SetModifyStatus(student.Sys_User);
                            newUserUpList.Add(student.Sys_User);
                            student.ClassmajorID = studentView.ClassmajorID;
                            student.SexID = studentView.SexID;
                            student.BirthDate = studentView.BirthDate;
                            student.NationID = studentView.NationID;
                            student.PoliticsID = studentView.PoliticsID;
                            student.CertificatesType = studentView.CertificatesType;
                            student.IDNumber = studentView.IDNumber;
                            student.StudentType = studentView.StudentType;
                            student.Sys_User.Sys_Role = new HashSet<Sys_Role>();
                            roleList = roleList.Where(x => x.CF_StudentRole.StudentType == studentView.StudentType).ToList();
                            if (roleList != null && roleList.Count > 0)
                            {
                                roleList.ForEach(x => student.Sys_User.Sys_Role.Add(x));
                            }
                            else
                            {
                                //对应角色为空时，默认为不分配用户角色
                            }
                            student.InSchoolStatusID = studentView.InSchoolStatusID;
                            student.StudentStatus = studentView.StudentStatus;
                            student.StudentCardNo = studentView.StudentCardNo;
                            if (!string.IsNullOrEmpty(photoUrl))
                            {
                                student.PhotoUrl = photoUrl;
                            }
                            if (studentView.PlanningGraduateDate.HasValue)
                            {
                                student.PlanningGraduateDate = studentView.PlanningGraduateDate;
                            }
                            if (studentView.GraduateDate.HasValue)
                            {
                                student.GraduateDate = studentView.GraduateDate;
                            }
                            student.GraduateCardNo = studentView.GraduateCardNo;
                            student.ReplaceGraduateNo = studentView.ReplaceGraduateNo;
                            student.DegreeStatus = studentView.DegreeStatus;
                            //if (!string.IsNullOrEmpty(studentView.GraduationPictureUrl))
                            //{
                            //    student.GraduationPictureUrl = studentView.GraduationPictureUrl;
                            //}
                            student.Career = studentView.Career;
                            //student.IsPhotoComparison = studentView.IsPhotoComparison;
                            //student.IsProofread = studentView.IsProofread;
                            student.Remark = studentView.Remark;
                            this.SetModifyStatus(student);
                            newStudentUpList.Add(student);
                            if (student.CF_StudentProfile == null)
                            {
                                var studentProfile = new CF_StudentProfile();
                                studentProfile.UserID = student.UserID;
                                studentProfile.UsedName = studentView.UsedName;
                                studentProfile.LiteracyLevelID = studentView.LiteracyLevelID;
                                studentProfile.CultureModelID = studentView.CultureModelID;
                                studentProfile.IsDreamProject = studentView.IsDreamProject;
                                studentProfile.Country = studentView.Country;
                                studentProfile.Place = studentView.Place;
                                studentProfile.BornPlace = studentView.BornPlace;
                                studentProfile.HealthStateID = studentView.HealthStateID;
                                studentProfile.BloodGroup = studentView.BloodGroup;
                                studentProfile.Specialty = studentView.Specialty;
                                studentProfile.Height = studentView.Height;
                                studentProfile.Weight = studentView.Weight;
                                studentProfile.DirectorName = studentView.DirectorName;
                                this.SetNewStatus(studentProfile);
                                newStudentProfileInList.Add(studentProfile);
                            }
                            else
                            {
                                student.CF_StudentProfile.UsedName = studentView.UsedName;
                                student.CF_StudentProfile.LiteracyLevelID = studentView.LiteracyLevelID;
                                student.CF_StudentProfile.CultureModelID = studentView.CultureModelID;
                                student.CF_StudentProfile.IsDreamProject = studentView.IsDreamProject;
                                student.CF_StudentProfile.Country = studentView.Country;
                                student.CF_StudentProfile.Place = studentView.Place;
                                student.CF_StudentProfile.BornPlace = studentView.BornPlace;
                                student.CF_StudentProfile.HealthStateID = studentView.HealthStateID;
                                student.CF_StudentProfile.BloodGroup = studentView.BloodGroup;
                                student.CF_StudentProfile.Specialty = studentView.Specialty;
                                student.CF_StudentProfile.Height = studentView.Height;
                                student.CF_StudentProfile.Weight = studentView.Weight;
                                student.CF_StudentProfile.DirectorName = studentView.DirectorName;
                                this.SetModifyStatus(student.CF_StudentProfile);
                                newStudentProfileUpList.Add(student.CF_StudentProfile);
                            }
                            if (student.CF_StudentContact == null)
                            {
                                var studentContact = new CF_StudentContact();
                                studentContact.UserID = student.UserID;
                                studentContact.Email = studentView.Email;
                                studentContact.Telephone = studentView.Email;
                                studentContact.Mobile = studentView.Email;
                                studentContact.ZIPCode = studentView.ZIPCode;
                                studentContact.WeChatNum = studentView.WeChatNum;
                                studentContact.QQ = studentView.QQ;
                                studentContact.HomeAddress = studentView.HomeAddress;
                                studentContact.WorkUnit = studentView.WorkUnit;
                                studentContact.Address = studentView.Address;
                                studentContact.Recipient = studentView.Recipient;
                                studentContact.Dormitory = studentView.Dormitory;
                                this.SetNewStatus(studentContact);
                                newStudentContactInList.Add(studentContact);
                            }
                            else
                            {
                                student.CF_StudentContact.Email = studentView.Email;
                                student.CF_StudentContact.Telephone = studentView.Telephone;
                                student.CF_StudentContact.Mobile = studentView.Mobile;
                                student.CF_StudentContact.ZIPCode = studentView.ZIPCode;
                                student.CF_StudentContact.WeChatNum = studentView.WeChatNum;
                                student.CF_StudentContact.QQ = studentView.QQ;
                                student.CF_StudentContact.HomeAddress = studentView.HomeAddress;
                                student.CF_StudentContact.WorkUnit = studentView.WorkUnit;
                                student.CF_StudentContact.Address = studentView.Address;
                                student.CF_StudentContact.Recipient = studentView.Recipient;
                                student.CF_StudentContact.Dormitory = studentView.Dormitory;
                                this.SetModifyStatus(student.CF_StudentContact);
                                newStudentContactUpList.Add(student.CF_StudentContact);
                            }
                            if (student.CF_StudentAccount == null)
                            {
                                var studentAccount = new CF_StudentAccount();
                                studentAccount.UserID = student.UserID;
                                studentAccount.BankName = studentView.BankName;
                                studentAccount.CardNo = studentView.CardNo;
                                this.SetNewStatus(studentAccount);
                                newStudentAccountInList.Add(studentAccount);
                            }
                            else
                            {
                                student.CF_StudentAccount.BankName = studentView.BankName;
                                student.CF_StudentAccount.CardNo = studentView.CardNo;
                                this.SetModifyStatus(student.CF_StudentAccount);
                                newStudentAccountUpList.Add(student.CF_StudentAccount);
                            }
                            if (student.CF_Recruitstudents == null)
                            {
                                var recruitstudents = new CF_Recruitstudents();
                                recruitstudents.UserID = student.UserID;
                                recruitstudents.ExamineeNum = studentView.ExamineeNum;
                                recruitstudents.AdmissionTicketNo = studentView.AdmissionTicketNo;
                                recruitstudents.ExamineeType = studentView.ExamineeType;
                                recruitstudents.EnteringSchoolYearID = studentView.StartSchoolyearID;
                                recruitstudents.EntranceDate = studentView.EntranceDate;
                                recruitstudents.Score = studentView.Score;
                                recruitstudents.EntranceWayID = studentView.EntranceWayID;
                                recruitstudents.FeaturesID = studentView.FeaturesID;
                                recruitstudents.TerritorialID = studentView.TerritorialID;
                                recruitstudents.Area = studentView.Area;
                                //if (!string.IsNullOrEmpty(studentView.RecruitPictureUrl))
                                //{
                                //    recruitstudents.RecruitPictureUrl = studentView.RecruitPictureUrl;
                                //}
                                this.SetNewStatus(recruitstudents);
                                newRecruitstudentsInList.Add(recruitstudents);
                            }
                            else
                            {
                                student.CF_Recruitstudents.ExamineeNum = studentView.ExamineeNum;
                                student.CF_Recruitstudents.AdmissionTicketNo = studentView.AdmissionTicketNo;
                                student.CF_Recruitstudents.ExamineeType = studentView.ExamineeType;
                                student.CF_Recruitstudents.EnteringSchoolYearID = studentView.StartSchoolyearID;
                                student.CF_Recruitstudents.EntranceDate = studentView.EntranceDate;
                                student.CF_Recruitstudents.Score = studentView.Score;
                                student.CF_Recruitstudents.EntranceWayID = studentView.EntranceWayID;
                                student.CF_Recruitstudents.FeaturesID = studentView.FeaturesID;
                                student.CF_Recruitstudents.TerritorialID = studentView.TerritorialID;
                                student.CF_Recruitstudents.Area = studentView.Area;
                                //if (!string.IsNullOrEmpty(studentView.RecruitPictureUrl))
                                //{
                                //    student.CF_Recruitstudents.RecruitPictureUrl = studentView.RecruitPictureUrl;
                                //}
                                this.SetModifyStatus(student.CF_Recruitstudents);
                                newRecruitstudentsUpList.Add(student.CF_Recruitstudents);
                            }
                        }
                    }
                    else
                    {
                        //新增
                        var newUser = new Sys_User();
                        newUser.UserID = Guid.NewGuid();
                        newUser.LoginID = studentView.StudentNo.Trim();
                        newUser.Name = studentView.Name.Trim();
                        if (passwordParameter == null)
                        {
                            newUser.Password = ("A" + studentView.StudentNo.Trim()).MD5();
                        }
                        else
                        {
                            if (passwordParameter.Value != null)
                            {
                                newUser.Password = passwordParameter.Value;
                            }
                            else
                            {
                                newUser.Password = ("A" + studentView.StudentNo.Trim()).MD5();
                            }
                        }
                        this.SetNewStatus(newUser, (int)SYS_STATUS.USABLE);
                        newUserInList.Add(newUser);
                        newUser.Sys_Role = new HashSet<Sys_Role>();
                        roleList = roleList.Where(x => x.CF_StudentRole.StudentType == studentView.StudentType).ToList();
                        if (roleList != null && roleList.Count > 0)
                        {
                            roleList.ForEach(x => newUser.Sys_Role.Add(x));
                        }
                        else
                        {
                            //对应角色为空时，默认为不分配用户角色
                        }
                        var newStudent = new CF_Student();
                        newStudent.UserID = newUser.UserID;
                        newStudent.ClassmajorID = studentView.ClassmajorID;
                        newStudent.SexID = studentView.SexID;
                        newStudent.BirthDate = studentView.BirthDate;
                        newStudent.NationID = studentView.NationID;
                        newStudent.PoliticsID = studentView.PoliticsID;
                        newStudent.CertificatesType = studentView.CertificatesType;
                        newStudent.IDNumber = studentView.IDNumber;
                        newStudent.StudentType = studentView.StudentType;
                        newStudent.InSchoolStatusID = studentView.InSchoolStatusID;
                        newStudent.StudentStatus = studentView.StudentStatus;
                        newStudent.StudentCardNo = studentView.StudentCardNo;
                        if (!string.IsNullOrEmpty(photoUrl))
                        {
                            newStudent.PhotoUrl = photoUrl;
                        }
                        newStudent.PlanningGraduateDate = this.GetClassmajorPlanningGraduateDate(studentView.ClassmajorID);
                        newStudent.GraduateDate = this.GetClassmajorGraduateDate(studentView.ClassmajorID);
                        newStudent.GraduateCardNo = studentView.GraduateCardNo;
                        newStudent.ReplaceGraduateNo = studentView.ReplaceGraduateNo;
                        newStudent.DegreeStatus = studentView.DegreeStatus;
                        //if (!string.IsNullOrEmpty(studentView.GraduationPictureUrl))
                        //{
                        //    newStudent.GraduationPictureUrl = studentView.GraduationPictureUrl;
                        //}
                        newStudent.Career = studentView.Career;
                        //newStudent.IsPhotoComparison = studentView.IsPhotoComparison;
                        //newStudent.IsProofread = studentView.IsProofread;
                        newStudent.Remark = studentView.Remark;
                        this.SetNewStatus(newStudent);
                        newStudentInList.Add(newStudent);
                        var newStudentProfile = new CF_StudentProfile();
                        newStudentProfile.UserID = newStudent.UserID;
                        newStudentProfile.UsedName = studentView.UsedName;
                        newStudentProfile.LiteracyLevelID = studentView.LiteracyLevelID;
                        newStudentProfile.CultureModelID = studentView.CultureModelID;
                        newStudentProfile.IsDreamProject = studentView.IsDreamProject;
                        newStudentProfile.Country = studentView.Country;
                        newStudentProfile.Place = studentView.Place;
                        newStudentProfile.BornPlace = studentView.BornPlace;
                        newStudentProfile.HealthStateID = studentView.HealthStateID;
                        newStudentProfile.BloodGroup = studentView.BloodGroup;
                        newStudentProfile.Specialty = studentView.Specialty;
                        newStudentProfile.Height = studentView.Height;
                        newStudentProfile.Weight = studentView.Weight;
                        newStudentProfile.DirectorName = studentView.DirectorName;
                        this.SetNewStatus(newStudentProfile);
                        newStudentProfileInList.Add(newStudentProfile);
                        var newStudentContact = new CF_StudentContact();
                        newStudentContact.UserID = newStudent.UserID;
                        newStudentContact.Email = studentView.Email;
                        newStudentContact.Telephone = studentView.Telephone;
                        newStudentContact.Mobile = studentView.Mobile;
                        newStudentContact.ZIPCode = studentView.ZIPCode;
                        newStudentContact.WeChatNum = studentView.WeChatNum;
                        newStudentContact.QQ = studentView.QQ;
                        newStudentContact.HomeAddress = studentView.HomeAddress;
                        newStudentContact.WorkUnit = studentView.WorkUnit;
                        newStudentContact.Address = studentView.Address;
                        newStudentContact.Recipient = studentView.Recipient;
                        newStudentContact.Dormitory = studentView.Dormitory;
                        this.SetNewStatus(newStudentContact);
                        newStudentContactInList.Add(newStudentContact);
                        var newStudentAccount = new CF_StudentAccount();
                        newStudentAccount.UserID = newStudent.UserID;
                        newStudentAccount.CardNo = studentView.CardNo;
                        newStudentAccount.BankName = studentView.BankName;
                        this.SetNewStatus(newStudentAccount);
                        newStudentAccountInList.Add(newStudentAccount);
                        var newRecruitstudents = new CF_Recruitstudents();
                        newRecruitstudents.UserID = newStudent.UserID;
                        newRecruitstudents.ExamineeNum = studentView.ExamineeNum;
                        newRecruitstudents.AdmissionTicketNo = studentView.AdmissionTicketNo;
                        newRecruitstudents.ExamineeType = studentView.ExamineeType;
                        newRecruitstudents.EnteringSchoolYearID = studentView.StartSchoolyearID;
                        newRecruitstudents.EntranceDate = studentView.EntranceDate;
                        newRecruitstudents.Score = studentView.Score;
                        newRecruitstudents.EntranceWayID = studentView.EntranceWayID;
                        newRecruitstudents.FeaturesID = studentView.FeaturesID;
                        newRecruitstudents.TerritorialID = studentView.TerritorialID;
                        newRecruitstudents.Area = studentView.Area;
                        //if (!string.IsNullOrEmpty(studentView.RecruitPictureUrl))
                        //{
                        //    newRecruitstudents.RecruitPictureUrl = studentView.RecruitPictureUrl;
                        //}
                        this.SetNewStatus(newRecruitstudents);
                        newRecruitstudentsInList.Add(newRecruitstudents);
                    }
                    using (TransactionScope ts = new TransactionScope())
                    {
                        UnitOfWork.BulkInsert<Sys_User>(newUserInList);
                        UnitOfWork.BulkInsert(newUserInList, (x => x.Sys_Role));
                        UnitOfWork.BulkInsert<CF_Student>(newStudentInList);
                        UnitOfWork.BulkInsert<CF_StudentProfile>(newStudentProfileInList);
                        UnitOfWork.BulkInsert<CF_StudentContact>(newStudentContactInList);
                        UnitOfWork.BulkInsert<CF_StudentAccount>(newStudentAccountInList);
                        UnitOfWork.BulkInsert<CF_Recruitstudents>(newRecruitstudentsInList);
                        if (newUserUpList != null && newUserUpList.Count() > 0)
                        {
                            UnitOfWork.BatchUpdate(newUserUpList);
                            UnitOfWork.Delete(newUserUpList, (x => x.Sys_Role));
                            UnitOfWork.BulkInsert(newUserUpList, (x => x.Sys_Role));
                        }
                        if (newStudentUpList != null && newStudentUpList.Count() > 0)
                        {
                            UnitOfWork.BatchUpdate(newStudentUpList);
                        }
                        if (newStudentProfileUpList != null && newStudentProfileUpList.Count() > 0)
                        {
                            UnitOfWork.BatchUpdate(newStudentProfileUpList);
                        }
                        if (newStudentContactUpList != null && newStudentContactUpList.Count() > 0)
                        {
                            UnitOfWork.BatchUpdate(newStudentContactUpList);
                        }
                        if (newStudentAccountUpList != null && newStudentAccountUpList.Count() > 0)
                        {
                            UnitOfWork.BatchUpdate(newStudentAccountUpList);
                        }
                        if (newRecruitstudentsUpList != null && newRecruitstudentsUpList.Count() > 0)
                        {
                            UnitOfWork.BatchUpdate(newRecruitstudentsUpList);
                        }
                        ts.Complete();
                    }
                }
                else
                {
                    var studentVerify = StudentDAL.Value.StudentRepository.GetList(x => x.UserID != studentView.UserID,
                            (x => x.Sys_User)).Where(x => x.Sys_User.LoginID == studentView.StudentNo.Trim()).SingleOrDefault();
                    if (studentVerify != null)
                    {
                        throw new Exception("已存在相同的学号(学号重复)，请核查。");
                    }
                    else
                    {
                        var staffVerify = StudentDAL.Value.StaffRepository.GetList(x => x.UserID != studentView.UserID,
                                (x => x.Sys_User)).Where(x => x.Sys_User.LoginID == studentView.StudentNo.Trim()).SingleOrDefault();
                        if (staffVerify != null)
                        {
                            throw new Exception("教师信息中已存在相同的用户(用户名重复)，请核查。");
                        }
                        else
                        {
                            throw new Exception("用户信息中已存在相同的用户(用户名重复)，请核查。");
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                throw new Exception(ex.Message);
            }
        }

        /// <summary>
        /// 学生信息Excel导入
        /// 注：学号总位数问题(广州美术)
        /// </summary>
        /// <param name="cellheader"></param>
        /// <param name="inCount"></param>
        /// <param name="upCount"></param>
        /// <param name="errdataList"></param>
        /// <param name="errCount"></param>
        /// <param name="sourcePhysicalPath"></param>
        public override void StudentImport(Dictionary<string, string> cellheader, out int? inCount, out int? upCount, out List<StudentView> errdataList, out int? errCount, string sourcePhysicalPath)
        {
            try
            {
                //查询相关Web.config配置
                if (EMIS.Utility.Const.LOCAL_SETTING_PlanningGraduateDateSpringMonth == null)
                {
                    throw new Exception("预计毕业月（春季、上学期入学月）未配置，请检查。");
                }
                if (EMIS.Utility.Const.LOCAL_SETTING_PlanningGraduateDateSpringDay == null)
                {
                    throw new Exception("预计毕业日（春季、上学期入学日）未配置，请检查。");
                }
                if (EMIS.Utility.Const.LOCAL_SETTING_PlanningGraduateDateAutumnMonth == null)
                {
                    throw new Exception("预计毕业月（秋季、下学期入学月）未配置，请检查。");
                }
                if (EMIS.Utility.Const.LOCAL_SETTING_PlanningGraduateDateAutumnDay == null)
                {
                    throw new Exception("预计毕业日（秋季、下学期入学日）未配置，请检查。");
                }
                if (EMIS.Utility.Const.LOCAL_SETTING_ENTRANCESEMESTERID == null)
                {
                    throw new Exception("入学学期（春季、上学期、秋季、下学期）未配置，请检查。");
                }
                var studentNoTotal = EMIS.Utility.Const.LOCAL_SETTING_LOGINIDTOTAL;
                if (studentNoTotal == null)
                {
                    throw new Exception("学号总位数未配置，请检查。");
                }

                StringBuilder errorMsg = new StringBuilder(); // 错误信息
                List<StudentView> errList = new List<StudentView>();
                // 1.1解析文件，存放到一个List集合里
                cellheader.Remove("ErrorMessage");//移除“未导入原因”列(ErrorMessage)
                List<StudentView> enlist = NpoiExcelHelper.ExcelToEntityList<StudentView>(cellheader, sourcePhysicalPath, out errorMsg, out errList);
                cellheader.Add("ErrorMessage", "未导入原因");

                //对List集合进行有效性校验
                if (enlist.Count() <= 0)
                {
                    throw new Exception("Excel文件数据为空，请检查。");
                }

                Regex reg = null; //正则表达式
                DateTime result; //用于返回判断日期字段格式
                inCount = 0; //导入个数
                upCount = 0; //更新个数
                errCount = 0; //失败个数
                string errorMsgStr = ""; //错误信息

                List<Sys_User> newUserInList = new List<Sys_User>();
                List<Sys_User> newUserUpList = new List<Sys_User>();
                List<CF_Student> newStudentInList = new List<CF_Student>();
                List<CF_Student> newStudentUpList = new List<CF_Student>();
                List<CF_StudentProfile> newStudentProfileInList = new List<CF_StudentProfile>();
                List<CF_StudentProfile> newStudentProfileUpList = new List<CF_StudentProfile>();
                List<CF_StudentContact> newStudentContactInList = new List<CF_StudentContact>();
                List<CF_StudentContact> newStudentContactUpList = new List<CF_StudentContact>();
                List<CF_StudentAccount> newStudentAccountInList = new List<CF_StudentAccount>();
                List<CF_StudentAccount> newStudentAccountUpList = new List<CF_StudentAccount>();
                List<CF_Recruitstudents> newRecruitstudentsInList = new List<CF_Recruitstudents>();
                List<CF_Recruitstudents> newRecruitstudentsUpList = new List<CF_Recruitstudents>();

                var passwordParameter = StudentDAL.Value.ParameterRepository.GetSingle(x => x.ParameterTypeID == (int)ViewModel.CF_ParameterType.StudentInitPassword);
                var roleList = StudentDAL.Value.RoleRepository.GetList(x => x.TypeID == (int)SYS_RoleType.Student, (x => x.CF_StudentRole)).ToList();

                //将循环中相关数据库查询统一查询出来进行匹配(尽量避免在循环中进行数据库查询)
                //性别
                var sexList = IdNameExt.GetDictionaryItem(DictionaryItem.CF_Sex).ToList();
                //民族
                var nationList = IdNameExt.GetDictionaryItem(DictionaryItem.CF_Nation).ToList();
                //政治面貌
                var politicsList = IdNameExt.GetDictionaryItem(DictionaryItem.CF_Politics).ToList();
                //学生类别
                var studentTypeList = IdNameExt.GetDictionaryItem(DictionaryItem.CF_STUDENTTYPE).ToList();
                //证件类型
                var certificatesTypeList = IdNameExt.GetDictionaryItem(DictionaryItem.CF_CertificatesType).ToList();
                //在校状态
                var inschoolStatusList = IdNameExt.GetDictionaryItem(DictionaryItem.CF_InschoolStatus).ToList();
                //学籍状态
                var studentStatusList = IdNameExt.GetDictionaryItem(DictionaryItem.CF_StudentStatus).ToList();
                //文化程度
                var literacyLevelList = IdNameExt.GetDictionaryItem(DictionaryItem.CF_LiteracyLevel).ToList();
                //培养方式
                var cultureModelList = IdNameExt.GetDictionaryItem(DictionaryItem.CF_CULTUREMODEL).ToList();
                //考生类别
                var examineeTypeList = IdNameExt.GetDictionaryItem(DictionaryItem.CF_EXAMINEETYPE).ToList();
                //入学方式
                var entranceWayList = IdNameExt.GetDictionaryItem(DictionaryItem.CF_EntranceWay).ToList();
                //考生特征
                var featuresList = IdNameExt.GetDictionaryItem(DictionaryItem.CF_Features).ToList();
                //生源所属地
                var territorialList = IdNameExt.GetDictionaryItem(DictionaryItem.CF_Province).ToList();
                //健康状况
                var healthStateList = IdNameExt.GetDictionaryItem(DictionaryItem.CF_HealthState).ToList();
                //血型
                var bloodGroupList = IdNameExt.GetDictionaryItem(DictionaryItem.CF_BLOODGROUP).ToList();
                //是否
                var generalPurposeList = IdNameExt.GetDictionaryItem(DictionaryItem.CF_GeneralPurpose).ToList();
                //有无
                var generalExistList = IdNameExt.GetDictionaryItem(DictionaryItem.CF_GeneralExist).ToList();
                //班级编号
                var classmajorNoList = enlist.Where(x => !string.IsNullOrEmpty(x.ClassmajorNo)).Select(x => x.ClassmajorNo.Trim()).ToList();
                //对比后的newClassmajorList
                var newClassmajorList = StudentDAL.Value.ClassmajorRepository.GetList(x => classmajorNoList.Contains(x.No)).ToList();
                //学籍卡编号
                var studentCardNoList = enlist.Where(x => !string.IsNullOrEmpty(x.StudentCardNo)).Select(x => x.StudentCardNo.Trim()).ToList();
                //对比后的newStudentCardNoList
                var newStudentCardNoList = StudentDAL.Value.StudentRepository.GetList(x => studentCardNoList.Contains(x.StudentCardNo)).ToList();
                //毕结业证书编号
                var graduateCardNoList = enlist.Where(x => !string.IsNullOrEmpty(x.GraduateCardNo)).Select(x => x.GraduateCardNo.Trim()).ToList();
                //对比后的newGraduateCardNoList
                var newGraduateCardNoList = StudentDAL.Value.StudentRepository.GetList(x => graduateCardNoList.Contains(x.GraduateCardNo)).ToList();
                //考生号
                var examineeNumList = enlist.Where(x => !string.IsNullOrEmpty(x.ExamineeNum)).Select(x => x.ExamineeNum.Trim()).ToList();
                //对比后的newExamineeNumList
                var newExamineeNumList = StudentDAL.Value.RecruitstudentsRepository.GetList(x => examineeNumList.Contains(x.ExamineeNum)).ToList();
                //学号
                var studentNoList = enlist.Where(x => !string.IsNullOrEmpty(x.StudentNo)).Select(x => x.StudentNo.Trim()).ToList();
                //对比后的newNewStuList
                var newNewStuList = StudentDAL.Value.NewStudentRepository.GetList(x => x.AssignStatus == (int)CF_AssignStatus.Assigned).Where(x => studentNoList.Contains(x.StudentNo)).ToList();
                //对比后的newStudentList
                var newStudentList = StudentDAL.Value.StudentRepository.GetList(x => studentNoList.Contains(x.Sys_User.LoginID),
                        (x => x.CF_StudentProfile), (x => x.CF_StudentContact), (x => x.CF_StudentAccount),
                        (x => x.CF_Recruitstudents), (x => x.Sys_User)).ToList();

                //循环检测数据列,对各数据列进行验证（必填、字典项验证、数据格式等）
                for (int i = 0; i < enlist.Count; i++)
                {
                    StudentView en = enlist[i]; //Excel表数据视图
                    var newUser = new Sys_User();
                    var newStudent = new CF_Student();
                    var newStudentProfile = new CF_StudentProfile();
                    var newStudentContact = new CF_StudentContact();
                    var newStudentAccount = new CF_StudentAccount();
                    var newRecruitstudents = new CF_Recruitstudents();

                    //考生号
                    if (string.IsNullOrWhiteSpace(en.ExamineeNum))
                    {
                        errCount++;
                        errorMsgStr = "考生号不能为空";
                        en.ErrorMessage = errorMsgStr;
                        errList.Add(en);
                        errorMsg.AppendLine(errorMsgStr);
                        continue;
                    }
                    else
                    {
                        reg = new Regex(@"^[0-9a-zA-Z\s?]+$"); //正则表达式(请输入数字或英文字母)
                        if (!reg.IsMatch(en.ExamineeNum.Trim()))
                        {
                            errCount++;
                            errorMsgStr = "考生号格式不正确，请检查(数字或英文字母)";
                            en.ErrorMessage = errorMsgStr;
                            errList.Add(en);
                            errorMsg.AppendLine(errorMsgStr);
                            continue;
                        }
                        else
                        {
                            newRecruitstudents.ExamineeNum = en.ExamineeNum.Trim();
                        }
                    }
                    //准考证号
                    if (string.IsNullOrWhiteSpace(en.AdmissionTicketNo))
                    {
                        //暂不考虑
                    }
                    else
                    {
                        reg = new Regex(@"^[0-9a-zA-Z\s?]+$"); //正则表达式(请输入数字或英文字母)
                        if (!reg.IsMatch(en.AdmissionTicketNo.Trim()))
                        {
                            errCount++;
                            errorMsgStr = "准考证号格式不正确，请检查(数字或英文字母)";
                            en.ErrorMessage = errorMsgStr;
                            errList.Add(en);
                            errorMsg.AppendLine(errorMsgStr);
                            continue;
                        }
                        else
                        {
                            newRecruitstudents.AdmissionTicketNo = en.AdmissionTicketNo.Trim();
                        }
                    }
                    //学号
                    if (string.IsNullOrWhiteSpace(en.StudentNo))
                    {
                        errCount++;
                        errorMsgStr = "学号不能为空";
                        en.ErrorMessage = errorMsgStr;
                        errList.Add(en);
                        errorMsg.AppendLine(errorMsgStr);
                        continue;
                    }
                    else
                    {
                        reg = new Regex(@"^[0-9a-zA-Z\s?]+$"); //正则表达式(请输入数字或英文字母)
                        if (!reg.IsMatch(en.StudentNo.Trim()))
                        {
                            errCount++;
                            errorMsgStr = "学号格式不正确，请检查(数字或英文字母)";
                            en.ErrorMessage = errorMsgStr;
                            errList.Add(en);
                            errorMsg.AppendLine(errorMsgStr);
                            continue;
                        }
                        else
                        {
                            if (en.StudentNo.Trim().Length > Convert.ToInt32(studentNoTotal))
                            {
                                errCount++;
                                errorMsgStr = "学号总位数有误，学号总位数应小于等于" + studentNoTotal + "位。";
                                en.ErrorMessage = errorMsgStr;
                                errList.Add(en);
                                errorMsg.AppendLine(errorMsgStr);
                                continue;
                            }
                            else
                            {
                                newUser.LoginID = en.StudentNo.Trim();
                            }
                        }
                    }
                    //姓名
                    if (string.IsNullOrWhiteSpace(en.Name))
                    {
                        errCount++;
                        errorMsgStr = "姓名不能为空";
                        en.ErrorMessage = errorMsgStr;
                        errList.Add(en);
                        errorMsg.AppendLine(errorMsgStr);
                        continue;
                    }
                    else
                    {
                        newUser.Name = en.Name.Trim();
                    }
                    //曾用名
                    if (string.IsNullOrWhiteSpace(en.UsedName))
                    {
                        //暂不考虑
                    }
                    else
                    {
                        newStudentProfile.UsedName = en.UsedName.Trim();
                    }
                    //性别
                    if (string.IsNullOrWhiteSpace(en.SexStr))
                    {
                        errCount++;
                        errorMsgStr = "性别不能为空";
                        en.ErrorMessage = errorMsgStr;
                        errList.Add(en);
                        errorMsg.AppendLine(errorMsgStr);
                        continue;
                    }
                    else
                    {
                        var sex = sexList.Where(x => x.Name == en.SexStr.Trim()).SingleOrDefault();
                        if (sex == null)
                        {
                            errCount++;
                            errorMsgStr = "性别不存在，请检查";
                            en.ErrorMessage = errorMsgStr;
                            errList.Add(en);
                            errorMsg.AppendLine(errorMsgStr);
                            continue;
                        }
                        else
                        {
                            newStudent.SexID = sex.Value;
                        }
                    }
                    //出生日期
                    if (string.IsNullOrWhiteSpace(en.BirthDateStr))
                    {
                        errCount++;
                        errorMsgStr = "出生日期不能为空";
                        en.ErrorMessage = errorMsgStr;
                        errList.Add(en);
                        errorMsg.AppendLine(errorMsgStr);
                        continue;
                    }
                    else
                    {
                        //reg = new Regex(@"(\d{4})-(\d{1,2})-(\d{1,2})"); //日期正则表达式,2017-12-28
                        if (!DateTime.TryParse(en.BirthDateStr, out result))
                        {
                            errCount++;
                            errorMsgStr = "出生日期格式不正确，请检查";
                            en.ErrorMessage = errorMsgStr;
                            errList.Add(en);
                            errorMsg.AppendLine(errorMsgStr);
                            continue;
                        }
                        else
                        {
                            newStudent.BirthDate = Convert.ToDateTime(en.BirthDateStr);
                        }
                    }
                    //民族
                    if (string.IsNullOrWhiteSpace(en.NationStr))
                    {
                        errCount++;
                        errorMsgStr = "民族不能为空";
                        en.ErrorMessage = errorMsgStr;
                        errList.Add(en);
                        errorMsg.AppendLine(errorMsgStr);
                        continue;
                    }
                    else
                    {
                        var nation = nationList.Where(x => x.Name == en.NationStr.Trim()).SingleOrDefault();
                        if (nation == null)
                        {
                            errCount++;
                            errorMsgStr = "民族不存在，请检查";
                            en.ErrorMessage = errorMsgStr;
                            errList.Add(en);
                            errorMsg.AppendLine(errorMsgStr);
                            continue;
                        }
                        else
                        {
                            newStudent.NationID = nation.Value;
                        }
                    }
                    //政治面貌
                    if (string.IsNullOrWhiteSpace(en.PoliticsStr))
                    {
                        errCount++;
                        errorMsgStr = "政治面貌不能为空";
                        en.ErrorMessage = errorMsgStr;
                        errList.Add(en);
                        errorMsg.AppendLine(errorMsgStr);
                        continue;
                    }
                    else
                    {
                        var politics = politicsList.Where(x => x.Name == en.PoliticsStr.Trim()).SingleOrDefault();
                        if (politics == null)
                        {
                            errCount++;
                            errorMsgStr = "政治面貌不存在，请检查";
                            en.ErrorMessage = errorMsgStr;
                            errList.Add(en);
                            errorMsg.AppendLine(errorMsgStr);
                            continue;
                        }
                        else
                        {
                            newStudent.PoliticsID = politics.Value;
                        }
                    }
                    //学生类别
                    if (string.IsNullOrWhiteSpace(en.StudentTypeStr))
                    {
                        newStudent.StudentType = (int)CF_STUDENTTYPE.DefaultType;
                    }
                    else
                    {
                        var studentType = studentTypeList.Where(x => x.Name == en.StudentTypeStr.Trim()).SingleOrDefault();
                        if (studentType == null)
                        {
                            errCount++;
                            errorMsgStr = "学生类别不存在，请检查";
                            en.ErrorMessage = errorMsgStr;
                            errList.Add(en);
                            errorMsg.AppendLine(errorMsgStr);
                            continue;
                        }
                        else
                        {
                            newStudent.StudentType = studentType.Value;
                        }
                    }
                    //证件类型
                    if (string.IsNullOrWhiteSpace(en.CertificatesTypeStr))
                    {
                        //默认为身份证
                        newStudent.CertificatesType = (int)CF_CertificatesType.IdCrad;
                    }
                    else
                    {
                        var certificatesType = certificatesTypeList.Where(x => x.Name == en.CertificatesTypeStr.Trim()).SingleOrDefault();
                        if (certificatesType == null)
                        {
                            errCount++;
                            errorMsgStr = "证件类型不存在，请检查";
                            en.ErrorMessage = errorMsgStr;
                            errList.Add(en);
                            errorMsg.AppendLine(errorMsgStr);
                            continue;
                        }
                        else
                        {
                            newStudent.CertificatesType = certificatesType.Value;
                        }
                    }
                    //证件号码
                    if (string.IsNullOrWhiteSpace(en.IDNumber))
                    {
                        errCount++;
                        errorMsgStr = "证件号码不能为空";
                        en.ErrorMessage = errorMsgStr;
                        errList.Add(en);
                        errorMsg.AppendLine(errorMsgStr);
                        continue;
                    }
                    else
                    {
                        //reg = new Regex(@"^[0-9a-zA-Z\s?]+$"); //正则表达式(请输入数字或英文字母)
                        //if (!reg.IsMatch(en.IDNumber.Trim()))
                        //{
                        //    errCount++;
                        //    errorMsgStr = "证件号码格式不正确，请检查(数字或英文字母)";
                        //    en.ErrorMessage = errorMsgStr;
                        //    errList.Add(en);
                        //    errorMsg.AppendLine(errorMsgStr);
                        //    continue;
                        //}
                        //else
                        //{
                        //    newStudent.IDNumber = en.IDNumber.Trim();
                        //}

                        newStudent.IDNumber = en.IDNumber.Trim();
                    }
                    //在校状态
                    if (string.IsNullOrWhiteSpace(en.InSchoolStatusStr))
                    {
                        errCount++;
                        errorMsgStr = "在校状态不能为空";
                        en.ErrorMessage = errorMsgStr;
                        errList.Add(en);
                        errorMsg.AppendLine(errorMsgStr);
                        continue;
                    }
                    else
                    {
                        var inSchoolStatus = inschoolStatusList.Where(x => x.Name == en.InSchoolStatusStr.Trim()).SingleOrDefault();
                        if (inSchoolStatus == null)
                        {
                            errCount++;
                            errorMsgStr = "在校状态不存在，请检查";
                            en.ErrorMessage = errorMsgStr;
                            errList.Add(en);
                            errorMsg.AppendLine(errorMsgStr);
                            continue;
                        }
                        else
                        {
                            newStudent.InSchoolStatusID = inSchoolStatus.Value;
                        }
                    }
                    //学籍状态
                    if (string.IsNullOrWhiteSpace(en.StudentStatusStr))
                    {
                        errCount++;
                        errorMsgStr = "学籍状态不能为空";
                        en.ErrorMessage = errorMsgStr;
                        errList.Add(en);
                        errorMsg.AppendLine(errorMsgStr);
                        continue;
                    }
                    else
                    {
                        var studentStatus = studentStatusList.Where(x => x.Name == en.StudentStatusStr.Trim()).SingleOrDefault();
                        if (studentStatus == null)
                        {
                            errCount++;
                            errorMsgStr = "学籍状态不存在，请检查";
                            en.ErrorMessage = errorMsgStr;
                            errList.Add(en);
                            errorMsg.AppendLine(errorMsgStr);
                            continue;
                        }
                        else
                        {
                            newStudent.StudentStatus = studentStatus.Value;
                        }
                    }
                    //班级编号
                    if (string.IsNullOrWhiteSpace(en.ClassmajorNo))
                    {
                        errCount++;
                        errorMsgStr = "班级编号不能为空";
                        en.ErrorMessage = errorMsgStr;
                        errList.Add(en);
                        errorMsg.AppendLine(errorMsgStr);
                        continue;
                    }
                    else
                    {
                        var classmajor = newClassmajorList.Where(x => x.No == en.ClassmajorNo.Trim()).SingleOrDefault();
                        if (classmajor == null)
                        {
                            errCount++;
                            errorMsgStr = "班级编号不存在，请检查";
                            en.ErrorMessage = errorMsgStr;
                            errList.Add(en);
                            errorMsg.AppendLine(errorMsgStr);
                            continue;
                        }
                        else
                        {
                            //判断班级编号与班级名称（以班级编号为准）
                            if (string.IsNullOrWhiteSpace(en.ClassmajorName))
                            {
                                //暂不考虑
                            }
                            else
                            {
                                //班级编号与班级名称不对应
                                if (classmajor.Name.Trim() != en.ClassmajorName.Trim())
                                {
                                    errCount++;
                                    errorMsgStr = "班级编号与班级名称不对应(以班级编号为准)，请检查";
                                    en.ErrorMessage = errorMsgStr;
                                    errList.Add(en);
                                    errorMsg.AppendLine(errorMsgStr);
                                    continue;
                                }
                            }
                            newStudent.ClassmajorID = classmajor.ClassmajorID;
                            newStudent.PlanningGraduateDate = this.GetClassmajorPlanningGraduateDate(classmajor.ClassmajorID);
                            newStudent.GraduateDate = this.GetClassmajorGraduateDate(classmajor.ClassmajorID);
                        }
                    }
                    //班级名称
                    if (string.IsNullOrWhiteSpace(en.ClassmajorName))
                    {
                        //暂不考虑
                    }
                    else
                    {
                        //暂不考虑
                    }
                    //文化程度
                    if (string.IsNullOrWhiteSpace(en.LiteracyLevelStr))
                    {
                        //暂不考虑
                    }
                    else
                    {
                        var literacyLevel = literacyLevelList.Where(x => x.Name == en.LiteracyLevelStr.Trim()).SingleOrDefault();
                        if (literacyLevel == null)
                        {
                            errCount++;
                            errorMsgStr = "文化程度不存在，请检查";
                            en.ErrorMessage = errorMsgStr;
                            errList.Add(en);
                            errorMsg.AppendLine(errorMsgStr);
                            continue;
                        }
                        else
                        {
                            newStudentProfile.LiteracyLevelID = literacyLevel.Value;
                        }
                    }
                    //培养方式
                    if (string.IsNullOrWhiteSpace(en.CultureModelStr))
                    {
                        //暂不考虑
                    }
                    else
                    {
                        var cultureModel = cultureModelList.Where(x => x.Name == en.CultureModelStr.Trim()).SingleOrDefault();
                        if (cultureModel == null)
                        {
                            errCount++;
                            errorMsgStr = "培养方式不存在，请检查";
                            en.ErrorMessage = errorMsgStr;
                            errList.Add(en);
                            errorMsg.AppendLine(errorMsgStr);
                            continue;
                        }
                        else
                        {
                            newStudentProfile.CultureModelID = cultureModel.Value;
                        }
                    }
                    //考生类别
                    if (string.IsNullOrWhiteSpace(en.ExamineeTypeStr))
                    {
                        //暂不考虑
                    }
                    else
                    {
                        var examineeType = examineeTypeList.Where(x => x.Name == en.ExamineeTypeStr.Trim()).SingleOrDefault();
                        if (examineeType == null)
                        {
                            errCount++;
                            errorMsgStr = "考生类别不存在，请检查";
                            en.ErrorMessage = errorMsgStr;
                            errList.Add(en);
                            errorMsg.AppendLine(errorMsgStr);
                            continue;
                        }
                        else
                        {
                            newRecruitstudents.ExamineeType = examineeType.Value;
                        }
                    }
                    //入学日期
                    if (string.IsNullOrWhiteSpace(en.EntranceDateStr))
                    {
                        //暂不考虑
                    }
                    else
                    {
                        if (!DateTime.TryParse(en.EntranceDateStr, out result))
                        {
                            errCount++;
                            errorMsgStr = "入学日期格式不正确，请检查";
                            en.ErrorMessage = errorMsgStr;
                            errList.Add(en);
                            errorMsg.AppendLine(errorMsgStr);
                            continue;
                        }
                        else
                        {
                            newRecruitstudents.EntranceDate = Convert.ToDateTime(en.EntranceDateStr);
                        }
                    }
                    //总分
                    if (string.IsNullOrWhiteSpace(en.ScoreStr))
                    {
                        //暂不考虑
                    }
                    else
                    {
                        reg = new Regex(@"^[0-9]+([.]{1}[0-9]+){0,1}$"); //数字正则表达式
                        if (!reg.IsMatch(en.ScoreStr))
                        {
                            errCount++;
                            errorMsgStr = "总分格式不正确，请检查";
                            en.ErrorMessage = errorMsgStr;
                            errList.Add(en);
                            errorMsg.AppendLine(errorMsgStr);
                            continue;
                        }
                        else
                        {
                            newRecruitstudents.Score = Convert.ToDecimal(en.ScoreStr);
                        }
                    }
                    //入学方式
                    if (string.IsNullOrWhiteSpace(en.EntranceWayStr))
                    {
                        //暂不考虑
                    }
                    else
                    {
                        var entranceWay = entranceWayList.Where(x => x.Name == en.EntranceWayStr.Trim()).SingleOrDefault();
                        if (entranceWay == null)
                        {
                            errCount++;
                            errorMsgStr = "入学方式不存在，请检查";
                            en.ErrorMessage = errorMsgStr;
                            errList.Add(en);
                            errorMsg.AppendLine(errorMsgStr);
                            continue;
                        }
                        else
                        {
                            newRecruitstudents.EntranceWayID = entranceWay.Value;
                        }
                    }
                    //考生特征
                    if (string.IsNullOrWhiteSpace(en.FeaturesStr))
                    {
                        //暂不考虑
                    }
                    else
                    {
                        var features = featuresList.Where(x => x.Name == en.FeaturesStr.Trim()).SingleOrDefault();
                        if (features == null)
                        {
                            errCount++;
                            errorMsgStr = "考生特征不存在，请检查";
                            en.ErrorMessage = errorMsgStr;
                            errList.Add(en);
                            errorMsg.AppendLine(errorMsgStr);
                            continue;
                        }
                        else
                        {
                            newRecruitstudents.FeaturesID = features.Value;
                        }
                    }
                    //生源所属地
                    if (string.IsNullOrWhiteSpace(en.TerritorialStr))
                    {
                        //暂不考虑
                    }
                    else
                    {
                        var territorial = territorialList.Where(x => x.Name == en.TerritorialStr.Trim()).SingleOrDefault();
                        if (territorial == null)
                        {
                            errCount++;
                            errorMsgStr = "生源所属地不存在，请检查";
                            en.ErrorMessage = errorMsgStr;
                            errList.Add(en);
                            errorMsg.AppendLine(errorMsgStr);
                            continue;
                        }
                        else
                        {
                            newRecruitstudents.TerritorialID = territorial.Value;
                        }
                    }
                    //来源地区
                    if (string.IsNullOrWhiteSpace(en.Area))
                    {
                        //暂不考虑
                    }
                    else
                    {
                        newRecruitstudents.Area = en.Area.Trim();
                    }
                    //国籍
                    if (string.IsNullOrWhiteSpace(en.Country))
                    {
                        //暂不考虑
                    }
                    else
                    {
                        newStudentProfile.Country = en.Country.Trim();
                    }
                    //籍贯
                    if (string.IsNullOrWhiteSpace(en.Place))
                    {
                        //暂不考虑
                    }
                    else
                    {
                        newStudentProfile.Place = en.Place.Trim();
                    }
                    //出生地
                    if (string.IsNullOrWhiteSpace(en.BornPlace))
                    {
                        //暂不考虑
                    }
                    else
                    {
                        newStudentProfile.BornPlace = en.BornPlace.Trim();
                    }
                    //电子邮箱
                    if (string.IsNullOrWhiteSpace(en.Email))
                    {
                        //暂不考虑
                    }
                    else
                    {
                        reg = new Regex(@"^\w+([-+.]\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*$"); //正则表达式
                        if (!reg.IsMatch(en.Email.Trim()))
                        {
                            errCount++;
                            errorMsgStr = "电子邮箱格式不正确，请检查";
                            en.ErrorMessage = errorMsgStr;
                            errList.Add(en);
                            errorMsg.AppendLine(errorMsgStr);
                            continue;
                        }
                        else
                        {
                            newStudentContact.Email = en.Email.Trim();
                        }
                    }
                    //移动电话
                    if (string.IsNullOrWhiteSpace(en.Mobile))
                    {
                        //暂不考虑
                    }
                    else
                    {
                        newStudentContact.Mobile = en.Mobile.Trim();
                    }
                    //家庭电话
                    if (string.IsNullOrWhiteSpace(en.Telephone))
                    {
                        //暂不考虑
                    }
                    else
                    {
                        newStudentContact.Telephone = en.Telephone.Trim();
                    }
                    //邮政编码
                    if (string.IsNullOrWhiteSpace(en.ZIPCode))
                    {
                        //暂不考虑
                    }
                    else
                    {
                        reg = new Regex(@"[1-9]\d{5}(?!\d)"); //正则表达式
                        if (!reg.IsMatch(en.ZIPCode.Trim()))
                        {
                            errCount++;
                            errorMsgStr = "邮政编码格式不正确，请检查";
                            en.ErrorMessage = errorMsgStr;
                            errList.Add(en);
                            errorMsg.AppendLine(errorMsgStr);
                            continue;
                        }
                        else
                        {
                            newStudentContact.ZIPCode = en.ZIPCode.Trim();
                        }
                    }
                    //健康状况
                    if (string.IsNullOrWhiteSpace(en.HealthStateStr))
                    {
                        newStudentProfile.HealthStateID = (int)CF_HealthState.Healthy;
                    }
                    else
                    {
                        var healthState = healthStateList.Where(x => x.Name == en.HealthStateStr.Trim()).SingleOrDefault();
                        if (healthState == null)
                        {
                            errCount++;
                            errorMsgStr = "健康状况不存在，请检查";
                            en.ErrorMessage = errorMsgStr;
                            errList.Add(en);
                            errorMsg.AppendLine(errorMsgStr);
                            continue;
                        }
                        else
                        {
                            newStudentProfile.HealthStateID = healthState.Value;
                        }
                    }
                    //血型
                    if (string.IsNullOrWhiteSpace(en.BloodGroupStr))
                    {
                        //暂不考虑
                    }
                    else
                    {
                        var bloodGroup = bloodGroupList.Where(x => x.Name == en.BloodGroupStr.Trim()).SingleOrDefault();
                        if (bloodGroup == null)
                        {
                            errCount++;
                            errorMsgStr = "血型不存在，请检查";
                            en.ErrorMessage = errorMsgStr;
                            errList.Add(en);
                            errorMsg.AppendLine(errorMsgStr);
                            continue;
                        }
                        else
                        {
                            newStudentProfile.BloodGroup = bloodGroup.Value;
                        }
                    }
                    //特长
                    if (string.IsNullOrWhiteSpace(en.Specialty))
                    {
                        //暂不考虑
                    }
                    else
                    {
                        newStudentProfile.Specialty = en.Specialty.Trim();
                    }
                    //身高(cm)
                    if (string.IsNullOrWhiteSpace(en.Height))
                    {
                        //暂不考虑
                    }
                    else
                    {
                        reg = new Regex(@"^\d+(\.\d+)?$"); //正则表达式
                        if (!reg.IsMatch(en.Height.Trim()))
                        {
                            errCount++;
                            errorMsgStr = "身高(cm)格式不正确，请检查";
                            en.ErrorMessage = errorMsgStr;
                            errList.Add(en);
                            errorMsg.AppendLine(errorMsgStr);
                            continue;
                        }
                        else
                        {
                            newStudentProfile.Height = en.Height.Trim();
                        }
                    }
                    //体重(kg)
                    if (string.IsNullOrWhiteSpace(en.Weight))
                    {
                        //暂不考虑
                    }
                    else
                    {
                        reg = new Regex(@"^\d+(\.\d+)?$"); //正则表达式
                        if (!reg.IsMatch(en.Weight.Trim()))
                        {
                            errCount++;
                            errorMsgStr = "体重(cm)格式不正确，请检查";
                            en.ErrorMessage = errorMsgStr;
                            errList.Add(en);
                            errorMsg.AppendLine(errorMsgStr);
                            continue;
                        }
                        else
                        {
                            newStudentProfile.Weight = en.Weight.Trim();
                        }
                    }
                    //微信号
                    if (string.IsNullOrWhiteSpace(en.WeChatNum))
                    {
                        //暂不考虑
                    }
                    else
                    {
                        newStudentContact.WeChatNum = en.WeChatNum.Trim();
                    }
                    //QQ
                    if (string.IsNullOrWhiteSpace(en.QQ))
                    {
                        //暂不考虑
                    }
                    else
                    {
                        reg = new Regex(@"[1-9][0-9]{4,}"); //正则表达式
                        if (!reg.IsMatch(en.QQ.Trim()))
                        {
                            errCount++;
                            errorMsgStr = "QQ格式不正确，请检查";
                            en.ErrorMessage = errorMsgStr;
                            errList.Add(en);
                            errorMsg.AppendLine(errorMsgStr);
                            continue;
                        }
                        else
                        {
                            newStudentContact.QQ = en.QQ.Trim();
                        }
                    }
                    //家庭住址
                    if (string.IsNullOrWhiteSpace(en.HomeAddress))
                    {
                        //暂不考虑
                    }
                    else
                    {
                        newStudentContact.HomeAddress = en.HomeAddress.Trim();
                    }
                    //工作单位
                    if (string.IsNullOrWhiteSpace(en.WorkUnit))
                    {
                        //暂不考虑
                    }
                    else
                    {
                        newStudentContact.WorkUnit = en.WorkUnit.Trim();
                    }
                    //通信地址
                    if (string.IsNullOrWhiteSpace(en.Address))
                    {
                        //暂不考虑
                    }
                    else
                    {
                        newStudentContact.Address = en.Address.Trim();
                    }
                    //宿舍地址
                    if (string.IsNullOrWhiteSpace(en.Dormitory))
                    {
                        //暂不考虑
                    }
                    else
                    {
                        newStudentContact.Dormitory = en.Dormitory.Trim();
                    }
                    //收件人
                    if (string.IsNullOrWhiteSpace(en.Recipient))
                    {
                        //暂不考虑
                    }
                    else
                    {
                        newStudentContact.Recipient = en.Recipient.Trim();
                    }
                    //圆梦计划
                    if (string.IsNullOrWhiteSpace(en.IsDreamProjectStr))
                    {
                        newStudentProfile.IsDreamProject = false;
                    }
                    else
                    {
                        var isDreamProject = generalPurposeList.Where(x => x.Name == en.IsDreamProjectStr.Trim()).SingleOrDefault();
                        if (isDreamProject == null)
                        {
                            errCount++;
                            errorMsgStr = "是否圆梦计划不存在，请检查";
                            en.ErrorMessage = errorMsgStr;
                            errList.Add(en);
                            errorMsg.AppendLine(errorMsgStr);
                            continue;
                        }
                        else
                        {
                            newStudentProfile.IsDreamProject = isDreamProject.Value == (int)CF_GeneralPurpose.IsYes ? true : false;
                        }
                    }
                    //导师姓名
                    if (string.IsNullOrWhiteSpace(en.DirectorName))
                    {
                        //暂不考虑
                    }
                    else
                    {
                        newStudentProfile.DirectorName = en.DirectorName.Trim();
                    }
                    //开户银行
                    if (string.IsNullOrWhiteSpace(en.BankName))
                    {
                        //暂不考虑
                    }
                    else
                    {
                        newStudentAccount.BankName = en.BankName.Trim();
                    }
                    //银行卡号
                    if (string.IsNullOrWhiteSpace(en.CardNo))
                    {
                        //暂不考虑
                    }
                    else
                    {
                        reg = new Regex(@"^[0-9]*$"); //正则表达式
                        if (!reg.IsMatch(en.CardNo.Trim()))
                        {
                            errCount++;
                            errorMsgStr = "银行卡号格式不正确，请检查";
                            en.ErrorMessage = errorMsgStr;
                            errList.Add(en);
                            errorMsg.AppendLine(errorMsgStr);
                            continue;
                        }
                        else
                        {
                            newStudentAccount.CardNo = en.CardNo.Trim();
                        }
                    }
                    //学籍卡编号
                    if (string.IsNullOrWhiteSpace(en.StudentCardNo))
                    {
                        //暂不考虑
                    }
                    else
                    {
                        reg = new Regex(@"^[0-9a-zA-Z\s?]+$"); //正则表达式
                        if (!reg.IsMatch(en.StudentCardNo.Trim()))
                        {
                            errCount++;
                            errorMsgStr = "学籍卡编号格式不正确，请检查";
                            en.ErrorMessage = errorMsgStr;
                            errList.Add(en);
                            errorMsg.AppendLine(errorMsgStr);
                            continue;
                        }
                        else
                        {
                            newStudent.StudentCardNo = en.StudentCardNo.Trim();
                        }
                    }
                    //毕结业证书编号
                    if (string.IsNullOrWhiteSpace(en.GraduateCardNo))
                    {
                        //暂不考虑
                    }
                    else
                    {
                        reg = new Regex(@"^[0-9a-zA-Z\s?]+$"); //正则表达式
                        if (!reg.IsMatch(en.GraduateCardNo.Trim()))
                        {
                            errCount++;
                            errorMsgStr = "毕结业证书编号格式不正确，请检查";
                            en.ErrorMessage = errorMsgStr;
                            errList.Add(en);
                            errorMsg.AppendLine(errorMsgStr);
                            continue;
                        }
                        else
                        {
                            newStudent.GraduateCardNo = en.GraduateCardNo.Trim();
                        }
                    }
                    //学位有无
                    if (string.IsNullOrWhiteSpace(en.DegreeStatusStr))
                    {
                        newStudent.DegreeStatus = false;
                    }
                    else
                    {
                        var degreeStatus = generalExistList.Where(x => x.Name == en.DegreeStatusStr.Trim()).SingleOrDefault();
                        if (degreeStatus == null)
                        {
                            errCount++;
                            errorMsgStr = "学位有无不存在，请检查";
                            en.ErrorMessage = errorMsgStr;
                            errList.Add(en);
                            errorMsg.AppendLine(errorMsgStr);
                            continue;
                        }
                        else
                        {
                            newStudent.DegreeStatus = degreeStatus.Value == (int)CF_GeneralExist.Have ? true : false;
                        }
                    }
                    //在校经历
                    if (string.IsNullOrWhiteSpace(en.Career))
                    {
                        //暂不考虑
                    }
                    else
                    {
                        newStudent.Career = en.Career.Trim();
                    }
                    //备注
                    if (string.IsNullOrWhiteSpace(en.Remark))
                    {
                        //暂不考虑
                    }
                    else
                    {
                        newStudent.Remark = en.Remark.Trim();
                    }

                    ////Excel表重复性验证（注：当数据表中没有此记录，但是Excel中有重复数据时的去掉）
                    //for (int j = i + 1; j < enlist.Count; j++)
                    //{
                    //    StudentView enA = enlist[j];

                    //    //根据Excel表中的业务主键进行去重（学号或考生号唯一）
                    //    if (en.StudentNo == enA.StudentNo || en.ExamineeNum == enA.ExamineeNum)
                    //    {
                    //        //用于标识Excel表中的重复记录（由于是批量进行插入数据表）

                    //    }
                    //}

                    //数据表重复性验证（学号或考生号唯一）
                    var userVerify = newStudentList.Select(x => x.Sys_User).Where(x => x.LoginID == newUser.LoginID).SingleOrDefault();
                    if (userVerify == null)
                    {
                        var newNewStuVerify = newNewStuList.Where(x => x.ExamineeNum != newRecruitstudents.ExamineeNum
                                && x.StudentNo == newUser.LoginID).SingleOrDefault();
                        if (newNewStuVerify != null)
                        {
                            errCount++;
                            errorMsgStr = "学号重复(录取名单中学号重复)，请核查";
                            en.ErrorMessage = errorMsgStr;
                            errList.Add(en);
                            errorMsg.AppendLine(errorMsgStr);
                            continue;
                        }
                        if (!newRecruitstudentsUpList.Any(x => x.ExamineeNum == newRecruitstudents.ExamineeNum))
                        {
                            if (!newRecruitstudentsInList.Any(x => x.ExamineeNum == newRecruitstudents.ExamineeNum))
                            {
                                var newExamineeNumVerify = newExamineeNumList.Where(x => x.ExamineeNum == newRecruitstudents.ExamineeNum).SingleOrDefault();
                                if (newExamineeNumVerify != null)
                                {
                                    errCount++;
                                    errorMsgStr = "考生号重复，请核查";
                                    en.ErrorMessage = errorMsgStr;
                                    errList.Add(en);
                                    errorMsg.AppendLine(errorMsgStr);
                                    continue;
                                }
                            }
                            else
                            {
                                errCount++;
                                errorMsgStr = "考生号重复(Excel中)，请检查";
                                en.ErrorMessage = errorMsgStr;
                                errList.Add(en);
                                errorMsg.AppendLine(errorMsgStr);
                                continue;
                            }
                        }
                        else
                        {
                            errCount++;
                            errorMsgStr = "考生号重复(Excel中)，请检查";
                            en.ErrorMessage = errorMsgStr;
                            errList.Add(en);
                            errorMsg.AppendLine(errorMsgStr);
                            continue;
                        }
                        if (!string.IsNullOrEmpty(newStudent.StudentCardNo))
                        {
                            if (!newStudentUpList.Any(x => x.StudentCardNo == newStudent.StudentCardNo))
                            {
                                if (!newStudentInList.Any(x => x.StudentCardNo == newStudent.StudentCardNo))
                                {
                                    var newStudentCardNoVerify = newStudentCardNoList.Where(x => x.StudentCardNo == newStudent.StudentCardNo).SingleOrDefault();
                                    if (newStudentCardNoVerify != null)
                                    {
                                        errCount++;
                                        errorMsgStr = "学籍卡编号重复，请核查";
                                        en.ErrorMessage = errorMsgStr;
                                        errList.Add(en);
                                        errorMsg.AppendLine(errorMsgStr);
                                        continue;
                                    }
                                }
                                else
                                {
                                    errCount++;
                                    errorMsgStr = "学籍卡编号重复(Excel中)，请检查";
                                    en.ErrorMessage = errorMsgStr;
                                    errList.Add(en);
                                    errorMsg.AppendLine(errorMsgStr);
                                    continue;
                                }
                            }
                            else
                            {
                                errCount++;
                                errorMsgStr = "学籍卡编号重复(Excel中)，请检查";
                                en.ErrorMessage = errorMsgStr;
                                errList.Add(en);
                                errorMsg.AppendLine(errorMsgStr);
                                continue;
                            }
                        }
                        if (!string.IsNullOrEmpty(newStudent.GraduateCardNo))
                        {
                            if (!newStudentUpList.Any(x => x.GraduateCardNo == newStudent.GraduateCardNo))
                            {
                                if (!newStudentInList.Any(x => x.GraduateCardNo == newStudent.GraduateCardNo))
                                {
                                    var newGraduateCardNoVerify = newGraduateCardNoList.Where(x => x.GraduateCardNo == newStudent.GraduateCardNo).SingleOrDefault();
                                    if (newGraduateCardNoVerify != null)
                                    {
                                        errCount++;
                                        errorMsgStr = "毕结业证书编号重复，请核查";
                                        en.ErrorMessage = errorMsgStr;
                                        errList.Add(en);
                                        errorMsg.AppendLine(errorMsgStr);
                                        continue;
                                    }
                                }
                                else
                                {
                                    errCount++;
                                    errorMsgStr = "毕结业证书编号重复(Excel中)，请检查";
                                    en.ErrorMessage = errorMsgStr;
                                    errList.Add(en);
                                    errorMsg.AppendLine(errorMsgStr);
                                    continue;
                                }
                            }
                            else
                            {
                                errCount++;
                                errorMsgStr = "毕结业证书编号重复(Excel中)，请检查";
                                en.ErrorMessage = errorMsgStr;
                                errList.Add(en);
                                errorMsg.AppendLine(errorMsgStr);
                                continue;
                            }
                        }
                        //新增
                        if (!newUserInList.Any(x => x.LoginID == newUser.LoginID))
                        {
                            newUser.UserID = Guid.NewGuid();
                            if (passwordParameter == null)
                            {
                                newUser.Password = ("A" + newUser.LoginID.Trim()).MD5();
                            }
                            else
                            {
                                if (passwordParameter.Value != null)
                                {
                                    newUser.Password = passwordParameter.Value;
                                }
                                else
                                {
                                    newUser.Password = ("A" + newUser.LoginID.Trim()).MD5();
                                }
                            }
                            this.SetNewStatus(newUser, (int)SYS_STATUS.USABLE);
                            newUserInList.Add(newUser);
                            newUser.Sys_Role = new HashSet<Sys_Role>();
                            roleList = roleList.Where(x => x.CF_StudentRole.StudentType == newStudent.StudentType).ToList();
                            if (roleList != null && roleList.Count > 0)
                            {
                                roleList.ForEach(x => newUser.Sys_Role.Add(x));
                            }
                            else
                            {
                                //对应角色为空时，默认为不分配用户角色
                            }
                            newStudent.UserID = newUser.UserID;
                            newStudent.IsPhotoComparison = false;
                            newStudent.IsProofread = false;
                            this.SetNewStatus(newStudent);
                            newStudentInList.Add(newStudent);
                            newStudentProfile.UserID = newStudent.UserID;
                            this.SetNewStatus(newStudentProfile);
                            newStudentProfileInList.Add(newStudentProfile);
                            newStudentContact.UserID = newStudent.UserID;
                            this.SetNewStatus(newStudentContact);
                            newStudentContactInList.Add(newStudentContact);
                            newStudentAccount.UserID = newStudent.UserID;
                            this.SetNewStatus(newStudentAccount);
                            newStudentAccountInList.Add(newStudentAccount);
                            newRecruitstudents.UserID = newStudent.UserID;
                            this.SetNewStatus(newRecruitstudents);
                            newRecruitstudentsInList.Add(newRecruitstudents);
                            inCount++;
                        }
                        else
                        {
                            //Excel表重复性验证
                            //（注：当数据表中没有此记录，但是Excel中有重复数据,可在此处进行抛出到失败数据文件中）
                            errCount++;
                            errorMsgStr = "学号重复(Excel中)，请检查";
                            en.ErrorMessage = errorMsgStr;
                            errList.Add(en);
                            errorMsg.AppendLine(errorMsgStr);
                            continue;
                        }
                    }
                    else
                    {
                        //更新(判断Excel有重复时，以最后一条记录更新为准)
                        var studentVerify = newStudentList.Where(x => x.UserID == userVerify.UserID).SingleOrDefault();
                        if (studentVerify == null)
                        {
                            errCount++;
                            errorMsgStr = "学号冲突(与其它帐号冲突)，请检查";
                            en.ErrorMessage = errorMsgStr;
                            errList.Add(en);
                            errorMsg.AppendLine(errorMsgStr);
                            continue;
                        }
                        else
                        {
                            var newNewStuVerify = newNewStuList.Where(x => x.ExamineeNum != newRecruitstudents.ExamineeNum
                                && x.StudentNo == newUser.LoginID).SingleOrDefault();
                            if (newNewStuVerify != null)
                            {
                                errCount++;
                                errorMsgStr = "学号重复(录取名单中学号重复)，请核查";
                                en.ErrorMessage = errorMsgStr;
                                errList.Add(en);
                                errorMsg.AppendLine(errorMsgStr);
                                continue;
                            }
                            if (!newRecruitstudentsInList.Any(x => x.ExamineeNum == newRecruitstudents.ExamineeNum))
                            {
                                if (!newRecruitstudentsUpList.Any(x => x.ExamineeNum == newRecruitstudents.ExamineeNum))
                                {
                                    var newExamineeNumVerify = newExamineeNumList.Where(x => x.UserID != userVerify.UserID
                                            && x.ExamineeNum == newRecruitstudents.ExamineeNum).ToList();
                                    if (newExamineeNumVerify != null && newExamineeNumVerify.Count() > 0)
                                    {
                                        errCount++;
                                        errorMsgStr = "考生号已存在(与其它学生冲突)，请检查";
                                        en.ErrorMessage = errorMsgStr;
                                        errList.Add(en);
                                        errorMsg.AppendLine(errorMsgStr);
                                        continue;
                                    }
                                }
                                else
                                {
                                    errCount++;
                                    errorMsgStr = "考生号重复(Excel中)，请检查";
                                    en.ErrorMessage = errorMsgStr;
                                    errList.Add(en);
                                    errorMsg.AppendLine(errorMsgStr);
                                    continue;
                                }
                            }
                            else
                            {
                                errCount++;
                                errorMsgStr = "考生号重复(Excel中)，请检查";
                                en.ErrorMessage = errorMsgStr;
                                errList.Add(en);
                                errorMsg.AppendLine(errorMsgStr);
                                continue;
                            }
                            if (!string.IsNullOrEmpty(newStudent.StudentCardNo))
                            {
                                if (!newStudentInList.Any(x => x.StudentCardNo == newStudent.StudentCardNo))
                                {
                                    if (!newStudentUpList.Any(x => x.StudentCardNo == newStudent.StudentCardNo))
                                    {
                                        var newStudentCardNoVerify = newStudentCardNoList.Where(x => x.UserID != userVerify.UserID
                                                && x.StudentCardNo == newStudent.StudentCardNo).ToList();
                                        if (newStudentCardNoVerify != null && newStudentCardNoVerify.Count() > 0)
                                        {
                                            errCount++;
                                            errorMsgStr = "学籍卡编号已存在(与其它学生冲突)，请检查";
                                            en.ErrorMessage = errorMsgStr;
                                            errList.Add(en);
                                            errorMsg.AppendLine(errorMsgStr);
                                            continue;
                                        }
                                    }
                                    else
                                    {
                                        errCount++;
                                        errorMsgStr = "学籍卡编号重复(Excel中)，请检查";
                                        en.ErrorMessage = errorMsgStr;
                                        errList.Add(en);
                                        errorMsg.AppendLine(errorMsgStr);
                                        continue;
                                    }
                                }
                                else
                                {
                                    errCount++;
                                    errorMsgStr = "学籍卡编号重复(Excel中)，请检查";
                                    en.ErrorMessage = errorMsgStr;
                                    errList.Add(en);
                                    errorMsg.AppendLine(errorMsgStr);
                                    continue;
                                }
                            }
                            if (!string.IsNullOrEmpty(newStudent.GraduateCardNo))
                            {
                                if (!newStudentInList.Any(x => x.GraduateCardNo == newStudent.GraduateCardNo))
                                {
                                    if (!newStudentUpList.Any(x => x.GraduateCardNo == newStudent.GraduateCardNo))
                                    {
                                        var newGraduateCardNoVerify = newGraduateCardNoList.Where(x => x.UserID != userVerify.UserID
                                                && x.GraduateCardNo == newStudent.GraduateCardNo).ToList();
                                        if (newGraduateCardNoVerify != null && newGraduateCardNoVerify.Count() > 0)
                                        {
                                            errCount++;
                                            errorMsgStr = "毕结业证书编号已存在(与其它学生冲突)，请检查";
                                            en.ErrorMessage = errorMsgStr;
                                            errList.Add(en);
                                            errorMsg.AppendLine(errorMsgStr);
                                            continue;
                                        }
                                    }
                                    else
                                    {
                                        errCount++;
                                        errorMsgStr = "毕结业证书编号重复(Excel中)，请检查";
                                        en.ErrorMessage = errorMsgStr;
                                        errList.Add(en);
                                        errorMsg.AppendLine(errorMsgStr);
                                        continue;
                                    }
                                }
                                else
                                {
                                    errCount++;
                                    errorMsgStr = "毕结业证书编号重复(Excel中)，请检查";
                                    en.ErrorMessage = errorMsgStr;
                                    errList.Add(en);
                                    errorMsg.AppendLine(errorMsgStr);
                                    continue;
                                }
                            }
                            studentVerify.Sys_User.LoginID = newUser.LoginID.Trim();
                            studentVerify.Sys_User.Name = newUser.Name.Trim();
                            this.SetModifyStatus(studentVerify.Sys_User);
                            newUserUpList.Add(studentVerify.Sys_User);
                            studentVerify.SexID = newStudent.SexID;
                            studentVerify.BirthDate = newStudent.BirthDate;
                            studentVerify.NationID = newStudent.NationID;
                            studentVerify.PoliticsID = newStudent.PoliticsID;
                            studentVerify.CertificatesType = newStudent.CertificatesType;
                            studentVerify.IDNumber = newStudent.IDNumber;
                            studentVerify.StudentType = newStudent.StudentType;
                            studentVerify.Sys_User.Sys_Role = new HashSet<Sys_Role>();
                            roleList = roleList.Where(x => x.CF_StudentRole.StudentType == newStudent.StudentType).ToList();
                            if (roleList != null && roleList.Count > 0)
                            {
                                roleList.ForEach(x => studentVerify.Sys_User.Sys_Role.Add(x));
                            }
                            else
                            {
                                //对应角色为空时，默认为不分配用户角色
                            }
                            studentVerify.StudentCardNo = newStudent.StudentCardNo;
                            studentVerify.GraduateCardNo = newStudent.GraduateCardNo;
                            studentVerify.DegreeStatus = newStudent.DegreeStatus;
                            studentVerify.Career = newStudent.Career;
                            studentVerify.Remark = newStudent.Remark;
                            this.SetModifyStatus(studentVerify);
                            newStudentUpList.Add(studentVerify);
                            if (studentVerify.CF_StudentProfile == null)
                            {
                                var studentProfile = new CF_StudentProfile();
                                studentProfile.UserID = studentVerify.UserID;
                                studentProfile.UsedName = newStudentProfile.UsedName;
                                studentProfile.LiteracyLevelID = newStudentProfile.LiteracyLevelID;
                                studentProfile.CultureModelID = newStudentProfile.CultureModelID;
                                studentProfile.IsDreamProject = newStudentProfile.IsDreamProject;
                                studentProfile.Country = newStudentProfile.Country;
                                studentProfile.Place = newStudentProfile.Place;
                                studentProfile.BornPlace = newStudentProfile.BornPlace;
                                studentProfile.HealthStateID = newStudentProfile.HealthStateID;
                                studentProfile.BloodGroup = newStudentProfile.BloodGroup;
                                studentProfile.Specialty = newStudentProfile.Specialty;
                                studentProfile.Height = newStudentProfile.Height;
                                studentProfile.Weight = newStudentProfile.Weight;
                                studentProfile.DirectorName = newStudentProfile.DirectorName;
                                this.SetNewStatus(studentProfile);
                                newStudentProfileInList.Add(studentProfile);
                            }
                            else
                            {
                                studentVerify.CF_StudentProfile.UsedName = newStudentProfile.UsedName;
                                studentVerify.CF_StudentProfile.LiteracyLevelID = newStudentProfile.LiteracyLevelID;
                                studentVerify.CF_StudentProfile.CultureModelID = newStudentProfile.CultureModelID;
                                studentVerify.CF_StudentProfile.IsDreamProject = newStudentProfile.IsDreamProject;
                                studentVerify.CF_StudentProfile.Country = newStudentProfile.Country;
                                studentVerify.CF_StudentProfile.Place = newStudentProfile.Place;
                                studentVerify.CF_StudentProfile.BornPlace = newStudentProfile.BornPlace;
                                studentVerify.CF_StudentProfile.HealthStateID = newStudentProfile.HealthStateID;
                                studentVerify.CF_StudentProfile.BloodGroup = newStudentProfile.BloodGroup;
                                studentVerify.CF_StudentProfile.Specialty = newStudentProfile.Specialty;
                                studentVerify.CF_StudentProfile.Height = newStudentProfile.Height;
                                studentVerify.CF_StudentProfile.Weight = newStudentProfile.Weight;
                                studentVerify.CF_StudentProfile.DirectorName = newStudentProfile.DirectorName;
                                this.SetModifyStatus(studentVerify.CF_StudentProfile);
                                newStudentProfileUpList.Add(studentVerify.CF_StudentProfile);
                            }
                            if (studentVerify.CF_StudentContact == null)
                            {
                                var studentContact = new CF_StudentContact();
                                studentContact.UserID = studentVerify.UserID;
                                studentContact.Email = newStudentContact.Email;
                                studentContact.Telephone = newStudentContact.Email;
                                studentContact.Mobile = newStudentContact.Email;
                                studentContact.ZIPCode = newStudentContact.ZIPCode;
                                studentContact.WeChatNum = newStudentContact.WeChatNum;
                                studentContact.QQ = newStudentContact.QQ;
                                studentContact.HomeAddress = newStudentContact.HomeAddress;
                                studentContact.WorkUnit = newStudentContact.WorkUnit;
                                studentContact.Address = newStudentContact.Address;
                                studentContact.Recipient = newStudentContact.Recipient;
                                studentContact.Dormitory = newStudentContact.Dormitory;
                                this.SetNewStatus(studentContact);
                                newStudentContactInList.Add(studentContact);
                            }
                            else
                            {
                                studentVerify.CF_StudentContact.Email = newStudentContact.Email;
                                studentVerify.CF_StudentContact.Telephone = newStudentContact.Telephone;
                                studentVerify.CF_StudentContact.Mobile = newStudentContact.Mobile;
                                studentVerify.CF_StudentContact.ZIPCode = newStudentContact.ZIPCode;
                                studentVerify.CF_StudentContact.WeChatNum = newStudentContact.WeChatNum;
                                studentVerify.CF_StudentContact.QQ = newStudentContact.QQ;
                                studentVerify.CF_StudentContact.HomeAddress = newStudentContact.HomeAddress;
                                studentVerify.CF_StudentContact.WorkUnit = newStudentContact.WorkUnit;
                                studentVerify.CF_StudentContact.Address = newStudentContact.Address;
                                studentVerify.CF_StudentContact.Recipient = newStudentContact.Recipient;
                                studentVerify.CF_StudentContact.Dormitory = newStudentContact.Dormitory;
                                this.SetModifyStatus(studentVerify.CF_StudentContact);
                                newStudentContactUpList.Add(studentVerify.CF_StudentContact);
                            }
                            if (studentVerify.CF_StudentAccount == null)
                            {
                                var studentAccount = new CF_StudentAccount();
                                studentAccount.UserID = studentVerify.UserID;
                                studentAccount.BankName = newStudentAccount.BankName;
                                studentAccount.CardNo = newStudentAccount.CardNo;
                                this.SetNewStatus(studentAccount);
                                newStudentAccountInList.Add(studentAccount);
                            }
                            else
                            {
                                studentVerify.CF_StudentAccount.BankName = newStudentAccount.BankName;
                                studentVerify.CF_StudentAccount.CardNo = newStudentAccount.CardNo;
                                this.SetModifyStatus(studentVerify.CF_StudentAccount);
                                newStudentAccountUpList.Add(studentVerify.CF_StudentAccount);
                            }
                            if (studentVerify.CF_Recruitstudents == null)
                            {
                                var recruitstudents = new CF_Recruitstudents();
                                recruitstudents.UserID = studentVerify.UserID;
                                recruitstudents.ExamineeNum = newRecruitstudents.ExamineeNum;
                                recruitstudents.AdmissionTicketNo = newRecruitstudents.AdmissionTicketNo;
                                recruitstudents.ExamineeType = newRecruitstudents.ExamineeType;
                                recruitstudents.EntranceDate = newRecruitstudents.EntranceDate;
                                recruitstudents.Score = newRecruitstudents.Score;
                                recruitstudents.EntranceWayID = newRecruitstudents.EntranceWayID;
                                recruitstudents.FeaturesID = newRecruitstudents.FeaturesID;
                                recruitstudents.TerritorialID = newRecruitstudents.TerritorialID;
                                recruitstudents.Area = newRecruitstudents.Area;
                                this.SetNewStatus(recruitstudents);
                                newRecruitstudentsInList.Add(recruitstudents);
                            }
                            else
                            {
                                studentVerify.CF_Recruitstudents.ExamineeNum = newRecruitstudents.ExamineeNum;
                                studentVerify.CF_Recruitstudents.AdmissionTicketNo = newRecruitstudents.AdmissionTicketNo;
                                studentVerify.CF_Recruitstudents.ExamineeType = newRecruitstudents.ExamineeType;
                                studentVerify.CF_Recruitstudents.EntranceDate = newRecruitstudents.EntranceDate;
                                studentVerify.CF_Recruitstudents.Score = newRecruitstudents.Score;
                                studentVerify.CF_Recruitstudents.EntranceWayID = newRecruitstudents.EntranceWayID;
                                studentVerify.CF_Recruitstudents.FeaturesID = newRecruitstudents.FeaturesID;
                                studentVerify.CF_Recruitstudents.TerritorialID = newRecruitstudents.TerritorialID;
                                studentVerify.CF_Recruitstudents.Area = newRecruitstudents.Area;
                                this.SetModifyStatus(studentVerify.CF_Recruitstudents);
                                newRecruitstudentsUpList.Add(studentVerify.CF_Recruitstudents);
                            }
                            upCount++;
                        }
                    }
                }
                TransactionOptions transactionOption = new TransactionOptions();
                transactionOption.IsolationLevel = System.Transactions.IsolationLevel.Serializable;
                transactionOption.Timeout = new TimeSpan(0, 3, 0);
                using (TransactionScope ts = new TransactionScope(TransactionScopeOption.Required, transactionOption))
                {
                    UnitOfWork.BulkInsert<Sys_User>(newUserInList);
                    UnitOfWork.BulkInsert(newUserInList, (x => x.Sys_Role));
                    UnitOfWork.BulkInsert<CF_Student>(newStudentInList);
                    UnitOfWork.BulkInsert<CF_StudentProfile>(newStudentProfileInList);
                    UnitOfWork.BulkInsert<CF_StudentContact>(newStudentContactInList);
                    UnitOfWork.BulkInsert<CF_StudentAccount>(newStudentAccountInList);
                    UnitOfWork.BulkInsert<CF_Recruitstudents>(newRecruitstudentsInList);
                    if (newUserUpList != null && newUserUpList.Count() > 0)
                    {
                        UnitOfWork.BatchUpdate(newUserUpList);
                    }
                    if (newStudentUpList != null && newStudentUpList.Count() > 0)
                    {
                        UnitOfWork.BatchUpdate(newStudentUpList);
                    }
                    if (newStudentProfileUpList != null && newStudentProfileUpList.Count() > 0)
                    {
                        UnitOfWork.BatchUpdate(newStudentProfileUpList);
                    }
                    if (newStudentContactUpList != null && newStudentContactUpList.Count() > 0)
                    {
                        UnitOfWork.BatchUpdate(newStudentContactUpList);
                    }
                    if (newStudentAccountUpList != null && newStudentAccountUpList.Count() > 0)
                    {
                        UnitOfWork.BatchUpdate(newStudentAccountUpList);
                    }
                    if (newRecruitstudentsUpList != null && newRecruitstudentsUpList.Count() > 0)
                    {
                        UnitOfWork.BatchUpdate(newRecruitstudentsUpList);
                    }
                    ts.Complete();
                }
                errdataList = errList.Distinct().ToList(); //错误列表List
            }
            catch (Exception)
            {
                throw;
            }
        }

    }
}