Arcgis---使用sql数据库中的数据刷新图层

使用sql语句select需要的数据，通过Arcgis的API插入到相应图层文件中，插入的数据可以在.dbf文件中查看，最后使用Arcgis的API刷新图层即可

using System;using System.Collections;using System.Collections.Generic;using System.Linq;using System.Text;using System.Data;using ESRI.ArcGIS.esriSystem;using ESRI.ArcGIS.Carto;using ESRI.ArcGIS.Controls;using ESRI.ArcGIS.SystemUI;using ESRI.ArcGIS.Geometry;using ESRI.ArcGIS.Geodatabase;using ESRI.ArcGIS.DataSourcesFile;using ESRI.ArcGIS.Display;using ESRI.ArcGIS.Analyst3D;using Wellcomm.DBUtility.Ibatis;   // 自定义using Wellcomm.Model;              // 自定义namespace Wellcomm.BLL.GIS{    /// <summary>    /// 覆盖网格，gxid,gyid,enodeb,ci,cellname    /// </summary>    public class OperateCoverGirdLayer    {        private IFeatureLayer pFeatureLayer;        private IFeatureClass pFeatureClass;        private int RecePowerIndex;        private int PathLossIndex;        private int GXIDIndex;        private int GYIDIndex;        private int cellNameIndex;        private int eNodeBIndex;        private int CIIndex;        // 列名        public OperateCoverGirdLayer()        {            pFeatureLayer = GISMapApplication.Instance.GetLayer("覆盖") as IFeatureLayer;            pFeatureClass=pFeatureLayer.FeatureClass;            this.RecePowerIndex=pFeatureClass.FindField("RecePower");            this.PathLossIndex=pFeatureClass.FindField("PathLoss");            this.GXIDIndex = pFeatureClass.FindField("GXID");            this.GYIDIndex = pFeatureClass.FindField("GYID");            this.cellNameIndex = pFeatureClass.FindField("CellName");            this.eNodeBIndex = pFeatureClass.FindField("eNodeB");            this.CIIndex = pFeatureClass.FindField("CI");        }        /// <summary>        /// 删除图层所有要素        /// </summary>        public void ClearLayer()        {            FeatureUtilities.DeleteFeatureLayerFeatrues(this.pFeatureLayer);        }        /// <summary>        /// 构造小区覆盖网格        /// </summary>        /// <param name="cellname"></param>        /// <param name="enodeb"></param>        /// <param name="ci"></param>        public void constuctCellGrids(string cellname, int enodeb, int ci)        {            DataTable gridTable = new DataTable();            Hashtable ht = new Hashtable();            ht["eNodeB"] = enodeb;            ht["CI"] = ci;            gridTable = IbatisHelper.ExecuteQueryForDataTable("GetSpecifiedCellGrids", ht);            /*             * 通过xml读取数据库             * <!--获取指定小区名称的网格-->                <select id="GetSpecifiedCellGrids" parameterClass="Hashtable">                    select a.GXID, a.GYID, b.MinLong, b.MinLat, b.MaxLong, b.MaxLat, a.ReceivedPowerdbm, a.PathLoss              *      from tbGridPathloss a, tbGridDem b              *      where a.GXID = b.GXID and a.GYID = b.GYID              *      and a.eNodeB = '$eNodeB$' and a.CI = '$CI$'              *      and a.ReceivedPowerdbm > -130                </select>             */            IDataset dataset = (IDataset)pFeatureLayer.FeatureClass;            IWorkspace workspace = dataset.Workspace;            IWorkspaceEdit workspaceEdit = (IWorkspaceEdit)workspace;            workspaceEdit.StartEditing(true);            workspaceEdit.StartEditOperation();            IFeatureCursor pFeatureCursor = pFeatureClass.Insert(true);            IFeatureBuffer pFeatureBuffer;            int gxid, gyid;            float x1, y1, x2, y2;            float recePower, pathLoss;            //循环添加            foreach (DataRow dataRow in gridTable.Rows)            {                gxid = int.Parse(dataRow[0].ToString());                gyid = int.Parse(dataRow[1].ToString());                if (!(float.TryParse(dataRow[2].ToString(), out x1) && float.TryParse(dataRow[3].ToString(), out y1) && float.TryParse(dataRow[4].ToString(), out x2) && float.TryParse(dataRow[5].ToString(), out y2) && float.TryParse(dataRow[6].ToString(), out recePower) && float.TryParse(dataRow[7].ToString(), out pathLoss)))                    continue;                IPoint pointA = GeometryUtilities.ConstructPoint2D(x1, y1);                IPoint pointB = GeometryUtilities.ConstructPoint2D(x2, y1);                IPoint pointC = GeometryUtilities.ConstructPoint2D(x2, y2);                IPoint pointD = GeometryUtilities.ConstructPoint2D(x1, y2);                IGeometryCollection pGeometryColl = GeometryUtilities.ConstructPolygon(new IPoint[] { pointA, pointB, pointC, pointD });                pFeatureBuffer = pFeatureClass.CreateFeatureBuffer();                pFeatureBuffer.Shape = pGeometryColl as IGeometry;   // 形状                pFeatureBuffer.set_Value(this.GXIDIndex, gxid);                pFeatureBuffer.set_Value(this.GYIDIndex, gyid);                pFeatureBuffer.set_Value(this.eNodeBIndex, enodeb);                pFeatureBuffer.set_Value(this.CIIndex, ci);                pFeatureBuffer.set_Value(this.cellNameIndex, cellname);                pFeatureBuffer.set_Value(this.RecePowerIndex, recePower);                pFeatureBuffer.set_Value(this.PathLossIndex, pathLoss);                pFeatureCursor.InsertFeature(pFeatureBuffer);            }            //一次性提交            pFeatureCursor.Flush();            //stop editing               workspaceEdit.StopEditOperation();            workspaceEdit.StopEditing(true);            GISMapApplication.Instance.RefreshLayer(pFeatureLayer);        }

using System;using System.Collections.Generic;using System.Text;using System.Windows.Forms;using ESRI.ArcGIS.Controls;using ESRI.ArcGIS.SystemUI;using ESRI.ArcGIS.Carto;using ESRI.ArcGIS.Analyst3D;using ESRI.ArcGIS.Geometry;using ESRI.ArcGIS.Geodatabase;namespace Wellcomm.BLL.GIS{    /// <summary>    /// GIS的入口操作(采用单例模式)     /// </summary>    public class GISMapApplication    {        private static GISMapApplication instance = null; //当前对象的实例        private AxSceneControl m_axSceneControl = null;        private ISceneControl m_sceneControl = null;        public AxSceneControl AxSceneControl        {            get { return m_axSceneControl; }            set { m_axSceneControl = value; }        }        /// <summary>        /// 地图控件的引用        /// </summary>        public ISceneControl SceneControl        {            get { return m_sceneControl; }            set { m_sceneControl = value; }        }        /// <summary>        /// 初始化的一些方法        /// </summary>        public void Init(AxSceneControl axSceneControl)        {            if (axSceneControl != null)            {                this.m_axSceneControl = axSceneControl;                m_sceneControl = axSceneControl.Object as ISceneControl;            }        }        /// <summary>        /// 当前实例对象(单例模式)        /// </summary>        public static GISMapApplication Instance        {            get            {                if (instance == null)                {                    lock (m_syncObject)                    {                        if (instance == null)                        {                            instance = new GISMapApplication();                        }                    }                }                return instance;            }        }        /// <summary>        /// 刷新指定图层        /// </summary>        /// <param name="pObject"></param>        public void RefreshLayer(object pObject)        {            if (this.m_sceneControl == null)                return;            ISceneGraph pSceneGragh = m_sceneControl.SceneGraph;            pSceneGragh.Invalidate(pObject, true, false);            pSceneGragh.ActiveViewer.Redraw(true);            pSceneGragh.RefreshViewers();        }    }

using System;using System.Linq;using System.Collections.Generic;using Wellcomm.BLL.Geometric;using ESRI.ArcGIS.Geometry;namespace Wellcomm.BLL.GIS{    public static class GeometryUtilities    {        public static IGeometryCollection ConstructPolygon(IPoint[] pointArray)        {            //创建一个Ring对象，通过ISegmentCollection接口向其中添加Segment对象            object o = Type.Missing;            ISegmentCollection pSegCollection = new RingClass();            for (int i = 0; i < pointArray.Length-1; i++)            {                IPoint from = pointArray[i];                IPoint to = pointArray[i+1];                ILine pLine = new LineClass();                //设置Line对象的起始终止点                pLine.PutCoords(from, to);                //QI到ISegment                ISegment pSegment = pLine as ISegment;                pSegCollection.AddSegment(pSegment, ref o, ref o);            }            //QI到IRing接口封闭Ring对象，使其有效            IRing pRing = pSegCollection as IRing;            pRing.Close();            //使用Ring对象构建Polygon对象            IGeometryCollection pGeometryColl = new PolygonClass();            pGeometryColl.AddGeometry(pRing, ref o, ref o);            return pGeometryColl;         }    }}