Linq如何获取分组后的所有数据呢
Linq怎么获取分组后的所有数据呢
------解决思路----------------------
foreach (var item in r)
{
foreach (var item1 in item)
{
}
}
------解决思路----------------------
------解决思路----------------------
List<RawWeeklyAccounts> query = new List<RawWeeklyAccounts>()
{
new RawWeeklyAccounts(31,5,"A"),
new RawWeeklyAccounts(32,6,"B"),
new RawWeeklyAccounts(33,-5,"A"),
new RawWeeklyAccounts(34,1,"B"),
new RawWeeklyAccounts(35,5,"B"),
new RawWeeklyAccounts(37,85,"A")
};
//排序分组
var r = query.Where(condition => condition.TotalAccounts > 0 && condition.weeknumber > 0 && !string.IsNullOrEmpty(condition.MsuName)).
OrderByDescending(order => order.weeknumber).GroupBy(groupName => groupName.MsuName).ToList();
List<RawWeeklyAccounts> str = new List<RawWeeklyAccounts>();
foreach (var item in r)
{
//在这里怎么遍历出每组的元素
}
public class RawWeeklyAccounts
{
public long TotalAccounts { get; set; }
public int weeknumber { get; set; }
public string MsuName { get; set; }
public RawWeeklyAccounts(long TotalAccounts, int weeknumber, string MsuName)
{
this.TotalAccounts = TotalAccounts;
this.weeknumber = weeknumber;
this.MsuName = MsuName;
}
public RawWeeklyAccounts()
{
}
}
------解决思路----------------------
foreach (var item in r)
{
foreach (var item1 in item)
{
}
}
------解决思路----------------------
foreach (IGrouping<string, RawWeeklyAccounts> group in r)
{
}
------解决思路----------------------
List<RawWeeklyAccounts> str = r.SelectMany(x=>x).ToList();