获取某字段唯一值
在做一般的数据处理时,要想得到某字段唯一值,我们可以利用SQL语言之关键字Distinct方便地获得。但是在用AE作开发时,我们应该怎样去做呢?当然我们可以首先获得某个字段的所有值,然后再去比较、提取、获得唯一值。这样的工作写起来麻烦,效率也非常低。其实AE类库ESRI.ArcGIS.Geodatabase之接口IDataStatistics已为我们提供了这样的方法。
ArcGIS开发帮助文档有很多示例,大都都是用VB或是VBA编写,下面是本人利用C#+AE9.1编写的示例:
1
/// <summary>
2
/// 得到要素类某字段的唯一值
3
/// </summary>
4
/// <param name="pFeatureClass">要素类</param>
5
/// <param name="strFld">指定要得到唯一值的字段</param>
6
/// <returns>唯一值字符数据</returns>
7
public
static
string
[] GetUniqueValue(IFeatureClass pFeatureClass,
string
strFld)
8
{
9
//得到IFeatureCursor游标
10
IFeatureCursor pCursor=pFeatureClass.Search(null,false);
11![](http://writeblog.csdn.net/Images/OutliningIndicators/InBlock.gif)
12
//coClass对象实例生成
13
IDataStatistics pData=new DataStatisticsClass();
14
pData.Field=strFld;
15
pData.Cursor=pCursor as ICursor;
16![](http://writeblog.csdn.net/Images/OutliningIndicators/InBlock.gif)
17
//枚举唯一值
18
IEnumerator pEnumVar=pData.UniqueValues ;
19![](http://writeblog.csdn.net/Images/OutliningIndicators/InBlock.gif)
20
//记录总数
21
int RecordCount=pData.UniqueValueCount;
22![](http://writeblog.csdn.net/Images/OutliningIndicators/InBlock.gif)
23
//字符数组
24
string[] strValue=new string[RecordCount];
25
pEnumVar.Reset();
26
27
int i=0;
28![](http://writeblog.csdn.net/Images/OutliningIndicators/InBlock.gif)
29
while(pEnumVar.MoveNext())
30
{
31
strValue[++i]=pEnumVar.Current.ToString();
32
}
33
34
return strValue;
35
}
![](http://writeblog.csdn.net/Images/OutliningIndicators/ExpandedBlockStart.gif)
2
![](http://writeblog.csdn.net/Images/OutliningIndicators/InBlock.gif)
3
![](http://writeblog.csdn.net/Images/OutliningIndicators/InBlock.gif)
4
![](http://writeblog.csdn.net/Images/OutliningIndicators/InBlock.gif)
5
![](http://writeblog.csdn.net/Images/OutliningIndicators/InBlock.gif)
6
![](http://writeblog.csdn.net/Images/OutliningIndicators/ExpandedBlockEnd.gif)
7
![](http://writeblog.csdn.net/Images/OutliningIndicators/None.gif)
8
![](http://writeblog.csdn.net/Images/OutliningIndicators/ExpandedBlockStart.gif)
9
![](http://writeblog.csdn.net/Images/OutliningIndicators/InBlock.gif)
10
![](http://writeblog.csdn.net/Images/OutliningIndicators/InBlock.gif)
11
![](http://writeblog.csdn.net/Images/OutliningIndicators/InBlock.gif)
12
![](http://writeblog.csdn.net/Images/OutliningIndicators/InBlock.gif)
13
![](http://writeblog.csdn.net/Images/OutliningIndicators/InBlock.gif)
14
![](http://writeblog.csdn.net/Images/OutliningIndicators/InBlock.gif)
15
![](http://writeblog.csdn.net/Images/OutliningIndicators/InBlock.gif)
16
![](http://writeblog.csdn.net/Images/OutliningIndicators/InBlock.gif)
17
![](http://writeblog.csdn.net/Images/OutliningIndicators/InBlock.gif)
18
![](http://writeblog.csdn.net/Images/OutliningIndicators/InBlock.gif)
19
![](http://writeblog.csdn.net/Images/OutliningIndicators/InBlock.gif)
20
![](http://writeblog.csdn.net/Images/OutliningIndicators/InBlock.gif)
21
![](http://writeblog.csdn.net/Images/OutliningIndicators/InBlock.gif)
22
![](http://writeblog.csdn.net/Images/OutliningIndicators/InBlock.gif)
23
![](http://writeblog.csdn.net/Images/OutliningIndicators/InBlock.gif)
24
![](http://writeblog.csdn.net/Images/OutliningIndicators/InBlock.gif)
25
![](http://writeblog.csdn.net/Images/OutliningIndicators/InBlock.gif)
26
![](http://writeblog.csdn.net/Images/OutliningIndicators/InBlock.gif)
27
![](http://writeblog.csdn.net/Images/OutliningIndicators/InBlock.gif)
28
![](http://writeblog.csdn.net/Images/OutliningIndicators/InBlock.gif)
29
![](http://writeblog.csdn.net/Images/OutliningIndicators/InBlock.gif)
30
![](http://writeblog.csdn.net/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
31
![](http://writeblog.csdn.net/Images/OutliningIndicators/InBlock.gif)
32
![](http://writeblog.csdn.net/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
33
![](http://writeblog.csdn.net/Images/OutliningIndicators/InBlock.gif)
34
![](http://writeblog.csdn.net/Images/OutliningIndicators/InBlock.gif)
35
![](http://writeblog.csdn.net/Images/OutliningIndicators/ExpandedBlockEnd.gif)