/// <summary> /// 分销订单列表(忽略分页) /// </summary> /// <param name="query"></param> /// <param name="isShopName">是否填充商铺名称</param> /// <param name="isShopName">是否填分销员(会员)</param> /// <returns></returns> public static List <BrokerageOrder> GetBrokerageOrdersAll(BrokerageOrderQuery query, bool isShopName = false, bool isSupperior = false) { var data = Service.GetBrokerageOrdersAll(query); if (isShopName) { //填充 门店名 var shops = GetService <IShopService>().GetShops(data.Select(p => p.ShopId)); if (isSupperior)//填充分销员 { var memberIds = new List <long>(); memberIds.AddRange(data.Select(p => p.SuperiorId1)); memberIds.AddRange(data.Select(p => p.SuperiorId2)); memberIds.AddRange(data.Select(p => p.SuperiorId3)); var members = GetService <IMemberService>().GetMembers(memberIds); data.ForEach(item => { item.ShopName = shops.FirstOrDefault(p => p.Id == item.ShopId)?.ShopName ?? string.Empty; item.SuperiorName1 = members.FirstOrDefault(p => p.Id == item.SuperiorId1)?.UserName ?? string.Empty; item.SuperiorName2 = members.FirstOrDefault(p => p.Id == item.SuperiorId2)?.UserName ?? string.Empty; item.SuperiorName3 = members.FirstOrDefault(p => p.Id == item.SuperiorId3)?.UserName ?? string.Empty; }); } else { data.ForEach(item => { item.ShopName = shops.FirstOrDefault(p => p.Id == item.ShopId)?.ShopName ?? string.Empty; }); } } return(data); }
/// <summary> /// 导出分销订单业绩 /// </summary> /// <param name="query"></param> /// <returns></returns> public ActionResult OrdersExportToExcel(BrokerageOrderQuery query) { if (query.SettlementEnd.HasValue) { query.SettlementEnd = query.SettlementEnd.Value.AddDays(1); } var orderResults = DistributionApplication.GetBrokerageOrdersAll(query, true, true); return(ExcelView("OrdersExport", "平台分销订单明细", orderResults)); }
/// <summary> /// 导出分销订单业绩 /// </summary> /// <param name="query"></param> /// <returns></returns> public ActionResult OrdersExportToExcel(BrokerageOrderQuery query) { query.ShopId = CurrentSellerManager.ShopId; if (query.SettlementEnd.HasValue) { query.SettlementEnd = query.SettlementEnd.Value.AddDays(1); } var orderResults = DistributionApplication.GetBrokerageOrdersAll(query); return(ExcelView("OrdersExport", "商家分销订单业绩", orderResults)); }
public ActionResult Orders(BrokerageOrderQuery query) { query.ShopId = CurrentShop.Id; if (query.SettlementEnd.HasValue) { query.SettlementEnd = query.SettlementEnd.Value.AddDays(1); } var data = DistributionApplication.GetBrokerageOrders(query); return(Json(data, true)); }
public ActionResult Orders(BrokerageOrderQuery query) { if (query.SettlementEnd.HasValue) { query.SettlementEnd = query.SettlementEnd.Value.AddDays(1); } var data = DistributionApplication.GetBrokerageOrders(query); foreach (var item in data.Models) { item.Brokerage1 = decimal.Parse(item.Brokerage1.ToString("F2")); item.Brokerage2 = decimal.Parse(item.Brokerage2.ToString("F2")); item.Brokerage3 = decimal.Parse(item.Brokerage3.ToString("F2")); } return(Json(data, true)); }
public static QueryPageModel <BrokerageOrder> GetBrokerageOrders(BrokerageOrderQuery query) { var data = Service.GetBrokerageOrders(query); //填充 门店名 与 会员名 var shops = GetService <IShopService>().GetShops(data.Models.Select(p => p.ShopId)); var memberIds = new List <long>(); memberIds.AddRange(data.Models.Select(p => p.SuperiorId1)); memberIds.AddRange(data.Models.Select(p => p.SuperiorId2)); memberIds.AddRange(data.Models.Select(p => p.SuperiorId3)); var members = GetService <IMemberService>().GetMembers(memberIds); data.Models.ForEach(item => { item.ShopName = shops.FirstOrDefault(p => p.Id == item.ShopId)?.ShopName ?? string.Empty; item.SuperiorName1 = members.FirstOrDefault(p => p.Id == item.SuperiorId1)?.UserName ?? string.Empty; item.SuperiorName2 = members.FirstOrDefault(p => p.Id == item.SuperiorId2)?.UserName ?? string.Empty; item.SuperiorName3 = members.FirstOrDefault(p => p.Id == item.SuperiorId3)?.UserName ?? string.Empty; }); return(data); }