ArcEngine创建SDE的workspace，包括FeatureWorkSpace和RasterWorSpaceEx

说明：

 

在这里提醒大家注意，读取处理SDE上的栅格数据的时候一定要注意，其workspace是扩展的工作空间，即：RasterWorSpaceEx。

 

不能使用RasterWorSpace，转换的时候会失败。

 

using System;
using System.Collections.Generic;
using System.Text;
using System.IO;
using ESRI.ArcGIS.Geodatabase;
using ESRI.ArcGIS.DataSourcesGDB;
using ESRI.ArcGIS.esriSystem;

namespace RadioAnalysisGIS.DataToSDE
{
    /// <summary>
    /// 连接类型
    /// </summary>
    public enum ConnectWorkSpaceType
    {
      FeatureClassWorkSpace=0,
      RasterWorkSpace=1
    };

    public abstract class ConnectWorkSpaceDef
    {
        protected ConnectWorkSpaceType CurrentWorkSpaceType = ConnectWorkSpaceType.FeatureClassWorkSpace;
        public ConnectWorkSpaceDef() { }
        public ConnectWorkSpaceType GetWorkSpaceType()
        {
            return CurrentWorkSpaceType;
        }
    }

    public class SDEConnectPara   //SDE的连接参数
    {
        public string Server;
        public string Instance;
        public string User;
        public string Password;
        public string Database;
        public string Version;
        public SDEConnectPara()
        {
            Version = "SDE.DEFAULT";
        }
    }

    #region 定义连接参数
    public class ConnectFeatureWorkSpaceDef : ConnectWorkSpaceDef
    {
        public readonly SDEConnectPara ConnectPara;
        public ConnectFeatureWorkSpaceDef(SDEConnectPara Connparas)
        {
            CurrentWorkSpaceType = ConnectWorkSpaceType.FeatureClassWorkSpace;
            ConnectPara = Connparas;
        }
    }
    public class ConnectRasterWorkSpaceDef : ConnectWorkSpaceDef
    {
        public readonly SDEConnectPara ConnectPara;
        public ConnectRasterWorkSpaceDef(SDEConnectPara Connparas)
        {
            CurrentWorkSpaceType = ConnectWorkSpaceType.RasterWorkSpace;
            ConnectPara = Connparas;
        }
    }
    #endregion

    #region 获取工作空间
    /// <summary>
    /// 连接到SDE feature数据工作空间
    /// </summary>
    public class ConnectFeatureWorkSpaceGet
    {
        private ConnectFeatureWorkSpaceDef pDef;
        public ConnectFeatureWorkSpaceGet(ConnectFeatureWorkSpaceDef ConnDef)
        {
            pDef = ConnDef;
        }
        public IFeatureWorkspace GetSDEWorkspace()
        //依据pDef得到SDE的工作空间
        {
            IWorkspaceFactory pWorkspaceFactory = new SdeWorkspaceFactoryClass();
            IFeatureWorkspace pWorkspace;
            SDEConnectPara para = pDef.ConnectPara;
            IPropertySet pPropSet = new PropertySetClass();
            pPropSet.SetProperty("SERVER", para.Server);
            pPropSet.SetProperty("INSTANCE", para.Instance);
            pPropSet.SetProperty("USER", para.User);
            pPropSet.SetProperty("PASSWORD", para.Password);
            pPropSet.SetProperty("VERSION", para.Version);//可选，缺省为SDE.DEFAULT版本
            pPropSet.SetProperty("Database", para.Database);
            try
            {
                pWorkspace = pWorkspaceFactory.Open(pPropSet, 0) as IFeatureWorkspace;
            }
            catch (Exception ex)
            {
                return null;
            }
            return pWorkspace;
        }
    }
    /// <summary>
    /// 连接到SDE栅格数据工作空间
    /// </summary>
    public class ConnectRasterWorkSpaceGet
    {
        private ConnectRasterWorkSpaceDef pDef;
        public ConnectRasterWorkSpaceGet(ConnectRasterWorkSpaceDef ConnDef)
        {
            pDef = ConnDef;
        }
        public IRasterWorkspaceEx GetSDEWorkspace()
        //依据pDef得到SDE的工作空间
        {
            IWorkspaceFactory pWorkspaceFactory = new SdeWorkspaceFactoryClass();
            IRasterWorkspaceEx pWorkspace;
            SDEConnectPara para = pDef.ConnectPara;
            IPropertySet pPropSet = new PropertySetClass();
            pPropSet.SetProperty("SERVER", para.Server);
            pPropSet.SetProperty("INSTANCE", para.Instance);
            pPropSet.SetProperty("USER", para.User);
            pPropSet.SetProperty("PASSWORD", para.Password);
            pPropSet.SetProperty("VERSION", para.Version);//可选，缺省为SDE.DEFAULT版本
            pPropSet.SetProperty("Database", para.Database);
            try
            {
                pWorkspace = pWorkspaceFactory.Open(pPropSet, 0) as IRasterWorkspaceEx;
            }
            catch (Exception ex)
            {
                return null;
            }
            return pWorkspace;
        }
    }
    #endregion

    #region 连接参数设置
    public class SDEConnectParas
    {
        #region SDE连接参数
        string Server = "gisserver";
        string Instance = "5152/tcp";
        string User = "sde";
        string Pass = "sde";
        string Database = "sde";
        string Version = "SDE.DEFAULT";
        #endregion
        public void GetSDEParameters(out string server, out string instance, out string user, out string password, out string database, out string version)
        {
            server = Server;
            instance = Instance;
            user = User;
            password = Pass;
            database = Database;
            version = Version;
        }//得到SDE连接参数
        public bool ReadFromFile()
        //从连接参数txt文件读取属性库和SDE的连接关键参数，以及站点关键表和关键SDE要素
        {
            string lpszPathName = FilePath.GetApplicationDir();
            lpszPathName = lpszPathName + "//sdeconn.txt";
            StreamReader reader = null;
            try
            {
                reader = new StreamReader(lpszPathName);
                string line = reader.ReadLine();
                line = reader.ReadLine();
                string[] SubStrings = line.Split(':');
                Server = SubStrings[1];
                line = reader.ReadLine();
                SubStrings = line.Split(':');
                Instance = SubStrings[1];
                line = reader.ReadLine();
                SubStrings = line.Split(':');
                User = SubStrings[1];
                line = reader.ReadLine();
                SubStrings = line.Split(':');
                Pass = SubStrings[1];
                line = reader.ReadLine();
                SubStrings = line.Split(':');
                Database = SubStrings[1];
                line = reader.ReadLine();
                SubStrings = line.Split(':');
                Version = SubStrings[1];
            }
            catch (IOException e)
            {
                Console.WriteLine(e.Message);
                return false;
            }
            catch
            {
                return false;
            }
            finally
            {
                if (reader != null) reader.Close();
            }
            return true;
        }
        public void WhiteToLogFile()
        //写入连接参数txt文件-----属性库和SDE的连接关键参数，以及站点关键表和关键SDE要素
        {
            string lpszPathName = FilePath.GetCurrentDir();
            lpszPathName = lpszPathName + "//sdeconn.txt";
            StreamWriter writer = File.CreateText(lpszPathName);
            writer.Write("SDE配置参数");
            writer.Write(writer.NewLine);
            writer.Write("1、服务器:" + Server);
            writer.Write(writer.NewLine);
            writer.Write("2、SDE端口:" + Instance);
            writer.Write(writer.NewLine);
            writer.Write("3、用户:" + User);
            writer.Write(writer.NewLine);
            writer.Write("4、密码:" + Pass);
            writer.Write(writer.NewLine);
            writer.Write("5、数据库:" + Database);
            writer.Write(writer.NewLine);
            writer.Write("6、版本:" + Version);
            writer.Write(writer.NewLine);
            writer.Write(@"///");
            writer.Write(writer.NewLine);
            writer.Close();
        }
    }
        #endregion
}

 

以上代码在SDE for Sql2005上测试通过。AE为9.3。