linq中的数据透视表
|
我有一个数据集，可以将以下结果返回给我：
Date |Location |Amount
11.03.2011|Location1| 1000
11.03.2011|Location2| 1000
11.03.2011|Location3| 1000
12.03.2011|Location1| 1000
12.03.2011|Location2| 1000
12.03.2011|Location3| 1000
13.03.2011|Location4| 1000
Location | 11.03.2011|12.03.2011|13.03.2011|
Location1| 1000| 1000| 0|
Location2| 1000| 1000| 0|
Location3| 1000| 1000| 0|
Location4| 0| 0| 1000|
没有找到相关结果
已邀请:
1 个回复
乐遣杀屎
var Locations = Data.GroupBy(l => l.Location); .SelectMany( g => new { LocationName = g.Key, Amounts = g }); Func<Location, bool> matchMonth11 = l => l.Date == \"11.03.2011\"; Func<Location, bool> matchMonth12 = l => l.Date == \"12.03.2011\"; Func<Location, bool> matchMonth13 = l => l.Date == \"13.03.2011\"; var PivotedLocations = new List<PivotedLocation>(); foreach(var item in Locations ) { PivotedLocations.Add( new PivotedLocation { LocationName = item.LocationName, month11Amount = item.Amounts.Where(matchMonth11) .FirstOrDefault().Amount, month12Amount = item.Amounts.Where(matchMonth12) .FirstOrDefault().Amount, month13Amount = item.Amounts.Where(matchMonth13) .FirstOrDefault().Amount }); }public class PivotedLocation { public string LocationName { get; set; } public int month11Amount { get; set; } public int month12Amount { get; set; } public int month13Amount { get; set; } }