/// <summary>
/// 获取排行数据（忽略分页）
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public static List <BrokerageRanking> GetRankingsAll(DistributorRankingQuery query)
{
var data = Service.GetRankingsAll(query);
var memberids = data.Select(p => p.MemberId).ToList();
var members = GetService <IMemberService>().GetMembers(memberids);
var distributors = Service.GetDistributors(memberids);
var rankingIndex = (query.PageNo - 1) * query.PageSize;
var rankings = data.Select(item =>
{
var distributor = distributors.FirstOrDefault(p => p.MemberId == item.MemberId);
return(new BrokerageRanking
{
Rank = ++rankingIndex,
Amount = item.Amount,
NoSettlement = item.NoSettlement,
Quantity = item.Quantity,
Settlement = item.Settlement,
Member = members.FirstOrDefault(p => p.Id == item.MemberId),
Distributor = distributor,
Grade = GetDistributorGrade(distributor.GradeId),
});
}).ToList();
return(rankings);
}
public ActionResult Ranking(DistributorRankingQuery query)
{
var data = DistributionApplication.GetRankings(query);
var list = data.Models.Select(item =>
new
{
Ranking = item.Rank,
item.Distributor.MemberId,
DistributorName = item.Member.UserName,
item.Distributor.ShopName,
item.Grade.GradeName,
item.Quantity,
item.Amount,
item.Settlement,
item.NoSettlement
});
return(Json(new { rows = list, total = data.Total }, true));
}
public ActionResult Rankings(DistributorRankingQuery query)
{
if (query.BatchId == 0)//必填参数
{
return(Json(new { rows = new List <object>(), total = 0 }));
}
var data = DistributionApplication.GetRankings(query);
var list = data.Models.Select(item =>
new
{
item.Rank,
DistributorId = item.Distributor.MemberId,
DistributorName = item.Member.UserName,
item.Distributor.ShopName,
item.Grade?.GradeName,
item.Quantity,
item.Amount,
item.Settlement,
item.NoSettlement
});
return(Json(new { rows = list, total = data.Total }, true));
}
/// <summary>
/// 导出分销订单业绩
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public ActionResult RankingsExportToExcel(DistributorRankingQuery query)
{
var orderResults = DistributionApplication.GetRankingsAll(query);
return(ExcelView("RankingsExport", "平台销售员排行", orderResults));
}
