LIOT/EMIS.CommonLogic/ExaminationApply/SubjectCountLimitServices.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.DataLogic.ExaminationApply;
//using EMIS.Entities;
//using EMIS.ViewModel;
//using EMIS.ViewModel.ExaminationApply;

//namespace EMIS.CommonLogic.ExaminationApply
//{
//    public class SubjectCountLimitServices : BaseServices, ISubjectCountLimitServices
//    {
//        public SubjectCountLimitDAL SubjectCountLimitDAL { get; set; }

//        public Bowin.Common.Linq.Entity.IGridResultSet<SubjectCountLimitView> GetSubjectCountLimitViewList(ViewModel.ConfiguretView subjectCountLimitView, 
//            Guid? examinationTypeID, Guid? facultymajorID, int? yearNum, int pageIndex, int pageSize)
//        {
//            Expression<Func<EX_ExaminationSubjectCountLimit, bool>> exp = (x => x.RecordStatus > (int)SYS_STATUS.UNUSABLE);

//            if (examinationTypeID.HasValue)
//            {
//                exp = exp.And(x => x.ExaminationTypeID == examinationTypeID);
//            }
//            if (facultymajorID.HasValue)
//            {
//                exp = exp.And(x => x.FacultymajorID == facultymajorID);
//            }
//            if (yearNum.HasValue)
//            {
//                exp = exp.And(x => x.Years == yearNum);
//            }

//            var q = SubjectCountLimitDAL.GetSubjectCountLimitView(exp);

//            if (!string.IsNullOrEmpty(subjectCountLimitView.ConditionValue) && !string.IsNullOrEmpty(subjectCountLimitView.Attribute))
//                q = q.DynamicWhere(subjectCountLimitView.Attribute, subjectCountLimitView.Condition, subjectCountLimitView.ConditionValue);

//            return GetQueryByDataRangeByCollege(q).OrderBy(x => x.ExaminationTypeName).ThenBy(x => x.FacultymajorName).ToGridResultSet<SubjectCountLimitView>(pageIndex, pageSize);
//        }

//        public IList<ViewModel.ExaminationApply.SubjectCountLimitView> GetSubjectCountLimitViewList(ViewModel.ConfiguretView subjectCountLimitView, Guid? examinationTypeID, Guid? facultymajorID)
//        {
//            Expression<Func<EX_ExaminationSubjectCountLimit, bool>> exp = (x => x.RecordStatus > (int)SYS_STATUS.UNUSABLE);

//            if (examinationTypeID.HasValue)
//            {
//                exp = exp.And(x => x.ExaminationTypeID == examinationTypeID);
//            }
//            if (facultymajorID.HasValue)
//            {
//                exp = exp.And(x => x.FacultymajorID == facultymajorID);
//            }

//            var q = SubjectCountLimitDAL.GetSubjectCountLimitView(exp);

//            if (!string.IsNullOrEmpty(subjectCountLimitView.ConditionValue) && !string.IsNullOrEmpty(subjectCountLimitView.Attribute))
//                q = q.DynamicWhere(subjectCountLimitView.Attribute, subjectCountLimitView.Condition, subjectCountLimitView.ConditionValue);

//            return GetQueryByDataRangeByCollege(q).OrderBy(x => x.ExaminationTypeName).ThenBy(x => x.FacultymajorName).ToList();
//        }

//        public ViewModel.ExaminationApply.SubjectCountLimitView GetSubjectCountLimitViewInfo(Guid? subjectCountLimitID)
//        {
//            return SubjectCountLimitDAL.GetSubjectCountLimitView(x => x.ExaminationSubjectCountLimitID == subjectCountLimitID).FirstOrDefault();
//        }

//        public void Save(ViewModel.ExaminationApply.SubjectCountLimitView subjectCountLimitView)
//        {
            
//            var subjectCountLimitEntity = SubjectCountLimitDAL.ExaminationSubjectCountLimitRepository.GetSingle(x => x.ExaminationSubjectCountLimitID == subjectCountLimitView.ExaminationSubjectCountLimitID);
//            var RepeatSubjectCountLimit = SubjectCountLimitDAL.ExaminationSubjectCountLimitRepository.GetSingle(x =>
//                x.ExaminationTypeID == subjectCountLimitView.ExaminationTypeID &&
//                x.FacultymajorID == subjectCountLimitView.FacultymajorID && x.Years == subjectCountLimitView.Years);
            
//            if (subjectCountLimitEntity != null)
//            {
//                if (RepeatSubjectCountLimit != null && subjectCountLimitEntity.ExaminationSubjectCountLimitID != RepeatSubjectCountLimit.ExaminationSubjectCountLimitID)
//                {   //门数限定,判断考试类型、院系专业、年级数不能重复
//                    throw new Exception("已存在相同的考试类型、院系专业、年级数，请核查");
//                }
//                subjectCountLimitEntity.ExaminationTypeID = subjectCountLimitView.ExaminationTypeID;
//                subjectCountLimitEntity.FacultymajorID = subjectCountLimitView.FacultymajorID;
//                subjectCountLimitEntity.Years = subjectCountLimitView.Years;
//                subjectCountLimitEntity.SubjectCountLimit = subjectCountLimitView.SubjectCountLimit;

//                this.SetModifyStatus(subjectCountLimitEntity);
//            }
//            else
//            {
//                if (RepeatSubjectCountLimit != null)
//                {   //门数限定,判断考试类型、院系专业、年级数不能重复
//                    throw new Exception("已存在相同的考试类型、院系专业、年级数，请核查");
//                }
//                subjectCountLimitEntity = new EX_ExaminationSubjectCountLimit();
//                subjectCountLimitEntity.ExaminationSubjectCountLimitID = Guid.NewGuid();
//                subjectCountLimitEntity.ExaminationTypeID = subjectCountLimitView.ExaminationTypeID;
//                subjectCountLimitEntity.FacultymajorID = subjectCountLimitView.FacultymajorID;
//                subjectCountLimitEntity.Years = subjectCountLimitView.Years;
//                subjectCountLimitEntity.SubjectCountLimit = subjectCountLimitView.SubjectCountLimit;

//                this.SetNewStatus(subjectCountLimitEntity);

//                UnitOfWork.Add(subjectCountLimitEntity);
//            }
//            UnitOfWork.Commit();
//        }

//        public void Delete(IList<Guid?> subjectCountLimitID)
//        {
//            if (subjectCountLimitID.Count > 0)
//            {
//                UnitOfWork.Delete<EX_ExaminationSubjectCountLimit>(x => subjectCountLimitID.Contains(x.ExaminationSubjectCountLimitID));
//            }
//        }

//        /// <summary>
//        /// 批量修改前，验证门数限定表的院系专业、学年数、考试类型是否重复
//        /// </summary>
//        /// <param name="examinationType">考试类型</param>
//        /// <param name="facultymajorIDs">院系专业</param>
//        /// <param name="years">学年数</param>
//        /// <returns></returns>
//        public string[] Validation(Guid? examinationType,List<Guid?> facultymajorIDs,List<int?> years)
//        {
//            try
//            {
//                for (int i = 0; i < facultymajorIDs.Count; i++)
//                {
//                    Guid a = facultymajorIDs[0].Value;
//                    int b = years[0].Value;
//                    //var SubjectCountLimit = SubjectCountLimitDAL.ExaminationSubjectCountLimitRepository.Entities.Where(x =>
//                    //    x.ExaminationTypeID == examinationType.Value && x.FacultymajorID == facultymajorIDs[0].Value &&
//                    //    x.Years == years[0].Value).FirstOrDefault();
//                    var SubjectCountLimit = SubjectCountLimitDAL.GetSubjectCountLimitView(x =>
//                        x.ExaminationTypeID == examinationType.Value && x.FacultymajorID == a &&
//                        x.Years == b).FirstOrDefault();
//                    if (SubjectCountLimit != null)       
//                        return new[] { "false", "专业【"+SubjectCountLimit.FacultymajorName + "】第" + SubjectCountLimit.Years + "学年的【" + SubjectCountLimit.ExaminationTypeName + "】考试类型数据已存在。" };         
//                }
//            }
//            catch (Exception ex)
//            {
//                return new[] { "false", ex.Message };
//            }
        
//            return new[] { "true", "成功" };
//        }
//    }
//}