/// <summary>
/// 查询本部门缴费时间列表
/// </summary>
/// <param name="busUserSearchTimeViewModel"></param>
/// <returns></returns>
private Expression <Func <Bus_Payment, bool> > SearchBusUserDateWhere(BusUserSearchTimeViewModel busUserSearchTimeViewModel)
{
var predicate = WhereExtension.True <Bus_Payment>();//初始化where表达式
predicate = predicate.And(a => a.status == "0");
predicate = predicate.And(a => a.User_DepartId.Value == busUserSearchTimeViewModel.User_DepartId);
return(predicate);
}
/// <summary>
/// 查询本部门人员缴费时间列表信息
/// </summary>
/// <param name="busUserSearchViewModel"></param>
/// <returns></returns>
public IQueryable <string> SearchInfoTimeWhere(BusUserSearchTimeViewModel busUserSearchTimeViewModel)
{
var predicate = SearchBusUserDateWhere(busUserSearchTimeViewModel);
var result = DbSet.Where(predicate).OrderByDescending(b => b.carDate)
.Select(a => a.carDate.Value.ToString("yyyy-MM")).Distinct();
return(result);
}
public ActionResult <BusUserTimeListSearchResModel> Bus_User_TimeList_Search(BusUserSearchTimeViewModel busUserSearchTimeViewModel)
{
BusUserTimeListSearchResModel busUserTimeListSearchResModel = new BusUserTimeListSearchResModel();
var BusUserSearchResult = _IBusUserService.Bus_User_TimeList_Search(busUserSearchTimeViewModel);
busUserTimeListSearchResModel.bus_user_time_Info = BusUserSearchResult;
busUserTimeListSearchResModel.isSuccess = true;
busUserTimeListSearchResModel.baseViewModel.Message = "查询成功";
busUserTimeListSearchResModel.baseViewModel.ResponseCode = 200;
busUserTimeListSearchResModel.TotalNum = BusUserSearchResult.Count;
_ILogger.Information("查询所有用户缴费信息成功");
return(Ok(busUserTimeListSearchResModel));
}
/// <summary>
/// 查询出所有时间
/// </summary>
/// <param name="busUserSearchViewModel"></param>
/// <returns></returns>
public List <string> Bus_User_TimeList_Search(BusUserSearchTimeViewModel busUserSearchTimeViewModel)
{
List <string> bus_Payments = _IBusUserRepository.SearchInfoTimeWhere(busUserSearchTimeViewModel).ToList();
return(bus_Payments);
}
