分组后如何排序

[chai1338]

DataTable dt_order=BindGrid();
                   var query = from c in dt_order.AsEnumerable()
                               group c by new
                               {
                                   SKU = c.Field<string>("SKU"),
                                   ProductAttributeValueIds = c.Field<string>("ProductAttributeValueIds")
                               } into g
                               select new
                               {
                                   SKU = g.Select(p => p.Field<string>("SKU")).First(),
                                   ProductAttributeValueIds = g.Select(p => p.Field<string>("ProductAttributeValueIds")).First(),
                                   Quantity = g.Sum(p => p.Field<int>("Quantity")),
                                   Total = g.Sum(p => p.Field<int>("Quantity")) * g.Select(p => p.Field<double>("Price")).First(),
                                   Email = string.Join(",", g.Select(p => p.Field<string>("Email"))),
                                   ProductVariantID = g.Select(p => p.Field<int>("ProductVariantID")).First(),
                                   BillingCountryID = string.Join(",", g.Select(p => p.Field<string>("BillingCountryID")))
                               };
我想根据Total  排序 请问怎么加啊？

[bdmh]

后面直接OrderBy

[chai1338]

引用 1 楼 bdmh 的回复:

后面直接OrderBy

}orderby; ？ 都敲不出这个词 没智能提示

[蝶恋花雨]

(from c in dt_order.AsEnumerable() group c by new { SKU = c.Field<string>("SKU"), ProductAttributeValueIds = c.Field<string>("ProductAttributeValueIds") } into g select new { }).OrderByDescending(x=>x.Total);//.OrderBy(x=>x.Total);

[wy_9203]

我怎么记得分组之前要先OrderBy？

[threenewbee]

from c in dt_order.AsEnumerable() group c by new { SKU = c.Field<string>("SKU"), ProductAttributeValueIds = c.Field<string>("ProductAttributeValueIds") } into g orderby g.Sum(p => p.Field<int>("Quantity")) * g.Select(p => p.Field<double>("Price")).First() select new { SKU = g.Select(p => p.Field<string>("SKU")).First(), ProductAttributeValueIds = g.Select(p => p.Field<string>("ProductAttributeValueIds")).First(), Quantity = g.Sum(p => p.Field<int>("Quantity")), Total = g.Sum(p => p.Field<int>("Quantity")) * g.Select(p => p.Field<double>("Price")).First(), Email = string.Join(",", g.Select(p => p.Field<string>("Email"))), ProductVariantID = g.Select(p => p.Field<int>("ProductVariantID")).First(), BillingCountryID = string.Join(",", g.Select(p => p.Field<string>("BillingCountryID"))) }

[蝶恋花雨]

引用 4 楼 wy_9203 的回复:

我怎么记得分组之前要先OrderBy？

在前面和后面都可以。