List<model> lstPFSelect = appdal.GetPlatformSelectWhere();
//省份
//1,linq to sql 写法
var listAddress = (from a in lstPFSelect
group a by new { a.Province,a.ProName} into g
//orderby new ComparerItem() { OrderIndex = b.Key., Id = b.Key.Id } descending
select new
{
Province=g.Key.Province,
ProName = g.Key.ProName,
OrderIndex = g.Sum(c => c.ProjectNum)
}).OrderByDescending(t => t.OrderIndex).ThenBy(t => t.Province);
//省份
//1,linq to sql 写法
var listAddress = (from a in lstPFSelect
group a by new { a.Province,a.ProName} into g
//orderby new ComparerItem() { OrderIndex = b.Key., Id = b.Key.Id } descending
select new
{
Province=g.Key.Province,
ProName = g.Key.ProName,
OrderIndex = g.Sum(c => c.ProjectNum)
}).OrderByDescending(t => t.OrderIndex).ThenBy(t => t.Province);
---------------------------------------------------------------------------------------------------------------------
//省份
//2,labmda表达式写法
listAddress.GroupBy(t =>
t.Province)
.Select(g =>
new
{
Province= g.Sum(t => t.Province),
ProName = g.Sum(t => t.ProName),
OrderIndex = g.Sum(t => t.ProjectNum)
});