用Linq给DataTable或DataRows 去重

最新推荐文章于 2024-03-05 20:23:03 发布

lee576

最新推荐文章于 2024-03-05 20:23:03 发布

阅读量4.6k

点赞数 2

分类专栏： LINQ

本文链接：https://blog.csdn.net/lee576/article/details/17188809

版权

LINQ 专栏收录该内容

38 篇文章 0 订阅

订阅专栏

            DataRow[] unitRows =
               taskUnitDb.Select("GeoID=" + rootNode.ObjEntity.ObjID + " and NavigateID=" +
                                 rootNode.ObjEntity.NavigateID + " and UnitID=" + unitID +
                                 " and OrganizationID=" + rootNode.ObjEntity.OrgID + " and WorkID =" + AppGlobal.WorkID);

            //去掉重复单元
            var distinctRows = unitRows.AsEnumerable().Cast<DataRow>()
                        .Select(row => new
                        {
                            GeoID = row.Field<int>("GeoID"),
                            NavigateID = row.Field<int>("NavigateID"),
                            UnitID = row.Field<int>("UnitID"),
                            OrganizationID = rootNode.ObjEntity.OrgID,
                            WorkID = AppGlobal.WorkID,
                            UnitName = row.Field<string>("UnitName"),
                            UnitEnumType = row.Field<string>("UnitEnumType")
                        })
                        .Distinct().ToList();

            foreach (var dr in distinctRows)
            {
                string id = dr.UnitID + "";
                string name = dr.UnitName;
                OfEntityObjectType objType =
                    (OfEntityObjectType)Enum.Parse(typeof(OfEntityObjectType), dr.UnitEnumType);
                // 绑定单元(计算单元、开发单元、评估单元)
                childNode = CreateAbstractNode(rootNode.ObjEntity.ObjID, name, objType, rootNode);

                childNode.ObjEntity.UnitID = id;
                childNode.ObjEntity.UnitName = name;
                childNode.ObjEntity.NodeEnumType = NodeEnumType.Unit;
                childNode.ObjEntity.Wells = Well.GetWellsInUnit(int.Parse(id));

                if (childNode != null)
                    rootNode.Nodes.Add(childNode);
            }

注意项目需要添加System.Data.DataSetExtensions引用