LIOT/EMIS.CommonLogic/ExaminationApply/ExaminationSubjectCollegeControlServices.cs

//using System;
//using System.Collections.Generic;
//using System.Linq;
//using System.Text;
//using Bowin.Common.Linq;
//using Bowin.Common.Linq.Entity;
//using EMIS.ViewModel.SelectCourse;
//using EMIS.ViewModel;
//using System.Linq.Expressions;
//using EMIS.Entities;
//using EMIS.DataLogic.SelectCourse;

//namespace EMIS.CommonLogic.SelectCourse
//{
//    public class ExaminationSubjectCollegeControlServices : BaseServices, IExaminationSubjectCollegeControlServices
//    {
//        public ExaminationSubjectCollegeControlDAL examinationSubjectCollegeControlDAL { get; set; }

//        /// <summary>
//        /// 列表查询
//        /// </summary>
//        /// <param name="configuretView"></param>
//        /// <param name="examinationTypeID"></param>
//        /// <param name="examinationSubjectID"></param>
//        /// <param name="collegeID"></param>
//        /// <param name="facultymajorID"></param>
//        /// <param name="schoolyearNumID"></param>
//        /// <param name="pageIndex"></param>
//        /// <param name="pageSize"></param>
//        /// <returns></returns>
//        public IGridResultSet<ExaminationSubjectCollegeControlView> GetExaminationSubjectCollegeControlViewGrid(ConfiguretView configuretView, Guid? examinationTypeID, Guid? examinationSubjectID, Guid? collegeID, Guid? facultymajorID, int? schoolyearNumID, int pageIndex, int pageSize)
//        { 
//            Expression<Func<EX_ExaminationSubjectCollegeControl, bool>> esccexp = x => true; 
//            Expression<Func<EX_ExaminationSubject, bool>> esexp= x => true;
//            Expression<Func<CF_Facultymajor, bool>> fexp = x => true;

//            if (examinationTypeID.HasValue)
//            {
//                esexp = esexp.And(x => x.ExaminationTypeID == examinationTypeID);
//            }

//            if (examinationSubjectID.HasValue)
//            {
//                esccexp = esccexp.And(x => x.ExaminationSubjectID == examinationSubjectID);
//            }

//            if (collegeID.HasValue)
//            {
//                fexp = fexp.And(x => x.CollegeID == collegeID);
//            }

//            if (facultymajorID.HasValue)
//            {
//                esccexp = esccexp.And(x => x.FacultymajorID == facultymajorID);
//            }

//            if (schoolyearNumID.HasValue)
//            {
//                esccexp = esccexp.And(x => x.SchoolyearNumID == schoolyearNumID);
//            }

//            var query = examinationSubjectCollegeControlDAL.GetExaminationSubjectCollegeControlView(esccexp, esexp, fexp);

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

//            var result = GetQueryByDataRangeByCollege(query);

//            return result.OrderBy(x => x.ExaminationSubjectName.Length).ThenBy(x => x.ExaminationSubjectName).ThenBy(x => x.CollegeName.Length).ThenBy(x => x.CollegeName).ThenBy(x => x.SchoolyearNumID).ToGridResultSet<ExaminationSubjectCollegeControlView>(pageIndex, pageSize);
//        }

//        /// <summary>
//        /// excel导出
//        /// </summary>
//        /// <param name="configuretView"></param>
//        /// <param name="examinationTypeID"></param>
//        /// <param name="examinationSubjectID"></param>
//        /// <param name="collegeID"></param>
//        /// <param name="facultymajorID"></param>
//        /// <param name="schoolyearNumID"></param>
//        /// <param name="idList"></param>
//        /// <returns></returns>
//        public List<ExaminationSubjectCollegeControlView> GetExaminationSubjectCollegeControlViewList(ConfiguretView configuretView, Guid? examinationTypeID, Guid? examinationSubjectID, Guid? collegeID, Guid? facultymajorID, int? schoolyearNumID, List<Guid?> idList)
//        {
//            Expression<Func<EX_ExaminationSubjectCollegeControl, bool>> esccexp = x => true;
//            Expression<Func<EX_ExaminationSubject, bool>> esexp = x => true;
//            Expression<Func<CF_Facultymajor, bool>> fexp = x => true;

//            if (examinationTypeID.HasValue)
//            {
//                esexp = esexp.And(x => x.ExaminationTypeID == examinationTypeID);
//            }

//            if (examinationSubjectID.HasValue)
//            {
//                esccexp = esccexp.And(x => x.ExaminationSubjectID == examinationSubjectID);
//            }

//            if (collegeID.HasValue)
//            {
//                fexp = fexp.And(x => x.CollegeID == collegeID);
//            }

//            if (facultymajorID.HasValue)
//            {
//                esccexp = esccexp.And(x => x.FacultymajorID == facultymajorID);
//            }

//            if (schoolyearNumID.HasValue)
//            {
//                esccexp = esccexp.And(x => x.SchoolyearNumID == schoolyearNumID);
//            }

//            if (idList.Count > 0)
//            {
//                esccexp = esccexp.And(x => idList.Contains(x.ExaminationSubjectCollegeControlID));
//            }

//            var query = examinationSubjectCollegeControlDAL.GetExaminationSubjectCollegeControlView(esccexp, esexp, fexp);

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

//            var result = GetQueryByDataRangeByCollege(query);

//            return result.OrderBy(x => x.ExaminationSubjectName.Length).ThenBy(x => x.ExaminationSubjectName).ThenBy(x => x.CollegeName.Length).ThenBy(x => x.CollegeName).ThenBy(x => x.SchoolyearNumID).ToList();
//        }

//        public ExaminationSubjectCollegeControlView GetExaminationSubjectCollegeControlView(Guid? examinationSubjectCollegeControlID)
//        {
//            Expression<Func<EX_ExaminationSubjectCollegeControl, bool>> esccexp = x => x.ExaminationSubjectCollegeControlID == examinationSubjectCollegeControlID;
//            var query = examinationSubjectCollegeControlDAL.GetExaminationSubjectCollegeControlView(esccexp, x => true, x => true).FirstOrDefault();
//            return query;
//        }

//        /// <summary>
//        /// 新增
//        /// </summary>
//        /// <param name="examinationSubjectCollegeControlView"></param>
//        /// <param name="facultymajorIDList"></param>
//        public void ExaminationSubjectCollegeControlAdd(ExaminationSubjectCollegeControlView examinationSubjectCollegeControlView, List<Guid> facultymajorIDList)
//        {
//            try
//            {
//                if (facultymajorIDList.Count > 0)
//                {
//                    List<EX_ExaminationSubjectCollegeControl> examinationSubjectCollegeControlList = new List<EX_ExaminationSubjectCollegeControl>();
//                    foreach (Guid facultymajorID in facultymajorIDList)
//                    {
//                        EX_ExaminationSubjectCollegeControl examinationSubjectCollegeControl = new EX_ExaminationSubjectCollegeControl();
//                        //新增
//                        examinationSubjectCollegeControl = examinationSubjectCollegeControlDAL.examinationSubjectCollegeControlRepository
//                                .GetSingle(x => x.ExaminationSubjectID == examinationSubjectCollegeControlView.ExaminationSubjectID && x.FacultymajorID == examinationSubjectCollegeControlView.FacultymajorID
//                                && x.SchoolyearNumID == examinationSubjectCollegeControlView.SchoolyearNumID);

//                        if (examinationSubjectCollegeControl != null)
//                        {
//                            throw new Exception("已存在相同的专业报考限制信息。");
//                        }
//                        examinationSubjectCollegeControl = new EX_ExaminationSubjectCollegeControl();
//                        examinationSubjectCollegeControl.ExaminationSubjectCollegeControlID = Guid.NewGuid();
//                        examinationSubjectCollegeControl.ExaminationSubjectID = examinationSubjectCollegeControlView.ExaminationSubjectID;
//                        examinationSubjectCollegeControl.FacultymajorID = facultymajorID;
//                        examinationSubjectCollegeControl.SchoolyearNumID = examinationSubjectCollegeControlView.SchoolyearNumID == -1 ? null : examinationSubjectCollegeControlView.SchoolyearNumID;
//                        SetNewStatus(examinationSubjectCollegeControl);
//                        examinationSubjectCollegeControlList.Add(examinationSubjectCollegeControl);
//                    }
//                    UnitOfWork.BulkInsert(examinationSubjectCollegeControlList);
//                }
//            }
//            catch (Exception ex)
//            {

//                throw new Exception(ex.Message);
//            }
//        }

//        /// <summary>
//        /// 修改
//        /// </summary>
//        /// <param name="examinationSubjectCollegeControlView"></param>
//        public void ExaminationSubjectCollegeControlEdit(ExaminationSubjectCollegeControlView examinationSubjectCollegeControlView)
//        {
//            try
//            {
//                EX_ExaminationSubjectCollegeControl examinationSubjectCollegeControl = new EX_ExaminationSubjectCollegeControl();
//                    //修改
//                examinationSubjectCollegeControl = examinationSubjectCollegeControlDAL.examinationSubjectCollegeControlRepository
//                        .GetSingle(x => x.ExaminationSubjectCollegeControlID != examinationSubjectCollegeControlView.ExaminationSubjectCollegeControlID
//                        && x.ExaminationSubjectID == examinationSubjectCollegeControlView.ExaminationSubjectID && x.FacultymajorID == examinationSubjectCollegeControlView.FacultymajorID
//                        && x.SchoolyearNumID == examinationSubjectCollegeControlView.SchoolyearNumID);

//                if (examinationSubjectCollegeControl != null)
//                {
//                    throw new Exception("已存在相同的专业报考限制信息。");
//                }

//                examinationSubjectCollegeControl = examinationSubjectCollegeControlDAL.examinationSubjectCollegeControlRepository
//                        .GetSingle(x => x.ExaminationSubjectCollegeControlID == examinationSubjectCollegeControlView.ExaminationSubjectCollegeControlID);

//                if (examinationSubjectCollegeControl == null)
//                {
//                    throw new Exception("数据有误，请核查。");
//                }

//                examinationSubjectCollegeControl.ExaminationSubjectID = examinationSubjectCollegeControlView.ExaminationSubjectID;
//                examinationSubjectCollegeControl.FacultymajorID = examinationSubjectCollegeControlView.FacultymajorID;
//                examinationSubjectCollegeControl.SchoolyearNumID = examinationSubjectCollegeControlView.SchoolyearNumID == -1 ? null : examinationSubjectCollegeControlView.SchoolyearNumID;
//                SetModifyStatus(examinationSubjectCollegeControl);
//                UnitOfWork.Commit();
//            }
//            catch (Exception ex)
//            {

//                throw new Exception(ex.Message);
//            }
//        }

//        /// <summary>
//        /// 删除
//        /// </summary>
//        /// <param name="examinationSubjectCollegeControlIDList"></param>
//        public void ExaminationSubjectCollegeControlDelete(IList<Guid?> examinationSubjectCollegeControlIDList)
//        {
//            try
//            {
//                if (examinationSubjectCollegeControlIDList.Count > 0)
//                {
//                    UnitOfWork.Delete<EX_ExaminationSubjectCollegeControl>(x => examinationSubjectCollegeControlIDList.Contains(x.ExaminationSubjectCollegeControlID));
//                }
//            }
//            catch (Exception ex)
//            {

//                throw new Exception(ex.Message);
//            }
//        }
//    }
//}