I have the following Linq query:
List<MonthlySales> monthlySales = (from sale in Sales
group sale by new { sale.DateSold.Month, sale.Product.Shop } into ds
select new MonthlyTitleSales
{
Shop = ds.Select(it => it.Product.Shop).FirstOrDefault(),
Month = ds.Select(it => it.DateSold.Month).FirstOrDefault(),
Year = ds.Select(it => it.DateSold.Year).FirstOrDefault(),
USDNumberItemsSold = ds.Where(it => it.USDCut.HasValue).Where(it => it.USDCut != 0).Count(),
GBPNumberItemsSold = ds.Where(it => it.GBPCut.HasValue).Where(it => it.GBPCut != 0).Count(),
EURNumberItemsSold = ds.Where(it => it.EURCut.HasValue).Where(it => it.EURCut != 0).Count(),
USDRevenueTotal = PerformCurrencyConversion(ds.Sum(it => it.USDCut.HasValue ? it.USDCut.Value : 0), 0M, 0M, Currency, endDate),
GBPRevenueTotal = PerformCurrencyConversion(0M, ds.Sum(it => it.GBPCut.HasValue ? it.GBPCut.Value : 0), 0M, Currency, endDate),
EURRevenueTotal = PerformCurrencyConversion(0M, 0M, ds.Sum(it => it.EURCut.HasValue ? it.EURCut.Value : 0), Currency, endDate),
}).OrderBy(it => it.DateSold.Month).ToList();
这个查询给我一个列表,每个列表项包含以下元素:商店、月份、年份、收入。
我最终需要做的是计算每个月所有商店收入的中位数,因此我需要准备好这些数据以便于这样做。
我认为一种方法可能是按月份将此列表分成小列表,但我对此是否是最有效的解决方案有所疑虑。
有人对此有什么想法吗?
Monthly Sales类供任何需要查看的人使用:
public class MonthlySales
{
public int Month { get; set; }
public int Year { get; set; }
public Shop Shop { get; set; }
public int USDNumberItemsSold { get; set; }
public int GBPNumberItemsSold { get; set; }
public int EURNumberItemsSold { get; set; }
public int TotalNumberItemsSold { get { return USDNumberItemsSold + GBPNumberItemsSold + EURNumberItemsSold; } }
public decimal USDRevenueTotal { get; set; }
public decimal GBPRevenueTotal { get; set; }
public decimal EURRevenueTotal { get; set; }
public decimal OverallEarnings { get { return USDRevenueTotal + GBPRevenueTotal + EURRevenueTotal; } }
}