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

绝地灬酷狼 2023-02-21 04:54 43阅读 0赞

**1.首先看一下数据格式**

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mzk3Njg5MA_size_16_color_FFFFFF_t_70]  
**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的好办法，  
可以交流一下。**

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mzk3Njg5MA_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20200628170650265.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mzk3Njg5MA==,size_16,color_FFFFFF,t_70