JW/ServiceLogic/EMIS.CommonLogic/UniversityManage/ClassroomManage/ClassroomServices.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.CacheManage;
using EMIS.ViewModel.UniversityManage.ClassroomManage;
using EMIS.DataLogic.UniversityManage.ClassroomManage;

namespace EMIS.CommonLogic.UniversityManage.ClassroomManage
{
    public class ClassroomServices : BaseServices, IClassroomServices
    {
        public ClassroomDAL ClassroomDAL { get; set; }

        /// <summary>
        /// 查询对应的教室信息View
        /// </summary>
        /// <param name="configuretView"></param>
        /// <param name="campusID"></param>
        /// <param name="buildingsInfoID"></param>
        /// <param name="classroomName"></param>
        /// <param name="classroomTypeID"></param>
        /// <param name="collegeID"></param>
        /// <param name="isConcurrentUse"></param>
        /// <param name="isReserve"></param>
        /// <param name="isAvailable"></param>
        /// <param name="pageIndex"></param>
        /// <param name="pageSize"></param>
        /// <returns></returns>
        public IGridResultSet<ClassroomView> GetClassroomViewGrid(ConfiguretView configuretView, Guid? campusID, Guid? buildingsInfoID, string classroomName, int? classroomTypeID, 
                Guid? collegeID, int? isConcurrentUse, int? isReserve, int? isAvailable, int pageIndex, int pageSize)
        {
            Expression<Func<CF_Classroom, bool>> expClassroom = (x => x.RecordStatus > (int)SYS_STATUS.UNUSABLE);
            if (buildingsInfoID.HasValue)
            {
                //建筑信息
                expClassroom = expClassroom.And(x => x.BuildingsInfoID == buildingsInfoID);
            }
            if (!string.IsNullOrEmpty(classroomName) && classroomName != "-1")
            {
                //教室名称
                expClassroom = expClassroom.And(x => x.Name == classroomName);
            }
            if (classroomTypeID.HasValue)
            {
                //教室类型(模糊查询)
                expClassroom = expClassroom.And(x => x.CF_ClassroomType.Select(w => w.ClassroomType).Contains(classroomTypeID));
            }
            if (collegeID.HasValue)
            {
                //院系所
                expClassroom = expClassroom.And(x => x.CollegeID == collegeID);
            }
            if (isConcurrentUse.HasValue)
            {
                //可否多班教学
                if (isConcurrentUse.Value == (int)CF_GeneralPurpose.IsYes)
                {
                    expClassroom = expClassroom.And(x => x.IsConcurrentUse == true);
                }
                if (isConcurrentUse.Value == (int)CF_GeneralPurpose.IsNo)
                {
                    expClassroom = expClassroom.And(x => x.IsConcurrentUse != true);
                }
            }
            if (isAvailable.HasValue)
            {
                //是否可用
                if (isAvailable.Value == (int)CF_GeneralPurpose.IsYes)
                {
                    expClassroom = expClassroom.And(x => x.IsAvailable == true);
                }
                if (isAvailable.Value == (int)CF_GeneralPurpose.IsNo)
                {
                    expClassroom = expClassroom.And(x => x.IsAvailable != true);
                }
            }
            var query = ClassroomDAL.GetClassroomViewQueryable(expClassroom);

            if (campusID.HasValue)
            {
                //校区
                query = query.Where(x => x.CampusID == campusID);
            }
            if (isReserve.HasValue)
            {
                //是否预留(排课用)
                if (isReserve.Value == (int)CF_GeneralPurpose.IsYes)
                {
                    query = query.Where(x => x.IsReserve == true);
                }
                if (isReserve.Value == (int)CF_GeneralPurpose.IsNo)
                {
                    query = query.Where(x => x.IsReserve != true);
                }
            }

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

            return this.GetQueryByDataRangeByCampus(query).OrderBy(x => x.CampusCode.Length).ThenBy(x => x.CampusCode)
                    .ThenBy(x => x.BuildingsInfoCode.Length).ThenBy(x => x.BuildingsInfoCode).ThenBy(x => x.Code.Length)
                    .ThenBy(x => x.Code).ThenBy(x => x.RoomUseID).ThenBy(x => x.CollegeCode.Length).ThenBy(x => x.CollegeCode).ToGridResultSet<ClassroomView>(pageIndex, pageSize);
        }

        /// <summary>
        /// 查询对应的教室信息List
        /// </summary>
        /// <param name="configuretView"></param>
        /// <param name="campusID"></param>
        /// <param name="buildingsInfoID"></param>
        /// <param name="classroomName"></param>
        /// <param name="classroomTypeID"></param>
        /// <param name="collegeID"></param>
        /// <param name="isConcurrentUse"></param>
        /// <param name="isReserve"></param>
        /// <param name="isAvailable"></param>
        /// <returns></returns>
        public IList<ClassroomView> GetClassroomViewList(ConfiguretView configuretView, Guid? campusID, Guid? buildingsInfoID, string classroomName, int? classroomTypeID, 
                Guid? collegeID, int? isConcurrentUse, int? isReserve, int? isAvailable)
        {
            Expression<Func<CF_Classroom, bool>> expClassroom = (x => x.RecordStatus > (int)SYS_STATUS.UNUSABLE);
            if (buildingsInfoID.HasValue)
            {
                //建筑信息
                expClassroom = expClassroom.And(x => x.BuildingsInfoID == buildingsInfoID);
            }
            if (!string.IsNullOrEmpty(classroomName) && classroomName != "-1")
            {
                //教室名称
                expClassroom = expClassroom.And(x => x.Name == classroomName);
            }
            if (classroomTypeID.HasValue)
            {
                //教室类型(模糊查询)
                expClassroom = expClassroom.And(x => x.CF_ClassroomType.Select(w => w.ClassroomType).Contains(classroomTypeID));
            }
            if (collegeID.HasValue)
            {
                //院系所
                expClassroom = expClassroom.And(x => x.CollegeID == collegeID);
            }
            if (isConcurrentUse.HasValue)
            {
                //可否多班教学
                if (isConcurrentUse.Value == (int)CF_GeneralPurpose.IsYes)
                {
                    expClassroom = expClassroom.And(x => x.IsConcurrentUse == true);
                }
                if (isConcurrentUse.Value == (int)CF_GeneralPurpose.IsNo)
                {
                    expClassroom = expClassroom.And(x => x.IsConcurrentUse != true);
                }
            }
            if (isAvailable.HasValue)
            {
                //是否可用
                if (isAvailable.Value == (int)CF_GeneralPurpose.IsYes)
                {
                    expClassroom = expClassroom.And(x => x.IsAvailable == true);
                }
                if (isAvailable.Value == (int)CF_GeneralPurpose.IsNo)
                {
                    expClassroom = expClassroom.And(x => x.IsAvailable != true);
                }
            }
            var query = ClassroomDAL.GetClassroomViewQueryable(expClassroom);

            if (campusID.HasValue)
            {
                //校区
                query = query.Where(x => x.CampusID == campusID);
            }
            if (isReserve.HasValue)
            {
                //是否预留(排课用)
                if (isReserve.Value == (int)CF_GeneralPurpose.IsYes)
                {
                    query = query.Where(x => x.IsReserve == true);
                }
                if (isReserve.Value == (int)CF_GeneralPurpose.IsNo)
                {
                    query = query.Where(x => x.IsReserve != true);
                }
            }

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

            return this.GetQueryByDataRangeByCampus(query).OrderBy(x => x.CampusCode.Length).ThenBy(x => x.CampusCode)
                    .ThenBy(x => x.BuildingsInfoCode.Length).ThenBy(x => x.BuildingsInfoCode).ThenBy(x => x.Code.Length)
                    .ThenBy(x => x.Code).ThenBy(x => x.RoomUseID).ThenBy(x => x.CollegeCode.Length).ThenBy(x => x.CollegeCode).ToList();
        }

        /// <summary>
        /// 查询对应的教室信息CF_Classroom
        /// </summary>
        /// <param name="classroomID"></param>
        /// <returns></returns>
        public CF_Classroom GetClassroomInfo(Guid? classroomID)
        {
            try
            {
                var query = ClassroomDAL.ClassroomRepository.GetList(x => x.ClassroomID == classroomID).SingleOrDefault();

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

        /// <summary>
        /// 查询对应的教室信息ClassroomView
        /// </summary>
        /// <param name="classroomID"></param>
        /// <returns></returns>
        public ClassroomView GetClassroomView(Guid? classroomID)
        {
            try
            {
                var query = ClassroomDAL.GetClassroomViewQueryable(x => x.ClassroomID == classroomID).SingleOrDefault();

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

        /// <summary>
        /// 编辑（新增、修改，业务主键：教室编号唯一）
        /// </summary>
        /// <param name="classroomView"></param>
        public void ClassroomEdit(ClassroomView classroomView)
        {
            try
            {
                //查询数据库进行验证
                var classroomVerify = ClassroomDAL.ClassroomRepository.GetList(x => x.ClassroomID != classroomView.ClassroomID && x.Code == classroomView.Code).FirstOrDefault();
                if (classroomVerify == null)
                {
                    //数据有误验证
                    if (classroomView.ClassroomID != null && classroomView.ClassroomID != Guid.Empty)
                    {
                        var classroom = ClassroomDAL.ClassroomRepository.GetList(x => x.ClassroomID == classroomView.ClassroomID, x => x.CF_ClassroomType).SingleOrDefault();
                        if (classroom == null)
                        {
                            throw new Exception("数据有误，请核查");
                        }
                        else
                        {
                            //表示修改
                            classroom.Code = classroomView.Code.Trim();
                            classroom.Name = classroomView.Name.Trim();
                            classroom.BuildingsInfoID = classroomView.BuildingsInfoID;
                            classroom.CollegeID = classroomView.CollegeID;
                            classroom.LayoutTypeID = classroomView.LayoutTypeID;
                            classroom.RoomUseID = classroomView.RoomUseID;
                            classroom.FloorLevel = classroomView.FloorLevel;
                            classroom.Acreage = classroomView.Acreage;
                            classroom.RowCout = classroomView.RowCout;
                            classroom.ColumnCount = classroomView.ColumnCount;
                            classroom.Totalseating = classroomView.Totalseating;
                            classroom.Effectiveseating = classroomView.Effectiveseating;
                            classroom.Examinationseating = classroomView.Examinationseating;
                            classroom.IsWrittenExam = classroomView.IsWrittenExam;
                            classroom.IsMachinetest = classroomView.IsMachinetest;
                            classroom.IsConcurrentUse = classroomView.IsConcurrentUse;
                            classroom.IsAvailable = classroomView.IsAvailable;
                            classroom.Remark = classroomView.Remark;
                            SetModifyStatus(classroom);
                            //教室类型
                            if (classroomView.ClassroomTypeIDList != null && classroomView.ClassroomTypeIDList.Count() > 0)
                            {
                                UnitOfWork.Delete<EMIS.Entities.CF_ClassroomType>(x => x.ClassroomID == classroom.ClassroomID);
                                foreach (var classroomTypeID in classroomView.ClassroomTypeIDList)
                                {
                                    EMIS.Entities.CF_ClassroomType classroomModeType = new EMIS.Entities.CF_ClassroomType();
                                    classroomModeType.ClassroomTypeID = Guid.NewGuid();
                                    classroomModeType.ClassroomID = classroom.ClassroomID;
                                    classroomModeType.ClassroomType = classroomTypeID;
                                    SetNewStatus(classroomModeType);
                                    UnitOfWork.Add(classroomModeType);
                                }
                            }
                        }
                    }
                    else
                    {
                        //表示新增
                        CF_Classroom classroom = new CF_Classroom();
                        classroom.ClassroomID = Guid.NewGuid();
                        classroom.Code = classroomView.Code.Trim();
                        classroom.Name = classroomView.Name.Trim();
                        classroom.BuildingsInfoID = classroomView.BuildingsInfoID;
                        classroom.CollegeID = classroomView.CollegeID;
                        classroom.LayoutTypeID = classroomView.LayoutTypeID;
                        classroom.RoomUseID = classroomView.RoomUseID;
                        classroom.FloorLevel = classroomView.FloorLevel;
                        classroom.Acreage = classroomView.Acreage;
                        classroom.RowCout = classroomView.RowCout;
                        classroom.ColumnCount = classroomView.ColumnCount;
                        classroom.Totalseating = classroomView.Totalseating;
                        classroom.Effectiveseating = classroomView.Effectiveseating;
                        classroom.Examinationseating = classroomView.Examinationseating;
                        classroom.IsWrittenExam = classroomView.IsWrittenExam;
                        classroom.IsMachinetest = classroomView.IsMachinetest;
                        classroom.IsConcurrentUse = classroomView.IsConcurrentUse;
                        classroom.IsAvailable = classroomView.IsAvailable;
                        classroom.Remark = classroomView.Remark;
                        SetNewStatus(classroom);
                        UnitOfWork.Add(classroom);
                        //教室类型
                        if (classroomView.ClassroomTypeIDList != null && classroomView.ClassroomTypeIDList.Count() > 0)
                        {
                            //UnitOfWork.Delete<EMIS.Entities.CF_ClassroomType>(x => x.ClassroomID == classroom.ClassroomID);
                            foreach (var classroomTypeID in classroomView.ClassroomTypeIDList)
                            {
                                EMIS.Entities.CF_ClassroomType classroomModeType = new EMIS.Entities.CF_ClassroomType();
                                classroomModeType.ClassroomTypeID = Guid.NewGuid();
                                classroomModeType.ClassroomID = classroom.ClassroomID;
                                classroomModeType.ClassroomType = classroomTypeID;
                                SetNewStatus(classroomModeType);
                                UnitOfWork.Add(classroomModeType);
                            }
                        }
                    }
                }
                else
                {
                    throw new Exception("已存在相同的教室编号，请核查");
                }
                //事务提交
                UnitOfWork.Commit();
            }
            catch (Exception ex)
            {
                throw new Exception(ex.Message);
            }
        }

        /// <summary>
        /// 增加对应的教室类型(根据教室信息ID、教室类型List)
        /// </summary>
        /// <param name="classroomID"></param>
        /// <param name="list"></param>
        /// <returns></returns>
        public bool ClassroomModeTypeAdd(Guid? classroomID, List<int> list)
        {
            try
            {
                if (list != null && list.Count() > 0)
                {
                    UnitOfWork.Delete<EMIS.Entities.CF_ClassroomType>(x => x.ClassroomID == classroomID);
                    foreach (var value in list)
                    {
                        EMIS.Entities.CF_ClassroomType classroomModeType = new EMIS.Entities.CF_ClassroomType();
                        classroomModeType.ClassroomTypeID = Guid.NewGuid();
                        classroomModeType.ClassroomID = classroomID;
                        classroomModeType.ClassroomType = value;
                        SetNewStatus(classroomModeType);
                        UnitOfWork.Add(classroomModeType);
                    }
                    UnitOfWork.Commit();
                    return true;
                }
                return false;
            }
            catch (Exception ex)
            {
                throw new Exception(ex.Message);
            }
        }

        /// <summary>
        /// 删除
        /// </summary>
        /// <param name="classroomIDList"></param>
        /// <returns></returns>
        public bool ClassroomDelete(List<Guid?> classroomIDList)
        {
            try
            {
                using (TransactionScope ts = new TransactionScope())
                {
                    UnitOfWork.Delete<EMIS.Entities.CF_ClassroomType>(x => classroomIDList.Contains(x.ClassroomID));
                    UnitOfWork.Delete<CF_Classroom>(x => classroomIDList.Contains(x.ClassroomID));
                    ts.Complete();
                    return true;
                }
            }
            catch (Exception)
            {
                throw;
            }
        }

        /// <summary>
        /// 根据教室信息ID查询对应的教室类型List
        /// </summary>
        /// <param name="classroomID"></param>
        /// <returns></returns>
        public List<int> GetClassroomTypeList(Guid? classroomID)
        {
            var query = ClassroomDAL.GetClassroomModeTypeQueryble(classroomID);

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

        /// <summary>
        /// 查询教室信息对应的排课分配院系所信息ClassroomView(无数据范围)
        /// </summary>
        /// <param name="configuretView"></param>
        /// <param name="classroomID"></param>
        /// <param name="campusID"></param>
        /// <param name="collegeID"></param>
        /// <param name="unitCategoryID"></param>
        /// <param name="pageIndex"></param>
        /// <param name="pageSize"></param>
        /// <returns></returns>
        public IGridResultSet<ClassroomView> GetClassroomCollegeViewGrid(ConfiguretView configuretView, Guid? classroomID, Guid? campusID, Guid? collegeID, int? unitCategoryID, int pageIndex, int pageSize)
        {
            Expression<Func<CF_Classroom, bool>> expClassroom = (x => x.RecordStatus > (int)SYS_STATUS.UNUSABLE);
            expClassroom = expClassroom.And(x => x.ClassroomID == classroomID);
            var query = ClassroomDAL.GetClassroomCollegeViewQueryable(expClassroom);
            if (campusID.HasValue)
            {
                query = query.Where(x => x.CollegeCampusID == campusID);
            }
            if (collegeID.HasValue)
            {
                query = query.Where(x => x.CollegeID == collegeID);
            }
            if (unitCategoryID.HasValue)
            {
                query = query.Where(x => x.UnitCategoryID == unitCategoryID);
            }

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

            return query.OrderBy(x => x.Code.Length).ThenBy(x => x.Code).ThenBy(x => x.RoomUseID).ThenBy(x => x.CollegeCode.Length).ThenBy(x => x.CollegeCode)
                    .OrderBy(x => x.CollegeCampusCode.Length).ThenBy(x => x.CollegeCampusCode).ToGridResultSet<ClassroomView>(pageIndex, pageSize);
        }

        /// <summary>
        /// 查询教室信息对应的排课分配院系所信息List(无数据范围)
        /// </summary>
        /// <param name="configuretView"></param>
        /// <param name="classroomID"></param>
        /// <param name="campusID"></param>
        /// <param name="collegeID"></param>
        /// <param name="unitCategoryID"></param>
        /// <returns></returns>
        public IList<ClassroomView> GetClassroomCollegeViewList(ConfiguretView configuretView, Guid? classroomID, Guid? campusID, Guid? collegeID, int? unitCategoryID)
        {
            Expression<Func<CF_Classroom, bool>> expClassroom = (x => x.RecordStatus > (int)SYS_STATUS.UNUSABLE);
            expClassroom = expClassroom.And(x => x.ClassroomID == classroomID);
            var query = ClassroomDAL.GetClassroomCollegeViewQueryable(expClassroom);
            if (campusID.HasValue)
            {
                query = query.Where(x => x.CollegeCampusID == campusID);
            }
            if (collegeID.HasValue)
            {
                query = query.Where(x => x.CollegeID == collegeID);
            }
            if (unitCategoryID.HasValue)
            {
                query = query.Where(x => x.UnitCategoryID == unitCategoryID);
            }

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

            return query.OrderBy(x => x.Code.Length).ThenBy(x => x.Code).ThenBy(x => x.RoomUseID).ThenBy(x => x.CollegeCode.Length).ThenBy(x => x.CollegeCode)
                    .OrderBy(x => x.CollegeCampusCode.Length).ThenBy(x => x.CollegeCampusCode).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 ClassroomImport(Dictionary<string, string> cellheader, out int? inCount, out int? upCount, out List<ClassroomView> errdataList, out int? errCount, string sourcePhysicalPath)
        {
            try
            {
                StringBuilder errorMsg = new StringBuilder();
                List<ClassroomView> errList = new List<ClassroomView>();
                // 1.1解析文件，存放到一个List集合里
                cellheader.Remove("ErrorMessage");
                List<ClassroomView> enlist = NpoiExcelHelper.ExcelToEntityList<ClassroomView>(cellheader, sourcePhysicalPath, out errorMsg, out errList);
                cellheader.Add("ErrorMessage", "未导入原因");
                //对List集合进行有效性校验
                if (enlist.Count() <= 0)
                {
                    throw new Exception("Excel文件数据为空，请检查。");
                }
                Regex reg = null; //正则表达式
                //DateTime result; //用于返回判断日期字段格式
                bool isClassroomTypePass = true; //教室类型判断标识
                inCount = 0; //导入个数
                upCount = 0; //更新个数
                errCount = 0; //失败个数
                string errorMsgStr = ""; //错误信息

                List<CF_Classroom> newClassroomInList = new List<CF_Classroom>();
                List<CF_Classroom> newClassroomUpList = new List<CF_Classroom>();
                List<EMIS.Entities.CF_ClassroomType> newClassroomTypeInList = new List<Entities.CF_ClassroomType>();
                List<Guid?> classroomCTDelList = new List<Guid?>();
                //将循环中相关数据库查询统一查询出来进行匹配(尽量避免在循环中进行数据库查询)
                //建筑信息
                var buildingsInfoList = ClassroomDAL.BuildingsInfoRepository.GetList(x => true).ToList();
                //建筑编号
                var buildingsInfoCodeList = enlist.Where(x => !string.IsNullOrEmpty(x.BuildingsInfoCode)).Select(x => x.BuildingsInfoCode).ToList();
                //对比后的newBuildingsInfoList
                var newBuildingsInfoList = buildingsInfoList.Where(x => buildingsInfoCodeList.Contains(x.Code)).ToList();
                //院系所信息
                var collegeList = ClassroomDAL.CollegeRepository.GetList(x => true, x => x.CF_Campus).ToList();
                //院系所代码
                var collegeNoList = enlist.Where(x => !string.IsNullOrEmpty(x.CollegeCode)).Select(x => x.CollegeCode).ToList();
                //对比后的newCollegeList
                var newCollegeList = collegeList.Where(x => collegeNoList.Contains(x.No)).ToList();
                //房间用途
                var roomUseList = IdNameExt.GetDictionaryItem(DictionaryItem.CF_RoomUse).ToList();
                //教室类型
                var classroomTypeDicList = IdNameExt.GetDictionaryItem(DictionaryItem.CF_ClassroomType).ToList();
                //是否启用
                var generalPurposeList = IdNameExt.GetDictionaryItem(DictionaryItem.CF_GeneralPurpose).ToList();
                //教室信息
                var classroomList = ClassroomDAL.ClassroomRepository.GetList(x => true).ToList();
                //教室编号
                var classroomCodeList = enlist.Where(x => !string.IsNullOrEmpty(x.Code)).Select(x => x.Code).ToList();
                //对比后的newClassroomList(暂时只对比教室编号)
                var newClassroomList = classroomList.Where(x => classroomCodeList.Contains(x.Code)).ToList();
                //循环检测数据列,对各数据列进行验证（必填、字典项验证、数据格式等）
                for (int i = 0; i < enlist.Count; i++)
                {
                    ClassroomView en = enlist[i]; //Excel表数据视图
                    CF_Classroom newClassroom = new CF_Classroom();
                    List<int> newClassroomTypeIDList = new List<int>();
                    //教室编号
                    if (string.IsNullOrWhiteSpace(en.Code))
                    {
                        errCount++;
                        errorMsgStr = "教室编号不能为空";
                        en.ErrorMessage = errorMsgStr;
                        errList.Add(en);
                        errorMsg.AppendLine(errorMsgStr);
                        continue;
                    }
                    else
                    {
                        //教室编号
                        newClassroom.Code = en.Code.Trim();
                    }
                    //教室名称
                    if (string.IsNullOrWhiteSpace(en.Name))
                    {
                        errCount++;
                        errorMsgStr = "教室名称不能为空";
                        en.ErrorMessage = errorMsgStr;
                        errList.Add(en);
                        errorMsg.AppendLine(errorMsgStr);
                        continue;
                    }
                    else
                    {
                        //教室名称
                        newClassroom.Name = en.Name.Trim();
                    }
                    //建筑编号
                    if (string.IsNullOrWhiteSpace(en.BuildingsInfoCode))
                    {
                        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.BuildingsInfoCode.Trim()))
                        {
                            errCount++;
                            errorMsgStr = "建筑编号格式不正确，请检查(数字或英文字母)";
                            en.ErrorMessage = errorMsgStr;
                            errList.Add(en);
                            errorMsg.AppendLine(errorMsgStr);
                            continue;
                        }
                        else
                        {
                            var buildingsInfo = newBuildingsInfoList.Where(x => x.Code == en.BuildingsInfoCode.Trim()).SingleOrDefault();
                            if (buildingsInfo == null)
                            {
                                errCount++;
                                errorMsgStr = "建筑编号不存在，请检查";
                                en.ErrorMessage = errorMsgStr;
                                errList.Add(en);
                                errorMsg.AppendLine(errorMsgStr);
                                continue;
                            }
                            else
                            {
                                //建筑信息ID
                                newClassroom.BuildingsInfoID = buildingsInfo.BuildingsInfoID;
                                //建筑信息对应的校区
                                en.CampusID = buildingsInfo.CampusID;
                            }
                        }
                    }
                    //院系所代码
                    if (string.IsNullOrWhiteSpace(en.CollegeCode))
                    {
                        //不考虑
                    }
                    else
                    {
                        reg = new Regex(@"^[0-9a-zA-Z\s?]+$"); //正则表达式(请输入数字或英文字母)
                        if (!reg.IsMatch(en.CollegeCode.Trim()))
                        {
                            errCount++;
                            errorMsgStr = RSL.Get("CollegeCode") + "格式不正确，请检查(数字或英文字母)";
                            en.ErrorMessage = errorMsgStr;
                            errList.Add(en);
                            errorMsg.AppendLine(errorMsgStr);
                            continue;
                        }
                        else
                        {
                            var college = newCollegeList.Where(x => x.No == en.CollegeCode.Trim()).SingleOrDefault();
                            if (college == null)
                            {
                                errCount++;
                                errorMsgStr = RSL.Get("CollegeCode") + "不存在，请检查";
                                en.ErrorMessage = errorMsgStr;
                                errList.Add(en);
                                errorMsg.AppendLine(errorMsgStr);
                                continue;
                            }
                            else
                            {
                                ////判断院系所对应的校区与建筑信息对应的校区（暂不考虑）
                                //if (college.CampusID == en.CampusID)
                                //{
                                //    //院系所信息ID
                                //    newClassroom.CollegeID = college.CollegeID;
                                //}
                                //else
                                //{
                                //    errCount++;
                                //    errorMsgStr = "建筑信息中对应的" + RSL.Get("CampusCode") 
                                //            + "与" + RSL.Get("CollegeCode") + "对应关系不存在，请检查";
                                //    en.ErrorMessage = errorMsgStr;
                                //    errList.Add(en);
                                //    errorMsg.AppendLine(errorMsgStr);
                                //    continue;
                                //}

                                //院系所信息ID
                                newClassroom.CollegeID = college.CollegeID;
                            }
                        }
                    }
                    //教室类型 
                    if (string.IsNullOrWhiteSpace(en.ClassroomTypeIDListStr))
                    {
                        errCount++;
                        errorMsgStr = "教室类型不能为空（存在多个教室类型时，可用顿号隔开）";
                        en.ErrorMessage = errorMsgStr;
                        errList.Add(en);
                        errorMsg.AppendLine(errorMsgStr);
                        continue;
                    }
                    else
                    {
                        //教室类型可为多个(可用顿号隔开)
                        List<string> list = en.ClassroomTypeIDListStr.Split('、').Where(x => !string.IsNullOrEmpty(x)).Select(x => x.Trim()).Distinct().ToList();
                        foreach (var item in list)
                        {
                            var classroomTypeDic = classroomTypeDicList.Where(x => x.Name == item.Trim()).SingleOrDefault();
                            if (classroomTypeDic == null)
                            {
                                errCount++;
                                errorMsgStr = "教室类型（" + item.Trim() + "）不存在，请检查（存在多个教室类型时，可用顿号隔开）";
                                en.ErrorMessage = errorMsgStr;
                                errList.Add(en);
                                errorMsg.AppendLine(errorMsgStr);
                                isClassroomTypePass = false;
                                break;
                            }
                        }
                        if (isClassroomTypePass)
                        {
                            newClassroomTypeIDList = classroomTypeDicList.Where(x => list.Contains(x.Name)).Select(x => x.Value.Value).ToList();
                        }
                        else
                        {
                            isClassroomTypePass = true;
                            continue;
                        }
                    }
                    //布局类型(暂不考虑)

                    //房间用途 
                    if (string.IsNullOrWhiteSpace(en.RoomUseStr))
                    {
                        //不考虑
                    }
                    else
                    {
                        var roomUse = roomUseList.Where(x => x.Name == en.RoomUseStr.Trim()).SingleOrDefault();
                        if (roomUse == null)
                        {
                            errCount++;
                            errorMsgStr = "房间用途不存在，请检查";
                            en.ErrorMessage = errorMsgStr;
                            errList.Add(en);
                            errorMsg.AppendLine(errorMsgStr);
                            continue;
                        }
                        else
                        {
                            //房间用途
                            newClassroom.RoomUseID = roomUse.Value;
                        }
                    }
                    //所在楼层
                    if (string.IsNullOrWhiteSpace(en.FloorLevelStr))
                    {
                        //不考虑
                    }
                    else
                    {
                        reg = new Regex(@"^-?\d+$"); //正则表达式(整数)
                        if (!reg.IsMatch(en.FloorLevelStr.Trim()))
                        {
                            errCount++;
                            errorMsgStr = "所在楼层格式不正确，请检查(请输入整数)";
                            en.ErrorMessage = errorMsgStr;
                            errList.Add(en);
                            errorMsg.AppendLine(errorMsgStr);
                            continue;
                        }
                        else
                        {
                            //所在楼层
                            newClassroom.FloorLevel = Convert.ToInt32(en.FloorLevelStr.Trim());
                        }
                    }
                    //面积
                    if (string.IsNullOrWhiteSpace(en.AcreageStr))
                    {
                        //不考虑
                    }
                    else
                    {
                        reg = new Regex(@"^[0-9]+([.]{1}[0-9]+){0,1}$"); //正则表达式()
                        if (!reg.IsMatch(en.AcreageStr.Trim()))
                        {
                            errCount++;
                            errorMsgStr = "面积格式不正确，请检查(请输入数字)";
                            en.ErrorMessage = errorMsgStr;
                            errList.Add(en);
                            errorMsg.AppendLine(errorMsgStr);
                            continue;
                        }
                        else
                        {
                            //面积
                            newClassroom.Acreage = Convert.ToDecimal(en.AcreageStr.Trim());
                        }
                    }
                    //行数
                    if (string.IsNullOrWhiteSpace(en.RowCoutStr))
                    {
                        //不考虑
                    }
                    else
                    {
                        reg = new Regex(@"^\d+$"); //正则表达式(非负整数)
                        if (!reg.IsMatch(en.RowCoutStr.Trim()))
                        {
                            errCount++;
                            errorMsgStr = "行数格式不正确，请检查(请输入非负整数)";
                            en.ErrorMessage = errorMsgStr;
                            errList.Add(en);
                            errorMsg.AppendLine(errorMsgStr);
                            continue;
                        }
                        else
                        {
                            //行数
                            newClassroom.RowCout = Convert.ToInt32(en.RowCoutStr.Trim());
                        }
                    }
                    //列数
                    if (string.IsNullOrWhiteSpace(en.ColumnCountStr))
                    {
                        //不考虑
                    }
                    else
                    {
                        reg = new Regex(@"^\d+$"); //正则表达式(非负整数)
                        if (!reg.IsMatch(en.ColumnCountStr.Trim()))
                        {
                            errCount++;
                            errorMsgStr = "列数格式不正确，请检查(请输入负零整数)";
                            en.ErrorMessage = errorMsgStr;
                            errList.Add(en);
                            errorMsg.AppendLine(errorMsgStr);
                            continue;
                        }
                        else
                        {
                            //列数
                            newClassroom.ColumnCount = Convert.ToInt32(en.ColumnCountStr.Trim());
                        }
                    }
                    //总座位数
                    if (string.IsNullOrWhiteSpace(en.TotalseatingStr))
                    {
                        //不考虑
                    }
                    else
                    {
                        reg = new Regex(@"^\d+$"); //正则表达式(非负整数)
                        if (!reg.IsMatch(en.TotalseatingStr.Trim()))
                        {
                            errCount++;
                            errorMsgStr = "总座位数格式不正确，请检查(请输入非负整数)";
                            en.ErrorMessage = errorMsgStr;
                            errList.Add(en);
                            errorMsg.AppendLine(errorMsgStr);
                            continue;
                        }
                        else
                        {
                            //总座位数
                            newClassroom.Totalseating = Convert.ToInt32(en.TotalseatingStr.Trim());
                        }
                    }
                    //有效座位数
                    if (string.IsNullOrWhiteSpace(en.EffectiveseatingStr))
                    {
                        //不考虑
                    }
                    else
                    {
                        reg = new Regex(@"^\d+$"); //正则表达式(非负整数)
                        if (!reg.IsMatch(en.EffectiveseatingStr.Trim()))
                        {
                            errCount++;
                            errorMsgStr = "有效座位数格式不正确，请检查(请输入非负整数)";
                            en.ErrorMessage = errorMsgStr;
                            errList.Add(en);
                            errorMsg.AppendLine(errorMsgStr);
                            continue;
                        }
                        else
                        {
                            //有效座位数
                            newClassroom.Effectiveseating = Convert.ToInt32(en.EffectiveseatingStr.Trim());
                            //座位判断
                            if (newClassroom.Totalseating != null)
                            {
                                if (newClassroom.Effectiveseating.Value > newClassroom.Totalseating.Value)
                                {
                                    errCount++;
                                    errorMsgStr = "有效座位数不能大于总座位数，请检查";
                                    en.ErrorMessage = errorMsgStr;
                                    errList.Add(en);
                                    errorMsg.AppendLine(errorMsgStr);
                                    continue;
                                }
                            }
                        }
                    }
                    //考试座位数
                    if (string.IsNullOrWhiteSpace(en.ExaminationseatingStr))
                    {
                        //不考虑
                    }
                    else
                    {
                        reg = new Regex(@"^\d+$"); //正则表达式(非负整数)
                        if (!reg.IsMatch(en.ExaminationseatingStr.Trim()))
                        {
                            errCount++;
                            errorMsgStr = "考试座位数格式不正确，请检查(请输入非负整数)";
                            en.ErrorMessage = errorMsgStr;
                            errList.Add(en);
                            errorMsg.AppendLine(errorMsgStr);
                            continue;
                        }
                        else
                        {
                            //考试座位数
                            newClassroom.Examinationseating = Convert.ToInt32(en.ExaminationseatingStr.Trim());
                            //座位判断
                            if (newClassroom.Totalseating != null)
                            {
                                if (newClassroom.Examinationseating.Value > newClassroom.Totalseating.Value)
                                {
                                    errCount++;
                                    errorMsgStr = "考试座位数不能大于总座位数，请检查";
                                    en.ErrorMessage = errorMsgStr;
                                    errList.Add(en);
                                    errorMsg.AppendLine(errorMsgStr);
                                    continue;
                                }
                            }
                        }
                    }
                    //可否笔试
                    if (string.IsNullOrWhiteSpace(en.IsWrittenExamStr))
                    {
                        //可否笔试(默认为否)
                        newClassroom.IsWrittenExam = false;
                    }
                    else
                    {
                        var generalPurpose = generalPurposeList.Where(x => x.Name == en.IsWrittenExamStr.Trim()).SingleOrDefault();
                        if (generalPurpose == null)
                        {
                            errCount++;
                            errorMsgStr = "可否笔试不存在，请检查";
                            en.ErrorMessage = errorMsgStr;
                            errList.Add(en);
                            errorMsg.AppendLine(errorMsgStr);
                            continue;
                        }
                        else
                        {
                            //可否笔试
                            newClassroom.IsWrittenExam = generalPurpose.Value == (int)CF_GeneralPurpose.IsYes ? true : false;
                        }
                    }
                    //可否机试
                    if (string.IsNullOrWhiteSpace(en.IsMachinetestStr))
                    {
                        //可否机试(默认为否)
                        newClassroom.IsMachinetest = false;
                    }
                    else
                    {
                        var generalPurpose = generalPurposeList.Where(x => x.Name == en.IsMachinetestStr.Trim()).SingleOrDefault();
                        if (generalPurpose == null)
                        {
                            errCount++;
                            errorMsgStr = "可否机试不存在，请检查";
                            en.ErrorMessage = errorMsgStr;
                            errList.Add(en);
                            errorMsg.AppendLine(errorMsgStr);
                            continue;
                        }
                        else
                        {
                            //可否机试
                            newClassroom.IsMachinetest = generalPurpose.Value == (int)CF_GeneralPurpose.IsYes ? true : false;
                        }
                    }
                    //可否多班教学
                    if (string.IsNullOrWhiteSpace(en.IsConcurrentUseStr))
                    {
                        //可否多班教学(默认为否)
                        newClassroom.IsConcurrentUse = false;
                    }
                    else
                    {
                        var generalPurpose = generalPurposeList.Where(x => x.Name == en.IsConcurrentUseStr.Trim()).SingleOrDefault();
                        if (generalPurpose == null)
                        {
                            errCount++;
                            errorMsgStr = "可否多班教学不存在，请检查";
                            en.ErrorMessage = errorMsgStr;
                            errList.Add(en);
                            errorMsg.AppendLine(errorMsgStr);
                            continue;
                        }
                        else
                        {
                            //可否多班教学
                            newClassroom.IsConcurrentUse = generalPurpose.Value == (int)CF_GeneralPurpose.IsYes ? true : false;
                        }
                    }
                    //是否可用
                    if (string.IsNullOrWhiteSpace(en.IsAvailableStr))
                    {
                        errCount++;
                        errorMsgStr = "是否可用不能为空";
                        en.ErrorMessage = errorMsgStr;
                        errList.Add(en);
                        errorMsg.AppendLine(errorMsgStr);
                        continue;
                    }
                    else
                    {
                        var generalPurpose = generalPurposeList.Where(x => x.Name == en.IsAvailableStr.Trim()).SingleOrDefault();
                        if (generalPurpose == null)
                        {
                            errCount++;
                            errorMsgStr = "是否可用不存在，请检查";
                            en.ErrorMessage = errorMsgStr;
                            errList.Add(en);
                            errorMsg.AppendLine(errorMsgStr);
                            continue;
                        }
                        else
                        {
                            //是否可用
                            newClassroom.IsAvailable = generalPurpose.Value == (int)CF_GeneralPurpose.IsYes ? true : false;
                        }
                    }
                    //备注
                    if (string.IsNullOrWhiteSpace(en.Remark))
                    {
                        //不考虑
                    }
                    else
                    {
                        newClassroom.Remark = en.Remark;
                    }

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

                    //    }
                    //}

                    //数据表重复性验证（教室编号唯一）
                    var classroomVerify = newClassroomList.Where(x => x.Code == newClassroom.Code).SingleOrDefault();
                    if (classroomVerify == null)
                    {
                        //新增
                        if (!newClassroomInList.Any(x => x.Code == newClassroom.Code))
                        {
                            newClassroom.ClassroomID = Guid.NewGuid();
                            SetNewStatus(newClassroom);
                            newClassroomInList.Add(newClassroom);
                            //教室类型
                            if (newClassroomTypeIDList != null && newClassroomTypeIDList.Count() > 0)
                            {
                                foreach (var value in newClassroomTypeIDList)
                                {
                                    EMIS.Entities.CF_ClassroomType classroomModeType = new EMIS.Entities.CF_ClassroomType();
                                    classroomModeType.ClassroomTypeID = Guid.NewGuid();
                                    classroomModeType.ClassroomID = newClassroom.ClassroomID;
                                    classroomModeType.ClassroomType = value;
                                    SetNewStatus(classroomModeType);
                                    newClassroomTypeInList.Add(classroomModeType);
                                }
                            }
                            inCount++;
                        }
                        else
                        {
                            //Excel表重复性验证
                            //（注：当数据表中没有此记录，但是Excel中有重复数据,可在此处进行抛出到失败数据文件中,目前暂不考虑）

                            inCount++;
                        }
                    }
                    else
                    {
                        //更新(Excel有重复时，以最后一条记录的更新为准)
                        classroomVerify.Name = newClassroom.Name;
                        classroomVerify.BuildingsInfoID = newClassroom.BuildingsInfoID;
                        classroomVerify.CollegeID = newClassroom.CollegeID;
                        classroomVerify.LayoutTypeID = newClassroom.LayoutTypeID;
                        classroomVerify.RoomUseID = newClassroom.RoomUseID;
                        classroomVerify.FloorLevel = newClassroom.FloorLevel;
                        classroomVerify.Acreage = newClassroom.Acreage;
                        classroomVerify.RowCout = newClassroom.RowCout;
                        classroomVerify.ColumnCount = newClassroom.ColumnCount;
                        classroomVerify.Totalseating = newClassroom.Totalseating;
                        classroomVerify.Effectiveseating = newClassroom.Effectiveseating;
                        classroomVerify.Examinationseating = newClassroom.Examinationseating;
                        classroomVerify.IsWrittenExam = newClassroom.IsWrittenExam;
                        classroomVerify.IsMachinetest = newClassroom.IsMachinetest;
                        classroomVerify.IsConcurrentUse = newClassroom.IsConcurrentUse;
                        classroomVerify.IsAvailable = newClassroom.IsAvailable;
                        classroomVerify.Remark = newClassroom.Remark;
                        SetModifyStatus(classroomVerify);
                        newClassroomUpList.Add(classroomVerify);
                        //教室类型
                        if (newClassroomTypeIDList != null && newClassroomTypeIDList.Count() > 0)
                        {
                            if (newClassroomTypeInList.Any(x => x.ClassroomID == classroomVerify.ClassroomID))
                            {
                                newClassroomTypeInList.RemoveAll(x => x.ClassroomID == classroomVerify.ClassroomID);
                            }
                            classroomCTDelList.Add(classroomVerify.ClassroomID);
                            foreach (var value in newClassroomTypeIDList)
                            {
                                EMIS.Entities.CF_ClassroomType classroomModeType = new EMIS.Entities.CF_ClassroomType();
                                classroomModeType.ClassroomTypeID = Guid.NewGuid();
                                classroomModeType.ClassroomID = classroomVerify.ClassroomID;
                                classroomModeType.ClassroomType = value;
                                SetNewStatus(classroomModeType);
                                newClassroomTypeInList.Add(classroomModeType);
                            }
                        }
                        else
                        {
                            classroomCTDelList.Add(classroomVerify.ClassroomID);
                        }
                        upCount++;
                    }
                }
                using (TransactionScope ts = new TransactionScope())
                {
                    //删除
                    UnitOfWork.Delete<EMIS.Entities.CF_ClassroomType>(x => classroomCTDelList.Contains(x.ClassroomID));
                    //批量插入
                    UnitOfWork.BulkInsert(newClassroomInList);
                    UnitOfWork.BulkInsert<EMIS.Entities.CF_ClassroomType>(newClassroomTypeInList);
                    //批量统一提交更新
                    if (newClassroomUpList != null && newClassroomUpList.Count() > 0)
                    {
                        UnitOfWork.BatchUpdate(newClassroomUpList);
                    }
                    ts.Complete();
                }
                errdataList = errList.Distinct().ToList(); //错误列表List
            }
            catch (Exception)
            {
                //目前会出现，由于错误信息字符太长，无法抛出弹出框的问题
                throw;
            }
        }

    }
}