List<Appoint_form> list = new List<Appoint_form>();
list.Add(new Appoint_form() { Order_month = "2020-09", Reward_money = 2000 });
list.Add(new Appoint_form() { Order_month = "2020-09", Reward_money = 800 });
list.Add(new Appoint_form() { Order_month = "2020-10", Reward_money = 500 });
list.Add(new Appoint_form() { Order_month = "2020-10", Reward_money = 1000 });
list.Add(new Appoint_form() { Order_month = "2020-11", Reward_money = 200 });
list.Add(new Appoint_form() { Order_month = "2020-11", Reward_money = 300 });
//分组统计每个月一共多少钱
List<MonthMoneyView> outList = list
.GroupBy(x => x.Order_month)
.Select(x => new MonthMoneyView()
{
Money = x.Sum(g => g.Reward_money),
Month = x.Key
//Month = x.First().Order_month
})
.OrderBy(x => x.Month)
.ToList();
结果:
2020-09消费2800
2020-10消费1500
2020-11消费500