/// <summary>
/// 分页查询店铺提现记录
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public static QueryPageModel <ShopWithDrawItem> GetShopWithDraw(WithdrawQuery query)
{
var model = _iBillingService.GetShopWithDraw(query);
QueryPageModel <ShopWithDrawItem> Models = new QueryPageModel <ShopWithDrawItem>();
List <ShopWithDrawItem> items = new List <ShopWithDrawItem>();
foreach (ShopWithDrawInfo mInfo in model.Models)
{
ShopWithDrawItem swdi = new ShopWithDrawItem();
swdi.Id = mInfo.Id;
swdi.Account = mInfo.Account;
swdi.AccountName = mInfo.AccountName;
swdi.AccountNo = long.Parse(mInfo.CashNo);
swdi.ApplyTime = mInfo.ApplyTime.ToString("yyyy-MM-dd HH:mm:ss");
swdi.CashAmount = mInfo.CashAmount.ToString("f2");
swdi.WithStatus = (int)mInfo.Status;
swdi.CashType = mInfo.CashType.ToDescription();
swdi.DealTime = mInfo.DealTime == null ? "" : mInfo.DealTime.Value.ToString("yyyy-MM-dd HH:mm:ss");
swdi.PlatRemark = mInfo.PlatRemark;
swdi.SellerId = mInfo.SellerId;
swdi.SellerName = mInfo.SellerName;
swdi.ShopId = mInfo.ShopId;
swdi.ShopName = mInfo.ShopName;
swdi.ShopRemark = mInfo.ShopRemark;
swdi.Status = mInfo.Status.ToDescription();
items.Add(swdi);
}
Models.Models = items;
Models.Total = model.Total;
return(Models);
}
/// <summary>
/// 分页获取店铺提现记录
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public QueryPageModel <ShopWithDrawInfo> GetShopWithDraw(WithdrawQuery query)
{
int total = 0;
var pendingQuery = ToWhere(query);
pendingQuery = pendingQuery.GetPage(out total, d => d.OrderByDescending(o => o.Id), query.PageNo, query.PageSize);
QueryPageModel <ShopWithDrawInfo> pageModel = new QueryPageModel <ShopWithDrawInfo>()
{
Models = pendingQuery.ToList(), Total = total
};
return(pageModel);
}
/// <summary>
/// 分页获取店铺提现记录
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public QueryPageModel <ShopWithDrawInfo> GetShopWithDraw(WithdrawQuery query)
{
var db = WhereBuilder(query);
switch (query.Sort.ToLower())
{
case "dealtime":
if (query.IsAsc)
{
db.OrderBy(p => p.DealTime);
}
else
{
db.OrderByDescending(p => p.DealTime);
}
break;
case "applytime":
if (query.IsAsc)
{
db.OrderBy(p => p.ApplyTime);
}
else
{
db.OrderByDescending(p => p.ApplyTime);
}
break;
case "cashamount":
if (query.IsAsc)
{
db.OrderBy(p => p.CashAmount);
}
else
{
db.OrderByDescending(p => p.CashAmount);
}
break;
default:
db.OrderByDescending(o => o.Id);
break;
}
var models = db.ToPagedList(query.PageNo, query.PageSize);
return(new QueryPageModel <ShopWithDrawInfo>()
{
Models = models, Total = models.TotalRecordCount
});
}
/// <summary>
/// 提现信息列表
/// </summary>
/// <returns></returns>
public ActionResult ExportShopWithDraw(DateTime?applyStartTime, DateTime?applyEndTime, DateTime?auditedStartTime, DateTime?auditedEndTime, long?staus)
{
var query = new WithdrawQuery()
{
ApplyStartTime = applyStartTime,
ApplyEndTime = applyEndTime,
AuditedStartTime = auditedStartTime,
AuditedEndTime = auditedEndTime,
Status = (Himall.CommonModel.WithdrawStaus?)staus,
ShopId = CurrentSellerManager.ShopId,
};
var models = BillingApplication.GetAllShopWithDraw(query);
return(ExcelView("提现明细", models));
}
private GetBuilder <ShopWithDrawInfo> WhereBuilder(WithdrawQuery query)
{
var pendingQuery = DbFactory.Default.Get <ShopWithDrawInfo>();
if (query.ApplyStartTime.HasValue)
{
pendingQuery.Where(a => a.ApplyTime >= query.ApplyStartTime.Value);
}
if (query.ApplyEndTime.HasValue)
{
var end = query.ApplyEndTime.Value.Date.AddDays(1);
pendingQuery.Where(a => a.ApplyTime < end);
}
if (query.AuditedStartTime.HasValue)
{
pendingQuery.Where(a => a.DealTime >= query.AuditedStartTime.Value);
}
if (query.AuditedEndTime.HasValue)
{
var end = query.AuditedEndTime.Value.Date.AddDays(1);
pendingQuery.Where(a => a.DealTime < end);
}
if (query.ShopId.HasValue)
{
pendingQuery.Where(a => a.ShopId == query.ShopId.Value);
}
if (!string.IsNullOrEmpty(query.ShopName))
{
pendingQuery.Where(a => a.ShopName.Contains(query.ShopName));
}
if (query.Status.HasValue)
{
pendingQuery.Where(a => a.Status == query.Status.Value);
}
if (query.Id.HasValue && query.Id.Value != 0)
{
pendingQuery.Where(a => a.Id == query.Id.Value);
}
if (query.Ids != null && query.Ids.Length > 0)
{
pendingQuery.Where(a => a.Id.ExIn(query.Ids));
}
return(pendingQuery);
}
public JsonResult List(DateTime?startDate, DateTime?endDate, DateTime?startDates, DateTime?endDates, long?WithdrawStaus, long?Id, int Status, int page, int rows)
{
WithdrawQuery query = new WithdrawQuery()
{
ApplyStartTime = startDate,
ApplyEndTime = endDate,
AuditedStartTime = startDates,
AuditedEndTime = endDates,
Id = Id,
Status = (Himall.CommonModel.WithdrawStaus?)WithdrawStaus,
ShopId = CurrentSellerManager.ShopId,
PageSize = rows,
PageNo = page
};
var model = BillingApplication.GetShopWithDraw(query);
return(Json(new { rows = model.Models, total = model.Total }));
}
private IQueryable <ShopWithDrawInfo> ToWhere(WithdrawQuery query)
{
var pendingQuery = Context.ShopWithDrawInfo.AsQueryable();
if (query.ApplyStartTime.HasValue)
{
pendingQuery = pendingQuery.Where(a => a.ApplyTime >= query.ApplyStartTime.Value);
}
if (query.ApplyEndTime.HasValue)
{
var end = query.ApplyEndTime.Value.Date.AddDays(1);
pendingQuery = pendingQuery.Where(a => a.ApplyTime < end);
}
if (query.AuditedStartTime.HasValue)
{
pendingQuery = pendingQuery.Where(a => a.DealTime >= query.AuditedStartTime.Value);
}
if (query.AuditedEndTime.HasValue)
{
var end = query.AuditedEndTime.Value.Date.AddDays(1);
pendingQuery = pendingQuery.Where(a => a.DealTime < end);
}
if (query.ShopId.HasValue)
{
pendingQuery = pendingQuery.Where(a => a.ShopId == query.ShopId.Value);
}
if (!string.IsNullOrEmpty(query.ShopName))
{
pendingQuery = pendingQuery.Where(a => a.ShopName.Contains(query.ShopName));
}
if (query.Status.HasValue)
{
pendingQuery = pendingQuery.Where(a => a.Status == query.Status.Value);
}
if (query.Id.HasValue && query.Id.Value != 0)
{
pendingQuery = pendingQuery.Where(a => a.Id == query.Id.Value);
}
return(pendingQuery);
}
public int GetShopWithDrawCount(WithdrawQuery query)
{
var db = WhereBuilder(query);
return(db.Count());
}
/// <summary>
/// 获取店铺提现记录
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public List <ShopWithDrawInfo> GetAllShopWithDraw(WithdrawQuery query)
{
var pendingQuery = WhereBuilder(query);
return(pendingQuery.OrderByDescending(a => a.Id).ToList());
}
public WithdrawQueryTest()
{
TestEnvironment.Init();
query = new WithdrawQuery();
}
public JsonResult List(WithdrawQuery query)
{
var model = BillingApplication.GetShopWithDraw(query);
return(Json(new { rows = model.Models, total = model.Total }));
}
/// <summary>
/// 导出分销订单业绩
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public ActionResult ExportToExcelShopWithDraw(WithdrawQuery query)
{
var orderResults = BillingApplication.GetAllShopWithDraw(query);
return(ExcelView("ExportShopWithDraw", "平台商家提现成功记录", orderResults));
}
/// <summary>
/// 获取店铺提现记录
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public List <ShopWithDrawInfo> GetShopWithDrawNoPage(WithdrawQuery query)
{
var pendingQuery = ToWhere(query);
return(pendingQuery.ToList());
}
