private Expression <Func <facultystaff_Info, bool> > EmploySearchLineWhere(EmploySearchHealthInfo employSearchHealthInfo) { var predicate = WhereExtension.True <facultystaff_Info>();//初始化where表达式 predicate = predicate.And(p => p.SchoolCode.Contains(employSearchHealthInfo.SchoolCode)); predicate = predicate.And(p => p.StaffCode.Contains(employSearchHealthInfo.StaffCode)); predicate = predicate.And(p => p.DepartCode.Contains(employSearchHealthInfo.DepartCode)); predicate = predicate.And(p => p.IdNumber.Contains(Dtol.Helper.MD5.Md5Hash(employSearchHealthInfo.Idnumber))); predicate = predicate.And(p => p.Name.Contains(employSearchHealthInfo.Name)); return(predicate); }
public List <EmployHealthInfoSearchMiddle> EmploySearchHealthRegisterInfo(EmploySearchHealthInfo employSearchHealthInfo) { var searchResult = healthRegisterRepository.searchHealthByEmployInfo(employSearchHealthInfo); var searchresult = _IMapper.Map <List <StudentRegisterHeath_Info>, List <EmployHealthInfoSearchMiddle> >(searchResult); foreach (var item in searchresult) { var modelStudent = facultystaffInfoRepository.GetStudentByfacultystaffRegisterHeath_InfoId(item.id); item.SchoolName = modelStudent.SchoolName; } return(searchresult); }
public List <StudentRegisterHeath_Info> searchHealthByEmployInfo(EmploySearchHealthInfo employSearchHealthInfo) { List <StudentRegisterHeath_Info> studentRegisterHeath_Infos = new List <StudentRegisterHeath_Info>(); var preciate = EmploySearchLineWhere(employSearchHealthInfo); //需要从学生信息差 var result = Db.facultystaff_Info.Include(a => a.StudentRegisterHeath_Info).Where(preciate).ToList(); for (int i = 0; i < result.Count; i++) { if (result[i].StudentRegisterHeath_Info != null) { studentRegisterHeath_Infos.Add(result[i].StudentRegisterHeath_Info); } } return(studentRegisterHeath_Infos); }
// GET: HealthInfo/Details/5 public ActionResult <EmployHealthInfoSearchResModel> EmploySearchHealthRegister(EmploySearchHealthInfo employSearchHealthInfo) { EmployHealthInfoSearchResModel employHealthInfoSearchResModel = new EmployHealthInfoSearchResModel(); employHealthInfoSearchResModel.employHealthInfoSearchMiddles = healthRegisterService.EmploySearchHealthRegisterInfo(employSearchHealthInfo); employHealthInfoSearchResModel.TotalNum = healthRegisterService.EmploySearchHealthRegisterInfo(employSearchHealthInfo).Count(); employHealthInfoSearchResModel.IsSuccess = true; employHealthInfoSearchResModel.baseViewModel.Message = "查询成功"; employHealthInfoSearchResModel.baseViewModel.ResponseCode = 200; return(Ok(employHealthInfoSearchResModel)); }