//查询所在区域
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");*/
}
/// <summary>
/// Clean up any resources being used.
/// </summary>
protected override void Dispose(bool disposing)
{
if (disposing)
{
if (components != null)
{
components.Dispose();
}
miCommand.Cancel();
miCommand.Dispose();
miConnection.Close();
}
base.Dispose(disposing);
}
