/// <summary> /// 查询服务的评价信息 /// </summary> /// <param name="satisfactionInfoAddViewModel"></param> /// <returns></returns> public List <SatisfactionInfoSearchMiddlecs> Satisfaction_Search(SatisfactionInfoSearchViewModel satisfactionInfoSearchViewModel) { List <Satisfaction_Info> satisfaction_Infos = _ISatisfactionInfoRepository.SearchInfoByRepairWhere(satisfactionInfoSearchViewModel); var satisfactionSearchMiddlecs = _IMapper.Map <List <Satisfaction_Info>, List <SatisfactionInfoSearchMiddlecs> >(satisfaction_Infos); return(satisfactionSearchMiddlecs); }
public List <Satisfaction_Info> SearchInfoByRepairWhere(SatisfactionInfoSearchViewModel satisfactionInfoSearchViewModel) { int SkipNum = satisfactionInfoSearchViewModel.pageViewModel.CurrentPageNum * satisfactionInfoSearchViewModel.pageViewModel.PageSize; //查询条件 var predicate = SearchSatisfactionWhere(satisfactionInfoSearchViewModel); var result = DbSet.Where(predicate).Include(b => b.User_Info) .ThenInclude(c => c.User_Depart) .Include(a => a.Repair_Info) .Where(s => s.User_Info.status != "1" && s.Repair_Info.status != "1") .OrderBy(o => o.AddDate) .Skip(SkipNum) .Take(satisfactionInfoSearchViewModel.pageViewModel.PageSize); return(result.ToList()); }
//根据条件查询报修 private Expression <Func <Satisfaction_Info, bool> > SearchSatisfactionWhere(SatisfactionInfoSearchViewModel satisfactionInfoSearchViewModel) { var predicate = WhereExtension.True <Satisfaction_Info>();//初始化where表达式 predicate = predicate.And(p => p.status.Contains(satisfactionInfoSearchViewModel.status)); predicate = predicate.And(p => p.User_Info.User_Depart.Name.Contains(satisfactionInfoSearchViewModel.Name)); predicate = predicate.And(p => p.User_Info.UserName.Contains(satisfactionInfoSearchViewModel.UserName)); if (satisfactionInfoSearchViewModel.Repair_InfoId != null) { predicate = predicate.And(p => p.Repair_InfoId == satisfactionInfoSearchViewModel.Repair_InfoId); } if (satisfactionInfoSearchViewModel.AddDate != null) { predicate = predicate.And(p => p.AddDate == satisfactionInfoSearchViewModel.AddDate); } predicate = predicate.And(p => p.Repair_Info.RepairsTitle.Contains(satisfactionInfoSearchViewModel.RepairTitle)); return(predicate); }
/// <summary> /// 查询服务的评价信息数量 /// </summary> /// <param name="satisfactionInfoAddViewModel"></param> /// <returns></returns> public int Satisfaction_Get_ALLNum(SatisfactionInfoSearchViewModel satisfactionInfoSearchViewModel) { return(_ISatisfactionInfoRepository.SearchInfoByRepairWhere(satisfactionInfoSearchViewModel).Count()); }
public ActionResult <SatisfactionInfoSearchResModel> Manage_Satisfaction_Search(SatisfactionInfoSearchViewModel satisfactionInfoSearchViewModel) { SatisfactionInfoSearchResModel satisfactionInfoSearchResModel = new SatisfactionInfoSearchResModel(); var satisfactionSearchResult = _ISatisfactionInfoService.Satisfaction_Search(satisfactionInfoSearchViewModel); var TotalNum = _ISatisfactionInfoService.Satisfaction_Get_ALLNum(satisfactionInfoSearchViewModel); satisfactionInfoSearchResModel.SatisfactionInfo_Info = satisfactionSearchResult; satisfactionInfoSearchResModel.isSuccess = true; satisfactionInfoSearchResModel.baseViewModel.Message = "查询成功"; satisfactionInfoSearchResModel.baseViewModel.ResponseCode = 200; satisfactionInfoSearchResModel.TotalNum = TotalNum; _ILogger.Information("查询评论信息成功"); return(Ok(satisfactionInfoSearchResModel)); }