/// <summary>
/// 查询人员缴费信息(重载，用户初始化当月的班车缴费清单而查询模板清单的方法)
/// </summary>
/// <param name="busUserSearchViewModel"></param>
/// <returns></returns>
public IQueryable <Bus_Payment> SearchInfoByBusWhere(BusPaymentUpdateViewModel busPamentUpdateViewModel)
{
var predicate = SearchBusUserWhere(busPamentUpdateViewModel);
var result = DbSet.Where(predicate)
.OrderBy(o => o.createDate);
return(result);
}
private Expression <Func <Bus_Payment, bool> > SearchBusUserWhere(BusPaymentUpdateViewModel busPamentUpdateViewModel)
{
var predicate = WhereExtension.True <Bus_Payment>();//初始化where表达式
predicate = predicate.And(a => a.status == "0");
predicate = predicate.And(a => a.User_DepartId == busPamentUpdateViewModel.User_DepartId);
predicate = predicate.And(a => a.carDate.Value.Year == busPamentUpdateViewModel.carDate.Year &&
a.carDate.Value.Month == busPamentUpdateViewModel.carDate.Month);
return(predicate);
}
/// <summary>
/// 更新人员缴费信息表单id列，将班车缴费表和流程表单id绑定
/// </summary>
/// <param name="busPamentUpdateViewModel"></param>
/// <returns></returns>
public int Bus_PayMent_Update(BusPaymentUpdateViewModel busPamentUpdateViewModel)
{
List <Bus_Payment> bus_user_Info = _IBusUserRepository.SearchInfoByBusWhere(busPamentUpdateViewModel).ToList();
for (int i = 0; i < bus_user_Info.Count; i++)
{
var temp = _IMapper.Map <BusPaymentUpdateViewModel, Bus_Payment>(busPamentUpdateViewModel, bus_user_Info[i]);
_IBusUserRepository.Update(temp);
}
return(_IBusUserRepository.SaveChanges());
}
public ActionResult <BusPaymentUpdateResModel> Bus_Payment_Update(BusPaymentUpdateViewModel busPamentUpdateViewModel)
{
BusPaymentUpdateResModel busPamentUpdateResModel = new BusPaymentUpdateResModel();
int UpdateRowNum = _IBusUserService.Bus_PayMent_Update(busPamentUpdateViewModel);
if (UpdateRowNum > 0)
{
busPamentUpdateResModel.IsSuccess = true;
busPamentUpdateResModel.AddCount = UpdateRowNum;
busPamentUpdateResModel.baseViewModel.Message = "更新成功";
busPamentUpdateResModel.baseViewModel.ResponseCode = 200;
_ILogger.Information("增加用户缴费表单id信息成功");
return(Ok(busPamentUpdateResModel));
}
else
{
busPamentUpdateResModel.IsSuccess = false;
busPamentUpdateResModel.AddCount = 0;
busPamentUpdateResModel.baseViewModel.Message = "更新失败";
busPamentUpdateResModel.baseViewModel.ResponseCode = 400;
_ILogger.Information("增加用户缴费表单id信息失败");
return(BadRequest(busPamentUpdateResModel));
}
}
