字段排序

我们知道表里面的记录是按照时间的顺序创建的，如果要对某一字段排序，ArcGIS的字段上点右键，但是当我们重新打开后，发现没有变化。写了断小代码可以对表的字段排序，没有对要素类排序，可以参考和修改代码

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using ESRI.ArcGIS.Carto;
using ESRI.ArcGIS.Geodatabase;
using ESRI.ArcGIS.esriSystem;
namespace TableSort
{
    public partial class Sort : Form
    {
        private ITable pTable;
        IMap pMap;
        public Sort(IMap _pMap)
        {
            InitializeComponent();
            this.pMap = _pMap;
        }
        private void Sort_Load(object sender, EventArgs e)
        {
            IDataset pDataset = null;
            ITable plTable=null ;
            ITableCollection pTableCollection = pMap as ITableCollection;
            for (int i = 0; i < pTableCollection.TableCount; i++)
            {
                plTable = pTableCollection.get_Table(i);
                pDataset = plTable as IDataset;
                comboBox1.Items.Add(pDataset.Name);
               
            }

           comboBox1.Text = comboBox1.Items[0].ToString();
       
           FieldName(comboBox2, FindTable (pMap as ITableCollection  ,comboBox1.Text ));
           comboBox3.Items.Add("升序");
           comboBox3.Items.Add("降序");
           comboBox3.Text = comboBox3.Items[0].ToString();
        }
        private void FieldName(ComboBox _pComBox, ITable _pTable)
        {
            IFields pTableFields = _pTable.Fields;
            for (int i = 0; i < pTableFields.FieldCount; i++)
            {
                if ( pTableFields.get_Field(i).Type != esriFieldType.esriFieldTypeOID)
                {
                    _pComBox.Items.Add(pTableFields.get_Field(i).Name);
                }
            }
           _pComBox.Text = _pComBox.Items[0].ToString();
        }
        private ITable FindTable(ITableCollection _pTabbleCollection, string _Name)
        {
            ITable plTable = null; ;
            IDataset plDataset;
            for (int i = 0; i < _pTabbleCollection .TableCount ;i++)
            {
              
                plDataset = _pTabbleCollection.get_Table(i) as IDataset;
                if (plDataset.Name == _Name.Trim ())
                {
                    plTable = _pTabbleCollection.get_Table(i);
                    break;
                }
            }
            return plTable;
        }
        private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
        {
            FieldName(comboBox2, FindTable(pMap as ITableCollection, comboBox1.Text));
        }
        private void bOK_Click(object sender, EventArgs e)
        {
            pTable = FindTable(pMap as ITableCollection, comboBox1.Text);
            ITableSort plTalbeSort = new TableSortClass();
            plTalbeSort.Table = pTable;
            plTalbeSort.Fields = comboBox2.Text.Trim();
            if (comboBox3.Text.Trim () == "降序")
            {
                plTalbeSort.set_Ascending(comboBox2.Text, false );
            }
            else
            {
                plTalbeSort.set_Ascending(comboBox2.Text, true);
            }
            plTalbeSort.Sort(null);           
           
            ICursor plSortCursor = plTalbeSort.Rows;
            IRow pSortRow = plSortCursor .NextRow ();
            IDataset plSortDataset = pTable as IDataset;
            IFeatureWorkspace plFWS = plSortDataset.Workspace as IFeatureWorkspace;
           ITable plStable= plFWS.CreateTable("NewSort", pTable.Fields, null, null, null);

           while (pSortRow != null)
           {
               IRow pRow = plStable.CreateRow();
               for (int i=0;i <pRow .Fields .FieldCount;i++ )
               {
                   if (pRow .Fields .get_Field (i).Type !=esriFieldType .esriFieldTypeOID)
                   {
                      pRow.set_Value (i,pSortRow .get_Value (i));
                   }
               }
               pRow.Store();
               pSortRow = plSortCursor.NextRow();
           }
           ITableCollection pTC = pMap as ITableCollection;
           pTC.AddTable(plStable);
         
        }
       
    }

}