C# GroupBy分组,合并同名项数据

1.首先看一下数据格式

2. 以goodName为判断条件，合并几项数据。

List<ShoopingDetail> shoopingDetailListOne = shoopingDetailList.custmerDetailOrderHdModelList;
                    //合并同goodName列的数字项
                    var query = shoopingDetailListOne.GroupBy(
                        x => new { x.goodName }).Select(
                        x => new
                        {
                            sjgbsl = x.Select(y => y.sjgbsl).Sum(),
                            unitPrice = x.Select(y => y.unitPrice).Sum(),
                            ysje = x.Select(y => y.ysje).Sum(),
                            x.Key.goodName
                        }).ToList();
                    List<ShoopingDetail> salesManSalesStatus = new List<ShoopingDetail>();
                    //遍历，赋值
                    foreach (var ig in query)
                    {
                        ShoopingDetail salesManSaleadd = new ShoopingDetail();
                        salesManSaleadd.goodName = ig.goodName;
                        salesManSaleadd.sjgbsl = ig.sjgbsl;
                        salesManSaleadd.unitPrice = ig.unitPrice;
                        salesManSaleadd.ysje = ig.ysje;
                        salesManSalesStatus.Add(salesManSaleadd);
                    }

3.只有decimal等数字类型才有 .sum()方法。
还有，这里用var类型来接收处理完的数据，
var 转 List的时候，转化不了。
所以这里用foreach赋值，如果有var转 List的好办法，
可以交流一下。