如何在c#中使用LINQ动态分组并计算合计和/最大值数据

using System.Linq;

List<Person> persons = new List<Person>
{
    new Person { Name = "Alice", Age = 25, Salary = 5000 },
    new Person { Name = "Bob", Age = 30, Salary = 6000 },
    new Person { Name = "Charlie", Age = 25, Salary = 5500 },
    new Person { Name = "David", Age = 35, Salary = 7000 },
    new Person { Name = "Eve", Age = 30, Salary = 6500 }
};

var result = persons
    .GroupBy(p => p.Age) // 按照年龄分组
    .Select(g => new
    {
        Age = g.Key,
        TotalSalary = g.Sum(p => p.Salary), // 计算总薪资
        MaxSalary = g.Max(p => p.Salary) // 计算最高薪资
    });

foreach (var group in result)
{
    Console.WriteLine($"Age: {group.Age}, Total Salary: {group.TotalSalary}, Max Salary: {group.MaxSalary}");
}

using System;
using System.Collections.Generic;
using System.Linq;

public class Person
{
    public string Name { get; set; }
    public int Age { get; set; }
    public int Salary { get; set; }
}

public class Program
{
    public static void Main()
    {
        List<Person> persons = new List<Person>
        {
            new Person { Name = "Alice", Age = 25, Salary = 5000 },
            new Person { Name = "Bob", Age = 30, Salary = 6000 },
            new Person { Name = "Charlie", Age = 25, Salary = 5500 },
            new Person { Name = "David", Age = 35, Salary = 7000 },
            new Person { Name = "Eve", Age = 30, Salary = 6500 }
        };

        var result = persons
            .GroupBy(p => p.Age)
            .Select(g => new
            {
                Age = g.Key,
                TotalSalary = g.Sum(p => p.Salary),
                MaxSalary = g.Max(p => p.Salary)
            });

        foreach (var group in result)
        {
            Console.WriteLine($"Age: {group.Age}, Total Salary: {group.TotalSalary}, Max Salary: {group.MaxSalary}");
        }
    }
}