LIOT/EMiS.DataLogic/ScoreManage/LevelSettingDAL.cs

//using System;
//using System.Collections.Generic;
//using EMIS.DataLogic.Repositories;
//using System.Linq;
//using System.Text;
//using EMIS.ViewModel.ScoreManage;
//using EMIS.Entities;
//using System.Linq.Expressions;

//namespace EMIS.DataLogic.ScoreManage
//{
//    public class LevelSettingDAL
//    {
//        public LevelSettingRepository levelSettingRepository { get; set; }
//        public ExaminationSubjectRepository examinationSubjectRepository { get; set; }


//        public IQueryable<LevelSettingView> GetLevelSettingViewQueryable(Expression<Func<ER_LevelSetting, bool>> exp)
//        {
//            var query = from a in levelSettingRepository.GetList(exp)
//                        join b in examinationSubjectRepository.Entities on a.ExaminationSubjectID equals b.ExaminationSubjectID
//                        select new LevelSettingView
//                        {
//                            LevelSettingID = a.LevelSettingID,
//                            ExaminationSubjectID = a.ExaminationSubjectID,
//                            ExaminationSubjectName = b.Name,
//                            LevelNo = a.LevelNo.Value,
//                            LevelName = a.LevelName,
//                            MaxScore = a.MaxScore.Value,
//                            MinScore = a.MinScore.Value,
//                            ScoreRange = a.MinScore.ToString() + " <=总成绩<= " + a.MaxScore.ToString(),
//                            Remark = a.Remark
//                        };
//            return query;
//        }

//    }
//}