JW/ServiceLogic/EMIS.CommonLogic/SchedulingManage/SchedulingSettings/CollegeClassroomServices.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Linq.Expressions;
using Bowin.Common.Linq;
using Bowin.Common.Linq.Entity;
using EMIS.Utility;
using EMIS.Entities;
using EMIS.ViewModel;
using EMIS.ViewModel.SchedulingManage.SchedulingSettings;
using EMIS.ViewModel.UniversityManage.ClassroomManage;
using EMIS.DataLogic.SchedulingManage.SchedulingSettings;

namespace EMIS.CommonLogic.SchedulingManage.SchedulingSettings
{
    public class CollegeClassroomServices : BaseServices, ICollegeClassroomServices
    {
        public CollegeClassroomDAL CollegeClassroomDAL { get; set; }

        /// <summary>
        /// 查询院系教室信息CollegeClassroomView
        /// </summary>
        /// <param name="configuretView"></param>
        /// <param name="collegeCampusID"></param>
        /// <param name="collegeID"></param>
        /// <param name="buildingsInfoID"></param>
        /// <param name="classroomName"></param>
        /// <param name="classroomTypeID"></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<CollegeClassroomView> GetCollegeClassroomViewGrid(ConfiguretView configuretView, Guid? collegeCampusID, Guid? collegeID,
                Guid? buildingsInfoID, string classroomName, int? classroomTypeID, int? isConcurrentUse, int? isReserve, int? isAvailable, int pageIndex, int pageSize)
        {
            Expression<Func<ES_CollegeClassroom, bool>> exp = (x => x.RecordStatus > (int)SYS_STATUS.UNUSABLE);
            if (collegeID.HasValue)
            {
                exp = exp.And(x => x.CollegeID == collegeID);
            }
            var query = CollegeClassroomDAL.GetCollegeClassroomViewQueryable(exp);

            if (collegeCampusID.HasValue)
            {
                query = query.Where(x => x.CollegeCampusID == collegeCampusID);
            }
            if (buildingsInfoID.HasValue)
            {
                query = query.Where(x => x.BuildingsInfoID == buildingsInfoID);
            }
            if (!string.IsNullOrEmpty(classroomName) && classroomName != "-1")
            {
                //教室名称
                query = query.Where(x => x.ClassroomName == classroomName);
            }
            if (classroomTypeID.HasValue)
            {
                //教室类型(模糊查询)
                query = query.Where(x => x.CF_ClassroomType.Select(w => w.ClassroomType).Contains(classroomTypeID));
            }
            if (isConcurrentUse.HasValue)
            {
                //可否多班教学
                if (isConcurrentUse.Value == (int)CF_GeneralPurpose.IsYes)
                {
                    query = query.Where(x => x.IsConcurrentUse == true);
                }
                if (isConcurrentUse.Value == (int)CF_GeneralPurpose.IsNo)
                {
                    query = query.Where(x => x.IsConcurrentUse != true);
                }
            }
            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 (isAvailable.HasValue)
            {
                //是否可用
                if (isAvailable.Value == (int)CF_GeneralPurpose.IsYes)
                {
                    query = query.Where(x => x.IsAvailable == true);
                }
                if (isAvailable.Value == (int)CF_GeneralPurpose.IsNo)
                {
                    query = query.Where(x => x.IsAvailable != true);
                }
            }
            
            //查询条件
            if (!string.IsNullOrEmpty(configuretView.ConditionValue))
            {
                query = query.DynamicWhere(configuretView.Attribute, configuretView.Condition, configuretView.ConditionValue.Trim());
            }

            return this.GetQueryByDataRangeByCollege(query).OrderBy(x => x.CollegeNo.Length).ThenBy(x => x.CollegeNo)
                    .ThenBy(x => x.ClassroomCode.Length).ThenBy(x => x.ClassroomCode).ThenBy(x => x.RoomUseID)
                    .ThenBy(x => x.BuildingsInfoCode.Length).ThenBy(x => x.BuildingsInfoCode)
                    .ToGridResultSet<CollegeClassroomView>(pageIndex, pageSize);
        }

        /// <summary>
        /// 查询院系教室信息List
        /// </summary>
        /// <param name="configuretView"></param>
        /// <param name="collegeCampusID"></param>
        /// <param name="collegeID"></param>
        /// <param name="buildingsInfoID"></param>
        /// <param name="classroomName"></param>
        /// <param name="classroomTypeID"></param>
        /// <param name="isConcurrentUse"></param>
        /// <param name="isReserve"></param>
        /// <param name="isAvailable"></param>
        /// <returns></returns>
        public IList<CollegeClassroomView> GetCollegeClassroomViewList(ConfiguretView configuretView, Guid? collegeCampusID, Guid? collegeID,
                Guid? buildingsInfoID, string classroomName, int? classroomTypeID, int? isConcurrentUse, int? isReserve, int? isAvailable)
        {
            Expression<Func<ES_CollegeClassroom, bool>> exp = (x => x.RecordStatus > (int)SYS_STATUS.UNUSABLE);
            if (collegeID.HasValue)
            {
                exp = exp.And(x => x.CollegeID == collegeID);
            }
            var query = CollegeClassroomDAL.GetCollegeClassroomViewQueryable(exp);

            if (collegeCampusID.HasValue)
            {
                query = query.Where(x => x.CollegeCampusID == collegeCampusID);
            }
            if (buildingsInfoID.HasValue)
            {
                query = query.Where(x => x.BuildingsInfoID == buildingsInfoID);
            }
            if (!string.IsNullOrEmpty(classroomName) && classroomName != "-1")
            {
                //教室名称
                query = query.Where(x => x.ClassroomName == classroomName);
            }
            if (classroomTypeID.HasValue)
            {
                //教室类型(模糊查询)
                query = query.Where(x => x.CF_ClassroomType.Select(w => w.ClassroomType).Contains(classroomTypeID));
            }
            if (isConcurrentUse.HasValue)
            {
                //可否多班教学
                if (isConcurrentUse.Value == (int)CF_GeneralPurpose.IsYes)
                {
                    query = query.Where(x => x.IsConcurrentUse == true);
                }
                if (isConcurrentUse.Value == (int)CF_GeneralPurpose.IsNo)
                {
                    query = query.Where(x => x.IsConcurrentUse != true);
                }
            }
            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 (isAvailable.HasValue)
            {
                //是否可用
                if (isAvailable.Value == (int)CF_GeneralPurpose.IsYes)
                {
                    query = query.Where(x => x.IsAvailable == true);
                }
                if (isAvailable.Value == (int)CF_GeneralPurpose.IsNo)
                {
                    query = query.Where(x => x.IsAvailable != true);
                }
            }

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

            return this.GetQueryByDataRangeByCollege(query).OrderBy(x => x.CollegeNo.Length).ThenBy(x => x.CollegeNo)
                    .ThenBy(x => x.ClassroomCode.Length).ThenBy(x => x.ClassroomCode).ThenBy(x => x.RoomUseID)
                    .ThenBy(x => x.BuildingsInfoCode.Length).ThenBy(x => x.BuildingsInfoCode).ToList();
        }

        /// <summary>
        /// 查询对应的院系教室信息CollegeClassroomView（根据院系教室ID）
        /// </summary>
        /// <param name="collegeClassroomID"></param>
        /// <returns></returns>
        public CollegeClassroomView GetCollegeClassroomView(Guid? collegeClassroomID)
        {
            try
            {
                var query = CollegeClassroomDAL.GetCollegeClassroomViewQueryable(x => x.CollegeClassroomID == collegeClassroomID).SingleOrDefault();

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

        /// <summary>
        /// 编辑（新增、修改）
        /// </summary>
        /// <param name="collegeClassroomView"></param>
        public void CollegeClassroomEdit(CollegeClassroomView collegeClassroomView)
        {
            try
            {
                //查询数据库进行验证
                var collegeClassroomVerify = CollegeClassroomDAL.CollegeClassroomRepository
                        .GetList(x => x.CollegeClassroomID != collegeClassroomView.CollegeClassroomID
                                && x.CollegeID == collegeClassroomView.CollegeID
                                && x.ClassroomID == collegeClassroomView.ClassroomID).SingleOrDefault();
                if (collegeClassroomVerify == null)
                {
                    //数据有误验证
                    if (collegeClassroomView.CollegeClassroomID != Guid.Empty)
                    {
                        var collegeClassroom = CollegeClassroomDAL.CollegeClassroomRepository
                                .GetList(x => x.CollegeClassroomID == collegeClassroomView.CollegeClassroomID).SingleOrDefault();
                        if (collegeClassroom == null)
                        {
                            throw new Exception("数据有误，请核查。");
                        }
                        else
                        {
                            //表示修改
                            collegeClassroom.CollegeID = collegeClassroomView.CollegeID;
                            collegeClassroom.ClassroomID = collegeClassroomView.ClassroomID;
                            SetModifyStatus(collegeClassroom);
                        }
                    }
                    else
                    {
                        //表示新增
                        var newCollegeClassroom = new ES_CollegeClassroom();
                        newCollegeClassroom.CollegeClassroomID = Guid.NewGuid();
                        newCollegeClassroom.CollegeID = collegeClassroomView.CollegeID;
                        newCollegeClassroom.ClassroomID = collegeClassroomView.ClassroomID;
                        SetNewStatus(newCollegeClassroom);
                        UnitOfWork.Add(newCollegeClassroom);
                    }
                }
                else
                {
                    throw new Exception("已存在相同的院系教室信息，请核查。");
                }
                //事务提交
                UnitOfWork.Commit();
            }
            catch (Exception ex)
            {
                throw new Exception(ex.Message);
            }
        }

        /// <summary>
        /// 院系教室信息批量新增（根据院系所信息选择教室信息新增）
        /// </summary>
        /// <param name="classroomIDList"></param>
        /// <param name="collegeClassroomView"></param>
        /// <returns></returns>
        public string CollegeClassroomBatchAdd(List<Guid?> classroomIDList, CollegeClassroomView collegeClassroomView)
        {
            try
            {
                //查询对应的院系教室信息List
                var collegeClassroomList = CollegeClassroomDAL.CollegeClassroomRepository
                        .GetList(x => classroomIDList.Contains(x.ClassroomID)).ToList();

                int success = 0; //成功
                int fail = 0; //失败
                string tipMessage = null; //提示消息
                List<ES_CollegeClassroom> collegeClassroomInList = new List<ES_CollegeClassroom>();

                foreach (var classroomID in classroomIDList)
                {
                    var collegeClassroomVerify = collegeClassroomList.Where(x => x.CollegeID == collegeClassroomView.CollegeID 
                            && x.ClassroomID == classroomID).SingleOrDefault();
                    if (collegeClassroomVerify == null)
                    {
                        //新增
                        var newCollegeClassroom = new ES_CollegeClassroom();
                        newCollegeClassroom.CollegeClassroomID = Guid.NewGuid();
                        newCollegeClassroom.CollegeID = collegeClassroomView.CollegeID;
                        newCollegeClassroom.ClassroomID = classroomID;
                        SetNewStatus(newCollegeClassroom);
                        collegeClassroomInList.Add(newCollegeClassroom);
                        success++;
                    }
                    else
                    {
                        //表示已存在相同的院系教室信息
                        fail++;
                    }
                }
                //批量插入
                UnitOfWork.BulkInsert<ES_CollegeClassroom>(collegeClassroomInList);
                if (success > 0 && fail <= 0)
                {
                    tipMessage = success + "条";
                }
                else
                {
                    tipMessage = success + "条," + fail + "条失败，原因：已存在相同的院系教室信息，请检查";
                }

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

        /// <summary>
        /// 查询院系教室中未新增的教室信息ClassroomView
        /// </summary>
        /// <param name="configuretView"></param>
        /// <param name="campusID"></param>
        /// <param name="buildingsInfoID"></param>
        /// <param name="classroomName"></param>
        /// <param name="classroomTypeID"></param>
        /// <param name="isConcurrentUse"></param>
        /// <param name="isReserve"></param>
        /// <param name="isAvailable"></param>
        /// <param name="collegeID"></param>
        /// <param name="pageIndex"></param>
        /// <param name="pageSize"></param>
        /// <returns></returns>
        public IGridResultSet<ClassroomView> GetClassroomViewNoAddGrid(ConfiguretView configuretView, Guid? campusID, Guid? buildingsInfoID,
                string classroomName, int? classroomTypeID, int? isConcurrentUse, int? isReserve, int? isAvailable, Guid? collegeID, 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 (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);
                }
            }
            
            //院系教室
            Expression<Func<ES_CollegeClassroom, bool>> expCollegeClassroom = (x => x.RecordStatus > (int)SYS_STATUS.UNUSABLE);
            if (collegeID.HasValue)
            {
                expCollegeClassroom = expCollegeClassroom.And(x => x.CollegeID == collegeID);
            }
            var query = CollegeClassroomDAL.GetClassroomViewNoAddQueryable(expClassroom, expCollegeClassroom);

            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.Code.Length).ThenBy(x => x.Code)
                    .ThenBy(x => x.RoomUseID).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="isConcurrentUse"></param>
        /// <param name="isReserve"></param>
        /// <param name="isAvailable"></param>
        /// <param name="collegeID"></param>
        /// <returns></returns>
        public IList<ClassroomView> GetClassroomViewNoAddList(ConfiguretView configuretView, Guid? campusID, Guid? buildingsInfoID,
                string classroomName, int? classroomTypeID, int? isConcurrentUse, int? isReserve, int? isAvailable, Guid? collegeID)
        {
            //教室信息
            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 (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);
                }
            }

            //院系教室
            Expression<Func<ES_CollegeClassroom, bool>> expCollegeClassroom = (x => x.RecordStatus > (int)SYS_STATUS.UNUSABLE);
            if (collegeID.HasValue)
            {
                expCollegeClassroom = expCollegeClassroom.And(x => x.CollegeID == collegeID);
            }
            var query = CollegeClassroomDAL.GetClassroomViewNoAddQueryable(expClassroom, expCollegeClassroom);

            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.Code.Length).ThenBy(x => x.Code)
                    .ThenBy(x => x.RoomUseID).ToList();
        }

        /// <summary>
        /// 院系教室信息批量新增（根据院系教室信息CollegeClassroomView）
        /// </summary>
        /// <param name="collegeClassroomViewList"></param>
        /// <param name="collegeClassroomView"></param>
        /// <returns></returns>
        public string CollegeClassroomBatchAdd(List<CollegeClassroomView> collegeClassroomViewList, CollegeClassroomView collegeClassroomView)
        {
            try
            {
                //查询对应的院系所信息IDList
                var collegeIDList = collegeClassroomViewList.Select(x => x.CollegeID).Distinct().ToList();
                //查询对应的院系教室信息List（暂时只匹配院系所信息ID）
                var collegeClassroomList = CollegeClassroomDAL.CollegeClassroomRepository
                        .GetList(x => collegeIDList.Contains(x.CollegeID)).ToList();

                int success = 0; //成功
                int fail = 0; //失败
                string tipMessage = null; //提示消息
                List<ES_CollegeClassroom> collegeClassroomInList = new List<ES_CollegeClassroom>();

                foreach (var newCollegeClassroomView in collegeClassroomViewList)
                {
                    var collegeClassroomVerify = collegeClassroomList.Where(x => x.CollegeID == newCollegeClassroomView.CollegeID
                            && x.ClassroomID == newCollegeClassroomView.ClassroomID).SingleOrDefault();
                    if (collegeClassroomVerify == null)
                    {
                        //新增
                        var newCollegeClassroom = new ES_CollegeClassroom();
                        newCollegeClassroom.CollegeClassroomID = newCollegeClassroomView.CollegeClassroomID;
                        newCollegeClassroom.CollegeID = newCollegeClassroomView.CollegeID;
                        newCollegeClassroom.ClassroomID = newCollegeClassroomView.ClassroomID;
                        SetNewStatus(newCollegeClassroom);
                        collegeClassroomInList.Add(newCollegeClassroom);
                        success++;
                    }
                    else
                    {
                        //表示已存在相同的院系教室信息
                        fail++;
                    }
                }
                //批量插入
                UnitOfWork.BulkInsert<ES_CollegeClassroom>(collegeClassroomInList);
                if (success > 0 && fail <= 0)
                {
                    tipMessage = success + "条";
                }
                else
                {
                    tipMessage = success + "条," + fail + "条失败，原因：已存在相同的院系教室信息，请检查";
                }

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

        /// <summary>
        /// 查询未新增的院系教室信息CollegeClassroomView
        /// </summary>
        /// <param name="configuretView"></param>
        /// <param name="buildingsInfoCampusID"></param>
        /// <param name="buildingsInfoID"></param>
        /// <param name="classroomName"></param>
        /// <param name="classroomTypeID"></param>
        /// <param name="isConcurrentUse"></param>
        /// <param name="isReserve"></param>
        /// <param name="isAvailable"></param>
        /// <param name="collegeID"></param>
        /// <param name="pageIndex"></param>
        /// <param name="pageSize"></param>
        /// <returns></returns>
        public IGridResultSet<CollegeClassroomView> GetCollegeClassroomViewNoAddGrid(ConfiguretView configuretView, Guid? buildingsInfoCampusID,
                Guid? buildingsInfoID, string classroomName, int? classroomTypeID, int? isConcurrentUse, int? isReserve,
                int? isAvailable, Guid? collegeID, int pageIndex, int pageSize)
        {
            //院系所信息
            Expression<Func<CF_College, bool>> expCollege = (x => x.RecordStatus > (int)SYS_STATUS.UNUSABLE);
            expCollege = expCollege.And(x => x.CF_CollegeProfile.UnitCategoryID == (int)CF_UnitCategory.College);
            if (collegeID.HasValue)
            {
                expCollege = expCollege.And(x => x.CollegeID == collegeID);
            }
            //教室信息
            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 (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 = CollegeClassroomDAL.GetCollegeClassroomViewNoAddQueryable(expCollege, expClassroom);

            if (buildingsInfoCampusID.HasValue)
            {
                query = query.Where(x => x.CampusID == buildingsInfoCampusID);
            }
            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(GetQueryByDataRangeByCollege(query))
                    .OrderBy(x => x.BuildingsInfoCode.Length).ThenBy(x => x.BuildingsInfoCode)
                    .ThenBy(x => x.ClassroomCode.Length).ThenBy(x => x.ClassroomCode).ThenBy(x => x.RoomUseID)
                    .ThenBy(x => x.CollegeNo.Length).ThenBy(x => x.CollegeNo)
                    .ToGridResultSet<CollegeClassroomView>(pageIndex, pageSize);
        }

        /// <summary>
        /// 查询未新增的院系教室信息List
        /// </summary>
        /// <param name="configuretView"></param>
        /// <param name="buildingsInfoCampusID"></param>
        /// <param name="buildingsInfoID"></param>
        /// <param name="classroomName"></param>
        /// <param name="classroomTypeID"></param>
        /// <param name="isConcurrentUse"></param>
        /// <param name="isReserve"></param>
        /// <param name="isAvailable"></param>
        /// <param name="collegeID"></param>
        /// <returns></returns>
        public IList<CollegeClassroomView> GetCollegeClassroomViewNoAddList(ConfiguretView configuretView, Guid? buildingsInfoCampusID,
                Guid? buildingsInfoID, string classroomName, int? classroomTypeID, int? isConcurrentUse, int? isReserve,
                int? isAvailable, Guid? collegeID)
        {
            //院系所信息
            Expression<Func<CF_College, bool>> expCollege = (x => x.RecordStatus > (int)SYS_STATUS.UNUSABLE);
            expCollege = expCollege.And(x => x.CF_CollegeProfile.UnitCategoryID == (int)CF_UnitCategory.College);
            if (collegeID.HasValue)
            {
                expCollege = expCollege.And(x => x.CollegeID == collegeID);
            }
            //教室信息
            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 (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 = CollegeClassroomDAL.GetCollegeClassroomViewNoAddQueryable(expCollege, expClassroom);

            if (buildingsInfoCampusID.HasValue)
            {
                query = query.Where(x => x.CampusID == buildingsInfoCampusID);
            }
            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(GetQueryByDataRangeByCollege(query))
                    .OrderBy(x => x.BuildingsInfoCode.Length).ThenBy(x => x.BuildingsInfoCode)
                    .ThenBy(x => x.ClassroomCode.Length).ThenBy(x => x.ClassroomCode).ThenBy(x => x.RoomUseID)
                    .ThenBy(x => x.CollegeNo.Length).ThenBy(x => x.CollegeNo)
                    .ToList();
        }

        /// <summary>
        /// 删除
        /// </summary>
        /// <param name="collegeClassroomIDs"></param>
        /// <returns></returns>
        public bool CollegeClassroomDelete(List<Guid?> collegeClassroomIDs)
        {
            try
            {
                UnitOfWork.Delete<ES_CollegeClassroom>(x => collegeClassroomIDs.Contains(x.CollegeClassroomID));
                UnitOfWork.Commit();
                return true;
            }
            catch (Exception)
            {
                throw;
            }
        }

    }
}