JW/ServiceLogic/EMIS.CommonLogic/UniversityManage/SpecialtyClassManage/ClassmajorServices.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Linq.Expressions;
using System.Text;
using System.Text.RegularExpressions;
using System.Transactions;
using Bowin.Common.Linq;
using Bowin.Common.Linq.Entity;
using Bowin.Common.Utility;
using EMIS.Entities;
using EMIS.Utility;
using EMIS.ViewModel;
using EMIS.ViewModel.UniversityManage.SpecialtyClassManage;
using EMIS.ViewModel.StudentManage.StudentProfile;
using EMIS.DataLogic.UniversityManage.SpecialtyClassManage;
using EMIS.CommonLogic.StudentManage.StudentStatistics;
using EMIS.CommonLogic.UniversityManage.TeacherManage;
using EMIS.CommonLogic.CalendarManage;

namespace EMIS.CommonLogic.UniversityManage.SpecialtyClassManage
{
    public class ClassmajorServices : BaseServices, IClassmajorServices
    {
        public ClassmajorDAL ClassmajorDAL { get; set; }
        public GrademajorDAL GrademajorDAL { get; set; }
        public Lazy<IInSchoolSettingServices> InSchoolSettingServices { get; set; }
        public Lazy<IStaffServices> StaffServices { get; set; }
        public Lazy<ISchoolYearServices> SchoolYearServices { get; set; }

        /// <summary>
        /// 查询对应的班级信息View
        /// </summary>
        /// <param name="configuretView"></param>
        /// <param name="campusID"></param>
        /// <param name="collegeID"></param>
        /// <param name="gradeID"></param>
        /// <param name="standardID"></param>
        /// <param name="educationID"></param>
        /// <param name="learningformID"></param>
        /// <param name="learnSystem"></param>
        /// <param name="grademajorID"></param>
        /// <param name="semesterID"></param>
        /// <param name="inSchoolStatus"></param>
        /// <param name="pageIndex"></param>
        /// <param name="pageSize"></param>
        /// <returns></returns>
        public IGridResultSet<ClassmajorView> GetClassmajorViewGrid(ConfiguretView configuretView, Guid? campusID, Guid? collegeID, int? gradeID, int? standardID,
                int? educationID, int? learningformID, string learnSystem, Guid? grademajorID, int? semesterID, int? inSchoolStatus, int pageIndex, int pageSize)
        {
            Expression<Func<CF_Classmajor, bool>> expClassmajor = (x => x.RecordStatus > (int)SYS_STATUS.UNUSABLE);
            if (grademajorID.HasValue)
            {
                expClassmajor = expClassmajor.And(x => x.GrademajorID == grademajorID);
            }
            Expression<Func<CF_Student, bool>> expStudent = (x => x.RecordStatus > (int)SYS_STATUS.UNUSABLE);
            if (inSchoolStatus != null && inSchoolStatus > -1)
            {
                var inschoolStatusList = InSchoolSettingServices.Value.GetInschoolStatusList(true);
                if (inSchoolStatus == 1)
                {
                    //表示在校
                    expStudent = expStudent.And(x => inschoolStatusList.Contains(x.InSchoolStatusID));
                }
                if (inSchoolStatus == 0)
                {
                    //不在校
                    expStudent = expStudent.And(x => !inschoolStatusList.Contains(x.InSchoolStatusID));
                }
            }
            var query = ClassmajorDAL.GetClassmajorViewQueryable(expClassmajor, expStudent);
            if (campusID.HasValue)
            {
                query = query.Where(x => x.CampusID == campusID);
            }
            if (collegeID.HasValue)
            {
                query = query.Where(x => x.CollegeID == collegeID);
            }
            if (gradeID.HasValue)
            {
                query = query.Where(x => x.GradeID == gradeID);
            }
            if (standardID.HasValue)
            {
                query = query.Where(x => x.StandardID == standardID);
            }
            if (educationID.HasValue)
            {
                query = query.Where(x => x.EducationID == educationID);
            }
            if (learningformID.HasValue)
            {
                query = query.Where(x => x.LearningformID == learningformID);
            }
            if (!string.IsNullOrEmpty(learnSystem) && learnSystem != "-1")
            {
                var LearnSystems = Convert.ToDecimal(learnSystem);
                query = query.Where(x => x.LearnSystem == LearnSystems);
            }
            if (semesterID.HasValue)
            {
                query = query.Where(x => x.SemesterID == semesterID);
            }
            //if (inSchoolStatus != null && inSchoolStatus > -1)
            //{
            //    //排除人数为0的信息
            //    query = query.Where(x => x.StudentCount > 0);
            //}

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

            return this.GetQueryByAssistant(query, null, this.GetQueryByDataRangeByCollege(query)).OrderBy(x => x.CollegeCode.Length).ThenBy(x => x.CollegeCode)
                    .ThenByDescending(x => x.GrademajorCode.Length).ThenByDescending(x => x.GrademajorCode).ThenByDescending(x => x.GradeID)
                    .ThenBy(x => x.StandardID).ThenBy(x => x.No.Length).ThenBy(x => x.No).ToGridResultSet<ClassmajorView>(pageIndex, pageSize);
        }

        /// <summary>
        /// 查询对应的班级信息List
        /// </summary>
        /// <param name="configuretView"></param>
        /// <param name="campusID"></param>
        /// <param name="collegeID"></param>
        /// <param name="gradeID"></param>
        /// <param name="standardID"></param>
        /// <param name="educationID"></param>
        /// <param name="learningformID"></param>
        /// <param name="learnSystem"></param>
        /// <param name="grademajorID"></param>
        /// <param name="semesterID"></param>
        /// <param name="inSchoolStatus"></param>
        /// <returns></returns>
        public IList<ClassmajorView> GetClassmajorViewList(ConfiguretView configuretView, Guid? campusID, Guid? collegeID, int? gradeID, int? standardID, 
                int? educationID, int? learningformID, string learnSystem, Guid? grademajorID, int? semesterID, int? inSchoolStatus)
        {
            Expression<Func<CF_Classmajor, bool>> expClassmajor = (x => x.RecordStatus > (int)SYS_STATUS.UNUSABLE);
            if (grademajorID.HasValue)
            {
                expClassmajor = expClassmajor.And(x => x.GrademajorID == grademajorID);
            }
            Expression<Func<CF_Student, bool>> expStudent = (x => x.RecordStatus > (int)SYS_STATUS.UNUSABLE);
            if (inSchoolStatus != null && inSchoolStatus > -1)
            {
                var inschoolStatusList = InSchoolSettingServices.Value.GetInschoolStatusList(true);
                if (inSchoolStatus == 1)
                {
                    //表示在校
                    expStudent = expStudent.And(x => inschoolStatusList.Contains(x.InSchoolStatusID));
                }
                if (inSchoolStatus == 0)
                {
                    //不在校
                    expStudent = expStudent.And(x => !inschoolStatusList.Contains(x.InSchoolStatusID));
                }
            }
            var query = ClassmajorDAL.GetClassmajorViewQueryable(expClassmajor, expStudent);
            if (campusID.HasValue)
            {
                query = query.Where(x => x.CampusID == campusID);
            }
            if (collegeID.HasValue)
            {
                query = query.Where(x => x.CollegeID == collegeID);
            }
            if (gradeID.HasValue)
            {
                query = query.Where(x => x.GradeID == gradeID);
            }
            if (standardID.HasValue)
            {
                query = query.Where(x => x.StandardID == standardID);
            }
            if (educationID.HasValue)
            {
                query = query.Where(x => x.EducationID == educationID);
            }
            if (learningformID.HasValue)
            {
                query = query.Where(x => x.LearningformID == learningformID);
            }
            if (!string.IsNullOrEmpty(learnSystem) && learnSystem != "-1")
            {
                var LearnSystems = Convert.ToDecimal(learnSystem);
                query = query.Where(x => x.LearnSystem == LearnSystems);
            }
            if (semesterID.HasValue)
            {
                query = query.Where(x => x.SemesterID == semesterID);
            }
            //if (inSchoolStatus != null && inSchoolStatus > -1)
            //{
            //    //排除人数为0的信息
            //    query = query.Where(x => x.StudentCount > 0);
            //}

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

            return this.GetQueryByAssistant(query, null, this.GetQueryByDataRangeByCollege(query)).OrderBy(x => x.CollegeCode.Length).ThenBy(x => x.CollegeCode)
                    .ThenByDescending(x => x.GrademajorCode.Length).ThenByDescending(x => x.GrademajorCode).ThenByDescending(x => x.GradeID)
                    .ThenBy(x => x.StandardID).ThenBy(x => x.No.Length).ThenBy(x => x.No).ToList();
        }

        /// <summary>
        /// 查询对应的班级信息View（在校）
        /// </summary>
        /// <param name="configuretView"></param>
        /// <param name="campusID"></param>
        /// <param name="collegeID"></param>
        /// <param name="gradeID"></param>
        /// <param name="standardID"></param>
        /// <param name="educationID"></param>
        /// <param name="learningformID"></param>
        /// <param name="learnSystem"></param>
        /// <param name="grademajorID"></param>
        /// <param name="pageIndex"></param>
        /// <param name="pageSize"></param>
        /// <returns></returns>
        public IGridResultSet<ClassmajorView> GetClassmajorViewForInschoolGrid(ConfiguretView configuretView, Guid? campusID, Guid? collegeID, int? gradeID, int? standardID, 
                int? educationID, int? learningformID, string learnSystem, Guid? grademajorID, int pageIndex, int pageSize)
        {
            Expression<Func<CF_Classmajor, bool>> expClassmajor = (x => x.RecordStatus > (int)SYS_STATUS.UNUSABLE);
            if (grademajorID.HasValue)
            {
                expClassmajor = expClassmajor.And(x => x.GrademajorID == grademajorID);
            }
            Expression<Func<CF_Student, bool>> expStudent = (x => x.RecordStatus > (int)SYS_STATUS.UNUSABLE);
            var inschoolStatusList = InSchoolSettingServices.Value.GetInschoolStatusList(true);
            expClassmajor = expClassmajor.And(x => x.CF_Student.Any(w => inschoolStatusList.Contains(w.InSchoolStatusID)));
            var query = ClassmajorDAL.GetClassmajorViewQueryable(expClassmajor, expStudent);
            if (campusID.HasValue)
            {
                query = query.Where(x => x.CampusID == campusID);
            }
            if (collegeID.HasValue)
            {
                query = query.Where(x => x.CollegeID == collegeID);
            }
            if (gradeID.HasValue)
            {
                query = query.Where(x => x.GradeID == gradeID);
            }
            if (standardID.HasValue)
            {
                query = query.Where(x => x.StandardID == standardID);
            }
            if (educationID.HasValue)
            {
                query = query.Where(x => x.EducationID == educationID);
            }
            if (learningformID.HasValue)
            {
                query = query.Where(x => x.LearningformID == learningformID);
            }
            if (!string.IsNullOrEmpty(learnSystem) && learnSystem != "-1")
            {
                var LearnSystems = Convert.ToDecimal(learnSystem);
                query = query.Where(x => x.LearnSystem == LearnSystems);
            }
            //排除人数为0的信息
            query = query.Where(x => x.StudentCount > 0);

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

            return this.GetQueryByAssistant(query, null, query).OrderBy(x => x.CollegeCode.Length).ThenBy(x => x.CollegeCode)
                    .ThenByDescending(x => x.GrademajorCode.Length).ThenByDescending(x => x.GrademajorCode).ThenByDescending(x => x.GradeID)
                    .ThenBy(x => x.StandardID).ThenBy(x => x.No.Length).ThenBy(x => x.No).ToGridResultSet<ClassmajorView>(pageIndex, pageSize);
        }

        /// <summary>
        /// 查询对应的班级信息List（在校）
        /// </summary>
        /// <param name="configuretView"></param>
        /// <param name="campusID"></param>
        /// <param name="collegeID"></param>
        /// <param name="gradeID"></param>
        /// <param name="standardID"></param>
        /// <param name="educationID"></param>
        /// <param name="learningformID"></param>
        /// <param name="learnSystem"></param>
        /// <param name="grademajorID"></param>
        /// <returns></returns>
        public IList<ClassmajorView> GetClassmajorViewForInschoolList(ConfiguretView configuretView, Guid? campusID, Guid? collegeID, int? gradeID, int? standardID,
                int? educationID, int? learningformID, string learnSystem, Guid? grademajorID)
        {
            Expression<Func<CF_Classmajor, bool>> expClassmajor = (x => x.RecordStatus > (int)SYS_STATUS.UNUSABLE);
            if (grademajorID.HasValue)
            {
                expClassmajor = expClassmajor.And(x => x.GrademajorID == grademajorID);
            }
            Expression<Func<CF_Student, bool>> expStudent = (x => x.RecordStatus > (int)SYS_STATUS.UNUSABLE);
            var inschoolStatusList = InSchoolSettingServices.Value.GetInschoolStatusList(true);
            expClassmajor = expClassmajor.And(x => x.CF_Student.Any(w => inschoolStatusList.Contains(w.InSchoolStatusID)));
            var query = ClassmajorDAL.GetClassmajorViewQueryable(expClassmajor, expStudent);
            if (campusID.HasValue)
            {
                query = query.Where(x => x.CampusID == campusID);
            }
            if (collegeID.HasValue)
            {
                query = query.Where(x => x.CollegeID == collegeID);
            }
            if (gradeID.HasValue)
            {
                query = query.Where(x => x.GradeID == gradeID);
            }
            if (standardID.HasValue)
            {
                query = query.Where(x => x.StandardID == standardID);
            }
            if (educationID.HasValue)
            {
                query = query.Where(x => x.EducationID == educationID);
            }
            if (learningformID.HasValue)
            {
                query = query.Where(x => x.LearningformID == learningformID);
            }
            if (!string.IsNullOrEmpty(learnSystem) && learnSystem != "-1")
            {
                var LearnSystems = Convert.ToDecimal(learnSystem);
                query = query.Where(x => x.LearnSystem == LearnSystems);
            }
            //排除人数为0的信息
            query = query.Where(x => x.StudentCount > 0);

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

            return this.GetQueryByAssistant(query, null, query).OrderBy(x => x.CollegeCode.Length).ThenBy(x => x.CollegeCode)
                    .ThenByDescending(x => x.GrademajorCode.Length).ThenByDescending(x => x.GrademajorCode).ThenByDescending(x => x.GradeID)
                    .ThenBy(x => x.StandardID).ThenBy(x => x.No.Length).ThenBy(x => x.No).ToList();
        }

        /// <summary>
        /// 查询对应的班级信息View(带毕业学期)
        /// </summary>
        /// <param name="configuretView"></param>
        /// <param name="collegeID"></param>
        /// <param name="gradeID"></param>
        /// <param name="standardID"></param>
        /// <param name="educationID"></param>
        /// <param name="learningformID"></param>
        /// <param name="learnSystem"></param>
        /// <param name="graduateSchoolyearID"></param>
        /// <param name="pageIndex"></param>
        /// <param name="pageSize"></param>
        /// <returns></returns>
        public IGridResultSet<ClassmajorView> GetClassmajorViewForGraduateGrid(ConfiguretView configuretView, Guid? collegeID, int? gradeID, int? standardID,
                int? educationID, int? learningformID, string learnSystem, Guid? graduateSchoolyearID, int pageIndex, int pageSize)
        {
            Expression<Func<CF_Classmajor, bool>> expClassmajor = (x => x.RecordStatus > (int)SYS_STATUS.UNUSABLE);
            var query = ClassmajorDAL.GetClassmajorViewQueryable(expClassmajor);
            if (collegeID.HasValue)
            {
                query = query.Where(x => x.CollegeID == collegeID);
            }
            if (gradeID.HasValue)
            {
                query = query.Where(x => x.GradeID == gradeID);
            }
            if (standardID.HasValue)
            {
                query = query.Where(x => x.StandardID == standardID);
            }
            if (educationID.HasValue)
            {
                query = query.Where(x => x.EducationID == educationID);
            }
            if (learningformID.HasValue)
            {
                query = query.Where(x => x.LearningformID == learningformID);
            }
            if (!string.IsNullOrEmpty(learnSystem) && learnSystem != "-1")
            {
                var LearnSystems = Convert.ToDecimal(learnSystem);
                query = query.Where(x => x.LearnSystem == LearnSystems);
            }
            if (graduateSchoolyearID.HasValue)
            {
                query = query.Where(x => x.GraduateSchoolyearID == graduateSchoolyearID);
            }

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

            return this.GetQueryByAssistant(query, null, this.GetQueryByDataRangeByCollege(query)).OrderBy(x => x.CollegeCode.Length).ThenBy(x => x.CollegeCode)
                    .ThenByDescending(x => x.GrademajorCode.Length).ThenByDescending(x => x.GrademajorCode).ThenByDescending(x => x.GradeID)
                    .ThenBy(x => x.StandardID).ThenBy(x => x.No.Length).ThenBy(x => x.No).ToGridResultSet<ClassmajorView>(pageIndex, pageSize);
        }

        /// <summary>
        /// 查询对应的班级信息List(带毕业学期)
        /// </summary>
        /// <param name="configuretView"></param>
        /// <param name="collegeID"></param>
        /// <param name="gradeID"></param>
        /// <param name="standardID"></param>
        /// <param name="educationID"></param>
        /// <param name="learningformID"></param>
        /// <param name="learnSystem"></param>
        /// <param name="graduateSchoolyearID"></param>
        /// <returns></returns>
        public IList<ClassmajorView> GetClassmajorViewForGraduateList(ConfiguretView configuretView, Guid? collegeID, int? gradeID, int? standardID,
                int? educationID, int? learningformID, string learnSystem, Guid? graduateSchoolyearID)
        {
            Expression<Func<CF_Classmajor, bool>> expClassmajor = (x => x.RecordStatus > (int)SYS_STATUS.UNUSABLE);
            var query = ClassmajorDAL.GetClassmajorViewQueryable(expClassmajor);
            if (collegeID.HasValue)
            {
                query = query.Where(x => x.CollegeID == collegeID);
            }
            if (gradeID.HasValue)
            {
                query = query.Where(x => x.GradeID == gradeID);
            }
            if (standardID.HasValue)
            {
                query = query.Where(x => x.StandardID == standardID);
            }
            if (educationID.HasValue)
            {
                query = query.Where(x => x.EducationID == educationID);
            }
            if (learningformID.HasValue)
            {
                query = query.Where(x => x.LearningformID == learningformID);
            }
            if (!string.IsNullOrEmpty(learnSystem) && learnSystem != "-1")
            {
                var LearnSystems = Convert.ToDecimal(learnSystem);
                query = query.Where(x => x.LearnSystem == LearnSystems);
            }
            if (graduateSchoolyearID.HasValue)
            {
                query = query.Where(x => x.GraduateSchoolyearID == graduateSchoolyearID);
            }

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

            return this.GetQueryByAssistant(query, null, this.GetQueryByDataRangeByCollege(query)).OrderBy(x => x.CollegeCode.Length).ThenBy(x => x.CollegeCode)
                    .ThenByDescending(x => x.GrademajorCode.Length).ThenByDescending(x => x.GrademajorCode).ThenByDescending(x => x.GradeID)
                    .ThenBy(x => x.StandardID).ThenBy(x => x.No.Length).ThenBy(x => x.No).ToList();
        }

        /// <summary>
        /// 查询对应的班级信息List（带数据范围）
        /// </summary>
        /// <param name="collegeID"></param>
        /// <param name="gradeID"></param>
        /// <param name="standardID"></param>
        /// <returns></returns>
        public List<CF_Classmajor> GetClassmajorList(Guid? collegeID, int? gradeID, int? standardID)
        {
            Expression<Func<CF_Classmajor, bool>> expClassmajor = (x => x.RecordStatus > (int)SYS_STATUS.UNUSABLE);
            if (collegeID.HasValue)
            {
                expClassmajor = expClassmajor.And(x => x.CF_Grademajor.CF_Facultymajor.CollegeID == collegeID);
            }
            if (gradeID.HasValue)
            {
                expClassmajor = expClassmajor.And(x => x.CF_Grademajor.GradeID == gradeID);
            }
            if (standardID.HasValue)
            {
                expClassmajor = expClassmajor.And(x => x.CF_Grademajor.CF_Facultymajor.StandardID == standardID);
            }

            var query = ClassmajorDAL.ClassmajorRepository.GetList(expClassmajor);

            return this.GetQueryByAssistant(query, null, this.GetQueryByDataRangeByCollege(query)).OrderBy(x => x.No.Length).ThenBy(x => x.No).ToList();
        }

        /// <summary>
        /// 根据年级专业信息ID查询对应的班级信息List
        /// </summary>
        /// <param name="grademajorID"></param>
        /// <returns></returns>
        public List<CF_Classmajor> GetClassmajorByGrademajorIDList(Guid? grademajorID)
        {
            try
            {
                var query = ClassmajorDAL.ClassmajorRepository.GetList(x => x.GrademajorID == grademajorID);

                return query.OrderBy(x => x.No.Length).ThenBy(x => x.No).ToList();
            }
            catch (Exception ex)
            {
                throw new Exception(ex.Message);
            }
        }

        /// <summary>
        /// 查询对应的班级信息CF_Classmajor
        /// </summary>
        /// <param name="classmajorID"></param>
        /// <returns></returns>
        public CF_Classmajor GetClassmajorInfo(Guid? classmajorID)
        {
            try
            {
                var query = ClassmajorDAL.ClassmajorRepository.GetList(x => x.ClassmajorID == classmajorID).SingleOrDefault();

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

        /// <summary>
        /// 查询对应的班级信息ClassmajorView
        /// </summary>
        /// <param name="classmajorID"></param>
        /// <returns></returns>
        public ClassmajorView GetClassmajorView(Guid? classmajorID)
        {
            try
            {
                var query = ClassmajorDAL.GetClassmajorViewQueryable(x => x.ClassmajorID == classmajorID).SingleOrDefault();

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

        /// <summary>
        /// 编辑（新增、修改，业务主键：班级编号或班级名称唯一）
        /// </summary>
        /// <param name="classmajorView"></param>
        public void ClassmajorEdit(ClassmajorView classmajorView)
        {
            try
            {
                //查询数据库进行验证
                var classmajorVerify = ClassmajorDAL.ClassmajorRepository.GetList(x => x.ClassmajorID != classmajorView.ClassmajorID 
                        && (x.No == classmajorView.No || x.Name == classmajorView.Name)).FirstOrDefault();
                if (classmajorVerify == null)
                {
                    //数据有误验证
                    if (classmajorView.ClassmajorID != Guid.Empty)
                    {
                        var classmajor = ClassmajorDAL.ClassmajorRepository.GetList(x => x.ClassmajorID == classmajorView.ClassmajorID, x => x.CF_Student).SingleOrDefault();
                        if (classmajor == null)
                        {
                            throw new Exception("数据有误，请核查");
                        }
                        else
                        {
                            //表示修改
                            classmajor.GrademajorID = classmajorView.GrademajorID;
                            classmajor.No = classmajorView.No.Trim();
                            classmajor.Name = classmajorView.Name;
                            classmajor.Abbreviation = classmajorView.Abbreviation;
                            classmajor.EnglishName = classmajorView.EnglishName;
                            classmajor.ClassNum = classmajorView.ClassNum;
                            classmajor.UserID = classmajorView.UserID;
                            classmajor.AssistantUserID = classmajorView.AssistantUserID;
                            classmajor.Fixedclassroom = classmajorView.Fixedclassroom;
                            classmajor.Remark = classmajorView.Remark;
                            SetModifyStatus(classmajor);
                            //计算对应学生的拟毕业时间
                            var grademajor = this.ClassmajorDAL.GrademajorRepository.GetSingle(x => x.GrademajorID == classmajor.GrademajorID);
                            if (grademajor == null)
                            {
                                throw new Exception("年级专业有误，请重新选择。");
                            }
                            else
                            {
                                if (grademajor.GraduateSchoolyearID == null)
                                {
                                    throw new Exception("年级专业信息中毕业学期有误，请核查。");
                                }
                            }
                            //这里应该用新的学年学期来算学生的拟毕业时间，原来的逻辑是用旧的……
                            var schoolyearView = SchoolYearServices.Value.GetSchoolYearView(grademajor.GraduateSchoolyearID);
                            if (EMIS.Utility.Const.LOCAL_SETTING_PlanningGraduateDateSpringMonth == null)
                            {
                                throw new Exception("请先设置配置文件的预计毕业月份（春季入学）。");
                            }
                            if (EMIS.Utility.Const.LOCAL_SETTING_PlanningGraduateDateSpringDay == null)
                            {
                                throw new Exception("请先设置配置文件的预计毕业日期（春季入学）。");
                            }
                            if (EMIS.Utility.Const.LOCAL_SETTING_PlanningGraduateDateAutumnMonth == null)
                            {
                                throw new Exception("请先设置配置文件的预计毕业月份（秋季入学）。");
                            }
                            if (EMIS.Utility.Const.LOCAL_SETTING_PlanningGraduateDateAutumnDay == null)
                            {
                                throw new Exception("请先设置配置文件的预计毕业日期（秋季入学）。");
                            }
                            List<CF_Student> studentUpList = new List<CF_Student>();
                            foreach (var item in classmajor.CF_Student)
                            {
                                item.PlanningGraduateDate = PlanningGraduateDateHelper.GetPlanningGraduateDate(schoolyearView.FirstWeek.Value);
                                studentUpList.Add(item);
                            }
                            //事务提交
                            UnitOfWork.Commit();
                            //批量统一提交更新(预计毕业日期)
                            if (studentUpList != null && studentUpList.Count() > 0)
                            {
                                UnitOfWork.BatchUpdate(studentUpList);
                            }
                        }
                    }
                    else
                    {
                        //表示新增
                        CF_Classmajor classmajor = new CF_Classmajor();
                        classmajor.ClassmajorID = Guid.NewGuid();
                        classmajor.GrademajorID = classmajorView.GrademajorID;
                        classmajor.No = classmajorView.No.Trim();
                        classmajor.Name = classmajorView.Name;
                        classmajor.Abbreviation = classmajorView.Abbreviation;
                        classmajor.EnglishName = classmajorView.EnglishName;
                        classmajor.ClassNum = classmajorView.ClassNum;
                        classmajor.UserID = classmajorView.UserID;
                        classmajor.AssistantUserID = classmajorView.AssistantUserID;
                        classmajor.Fixedclassroom = classmajorView.Fixedclassroom;
                        classmajor.Remark = classmajorView.Remark;
                        SetNewStatus(classmajor);
                        UnitOfWork.Add(classmajor);
                        //事务提交
                        UnitOfWork.Commit();
                    }
                }
                else
                {
                    throw new Exception("已存在相同的班级编号或班级名称，请核查");
                }
            }
            catch (Exception ex)
            {
                throw new Exception(ex.Message);
            }
        }

        /// <summary>
        /// 批量新增
        /// </summary>
        /// <param name="classmajorView"></param>
        /// <returns></returns>
        public string ClassmajorBatchAdd(ClassmajorView classmajorView)
        {
            try
            {
                List<CF_Classmajor> ClassmajorList = new List<CF_Classmajor>();
                //获取源数据
                var Grademajor = GrademajorDAL.GetGrademajorViwQueryable(x => x.GradeID == classmajorView.BatchGradeID);
                if (classmajorView.CollegeID != null)
                {
                    Grademajor = Grademajor.Where(x => x.CollegeID == classmajorView.CollegeID);
                }
                if (classmajorView.StandardID != null && classmajorView.StandardID != -1)
                {
                    Grademajor = Grademajor.Where(x => x.StandardID == classmajorView.StandardID);
                }
                //获取目标年级对应的年级专业
                var GrademajorList = Grademajor.ToList();
                //获取班级
                var SourceClass = ClassmajorDAL.GetClassmajorViewQueryable(x => true);
                if (classmajorView.CollegeID != null)
                {
                    SourceClass = SourceClass.Where(x => x.CollegeID == classmajorView.CollegeID);
                }
                if (classmajorView.StandardID != null && classmajorView.StandardID != -1)
                {
                    SourceClass = SourceClass.Where(x => x.StandardID == classmajorView.StandardID);
                }
                if (classmajorView.GradeID != null)
                {
                    SourceClass = SourceClass.Where(x => x.GradeID == classmajorView.GradeID);
                }
                var SourceClassmajorList = SourceClass.ToList();
                //获取目标年级中已存在数据
                var BatchClass = ClassmajorDAL.GetClassmajorViewQueryable(x => true);
                if (classmajorView.CollegeID != null)
                {
                    BatchClass = BatchClass.Where(x => x.CollegeID == classmajorView.CollegeID);
                }
                if (classmajorView.StandardID != null && classmajorView.StandardID != -1)
                {
                    BatchClass = BatchClass.Where(x => x.StandardID == classmajorView.StandardID);
                }
                if (classmajorView.BatchGradeID != null)
                {
                    BatchClass = BatchClass.Where(x => x.GradeID == classmajorView.BatchGradeID);
                }
                var BatchClassmajorList = BatchClass.ToList();
                //插入数据
                foreach (var sc in SourceClassmajorList)
                {
                    var Class = GrademajorList.Where(x => x.GradeID == classmajorView.BatchGradeID && x.StandardID == sc.StandardID && x.CollegeID == sc.CollegeID).FirstOrDefault();
                    if (Class != null)
                    {
                        CF_Classmajor classmajor = new CF_Classmajor();
                        string gradeID = sc.GradeID.ToString();
                        string batchGradeID = classmajorView.BatchGradeID.Value.ToString();
                        //替换复制的年级专业代码
                        string No = sc.No.Trim().Replace(gradeID, batchGradeID);
                        //替换复制的年级专业名称
                        string Name = sc.Name.Trim().Replace(gradeID, batchGradeID);
                        //替换复制的年级专业简称
                        string Abbreviation = sc.Abbreviation.Trim().Replace(gradeID, batchGradeID);
                        classmajor.ClassmajorID = Guid.NewGuid();
                        classmajor.GrademajorID = Class.GrademajorID;
                        classmajor.No = No;
                        classmajor.Name = Name;
                        classmajor.Abbreviation = Abbreviation;
                        classmajor.EnglishName = classmajorView.EnglishName;
                        classmajor.ClassNum = sc.ClassNum;
                        classmajor.UserID = sc.UserID;
                        classmajor.AssistantUserID = sc.AssistantUserID;
                        classmajor.Fixedclassroom = sc.Fixedclassroom;
                        classmajor.Remark = sc.Remark;
                        SetNewStatus(classmajor);
                        if (!classmajorView.IsOverwrite)
                        {
                            var batch = BatchClassmajorList.Where(x => x.No == No && x.GradeID == classmajorView.BatchGradeID && x.GrademajorID == Class.GrademajorID).FirstOrDefault();
                            if (batch == null)
                            {
                                ClassmajorList.Add(classmajor);
                            }
                        }
                        else
                        {
                            var BatchClassmajorIDList = BatchClassmajorList.Select(x => x.ClassmajorID).ToList();
                            List<Guid> ids = new List<Guid>();
                            if (BatchClassmajorIDList.Count > 0)
                            {
                                foreach (var batch in BatchClassmajorIDList)
                                {
                                    string BatchClassmajorID = batch.ToString();
                                    Guid id = new Guid(BatchClassmajorID);
                                    ids.Add(id);
                                }
                                UnitOfWork.Remove<CF_Classmajor>(x => ids.Contains(x.ClassmajorID));
                            }
                            ClassmajorList.Add(classmajor);
                        }
                    }
                }
                UnitOfWork.BulkInsert(ClassmajorList);
                UnitOfWork.Commit();
                int DefeatedCount = SourceClassmajorList.Count() - ClassmajorList.Count();
                int SuccessCount = SourceClassmajorList.Count() - DefeatedCount;
                int BatchClassmajorCount = BatchClassmajorList.Count();
                var result = "一共处理了" + SourceClassmajorList.Count() + "条数据，其中成功" + SuccessCount + "条，失败0条";
                if (DefeatedCount > 0 && BatchClassmajorCount == 0)
                {
                    result = "一共处理了" + SourceClassmajorList.Count() + "条数据，其中成功" + SuccessCount + "条，失败" + DefeatedCount + "条，失败原因：没有对应的年级专业";
                }
                if (DefeatedCount > 0 && BatchClassmajorCount > 0)
                {
                    DefeatedCount = SourceClassmajorList.Count() - BatchClassmajorCount;
                    SuccessCount = SourceClassmajorList.Count() - BatchClassmajorCount - DefeatedCount;
                    result = "一共处理了" + SourceClassmajorList.Count() + "条数据，其中成功" + SuccessCount + " 条，有" + BatchClassmajorCount + "条数据已存在,失败" + DefeatedCount + "条，失败原因：没有对应的年级专业。";
                }
                return result;
            }
            catch (Exception ex)
            {
                throw new Exception(ex.Message);
            }
        }

        /// <summary>
        /// 删除
        /// </summary>
        /// <param name="classmajorIDList"></param>
        /// <returns></returns>
        public bool ClassmajorDelete(IList<Guid?> classmajorIDList)
        {
            try
            {
                UnitOfWork.Delete<CF_Classmajor>(x => classmajorIDList.Contains(x.ClassmajorID));
                return true;
            }
            catch (Exception)
            {
                throw;
            }
        }

        /// <summary>
        /// 查询班级信息对应的学生信息BaseStudentView
        /// </summary>
        /// <param name="configuretView"></param>
        /// <param name="classmajorID"></param>
        /// <param name="inSchoolStatus"></param>
        /// <param name="pageIndex"></param>
        /// <param name="pageSize"></param>
        /// <returns></returns>
        public IGridResultSet<StudentBaseView> GetStudentBaseViewGrid(ConfiguretView configuretView, Guid? classmajorID, int? inSchoolStatus, int pageIndex, int pageSize)
        {
            Expression<Func<CF_Classmajor, bool>> expClassmajor = (x => x.RecordStatus > (int)SYS_STATUS.UNUSABLE);
            expClassmajor = expClassmajor.And(x => x.ClassmajorID == classmajorID);
            //学生信息
            Expression<Func<CF_Student, bool>> expStudent = (x => x.RecordStatus > (int)SYS_STATUS.UNUSABLE);
            if (inSchoolStatus != null && inSchoolStatus > -1)
            {
                var inschoolStatusList = InSchoolSettingServices.Value.GetInschoolStatusList(true);
                if (inSchoolStatus == 1)
                {
                    //表示在校
                    expStudent = expStudent.And(x => inschoolStatusList.Contains(x.InSchoolStatusID));
                }
                if (inSchoolStatus == 0)
                {
                    //不在校
                    expStudent = expStudent.And(x => !inschoolStatusList.Contains(x.InSchoolStatusID));
                }
            }
            var query = ClassmajorDAL.GetStudentBaseViewQueryable(expClassmajor, expStudent);

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

            return query.OrderBy(x => x.LoginID).ThenBy(x => x.ClassmajorNo.Length).ThenBy(x => x.ClassmajorNo).ToGridResultSet<StudentBaseView>(pageIndex, pageSize);
        }

        /// <summary>
        /// 查询班级信息对应的学生信息List
        /// </summary>
        /// <param name="configuretView"></param>
        /// <param name="classmajorID"></param>
        /// <param name="inSchoolStatus"></param>
        /// <returns></returns>
        public List<StudentBaseView> GetStudentBaseViewList(ConfiguretView configuretView, Guid? classmajorID, int? inSchoolStatus)
        {
            Expression<Func<CF_Classmajor, bool>> expClassmajor = (x => x.RecordStatus > (int)SYS_STATUS.UNUSABLE);
            expClassmajor = expClassmajor.And(x => x.ClassmajorID == classmajorID);
            //学生信息
            Expression<Func<CF_Student, bool>> expStudent = (x => x.RecordStatus > (int)SYS_STATUS.UNUSABLE);
            if (inSchoolStatus != null && inSchoolStatus > -1)
            {
                var inschoolStatusList = InSchoolSettingServices.Value.GetInschoolStatusList(true);
                if (inSchoolStatus == 1)
                {
                    //表示在校
                    expStudent = expStudent.And(x => inschoolStatusList.Contains(x.InSchoolStatusID));
                }
                if (inSchoolStatus == 0)
                {
                    //不在校
                    expStudent = expStudent.And(x => !inschoolStatusList.Contains(x.InSchoolStatusID));
                }
            }

            var query = ClassmajorDAL.GetStudentBaseViewQueryable(expClassmajor, expStudent);

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

            return query.OrderBy(x => x.LoginID).ThenBy(x => x.ClassmajorNo.Length).ThenBy(x => x.ClassmajorNo).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 ClassmajorImport(Dictionary<string, string> cellheader, out int? inCount, out int? upCount, out List<ClassmajorView> errdataList, out int? errCount, string sourcePhysicalPath)
        {
            try
            {
                StringBuilder errorMsg = new StringBuilder();
                List<ClassmajorView> errList = new List<ClassmajorView>();
                cellheader.Remove("ErrorMessage");
                List<ClassmajorView> enlist = NpoiExcelHelper.ExcelToEntityList<ClassmajorView>(cellheader, sourcePhysicalPath, out errorMsg, out errList);
                cellheader.Add("ErrorMessage", "未导入原因");
                //对List集合进行有效性校验
                if (enlist.Count() <= 0)
                {
                    throw new Exception("Excel文件数据为空，请检查。");
                }
                Regex reg = null; //正则表达式
                //DateTime result; //用于返回判断日期字段格式
                inCount = 0; //导入个数
                upCount = 0; //更新个数
                errCount = 0; //失败个数
                string errorMsgStr = ""; //错误信息
                List<CF_Classmajor> newClassmajorInList = new List<CF_Classmajor>();
                List<CF_Classmajor> newClassmajorUpList = new List<CF_Classmajor>();
                //将循环中相关数据库查询统一查询出来进行匹配(尽量避免在循环中进行数据库查询)
                //班级信息
                var classmajorList = ClassmajorDAL.ClassmajorRepository.GetList(x => true).ToList();
                //班级编号
                var classmajorNoList = enlist.Where(x => !string.IsNullOrEmpty(x.No)).Select(x => x.No).ToList();
                //班级名称
                var classmajorNameList = enlist.Where(x => !string.IsNullOrEmpty(x.Name)).Select(x => x.Name).ToList();
                //对比后的newClassmajorList
                var newClassmajorList = classmajorList.Where(x => classmajorNoList.Contains(x.No) || classmajorNameList.Contains(x.Name)).ToList();
                //年级专业信息
                var grademajorList = ClassmajorDAL.GrademajorRepository.GetList(x => true).ToList();
                //年级专业编号
                var grademajorCodeList = enlist.Where(x => !string.IsNullOrEmpty(x.GrademajorCode)).Select(x => x.GrademajorCode).ToList();
                //对比后的newGrademajorList
                var newGrademajorList = grademajorList.Where(x => grademajorCodeList.Contains(x.Code)).ToList();
                //教职工信息
                var staffViewList = StaffServices.Value.GetListStaffView();
                //教职工姓名(暂时不考虑，教职工号不同，姓名相同的情况)
                var staffNameUList = enlist.Where(x => !string.IsNullOrEmpty(x.UserName)).Select(x => x.UserName).ToList();
                var staffNameAList = enlist.Where(x => !string.IsNullOrEmpty(x.AssistantUserName)).Select(x => x.AssistantUserName).ToList();
                //对比后的newStaffViewList
                var newStaffViewList = staffViewList.Where(x => staffNameUList.Contains(x.Name) || staffNameAList.Contains(x.Name)).ToList();

                //循环检测数据列,对各数据列进行验证（必填、字典项验证、数据格式等）
                for (int i = 0; i < enlist.Count; i++)
                {
                    ClassmajorView en = enlist[i]; //Excel表数据视图
                    CF_Classmajor newClassmajor = new CF_Classmajor();
                    //班级编号
                    if (string.IsNullOrEmpty(en.No))
                    {
                        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.No))
                        {
                            errCount++;
                            errorMsgStr = "班级编号格式不正确，请检查(数字或英文字母)";
                            en.ErrorMessage = errorMsgStr;
                            errList.Add(en);
                            errorMsg.AppendLine(errorMsgStr);
                            continue;
                        }
                        else
                        {
                            //班级编号
                            newClassmajor.No = en.No.Trim();
                        }
                    }
                    //班级名称
                    if (string.IsNullOrEmpty(en.Name))
                    {
                        errCount++;
                        errorMsgStr = "班级名称不能为空";
                        en.ErrorMessage = errorMsgStr;
                        errList.Add(en);
                        errorMsg.AppendLine(errorMsgStr);
                        continue;
                    }
                    else
                    {
                        //班级名称
                        newClassmajor.Name = en.Name.Trim();
                    }
                    //简称
                    if (string.IsNullOrEmpty(en.Abbreviation))
                    {
                        //不考虑
                    }
                    else
                    {
                        newClassmajor.Abbreviation = en.Abbreviation;
                    }
                    //英文名称
                    if (string.IsNullOrEmpty(en.EnglishName))
                    {
                        //不考虑
                    }
                    else
                    {
                        newClassmajor.EnglishName = en.EnglishName;
                    }
                    //年级专业编号
                    if (string.IsNullOrEmpty(en.GrademajorCode))
                    {
                        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.GrademajorCode))
                        {
                            errCount++;
                            errorMsgStr = "年级专业编号格式不正确，请检查(数字或英文字母)";
                            en.ErrorMessage = errorMsgStr;
                            errList.Add(en);
                            errorMsg.AppendLine(errorMsgStr);
                            continue;
                        }
                        else
                        {
                            var grademajor = newGrademajorList.Where(x => x.Code == en.GrademajorCode.Trim()).SingleOrDefault();
                            if (grademajor == null)
                            {
                                errCount++;
                                errorMsgStr = "年级专业编号不存在，请检查";
                                en.ErrorMessage = errorMsgStr;
                                errList.Add(en);
                                errorMsg.AppendLine(errorMsgStr);
                                continue;
                            }
                            else
                            {
                                //年级专业信息ID
                                newClassmajor.GrademajorID = grademajor.GrademajorID;
                            }
                        }
                    }
                    //班序
                    if (string.IsNullOrEmpty(en.ClassNumStr))
                    {
                        errCount++;
                        errorMsgStr = "班序不能为空";
                        en.ErrorMessage = errorMsgStr;
                        errList.Add(en);
                        errorMsg.AppendLine(errorMsgStr);
                        continue;
                    }
                    else
                    {
                        reg = new Regex(@"^[1-9]\d*|0$"); //班序字段正则表达式()
                        if (!reg.IsMatch(en.ClassNumStr))
                        {
                            errCount++;
                            errorMsgStr = "班序格式不正确，请检查（自然数）";
                            en.ErrorMessage = errorMsgStr;
                            errList.Add(en);
                            errorMsg.AppendLine(errorMsgStr);
                            continue;
                        }
                        else
                        {
                            //班序
                            newClassmajor.ClassNum = Convert.ToInt32(en.ClassNumStr);
                        }
                    }
                    //班主任
                    if (string.IsNullOrEmpty(en.UserName))
                    {
                        //不考虑
                    }
                    else
                    {
                        var staffViewByU = newStaffViewList.Where(x => x.Name == en.UserName.Trim()).FirstOrDefault();
                        if (staffViewByU == null)
                        {
                            ////暂不考虑
                            //errCount++;
                            //errorMsgStr = "班主任不存在，请检查";
                            //en.ErrorMessage = errorMsgStr;
                            //errList.Add(en);
                            //errorMsg.AppendLine(errorMsgStr);
                            //continue;
                        }
                        else
                        {
                            //班主任
                            newClassmajor.UserID = staffViewByU.UserID;
                        }
                    }
                    //辅导员
                    if (string.IsNullOrEmpty(en.AssistantUserName))
                    {
                        //不考虑
                    }
                    else
                    {
                        var staffViewByA = newStaffViewList.Where(x => x.Name == en.AssistantUserName.Trim()).FirstOrDefault();
                        if (staffViewByA == null)
                        {
                            ////暂不考虑
                            //errCount++;
                            //errorMsgStr = "辅导员不存在，请检查";
                            //en.ErrorMessage = errorMsgStr;
                            //errList.Add(en);
                            //errorMsg.AppendLine(errorMsgStr);
                            //continue;
                        }
                        else
                        {
                            //辅导员
                            newClassmajor.AssistantUserID = staffViewByA.UserID;
                        }
                    }
                    //固定教室
                    if (string.IsNullOrEmpty(en.Fixedclassroom))
                    {
                        //不考虑
                    }
                    else
                    {
                        newClassmajor.Fixedclassroom = en.Fixedclassroom;
                    }
                    //备注
                    if (string.IsNullOrEmpty(en.Remark))
                    {
                        //不考虑
                    }
                    else
                    {
                        newClassmajor.Remark = en.Remark;
                    }

                    ////Excel表重复性验证（注：当数据表中没有此记录，但是Excel中有重复数据时的去掉）
                    //for (int j = i + 1; j < enlist.Count; j++)
                    //{
                    //    NewClassmajorView enA = enlist[j];
                    //    //根据Excel表中的业务主键进行去重（班级编号或班级名称唯一）
                    //    if (en.No == enA.No && en.Name == enA.Name)
                    //    {
                    //        //用于标识Excel表中的重复记录（由于是批量进行插入数据表）

                    //    }
                    //}

                    //数据表重复性验证（班级编号或班级名称唯一）
                    var classmajorVerify = newClassmajorList.Where(x => x.No == newClassmajor.No || x.Name == newClassmajor.Name).FirstOrDefault();
                    if (classmajorVerify == null)
                    {
                        //新增
                        if (!newClassmajorInList.Any(x => x.No == newClassmajor.No || x.Name == newClassmajor.Name))
                        {
                            //CF_Classmajor表
                            newClassmajor.ClassmajorID = Guid.NewGuid();
                            SetNewStatus(newClassmajor);
                            newClassmajorInList.Add(newClassmajor);
                            inCount++;
                        }
                        else
                        {
                            //Excel表重复性验证
                            //（注：当数据表中没有此记录，但是Excel中有重复数据,可在此处进行抛出到失败数据文件中,目前暂不考虑）

                            inCount++;
                        }
                    }
                    else
                    {
                        //更新(Excel有重复时，以最后一条记录的更新为准)
                        //注：暂时不更新对应的年级专业信息
                        //classmajorVerify.GrademajorID = newClassmajor.GrademajorID;
                        classmajorVerify.Abbreviation = newClassmajor.Abbreviation;
                        classmajorVerify.EnglishName = newClassmajor.EnglishName;
                        classmajorVerify.ClassNum = newClassmajor.ClassNum;
                        classmajorVerify.UserID = newClassmajor.UserID;
                        classmajorVerify.AssistantUserID = newClassmajor.AssistantUserID;
                        classmajorVerify.Fixedclassroom = newClassmajor.Fixedclassroom;
                        classmajorVerify.Remark = newClassmajor.Remark;
                        SetModifyStatus(classmajorVerify);
                        newClassmajorUpList.Add(classmajorVerify);
                        upCount++;
                    }
                }
                using (TransactionScope ts = new TransactionScope())
                {
                    UnitOfWork.BulkInsert(newClassmajorInList);
                    //批量统一提交更新
                    if (newClassmajorUpList != null && newClassmajorUpList.Count() > 0)
                    {
                        UnitOfWork.BatchUpdate(newClassmajorUpList);
                    }
                    ts.Complete();
                }
                errdataList = errList.Distinct().ToList(); //错误列表List
            }
            catch (Exception)
            {
                throw;
            }
        }

    }
}