基于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;//    }//}