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