/// <summary> /// 报修表单查询 /// </summary> /// <param name="repairInfoSearchViewModel"></param> /// <returns></returns> public List <RepairInfoSearchMiddlecs> Repair_Search(RepairInfoSearchViewModel repairInfoSearchViewModel) { RepairInfoSearchMiddlecs repairSearches = new RepairInfoSearchMiddlecs(); List <Repair_Info> line_Infos = _IRepairInfoRepository.SearchInfoByRepairWhere(repairInfoSearchViewModel).ToList(); var repairSearchMiddlecs = _IMapper.Map <List <Repair_Info>, List <RepairInfoSearchMiddlecs> >(line_Infos); return(repairSearchMiddlecs); }
//根据条件查询报修 private Expression <Func <Repair_Info, bool> > SearchRepairWhere(RepairInfoSearchViewModel repairInfoSearchViewModel) { var predicate = WhereExtension.True <Repair_Info>();//初始化where表达式 predicate = predicate.And(p => p.User_Info.UserName.Contains(repairInfoSearchViewModel.UserName)); predicate = predicate.And(p => p.User_Depart.Name.Contains(repairInfoSearchViewModel.Name)); predicate = predicate.And(p => p.RepairsTitle.Contains(repairInfoSearchViewModel.RepairsTitle)); predicate = predicate.And(p => p.RepairsType.Contains(repairInfoSearchViewModel.RepairsType)); predicate = predicate.And(p => p.status.Contains(repairInfoSearchViewModel.status)); return(predicate); }
public IQueryable <Repair_Info> SearchInfoByRepairWhere(RepairInfoSearchViewModel repairInfoSearchViewModel) { int SkipNum = repairInfoSearchViewModel.pageViewModel.CurrentPageNum * repairInfoSearchViewModel.pageViewModel.PageSize; var preciateByRepair = SearchRepairWhere(repairInfoSearchViewModel); IQueryable <Repair_Info> repair_Infos = Db.repair_Info.Where(preciateByRepair); IQueryable <Repair_Info> SearchResultTemp = repair_Infos.Include(a => a.User_Info) .Include(a => a.User_Depart) .Skip(SkipNum) .Take(repairInfoSearchViewModel.pageViewModel.PageSize).OrderBy(o => o.repairsDate); return(SearchResultTemp); }
public ActionResult <RepairInfoSearchResModel> Repair_Search(RepairInfoSearchViewModel repairInfoSearchViewModel) { RepairInfoSearchResModel repairInfoSearchResModel = new RepairInfoSearchResModel(); var repairSearchResult = _IRepairService.Repair_Search(repairInfoSearchViewModel); var TotalNum = _IRepairService.Repair_Get_ALLNum(repairInfoSearchViewModel); repairInfoSearchResModel.repair_Infos = repairSearchResult; repairInfoSearchResModel.isSuccess = true; repairInfoSearchResModel.baseViewModel.Message = "查询成功"; repairInfoSearchResModel.baseViewModel.ResponseCode = 200; repairInfoSearchResModel.TotalNum = TotalNum; _ILogger.Information("查询报修信息成功"); return(Ok(repairInfoSearchResModel)); }
public IQueryable <Repair_Info> GetInfoByRepairAll(RepairInfoSearchViewModel repairInfoSearchViewMode) { var predicate = SearchRepairWhere(repairInfoSearchViewMode); return(DbSet.Where(predicate)); }