public static FrmShowFeatureAttributesByTable GetForm(DataTable importDt, GSOLayer layer, GSOGlobeControl globeControl)
{
if (tableAttribute == null)
{
tableAttribute = new FrmShowFeatureAttributesByTable(importDt, layer, globeControl);
}
else
{
dt = importDt;
geoLayer = layer;
globeControl1 = globeControl;
}
return tableAttribute;
}
public static FrmShowFeatureAttributesByTable GetForm(DataTable importDt, GSOLayer layer, GSOGlobeControl globeControl)
{
if (tableAttribute == null)
{
tableAttribute = new FrmShowFeatureAttributesByTable(importDt, layer, globeControl);
}
else
{
dt = importDt;
geoLayer = layer;
globeControl1 = globeControl;
}
return(tableAttribute);
}
private void btn_Apply_Click(object sender, EventArgs e)
{
string caption = cbox_Layers.Text;
if (caption == "")
{
MessageBox.Show("请先添加图层", "提示");
return;
}
GSOLayer layer = globeControl1.Globe.Layers.GetLayerByCaption(caption);
if (layer == null || connectParams == null)
{
return;
}
string sql = "select * from " + cbox_Layers.Text.Trim();
if (textBox_WhereClause.Text != "")
{
sql += " where " + textBox_WhereClause.Text;
try
{
DataTable table = OledbHelper.QueryTable(sql, connectParams);
if (table == null)
{
return;
}
for (int i = 0; i < 3; i++)
{
table.Columns.RemoveAt(0);
}
frm_editor = FrmShowFeatureAttributesByTable.GetForm(table, layer, globeControl1);
frm_editor.SetDataTable();
if (!frm_editor.isShowFirst)
{
frm_editor.Show(this);
}
}
catch (Exception ex)
{
Log.PublishTxt(ex);
MessageBox.Show(ex.Message, "提示");
return;
}
}
}
private void btn_Apply_Click(object sender, EventArgs e)
{
string caption = cbox_Layers.Text;
if (caption == "")
{
MessageBox.Show("请先添加图层", "提示");
return;
}
GSOLayer layer = globeControl1.Globe.Layers.GetLayerByCaption(caption);
if (layer == null || connectParams == null)
{
return;
}
string sql = "select * from " + cbox_Layers.Text.Trim();
if (textBox_WhereClause.Text != "")
{
sql += " where " + textBox_WhereClause.Text;
try
{
DataTable table = OledbHelper.QueryTable(sql,connectParams);
if (table == null)
{
return;
}
for (int i = 0; i < 3; i++)
{
table.Columns.RemoveAt(0);
}
frm_editor = FrmShowFeatureAttributesByTable.GetForm(table, layer, globeControl1);
frm_editor.SetDataTable();
if (!frm_editor.isShowFirst)
{
frm_editor.Show(this);
}
}
catch (Exception ex)
{
Log.PublishTxt(ex);
MessageBox.Show(ex.Message, "提示");
return;
}
}
}
private void Frm_TableAttribute_FormClosing(object sender, FormClosingEventArgs e)
{
tableAttribute = null;
}
private void Frm_TableAttribute_FormClosing(object sender, FormClosingEventArgs e)
{
tableAttribute = null;
}
