using System;
using System.Collections.Generic;
using System.Linq;
using System.Linq.Expressions;
using System.Text;
using System.Text.RegularExpressions;
using System.Transactions;
using Bowin.Common.Utility;
using Bowin.Common.Linq;
using Bowin.Common.Linq.Entity;
using EMIS.Utility;
using EMIS.Entities;
using EMIS.ViewModel;
using EMIS.ViewModel.CacheManage;
using EMIS.ViewModel.EnrollManage.SpecialtyManage;
using EMIS.DataLogic.EnrollManage.SpecialtyManage;

namespace EMIS.CommonLogic.EnrollManage.SpecialtyManage
{
    public class RecruitSpecialtyServices : BaseServices, IRecruitSpecialtyServices
    {
        public RecruitSpecialtyDAL recruitSpecialtyDAL { get; set; }
        public Lazy<ISpecialtyApplyServices> SpecialtyApplyServices { get; set; }

        /// <summary>
        /// 查询对应的招生专业信息View
        /// </summary>
        /// <param name="configuretView"></param>
        /// <param name="campusID"></param>
        /// <param name="collegeID"></param>
        /// <param name="gradeID"></param>
        /// <param name="standardID"></param>
        /// <param name="educationID"></param>
        /// <param name="learningformID"></param>
        /// <param name="learnSystem"></param>
        /// <param name="isGenerated"></param>
        /// <param name="pageIndex"></param>
        /// <param name="pageSize"></param>
        /// <returns></returns>
        public IGridResultSet<RecruitSpecialtyView> GetRecruitSpecialtyViewGrid(ConfiguretView configuretView, Guid? campusID, Guid? collegeID, int? gradeID, int? standardID, 
                int? educationID, int? learningformID, string learnSystem, int? isGenerated, int pageIndex, int pageSize)
        {
            //招生专业
            Expression<Func<CF_RecruitSpecialty, bool>> expRecruitSpecialty = (x => x.RecordStatus > (int)SYS_STATUS.UNUSABLE);
            if (collegeID.HasValue)
            {
                expRecruitSpecialty = expRecruitSpecialty.And(x => x.CollegeID == collegeID);
            }
            if (gradeID.HasValue)
            {
                expRecruitSpecialty = expRecruitSpecialty.And(x => x.GradeID == gradeID);
            }
            if (isGenerated.HasValue)
            {
                //生成状态
                if (isGenerated.Value == (int)CF_GeneralPurpose.IsYes)
                {
                    expRecruitSpecialty = expRecruitSpecialty.And(x => x.isGenerated == true);
                }
                if (isGenerated.Value == (int)CF_GeneralPurpose.IsNo)
                {
                    expRecruitSpecialty = expRecruitSpecialty.And(x => x.isGenerated != true);
                }
            }

            var query = recruitSpecialtyDAL.GetRecruitSpecialtyViewQueryable(expRecruitSpecialty);

            if (campusID.HasValue)
            {
                query = query.Where(x => x.CampusID == campusID);
            }
            if (standardID.HasValue)
            {
                query = query.Where(x => x.StandardID == standardID);
            }
            if (educationID.HasValue)
            {
                query = query.Where(x => x.EducationID == educationID);
            }
            if (learningformID.HasValue)
            {
                query = query.Where(x => x.LearningformID == learningformID);
            }
            if (!string.IsNullOrEmpty(learnSystem) && learnSystem != "-1")
            {
                var LearnSystems = Convert.ToDecimal(learnSystem);
                query = query.Where(x => x.LearnSystem == LearnSystems);
            }
            //查询条件
            if (!string.IsNullOrEmpty(configuretView.ConditionValue))
            {
                query = query.DynamicWhere(configuretView.Attribute, configuretView.Condition, configuretView.ConditionValue.Trim());
            }

            return this.GetQueryByDataRangeByCollege(query).OrderBy(x => x.CollegeNo.Length).ThenBy(x => x.CollegeNo).ThenByDescending(x => x.GradeID)
                    .ThenBy(x => x.StandardName).ThenBy(x => x.EducationID).ThenBy(x => x.LearningformID).ThenBy(x => x.LearnSystem).ToGridResultSet<RecruitSpecialtyView>(pageIndex, pageSize);
        }

        /// <summary>
        /// 查询对应的招生专业信息List
        /// </summary>
        /// <param name="configuretView"></param>
        /// <param name="campusID"></param>
        /// <param name="collegeID"></param>
        /// <param name="gradeID"></param>
        /// <param name="standardID"></param>
        /// <param name="educationID"></param>
        /// <param name="learningformID"></param>
        /// <param name="learnSystem"></param>
        /// <param name="isGenerated"></param>
        /// <returns></returns>
        public IList<RecruitSpecialtyView> GetRecruitSpecialtyViewList(ConfiguretView configuretView, Guid? campusID, Guid? collegeID, int? gradeID, int? standardID, 
                int? educationID, int? learningformID, string learnSystem, int? isGenerated)
        {
            //招生专业
            Expression<Func<CF_RecruitSpecialty, bool>> expRecruitSpecialty = (x => x.RecordStatus > (int)SYS_STATUS.UNUSABLE);
            if (collegeID.HasValue)
            {
                expRecruitSpecialty = expRecruitSpecialty.And(x => x.CollegeID == collegeID);
            }
            if (gradeID.HasValue)
            {
                expRecruitSpecialty = expRecruitSpecialty.And(x => x.GradeID == gradeID);
            }
            if (isGenerated.HasValue)
            {
                //生成状态
                if (isGenerated.Value == (int)CF_GeneralPurpose.IsYes)
                {
                    expRecruitSpecialty = expRecruitSpecialty.And(x => x.isGenerated == true);
                }
                if (isGenerated.Value == (int)CF_GeneralPurpose.IsNo)
                {
                    expRecruitSpecialty = expRecruitSpecialty.And(x => x.isGenerated != true);
                }
            }

            var query = recruitSpecialtyDAL.GetRecruitSpecialtyViewQueryable(expRecruitSpecialty);

            if (campusID.HasValue)
            {
                query = query.Where(x => x.CampusID == campusID);
            }
            if (standardID.HasValue)
            {
                query = query.Where(x => x.StandardID == standardID);
            }
            if (educationID.HasValue)
            {
                query = query.Where(x => x.EducationID == educationID);
            }
            if (learningformID.HasValue)
            {
                query = query.Where(x => x.LearningformID == learningformID);
            }
            if (!string.IsNullOrEmpty(learnSystem) && learnSystem != "-1")
            {
                var LearnSystems = Convert.ToDecimal(learnSystem);
                query = query.Where(x => x.LearnSystem == LearnSystems);
            }
            //查询条件
            if (!string.IsNullOrEmpty(configuretView.ConditionValue))
            {
                query = query.DynamicWhere(configuretView.Attribute, configuretView.Condition, configuretView.ConditionValue.Trim());
            }

            return this.GetQueryByDataRangeByCollege(query).OrderBy(x => x.CollegeNo.Length).ThenBy(x => x.CollegeNo).ThenByDescending(x => x.GradeID)
                    .ThenBy(x => x.StandardName).ThenBy(x => x.EducationID).ThenBy(x => x.LearningformID).ThenBy(x => x.LearnSystem).ToList();
        }

        /// <summary>
        /// 查询对应的招生专业信息CF_RecruitSpecialty
        /// </summary>
        /// <param name="recruitSpecialtyID"></param>
        /// <returns></returns>
        public CF_RecruitSpecialty GetRecruitSpecialtyInfo(Guid? recruitSpecialtyID)
        {
            try
            {
                var query = recruitSpecialtyDAL.recruitSpecialtyRepository.GetList(x => x.RecruitSpecialtyID == recruitSpecialtyID).SingleOrDefault();

                return query;
            }
            catch (Exception ex)
            {
                throw new Exception(ex.Message);
            }
        }

        /// <summary>
        /// 查询对应的招生专业信息RecruitSpecialtyView
        /// </summary>
        /// <param name="recruitSpecialtyID"></param>
        /// <returns></returns>
        public RecruitSpecialtyView GetRecruitSpecialtyView(Guid? recruitSpecialtyID)
        {
            try
            {
                var query = recruitSpecialtyDAL.GetRecruitSpecialtyViewQueryable(x => x.RecruitSpecialtyID == recruitSpecialtyID).SingleOrDefault();

                return query;
            }
            catch (Exception ex)
            {
                throw new Exception(ex.Message);
            }
        }

        /// <summary>
        /// 招生专业批量新增（业务主键：专业信息ID、年级、学期、院系所）
        /// </summary>
        /// <param name="specialtyIDList"></param>
        /// <param name="recruitSpecialtyView"></param>
        /// <returns></returns>
        public string RecruitSpecialtyBatchAdd(List<Guid?> specialtyIDList, RecruitSpecialtyView recruitSpecialtyView)
        {
            try
            {
                var endStatusID = SpecialtyApplyServices.Value.GetCorrectEndStatus();
                if (endStatusID == null)
                {
                    throw new Exception("工作流平台中，招生专业流程结束环节未配置，请核查");
                }
                //招生专业
                Expression<Func<CF_RecruitSpecialty, bool>> expRecruitSpecialty = (x => x.RecordStatus > (int)SYS_STATUS.UNUSABLE);
                expRecruitSpecialty = expRecruitSpecialty.And(x => specialtyIDList.Contains(x.SpecialtyID));
                //查询对应的招生专业信息List
                var recruitSpecialtyList = recruitSpecialtyDAL.recruitSpecialtyRepository.GetList(expRecruitSpecialty).ToList();
                int success = 0;
                int fail = 0;
                string tipMessage = null;
                List<CF_RecruitSpecialty> recruitSpecialtyInList = new List<CF_RecruitSpecialty>();
                foreach (var specialtyID in specialtyIDList)
                {
                    var recruitSpecialtyVerify = recruitSpecialtyList.Where(x => x.SpecialtyID == specialtyID && x.CollegeID == recruitSpecialtyView.CollegeID
                            && x.GradeID == recruitSpecialtyView.GradeID && x.SemesterID == recruitSpecialtyView.SemesterID).SingleOrDefault();
                    if (recruitSpecialtyVerify == null)
                    {
                        //新增
                        var recruitSpecialty = new CF_RecruitSpecialty();
                        recruitSpecialty.RecruitSpecialtyID = Guid.NewGuid();
                        recruitSpecialty.SpecialtyApplyID = null;
                        recruitSpecialty.SpecialtyID = specialtyID;
                        recruitSpecialty.CollegeID = recruitSpecialtyView.CollegeID;
                        recruitSpecialty.GradeID = recruitSpecialtyView.GradeID;
                        recruitSpecialty.SemesterID = recruitSpecialtyView.SemesterID;
                        recruitSpecialty.ApprovalStatus = endStatusID;
                        recruitSpecialty.isGenerated = false;
                        recruitSpecialty.Remark = recruitSpecialtyView.Remark;
                        SetNewStatus(recruitSpecialty);
                        recruitSpecialtyInList.Add(recruitSpecialty);
                        success++;
                    }
                    else
                    {
                        //表示已存在相同的招生专业信息
                        fail++;
                    }
                }
                //批量插入
                UnitOfWork.BulkInsert<CF_RecruitSpecialty>(recruitSpecialtyInList);
                if (success > 0 && fail <= 0)
                {
                    tipMessage = success + "条";
                }
                else
                {
                    tipMessage = success + "条," + fail + "条失败，原因：已存在相同的招生专业信息，请检查";
                }

                return tipMessage;
            }
            catch (Exception ex)
            {
                throw new Exception(ex.Message);
            }
        }

        /// <summary>
        /// 查询招生专业中未新增的专业信息SpecialtyView
        /// </summary>
        /// <param name="configuretView"></param>
        /// <param name="collegeID"></param>
        /// <param name="gradeID"></param>
        /// <param name="semesterID"></param>
        /// <param name="standardID"></param>
        /// <param name="educationID"></param>
        /// <param name="learningformID"></param>
        /// <param name="learnSystem"></param>
        /// <param name="scienceclassID"></param>
        /// <param name="pageIndex"></param>
        /// <param name="pageSize"></param>
        /// <returns></returns>
        public IGridResultSet<SpecialtyView> GetSpecialtyViewNoAdd(ConfiguretView configuretView, Guid? collegeID, int? gradeID, int? semesterID, int? standardID, 
                int? educationID, int? learningformID, string learnSystem, int? scienceclassID, int pageIndex, int pageSize)
        {
            //专业信息(只查询启用状态的专业信息)
            Expression<Func<CF_Specialty, bool>> expSpecialty = (x => x.RecordStatus > (int)SYS_STATUS.UNUSABLE);
            if (standardID.HasValue)
            {
                expSpecialty = expSpecialty.And(x => x.StandardID == standardID);
            }
            if (educationID.HasValue)
            {
                expSpecialty = expSpecialty.And(x => x.EducationID == educationID);
            }
            if (learningformID.HasValue)
            {
                expSpecialty = expSpecialty.And(x => x.LearningformID == learningformID);
            }
            if (!string.IsNullOrEmpty(learnSystem) && learnSystem != "-1")
            {
                var LearnSystems = Convert.ToDecimal(learnSystem);
                expSpecialty = expSpecialty.And(x => x.LearnSystem == LearnSystems);
            }
            if (scienceclassID.HasValue)
            {
                expSpecialty = expSpecialty.And(x => x.ScienceclassID == scienceclassID);
            }
            //招生专业
            Expression<Func<CF_RecruitSpecialty, bool>> expRecruitSpecialty = (x => x.RecordStatus > (int)SYS_STATUS.UNUSABLE);
            if (collegeID.HasValue)
            {
                expRecruitSpecialty = expRecruitSpecialty.And(x => x.CollegeID == collegeID);
            }
            if (gradeID.HasValue)
            {
                expRecruitSpecialty = expRecruitSpecialty.And(x => x.GradeID == gradeID);
            }
            if (semesterID.HasValue)
            {
                expRecruitSpecialty = expRecruitSpecialty.And(x => x.SemesterID == semesterID);
            }

            var query = recruitSpecialtyDAL.GetSpecialtyViewNoAddQueryable(expSpecialty, expRecruitSpecialty);

            //查询条件
            if (!string.IsNullOrEmpty(configuretView.ConditionValue))
            {
                query = query.DynamicWhere(configuretView.Attribute, configuretView.Condition, configuretView.ConditionValue.Trim());
            }

            return query.OrderBy(x => x.StandardName).ThenBy(x => x.EducationID).ThenBy(x => x.LearningformID).ThenBy(x => x.LearnSystem).ToGridResultSet<SpecialtyView>(pageIndex, pageSize);
        }

        /// <summary>
        /// 编辑（新增、修改，业务主键：专业信息ID、院系所、年级、学期）
        /// </summary>
        /// <param name="recruitSpecialtyView"></param>
        public void RecruitSpecialtyEdit(RecruitSpecialtyView recruitSpecialtyView)
        {
            try
            {
                var endStatusID = SpecialtyApplyServices.Value.GetCorrectEndStatus();
                if (endStatusID == null)
                {
                    throw new Exception("工作流平台中，招生专业流程结束环节未配置，请核查");
                }
                //查询数据库进行验证
                var recruitSpecialtyVerification = recruitSpecialtyDAL.recruitSpecialtyRepository.GetList(x => x.RecruitSpecialtyID != recruitSpecialtyView.RecruitSpecialtyID
                        && x.SpecialtyID == recruitSpecialtyView.SpecialtyID && x.CollegeID == recruitSpecialtyView.CollegeID
                        && x.GradeID == recruitSpecialtyView.GradeID && x.SemesterID == recruitSpecialtyView.SemesterID).SingleOrDefault();
                if (recruitSpecialtyVerification == null)
                {
                    //数据有误验证
                    if (recruitSpecialtyView.RecruitSpecialtyID != Guid.Empty)
                    {
                        var recruitSpecialty = recruitSpecialtyDAL.recruitSpecialtyRepository.GetList(x => x.RecruitSpecialtyID == recruitSpecialtyView.RecruitSpecialtyID).SingleOrDefault();
                        if (recruitSpecialty == null)
                        {
                            throw new Exception("数据有误，请核查");
                        }
                        else
                        {
                            //表示修改
                            recruitSpecialty.Remark = recruitSpecialtyView.Remark;
                            SetModifyStatus(recruitSpecialty);
                        }
                    }
                    else
                    {
                        //表示新增
                        var recruitSpecialty = new CF_RecruitSpecialty();
                        recruitSpecialty.RecruitSpecialtyID = Guid.NewGuid();
                        recruitSpecialty.SpecialtyApplyID = null;
                        recruitSpecialty.SpecialtyID = recruitSpecialtyView.SpecialtyID;
                        recruitSpecialty.CollegeID = recruitSpecialtyView.CollegeID;
                        recruitSpecialty.GradeID = recruitSpecialtyView.GradeID;
                        recruitSpecialty.SemesterID = recruitSpecialtyView.SemesterID;
                        recruitSpecialty.ApprovalStatus = endStatusID;
                        recruitSpecialty.isGenerated = false;
                        recruitSpecialty.Remark = recruitSpecialtyView.Remark;
                        SetNewStatus(recruitSpecialty);
                        UnitOfWork.Add(recruitSpecialty);
                    }
                }
                else
                {
                    throw new Exception("已存在相同的招生专业信息（专业信息、" + RSL.Get("College") + "、年级、学期唯一），请核查");
                }
                //事务提交
                UnitOfWork.Commit();
            }
            catch (Exception ex)
            {
                throw new Exception(ex.Message);
            }
        }

        /// <summary>
        /// 专业班级生成(由于各高校生成规则不同，需分版本—个性化配置)
        /// </summary>
        /// <param name="recruitSpecialtyIDs"></param>
        /// <returns></returns>
        public virtual string GenerateClass(List<Guid?> recruitSpecialtyIDs)
        {
            //根据各高校个性化要求进行配置
            throw new Exception("生成规则配置有误（根据个性化要求进行配置），请检查");
        }

        /// <summary>
        /// 删除（需根据业务主键删除对应的流程结束专业申请信息）
        /// </summary>
        /// <param name="recruitSpecialtyIDList"></param>
        /// <returns></returns>
        public bool RecruitSpecialtyDelete(List<Guid?> recruitSpecialtyIDList)
        {
            try
            {
                //查询招生专业工作流程线束环节状态
                var endStatusID = SpecialtyApplyServices.Value.GetCorrectEndStatus();
                if (endStatusID == null)
                {
                    throw new Exception("工作流平台中，招生专业流程结束环节未配置，请核查");
                }
                //查询对应的招生专业信息List
                var recruitSpecialtyList = this.recruitSpecialtyDAL.recruitSpecialtyRepository.GetList(x => recruitSpecialtyIDList.Contains(x.RecruitSpecialtyID)).ToList();
                //招生专业中对应的专业信息IDList
                var specialtyIDList = recruitSpecialtyList.Select(x => x.SpecialtyID).ToList();
                //查询对应的专业申请信息List
                var specialtyApplyList = recruitSpecialtyDAL.specialtyApplyRepository.GetList(x => specialtyIDList.Contains(x.SpecialtyID)).ToList();
                //查询专业申请信息List(流程结束)
                List<Guid> specialtyApplyIDList = new List<Guid>();
                foreach (var recruitSpecialty in recruitSpecialtyList)
                {
                    //查询专业申请信息
                    var specialtyApply = specialtyApplyList.Where(x => x.SpecialtyID == recruitSpecialty.SpecialtyID && x.CollegeID == recruitSpecialty.CollegeID 
                            && x.GradeID == recruitSpecialty.GradeID && x.SemesterID == recruitSpecialty.SemesterID && x.ApprovalStatus == endStatusID).SingleOrDefault();
                    if (specialtyApply != null)
                    {
                        specialtyApplyIDList.Add(specialtyApply.SpecialtyApplyID);
                    }
                }
                using (TransactionScope ts = new TransactionScope())
                {
                    if (recruitSpecialtyIDList != null && recruitSpecialtyIDList.Count() > 0)
                    {
                        UnitOfWork.Delete<CF_RecruitSpecialty>(x => recruitSpecialtyIDList.Contains(x.RecruitSpecialtyID));
                    }
                    if (specialtyApplyIDList != null && specialtyApplyIDList.Count() > 0)
                    {
                        UnitOfWork.Delete<CF_SpecialtyApply>(x => specialtyApplyIDList.Contains(x.SpecialtyApplyID));
                    }
                    ts.Complete();
                }
                return true;
            }
            catch (Exception)
            {
                throw;
            }
        }

        /// <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 void RecruitSpecialtyImport(Dictionary<string, string> cellheader, out int? inCount, out int? upCount, out List<RecruitSpecialtyView> errdataList, out int? errCount, string sourcePhysicalPath)
        {
            try
            {
                //查询招生专业工作流程结束环节状态
                var endStatusID = SpecialtyApplyServices.Value.GetCorrectEndStatus();
                if (endStatusID == null)
                {
                    throw new Exception("工作流平台中，招生专业流程结束环节未配置，请核查");
                }
                StringBuilder errorMsg = new StringBuilder(); // 错误信息
                List<RecruitSpecialtyView> errList = new List<RecruitSpecialtyView>();
                // 1.1解析文件，存放到一个List集合里
                cellheader.Remove("ErrorMessage");//移除“未导入原因”列(ErrorMessage)
                List<RecruitSpecialtyView> enlist = NpoiExcelHelper.ExcelToEntityList<RecruitSpecialtyView>(cellheader, sourcePhysicalPath, out errorMsg, out errList);
                cellheader.Add("ErrorMessage", "未导入原因");
                //对List集合进行有效性校验
                if (enlist.Count() <= 0)
                {
                    throw new Exception("Excel文件数据为空，请检查。");
                }
                Regex reg = new Regex(@"^[0-9]+([.]{1}[0-9]+){0,1}$"); //学制字段正则表达式()
                inCount = 0; //导入个数
                upCount = 0; //更新个数
                errCount = 0; //失败个数
                string errorMsgStr = ""; //错误信息
                List<CF_RecruitSpecialty> recruitSpecialtyInList = new List<CF_RecruitSpecialty>();
                List<CF_RecruitSpecialty> recruitSpecialtyUpList = new List<CF_RecruitSpecialty>();
                //将循环中相关数据库查询统一查询出来进行匹配(尽量避免在循环中进行数据库查询)
                //专业代码、专业名称、专业ID(Value)
                var standardList = IdNameExt.GetDictionaryItem(DictionaryItem.CF_Standard).ToList();
                //培养层次(所修学历)
                var educationList = IdNameExt.GetDictionaryItem(DictionaryItem.CF_Education).ToList();
                //学习形式
                var learningFormList = IdNameExt.GetDictionaryItem(DictionaryItem.CF_Learningform).ToList();
                //院系所代码
                var collegeNoList = enlist.Where(x => !string.IsNullOrEmpty(x.CollegeNo)).Select(x => x.CollegeNo).ToList();
                //对应的院系所信息
                var collegeList = recruitSpecialtyDAL.collegeRepository.GetList(x => collegeNoList.Contains(x.No), x => x.CF_CollegeProfile).ToList();
                //GradeStr
                var gradeStrList = enlist.Where(x => !string.IsNullOrEmpty(x.GradeStr)).Select(x => x.GradeStr).ToList();
                //年级
                var gradeList = IdNameExt.GetDictionaryItem(DictionaryItem.CF_Grade).ToList();
                //学期
                var semesterList = IdNameExt.GetDictionaryItem(DictionaryItem.CF_Semester).ToList();
                //专业信息
                var specialtyList = recruitSpecialtyDAL.specialtyRepository.GetList(x => true).ToList();
                //招生专业
                var recruitSpecialtyList = recruitSpecialtyDAL.recruitSpecialtyRepository.GetList(x => gradeStrList.Contains(x.GradeID.ToString())).ToList();
                //循环检测数据列,对各数据列进行验证（必填、字典项验证、数据格式等）
                for (int i = 0; i < enlist.Count; i++)
                {
                    RecruitSpecialtyView en = enlist[i]; //Excel表数据视图
                    var recruitSpecialty = new CF_RecruitSpecialty(); //招生专业实体
                    //专业代码
                    if (string.IsNullOrEmpty(en.StandardCode))
                    {
                        errCount++;
                        errorMsgStr = "专业代码不能为空";
                        en.ErrorMessage = errorMsgStr;
                        errList.Add(en);
                        errorMsg.AppendLine(errorMsgStr);
                        continue;
                    }
                    else
                    {
                        var standardCode = standardList.Where(x => x.Code == en.StandardCode.Trim()).FirstOrDefault();
                        if (standardCode == null)
                        {
                            errCount++;
                            errorMsgStr = "专业代码不存在，请检查";
                            en.ErrorMessage = errorMsgStr;
                            errList.Add(en);
                            errorMsg.AppendLine(errorMsgStr);
                            continue;
                        }
                        else
                        {
                            //专业代码

                        }
                    }
                    //专业名称
                    if (string.IsNullOrEmpty(en.StandardName))
                    {
                        errCount++;
                        errorMsgStr = "专业名称不能为空";
                        en.ErrorMessage = errorMsgStr;
                        errList.Add(en);
                        errorMsg.AppendLine(errorMsgStr);
                        continue;
                    }
                    else
                    {
                        var standardName = standardList.Where(x => x.Name == en.StandardName.Trim()).FirstOrDefault();
                        if (standardName == null)
                        {
                            errCount++;
                            errorMsgStr = "专业名称不存在，请检查";
                            en.ErrorMessage = errorMsgStr;
                            errList.Add(en);
                            errorMsg.AppendLine(errorMsgStr);
                            continue;
                        }
                        else
                        {
                            //专业名称

                        }
                    }
                    //专业代码与专业名称查询专业ID(Value)
                    if (string.IsNullOrEmpty(en.StandardCode) || string.IsNullOrEmpty(en.StandardName))
                    {
                        errCount++;
                        errorMsgStr = "专业代码或专业名称不能为空";
                        en.ErrorMessage = errorMsgStr;
                        errList.Add(en);
                        errorMsg.AppendLine(errorMsgStr);
                        continue;
                    }
                    else
                    {
                        var standardID = standardList.Where(x => x.Code == en.StandardCode.Trim() && x.Name == en.StandardName.Trim()).SingleOrDefault();
                        if (standardID == null)
                        {
                            errCount++;
                            errorMsgStr = "专业代码与专业名称对应的元素值不存在，请检查";
                            en.ErrorMessage = errorMsgStr;
                            errList.Add(en);
                            errorMsg.AppendLine(errorMsgStr);
                            continue;
                        }
                        else
                        {
                            //专业ID(Value)
                            en.StandardID = standardID.Value;
                        }
                    }
                    //培养层次(所修学历)
                    if (string.IsNullOrEmpty(en.EducationStr))
                    {
                        errCount++;
                        errorMsgStr = RSL.Get("EducationID") + "不能为空";
                        en.ErrorMessage = errorMsgStr;
                        errList.Add(en);
                        errorMsg.AppendLine(errorMsgStr);
                        continue;
                    }
                    else
                    {
                        var education = educationList.Where(x => x.Name == en.EducationStr.Trim()).SingleOrDefault();
                        if (education == null)
                        {
                            errCount++;
                            errorMsgStr = RSL.Get("EducationID") + "不存在，请检查";
                            en.ErrorMessage = errorMsgStr;
                            errList.Add(en);
                            errorMsg.AppendLine(errorMsgStr);
                            continue;
                        }
                        else
                        {
                            //培养层次
                            en.EducationID = education.Value;
                        }
                    }
                    //学习形式
                    if (string.IsNullOrEmpty(en.LearningformStr))
                    {
                        errCount++;
                        errorMsgStr = "学习形式不能为空";
                        en.ErrorMessage = errorMsgStr;
                        errList.Add(en);
                        errorMsg.AppendLine(errorMsgStr);
                        continue;
                    }
                    else
                    {
                        var learningForm = learningFormList.Where(x => x.Name == en.LearningformStr.Trim()).SingleOrDefault();
                        if (learningForm == null)
                        {
                            errCount++;
                            errorMsgStr = "学习形式不存在，请检查";
                            en.ErrorMessage = errorMsgStr;
                            errList.Add(en);
                            errorMsg.AppendLine(errorMsgStr);
                            continue;
                        }
                        else
                        {
                            //学习形式
                            en.LearningformID = learningForm.Value;
                        }
                    }
                    //学制
                    if (string.IsNullOrEmpty(en.LearnSystemStr))
                    {
                        errCount++;
                        errorMsgStr = "学制不能为空";
                        en.ErrorMessage = errorMsgStr;
                        errList.Add(en);
                        errorMsg.AppendLine(errorMsgStr);
                        continue;
                    }
                    else
                    {
                        if (!reg.IsMatch(en.LearnSystemStr))
                        {
                            errCount++;
                            errorMsgStr = "学制格式不正确，请检查";
                            en.ErrorMessage = errorMsgStr;
                            errList.Add(en);
                            errorMsg.AppendLine(errorMsgStr);
                            continue;
                        }
                        else
                        {
                            //学制
                            en.LearnSystem = Convert.ToDecimal(en.LearnSystemStr);
                        }
                    }
                    //专业信息查询
                    var specialty = specialtyList.Where(x => x.StandardID == en.StandardID && x.EducationID == en.EducationID && x.LearningformID == en.LearningformID && x.LearnSystem == en.LearnSystem).SingleOrDefault();
                    //专业信息ID
                    if (specialty == null)
                    {
                        errCount++;
                        errorMsgStr = "专业信息不存在，请检查";
                        en.ErrorMessage = errorMsgStr;
                        errList.Add(en);
                        errorMsg.AppendLine(errorMsgStr);
                        continue;
                    }
                    else
                    {
                        //查询专业信息(启用、禁用状态)
                        if (specialty.RecordStatus > (int)SYS_STATUS.UNUSABLE)
                        {
                            recruitSpecialty.SpecialtyID = specialty.SpecialtyID;
                        }
                        else
                        {
                            recruitSpecialty.SpecialtyID = specialty.SpecialtyID;
                            errCount++;
                            errorMsgStr = "专业信息为禁用状态，请检查";
                            en.ErrorMessage = errorMsgStr;
                            errList.Add(en);
                            errorMsg.AppendLine(errorMsgStr);
                            continue;
                        }
                    }
                    //院系所代码
                    if (string.IsNullOrEmpty(en.CollegeNo))
                    {
                        errCount++;
                        errorMsgStr = RSL.Get("CollegeCode") + "不能为空";
                        en.ErrorMessage = errorMsgStr;
                        errList.Add(en);
                        errorMsg.AppendLine(errorMsgStr);
                        continue;
                    }
                    else
                    {
                        var college = collegeList.Where(x => x.No == en.CollegeNo.Trim()).SingleOrDefault();
                        if (college == null)
                        {
                            errCount++;
                            errorMsgStr = RSL.Get("CollegeCode") + "不存在，请检查";
                            en.ErrorMessage = errorMsgStr;
                            errList.Add(en);
                            errorMsg.AppendLine(errorMsgStr);
                            continue;
                        }
                        else
                        {
                            if (college.CF_CollegeProfile == null)
                            {
                                errCount++;
                                errorMsgStr = RSL.Get("CollegeCode") + "所属的单位类别有误，请检查";
                                en.ErrorMessage = errorMsgStr;
                                errList.Add(en);
                                errorMsg.AppendLine(errorMsgStr);
                                continue;
                            }
                            else if (college.CF_CollegeProfile.UnitCategoryID != (int)CF_UnitCategory.College)
                            {
                                errCount++;
                                errorMsgStr = RSL.Get("CollegeCode") + "所属的单位类别有误，请检查";
                                en.ErrorMessage = errorMsgStr;
                                errList.Add(en);
                                errorMsg.AppendLine(errorMsgStr);
                                continue;
                            }
                            //院系所ID
                            recruitSpecialty.CollegeID = college.CollegeID;
                        }
                    }
                    //年级
                    if (string.IsNullOrEmpty(en.GradeStr))
                    {
                        errCount++;
                        errorMsgStr = "年级不能为空";
                        en.ErrorMessage = errorMsgStr;
                        errList.Add(en);
                        errorMsg.AppendLine(errorMsgStr);
                        continue;
                    }
                    else
                    {
                        var grade = gradeList.Where(x => x.Name == en.GradeStr.Trim()).SingleOrDefault();
                        if (grade == null)
                        {
                            errCount++;
                            errorMsgStr = "年级不存在，请检查";
                            en.ErrorMessage = errorMsgStr;
                            errList.Add(en);
                            errorMsg.AppendLine(errorMsgStr);
                            continue;
                        }
                        else
                        {
                            //年级
                            recruitSpecialty.GradeID = grade.Value;
                        }
                    }
                    //学期
                    if (string.IsNullOrEmpty(en.SemesterStr))
                    {
                        errCount++;
                        errorMsgStr = "学期不能为空";
                        en.ErrorMessage = errorMsgStr;
                        errList.Add(en);
                        errorMsg.AppendLine(errorMsgStr);
                        continue;
                    }
                    else
                    {
                        var semester = semesterList.Where(x => x.Name == en.SemesterStr.Trim()).SingleOrDefault();
                        if (semester == null)
                        {
                            errCount++;
                            errorMsgStr = "学期不存在，请检查";
                            en.ErrorMessage = errorMsgStr;
                            errList.Add(en);
                            errorMsg.AppendLine(errorMsgStr);
                            continue;
                        }
                        else
                        {
                            //学期
                            recruitSpecialty.SemesterID = semester.Value;
                        }
                    }
                    //备注
                    recruitSpecialty.Remark = en.Remark;

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

                    //    //根据Excel表中的业务主键进行去重（专业代码、专业名称、学制、培养层次(所修学历)、学习形式、年级、学期、院系所代码唯一）
                    //    if (en.StandardCode == enA.StandardCode && en.StandardName == enA.StandardName
                    //        && en.LearnSystemStr == enA.LearnSystemStr
                    //        && en.EducationStr == enA.EducationStr
                    //        && en.LearningformStr == enA.LearningformStr
                    //        && en.GradeStr == enA.GradeStr
                    //        && en.SemesterStr == enA.SemesterStr
                    //        && en.CollegeNo == enA.CollegeNo)
                    //    {
                    //        //用于标识Excel表中的重复记录（由于是批量进行插入数据表）

                    //    }
                    //}

                    //由于招生专业表与专业申请表不同，招生专业新增时，需进行处理（目前采用方法一进行处理）
                    //处理方法一：目前已在工作流审核处理通过时，进行了相关处理（采用更新的方式）
                    //处理方法二：可在此处进行判断处理，以Excel错误数据方式进行抛出，提示信息：数据重复，工作流程中已存在此数据

                    //数据表重复性验证(专业信息ID、年级、学期、院系所ID唯一)
                    var recruitSpecialtyVerify = recruitSpecialtyList.Where(x => x.GradeID == recruitSpecialty.GradeID && x.SemesterID == recruitSpecialty.SemesterID 
                            && x.SpecialtyID == recruitSpecialty.SpecialtyID && x.CollegeID == recruitSpecialty.CollegeID).SingleOrDefault();
                    if (recruitSpecialtyVerify == null)
                    {
                        //新增
                        if (!recruitSpecialtyInList.Any(x => x.GradeID == recruitSpecialty.GradeID && x.SemesterID == recruitSpecialty.SemesterID 
                                && x.SpecialtyID == recruitSpecialty.SpecialtyID && x.CollegeID == recruitSpecialty.CollegeID))
                        {
                            recruitSpecialty.RecruitSpecialtyID = Guid.NewGuid();
                            recruitSpecialty.SpecialtyApplyID = null;
                            recruitSpecialty.ApprovalStatus = endStatusID;
                            recruitSpecialty.isGenerated = false;
                            SetNewStatus(recruitSpecialty);
                            recruitSpecialtyInList.Add(recruitSpecialty);
                            inCount++;
                        }
                        else
                        {
                            //Excel表重复性验证
                            //（注：当数据表中没有此记录，但是Excel中有重复数据,可在此处进行抛出到失败数据文件中,目前暂不考虑）

                            inCount++;
                        }
                    }
                    else
                    {
                        //更新(Excel有重复时，以最后一条记录的更新为准)
                        recruitSpecialtyVerify.Remark = recruitSpecialty.Remark;
                        SetModifyStatus(recruitSpecialtyVerify);
                        recruitSpecialtyUpList.Add(recruitSpecialtyVerify);
                        upCount++;
                    }
                }
                using (TransactionScope ts = new TransactionScope())
                {
                    if (recruitSpecialtyInList != null && recruitSpecialtyInList.Count() > 0)
                    {
                        UnitOfWork.BulkInsert(recruitSpecialtyInList);
                    }
                    if (recruitSpecialtyUpList != null && recruitSpecialtyUpList.Count() > 0)
                    {
                        UnitOfWork.BatchUpdate(recruitSpecialtyUpList);
                    }
                    ts.Complete();
                }
                errdataList = errList.Distinct().ToList();
            }
            catch (Exception)
            {
                throw;
            }
        }

    }
}