Linq 中按照多个值进行分组(GroupBy) 后进行求和

驾驭人生

已于 2024-04-25 11:43:37 修改

阅读量9.2k

点赞数 3

分类专栏： C# 文章标签： linq powerpoint c#

于 2019-08-16 14:56:05 首次发布

本文链接：https://blog.csdn.net/qq165285727/article/details/99678134

版权

C# 专栏收录该内容

58 篇文章 1 订阅

订阅专栏

static void Main(string[] args)
        {
            List<User> products = new List<User>()
           {
                new User(){ Id="1", Name="n1",count1=1},
                new User(){ Id="1", Name="n1",count1=2},
                new User(){ Id="2", Name="n2",count1=3},
                new User(){ Id="2", Name="n2",count1=4},
           };

            var group = products.GroupBy(x => new { x.Id, x.Name })
                .Select(g => new
                {
                    Id = g.Key.Id,
                    Name = g.Key.Name,
                    count1 = g.Sum(t => t.count1)
                }).ToList();
 

            Func<User, dynamic> exp = x => new { x.Id, x.Name };


           var group1 = products.GroupBy(exp)
                     .Select(g => new
                     {
                         Id = g.Key.Id,
                         Name = g.Key.Name,
                         count1 = g.Sum(t => t.count1)
                     }).ToList();

            Func<User, GroupUser> func = x => new GroupUser { Id = x.Id, Name = x.Name };
            var group2 = products.GroupBy(func)
                     .Select(g => new
                     {
                         Id = g.Key.Id,
                         Name = g.Key.Name,
                         count1 = g.Sum(t => t.count1)
                     }).ToList();
 
        }
  
    public class User
    {
        public string Id { get; set; }
        public string Name { get; set; }
        public int count1 { get; set; }

    }

    public class GroupUser
    {
        public string Id { get; set; }
        public string Name { get; set; }
    }

//分组后进行排序返回第一个
List<QualityPerformanceData> maxGroup = qualityPerformanceDataList
                    .DistinctBy(d => new { d.AnalysisItemCode, d.Lower, d.Upper })
                    .OrderBy(x => x.AnalysisItemName)
                    .GroupBy(x => x.AnalysisItemCode)
                    .Select(group => group.OrderByDescending(item => item.Lower).First())
                    .ToList();

输出：

foreach (var item in tt)
{
MessageBox.Show(item.Id + "---" + item.Name + "---" + item.count1);
}