public ActionResult <BusUserAddResModel> Bus_PayMent_Template_Add(BusUserSearchViewModel busUserSearchViewModel)
{
int Bus_User_Add_Count;
Bus_User_Add_Count = _IBusUserService.Bus_PayMent_Template(busUserSearchViewModel);
BusUserAddResModel busUserAddResModel = new BusUserAddResModel();
if (Bus_User_Add_Count > 0)
{
busUserAddResModel.IsSuccess = true;
busUserAddResModel.AddCount = Bus_User_Add_Count;
busUserAddResModel.baseViewModel.Message = "添加成功";
busUserAddResModel.baseViewModel.ResponseCode = 200;
_ILogger.Information("增加用户缴费信息成功");
return(Ok(busUserAddResModel));
}
else
{
busUserAddResModel.IsSuccess = false;
busUserAddResModel.AddCount = 0;
busUserAddResModel.baseViewModel.Message = "添加失败";
busUserAddResModel.baseViewModel.ResponseCode = 200;
_ILogger.Information("增加用户缴费信息失败");
return(Ok(busUserAddResModel));
}
}
/// <summary>
/// 查询出人员缴费信息
/// </summary>
/// <param name="busUserSearchViewModel"></param>
/// <returns></returns>
public List <BusUserSearchMiddlecs> Bus_User_Search(BusUserSearchViewModel busUserSearchViewModel)
{
BusUserSearchMiddlecs busUserSearchMiddlecs = new BusUserSearchMiddlecs();
List <Bus_Payment> bus_Payments = _IBusUserRepository.SearchInfoByBusWhere(busUserSearchViewModel).ToList();
var bus_User_Search = _IMapper.Map <List <Bus_Payment>, List <BusUserSearchMiddlecs> >(bus_Payments);
return(bus_User_Search);
}
/// <summary>
/// 查询当前条件下所有人的缴费总和
/// </summary>
/// <param name="busUserSearchViewModel"></param>
/// <returns></returns>
public int Bus_UserExpen_Search(BusUserSearchViewModel busUserSearchViewModel)
{
List <Bus_Payment> bus_Payments = _IBusUserRepository.SearchInfoByBusWhere(busUserSearchViewModel).ToList();
int TotalExpen = 0;
for (int i = 0; i < bus_Payments.Count; i++)
{
TotalExpen += Convert.ToInt32(bus_Payments[i].Expense);//当前条件下，每个人应交费用总和
}
return(TotalExpen);
}
/// <summary>
/// 查询人员缴费信息（重载,最普通的查询）
/// </summary>
/// <param name="busUserSearchViewModel"></param>
/// <returns></returns>
public List <int> SearchInfoByBusDistinctWhere(BusUserSearchViewModel busUserSearchViewModel)
{
//int SkipNum = busUserSearchViewModel.pageViewModel.CurrentPageNum * busUserSearchViewModel.pageViewModel.PageSize;
var predicate = SearchBusUserWhere2(busUserSearchViewModel);
var result = DbSet.Where(predicate).Select(a => a.Bus_LineId.Value).Distinct()
.ToList();
return(result);
}
/// <summary>
/// 查询人员缴费信息（重载,最普通的查询）
/// </summary>
/// <param name="busUserSearchViewModel"></param>
/// <returns></returns>
public IQueryable <Bus_Payment> SearchInfoByBusWhere4(BusUserSearchViewModel busUserSearchViewModel)
{
int SkipNum = busUserSearchViewModel.pageViewModel.CurrentPageNum * busUserSearchViewModel.pageViewModel.PageSize;
var predicate = SearchBusUserWhere4(busUserSearchViewModel);
var result = DbSet.Where(predicate).OrderBy(o => o.Id)
.Skip(SkipNum)
.Take(busUserSearchViewModel.pageViewModel.PageSize);
return(result);
}
//根据条件查询班车
private Expression <Func <Bus_Payment, bool> > SearchBusUserWhere(BusUserSearchViewModel busUserSearchViewModel)
{
var predicate = WhereExtension.True <Bus_Payment>();//初始化where表达式
if (busUserSearchViewModel.Repair_InfoId != null)
{
predicate = predicate.And(a => a.Repair_InfoId == busUserSearchViewModel.Repair_InfoId);
}
if (busUserSearchViewModel.Bus_Payment_OrderId != null)
{
predicate = predicate.And(a => a.Bus_Payment_OrderId == busUserSearchViewModel.Bus_Payment_OrderId);
}
predicate = predicate.And(a => a.Bus_Payment_OrderId == null);
predicate = predicate.And(a => a.UserName.Contains(busUserSearchViewModel.UserName));
if (busUserSearchViewModel.User_DepartId != "")
{
predicate = predicate.And(a => a.User_DepartId.ToString() == busUserSearchViewModel.User_DepartId);
}
if (busUserSearchViewModel.Bus_LineId != "")
{
predicate = predicate.And(a => a.Bus_LineId.ToString() == (busUserSearchViewModel.Bus_LineId));
}
if (busUserSearchViewModel.Bus_StationId != "")
{
predicate = predicate.And(a => a.Bus_StationId.ToString() == (busUserSearchViewModel.Bus_StationId));
}
if (busUserSearchViewModel.User_InfoId != "")
{
predicate = predicate.And(a => a.User_InfoId.ToString() == (busUserSearchViewModel.User_InfoId));
}
predicate = predicate.And(a => a.status == (busUserSearchViewModel.status));
if (busUserSearchViewModel.Expense != "")
{
predicate = predicate.And(a => a.Expense == (busUserSearchViewModel.Expense));
}
if (busUserSearchViewModel.carDate != null)
{
predicate = predicate.And(a => a.carDate.Value.Year == busUserSearchViewModel.carDate.Value.Year &&
a.carDate.Value.Month == busUserSearchViewModel.carDate.Value.Month);
}
return(predicate);
}
//根据条件查询班车
private Expression <Func <Bus_Payment, bool> > SearchBusUserWhere2(BusUserSearchViewModel busUserSearchViewModel)
{
var predicate = WhereExtension.True <Bus_Payment>();//初始化where表达式
if (busUserSearchViewModel.User_DepartId != "")
{
predicate = predicate.And(a => a.User_DepartId.ToString() == (busUserSearchViewModel.User_DepartId));
}
if (busUserSearchViewModel.carDate != null)
{
predicate = predicate.And(a => a.carDate.Value.Year == busUserSearchViewModel.carDate.Value.Year &&
a.carDate.Value.Month == busUserSearchViewModel.carDate.Value.Month);
}
predicate = predicate.And(a => a.status == "0" || a.status == "2");
return(predicate);
}
public ActionResult <BusUserSearchResModel> Bus_User_Search(BusUserSearchViewModel busUserSearchViewModel)
{
BusUserSearchResModel busUserSearchResModel = new BusUserSearchResModel();
var BusUserSearchResult = _IBusUserService.Bus_User_Search(busUserSearchViewModel);
int TotalExpen = _IBusUserService.Bus_UserExpen_Search(busUserSearchViewModel);//应缴费用总和
var TotalNum = _IBusUserService.Bus_User_Get_ALLNum(busUserSearchViewModel);
busUserSearchResModel.bus_user_Info = BusUserSearchResult;
busUserSearchResModel.isSuccess = true;
busUserSearchResModel.baseViewModel.Message = "查询成功";
busUserSearchResModel.baseViewModel.ResponseCode = 200;
busUserSearchResModel.TotalNum = TotalNum;
busUserSearchResModel.TotalExpen = TotalExpen;
_ILogger.Information("查询所有用户缴费信息成功");
return(Ok(busUserSearchResModel));
}
/// <summary>
/// 根据以前某月的缴费信息，生成当前月的缴费信息
/// </summary>
/// <param name="busUserSearchViewModel"></param>
/// <returns></returns>
public int Bus_PayMent_Template(BusUserSearchViewModel busUserSearchViewModel)
{
List <Bus_Payment> bus_Payments = _IBusUserRepository.SearchInfoByBusWhere(busUserSearchViewModel).ToList();
//先以之前的月份为模板进行添加
List <BusUserAddViewModel> busUserAddViewModel = new List <BusUserAddViewModel>();
for (int j = 0; j < bus_Payments.Count; j++)
{
var bus_Info = _IMapper.Map <Bus_Payment, BusUserAddViewModel>(bus_Payments[j]);//把查询结果中的主键列去掉
busUserAddViewModel.Add(bus_Info);
}
//按照模板添加后，更新日期为当前年份和月份
NowDateUpdateViewModel nowDateUpdateViewModel = new NowDateUpdateViewModel();
nowDateUpdateViewModel.carDate = DateTime.Now;//当前年月
for (int i = 0; i < bus_Payments.Count; i++)
{
var bus_user_Info = _IMapper.Map <NowDateUpdateViewModel, BusUserAddViewModel>(nowDateUpdateViewModel, busUserAddViewModel[i]);
var Bus_Payment = _IMapper.Map <BusUserAddViewModel, Bus_Payment>(busUserAddViewModel[i]);
_IBusUserRepository.Add(Bus_Payment);
}
return(_IBusUserRepository.SaveChanges());
}
/// <summary>
/// 查询班车缴费清单表
/// </summary>
/// <param name="busUserSearchViewModell"></param>
/// <returns></returns>
public int Bus_User_Get_ALLNum(BusUserSearchViewModel busUserSearchViewModell)
{
return(_IBusUserRepository.GetInfoByBusAll(busUserSearchViewModell).Count());
}
public IQueryable <Bus_Payment> GetInfoByBusAll(BusUserSearchViewModel busUserSearchViewModel)
{
var predicate = SearchBusUserWhere(busUserSearchViewModel);
return(DbSet.Where(predicate));
}
