//查询所在区域
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");*/
}
public Form1()
{
//
// Required for Windows Form Designer support
//
InitializeComponent();
UpdateNavigationButtons();
this.components = new System.ComponentModel.Container();
//
// Create a command object to hold parameters and last command executed
//
this.miConnection = new MIConnection();
miConnection.Open();
this.miCommand = miConnection.CreateCommand();
}
public Form1()
{
//
// Required for Windows Form Designer support
//
InitializeComponent();
UpdateNavigationButtons();
this.components = new System.ComponentModel.Container();
//
// Create a command object to hold parameters and last command executed
//
this.miConnection = new MIConnection();
miConnection.Open();
this.miCommand = miConnection.CreateCommand();
}
