mapInfo表操作,mapXtreme2008 VS c#

查询oracle数据表

建立临时表存储筛选后的数据

建立专题图

private void OpenOrclTab(string tabname)
{
try
{
TableInfoServer ti = new TableInfoServer(tabname);
ti.ConnectString = mapconstr;
ti.Query = "Select * From " + tabname;
ti.Toolkit = ServerToolkit.Oci;
ti.CacheSettings.CacheType = CacheOption.Off;
Table tbl = connection.Catalog.OpenTable(ti);
FeatureLayer MyLayer = new FeatureLayer(tbl);
int wz = MainMap.Map.Layers.Add(MyLayer);
//MainMap.Map.Layers.Insert(0, MyLayer);




//据管理公司不同渲染专题图
if ("MANAGEAREA".Equals(tabname))
{
//hj
MapInfo.Data.TableInfoMemTable tb2 = new MapInfo.Data.TableInfoMemTable("tempTable");//构建新的内存表pathTable
//复制表结构
TableInfo tInfo = MyLayer.Table.TableInfo;
int count = tInfo.Columns.Count;

//CODE Decimal (14, 0) ;
//ALIAS Char (128) ;
//MANAGER_ID Decimal (14, 0) ;
//MANAGE Char (50) ;
//MODI Char (50) ;
// MI_PRINX Decimal (12, 0) ;

tb2.Columns.Add(MapInfo.Data.ColumnFactory.CreateDecimalColumn(tInfo.Columns[0].ToString(), 14, 0));
tb2.Columns.Add(MapInfo.Data.ColumnFactory.CreateStringColumn(tInfo.Columns[1].ToString(), 128));
tb2.Columns.Add(MapInfo.Data.ColumnFactory.CreateDecimalColumn(tInfo.Columns[2].ToString(), 14, 0));
tb2.Columns.Add(MapInfo.Data.ColumnFactory.CreateStringColumn(tInfo.Columns[3].ToString(), 50));
tb2.Columns.Add(MapInfo.Data.ColumnFactory.CreateStringColumn(tInfo.Columns[4].ToString(), 50));
//style
tb2.Columns.Add(MapInfo.Data.ColumnFactory.CreateStyleColumn());
//id
tb2.Columns.Add(MapInfo.Data.ColumnFactory.CreateDecimalColumn(tInfo.Columns[6].ToString(), 12, 0));
//geo
tb2.Columns.Add(MapInfo.Data.ColumnFactory.CreateFeatureGeometryColumn(tInfo.Columns[7].ToString(), MyLayer.Map.GetDisplayCoordSys()));
MapInfo.Data.Table table = MapInfo.Engine.Session.Current.Catalog.CreateTable(tb2);




MIDataReader mr = MyLayer.Table.ExecuteReader();
int i, n = mr.FieldCount;
while (mr.Read())
{
object o = mr.GetValue(3);
if (o.ToString().Equals(DBConnection.key))
{
table.InsertFeature(mr.Current);
}
else
{
}
}
FeatureLayer newMyLayer = new FeatureLayer(table);
wz = MainMap.Map.Layers.Add(newMyLayer);
mr.Close();
IndividualValueTheme thm = new IndividualValueTheme(newMyLayer, "MANAGE", "管理单位");
// thm.ModelStyle.AreaStyle;

// Add the theme to the FeatureStyleModifiers list
newMyLayer.Modifiers.Append(thm);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}