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