public List <StaffStationMiddleModel> GetRelateToStationInfo(StaffStationRelateSearchViewModel staffStationRelateSearchViewModel) { //var searchResult = staffStationRelateRepository.GethealthByStaff(staffStationRelateSearchViewModel); //var result = _IMapper.Map<List<Health_Info>, List<StaffStationMiddleModel>>(searchResult); return(_staffStationRelateRepository.GethealthByStaff(staffStationRelateSearchViewModel)); //教职工和岗位 关系表删除 }
public ActionResult <StaffStationRelateResModel> getStationFromStaffToClass(StaffStationRelateSearchViewModel staffStationRelateSearchViewModel) { StaffStationRelateResModel staffStationRelateResModel = new StaffStationRelateResModel(); var result = _facultystaffService.GetRelateToStationInfo(staffStationRelateSearchViewModel); staffStationRelateResModel.IsSuccess = true; staffStationRelateResModel.staffStationRelateResModels = result; staffStationRelateResModel.TotalNum = result.Count(); staffStationRelateResModel.baseViewModel.Message = "查询成功"; staffStationRelateResModel.baseViewModel.ResponseCode = 200; return(Ok(staffStationRelateResModel)); }
public Expression <Func <Health_Info, bool> > GetByModelWhere(StaffStationRelateSearchViewModel staffStationRelateSearchViewModel) { var predicate = WhereExtension.True <Health_Info>();//初始化where表达式 //姓名 predicate = predicate.And(p => p.facultystaff_Info.DepartCode.Contains(staffStationRelateSearchViewModel.DepartCode)); predicate = predicate.And(p => p.facultystaff_Info.StaffCode.Contains(staffStationRelateSearchViewModel.StationCode)); predicate = predicate.And(p => p.Name.Contains(staffStationRelateSearchViewModel.Name)); if (staffStationRelateSearchViewModel.RoleID != "sys") { predicate = predicate.And(p => p.IdNumber.Contains(Dtol.Helper.MD5.Md5Hash(staffStationRelateSearchViewModel.IdNumber))); } if (staffStationRelateSearchViewModel.SchoolCode != null && staffStationRelateSearchViewModel.SchoolCode != "") { predicate = predicate.And(p => p.facultystaff_Info.SchoolCode.Equals(staffStationRelateSearchViewModel.SchoolCode)); } predicate = predicate.And(p => p.IsHot.Contains(staffStationRelateSearchViewModel.IsHot)); predicate = predicate.And(p => p.IsComeSchool.Contains(staffStationRelateSearchViewModel.isSchool)); predicate = predicate.And(p => p.CheckType.Contains(staffStationRelateSearchViewModel.CheckType)); predicate = predicate.And(p => p.Createdate.ToString().Contains(staffStationRelateSearchViewModel.CreateDate == null ? "" : staffStationRelateSearchViewModel.CreateDate.Value.ToString("yyyy-MM-dd"))); return(predicate); }
public List <StaffStationMiddleModel> GethealthByStaff(StaffStationRelateSearchViewModel staffStationRelateSearchViewModel) { int SkipNum = staffStationRelateSearchViewModel.pageViewModel.CurrentPageNum * staffStationRelateSearchViewModel.pageViewModel.PageSize; var preciaateStudent = GetByModelWhere(staffStationRelateSearchViewModel); List <StaffStationMiddleModel> staffStationMiddleModel = new List <StaffStationMiddleModel>(); if (staffStationRelateSearchViewModel.RoleID == "sys") { var tempresult = Db.Health_Info.Where(preciaateStudent).Where(info => info.facultystaff_InfoId != null) .Select(a => new StaffStationMiddleModel { SchoolName = a.facultystaff_Info.SchoolName, StaffName = a.facultystaff_Info.StaffName, DepartName = a.facultystaff_Info.DepartName, Name = a.facultystaff_Info.Name, Createdate = a.Createdate, IsComeSchool = a.IsComeSchool, IdNumber = Dtol.Helper.MD5.Decrypt(a.IdNumber), id = a.id, IsFamilyHot = a.IsFamilyHot, IsFamilyThroat = a.IsFamilyThroat, IsFamilyWeakt = a.IsFamilyWeakt, IsHot = a.IsHot, IsThroat = a.IsThroat, IsTouch = a.IsTouch, IsWeak = a.IsWeak, CheckType = a.CheckType, Temperature = a.Temperature, IsAggregate = a.IsAggregate, IsTianJin = a.IsTianJin, IsAggregateContain = a.IsAggregateContain, NotComeSchoolReason = a.NotComeSchoolReason, IsBulu = a.IsBulu, facultystaff_InfoId = a.facultystaff_Info.id }).Distinct() ; staffStationMiddleModel.AddRange(tempresult); } else { var searchResult = DbSet .Where(a => a.facultystaff_InfoId == staffStationRelateSearchViewModel.UserKeyId) .Include(a => a.Station_Info).ToList(); for (int i = 0; i < searchResult.Count(); i++) { var tempresult = Db.Health_Info.Where(a => a.facultystaff_Info.station_InfoId == searchResult[i].Station_InfoId) .Where(preciaateStudent) .Select(a => new StaffStationMiddleModel { SchoolName = a.facultystaff_Info.SchoolName, StaffName = a.facultystaff_Info.StaffName, DepartName = a.facultystaff_Info.DepartName, Name = a.facultystaff_Info.Name, Createdate = a.Createdate, IsComeSchool = a.IsComeSchool, IdNumber = Dtol.Helper.MD5.Decrypt(a.IdNumber), id = a.id, IsFamilyHot = a.IsFamilyHot, IsFamilyThroat = a.IsFamilyThroat, IsFamilyWeakt = a.IsFamilyWeakt, IsHot = a.IsHot, IsThroat = a.IsThroat, IsTouch = a.IsTouch, IsWeak = a.IsWeak, CheckType = a.CheckType, Temperature = a.Temperature, IsAggregate = a.IsAggregate, IsTianJin = a.IsTianJin, IsAggregateContain = a.IsAggregateContain, NotComeSchoolReason = a.NotComeSchoolReason, IsBulu = a.IsBulu, facultystaff_InfoId = a.facultystaff_Info.id }) ; staffStationMiddleModel.AddRange(tempresult); } } //List<Health_Info> Health_Info = new List<Health_Info>(); return(staffStationMiddleModel.Distinct().OrderByDescending(o => o.Createdate).Skip(SkipNum) .Take(staffStationRelateSearchViewModel.pageViewModel.PageSize) .ToList()); }