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());
}
