视图中的LINQ查询按升序或降序排序的类别的总金额

// 假设视图中的数据源为List<Category> categories

// 按升序排序类别的总金额
var sortedCategoriesAsc = categories
    .OrderBy(category => category.Amount)
    .GroupBy(category => category.Name)
    .Select(group => new
    {
        Category = group.Key,
        TotalAmount = group.Sum(category => category.Amount)
    });

// 按降序排序类别的总金额
var sortedCategoriesDesc = categories
    .OrderByDescending(category => category.Amount)
    .GroupBy(category => category.Name)
    .Select(group => new
    {
        Category = group.Key,
        TotalAmount = group.Sum(category => category.Amount)
    });

// 输出结果
foreach (var category in sortedCategoriesAsc)
{
    Console.WriteLine($"类别：{category.Category}，总金额：{category.TotalAmount}");
}

foreach (var category in sortedCategoriesDesc)
{
    Console.WriteLine($"类别：{category.Category}，总金额：{category.TotalAmount}");
}