/// <summary> /// 班车信息验证 /// </summary> public IDictionary <int, String> Bus_Payment_valide(BusUserValideViewModel busUserValideViewModel) { IDictionary <int, String> ErrorResult = new Dictionary <int, String>(); //查询缴费信息 IQueryable <Bus_Payment> Bus_Payments = _IBusUserRepository.SearchInfoByBusWhere(busUserValideViewModel); //查询班车信息 IQueryable <Bus_Info> bus_Infos = _IBusInfoRepository.GetAll(); //查询站点信息 IQueryable <Bus_Station> Bus_Stations = _IBusStationRepository.GetAll(); //查询线路信息 IQueryable <Bus_Line> Bus_Lines = _IBusLineRepository.GetAll(); //错误信息汇总 List <BusUserErrorMiddles> Errorqueryable = GetPayError(Bus_Payments, bus_Infos, Bus_Stations, Bus_Lines); //合成错误消息 for (int i = 0; i < Errorqueryable.Count(); i++) { if (i == 0) { if (Errorqueryable[i].BaseName == null || Errorqueryable[i].Status.Equals("1")) { ErrorResult.Add(Errorqueryable[i].Id, Errorqueryable[i].Username + "所选择的" + Errorqueryable[i].PayName + "已经删除,请重新选择。"); } else { ErrorResult.Add(Errorqueryable[i].Id, Errorqueryable[i].Username + "所选择的" + Errorqueryable[i].PayName + "已经修改,请重新选择。"); } } else { //查询某个key是否存在 if (ErrorResult.ContainsKey(Errorqueryable[i].Id)) { int key = Errorqueryable[i].Id; if (Errorqueryable[i].BaseName == null || Errorqueryable[i].Status.Equals("1")) { //将相同id的行的结果合并为一个,以文件信息返回出来 ErrorResult[key] += Errorqueryable[i].PayName + "已经不存在,请重新选择"; } else { ErrorResult[key] += Errorqueryable[i].PayName + "已经修改,请重新选择"; } } else { if (Errorqueryable[i].BaseName == null || Errorqueryable[i].Status.Equals("1")) { ErrorResult.Add(Errorqueryable[i].Id, Errorqueryable[i].Username + "所选择的" + Errorqueryable[i].PayName + "已经删除,请重新选择。"); } else { ErrorResult.Add(Errorqueryable[i].Id, Errorqueryable[i].Username + "所选择的" + Errorqueryable[i].PayName + "已经修改,请重新选择。"); } } } } return(ErrorResult); }
/// <summary> /// 查询人员缴费信息验证(重载,用于缴费单提交之前班车信息的验证) /// </summary> /// <param name="busUserSearchViewModel"></param> /// <returns></returns> public IQueryable <Bus_Payment> SearchInfoByBusWhere(BusUserValideViewModel busUserValideViewModel) { var predicate = SearchBusValideWhere(busUserValideViewModel); var result = DbSet.Where(predicate) .OrderBy(o => o.createDate); return(result); }
//根据条件查询班车 private Expression <Func <Bus_Payment, bool> > SearchBusValideWhere(BusUserValideViewModel busUserValideViewModel) { var predicate = WhereExtension.True <Bus_Payment>();//初始化where表达式 predicate = predicate.And(a => a.User_DepartId == busUserValideViewModel.User_DepartId); predicate = predicate.And(a => a.carDate.Value.Year == busUserValideViewModel.carDate.Value.Year && a.carDate.Value.Month == busUserValideViewModel.carDate.Value.Month); return(predicate); }
public ActionResult <BuUserValideResModel> Bus_Payment_Valide(BusUserValideViewModel busUserValideViewModel) { BuUserValideResModel buUserValideResModel = new BuUserValideResModel(); IDictionary <int, String> errorResult = _IBusUserService.Bus_Payment_valide(busUserValideViewModel); if (errorResult.Count > 0) { buUserValideResModel.isSuccess = false; buUserValideResModel.errorResult = errorResult; buUserValideResModel.baseViewModel.Message = "缴费单存在变更信息"; buUserValideResModel.baseViewModel.ResponseCode = 200; _ILogger.Information("验证班车缴费信息存在变更"); return(Ok(buUserValideResModel)); } else { buUserValideResModel.isSuccess = true; buUserValideResModel.errorResult = errorResult; buUserValideResModel.baseViewModel.Message = "班车缴费单不存在变更信息"; buUserValideResModel.baseViewModel.ResponseCode = 200; _ILogger.Information("班车缴费信息可以使用,无异常"); return(Ok(buUserValideResModel)); } }