//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;
}
}
}
/// <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);
}
}
}
/// <summary>
/// SQL设置
/// </summary>
private void button3_Click(object sender, EventArgs e)
{
SQLExpressionDialog sqlDialog = new SQLExpressionDialog();
sqlDialog.Table = _plan.FeatureSet.DataTable;
sqlDialog.ShowDialog();
if (sqlDialog.DialogResult == DialogResult.OK)
{
textBox3.Text = sqlDialog.Expression;
_controlZone.SQL = sqlDialog.Expression;
}
}
