/// <summary>
/// Find a feature by query expression
/// </summary>
private void FindTool_Click(object sender, EventArgs e)
{
Map mainMap = App.Map as Map;
List<ILayer> layers;
if (mainMap != null)
layers = mainMap.GetAllLayers();
else
layers = mainMap.GetLayers();
IFeatureLayer fl = null;
foreach (ILayer layer in layers)
{
if (layer.IsSelected)
{
fl = layer as IFeatureLayer;
break;
}
}
if (fl == null)
{
MessageBox.Show("Please select a feature layer.");
return;
}
SQLExpressionDialog qd = new SQLExpressionDialog();
if (fl.DataSet.AttributesPopulated)
qd.Table = fl.DataSet.DataTable;
else
qd.AttributeSource = fl.DataSet;
// Note: User must click ok button to see anything.
if (qd.ShowDialog() == DialogResult.Cancel)
return;
if (!String.IsNullOrWhiteSpace(qd.Expression))
{
try
{
fl.SelectByAttribute(qd.Expression);
}
catch (SyntaxErrorException ex)
{
MessageBox.Show("The syntax of that query isn't quite right: " + ex.Message);
}
}
}
//User Click the Select Button
private void BtnSelectClick(object sender, EventArgs e)
{
if (_enableUpdate)
{
if (((IndexParam)base.Param).Fs == null || ((IndexParam)base.Param).Fs.DataTable == null) return;
if (((IndexParam)base.Param).Fs.DataTable.Rows.Count < 1) return;
SQLExpressionDialog dlgExpression = new SQLExpressionDialog();
dlgExpression.Table = ((IndexParam)base.Param).Fs.DataTable;
dlgExpression.ShowDialog();
if (dlgExpression.DialogResult == DialogResult.OK)
{
_expression = dlgExpression.Expression;
textBox1.Text = _expression;
base.Status = ToolStatus.Ok;
_click = true;
LightTipText = ModelingMessageStrings.FeaturesSelected;
}
}
}
//Executes a query
private void QueryExe()
{
var queryDialog = new SQLExpressionDialog();
queryDialog.ChangesApplied += QueryDialog_ChangesApplied;
if (_featureLayer.DataSet.AttributesPopulated)
{
queryDialog.Table = _featureLayer.DataSet.DataTable;
}
else
{
queryDialog.AttributeSource = _featureLayer.DataSet;
}
queryDialog.ShowDialog(this);
queryDialog.ChangesApplied -= QueryDialog_ChangesApplied;
}