//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; } }