JW/ServiceLogic/EMIS.CommonLogic/CultureplanManage/PlanManagement/SpecialtyCourseServices.cs

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

namespace EMIS.CommonLogic.CultureplanManage.PlanManagement
{
    public class SpecialtyCourseServices : BaseServices, ISpecialtyCourseServices
    {
        public SpecialtyCourseDAL SpecialtyCourseDAL { get; set; }

        /// <summary>
        /// 查询专业课程信息SpecialtyCourseView
        /// </summary>
        /// <param name="configuretView"></param>
        /// <param name="collegeID"></param>
        /// <param name="departmentID"></param>
        /// <param name="standardID"></param>
        /// <param name="educationID"></param>
        /// <param name="learningformID"></param>
        /// <param name="learnSystem"></param>
        /// <param name="coursematerialID"></param>
        /// <param name="courseTypeID"></param>
        /// <param name="starttermID"></param>
        /// <param name="teachingModeID"></param>
        /// <param name="handleModeID"></param>
        /// <param name="isEnable"></param>
        /// <param name="pageIndex"></param>
        /// <param name="pageSize"></param>
        /// <returns></returns>
        public IGridResultSet<SpecialtyCourseView> GetSpecialtyCourseViewGrid(ConfiguretView configuretView, Guid? collegeID, Guid? departmentID,
                int? standardID, int? educationID, int? learningformID, string learnSystem, Guid? coursematerialID, int? courseTypeID,
                int? starttermID, int? teachingModeID, int? handleModeID, int? isEnable, int pageIndex, int pageSize)
        {
            //专业课程
            Expression<Func<EM_SpecialtyCourse, bool>> exp = (x => x.RecordStatus > (int)SYS_STATUS.UNUSABLE);
            if (departmentID.HasValue)
            {
                //开课教研室ID
                exp = exp.And(x => x.DepartmentID == departmentID);
            }
            if (coursematerialID.HasValue)
            {
                //课程信息ID
                exp = exp.And(x => x.CoursematerialID == coursematerialID);
            }
            if (courseTypeID.HasValue)
            {
                //课程类型
                exp = exp.And(x => x.CourseTypeID == courseTypeID);
            }
            if (starttermID.HasValue)
            {
                //开课学期
                exp = exp.And(x => x.StarttermID == starttermID);
            }
            if (handleModeID.HasValue)
            {
                //处理方式
                exp = exp.And(x => x.HandleModeID == handleModeID);
            }
            if (isEnable.HasValue)
            {
                //是否启用
                if (isEnable == 1)
                {
                    exp = exp.And(x => x.IsEnable == true);
                }
                if (isEnable == 0)
                {
                    exp = exp.And(x => x.IsEnable != true);
                }
            }

            var query = SpecialtyCourseDAL.GetSpecialtyCourseViewQueryable(exp);
            if (collegeID.HasValue)
            {
                //开课院系ID
                query = query.Where(x => x.CollegeID == collegeID);
            }
            if (standardID.HasValue)
            {
                //专业ID(Value)
                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 (teachingModeID.HasValue)
            {
                //授课方式
                query = query.Where(x => x.TeachingModeIDList.Contains(teachingModeID));
            }

            //查询条件
            if (!string.IsNullOrEmpty(configuretView.ConditionValue))
            {
                query = query.DynamicWhere(configuretView.Attribute, configuretView.Condition, configuretView.ConditionValue.Trim());
            }
            return this.GetQueryByDataRangeByCollege(query).OrderBy(x => x.StandardID).ThenBy(x => x.EducationID)
                    .ThenBy(x => x.LearningformID).ThenBy(x => x.LearnSystem)
                    .ThenBy(x => x.StarttermID).ThenBy(x => x.CourseTypeID)
                    .ThenBy(x => x.CourseCode.Length).ThenBy(x => x.CourseCode)
                    .ToGridResultSet<SpecialtyCourseView>(pageIndex, pageSize);
        }

        /// <summary>
        /// 查询专业课程信息List
        /// </summary>
        /// <param name="configuretView"></param>
        /// <param name="collegeID"></param>
        /// <param name="departmentID"></param>
        /// <param name="standardID"></param>
        /// <param name="educationID"></param>
        /// <param name="learningformID"></param>
        /// <param name="learnSystem"></param>
        /// <param name="coursematerialID"></param>
        /// <param name="courseTypeID"></param>
        /// <param name="starttermID"></param>
        /// <param name="teachingModeID"></param>
        /// <param name="handleModeID"></param>
        /// <param name="isEnable"></param>
        /// <returns></returns>
        public IList<SpecialtyCourseView> GetSpecialtyCourseViewList(ConfiguretView configuretView, Guid? collegeID, Guid? departmentID,
                int? standardID, int? educationID, int? learningformID, string learnSystem, Guid? coursematerialID, int? courseTypeID,
                int? starttermID, int? teachingModeID, int? handleModeID, int? isEnable)
        {
            //专业课程
            Expression<Func<EM_SpecialtyCourse, bool>> exp = (x => x.RecordStatus > (int)SYS_STATUS.UNUSABLE);
            if (departmentID.HasValue)
            {
                //开课教研室ID
                exp = exp.And(x => x.DepartmentID == departmentID);
            }
            if (coursematerialID.HasValue)
            {
                //课程信息ID
                exp = exp.And(x => x.CoursematerialID == coursematerialID);
            }
            if (courseTypeID.HasValue)
            {
                //课程类型
                exp = exp.And(x => x.CourseTypeID == courseTypeID);
            }
            if (starttermID.HasValue)
            {
                //开课学期
                exp = exp.And(x => x.StarttermID == starttermID);
            }
            if (handleModeID.HasValue)
            {
                //处理方式
                exp = exp.And(x => x.HandleModeID == handleModeID);
            }
            if (isEnable.HasValue)
            {
                //是否启用
                if (isEnable == 1)
                {
                    exp = exp.And(x => x.IsEnable == true);
                }
                if (isEnable == 0)
                {
                    exp = exp.And(x => x.IsEnable != true);
                }
            }

            var query = SpecialtyCourseDAL.GetSpecialtyCourseViewQueryable(exp);
            if (collegeID.HasValue)
            {
                //开课院系ID
                query = query.Where(x => x.CollegeID == collegeID);
            }
            if (standardID.HasValue)
            {
                //专业ID(Value)
                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 (teachingModeID.HasValue)
            {
                //授课方式
                query = query.Where(x => x.TeachingModeIDList.Contains(teachingModeID));
            }

            //查询条件
            if (!string.IsNullOrEmpty(configuretView.ConditionValue))
            {
                query = query.DynamicWhere(configuretView.Attribute, configuretView.Condition, configuretView.ConditionValue.Trim());
            }
            return this.GetQueryByDataRangeByCollege(query).OrderBy(x => x.StandardID).ThenBy(x => x.EducationID)
                    .ThenBy(x => x.LearningformID).ThenBy(x => x.LearnSystem)
                    .ThenBy(x => x.StarttermID).ThenBy(x => x.CourseTypeID)
                    .ThenBy(x => x.CourseCode.Length).ThenBy(x => x.CourseCode)
                    .ToList();
        }

        /// <summary>
        /// 查询对应的专业课程信息SpecialtyCourseView
        /// </summary>
        /// <param name="specialtyCourseID"></param>
        /// <returns></returns>
        public SpecialtyCourseView GetSpecialtyCourseView(Guid? specialtyCourseID)
        {
            try
            {
                var specialtyCourseView = SpecialtyCourseDAL.GetSpecialtyCourseViewQueryable(x => x.SpecialtyCourseID == specialtyCourseID)
                        .SingleOrDefault();
                return specialtyCourseView;
            }
            catch (Exception ex)
            {
                throw new Exception(ex.Message);
            }
        }

        /// <summary>
        /// 编辑（新增、修改，业务主键：专业信息ID、开课学期、课程信息ID）
        /// </summary>
        /// <param name="specialtyCourseView"></param>
        public virtual void SpecialtyCourseEdit(SpecialtyCourseView specialtyCourseView)
        {
            try
            {
                //查询数据库进行验证
                var specialtyCourseVerify = SpecialtyCourseDAL.SpecialtyCourseRepository
                        .GetList(x => x.SpecialtyCourseID != specialtyCourseView.SpecialtyCourseID
                            && x.SpecialtyID == specialtyCourseView.SpecialtyID
                            && x.StarttermID == specialtyCourseView.StarttermID
                            && x.CoursematerialID == specialtyCourseView.CoursematerialID).SingleOrDefault();
                if (specialtyCourseVerify == null)
                {
                    //查询对应的专业信息
                    var specialty = SpecialtyCourseDAL.SpecialtyRepository
                            .GetList(x => x.SpecialtyID == specialtyCourseView.SpecialtyID).SingleOrDefault();
                    if (specialty == null)
                    {
                        throw new Exception("专业信息不存在，请检查。");
                    }
                    //对学制和开课学期进行判断
                    var maxStartterm = Convert.ToInt32(Math.Ceiling(specialty.LearnSystem.Value * 2 - 1)) + 1;
                    if (specialtyCourseView.StarttermID > maxStartterm)
                    {
                        throw new Exception("开课学期超出学制范围，请检查。");
                    }

                    List<EM_SpecialtyCourse> newSpecialtyCourseInList = new List<EM_SpecialtyCourse>();
                    List<EM_SpecialtyCourse> newSpecialtyCourseUpList = new List<EM_SpecialtyCourse>();
                    List<EM_SpecialtyCourseTeachingSetting> newTeachingSettingInList = new List<EM_SpecialtyCourseTeachingSetting>();
                    List<EM_SpecialtyCourseTeachingSetting> newTeachingSettingUpList = new List<EM_SpecialtyCourseTeachingSetting>();
                    List<EM_TeachingModeType> newTeachingModeTypeInList = new List<EM_TeachingModeType>();
                    List<EMIS.Entities.EM_TeachingPlace> newTeachingPlaceInList = new List<EMIS.Entities.EM_TeachingPlace>();
                    List<Guid?> specialtyCourseTMDelList = new List<Guid?>();
                    List<Guid?> specialtyCourseTPDelList = new List<Guid?>();

                    //数据有误验证
                    if (specialtyCourseView.SpecialtyCourseID != Guid.Empty)
                    {
                        var specialtyCourse = SpecialtyCourseDAL.SpecialtyCourseRepository
                                .GetList(x => x.SpecialtyCourseID == specialtyCourseView.SpecialtyCourseID,
                                    (x => x.EM_SpecialtyCourseTeachingSetting)).SingleOrDefault();
                        if (specialtyCourse == null)
                        {
                            throw new Exception("数据有误，请核查。");
                        }
                        else
                        {
                            //表示修改
                            specialtyCourse.SpecialtyID = specialtyCourseView.SpecialtyID;
                            specialtyCourse.StarttermID = specialtyCourseView.StarttermID;
                            specialtyCourse.CoursematerialID = specialtyCourseView.CoursematerialID;
                            specialtyCourse.CourseStructureID = specialtyCourseView.CourseStructureID;
                            specialtyCourse.CourseCategoryID = specialtyCourseView.CourseCategoryID;
                            specialtyCourse.CourseTypeID = specialtyCourseView.CourseTypeID;
                            specialtyCourse.CourseQualityID = specialtyCourseView.CourseQualityID;
                            specialtyCourse.DepartmentID = specialtyCourseView.DepartmentID;
                            specialtyCourse.IsSpecialtycore = specialtyCourseView.IsSpecialtycore;
                            specialtyCourse.IsCooperation = specialtyCourseView.IsCooperation;
                            specialtyCourse.IsRequired = specialtyCourseView.IsRequired;
                            specialtyCourse.IsElective = specialtyCourseView.IsElective;
                            specialtyCourse.IsNetworkCourse = specialtyCourseView.IsNetworkCourse;
                            specialtyCourse.IsMainCourse = specialtyCourseView.IsMainCourse;
                            specialtyCourse.IsNeedMaterial = specialtyCourseView.IsNeedMaterial;
                            specialtyCourse.CourseFineID = specialtyCourseView.CourseFineID;
                            specialtyCourse.PracticeTypeID = specialtyCourseView.PracticeTypeID;
                            specialtyCourse.TeachinglanguageID = specialtyCourseView.TeachinglanguageID;
                            specialtyCourse.ExaminationModeID = specialtyCourseView.ExaminationModeID;
                            specialtyCourse.ResultTypeID = specialtyCourseView.ResultTypeID;
                            specialtyCourse.HandleModeID = specialtyCourseView.HandleModeID;
                            specialtyCourse.IsEnable = specialtyCourseView.IsEnable;
                            specialtyCourse.Remark = specialtyCourseView.Remark;
                            SetModifyStatus(specialtyCourse);
                            newSpecialtyCourseUpList.Add(specialtyCourse);
                            if (specialtyCourse.EM_SpecialtyCourseTeachingSetting == null)
                            {
                                var newTeachingSetting = new EM_SpecialtyCourseTeachingSetting();
                                newTeachingSetting.SpecialtyCourseID = specialtyCourse.SpecialtyCourseID;
                                newTeachingSetting.Credit = specialtyCourseView.Credit;
                                newTeachingSetting.TheoryCourse = specialtyCourseView.TheoryCourse;
                                newTeachingSetting.Practicehours = specialtyCourseView.Practicehours;
                                newTeachingSetting.Trialhours = specialtyCourseView.Trialhours;
                                newTeachingSetting.TheoryWeeklyNum = specialtyCourseView.TheoryWeeklyNum;
                                newTeachingSetting.PracticeWeeklyNum = specialtyCourseView.PracticeWeeklyNum;
                                newTeachingSetting.TrialWeeklyNum = specialtyCourseView.TrialWeeklyNum;
                                newTeachingSetting.WeeklyHours = specialtyCourseView.WeeklyHours;
                                newTeachingSetting.WeeklyNum = specialtyCourseView.WeeklyNum;
                                newTeachingSetting.StartWeeklyNum = specialtyCourseView.StartWeeklyNum;
                                newTeachingSetting.EndWeeklyNum = specialtyCourseView.EndWeeklyNum;
                                newTeachingSettingInList.Add(newTeachingSetting);
                            }
                            else
                            {
                                specialtyCourse.EM_SpecialtyCourseTeachingSetting.Credit = specialtyCourseView.Credit;
                                specialtyCourse.EM_SpecialtyCourseTeachingSetting.TheoryCourse = specialtyCourseView.TheoryCourse;
                                specialtyCourse.EM_SpecialtyCourseTeachingSetting.Practicehours = specialtyCourseView.Practicehours;
                                specialtyCourse.EM_SpecialtyCourseTeachingSetting.Trialhours = specialtyCourseView.Trialhours;
                                specialtyCourse.EM_SpecialtyCourseTeachingSetting.TheoryWeeklyNum = specialtyCourseView.TheoryWeeklyNum;
                                specialtyCourse.EM_SpecialtyCourseTeachingSetting.PracticeWeeklyNum = specialtyCourseView.PracticeWeeklyNum;
                                specialtyCourse.EM_SpecialtyCourseTeachingSetting.TrialWeeklyNum = specialtyCourseView.TrialWeeklyNum;
                                specialtyCourse.EM_SpecialtyCourseTeachingSetting.WeeklyHours = specialtyCourseView.WeeklyHours;
                                specialtyCourse.EM_SpecialtyCourseTeachingSetting.WeeklyNum = specialtyCourseView.WeeklyNum;
                                specialtyCourse.EM_SpecialtyCourseTeachingSetting.StartWeeklyNum = specialtyCourseView.StartWeeklyNum;
                                specialtyCourse.EM_SpecialtyCourseTeachingSetting.EndWeeklyNum = specialtyCourseView.EndWeeklyNum;
                                newTeachingSettingUpList.Add(specialtyCourse.EM_SpecialtyCourseTeachingSetting);
                            }
                            if (specialtyCourseView.TeachingModeIDList != null && specialtyCourseView.TeachingModeIDList.Count() > 0)
                            {
                                specialtyCourseTMDelList.Add(specialtyCourse.SpecialtyCourseID);
                                foreach (var teachingModeID in specialtyCourseView.TeachingModeIDList)
                                {
                                    var newTeachingMode = new EM_TeachingModeType();
                                    newTeachingMode.TeachingModeTypeID = Guid.NewGuid();
                                    newTeachingMode.SpecialtyCourseID = specialtyCourse.SpecialtyCourseID;
                                    newTeachingMode.TeachingModeID = teachingModeID;
                                    SetNewStatus(newTeachingMode);
                                    newTeachingModeTypeInList.Add(newTeachingMode);
                                }
                            }
                            else
                            {
                                specialtyCourseTMDelList.Add(specialtyCourse.SpecialtyCourseID);
                            }
                            if (specialtyCourseView.TeachingPlaceIDList != null && specialtyCourseView.TeachingPlaceIDList.Count() > 0)
                            {
                                specialtyCourseTPDelList.Add(specialtyCourse.SpecialtyCourseID);
                                foreach (var teachingPlaceID in specialtyCourseView.TeachingPlaceIDList)
                                {
                                    var newTeachingPlace = new EMIS.Entities.EM_TeachingPlace();
                                    newTeachingPlace.TeachingPlaceID = Guid.NewGuid();
                                    newTeachingPlace.SpecialtyCourseID = specialtyCourse.SpecialtyCourseID;
                                    newTeachingPlace.TeachingPlace = teachingPlaceID;
                                    SetNewStatus(newTeachingPlace);
                                    newTeachingPlaceInList.Add(newTeachingPlace);
                                }
                            }
                            else
                            {
                                specialtyCourseTPDelList.Add(specialtyCourse.SpecialtyCourseID);
                            }
                        }
                    }
                    else
                    {
                        //表示新增
                        var newSpecialtyCourse = new EM_SpecialtyCourse();
                        newSpecialtyCourse.SpecialtyCourseID = Guid.NewGuid();
                        newSpecialtyCourse.SpecialtyID = specialtyCourseView.SpecialtyID;
                        newSpecialtyCourse.StarttermID = specialtyCourseView.StarttermID;
                        newSpecialtyCourse.CoursematerialID = specialtyCourseView.CoursematerialID;
                        newSpecialtyCourse.CourseStructureID = specialtyCourseView.CourseStructureID;
                        newSpecialtyCourse.CourseCategoryID = specialtyCourseView.CourseCategoryID;
                        newSpecialtyCourse.CourseTypeID = specialtyCourseView.CourseTypeID;
                        newSpecialtyCourse.CourseQualityID = specialtyCourseView.CourseQualityID;
                        newSpecialtyCourse.DepartmentID = specialtyCourseView.DepartmentID;
                        newSpecialtyCourse.IsSpecialtycore = specialtyCourseView.IsSpecialtycore;
                        newSpecialtyCourse.IsCooperation = specialtyCourseView.IsCooperation;
                        newSpecialtyCourse.IsRequired = specialtyCourseView.IsRequired;
                        newSpecialtyCourse.IsElective = specialtyCourseView.IsElective;
                        newSpecialtyCourse.IsNetworkCourse = specialtyCourseView.IsNetworkCourse;
                        newSpecialtyCourse.IsMainCourse = specialtyCourseView.IsMainCourse;
                        newSpecialtyCourse.IsNeedMaterial = specialtyCourseView.IsNeedMaterial;
                        newSpecialtyCourse.CourseFineID = specialtyCourseView.CourseFineID;
                        newSpecialtyCourse.PracticeTypeID = specialtyCourseView.PracticeTypeID;
                        newSpecialtyCourse.TeachinglanguageID = specialtyCourseView.TeachinglanguageID;
                        newSpecialtyCourse.ExaminationModeID = specialtyCourseView.ExaminationModeID;
                        newSpecialtyCourse.ResultTypeID = specialtyCourseView.ResultTypeID;
                        newSpecialtyCourse.HandleModeID = specialtyCourseView.HandleModeID;
                        newSpecialtyCourse.IsEnable = specialtyCourseView.IsEnable;
                        newSpecialtyCourse.Remark = specialtyCourseView.Remark;
                        SetNewStatus(newSpecialtyCourse);
                        newSpecialtyCourseInList.Add(newSpecialtyCourse);
                        var newTeachingSetting = new EM_SpecialtyCourseTeachingSetting();
                        newTeachingSetting.SpecialtyCourseID = newSpecialtyCourse.SpecialtyCourseID;
                        newTeachingSetting.Credit = specialtyCourseView.Credit;
                        newTeachingSetting.TheoryCourse = specialtyCourseView.TheoryCourse;
                        newTeachingSetting.Practicehours = specialtyCourseView.Practicehours;
                        newTeachingSetting.Trialhours = specialtyCourseView.Trialhours;
                        newTeachingSetting.TheoryWeeklyNum = specialtyCourseView.TheoryWeeklyNum;
                        newTeachingSetting.PracticeWeeklyNum = specialtyCourseView.PracticeWeeklyNum;
                        newTeachingSetting.TrialWeeklyNum = specialtyCourseView.TrialWeeklyNum;
                        newTeachingSetting.WeeklyHours = specialtyCourseView.WeeklyHours;
                        newTeachingSetting.WeeklyNum = specialtyCourseView.WeeklyNum;
                        newTeachingSetting.StartWeeklyNum = specialtyCourseView.StartWeeklyNum;
                        newTeachingSetting.EndWeeklyNum = specialtyCourseView.EndWeeklyNum;
                        newTeachingSettingInList.Add(newTeachingSetting);
                        if (specialtyCourseView.TeachingModeIDList != null && specialtyCourseView.TeachingModeIDList.Count() > 0)
                        {
                            foreach (var teachingModeID in specialtyCourseView.TeachingModeIDList)
                            {
                                var newTeachingMode = new EM_TeachingModeType();
                                newTeachingMode.TeachingModeTypeID = Guid.NewGuid();
                                newTeachingMode.SpecialtyCourseID = newSpecialtyCourse.SpecialtyCourseID;
                                newTeachingMode.TeachingModeID = teachingModeID;
                                SetNewStatus(newTeachingMode);
                                newTeachingModeTypeInList.Add(newTeachingMode);
                            }
                        }
                        if (specialtyCourseView.TeachingPlaceIDList != null && specialtyCourseView.TeachingPlaceIDList.Count() > 0)
                        {
                            foreach (var teachingPlaceID in specialtyCourseView.TeachingPlaceIDList)
                            {
                                var newTeachingPlace = new EMIS.Entities.EM_TeachingPlace();
                                newTeachingPlace.TeachingPlaceID = Guid.NewGuid();
                                newTeachingPlace.SpecialtyCourseID = newSpecialtyCourse.SpecialtyCourseID;
                                newTeachingPlace.TeachingPlace = teachingPlaceID;
                                SetNewStatus(newTeachingPlace);
                                newTeachingPlaceInList.Add(newTeachingPlace);
                            }
                        }
                    }
                    //事务提交
                    //UnitOfWork.Commit();
                    using (TransactionScope ts = new TransactionScope())
                    {
                        //删除
                        UnitOfWork.Delete<EMIS.Entities.EM_TeachingPlace>(x => specialtyCourseTPDelList.Contains(x.SpecialtyCourseID));
                        UnitOfWork.Delete<EM_TeachingModeType>(x => specialtyCourseTMDelList.Contains(x.SpecialtyCourseID));
                        //批量插入
                        UnitOfWork.BulkInsert(newSpecialtyCourseInList);
                        UnitOfWork.BulkInsert(newTeachingSettingInList);
                        UnitOfWork.BulkInsert(newTeachingModeTypeInList);
                        UnitOfWork.BulkInsert(newTeachingPlaceInList);
                        //批量统一提交更新
                        if (newSpecialtyCourseUpList != null && newSpecialtyCourseUpList.Count() > 0)
                        {
                            UnitOfWork.BatchUpdate(newSpecialtyCourseUpList);
                        }
                        //批量统一提交更新
                        if (newTeachingSettingUpList != null && newTeachingSettingUpList.Count() > 0)
                        {
                            UnitOfWork.BatchUpdate(newTeachingSettingUpList);
                        }
                        ts.Complete();
                    }
                }
                else
                {
                    throw new Exception("已存在相同的专业课程信息（专业信息、开课学期、课程信息唯一），请核查。");
                }
            }
            catch (Exception ex)
            {
                throw new Exception(ex.Message);
            }
        }

        /// <summary>
        /// 删除
        /// </summary>
        /// <param name="specialtyCourseIDs"></param>
        /// <returns></returns>
        public bool SpecialtyCourseDelete(List<Guid?> specialtyCourseIDs)
        {
            try
            {
                using (TransactionScope ts = new TransactionScope())
                {
                    UnitOfWork.Delete<EMIS.Entities.EM_TeachingPlace>(x => specialtyCourseIDs.Contains(x.SpecialtyCourseID));
                    UnitOfWork.Delete<EM_TeachingModeType>(x => specialtyCourseIDs.Contains(x.SpecialtyCourseID));
                    UnitOfWork.Delete<EM_SpecialtyCourseTeachingSetting>(x => specialtyCourseIDs.Contains(x.SpecialtyCourseID));
                    UnitOfWork.Delete<EM_SpecialtyCourse>(x => specialtyCourseIDs.Contains(x.SpecialtyCourseID));
                    ts.Complete();
                    return true;
                }
            }
            catch (Exception)
            {
                throw;
            }
        }

        /// <summary>
        /// 查询专业课程对应的授课方式List
        /// </summary>
        /// <param name="specialtyCourseID"></param>
        /// <returns></returns>
        public List<string> GetTeachingModeTypeList(Guid? specialtyCourseID)
        {
            //专业课程
            Expression<Func<EM_SpecialtyCourse, bool>> exp = (x => x.RecordStatus > (int)SYS_STATUS.UNUSABLE);
            exp = exp.And(x => x.SpecialtyCourseID == specialtyCourseID);
            var query = SpecialtyCourseDAL.GetTeachingModeTypeQueryble(exp);

            return query.OrderBy(x => x.Value).Select(x => x.ToString()).ToList();
        }

        /// <summary>
        /// 查询专业课程对应的授课地点List
        /// </summary>
        /// <param name="specialtyCourseID"></param>
        /// <returns></returns>
        public List<string> GetTeachingPlaceList(Guid? specialtyCourseID)
        {
            //专业课程
            Expression<Func<EM_SpecialtyCourse, bool>> exp = (x => x.RecordStatus > (int)SYS_STATUS.UNUSABLE);
            exp = exp.And(x => x.SpecialtyCourseID == specialtyCourseID);
            var query = SpecialtyCourseDAL.GetTeachingPlaceQueryble(exp);

            return query.OrderBy(x => x.Value).Select(x => x.ToString()).ToList();
        }

        /// <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 SpecialtyCourseImport(Dictionary<string, string> cellheader, out int? inCount, out int? upCount, out List<SpecialtyCourseView> errdataList, out int? errCount, string sourcePhysicalPath)
        {
            try
            {
                StringBuilder errorMsg = new StringBuilder(); // 错误信息
                List<SpecialtyCourseView> errList = new List<SpecialtyCourseView>();

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

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

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

                List<EM_SpecialtyCourse> newSpecialtyCourseInList = new List<EM_SpecialtyCourse>();
                List<EM_SpecialtyCourse> newSpecialtyCourseUpList = new List<EM_SpecialtyCourse>();
                List<EM_SpecialtyCourseTeachingSetting> newTeachingSettingInList = new List<EM_SpecialtyCourseTeachingSetting>();
                List<EM_SpecialtyCourseTeachingSetting> newTeachingSettingUpList = new List<EM_SpecialtyCourseTeachingSetting>();
                List<EM_TeachingModeType> newTeachingModeTypeInList = new List<EM_TeachingModeType>();
                List<EMIS.Entities.EM_TeachingPlace> newTeachingPlaceInList = new List<EMIS.Entities.EM_TeachingPlace>();
                List<Guid?> specialtyCourseTMDelList = new List<Guid?>();
                List<Guid?> specialtyCourseTPDelList = new List<Guid?>();

                //将循环中相关数据库查询统一查询出来进行匹配(尽量避免在循环中进行数据库查询)
                //专业代码、专业名称、专业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 specialtyList = SpecialtyCourseDAL.SpecialtyRepository.GetList(x => true).ToList();
                //开课学期
                var starttermList = IdNameExt.GetDictionaryItem(DictionaryItem.CF_Startterm).ToList();
                //课程信息
                var courseList = SpecialtyCourseDAL.CoursematerialRepository.GetList(x => true).ToList();
                //课程代码
                var courseCodeList = enlist.Where(x => !string.IsNullOrWhiteSpace(x.CourseCode)).Select(x => x.CourseCode.Trim()).ToList();
                //对比后的newCourseList
                var newCourseList = courseList.Where(x => courseCodeList.Contains(x.CourseCode)).ToList();
                //对比后的coursematerialIDList
                var coursematerialIDList = newCourseList.Select(x => (Guid?)x.CoursematerialID).ToList();
                //课程结构
                var courseStructureList = IdNameExt.GetDictionaryItem(DictionaryItem.CF_CourseStructure).ToList();
                //课程属性
                var courseCategoryList = IdNameExt.GetDictionaryItem(DictionaryItem.CF_CourseCategory).ToList();
                //课程类型
                var courseTypeList = IdNameExt.GetDictionaryItem(DictionaryItem.CF_CourseType).ToList();
                //课程性质
                var courseQualityList = IdNameExt.GetDictionaryItem(DictionaryItem.CF_CourseQuality).ToList();
                //教研室信息
                var departmentList = SpecialtyCourseDAL.DepartmentRepository.GetList(x => true).ToList();
                //开课教研室
                var departmentNameList = enlist.Where(x => !string.IsNullOrWhiteSpace(x.DepartmentName)).Select(x => x.DepartmentName.Trim()).ToList();
                //对比后的newDepartmentList
                var newDepartmentList = departmentList.Where(x => departmentNameList.Contains(x.Name)).ToList();
                //通用是否
                var generalPurposeList = IdNameExt.GetDictionaryItem(DictionaryItem.CF_GeneralPurpose).ToList();
                //精品课程
                var courseFineList = IdNameExt.GetDictionaryItem(DictionaryItem.CF_CourseFine).ToList();
                //实践类型
                var practiceTypeList = IdNameExt.GetDictionaryItem(DictionaryItem.EM_PracticeType).ToList();
                //授课语言
                var teachinglanguageList = IdNameExt.GetDictionaryItem(DictionaryItem.CF_Teachinglanguage).ToList();
                //考试方式
                var examinationModeList = IdNameExt.GetDictionaryItem(DictionaryItem.CF_ExaminationMode).ToList();
                //成绩类型
                var resultTypeList = IdNameExt.GetDictionaryItem(DictionaryItem.CF_ResultType).ToList();
                //处理方式
                var handleModeList = IdNameExt.GetDictionaryItem(DictionaryItem.CF_HandleMode).ToList();
                //授课方式
                var teachingModeList = IdNameExt.GetDictionaryItem(DictionaryItem.CF_TeachingMode).ToList();
                //授课地点
                var teachingPlaceList = IdNameExt.GetDictionaryItem(DictionaryItem.EM_TeachingPlace).ToList();
                //专业课程
                var specialtyCourseList = SpecialtyCourseDAL.SpecialtyCourseRepository
                        .GetList(x => true, (x => x.EM_SpecialtyCourseTeachingSetting)).ToList();
                //对比后的newSpecialtyCourseList(暂时只对比课程信息ID)
                var newSpecialtyCourseList = specialtyCourseList.Where(x => coursematerialIDList.Contains(x.CoursematerialID)).ToList();

                //循环检测数据列,对各数据列进行验证（必填、字典项验证、数据格式等）
                for (int i = 0; i < enlist.Count; i++)
                {
                    SpecialtyCourseView en = enlist[i]; //Excel表数据视图
                    EM_SpecialtyCourse newSpecialtyCourse = new EM_SpecialtyCourse();
                    EM_SpecialtyCourseTeachingSetting newTeachingSetting = new EM_SpecialtyCourseTeachingSetting();
                    List<int> newModeTypeList = new List<int>();
                    List<int> newPlaceList = new List<int>();

                    //专业代码
                    if (string.IsNullOrWhiteSpace(en.StandardCodeStr))
                    {
                        errCount++;
                        errorMsgStr = "专业代码不能为空";
                        en.ErrorMessage = errorMsgStr;
                        errList.Add(en);
                        errorMsg.AppendLine(errorMsgStr);
                        continue;
                    }
                    else
                    {
                        var standard = standardList.Where(x => x.Code == en.StandardCodeStr.Trim()).FirstOrDefault();
                        if (standard == null)
                        {
                            errCount++;
                            errorMsgStr = "专业代码不存在，请检查";
                            en.ErrorMessage = errorMsgStr;
                            errList.Add(en);
                            errorMsg.AppendLine(errorMsgStr);
                            continue;
                        }
                        else
                        {
                            //专业代码
                        }
                    }
                    //专业名称
                    if (string.IsNullOrWhiteSpace(en.StandardNameStr))
                    {
                        errCount++;
                        errorMsgStr = "专业名称不能为空";
                        en.ErrorMessage = errorMsgStr;
                        errList.Add(en);
                        errorMsg.AppendLine(errorMsgStr);
                        continue;
                    }
                    else
                    {
                        var standard = standardList.Where(x => x.Name == en.StandardNameStr.Trim()).FirstOrDefault();
                        if (standard == null)
                        {
                            errCount++;
                            errorMsgStr = "专业名称不存在，请检查";
                            en.ErrorMessage = errorMsgStr;
                            errList.Add(en);
                            errorMsg.AppendLine(errorMsgStr);
                            continue;
                        }
                        else
                        {
                            //专业名称
                        }
                    }
                    //专业代码与专业名称查询专业ID(Value)
                    if (string.IsNullOrWhiteSpace(en.StandardCodeStr) || string.IsNullOrWhiteSpace(en.StandardNameStr))
                    {
                        errCount++;
                        errorMsgStr = "专业代码或专业名称不能为空";
                        en.ErrorMessage = errorMsgStr;
                        errList.Add(en);
                        errorMsg.AppendLine(errorMsgStr);
                        continue;
                    }
                    else
                    {
                        var standard = standardList.Where(x => x.Code == en.StandardCodeStr.Trim() && x.Name == en.StandardNameStr.Trim()).SingleOrDefault();
                        if (standard == null)
                        {
                            errCount++;
                            errorMsgStr = "专业代码与专业名称对应的元素值不存在，请检查";
                            en.ErrorMessage = errorMsgStr;
                            errList.Add(en);
                            errorMsg.AppendLine(errorMsgStr);
                            continue;
                        }
                        else
                        {
                            //专业ID(Value)
                            en.StandardID = standard.Value;
                        }
                    }
                    //培养层次
                    if (string.IsNullOrWhiteSpace(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.IsNullOrWhiteSpace(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.IsNullOrWhiteSpace(en.LearnSystemStr))
                    {
                        errCount++;
                        errorMsgStr = "学制不能为空";
                        en.ErrorMessage = errorMsgStr;
                        errList.Add(en);
                        errorMsg.AppendLine(errorMsgStr);
                        continue;
                    }
                    else
                    {
                        reg = new Regex(@"^[0-9]+([.]{1}[0-9]+){0,1}$"); //学制字段正则表达式(数字)
                        if (!reg.IsMatch(en.LearnSystemStr.Trim()))
                        {
                            errCount++;
                            errorMsgStr = "学制格式不正确，请检查";
                            en.ErrorMessage = errorMsgStr;
                            errList.Add(en);
                            errorMsg.AppendLine(errorMsgStr);
                            continue;
                        }
                        else
                        {
                            //学制
                            en.LearnSystem = Convert.ToDecimal(en.LearnSystemStr.Trim());
                        }
                    }
                    //查询对应的专业信息ID
                    if (en.StandardID.HasValue && en.EducationID.HasValue && en.LearningformID.HasValue && en.LearnSystem.HasValue)
                    {
                        //查询对应的专业信息
                        var specialty = specialtyList.Where(x => x.StandardID == en.StandardID
                                && x.EducationID == en.EducationID
                                && x.LearningformID == en.LearningformID
                                && x.LearnSystem == en.LearnSystem).SingleOrDefault();
                        if (specialty == null)
                        {
                            errCount++;
                            errorMsgStr = "对应的专业信息不存在（以专业代码、专业名称、"
                                    + RSL.Get("EducationID") + "、学习形式、学制查询），请检查";
                            en.ErrorMessage = errorMsgStr;
                            errList.Add(en);
                            errorMsg.AppendLine(errorMsgStr);
                            continue;
                        }
                        else
                        {
                            //判断对应的专业信息状态(启用、禁用状态)
                            if (specialty.RecordStatus > (int)SYS_STATUS.UNUSABLE)
                            {
                                newSpecialtyCourse.SpecialtyID = specialty.SpecialtyID;
                            }
                            else
                            {
                                newSpecialtyCourse.SpecialtyID = specialty.SpecialtyID;
                                errCount++;
                                errorMsgStr = "对应的专业信息为禁用状态，请检查";
                                en.ErrorMessage = errorMsgStr;
                                errList.Add(en);
                                errorMsg.AppendLine(errorMsgStr);
                                continue;
                            }
                        }
                    }
                    else
                    {
                        errCount++;
                        errorMsgStr = "数据有误，请检查（专业ID(Value)、"
                                + RSL.Get("EducationID") + "、学习形式或学制不能为空）";
                        en.ErrorMessage = errorMsgStr;
                        errList.Add(en);
                        errorMsg.AppendLine(errorMsgStr);
                        continue;
                    }
                    //开课学期
                    if (string.IsNullOrWhiteSpace(en.StarttermStr))
                    {
                        errCount++;
                        errorMsgStr = "开课学期不能为空";
                        en.ErrorMessage = errorMsgStr;
                        errList.Add(en);
                        errorMsg.AppendLine(errorMsgStr);
                        continue;
                    }
                    else
                    {
                        var startterm = starttermList.Where(x => x.Name == en.StarttermStr.Trim()).SingleOrDefault();
                        if (startterm == null)
                        {
                            errCount++;
                            errorMsgStr = "开课学期不存在，请检查";
                            en.ErrorMessage = errorMsgStr;
                            errList.Add(en);
                            errorMsg.AppendLine(errorMsgStr);
                            continue;
                        }
                        else
                        {
                            //对学制和开课学期进行判断
                            var maxStartterm = Convert.ToInt32(Math.Ceiling(en.LearnSystem.Value * 2 - 1)) + 1;
                            if (startterm.Value > maxStartterm)
                            {
                                errCount++;
                                errorMsgStr = "开课学期超出学制范围，请检查";
                                en.ErrorMessage = errorMsgStr;
                                errList.Add(en);
                                errorMsg.AppendLine(errorMsgStr);
                                continue;
                            }
                            else
                            {
                                //开课学期
                                newSpecialtyCourse.StarttermID = startterm.Value;
                            }
                        }
                    }
                    //课程代码
                    if (string.IsNullOrWhiteSpace(en.CourseCode))
                    {
                        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.CourseCode.Trim()))
                        {
                            errCount++;
                            errorMsgStr = "课程代码格式不正确，请检查(数字或英文字母)";
                            en.ErrorMessage = errorMsgStr;
                            errList.Add(en);
                            errorMsg.AppendLine(errorMsgStr);
                            continue;
                        }
                        else
                        {
                            var course = newCourseList.Where(x => x.CourseCode == en.CourseCode.Trim()).SingleOrDefault();
                            if (course == null)
                            {
                                errCount++;
                                errorMsgStr = "课程代码不存在，请检查";
                                en.ErrorMessage = errorMsgStr;
                                errList.Add(en);
                                errorMsg.AppendLine(errorMsgStr);
                                continue;
                            }
                            else
                            {
                                //判断课程代码与课程名称（以课程代码为准）
                                if (string.IsNullOrWhiteSpace(en.CourseName))
                                {
                                    //暂不考虑
                                }
                                else
                                {
                                    //课程代码与课程名称不对应
                                    if (course.CourseName.Trim() != en.CourseName.Trim())
                                    {
                                        errCount++;
                                        errorMsgStr = "课程代码与课程名称不对应(以课程代码为准)，请检查";
                                        en.ErrorMessage = errorMsgStr;
                                        errList.Add(en);
                                        errorMsg.AppendLine(errorMsgStr);
                                        continue;
                                    }
                                }
                                //判断对应的课程信息状态(启用、禁用状态)
                                if (course.IsEnable == true)
                                {
                                    //课程信息ID
                                    newSpecialtyCourse.CoursematerialID = course.CoursematerialID;
                                }
                                else
                                {
                                    newSpecialtyCourse.CoursematerialID = course.CoursematerialID;
                                    errCount++;
                                    errorMsgStr = "对应的课程信息为禁用状态，请检查";
                                    en.ErrorMessage = errorMsgStr;
                                    errList.Add(en);
                                    errorMsg.AppendLine(errorMsgStr);
                                    continue;
                                }
                            }
                        }
                    }
                    //课程名称
                    if (string.IsNullOrWhiteSpace(en.CourseName))
                    {
                        //暂不考虑
                    }
                    else
                    {
                        //暂不考虑
                    }
                    //课程结构
                    if (string.IsNullOrWhiteSpace(en.CourseStructureStr))
                    {
                        newSpecialtyCourse.CourseStructureID = (int)CF_CourseStructure.ClassroomTeaching;
                    }
                    else
                    {
                        var courseStructure = courseStructureList.Where(x => x.Name == en.CourseStructureStr.Trim()).SingleOrDefault();
                        if (courseStructure == null)
                        {
                            errCount++;
                            errorMsgStr = "课程结构不存在，请检查";
                            en.ErrorMessage = errorMsgStr;
                            errList.Add(en);
                            errorMsg.AppendLine(errorMsgStr);
                            continue;
                        }
                        else
                        {
                            //课程结构
                            newSpecialtyCourse.CourseStructureID = courseStructure.Value;
                        }
                    }
                    //课程属性
                    if (string.IsNullOrWhiteSpace(en.CourseCategoryStr))
                    {
                        newSpecialtyCourse.CourseCategoryID = (int)CF_CourseCategory.Publiccourse;
                    }
                    else
                    {
                        var courseCategory = courseCategoryList.Where(x => x.Name == en.CourseCategoryStr.Trim()).SingleOrDefault();
                        if (courseCategory == null)
                        {
                            errCount++;
                            errorMsgStr = "课程属性不存在，请检查";
                            en.ErrorMessage = errorMsgStr;
                            errList.Add(en);
                            errorMsg.AppendLine(errorMsgStr);
                            continue;
                        }
                        else
                        {
                            //课程属性
                            newSpecialtyCourse.CourseCategoryID = courseCategory.Value;
                        }
                    }
                    //课程类型
                    if (string.IsNullOrWhiteSpace(en.CourseTypeStr))
                    {
                        errCount++;
                        errorMsgStr = "课程类型不能为空";
                        en.ErrorMessage = errorMsgStr;
                        errList.Add(en);
                        errorMsg.AppendLine(errorMsgStr);
                        continue;
                    }
                    else
                    {
                        var courseType = courseTypeList.Where(x => x.Name == en.CourseTypeStr.Trim()).SingleOrDefault();
                        if (courseType == null)
                        {
                            errCount++;
                            errorMsgStr = "课程类型不存在，请检查";
                            en.ErrorMessage = errorMsgStr;
                            errList.Add(en);
                            errorMsg.AppendLine(errorMsgStr);
                            continue;
                        }
                        else
                        {
                            //课程类型
                            newSpecialtyCourse.CourseTypeID = courseType.Value;
                        }
                    }
                    //课程性质
                    if (string.IsNullOrWhiteSpace(en.CourseQualityStr))
                    {
                        newSpecialtyCourse.CourseQualityID = (int)CF_CourseQuality.Required;
                    }
                    else
                    {
                        var courseQuality = courseQualityList.Where(x => x.Name == en.CourseQualityStr.Trim()).SingleOrDefault();
                        if (courseQuality == null)
                        {
                            errCount++;
                            errorMsgStr = "课程性质不存在，请检查";
                            en.ErrorMessage = errorMsgStr;
                            errList.Add(en);
                            errorMsg.AppendLine(errorMsgStr);
                            continue;
                        }
                        else
                        {
                            //课程性质
                            newSpecialtyCourse.CourseQualityID = courseQuality.Value;
                        }
                    }
                    //课程学分
                    if (string.IsNullOrWhiteSpace(en.CreditStr))
                    {
                        errCount++;
                        errorMsgStr = "课程学分不能为空";
                        en.ErrorMessage = errorMsgStr;
                        errList.Add(en);
                        errorMsg.AppendLine(errorMsgStr);
                        continue;
                    }
                    else
                    {
                        reg = new Regex(@"^[0-9]+([.]{1}[0-9]+){0,1}$"); //课程学分字段正则表达式(数字)
                        if (!reg.IsMatch(en.CreditStr.Trim()))
                        {
                            errCount++;
                            errorMsgStr = "课程学分格式不正确，请检查";
                            en.ErrorMessage = errorMsgStr;
                            errList.Add(en);
                            errorMsg.AppendLine(errorMsgStr);
                            continue;
                        }
                        else
                        {
                            //课程学分
                            newTeachingSetting.Credit = Convert.ToDecimal(en.CreditStr.Trim());
                        }
                    }
                    //理论学时
                    if (string.IsNullOrWhiteSpace(en.TheoryCourseStr))
                    {
                        errCount++;
                        errorMsgStr = "理论学时不能为空";
                        en.ErrorMessage = errorMsgStr;
                        errList.Add(en);
                        errorMsg.AppendLine(errorMsgStr);
                        continue;
                    }
                    else
                    {
                        reg = new Regex(@"^\d+$"); //正则表达式(非负整数)
                        if (!reg.IsMatch(en.TheoryCourseStr.Trim()))
                        {
                            errCount++;
                            errorMsgStr = "理论学时格式不正确，请检查";
                            en.ErrorMessage = errorMsgStr;
                            errList.Add(en);
                            errorMsg.AppendLine(errorMsgStr);
                            continue;
                        }
                        else
                        {
                            //理论学时
                            newTeachingSetting.TheoryCourse = Convert.ToInt32(en.TheoryCourseStr.Trim());
                        }
                    }
                    //实践学时
                    if (string.IsNullOrWhiteSpace(en.PracticehoursStr))
                    {
                        //默认为0
                        newTeachingSetting.Practicehours = 0;
                    }
                    else
                    {
                        reg = new Regex(@"^\d+$"); //正则表达式(非负整数)
                        if (!reg.IsMatch(en.PracticehoursStr.Trim()))
                        {
                            errCount++;
                            errorMsgStr = "实践学时格式不正确，请检查";
                            en.ErrorMessage = errorMsgStr;
                            errList.Add(en);
                            errorMsg.AppendLine(errorMsgStr);
                            continue;
                        }
                        else
                        {
                            //实践学时
                            newTeachingSetting.Practicehours = Convert.ToInt32(en.PracticehoursStr.Trim());
                        }
                    }
                    //实验学时
                    if (string.IsNullOrWhiteSpace(en.TrialhoursStr))
                    {
                        //默认为0
                        newTeachingSetting.Trialhours = 0;
                    }
                    else
                    {
                        reg = new Regex(@"^\d+$"); //正则表达式(非负整数)
                        if (!reg.IsMatch(en.TrialhoursStr.Trim()))
                        {
                            errCount++;
                            errorMsgStr = "实验学时格式不正确，请检查";
                            en.ErrorMessage = errorMsgStr;
                            errList.Add(en);
                            errorMsg.AppendLine(errorMsgStr);
                            continue;
                        }
                        else
                        {
                            //实验学时
                            newTeachingSetting.Trialhours = Convert.ToInt32(en.TrialhoursStr.Trim());
                        }
                    }
                    //开课教研室
                    if (string.IsNullOrWhiteSpace(en.DepartmentName))
                    {
                        errCount++;
                        errorMsgStr = "开课教研室不能为空";
                        en.ErrorMessage = errorMsgStr;
                        errList.Add(en);
                        errorMsg.AppendLine(errorMsgStr);
                        continue;
                    }
                    else
                    {
                        var department = newDepartmentList.Where(x => x.Name == en.DepartmentName.Trim()).SingleOrDefault();
                        if (department == null)
                        {
                            errCount++;
                            errorMsgStr = "开课教研室不存在，请检查";
                            en.ErrorMessage = errorMsgStr;
                            errList.Add(en);
                            errorMsg.AppendLine(errorMsgStr);
                            continue;
                        }
                        else
                        {
                            //开课教研室ID
                            newSpecialtyCourse.DepartmentID = department.DepartmentID;
                        }
                    }
                    //是否专业核心
                    if (string.IsNullOrWhiteSpace(en.IsSpecialtycoreStr))
                    {
                        //是否专业核心(默认为否)
                        newSpecialtyCourse.IsSpecialtycore = false;
                    }
                    else
                    {
                        var generalPurpose = generalPurposeList.Where(x => x.Name == en.IsSpecialtycoreStr.Trim()).SingleOrDefault();
                        if (generalPurpose == null)
                        {
                            errCount++;
                            errorMsgStr = "是否专业核心不存在，请检查";
                            en.ErrorMessage = errorMsgStr;
                            errList.Add(en);
                            errorMsg.AppendLine(errorMsgStr);
                            continue;
                        }
                        else
                        {
                            //是否专业核心
                            newSpecialtyCourse.IsSpecialtycore = generalPurpose.Value == (int)CF_GeneralPurpose.IsYes ? true : false;
                        }
                    }
                    //是否合作开发
                    if (string.IsNullOrWhiteSpace(en.IsCooperationStr))
                    {
                        //是否合作开发(默认为否)
                        newSpecialtyCourse.IsCooperation = false;
                    }
                    else
                    {
                        var generalPurpose = generalPurposeList.Where(x => x.Name == en.IsCooperationStr.Trim()).SingleOrDefault();
                        if (generalPurpose == null)
                        {
                            errCount++;
                            errorMsgStr = "是否合作开发不存在，请检查";
                            en.ErrorMessage = errorMsgStr;
                            errList.Add(en);
                            errorMsg.AppendLine(errorMsgStr);
                            continue;
                        }
                        else
                        {
                            //是否合作开发
                            newSpecialtyCourse.IsCooperation = generalPurpose.Value == (int)CF_GeneralPurpose.IsYes ? true : false;
                        }
                    }
                    //是否必修课
                    if (string.IsNullOrWhiteSpace(en.IsRequiredStr))
                    {
                        //是否必修课(默认为否)
                        newSpecialtyCourse.IsRequired = false;
                    }
                    else
                    {
                        var generalPurpose = generalPurposeList.Where(x => x.Name == en.IsRequiredStr.Trim()).SingleOrDefault();
                        if (generalPurpose == null)
                        {
                            errCount++;
                            errorMsgStr = RSL.Get("IsRequired") + "不存在，请检查";
                            en.ErrorMessage = errorMsgStr;
                            errList.Add(en);
                            errorMsg.AppendLine(errorMsgStr);
                            continue;
                        }
                        else
                        {
                            //是否必修课
                            newSpecialtyCourse.IsRequired = generalPurpose.Value == (int)CF_GeneralPurpose.IsYes ? true : false;
                        }
                    }
                    //是否网上选修
                    if (string.IsNullOrWhiteSpace(en.IsElectiveStr))
                    {
                        //是否网上选修(默认为否)
                        newSpecialtyCourse.IsElective = false;
                    }
                    else
                    {
                        var generalPurpose = generalPurposeList.Where(x => x.Name == en.IsElectiveStr.Trim()).SingleOrDefault();
                        if (generalPurpose == null)
                        {
                            errCount++;
                            errorMsgStr = "是否网上选修不存在，请检查";
                            en.ErrorMessage = errorMsgStr;
                            errList.Add(en);
                            errorMsg.AppendLine(errorMsgStr);
                            continue;
                        }
                        else
                        {
                            //是否网上选修
                            newSpecialtyCourse.IsElective = generalPurpose.Value == (int)CF_GeneralPurpose.IsYes ? true : false;
                        }
                    }
                    //是否网络课程
                    if (string.IsNullOrWhiteSpace(en.IsNetworkCourseStr))
                    {
                        //是否网络课程(默认为否)
                        newSpecialtyCourse.IsNetworkCourse = false;
                    }
                    else
                    {
                        var generalPurpose = generalPurposeList.Where(x => x.Name == en.IsNetworkCourseStr.Trim()).SingleOrDefault();
                        if (generalPurpose == null)
                        {
                            errCount++;
                            errorMsgStr = "是否网络课程不存在，请检查";
                            en.ErrorMessage = errorMsgStr;
                            errList.Add(en);
                            errorMsg.AppendLine(errorMsgStr);
                            continue;
                        }
                        else
                        {
                            //是否网络课程
                            newSpecialtyCourse.IsNetworkCourse = generalPurpose.Value == (int)CF_GeneralPurpose.IsYes ? true : false;
                        }
                    }
                    //是否学位课程
                    if (string.IsNullOrWhiteSpace(en.IsMainCourseStr))
                    {
                        //是否学位课程(默认为否)
                        newSpecialtyCourse.IsMainCourse = false;
                    }
                    else
                    {
                        var generalPurpose = generalPurposeList.Where(x => x.Name == en.IsMainCourseStr.Trim()).SingleOrDefault();
                        if (generalPurpose == null)
                        {
                            errCount++;
                            errorMsgStr = "是否学位课程不存在，请检查";
                            en.ErrorMessage = errorMsgStr;
                            errList.Add(en);
                            errorMsg.AppendLine(errorMsgStr);
                            continue;
                        }
                        else
                        {
                            //是否学位课程
                            newSpecialtyCourse.IsMainCourse = generalPurpose.Value == (int)CF_GeneralPurpose.IsYes ? true : false;
                        }
                    }
                    //是否需要教材
                    if (string.IsNullOrWhiteSpace(en.IsNeedMaterialStr))
                    {
                        //是否需要教材(默认为是)
                        newSpecialtyCourse.IsNeedMaterial = true;
                    }
                    else
                    {
                        var generalPurpose = generalPurposeList.Where(x => x.Name == en.IsNeedMaterialStr.Trim()).SingleOrDefault();
                        if (generalPurpose == null)
                        {
                            errCount++;
                            errorMsgStr = "是否需要教材不存在，请检查";
                            en.ErrorMessage = errorMsgStr;
                            errList.Add(en);
                            errorMsg.AppendLine(errorMsgStr);
                            continue;
                        }
                        else
                        {
                            //是否需要教材
                            newSpecialtyCourse.IsNeedMaterial = generalPurpose.Value == (int)CF_GeneralPurpose.IsYes ? true : false;
                        }
                    }
                    //精品课程
                    if (string.IsNullOrWhiteSpace(en.CourseFineStr))
                    {
                        newSpecialtyCourse.CourseFineID = (int)CF_CourseFine.No;
                    }
                    else
                    {
                        var courseFine = courseFineList.Where(x => x.Name == en.CourseFineStr.Trim()).SingleOrDefault();
                        if (courseFine == null)
                        {
                            errCount++;
                            errorMsgStr = "精品课程不存在，请检查";
                            en.ErrorMessage = errorMsgStr;
                            errList.Add(en);
                            errorMsg.AppendLine(errorMsgStr);
                            continue;
                        }
                        else
                        {
                            //精品课程
                            newSpecialtyCourse.CourseFineID = courseFine.Value;
                        }
                    }
                    //实践类型
                    if (string.IsNullOrWhiteSpace(en.PracticeTypeStr))
                    {
                        //不考虑
                    }
                    else
                    {
                        var practiceType = practiceTypeList.Where(x => x.Name == en.PracticeTypeStr.Trim()).SingleOrDefault();
                        if (practiceType == null)
                        {
                            errCount++;
                            errorMsgStr = "实践类型不存在，请检查";
                            en.ErrorMessage = errorMsgStr;
                            errList.Add(en);
                            errorMsg.AppendLine(errorMsgStr);
                            continue;
                        }
                        else
                        {
                            //实践类型
                            newSpecialtyCourse.PracticeTypeID = practiceType.Value;
                        }
                    }
                    //授课语言
                    if (string.IsNullOrWhiteSpace(en.TeachinglanguageStr))
                    {
                        newSpecialtyCourse.TeachinglanguageID = (int)CF_Teachinglanguage.Chinese;
                    }
                    else
                    {
                        var teachinglanguage = teachinglanguageList.Where(x => x.Name == en.TeachinglanguageStr.Trim()).SingleOrDefault();
                        if (teachinglanguage == null)
                        {
                            errCount++;
                            errorMsgStr = "授课语言不存在，请检查";
                            en.ErrorMessage = errorMsgStr;
                            errList.Add(en);
                            errorMsg.AppendLine(errorMsgStr);
                            continue;
                        }
                        else
                        {
                            //授课语言
                            newSpecialtyCourse.TeachinglanguageID = teachinglanguage.Value;
                        }
                    }
                    //考试方式
                    if (string.IsNullOrWhiteSpace(en.ExaminationModeStr))
                    {
                        newSpecialtyCourse.ExaminationModeID = (int)CF_ExaminationMode.WrittenExam;
                    }
                    else
                    {
                        var examinationMode = examinationModeList.Where(x => x.Name == en.ExaminationModeStr.Trim()).SingleOrDefault();
                        if (examinationMode == null)
                        {
                            errCount++;
                            errorMsgStr = "考试方式不存在，请检查";
                            en.ErrorMessage = errorMsgStr;
                            errList.Add(en);
                            errorMsg.AppendLine(errorMsgStr);
                            continue;
                        }
                        else
                        {
                            //考试方式
                            newSpecialtyCourse.ExaminationModeID = examinationMode.Value;
                        }
                    }
                    //成绩类型
                    if (string.IsNullOrWhiteSpace(en.ResultTypeStr))
                    {
                        //默认为百分制
                        newSpecialtyCourse.ResultTypeID = (int)CF_ResultType.Percentage;
                    }
                    else
                    {
                        var resultType = resultTypeList.Where(x => x.Name == en.ResultTypeStr.Trim()).SingleOrDefault();
                        if (resultType == null)
                        {
                            errCount++;
                            errorMsgStr = "成绩类型不存在，请检查";
                            en.ErrorMessage = errorMsgStr;
                            errList.Add(en);
                            errorMsg.AppendLine(errorMsgStr);
                            continue;
                        }
                        else
                        {
                            //成绩类型
                            newSpecialtyCourse.ResultTypeID = resultType.Value;
                        }
                    }
                    //处理方式
                    if (string.IsNullOrWhiteSpace(en.HandleModeStr))
                    {
                        //默认为必修课
                        newSpecialtyCourse.HandleModeID = (int)CF_HandleMode.RequiredCourse;
                    }
                    else
                    {
                        var handleMode = handleModeList.Where(x => x.Name == en.HandleModeStr.Trim()).SingleOrDefault();
                        if (handleMode == null)
                        {
                            errCount++;
                            errorMsgStr = "处理方式不存在，请检查";
                            en.ErrorMessage = errorMsgStr;
                            errList.Add(en);
                            errorMsg.AppendLine(errorMsgStr);
                            continue;
                        }
                        else
                        {
                            //处理方式
                            newSpecialtyCourse.HandleModeID = handleMode.Value;
                        }
                    }
                    //授课方式
                    if (string.IsNullOrEmpty(en.TeachingModeIDListStr))
                    {
                        newModeTypeList.Add((int)CF_TeachingMode.Theory);
                    }
                    else
                    {
                        //授课方式可为多个(可用顿号隔开)
                        List<string> list = en.TeachingModeIDListStr.Split('、').Where(x => !string.IsNullOrEmpty(x))
                          .Select(x => x.Trim()).Distinct().ToList();
                        foreach (var item in list)
                        {
                            var teachingMode = teachingModeList.Where(x => x.Name == item.Trim()).SingleOrDefault();
                            if (teachingMode == null)
                            {
                                errCount++;
                                errorMsgStr = "授课方式（" + item.Trim() + "）不存在，请检查（存在多个授课方式时，可用顿号隔开）";
                                en.ErrorMessage = errorMsgStr;
                                errList.Add(en);
                                errorMsg.AppendLine(errorMsgStr);
                                isListPass = false;
                                break;
                            }
                        }
                        if (isListPass)
                        {
                            newModeTypeList = teachingModeList.Where(x => list.Contains(x.Name))
                                    .Select(x => x.Value.Value).ToList();
                        }
                        else
                        {
                            isListPass = true;
                            continue;
                        }
                    }
                    //授课地点
                    if (string.IsNullOrEmpty(en.TeachingPlaceIDListStr))
                    {
                        newPlaceList.Add((int)EMIS.ViewModel.EM_TeachingPlace.Multimedia);
                    }
                    else
                    {
                        //授课地点可为多个(可用顿号隔开)
                        List<string> list = en.TeachingPlaceIDListStr.Split('、').Where(x => !string.IsNullOrEmpty(x))
                          .Select(x => x.Trim()).Distinct().ToList();
                        foreach (var item in list)
                        {
                            var teachingPlace = teachingPlaceList.Where(x => x.Name == item.Trim()).SingleOrDefault();
                            if (teachingPlace == null)
                            {
                                errCount++;
                                errorMsgStr = "授课地点（" + item.Trim() + "）不存在，请检查（存在多个授课地点时，可用顿号隔开）";
                                en.ErrorMessage = errorMsgStr;
                                errList.Add(en);
                                errorMsg.AppendLine(errorMsgStr);
                                isListPass = false;
                                break;
                            }
                        }
                        if (isListPass)
                        {
                            newPlaceList = teachingPlaceList.Where(x => list.Contains(x.Name))
                                    .Select(x => x.Value.Value).ToList();
                        }
                        else
                        {
                            isListPass = true;
                            continue;
                        }
                    }
                    //是否启用（默认为是）
                    newSpecialtyCourse.IsEnable = true;
                    //备注
                    if (string.IsNullOrWhiteSpace(en.Remark))
                    {
                        //不考虑
                    }
                    else
                    {
                        newSpecialtyCourse.Remark = en.Remark;
                    }

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

                    //    //根据Excel表中的业务主键进行去重（专业信息ID、开课学期、课程信息ID唯一）
                    //    if (en.No == enA.No && en.Name == enA.Name)
                    //    {
                    //        //用于标识Excel表中的重复记录（由于是批量进行插入数据表）

                    //    }
                    //}

                    //数据表重复性验证（专业信息ID、开课学期、课程信息ID唯一）
                    var specialtyCourseVerify = newSpecialtyCourseList.Where(x => x.SpecialtyID == newSpecialtyCourse.SpecialtyID
                            && x.StarttermID == newSpecialtyCourse.StarttermID
                            && x.CoursematerialID == newSpecialtyCourse.CoursematerialID).SingleOrDefault();
                    if (specialtyCourseVerify == null)
                    {
                        //新增
                        if (!newSpecialtyCourseInList.Any(x => x.SpecialtyID == newSpecialtyCourse.SpecialtyID
                            && x.StarttermID == newSpecialtyCourse.StarttermID
                            && x.CoursematerialID == newSpecialtyCourse.CoursematerialID))
                        {
                            newSpecialtyCourse.SpecialtyCourseID = Guid.NewGuid();
                            SetNewStatus(newSpecialtyCourse);
                            newSpecialtyCourseInList.Add(newSpecialtyCourse);
                            newTeachingSetting.SpecialtyCourseID = newSpecialtyCourse.SpecialtyCourseID;
                            newTeachingSetting.TheoryWeeklyNum = 0;
                            newTeachingSetting.PracticeWeeklyNum = 0;
                            newTeachingSetting.TrialWeeklyNum = 0;
                            newTeachingSetting.WeeklyHours = 0;
                            newTeachingSetting.WeeklyNum = 0;
                            newTeachingSetting.StartWeeklyNum = 1;
                            newTeachingSetting.EndWeeklyNum = 18;
                            newTeachingSettingInList.Add(newTeachingSetting);
                            if (newModeTypeList != null && newModeTypeList.Count() > 0)
                            {
                                foreach (var newModeTypeID in newModeTypeList)
                                {
                                    var newTeachingModeType = new EM_TeachingModeType();
                                    newTeachingModeType.TeachingModeTypeID = Guid.NewGuid();
                                    newTeachingModeType.SpecialtyCourseID = newSpecialtyCourse.SpecialtyCourseID;
                                    newTeachingModeType.TeachingModeID = newModeTypeID;
                                    this.SetNewStatus(newTeachingModeType);
                                    newTeachingModeTypeInList.Add(newTeachingModeType);
                                }
                            }
                            if (newPlaceList != null && newPlaceList.Count() > 0)
                            {
                                foreach (var newPlaceID in newPlaceList)
                                {
                                    var newTeachingPlace = new EMIS.Entities.EM_TeachingPlace();
                                    newTeachingPlace.TeachingPlaceID = Guid.NewGuid();
                                    newTeachingPlace.SpecialtyCourseID = newSpecialtyCourse.SpecialtyCourseID;
                                    newTeachingPlace.TeachingPlace = newPlaceID;
                                    this.SetNewStatus(newTeachingPlace);
                                    newTeachingPlaceInList.Add(newTeachingPlace);
                                }
                            }
                            inCount++;
                        }
                        else
                        {
                            //Excel表重复性验证
                            //（注：当数据表中没有此记录，但是Excel中有重复数据,可在此处进行抛出到失败数据文件中,目前暂不考虑）
                            inCount++;
                        }
                    }
                    else
                    {
                        //更新(Excel有重复时，以最后一条记录的更新为准)
                        specialtyCourseVerify.CourseStructureID = newSpecialtyCourse.CourseStructureID;
                        specialtyCourseVerify.CourseCategoryID = newSpecialtyCourse.CourseCategoryID;
                        specialtyCourseVerify.CourseTypeID = newSpecialtyCourse.CourseTypeID;
                        specialtyCourseVerify.CourseQualityID = newSpecialtyCourse.CourseQualityID;
                        specialtyCourseVerify.DepartmentID = newSpecialtyCourse.DepartmentID;
                        specialtyCourseVerify.IsSpecialtycore = newSpecialtyCourse.IsSpecialtycore;
                        specialtyCourseVerify.IsCooperation = newSpecialtyCourse.IsCooperation;
                        specialtyCourseVerify.IsRequired = newSpecialtyCourse.IsRequired;
                        specialtyCourseVerify.IsElective = newSpecialtyCourse.IsElective;
                        specialtyCourseVerify.IsNetworkCourse = newSpecialtyCourse.IsNetworkCourse;
                        specialtyCourseVerify.IsMainCourse = newSpecialtyCourse.IsMainCourse;
                        specialtyCourseVerify.IsNeedMaterial = newSpecialtyCourse.IsNeedMaterial;
                        specialtyCourseVerify.CourseFineID = newSpecialtyCourse.CourseFineID;
                        specialtyCourseVerify.PracticeTypeID = newSpecialtyCourse.PracticeTypeID;
                        specialtyCourseVerify.TeachinglanguageID = newSpecialtyCourse.TeachinglanguageID;
                        specialtyCourseVerify.ExaminationModeID = newSpecialtyCourse.ExaminationModeID;
                        specialtyCourseVerify.ResultTypeID = newSpecialtyCourse.ResultTypeID;
                        specialtyCourseVerify.HandleModeID = newSpecialtyCourse.HandleModeID;
                        //specialtyCourseVerify.IsEnable = newSpecialtyCourse.IsEnable;
                        specialtyCourseVerify.Remark = newSpecialtyCourse.Remark;
                        SetModifyStatus(specialtyCourseVerify);
                        newSpecialtyCourseUpList.Add(specialtyCourseVerify);
                        if (specialtyCourseVerify.EM_SpecialtyCourseTeachingSetting == null)
                        {
                            if (newTeachingSettingInList.Any(x => x.SpecialtyCourseID == specialtyCourseVerify.SpecialtyCourseID))
                            {
                                newTeachingSettingInList.RemoveAll(x => x.SpecialtyCourseID == specialtyCourseVerify.SpecialtyCourseID);
                            }
                            newTeachingSetting.SpecialtyCourseID = specialtyCourseVerify.SpecialtyCourseID;
                            newTeachingSetting.TheoryWeeklyNum = 0;
                            newTeachingSetting.PracticeWeeklyNum = 0;
                            newTeachingSetting.TrialWeeklyNum = 0;
                            newTeachingSetting.WeeklyHours = 0;
                            newTeachingSetting.WeeklyNum = 0;
                            newTeachingSetting.StartWeeklyNum = 1;
                            newTeachingSetting.EndWeeklyNum = 16;
                            newTeachingSettingInList.Add(newTeachingSetting);
                        }
                        else
                        {
                            specialtyCourseVerify.EM_SpecialtyCourseTeachingSetting.Credit = newTeachingSetting.Credit;
                            specialtyCourseVerify.EM_SpecialtyCourseTeachingSetting.TheoryCourse = newTeachingSetting.TheoryCourse;
                            specialtyCourseVerify.EM_SpecialtyCourseTeachingSetting.Practicehours = newTeachingSetting.Practicehours;
                            specialtyCourseVerify.EM_SpecialtyCourseTeachingSetting.Trialhours = newTeachingSetting.Trialhours;
                            newTeachingSettingUpList.Add(specialtyCourseVerify.EM_SpecialtyCourseTeachingSetting);
                        }
                        if (newModeTypeList != null && newModeTypeList.Count() > 0)
                        {
                            if (newTeachingModeTypeInList.Any(x => x.SpecialtyCourseID == specialtyCourseVerify.SpecialtyCourseID))
                            {
                                newTeachingModeTypeInList.RemoveAll(x => x.SpecialtyCourseID == specialtyCourseVerify.SpecialtyCourseID);
                            }
                            specialtyCourseTMDelList.Add(specialtyCourseVerify.SpecialtyCourseID);
                            foreach (var newModeTypeID in newModeTypeList)
                            {
                                var newTeachingModeType = new EM_TeachingModeType();
                                newTeachingModeType.TeachingModeTypeID = Guid.NewGuid();
                                newTeachingModeType.SpecialtyCourseID = specialtyCourseVerify.SpecialtyCourseID;
                                newTeachingModeType.TeachingModeID = newModeTypeID;
                                this.SetNewStatus(newTeachingModeType);
                                newTeachingModeTypeInList.Add(newTeachingModeType);
                            }
                        }
                        else
                        {
                            specialtyCourseTMDelList.Add(specialtyCourseVerify.SpecialtyCourseID);
                        }
                        if (newPlaceList != null && newPlaceList.Count() > 0)
                        {
                            if (newTeachingPlaceInList.Any(x => x.SpecialtyCourseID == specialtyCourseVerify.SpecialtyCourseID))
                            {
                                newTeachingPlaceInList.RemoveAll(x => x.SpecialtyCourseID == specialtyCourseVerify.SpecialtyCourseID);
                            }
                            specialtyCourseTPDelList.Add(specialtyCourseVerify.SpecialtyCourseID);
                            foreach (var newPlace in newPlaceList)
                            {
                                var newTeachingPlace = new EMIS.Entities.EM_TeachingPlace();
                                newTeachingPlace.TeachingPlaceID = Guid.NewGuid();
                                newTeachingPlace.SpecialtyCourseID = specialtyCourseVerify.SpecialtyCourseID;
                                newTeachingPlace.TeachingPlace = newPlace;
                                this.SetNewStatus(newTeachingPlace);
                                newTeachingPlaceInList.Add(newTeachingPlace);
                            }
                        }
                        else
                        {
                            specialtyCourseTPDelList.Add(specialtyCourseVerify.SpecialtyCourseID);
                        }
                        upCount++;
                    }
                }
                using (TransactionScope ts = new TransactionScope())
                {
                    //删除
                    UnitOfWork.Delete<EMIS.Entities.EM_TeachingPlace>(x => specialtyCourseTPDelList.Contains(x.SpecialtyCourseID));
                    UnitOfWork.Delete<EM_TeachingModeType>(x => specialtyCourseTMDelList.Contains(x.SpecialtyCourseID));
                    //批量插入
                    UnitOfWork.BulkInsert(newSpecialtyCourseInList);
                    UnitOfWork.BulkInsert(newTeachingSettingInList);
                    UnitOfWork.BulkInsert(newTeachingModeTypeInList);
                    UnitOfWork.BulkInsert(newTeachingPlaceInList);
                    //批量统一提交更新
                    if (newSpecialtyCourseUpList != null && newSpecialtyCourseUpList.Count() > 0)
                    {
                        UnitOfWork.BatchUpdate(newSpecialtyCourseUpList);
                    }
                    //批量统一提交更新
                    if (newTeachingSettingUpList != null && newTeachingSettingUpList.Count() > 0)
                    {
                        UnitOfWork.BatchUpdate(newTeachingSettingUpList);
                    }
                    ts.Complete();
                }
                errdataList = errList.Distinct().ToList(); //错误列表List
            }
            catch (Exception)
            {
                throw;
            }
        }

    }
}