【转载】ArcEngine ITable 与System.DataTable相互转换

 /// <summary>
        /// 打开dbf表
        /// </summary>
        /// <param name=”pathName”></param>
        /// <param name=”tableName”></param>
        /// <returns></returns>
        public static ITable OpenTable(string pathName, string tableName)
        {
            // Create the workspace name object.
            IWorkspaceName workspaceName = new WorkspaceNameClass();
            workspaceName.PathName = pathName;
            workspaceName.WorkspaceFactoryProgID = “esriDataSourcesFile.shapefileworkspacefactory”;
            // Create the table name object.
            IDatasetName dataSetName = new TableNameClass();
            dataSetName.Name = tableName;
            dataSetName.WorkspaceName = workspaceName;
            // Open the table.
            IName name = (IName)dataSetName;
            ITable table = (ITable)name.Open();
            return table;
        }

        /// <summary>
        /// 将ITable转换为DataTable
        /// </summary>
        /// <param name=”mTable”></param>
        /// <returns></returns>
        public static DataTable ToDataTable(ITable mTable)
        {
            try
            {
                DataTable pTable = new DataTable();
                for (int i = 0; i < mTable.Fields.FieldCount; i++)
                {
                    pTable.Columns.Add(mTable.Fields.get_Field(i).Name);
                }

                ICursor pCursor = mTable.Search(null, false);
                IRow pRrow = pCursor.NextRow();
                while (pRrow != null)
                {
                    DataRow pRow = pTable.NewRow();
                    string[] StrRow = new string[pRrow.Fields.FieldCount];
                    for (int i = 0; i < pRrow.Fields.FieldCount; i++)
                    {
                        StrRow[i] = pRrow.get_Value(i).ToString();
                    }
                    pRow.ItemArray = StrRow;
                    pTable.Rows.Add(pRow);
                    pRrow = pCursor.NextRow();
                }

                return pTable;
            }
            catch (Exception ex)
            {
                return null;
            }
        }

        /// <summary>
        /// 把DataTable转为ITable ,tempPath 不含文件名的问价夹路径
        /// </summary>
        /// <param name=”mTable”></param>
        /// <returns></returns>
        public static  ITable  ToITable(DataTable  mTable,string tempPath)
        {
            try
            {
                #region 新建表字段

                IField pField = null;

                IFields fields = new FieldsClass();
                IFieldsEdit fieldsEdit = (IFieldsEdit)fields;
                fieldsEdit.FieldCount_2 = 3;

                pField = new FieldClass();
                IFieldEdit fieldEdit = (IFieldEdit)pField;
                fieldEdit.Name_2 = “FromField”;
                fieldEdit.AliasName_2 = “开始字段值”;
                fieldEdit.Type_2 = esriFieldType.esriFieldTypeDouble;
                fieldEdit.Editable_2 = true;

                //添加开始字段
                fieldsEdit.set_Field(0, pField);

                IField pField1 = new FieldClass();
                IFieldEdit fieldEdit1 = (IFieldEdit)pField1;
                fieldEdit1.Name_2 = “ToField”;
                fieldEdit1.AliasName_2 = “结束字段值”;
                fieldEdit1.Type_2 = esriFieldType.esriFieldTypeDouble;
                fieldEdit1.Editable_2 = true;

                //添加结束字段
                fieldsEdit.set_Field(1, pField1);

                IField pField2 = new FieldClass();
                IFieldEdit fieldEdit2 = (IFieldEdit)pField2;
                fieldEdit2.Name_2 = “outField”;
                fieldEdit2.AliasName_2 = “分类字段值”;
                fieldEdit2.Type_2 = esriFieldType.esriFieldTypeDouble;
                fieldEdit2.Editable_2 = true;
                //添加重分类字段
                fieldsEdit.set_Field(2, pField2);

                #endregion

                ShapefileWorkspaceFactoryClass class2 = new ShapefileWorkspaceFactoryClass();
                ESRI.ArcGIS.Geodatabase.IWorkspace pWorkspace = class2.OpenFromFile(tempPath, 0);
                IFeatureWorkspace pFWS = pWorkspace as IFeatureWorkspace;

                //删除已有的
                if (System.IO.File.Exists(tempPath + “重分类.dbf”))
                {
                    System.IO.File.Delete(tempPath + “重分类.dbf”);
                }

                //创建空表
                ESRI.ArcGIS.Geodatabase.ITable pTable;
                pTable = pFWS.CreateTable(“重分类”, fieldsEdit, null, null, “”);
               
                //获取表中记录数
                int count=mTable .Rows .Count ;

                //转换为ITable中的数据
                for(int k=0;k<count ;k++)
                {
                    //ITable 的记录
                    IRow row = pTable.CreateRow();

                 
                   DataRow pRrow=mTable .Rows[k];
                   //列元素
                   int rowNum= pRrow .ItemArray.Length;
                 
                    // 添加记录
                    for (int n=1;n<rowNum+1 ;n++)
                    {
                        row.set_Value(n,pRrow.ItemArray.GetValue(n-1));
                        row.Store ();
                    }
                }
                return pTable ;
            }
            catch (Exception ex)
            {
                return null;
            }
        }

        /// <summary>
        ///保存DataTable表位DBF ,tempPath 文件完整路径
        /// </summary>
        /// <param name=”mTable”></param>
        /// <returns></returns>
        public static bool  SaveTable(DataTable mTable, string tempPath)
        {
            try
            {
                #region 新建表字段

                IField pField = null;

                IFields fields = new FieldsClass();
                IFieldsEdit fieldsEdit = (IFieldsEdit)fields;
                fieldsEdit.FieldCount_2 = 3;

                pField = new FieldClass();
                IFieldEdit fieldEdit = (IFieldEdit)pField;
                fieldEdit.Name_2 = “FromField”;
                fieldEdit.AliasName_2 = “开始字段值”;
                fieldEdit.Type_2 = esriFieldType.esriFieldTypeDouble;
                fieldEdit.Editable_2 = true;

                //添加开始字段
                fieldsEdit.set_Field(0, pField);

                IField pField1 = new FieldClass();
                IFieldEdit fieldEdit1 = (IFieldEdit)pField1;
                fieldEdit1.Name_2 = “ToField”;
                fieldEdit1.AliasName_2 = “结束字段值”;
                fieldEdit1.Type_2 = esriFieldType.esriFieldTypeDouble;
                fieldEdit1.Editable_2 = true;

                //添加结束字段
                fieldsEdit.set_Field(1, pField1);

                IField pField2 = new FieldClass();
                IFieldEdit fieldEdit2 = (IFieldEdit)pField2;
                fieldEdit2.Name_2 = “outField”;
                fieldEdit2.AliasName_2 = “分类字段值”;
                fieldEdit2.Type_2 = esriFieldType.esriFieldTypeDouble;
                fieldEdit2.Editable_2 = true;
                //添加重分类字段
                fieldsEdit.set_Field(2, pField2);

                #endregion

                string path = System.IO.Path.GetDirectoryName(tempPath);
                string fileName = System.IO.Path.GetFileName(tempPath);

                ShapefileWorkspaceFactoryClass class2 = new ShapefileWorkspaceFactoryClass();
                ESRI.ArcGIS.Geodatabase.IWorkspace pWorkspace = class2.OpenFromFile(path, 0);
                IFeatureWorkspace pFWS = pWorkspace as IFeatureWorkspace;

                //删除已有的
                if (System.IO.File.Exists(tempPath))
                {
                    System.IO.File.Delete(tempPath);
                }

                fileName = fileName.Split(‘.’)[0];
                //创建空表
                ESRI.ArcGIS.Geodatabase.ITable pTable;
                pTable = pFWS.CreateTable(fileName, fieldsEdit, null, null, “”);

                //获取表中记录数
                int count = mTable.Rows.Count;

                //转换为ITable中的数据
                for (int k = 0; k < count; k++)
                {
                    //ITable 的记录
                    IRow row = pTable.CreateRow();

                    DataRow pRrow = mTable.Rows[k];
                    //列元素
                    int rowNum = pRrow.ItemArray.Length;

                    // 添加记录
                    for (int n = 1; n < rowNum + 1; n++)
                    {
                        row.set_Value(n, pRrow.ItemArray.GetValue(n – 1));
                        row.Store();
                    }
                }

                return true ;
            }
            catch (Exception ex)
            {
                return false ;
            }
        }

转载自:https://blog.csdn.net/comeonyangzi/article/details/20611443

You may also like...