public void SetSQLFilter(string[] tables, DbConsole db, SQLFilter filter) { this.Tables = tables; this.DbConsole = db; if (!string.IsNullOrEmpty(filter.Table)) { cmbTabela.Text = filter.Table; } if (filter.Field != null) { cmbCampo.Text = filter.Field.Name; } if (!string.IsNullOrEmpty(filter.Filter)) { cmbExpressao.Text = filter.Filter; } if (!string.IsNullOrEmpty(filter.Value)) { txtValor.Text = filter.Value; } }
public SQLFilter GetSQLFilter() { if (cmbTabela.SelectedIndex == -1 || cmbCampo.SelectedIndex == -1 || cmbExpressao.SelectedIndex == -1) { MessageBox.Show("Preencha todos os campos"); } SQLFilter s = new SQLFilter(); s.Table = cmbTabela.Text; s.Field = (SQLField)cmbCampo.SelectedItem; s.Filter = cmbExpressao.Text; s.Value = txtValor.Text; return(s); }