/// <summary>
/// 分页获取平台的收支明细
/// </summary>
/// <param name="query">查询实体</param>
/// <returns></returns>
public static QueryPageModel <PlatAccountItem> GetPlatAccountItem(PlatAccountItemQuery query)
{
var model = _iBillingService.GetPlatAccountItem(query);
QueryPageModel <PlatAccountItem> item = new QueryPageModel <PlatAccountItem>();
item.Total = model.Total;
List <PlatAccountItem> items = new List <PlatAccountItem>();
foreach (var m in model.Models)
{
PlatAccountItem PlatAccountItem = new PlatAccountItem();
PlatAccountItem.AccountNo = m.AccountNo;
PlatAccountItem.Balance = m.Balance.ToString();
PlatAccountItem.CreateTime = m.CreateTime.ToString("yyyy-MM-dd HH:mm:ss");
PlatAccountItem.DetailId = m.DetailId;
PlatAccountItem.PlatAccountType = m.TradeType;
if (m.IsIncome)
{
PlatAccountItem.Income = m.Amount.ToString();
}
else
{
PlatAccountItem.Expenditure = m.Amount.ToString();
}
PlatAccountItem.Id = m.Id;
items.Add(PlatAccountItem);
}
item.Models = items;
return(item);
}
/// <summary>
/// 分页获取平台流水
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public QueryPageModel <PlatAccountItemInfo> GetPlatAccountItem(PlatAccountItemQuery query)
{
var db = ToWhere(query);
var models = db.OrderByDescending(o => o.Id).ToPagedList(query.PageNo, query.PageSize);
return(new QueryPageModel <PlatAccountItemInfo>
{
Models = models,
Total = models.TotalRecordCount
});
}
/// <summary>
/// 获取平台帐户流水
/// </summary>
/// <param name="startDate"></param>
/// <param name="endDate"></param>
/// <param name="type"></param>
/// <param name="page"></param>
/// <param name="rows"></param>
/// <returns></returns>
public ActionResult ExportPlatAccountItems(DateTime?startDate, DateTime?endDate, PlatAccountType?type)
{
PlatAccountItemQuery query = new PlatAccountItemQuery();
query.TimeStart = startDate;
query.TimeEnd = endDate;
query.PlatAccountType = type;
var models = BillingApplication.GetAllPlatAccountItem(query);
return(ExcelView("结余明细", models));
}
/// <summary>
/// 分页获取平台流水
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public QueryPageModel <PlatAccountItemInfo> GetPlatAccountItem(PlatAccountItemQuery query)
{
int total = 0;
var ItemQuery = ToWhere(query);
ItemQuery = ItemQuery.GetPage(out total, d => d.OrderByDescending(o => o.Id), query.PageNo, query.PageSize);
QueryPageModel <PlatAccountItemInfo> pageModel = new QueryPageModel <PlatAccountItemInfo>()
{
Models = ItemQuery.ToList(), Total = total
};
return(pageModel);
}
public JsonResult GetPlatAccountItemlist(DateTime?startDate, DateTime?endDate, PlatAccountType?type, int page, int rows)
{
PlatAccountItemQuery query = new PlatAccountItemQuery();
query.PageNo = page;
query.PageSize = rows;
query.TimeStart = startDate;
query.TimeEnd = endDate;
query.PlatAccountType = type;
var model = BillingApplication.GetPlatAccountItem(query);
var result = new { rows = model.Models, total = model.Total };
return(Json(result));
}
private GetBuilder <PlatAccountItemInfo> ToWhere(PlatAccountItemQuery query)
{
var ItemQuery = DbFactory.Default.Get <PlatAccountItemInfo>();
if (query.PlatAccountType.HasValue)
{
ItemQuery.Where(a => a.TradeType == query.PlatAccountType.Value);
}
if (query.TimeStart.HasValue)
{
ItemQuery.Where(a => a.CreateTime >= query.TimeStart.Value);
}
if (query.TimeEnd.HasValue)
{
var end = query.TimeEnd.Value.Date.AddDays(1);
ItemQuery.Where(a => a.CreateTime < end);
}
return(ItemQuery);
}
private IQueryable <PlatAccountItemInfo> ToWhere(PlatAccountItemQuery query)
{
IQueryable <PlatAccountItemInfo> ItemQuery = Context.PlatAccountItemInfo.AsQueryable();
if (query.PlatAccountType.HasValue)
{
ItemQuery = ItemQuery.Where(a => a.TradeType == query.PlatAccountType.Value);
}
if (query.TimeStart.HasValue)
{
ItemQuery = ItemQuery.Where(a => a.CreateTime >= query.TimeStart.Value);
}
if (query.TimeEnd.HasValue)
{
var end = query.TimeEnd.Value.Date.AddDays(1);
ItemQuery = ItemQuery.Where(a => a.CreateTime < end);
}
return(ItemQuery);
}
/// <summary>
/// 分页获取平台流水
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public List <PlatAccountItemInfo> GetAllPlatAccountItem(PlatAccountItemQuery query)
{
var itemQuery = ToWhere(query);
return(itemQuery.OrderByDescending(p => p.Id).ToList());
}
