private void btnEditComputed_Click(object sender, EventArgs e) { ListViewItem item = lstComputed.SelectedItems[0]; string alias = item.SubItems[0].Text; string exprText = ""; using (var expr = OSGeo.FDO.Expression.Expression.Parse(item.SubItems[1].Text)) { using (var comp = new OSGeo.FDO.Expression.ComputedIdentifier(alias, expr)) { exprText = comp.ToString(); } } exprText = ExpressionEditor.EditExpression(_conn, _presenter.SelectedClass, null, exprText, ExpressionMode.Normal); if (exprText != null) { //Test to see if it is a computed identifier using (var expr = OSGeo.FDO.Expression.Expression.Parse(exprText)) { var comp = expr as OSGeo.FDO.Expression.ComputedIdentifier; if (comp != null) { exprText = comp.Expression.ToString(); alias = GetExpressionAlias(comp.Name); } else { alias = GetExpressionAlias("Expr0"); } } item.SubItems[0].Text = alias; item.SubItems[1].Text = exprText; } }
private void btnGroupFilter_Click(object sender, EventArgs e) { string expr = txtGroupFilter.Text; expr = ExpressionEditor.EditExpression(_conn, _presenter.SelectedClass, null, expr, ExpressionMode.Filter); if (expr != null) { txtGroupFilter.Text = expr; } }
private void btnEditComputed_Click(object sender, EventArgs e) { ListViewItem item = lstComputed.SelectedItems[0]; string expr = item.SubItems[1].Text; expr = ExpressionEditor.EditExpression(_conn, _presenter.SelectedClass, null, expr, ExpressionMode.Normal); if (expr != null) { item.SubItems[1].Text = expr; } }
private void txtFilter_Enter(object sender, EventArgs e) { if (!string.IsNullOrEmpty(this.Filter)) { string filter = ExpressionEditor.EditExpression(_conn, _presenter.SelectedClass, null, this.Filter, ExpressionMode.Filter); if (filter != null) { this.Filter = filter; } } else { this.Filter = ExpressionEditor.NewExpression(_conn, _presenter.SelectedClass, null, ExpressionMode.Filter); } }
private void InitContextMenus() { ctxDeleteTarget = new ContextMenuStrip(); ctxSourceFilter = new ContextMenuStrip(); ctxBatchSize = new ContextMenuStrip(); ctxFlatten = new ContextMenuStrip(); ctxForceWkb = new ContextMenuStrip(); //Delete Target ctxDeleteTarget.Items.Add("True", null, delegate { this.Delete = true; }); ctxDeleteTarget.Items.Add("False", null, delegate { this.Delete = false; }); //Source Filter ctxSourceFilter.Items.Add("Set Filter", null, delegate { string filter = this.SourceFilter; string newFilter = ExpressionEditor.EditExpression(Parent.GetSourceConnection(), Parent.SourceClass, null, filter, ExpressionMode.Filter); if (filter != newFilter) { this.SourceFilter = newFilter; } }); ctxSourceFilter.Items.Add("Clear", null, delegate { this.SourceFilter = string.Empty; }); //Flatten Geometries ctxFlatten.Items.Add("True", null, delegate { this.Flatten = true; }); ctxFlatten.Items.Add("False", null, delegate { this.Flatten = false; }); //Force wkb ctxForceWkb.Items.Add("True", null, delegate { this.ForceWkb = true; }); ctxForceWkb.Items.Add("False", null, delegate { this.ForceWkb = false; }); //Batch Size ctxBatchSize.Items.Add("Set Size", null, delegate { string result = MessageService.ShowInputBox("Batch Size", "Set batch size", this.BatchSize.ToString()); int size; while (!int.TryParse(result, out size)) { result = MessageService.ShowInputBox("Batch Size", "Set batch size", result); if (result == null) //cancelled { return; } } this.BatchSize = size; }); }
private void PromptRightFilter() { var connMgr = ServiceManager.Instance.GetService <FdoConnectionManager>(); var conn = connMgr.GetConnection(this.SelectedRightConnection); using (var svc = conn.CreateFeatureService()) { using (ClassDefinition cd = svc.GetClassByName(this.SelectedRightSchema, this.SelectedRightClass)) { var expr = ExpressionEditor.EditExpression(conn, cd, null, txtRightFilter.Text, ExpressionMode.Filter); if (expr != null) { txtRightFilter.Text = expr; } } } }
private void OnEditExpression(object sender, EventArgs e) { TreeNode exprNode = _treeView.SelectedNode; Debug.Assert(exprNode.Tag != null); ExpressionMappingInfo expr = exprNode.Tag as ExpressionMappingInfo; if (expr != null) { string newExpr = ExpressionEditor.EditExpression(Parent.GetSourceConnection(), Parent.SourceClass, null, expr.Expression, ExpressionMode.Normal); if (newExpr != null) //null = cancel { exprNode.ToolTipText = "Expression: " + newExpr; expr.Expression = newExpr; } } }
private void txtUpdateFilter_Click(object sender, EventArgs e) { if (_classDef == null) { using (FdoFeatureService service = _conn.CreateFeatureService()) { _classDef = service.GetClassByName(this.ClassName); } } if (!string.IsNullOrEmpty(this.Filter)) { string filter = ExpressionEditor.EditExpression(_conn, _classDef, null, this.Filter, ExpressionMode.Filter); if (filter != null) { this.Filter = filter; } } else { this.Filter = ExpressionEditor.NewExpression(_conn, _classDef, null, ExpressionMode.Filter); } }
private void btnFilter_Click(object sender, EventArgs e) { var cls = cmbClass.SelectedItem as ClassDefinition; if (cls != null) { var aliasedClasses = new Dictionary <string, ClassDefinition>(); aliasedClasses.Add(txtJoinClassAlias.Text, cls); bool found = false; foreach (FeatureSchema fs in (FeatureSchemaCollection)cmbSchema.DataSource) { if (fs.Name == _primarySchemaName) { foreach (ClassDefinition cd in fs.Classes) { if (cd.Name == _primaryClassName) { aliasedClasses.Add(_primaryClassAlias, cd); found = true; break; } } } if (found) { break; } } string expr = ExpressionEditor.EditExpression(_conn, cls, aliasedClasses, txtJoinFilter.Text, ExpressionMode.Filter); if (expr != null) { txtJoinFilter.Text = expr; } } }