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