public ActionResult <DayAndNightSearchResViewModel> getDayAndNightInfo(DayAndNightSearchViewModel dayAndNightSearchViewModel)
{
DayAndNightSearchResViewModel dayAndNightSearchResViewModel = new DayAndNightSearchResViewModel();
var result = dayAndNightService.SearchDayAndNightListService(dayAndNightSearchViewModel);
dayAndNightSearchResViewModel.dayandNightInfoMiddles = result;
dayAndNightSearchResViewModel.TotalNum = result.Count();
dayAndNightSearchResViewModel.baseViewModel.Message = "查询成功";
dayAndNightSearchResViewModel.baseViewModel.ResponseCode = 200;
return(Ok(dayAndNightSearchResViewModel));
}
public List <DayandNightInfoMiddle> SearchDayAndNightListService(DayAndNightSearchViewModel dayAndNightSearchViewModel)
{
var schoolInfo = schoolInfoRepository.GetSchoolNameByCode(dayAndNightSearchViewModel.SchoolCode);
if (schoolInfo != null)
{
dayAndNightSearchViewModel.SchoolName = schoolInfo.SchoolName;
}
var searchResult = dayandNightRepository.SearchDayAndNightList(dayAndNightSearchViewModel);
var result = mapper.Map <List <Student_DayandNight_Info>, List <DayandNightInfoMiddle> >(searchResult);
return(result);
}
public Expression <Func <Student_DayandNight_Info, bool> > GetByModelWhere(DayAndNightSearchViewModel dayAndNightSearchViewModel)
{
var predicate = WhereExtension.True <Student_DayandNight_Info>();//初始化where表达式SchoolName
//姓
predicate = predicate.And(p => p.GradeName.Contains(dayAndNightSearchViewModel.GradeName));
predicate = predicate.And(p => p.ClassName.Contains(dayAndNightSearchViewModel.ClassName));
predicate = predicate.And(p => p.IsComeSchool.Contains(dayAndNightSearchViewModel.IsComeSchool));
predicate = predicate.And(p => p.Name.Contains(dayAndNightSearchViewModel.Name));
predicate = predicate.And(p => p.SchoolName.Contains(dayAndNightSearchViewModel.SchoolName));
predicate = predicate.And(p => p.Temperature.Contains(dayAndNightSearchViewModel.Temperature));
predicate = predicate.And(p => p.AddTimeInterval.Contains(dayAndNightSearchViewModel.AddTimeInterval));
if (dayAndNightSearchViewModel.AddCreateDate != null && !dayAndNightSearchViewModel.AddCreateDate.Equals("") && dayAndNightSearchViewModel.AddCreateDateT != null && !dayAndNightSearchViewModel.AddCreateDateT.Equals(""))
{
predicate = predicate.And(p => p.AddCreateDate >= Convert.ToDateTime(Convert.ToDateTime(dayAndNightSearchViewModel.AddCreateDate).ToString("yyyy-MM-dd 00:00:00")) && p.AddCreateDate <= Convert.ToDateTime(Convert.ToDateTime(dayAndNightSearchViewModel.AddCreateDateT).ToString("yyyy-MM-dd 23:59:59")));//hc加日期条件
}
predicate = predicate.And(p => p.tag.Contains(dayAndNightSearchViewModel.tag));
return(predicate);
}
public List <Student_DayandNight_Info> SearchDayAndNightList(DayAndNightSearchViewModel dayAndNightSearchViewModel)
{
var preciate = GetByModelWhere(dayAndNightSearchViewModel);
var precateresult = GetByModelChildResultWhere(dayAndNightSearchViewModel);
List <Student_DayandNight_Info> Student_DayandNight_Infos = new List <Student_DayandNight_Info>();
if (dayAndNightSearchViewModel.RoleID.Equals("sys") || dayAndNightSearchViewModel.RoleID.Equals("con") || dayAndNightSearchViewModel.RoleID.Equals("admin"))//总管理员、校医、校长默认查看学校所有
{
var tempresult = Db.Student_DayandNight_Info.Where(preciate);
Student_DayandNight_Infos.AddRange(tempresult.ToList());
}
else
{
var searchResult = Db.ClassManager_Relate
.Where(a => a.facultystaff_InfoId == dayAndNightSearchViewModel.userKey)
.Where(a => a.Class_Info.ClassName == dayAndNightSearchViewModel.ClassName)
.Include(a => a.Class_Info).ToList();
for (int i = 0; i < searchResult.Count; i++)
{
if (searchResult[i].Class_Info == null || searchResult[i].Class_Info.ClassCode.Equals("string") || searchResult[i].Class_Info.ClassCode.Equals(""))
{
continue;
}
var gradeName = int.Parse(searchResult[i].Class_Info.ClassCode.Substring(2, 2)).ToString();
int gradaCode = Convert.ToInt32(searchResult[i].Class_Info.ClassCode.Substring(2, 2));
bool result = true;
switch (gradaCode)
{
case 13:
gradeName = "大班";
result = false;
break;
case 14:
gradeName = "中班";
result = false;
break;
case 15:
gradeName = "小班";
result = false;
break;
case 16:
gradeName = "小小班";
result = false;
break;
case 17:
gradeName = "混龄班";
result = false;
break;
default: break;
}
//var className = int.Parse(searchResult[i].Class_Info.ClassCode.Substring(4, 2)).ToString();
var className = searchResult[i].Class_Info.ClassName.ToString();
var preciatechild = GetByModelChildWhereNew(className, gradeName);
if (result)
{
preciatechild = GetByModelChildWhere(className, gradeName);
}
var tempresult = Db.Student_DayandNight_Info.Where(preciate);
tempresult = tempresult.Where(preciatechild);
Student_DayandNight_Infos.AddRange(tempresult.ToList());
}
}
return(Student_DayandNight_Infos.AsQueryable().Where(precateresult).OrderByDescending(a => a.AddCreateDate).ToList());
}
public Expression <Func <Student_DayandNight_Info, bool> > GetByModelChildResultWhere(DayAndNightSearchViewModel dayAndNightSearchViewModel)
{
var predicate = WhereExtension.True <Student_DayandNight_Info>();//初始化where表达式SchoolName
if (dayAndNightSearchViewModel.GradeName != "")
{
predicate = predicate.And(p => p.GradeName == dayAndNightSearchViewModel.GradeName);
}
if (dayAndNightSearchViewModel.ClassName != "")
{
predicate = predicate.And(p => p.ClassName == dayAndNightSearchViewModel.ClassName);
}
return(predicate);
}
