public ActionResult <StaffClassRelateResModel> getRelateFromStaffToClass(StaffClassRelateSearchViewModel staffClassRelateSearchView)
{
StaffClassRelateResModel staffClassRelateResModel = new StaffClassRelateResModel();
var result = _facultystaffService.GetRelateToClassInfo(staffClassRelateSearchView);
staffClassRelateResModel.IsSuccess = true;
staffClassRelateResModel.staffClassMiddleModels = result;
staffClassRelateResModel.TotalNum = result.Count();
staffClassRelateResModel.baseViewModel.Message = "查询成功";
staffClassRelateResModel.baseViewModel.ResponseCode = 200;
return(Ok(staffClassRelateResModel));
}
public Expression <Func <Health_Info, bool> > GetByModelWhere(StaffClassRelateSearchViewModel staffClassRelateSearchView)
{
var predicate = WhereExtension.True <Health_Info>();//初始化where表达式
//姓名
predicate = predicate.And(p => p.Student_Info.ClassCode.Contains(staffClassRelateSearchView.ClassCode));
predicate = predicate.And(p => p.Student_Info.GradeCode.Contains(staffClassRelateSearchView.GradeCode));
predicate = predicate.And(p => p.Name.Contains(staffClassRelateSearchView.Name));
predicate = predicate.And(p => p.IdNumber.Contains(Dtol.Helper.MD5.Md5Hash(staffClassRelateSearchView.IdNumber)));
predicate = predicate.And(p => p.IsHot.Contains(staffClassRelateSearchView.IsHot));
predicate = predicate.And(p => p.IsComeSchool.Contains(staffClassRelateSearchView.isSchool));
predicate = predicate.And(p => p.Createdate.ToString().Contains(staffClassRelateSearchView.CreateDate == null ? "" : staffClassRelateSearchView.CreateDate.Value.ToString("yyyy-MM-dd")));
return(predicate);
}
public List <StaffClassMiddleModel> GetStudentsByStaff(StaffClassRelateSearchViewModel staffClassRelateSearchView)
{
int SkipNum = staffClassRelateSearchView.pageViewModel.CurrentPageNum * staffClassRelateSearchView.pageViewModel.PageSize;
var preciaateStudent = GetByModelWhere(staffClassRelateSearchView);
List <StaffClassMiddleModel> staffClassMiddleModel = new List <StaffClassMiddleModel>();
//List<Student_Info> student_Infos = new List<Student_Info>();
//List<Health_Info> Health_Info = new List<Health_Info>();
if (staffClassRelateSearchView.RoleID == "sys")
{
var tempresult = Db.Health_Info.Where(preciaateStudent).Where(info => info.Student_InfoId != null)
.Select(a => new StaffClassMiddleModel
{
SchoolName = a.Student_Info.SchoolName,
ClassName = a.Student_Info.ClassName,
GradeName = a.Student_Info.GradeName,
Name = a.Student_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,
IsAggregate = a.IsAggregate,
IsAggregateContain = a.IsAggregateContain,
IsTianJin = a.IsTianJin,
Temperature = a.Temperature,
NotComeSchoolReason = a.NotComeSchoolReason,
IsBulu = a.IsBulu,
Student_InfoId = a.Student_Info.id
})
.ToList();
staffClassMiddleModel.AddRange(tempresult);
}
else
{
var searchResult = DbSet
.Where(a => a.facultystaff_InfoId == staffClassRelateSearchView.UserKeyId)
.Include(a => a.Class_Info).ToList();
for (int i = 0; i < searchResult.Count(); i++)
{
var tempresult = Db.Health_Info.Where(a => a.Student_Info.class_InfoId == searchResult[i].Class_InfoId)
.Where(preciaateStudent)
.Select(a => new StaffClassMiddleModel
{
SchoolName = a.Student_Info.SchoolName,
ClassName = a.Student_Info.ClassName,
GradeName = a.Student_Info.GradeName,
Name = a.Student_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,
IsAggregate = a.IsAggregate,
IsAggregateContain = a.IsAggregateContain,
IsTianJin = a.IsTianJin,
Temperature = a.Temperature,
NotComeSchoolReason = a.NotComeSchoolReason,
IsBulu = a.IsBulu,
Student_InfoId = a.Student_Info.id
})
.ToList();
staffClassMiddleModel.AddRange(tempresult);
}
}
return(staffClassMiddleModel.Distinct().OrderByDescending(o => o.Createdate).Skip(SkipNum)
.Take(staffClassRelateSearchView.pageViewModel.PageSize)
.ToList());
}
public List <StaffClassMiddleModel> GetRelateToClassInfo(StaffClassRelateSearchViewModel staffClassRelateSearchView)
{
//var searchResult = staffClassRelateRepository.GetStudentsByStaff(staffClassRelateSearchView);
//var result = _IMapper.Map<List<Health_Info>, List<StaffClassMiddleModel>>(searchResult);
return(staffClassRelateRepository.GetStudentsByStaff(staffClassRelateSearchView));
}
