LINQ group by sum

最新推荐文章于 2022-05-20 14:57:53 发布

weixin_30826761

最新推荐文章于 2022-05-20 14:57:53 发布

阅读量90

点赞数

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/lcl_1015/articles/2205768.html

本文介绍了使用Linq进行复杂数据查询的两个例子。首先通过分组并计算特定属性的总和，其次展示了如何联接不同表并筛选有效记录的方法。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

var attributeTotalValues = (from a in objValue
                                        group a by new
                                        {
                                            a.ProductTypeID,
                                            a.AttributeCode
                                        } into b
                                        select new
                                        {
                                            ProductTypeID = b.Key.ProductTypeID,
                                            AttributeCode = b.Key.AttributeCode,
                                            TotalAttributeValue = b.Sum(a => a.AttributeValue.ToDecimal())
                                        });

var objValue = (from a in LinqMetaData.PMExtendAttribute
                            join b in LinqMetaData.PMProjectProductUnit on
                            new { RefRecordID = a.RefRecordID, RefTable = a.RefTable, RecordStatus = a.RecordStatus }
                            equals new { RefRecordID = b.ProjectProductUnitID, RefTable = "PM_ProjectProductUnit", RecordStatus = "Active" }
                            where b.RecordStatus != "Inactive" && b.ProjectID == intProjectID && ids.Contains(b.ProjectProductUnitID)
                            select new
                            {
                                ProductTypeID = b.ProductTypeID,
                                ProjectProductUnitID = b.ProjectProductUnitID,
                                AttributeCode = a.AttributeCode,
                                AttributeValue = a.AttributeValue
                            });

转载于:https://www.cnblogs.com/lcl_1015/articles/2205768.html