ArcObject 要素删除

1 四种删除方法

1.1 FeatureClass.Search() 查询游标删除

private void Delete01(IFeatureClass featureclass)
{
    IQueryFilter queryFilter = new QueryFilterClass();
    queryFilter.WhereClause = "objectID <= " + DeleteNum;
    IFeatureCursor featureCursor = featureclass.Search(queryFilter, false);        
    IFeature feature = null ;
    while ((feature = featureCursor.NextFeature())!= null)
    {
        feature.Delete();
    }
    System.Runtime.InteropServices.Marshal.ReleaseComObject(featureCursor);
}

1.2 FeatureClass.Update() 更新游标删除

private void Delete02(IFeatureClass featureclass)
{
    IQueryFilter queryFilter = new QueryFilterClass();
    queryFilter.WhereClause = "objectID <= " + DeleteNum;
    IFeatureCursor featureCursor = featureclass.Update(queryFilter, false);        
    IFeature feature = null ;
    while ((feature = featureCursor.NextFeature())!= null)
    {
        feature.Delete();
    }
    System.Runtime.InteropServices.Marshal.ReleaseComObject(featureCursor);
}

1.3 ITable.DeleteSearchedRows() 删除

private void Delete03(IFeatureClass featureclass)
{
    IQueryFilter queryFilter = new QueryFilterClass();
    queryFilter.WhereClause = "objectID <= " + DeleteNum;
    ITable table = featureclass as ITable;
    table.DeleteSearchedRows(queryFilter);
}

1.4 IWorkspace.ExecuteSQL() 删除

private void Delete04(IFeatureClass featureclass)
{
    IDataset dataset = featureclass as IDataset;
    dataset.Workspace.ExecuteSQL("delete from " + featureclass.AliasName + " where objectid <= " + DeleteNum);
}

2 删除方法效率对比

2.1 测试代码

相同的数据条件，删除2000条记录
代码如下：

IFeatureLayer pFeatureLayer = axMapControl1.Map.get_Layer(0) as IFeatureLayer;
IFeatureClass PFeatureClass = pFeatureLayer.FeatureClass;
System.Diagnostics.Stopwatch MyWatch = new System.Diagnostics.Stopwatch();
MyWatch.Start();
Delete01(PFeatureClass)
//Delete02(PFeatureClass);
//Delete03(PFeatureClass);
//Delete04(PFeatureClass);
MyWatch.Stop();
MessageBox.Show("删除时间:" + MyWatch.ElapsedMilliseconds.ToString() + "毫秒");

2.2 测试结果

---

方法	第一次时间（单位ms）	第二次时间（单位ms）
Delete01	5214ms	5735ms
Delete02	299ms	290Ms
Delete03	59ms	58ms
Delete04	26ms	26ms