//查询所在区域
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);
}
