基于ArcGIS10.0和Oracle10g的空间数据管理平台（C#开发）-AE常用操作代码

本来打算睡觉了，但是突然看到自己保留的一个单独的C#文件，原来是AE常用操作的代码，这也是自己在做ArcGIS空间数据管理平台的项目时积累下来的，这里贴出来供需要使用的人。

/********************************************************
 * 
 * 本类部分功能接口依附于_workSpaceInstance
 * 必须首先使用CreateWorkspace或者OpenWorkspaceFromFile
 * 实例化_workSpaceInstance，才能使用
 *
********************************************************/
using System;
using System.Windows.Forms;
using System.IO;
using System.Data;
using ESRI.ArcGIS.esriSystem;
using ESRI.ArcGIS.Geodatabase;
using ESRI.ArcGIS.Geometry;
using ESRI.ArcGIS.CatalogUI;

namespace ControlLibrary
{
    class RuleDBCreater
    {
        private static IWorkspace _workSpaceInstance;
        public RuleDBCreater()
        {
            //
            // TODO: 在此处添加构造函数逻辑
            //
        }

        public static void setWorkSpaceInstance(IWorkspace ws)
        {
            _workSpaceInstance = ws;
        }

        public static IWorkspace getWorkSpaceInstance()
        {
            return _workSpaceInstance;
        }
        /// <summary>
        /// 创建规则数据库workspace
        /// </summary>
        /// <param name="workspaceType"></param>
        /// <param name="WorkspaceDirectory"></param>
        /// <returns>返回workspace实例</returns>
        public static IWorkspace CreateWorkspace(string pName, string pPath)
        {
            IWorkspaceFactory workspaceFactory = null;
            Type factoryType = Type.GetTypeFromProgID("esriDataSourcesGDB.AccessWorkspaceFactory");
            workspaceFactory = (IWorkspaceFactory)Activator.CreateInstance(factoryType);
            Directory.CreateDirectory(pPath);
            IWorkspaceName workspaceName = workspaceFactory.Create(pPath, pName,null, 0);
            IName Name = (IName)workspaceName;
            _workSpaceInstance = (IWorkspace)(Name.Open());
            return _workSpaceInstance;
        }
        /// <summary>
        /// 从文件创建规则数据库workspace
        /// </summary>
        /// <param name="WorkspaceDirectory"></param>
        /// <returns>返回workspace实例</returns>
        public static IWorkspace OpenWorkspaceFromFile(string WorkspaceDirectory)
        {
            IWorkspaceFactory workspaceFactory = null;
            Type factoryType = Type.GetTypeFromProgID("esriDataSourcesGDB.AccessWorkspaceFactory");
            workspaceFactory = (IWorkspaceFactory)Activator.CreateInstance(factoryType);
            _workSpaceInstance = workspaceFactory.OpenFromFile(WorkspaceDirectory, 0);
            return _workSpaceInstance;
        }
        /// <summary>
        /// 创建要素数据集
        /// </summary>
        /// <param name="name"></param>
        /// <returns>IFeatureDataset</returns>
        public static IFeatureDataset CreateFeatureDataSet(/*string name,ISpatialReference srf*/)
        {
            IFeatureDatasetDialog fdlg = new FeatureDatasetDefDialog();
            IFeatureWorkspace featureWorkspace = (IFeatureWorkspace)_workSpaceInstance;
            return fdlg.DoModalCreate(featureWorkspace, 0);
            //if (_workSpaceInstance == null) return null;
            //IFeatureWorkspace featureWorkspace = (IFeatureWorkspace)_workSpaceInstance;
            //IFeatureDataset tmp = featureWorkspace.CreateFeatureDataset(name, srf);
            //return tmp;
        }
        /// <summary>
        /// 删除要素数据集
        /// </summary>
        /// <param name="name"></param>
        /// <param name="srf"></param>
        /// <returns></returns>
        public static void DeleteFeatureDataSet(string name)
        {
            IFeatureDataset fds = GetFeatureDataSet(name);
            if (fds != null)
                fds.Delete();
        }
        /// <summary>
        /// 获取数据库中IFeatureDataset
        /// </summary>
        /// <param name="name"></param>
        /// <returns></returns>
        public static IFeatureDataset GetFeatureDataSet(string name)
        {
            if (_workSpaceInstance == null) return null;
            IFeatureWorkspace featureWorkspace = (IFeatureWorkspace)_workSpaceInstance;
            IFeatureDataset tmp = featureWorkspace.OpenFeatureDataset(name);
            return tmp;
        }
        /// <summary>
        /// 重命名DataSet
        /// </summary>
        /// <param name="fds"></param>
        /// <param name="newname"></param>
        public static void RenameFeatureDataSet(IFeatureDataset fds,string newname)
        {
            if (fds.CanRename())
            {
                fds.Rename(newname);
            }
        }
        /// <summary>
        /// 获取IFeatureDataset空间参照
        /// </summary>
        /// <param name="ds"></param>
        /// <returns></returns>
        public static ISpatialReference GetFdsSpatialReference(IFeatureDataset ds)
        {
            IGeoDataset gds = ds as IGeoDataset;
            return gds.SpatialReference;
        }
        /// <summary>
        /// 设置IFeatureDataset空间参照
        /// </summary>
        /// <param name="ds"></param>
        /// <returns></returns>
        public static void SetFdsSpatialReference(IFeatureDataset ds)
        {
            IGeoDataset gds = ds as IGeoDataset;
            // Cast the geodataset to the IGeoDatasetSchemaEdit interface and set the Spatial Reference.    
            IGeoDatasetSchemaEdit geoDatasetSchemaEdit = (IGeoDatasetSchemaEdit)gds;
            if (geoDatasetSchemaEdit.CanAlterSpatialReference)
            {
                geoDatasetSchemaEdit.AlterSpatialReference(EditSpatialReferenceDlg(gds.SpatialReference));
            }
        }
        /// <summary>
        /// 创建属性字段
        /// </summary>
        /// <param name="shapeType"></param>
        /// <param name="dgrc"></param>
        /// <param name="spr"></param>
        /// <returns></returns>
        public static IFields CreateFields(string shapeType, DataTable dt, ISpatialReference spr,bool hasM,bool hasZ)
        {
            IField oField = new FieldClass();
            IFieldEdit oFieldEdit = oField as IFieldEdit;
            IFields oFields = new FieldsClass();
            IFieldsEdit oFieldsEdit = oFields as IFieldsEdit;

            IGeometryDef geometryDef = new GeometryDefClass();
            IGeometryDefEdit geometryDefEdit = geometryDef as IGeometryDefEdit;

            foreach(DataRow dr in dt.Rows)
            {
                switch (dr[1].ToString())
                {
                    case "Object ID":
                        oFieldEdit.Name_2 = "ObjectID";
                        oFieldEdit.AliasName_2 = "FID";
                        oFieldEdit.Type_2 = esriFieldType.esriFieldTypeOID;
                        oFieldsEdit.AddField(oField);
                        break;
                    case "Multipoint Features":
                        oField = new FieldClass();
                        oFieldEdit = oField as IFieldEdit;
                        oFieldEdit.Name_2 = "SHAPE";
                        oFieldEdit.IsNullable_2 = true;
                        oFieldEdit.Required_2 = true;

                        geometryDefEdit.AvgNumPoints_2 = 1;
                        geometryDefEdit.GridCount_2 = 0;
                        geometryDefEdit.HasM_2 = hasM;
                        geometryDefEdit.HasZ_2 = hasZ;
                        geometryDefEdit.GeometryType_2 = esriGeometryType.esriGeometryMultipoint;
                        geometryDefEdit.SpatialReference_2 = spr;

                        oFieldEdit.Type_2 = esriFieldType.esriFieldTypeGeometry;
                        oFieldEdit.GeometryDef_2 = (GeometryDef)geometryDefEdit;
                        oFieldsEdit.AddField(oField);
                        break;
                    case "MultiPatch Features":
                        oField = new FieldClass();
                        oFieldEdit = oField as IFieldEdit;
                        oFieldEdit.Name_2 = "SHAPE";
                        oFieldEdit.IsNullable_2 = true;
                        oFieldEdit.Required_2 = true;
                       
                        geometryDef = new GeometryDefClass();
                        geometryDefEdit = geometryDef as IGeometryDefEdit;
                        geometryDefEdit.AvgNumPoints_2 = 1;
                        geometryDefEdit.GridCount_2 = 0;
                        geometryDefEdit.HasM_2 = hasM;
                        geometryDefEdit.HasZ_2 = hasZ;
                        geometryDefEdit.GeometryType_2 = esriGeometryType.esriGeometryMultiPatch;
                        geometryDefEdit.SpatialReference_2 = spr;

                        oFieldEdit.Type_2 = esriFieldType.esriFieldTypeGeometry;
                        oFieldEdit.GeometryDef_2 = (GeometryDef)geometryDefEdit;
                        oFieldsEdit.AddField(oField);
                        break;
                    case "Point Features":
                        oField = new FieldClass();
                        oFieldEdit = oField as IFieldEdit;
                        oFieldEdit.Name_2 = "SHAPE";
                        oFieldEdit.IsNullable_2 = true;
                        oFieldEdit.Required_2 = true;

                        geometryDef = new GeometryDefClass();
                        geometryDefEdit = geometryDef as IGeometryDefEdit;
                        geometryDefEdit.AvgNumPoints_2 = 1;
                        geometryDefEdit.GridCount_2 = 0;
                        geometryDefEdit.HasM_2 = hasM;
                        geometryDefEdit.HasZ_2 = hasZ;
                        geometryDefEdit.GeometryType_2 = esriGeometryType.esriGeometryPoint;
                        geometryDefEdit.SpatialReference_2 = spr;

                        oFieldEdit.Type_2 = esriFieldType.esriFieldTypeGeometry;
                        oFieldEdit.GeometryDef_2 = (GeometryDef)geometryDefEdit;
                        oFieldsEdit.AddField(oField);
                        break;
                    case "Line Features":
                        oField = new FieldClass();
                        oFieldEdit = oField as IFieldEdit;
                        oFieldEdit.Name_2 = "SHAPE";
                        oFieldEdit.IsNullable_2 = true;
                        oFieldEdit.Required_2 = true;
            
                        geometryDef = new GeometryDefClass();
                        geometryDefEdit = geometryDef as IGeometryDefEdit;
                        geometryDefEdit.AvgNumPoints_2 = 1;
                        geometryDefEdit.GridCount_2 = 0;
                        geometryDefEdit.HasM_2 = hasM;
                        geometryDefEdit.HasZ_2 = hasZ;
                        geometryDefEdit.GeometryType_2 = esriGeometryType.esriGeometryLine;
                        geometryDefEdit.SpatialReference_2 = spr;

                        oFieldEdit.Type_2 = esriFieldType.esriFieldTypeGeometry;
                        oFieldEdit.GeometryDef_2 = (GeometryDef)geometryDefEdit;
                        oFieldsEdit.AddField(oField);
                        break;
                    case "Polygon Features":
                        oField = new FieldClass();
                        oFieldEdit = oField as IFieldEdit;
                        oFieldEdit.Name_2 = "SHAPE";
                        oFieldEdit.IsNullable_2 = true;
                        oFieldEdit.Required_2 = true;

                        geometryDef = new GeometryDefClass();
                        geometryDefEdit = geometryDef as IGeometryDefEdit;
                        geometryDefEdit.AvgNumPoints_2 = 1;
                        geometryDefEdit.GridCount_2 = 0;
                        geometryDefEdit.HasM_2 = hasM;
                        geometryDefEdit.HasZ_2 = hasZ;
                        geometryDefEdit.GeometryType_2 = esriGeometryType.esriGeometryPolygon;
                        geometryDefEdit.SpatialReference_2 = spr;

                        oFieldEdit.Type_2 = esriFieldType.esriFieldTypeGeometry;
                        oFieldEdit.GeometryDef_2 = (GeometryDef)geometryDefEdit;
                        oFieldsEdit.AddField(oField);
                        break;
                    case "Short Int":
                        oField = new FieldClass();
                        oFieldEdit = oField as IFieldEdit;
                        oFieldEdit.Name_2 = dr[0].ToString();
                        oFieldEdit.Type_2 = esriFieldType.esriFieldTypeSmallInteger;
                        oFieldEdit.IsNullable_2 = true;
                        oFieldsEdit.AddField(oField);
                        break;
                    case "Long Int":
                        oField = new FieldClass();
                        oFieldEdit = oField as IFieldEdit;
                        oFieldEdit.Name_2 = dr[0].ToString();
                        oFieldEdit.Type_2 = esriFieldType.esriFieldTypeInteger;
                        oFieldsEdit.AddField(oField);
                        break;
                    case "Float":
                        oField = new FieldClass();
                        oFieldEdit = oField as IFieldEdit;
                        oFieldEdit.Name_2 = dr[0].ToString();
                        oFieldEdit.Type_2 = esriFieldType.esriFieldTypeSingle;
                        oFieldsEdit.AddField(oField);
                        break;
                    case "Double":
                        oField = new FieldClass();
                        oFieldEdit = oField as IFieldEdit;
                        oFieldEdit.Name_2 = dr[0].ToString();
                        oFieldEdit.Type_2 = esriFieldType.esriFieldTypeDouble;
                        oFieldsEdit.AddField(oField);
                        break;
                    case "Text":
                        oField = new FieldClass();
                        oFieldEdit = oField as IFieldEdit;
                        oFieldEdit.Name_2 = dr[0].ToString();
                        oFieldEdit.Length_2 = 30; // Only string fields require that you set the length.
                        oFieldEdit.Type_2 = esriFieldType.esriFieldTypeString;
                        oFieldsEdit.AddField(oField);
                        break;
                    case "Date":
                        oField = new FieldClass();
                        oFieldEdit = oField as IFieldEdit;
                        oFieldEdit.Name_2 = dr[0].ToString();
                        oFieldEdit.Type_2 = esriFieldType.esriFieldTypeDate;
                        oFieldsEdit.AddField(oField);
                        break;
                    //case "Guid":
                    //    IField fld12 = new FieldClass();
                    //    IFieldEdit fldedt12 = (IFieldEdit)fld12;
                    //    fldedt12.Name_2 = dr[0].ToString();
                    //    fldedt12.Type_2 = esriFieldType.esriFieldTypeGUID;
                    //    fieldsEdit.set_Field(i, fld12);
                    //    break;
                    //case "Geomery":
                    //    IField fld13 = new FieldClass();
                    //    IFieldEdit fldedt13 = (IFieldEdit)fld13;
                    //    fldedt13.Name_2 = dr[0].ToString();
                    //    fldedt13.IsNullable_2 = true;
                    //    fldedt13.Required_2 = true;
                    //    IGeometryDef geometryDef13 = new GeometryDefClass();
                    //    IGeometryDefEdit geometryDefEdit13 = (IGeometryDefEdit)geometryDef13;
                    //    geometryDef13 = new GeometryDefClass();
                    //    geometryDefEdit13 = (IGeometryDefEdit)geometryDef13;
                    //    geometryDefEdit13.AvgNumPoints_2 = 1;
                    //    geometryDefEdit13.GridCount_2 = 0;
                    //    geometryDefEdit13.HasM_2 = hasM;
                    //    geometryDefEdit13.HasZ_2 = hasZ;
                    //    fldedt13.Type_2 = esriFieldType.esriFieldTypeGeometry;
                    //    geometryDefEdit13.GeometryType_2 = esriGeometryType.esriGeometryAny;
                    //    //Generate a default Spatial Reference
                    //    geometryDefEdit13.SpatialReference_2 = spr;
                    //    fldedt13.GeometryDef_2 = (GeometryDef)geometryDefEdit13;
                    //    fldedt13.Type_2 = esriFieldType.esriFieldTypeGeometry;
                    //    fieldsEdit.set_Field(i, fld13);
                    //    break;
                    //case "Raster":
                    //    IField fld14 = new FieldClass();
                    //    IFieldEdit fldedt14 = (IFieldEdit)fld14;
                    //    fldedt14.Name_2 = dr[0].ToString();
                    //    fldedt14.Type_2 = esriFieldType.esriFieldTypeRaster;
                    //    fieldsEdit.set_Field(i, fld14);
                    //    break;
                }
            }
            return oFields;
        }     
        /// <summary>
        /// 创建要素类
        /// </summary>
        /// <param name="workspace"></param>
        /// <param name="featureDataset"></param>
        /// <param name="featureClassName"></param>
        /// <param name="fields"></param>
        /// <param name="CLSID"></param>
        /// <param name="CLSEXT"></param>
        /// <param name="strConfigKeyword"></param>
        /// <returns></returns>
        public static IFeatureClass CreateFeatureClass(IFeatureDataset featureDataset, String featureClassName, IFields fields)
        {
            if (_workSpaceInstance == null) return null;
            IFeatureClass featureClass = null;
            IFeatureWorkspace featureWorkspace = (IFeatureWorkspace)_workSpaceInstance; 

            // assign the class id value if not assigned
            ESRI.ArcGIS.esriSystem.UID CLSID = null;
            ESRI.ArcGIS.esriSystem.UID CLSEXT = null;
            string strConfigKeyword = "";
            if (CLSID == null)
            {
                CLSID = new ESRI.ArcGIS.esriSystem.UIDClass();
                CLSID.Value = "esriGeoDatabase.Feature";
            }

            System.String strShapeField = "";

            // locate the shape field
            for (Int32 j = 0; j < fields.FieldCount; j++)
            {
                esriFieldType dd = fields.get_Field(j).Type;
                if (dd == esriFieldType.esriFieldTypeGeometry)
                {
                    strShapeField = fields.get_Field(j).Name;
                }
            }

            // finally create and return the feature class
            if (featureDataset != null)
            {
                featureClass = featureDataset.CreateFeatureClass(featureClassName, fields, CLSID, CLSEXT, esriFeatureType.esriFTSimple, strShapeField, strConfigKeyword);
            }
            
            return featureClass;
        }
        /// <summary>
        /// 获取FeatureClass从IFeatureDataset
        /// </summary>
        /// <param name="featDs"></param>
        /// <param name="className"></param>
        /// <returns></returns>
        public static IFeatureClass GetFeatureClassFromFeatureDataset(IFeatureDataset featDs, string className)
        {
            IFeatureClass featClass;
            IFeatureClassContainer fcContainer = featDs as IFeatureClassContainer;
            for (int i = 0; i < fcContainer.ClassCount; i++)
            {
                featClass = fcContainer.get_Class(i);
                if (RuleDBCreater.GetFeatureClassName(featClass) == className)
                {
                    return featClass;
                }
            }
            return null;
        }
        /// <summary>
        /// 重命名FeatureClass
        /// </summary>
        /// <param name="fds"></param>
        /// <param name="newname"></param>
        public static void RenameFeatureClass(IFeatureClass fc,string newname)
        {
            IDataset ds = fc as IDataset;
            if (ds.CanRename())
            {
                ds.Rename(newname);
            }
        }
        /// <summary>
        /// 从数据集删除要素类
        /// </summary>
        /// <param name="featureDataset"></param>
        /// <param name="featureClassName"></param>
        /// <param name="fields"></param>
        /// <returns></returns>
        public static void DeleteFeatureClass(IFeatureDataset featureDataset, String featureClassName)
        {
            IFeatureClass fc = GetFeatureClassFromFeatureDataset(featureDataset, featureClassName);
            if (fc != null)
            {
                IDataset ds = fc as IDataset;
                if (ds.CanDelete())
                {
                    ds.Delete();
                }
            }
        }
        /// <summary>
        /// 编辑空间参照
        /// </summary>
        /// <param name="inputSpr"></param>
        /// <returns></returns>
        public static ISpatialReference EditSpatialReferenceDlg(ISpatialReference inputSpr)
        {
            ESRI.ArcGIS.CatalogUI.ISpatialReferenceDialog2 spatialReferenceDialog2 = new ESRI.ArcGIS.CatalogUI.SpatialReferenceDialogClass();
            ISpatialReference spf = spatialReferenceDialog2.DoModalEdit(inputSpr, false, false, false, false, false, false, false, 0);
            return spf;
        }
        /// <summary>
        /// 创建空间参照
        /// </summary>
        /// <param name="coordinateSystem"></param>
        /// <returns></returns>
        public static ISpatialReference CreateSpatialReferenceDlg()//
        {
            ESRI.ArcGIS.CatalogUI.ISpatialReferenceDialog2 spatialReferenceDialog2 = new ESRI.ArcGIS.CatalogUI.SpatialReferenceDialogClass();
            ISpatialReference spatialReference = spatialReferenceDialog2.DoModalCreate(true, false, false, 0);
            //ISpatialReferenceTolerance spatialReferenceTolerance = spatialReference as ISpatialReferenceTolerance;
            return spatialReference;
        }

        public static ISpatialReference SetXYZMTolerance(ISpatialReference srf,double xytolerance,double ztolerance,double mtolerance)
        {
            ISpatialReferenceTolerance spatialReferenceTolerance = srf as ISpatialReferenceTolerance;
            //spatialReferenceTolerance.XYTolerance = xytolerance;
            //spatialReferenceTolerance.ZTolerance = ztolerance;
            //spatialReferenceTolerance.MTolerance = mtolerance;
            return srf;
        }

        public static void GetXYZMTolerance(ISpatialReference srf,out double xytolerance,out double ztolerance,out double mtolerance)
        {
            ISpatialReferenceTolerance spatialReferenceTolerance = srf as ISpatialReferenceTolerance;
            xytolerance = spatialReferenceTolerance.XYTolerance;
            ztolerance = spatialReferenceTolerance.ZTolerance;
            mtolerance = spatialReferenceTolerance.MTolerance;
        }
        /// <summary>
        /// 获取工作区内所有数据集名称
        /// </summary>
        /// <param name="ws"></param>
        /// <returns></returns>
        public static IEnumDatasetName GetFeatureDataSetNames(IWorkspace ws)
        {
            return ws.get_DatasetNames(esriDatasetType.esriDTFeatureDataset);
        }

        public static bool IsArcDbFile(string path)
        {
            IWorkspaceFactory workspaceFactory = null;
            Type factoryType = Type.GetTypeFromProgID("esriDataSourcesGDB.AccessWorkspaceFactory");
            workspaceFactory = (IWorkspaceFactory)Activator.CreateInstance(factoryType);
            return workspaceFactory.IsWorkspace(path);
        }

        public static string GetFeatureClassName(IFeatureClass fc)
        {
            IDataset ds = fc as IDataset;
            return ds.Name;
        }

        public static IEnumFeatureClass GetFeatureClasses(IFeatureDataset fds)
        {
            IFeatureClassContainer pFeatureclassContainer = (IFeatureClassContainer)fds;
            return (IEnumFeatureClass)pFeatureclassContainer.Classes;
        }

        public static bool IsFeatureDataSetExist(string name)
        {
            //if (_workSpaceInstance == null) return true;
            IEnumDatasetName iEdn = GetFeatureDataSetNames(_workSpaceInstance);
            iEdn.Reset();
            IDatasetName iDsn = iEdn.Next();
            while (iDsn is IFeatureDatasetName)
            {
                if (iDsn.Name == name)   
                    return true;
                iDsn = iEdn.Next();
            }
            return false;
        }

        public static bool IsFeatureClassExist(string dsname, string fcname)
        {
            IEnumFeatureClass iEfc = GetFeatureClasses(GetFeatureDataSet(dsname));
            iEfc.Reset();
            IFeatureClass fcn = iEfc.Next();
            while (fcn is IFeatureClass)
            {
                if (fcname == fcn.AliasName)
                    return true;
                fcn = iEfc.Next();
            }
            return false;
        }
        /// <summary>
        /// 设置VerticalCoordinateSystem
        /// </summary>
        public static ISpatialReference3 SetVerticalCoordinateSystem(ISpatialReference3 spatialReference3)
        {
            ISpatialReferenceFactory3 spatialReferenceFactory3 = new SpatialReferenceEnvironmentClass();
            IVerticalCoordinateSystem verticalCoordinateSystem = spatialReferenceFactory3.CreateVerticalCoordinateSystem((int)esriSRVerticalCSType.esriSRVertCS_NAVD1988);
            spatialReference3.VerticalCoordinateSystem = verticalCoordinateSystem;
            return spatialReference3;
        }
    }
}
//public static bool IsNameValid(string str)
//{
//    System.Text.RegularExpressions.Regex reg = new System.Text.RegularExpressions.Regex(@"^[a-zA-Z]\w{0,17}{1}quot;);
//    if (reg.IsMatch(s))
//    {
//        return true;
//    }
//    else
//    {
//        return false;
//    }
//}