/// <summary>
/// 分页获取门店已结算订单
/// </summary>
/// <param name="page"></param>
/// <param name="pagesize"></param>
/// <param name="startDate"></param>
/// <param name="endDate"></param>
/// <param name="orderId"></param>
/// <returns></returns>
public DataGridModel <DTO.SettledOrders> GetSettlementOrders(int page = 1, int pagesize = 10,
DateTime?startDate = null, DateTime?endDate = null, long?orderId = null, long?WeekSettlementId = null)
{
CheckShopManageLogin();
var shop = CurrentShop;
long shopId = shop.Id;
var query = new SettlementOrderQuery()
{
OrderStart = startDate,
OrderEnd = endDate,
PageNo = page,
PageSize = pagesize,
OrderId = orderId,
ShopId = shopId,
WeekSettlementId = WeekSettlementId
};
var model = BillingApplication.GetSettlementOrders(query);
DataGridModel <DTO.SettledOrders> result = new DataGridModel <DTO.SettledOrders>()
{
rows = model.Models,
total = model.Total
};
return(result);
}
/// <summary>
/// 分页获取已结算订单列表
/// </summary>
/// <param name="query">查询实体</param>
/// <returns></returns>
public static QueryPageModel <SettledOrders> GetSettlementOrders(SettlementOrderQuery query)
{
QueryPageModel <SettledOrders> orders = new QueryPageModel <SettledOrders>();
var model = _iBillingService.GetSettlementOrders(query);
orders.Total = model.Total;
List <SettledOrders> SettledOrders = new List <SettledOrders>();
foreach (var m in model.Models)
{
SettledOrders o = new SettledOrders();
o.DistributorCommission = m.BrokerageAmount - m.ReturnBrokerageAmount;
o.OrderAmount = m.OrderAmount;
o.OrderFinshTime = m.OrderFinshDate.ToString("yyyy-MM-dd HH:mm:ss");
o.OrderId = m.OrderId;
o.PlatCommission = m.CommissionAmount - m.RefundCommisAmount;
o.RefundAmount = m.RefundTotalAmount;
o.SettledTime = m.Date.ToString("yyyy-MM-dd HH:mm:ss");
o.SettlementAmount = m.SettlementAmount;
o.ShopName = m.ShopName;
o.ShopId = m.ShopId;
o.PaymentTypeName = m.PaymentTypeName;
SettledOrders.Add(o);
}
orders.Models = SettledOrders;
return(orders);
}
/// <summary>
/// 获取已结算订单
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public static List <SettledOrders> GetSettlementOrdersNoPage(SettlementOrderQuery query)
{
var models = _iBillingService.GetSettlementOrdersNoPage(query);
var settledOrders = new List <SettledOrders>();
foreach (var m in models)
{
var o = new SettledOrders();
o.DistributorCommission = m.BrokerageAmount - m.ReturnBrokerageAmount;
o.OrderAmount = m.OrderAmount;
o.OrderFinshTime = m.OrderFinshDate.ToString("yyyy-MM-dd HH:mm:ss");
o.OrderId = m.OrderId;
o.PlatCommission = m.CommissionAmount - m.RefundCommisAmount;
o.RefundAmount = m.RefundTotalAmount;
o.SettledTime = m.Date.ToString("yyyy-MM-dd HH:mm:ss");
o.SettlementAmount = m.SettlementAmount;
o.ShopName = m.ShopName;
o.ShopId = m.ShopId;
o.PaymentTypeName = m.PaymentTypeName;
o.OpenCommission = m.OpenCommission;
o.JoinCommission = m.JoinCommission;
settledOrders.Add(o);
}
return(settledOrders);
}
private GetBuilder <AccountDetailInfo> ToWhere(SettlementOrderQuery query)
{
//var accountDetailQuery = Context.AccountDetailInfo.AsQueryable();
var accountDetailQuery = DbFactory.Default.Get <AccountDetailInfo>();
if (query.ShopId.HasValue)
{
accountDetailQuery.Where(a => a.ShopId == query.ShopId.Value);
}
if (query.OrderId.HasValue)
{
accountDetailQuery.Where(a => a.OrderId == query.OrderId.Value);
}
if (query.OrderStart.HasValue)
{
accountDetailQuery.Where(a => a.OrderFinshDate >= query.OrderStart.Value);
}
if (query.OrderEnd.HasValue)
{
var end = query.OrderEnd.Value.Date.AddDays(1);
accountDetailQuery.Where(a => a.OrderFinshDate < end);
}
if (query.SettleStart.HasValue)
{
accountDetailQuery.Where(a => a.Date >= query.SettleStart.Value);
}
if (query.SettleEnd.HasValue)
{
var end = query.SettleEnd.Value.Date.AddDays(1);
accountDetailQuery.Where(a => a.Date < end);
}
if (!string.IsNullOrEmpty(query.ShopName))
{
accountDetailQuery.Where(a => a.ShopName.Contains(query.ShopName));
}
if (!string.IsNullOrEmpty(query.PaymentName))
{
if (string.Equals(query.PaymentName, "组合支付"))
{
accountDetailQuery.Where(a => a.PaymentTypeName.Contains("+"));
}
else
{
accountDetailQuery.Where(a => a.PaymentTypeName.Contains(query.PaymentName));
}
}
if (query.WeekSettlementId.HasValue && query.WeekSettlementId.Value != 0)
{
var detailId = query.WeekSettlementId.Value;
accountDetailQuery.Where(a => a.AccountId == detailId);
}
return(accountDetailQuery);
}
/// <summary>
/// 分页获取已结算订单
/// </summary>
/// <param name="query">结算订单查询实体</param>
/// <returns></returns>
public QueryPageModel <AccountDetailInfo> GetSettlementOrders(SettlementOrderQuery query)
{
var accountDetailQuery = ToWhere(query);
var models = accountDetailQuery.OrderByDescending(o => o.Id).ToPagedList(query.PageNo, query.PageSize);
QueryPageModel <AccountDetailInfo> pageModel = new QueryPageModel <AccountDetailInfo>()
{
Models = models, Total = models.TotalRecordCount
};
return(pageModel);
}
/// <summary>
/// 分页获取已结算订单
/// </summary>
/// <param name="query">结算订单查询实体</param>
/// <returns></returns>
public QueryPageModel <AccountDetailInfo> GetSettlementOrders(SettlementOrderQuery query)
{
int total = 0;
var accountDetailQuery = ToWhere(query);
accountDetailQuery = accountDetailQuery.GetPage(out total, d => d.OrderByDescending(o => o.Id), query.PageNo, query.PageSize);
QueryPageModel <AccountDetailInfo> pageModel = new QueryPageModel <AccountDetailInfo>()
{
Models = accountDetailQuery.ToList(), Total = total
};
return(pageModel);
}
/// <summary>
/// 导出已结算预约单
/// </summary>
/// <param name="startDate"></param>
/// <param name="endDate"></param>
/// <param name="orderId"></param>
/// <param name="fileName"></param>
/// <returns></returns>
public ActionResult ExportSettlementOrder(DateTime?startDate, DateTime?endDate, DateTime?BillingstartDate, DateTime?BillingendDate, long?orderId, long?detailId)
{
var query = new SettlementOrderQuery();
query.OrderStart = startDate;
query.OrderEnd = endDate;
query.SettleStart = BillingstartDate;
query.SettleEnd = BillingendDate;
query.OrderId = orderId;
query.ShopId = CurrentSellerManager.ShopId;
query.WeekSettlementId = detailId;
var models = BillingApplication.GetSettlementOrdersNoPage(query);
return(ExcelView("已结算预约单", models));
}
/// <summary>
/// 导出已结算订单
/// </summary>
/// <param name="startDate"></param>
/// <param name="endDate"></param>
/// <param name="BillingstartDate"></param>
/// <param name="BillingendDate"></param>
/// <param name="shopName"></param>
/// <param name="paymentName"></param>
/// <param name="orderId"></param>
/// <param name="detailId"></param>
/// <returns></returns>
public ActionResult ExportSettlementOrders(DateTime?startDate, DateTime?endDate, DateTime?BillingstartDate, DateTime?BillingendDate, long?shopId, string paymentName, long?orderId, long?detailId)
{
var query = new SettlementOrderQuery();
query.OrderStart = startDate;
query.OrderEnd = endDate;
query.WeekSettlementId = detailId;
query.SettleStart = BillingstartDate;
query.SettleEnd = BillingendDate;
query.PaymentName = paymentName;
query.OrderId = orderId;
query.ShopId = shopId;
var models = BillingApplication.GetAllSettlementOrders(query);
return(ExcelView("已结算订单", models));
}
private IQueryable <AccountDetailInfo> ToWhere(SettlementOrderQuery query)
{
var accountDetailQuery = Context.AccountDetailInfo.AsQueryable();
if (query.ShopId.HasValue)
{
accountDetailQuery = accountDetailQuery.Where(a => a.ShopId == query.ShopId.Value);
}
if (query.OrderId.HasValue)
{
accountDetailQuery = accountDetailQuery.Where(a => a.OrderId == query.OrderId.Value);
}
if (query.OrderStart.HasValue)
{
accountDetailQuery = accountDetailQuery.Where(a => a.OrderFinshDate >= query.OrderStart.Value);
}
if (query.OrderEnd.HasValue)
{
var end = query.OrderEnd.Value.Date.AddDays(1);
accountDetailQuery = accountDetailQuery.Where(a => a.OrderFinshDate < end);
}
if (query.SettleStart.HasValue)
{
accountDetailQuery = accountDetailQuery.Where(a => a.Date >= query.SettleStart.Value);
}
if (query.SettleEnd.HasValue)
{
var end = query.SettleEnd.Value.Date.AddDays(1);
accountDetailQuery = accountDetailQuery.Where(a => a.Date < end);
}
if (!string.IsNullOrEmpty(query.ShopName))
{
accountDetailQuery = accountDetailQuery.Where(a => a.ShopName.Contains(query.ShopName));
}
if (!string.IsNullOrEmpty(query.PaymentName))
{
accountDetailQuery = accountDetailQuery.Where(a => a.PaymentTypeName == query.PaymentName);
}
if (query.WeekSettlementId.HasValue && query.WeekSettlementId.Value != 0)
{
var detailId = query.WeekSettlementId.Value;
accountDetailQuery = accountDetailQuery.Where(a => a.AccountId == detailId);
}
return(accountDetailQuery);
}
public JsonResult SettlementOrderList(DateTime?startDate, DateTime?endDate, DateTime?BillingstartDate, DateTime?BillingendDate, long?orderId, long?detailId, int page, int rows)
{
var query = new SettlementOrderQuery();
query.OrderStart = startDate;
query.OrderEnd = endDate;
query.SettleStart = BillingstartDate;
query.SettleEnd = BillingendDate;
query.WeekSettlementId = detailId;
query.PageNo = page;
query.PageSize = rows;
query.OrderId = orderId;
query.ShopId = CurrentSellerManager.ShopId;
var model = BillingApplication.GetSettlementOrders(query);
var result = new { rows = model.Models, total = model.Total };
return(Json(result));
}
/// <summary>
/// 获取已结算订单
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public List <AccountDetailInfo> GetAllSettlementOrders(SettlementOrderQuery query)
{
var accountDetailQuery = ToWhere(query);
return(accountDetailQuery.ToList());
}
