//晚
private List <Template_Employment> GetReportStatistiNightData(BaseStudentStasticViewModel baseStudentStasticViewModel)
{
List <Template_Employment> template_Students = new List <Template_Employment>();
var searchresultGao = DbSet.Where(a => a.SchoolCode == baseStudentStasticViewModel.SchoolCode &&
a.CreateDate.Value.ToString("yyyy-MM-dd") == baseStudentStasticViewModel.createdate.Value.ToString("yyyy-MM-dd") &&
a.type == "晚"
)
.GroupBy(m => new { m.SchoolCode, m.type, m.SchoolName })
.Select(a => new Template_Employment
{
SchoolName = a.Key.SchoolName,
SchoolCode = a.Key.SchoolCode,
type = a.Key.type,
ShouldComeSchoolCount = a.Sum(w => w.ShouldComeSchoolCount),
ActualComeSchoolCount = a.Sum(w => w.ActualComeSchoolCount),
ComeSchoolHotCount = a.Sum(w => w.ComeSchoolHotCount),
NotComeSchoolCount = a.Sum(w => w.NotComeSchoolCount),
NotComeSchoolByHotCount = a.Sum(w => w.NotComeSchoolByHotCount),
NotComeSchoolByOutCount = a.Sum(w => w.NotComeSchoolByOutCount),
NotComeSchoolByOtherCount = a.Sum(w => w.NotComeSchoolByOtherCount)
}
);
template_Students.AddRange(searchresultGao);
//早
return(template_Students);
}
public ActionResult <EmployBaseResModel> getEmployBaseTemplate(BaseStudentStasticViewModel baseStudentStasticViewModel)
{
EmployBaseResModel employBaseResModel = new EmployBaseResModel();
employBaseResModel.employComtemlateMiddles = istatisticsService.getBaseComtemplateInfoEmploy(baseStudentStasticViewModel);
employBaseResModel.IsSuccess = true;
employBaseResModel.baseViewModel.Message = "查询成功";
employBaseResModel.baseViewModel.ResponseCode = 200;
return(Ok(employBaseResModel));
}
public ActionResult <StudentBaseResModel> getStudentBaseTemplate(BaseStudentStasticViewModel baseStudentStasticViewModel)
{
StudentBaseResModel studentBaseResModel = new StudentBaseResModel();
studentBaseResModel.studentComtemlateMiddles = istatisticsService.getBaseComtemplateInfo(baseStudentStasticViewModel);
studentBaseResModel.IsSuccess = true;
studentBaseResModel.baseViewModel.Message = "查询成功";
studentBaseResModel.baseViewModel.ResponseCode = 200;
return(Ok(studentBaseResModel));
}
public List <Template_Employment> GetCompTemplateEmploy(BaseStudentStasticViewModel baseStudentStasticViewModel)
{
List <Template_Employment> template_Students = new List <Template_Employment>();
template_Students.AddRange(GetReportStatisticData(baseStudentStasticViewModel)); //到校前初中高中小学
template_Students.AddRange(GetReportStatisticMorningData(baseStudentStasticViewModel)); //早初中高中小学
template_Students.AddRange(GetReportStatistiNoonData(baseStudentStasticViewModel)); //午初中高中小学
template_Students.AddRange(GetReportStatistiNightData(baseStudentStasticViewModel)); //晚高中小学
return(template_Students);
}
public List <EmployComtemlateMiddle> getBaseComtemplateInfoEmploy(BaseStudentStasticViewModel baseStudentStasticViewModel)
{
var SearchResult = employComtemplateRepository.GetCompTemplateEmploy(baseStudentStasticViewModel);
return(_IMapper.Map <List <Template_Employment>, List <EmployComtemlateMiddle> >(SearchResult));
}