/// <summary>
/// 查询催单信息
/// </summary>
/// <param name="reminderInfoSearchViewModel"></param>
/// <returns></returns>
public List <ReminderInfoSearchMiddlecs> ReminderInfo_Search(ReminderInfoSearchViewModel reminderInfoSearchViewModel)
{
List <Reminder_Info> reminder_Infos = _IReminderInfoRepository.SearchInfoByReminderWhere(reminderInfoSearchViewModel);
var satisfactionSearchMiddlecs = _IMapper.Map <List <Reminder_Info>, List <ReminderInfoSearchMiddlecs> >(reminder_Infos);
return(satisfactionSearchMiddlecs);
}
public ActionResult <ReminderInfoSearchResModel> Manage_Satisfaction_Search(ReminderInfoSearchViewModel reminderInfoSearchViewModel)
{
ReminderInfoSearchResModel reminderInfoSearchResModel = new ReminderInfoSearchResModel();
var satisfactionSearchResult = _IReminderInfoService.ReminderInfo_Search(reminderInfoSearchViewModel);
var TotalNum = _IReminderInfoService.ReminderInfo_Get_ALLNum(reminderInfoSearchViewModel);
reminderInfoSearchResModel.Reminder_Info = satisfactionSearchResult;
reminderInfoSearchResModel.isSuccess = true;
reminderInfoSearchResModel.baseViewModel.Message = "查询成功";
reminderInfoSearchResModel.baseViewModel.ResponseCode = 200;
reminderInfoSearchResModel.TotalNum = TotalNum;
_ILogger.Information("查询催单信息成功");
return(Ok(reminderInfoSearchResModel));
}
public List <Reminder_Info> SearchInfoByReminderWhere(ReminderInfoSearchViewModel reminderInfoSearchViewModel)
{
int SkipNum = reminderInfoSearchViewModel.pageViewModel.CurrentPageNum * reminderInfoSearchViewModel.pageViewModel.PageSize;
//查询条件
var predicate = SearchSatisfactionWhere(reminderInfoSearchViewModel);
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(reminderInfoSearchViewModel.pageViewModel.PageSize);
return(result.ToList());
}
//根据条件查询催单
private Expression <Func <Reminder_Info, bool> > SearchSatisfactionWhere(ReminderInfoSearchViewModel reminderInfoSearchViewModel)
{
var predicate = WhereExtension.True <Reminder_Info>();//初始化where表达式
predicate = predicate.And(p => p.status.Contains(reminderInfoSearchViewModel.status));
predicate = predicate.And(p => p.User_Info.User_Depart.Name.Contains(reminderInfoSearchViewModel.Name));
predicate = predicate.And(p => p.User_Info.UserName.Contains(reminderInfoSearchViewModel.UserName));
if (reminderInfoSearchViewModel.Repair_InfoId != null)
{
predicate = predicate.And(p => p.Repair_InfoId == reminderInfoSearchViewModel.Repair_InfoId);
}
if (reminderInfoSearchViewModel.AddDate != null)
{
predicate = predicate.And(p => p.AddDate == reminderInfoSearchViewModel.AddDate);
}
predicate = predicate.And(p => p.Repair_Info.RepairsTitle.Contains(reminderInfoSearchViewModel.RepairTitle));
return(predicate);
}
/// <summary>
/// 查询催单数量
/// </summary>
/// <param name="reminderInfoSearchViewModel"></param>
/// <returns></returns>
public int ReminderInfo_Get_ALLNum(ReminderInfoSearchViewModel reminderInfoSearchViewModel)
{
return(_IReminderInfoRepository.SearchInfoByReminderWhere(reminderInfoSearchViewModel).Count());
}
