public ActionResult <FacultystaffSearchResModel> GetListByParas(FacultystaffSearchModel model) { var lists = _facultystaffService.GetListByParas(model); FacultystaffSearchResModel resModel = new FacultystaffSearchResModel(); resModel.IsSuccess = true; resModel.viewModels = lists; resModel.TotalNum = lists.Count; resModel.baseViewModel.Message = "查询成功"; resModel.baseViewModel.ResponseCode = 200; return(resModel); }
//根据条件查询 public List <facultystaff_Info> GetByModel(FacultystaffSearchModel model) { //查询条件 var predicate = WhereExtension.True <facultystaff_Info>();//初始化where表达式 //姓名 if (!String.IsNullOrEmpty(model.Name)) { predicate = predicate.And(p => p.Name.Contains(model.Name)); } ////身份证 //if (!String.IsNullOrEmpty(model.IdNumber)) //{ // predicate = predicate.And(p => Dtol.Helper.MD5.Decrypt(p.IdNumber).Contains(model.IdNumber)); //} if (!String.IsNullOrEmpty(model.IdNumber)) { predicate = predicate.And(p => p.IdNumber == Dtol.Helper.MD5.Md5Hash(model.IdNumber)); } //学校 if (!String.IsNullOrEmpty(model.SchoolCode)) { predicate = predicate.And(p => p.SchoolCode.Equals(model.SchoolCode)); } //部门 if (!String.IsNullOrEmpty(model.DepartCode)) { predicate = predicate.And(p => p.DepartCode.Equals(model.DepartCode)); } //岗位 if (!String.IsNullOrEmpty(model.StaffCode)) { predicate = predicate.And(p => p.StaffCode.Equals(model.StaffCode)); } //住址 if (!String.IsNullOrEmpty(model.PermanentAddress)) { predicate = predicate.And(p => p.PermanentAddress.Contains(model.PermanentAddress)); } var result = DbSet.Where(predicate).ToList(); return(result); }
//根据条件查询 public List <FacultystaffMiddle> GetListByParas(FacultystaffSearchModel model) { List <facultystaff_Info> lists = new List <facultystaff_Info>(); List <FacultystaffMiddle> nlists = new List <FacultystaffMiddle>(); //if (!string.IsNullOrEmpty(model.IdNumber)) //{ // model.IdNumber = Dtol.Helper.MD5.Md5Hash(model.IdNumber); //} lists = _facultystaffInfoRepository.GetByModel(model); foreach (var item in lists) { var info = _IMapper.Map <facultystaff_Info, FacultystaffMiddle>(item); info.IdNumber = Dtol.Helper.MD5.Decrypt(info.IdNumber); nlists.Add(info); } return(nlists); }