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