//查询所在区域 private String FindMapInRegion(double x, double y, String tableName, String colName) { String ret = ""; try { MapInfo.Data.MIConnection connection = new MapInfo.Data.MIConnection(); connection.Open(); MapInfo.Data.MICommand command = connection.CreateCommand(); command.CommandText = "Select * from " + tableName + " where MI_Point(@x, @y, @cs) within obj"; command.Parameters.Add("@x", x); command.Parameters.Add("@y", y); command.Parameters.Add("@cs", this.mapControl.Map.GetDisplayCoordSys()); command.Prepare(); MapInfo.Data.IResultSetFeatureCollection irfc = command.ExecuteFeatureCollection(); if (irfc.Count > 0) { ret = irfc[0][colName].ToString(); } command.Dispose(); connection.Close(); } catch { } return(ret); /* * Feature ftr1 = new Feature(tableTemp.TableInfo.Columns); * ftr1.Geometry = new MapInfo.Geometry.Point(mapControl.Map.GetDisplayCoordSys(), new DPoint(113.70, 23.04)) as FeatureGeometry; * MapInfo.Data.SearchInfo si = MapInfo.Data.SearchInfoFactory.SearchWithinFeature(ftr1, ContainsType.Geometry); * si.QueryDefinition.Columns = null; * MapInfo.Data.IResultSetFeatureCollection irfc = MapInfo.Engine.Session.Current.Catalog.Search("chinagl_guide", si); * if(irfc.Count > 0) * MessageBox.Show(irfc[0]["Name"].ToString()); * else MessageBox.Show("null");*/ }
//查询附近地物 private String FindMapNearInfo(double x, double y, String tableName, String colName, int meter) { String ret = ""; try { MapInfo.Data.SearchInfo si = MapInfo.Data.SearchInfoFactory.SearchNearest(new DPoint(x, y), mapControl.Map.GetDisplayCoordSys(), new Distance(meter, DistanceUnit.Meter)); si.QueryDefinition.Columns = null; (si.SearchResultProcessor as ClosestSearchResultProcessor).Options = ClosestSearchOptions.StopAtFirstMatch; MapInfo.Data.IResultSetFeatureCollection irfc = MapInfo.Engine.Session.Current.Catalog.Search(tableName, si); if (irfc.Count > 0) { ret = irfc[0][colName].ToString(); } irfc.Close(); } catch { } return(ret); }