private void CarregarListTabelas(string filtro)
{
string firstChar = filtro[0].ToString();
string lastChar = filtro[filtro.Length - 1].ToString();
string filtro_puro = filtro.Replace("*", "");
if (firstChar == "*" && lastChar == "*")
{
listTabelas.DataSource = Geral.ToListof <AgileE.Tabela>(agilee.getTabelas()).Where(x => x.TABLE_NAME.Contains(filtro_puro)).ToList();
}
else if (firstChar == "*" && lastChar != "*")
{
listTabelas.DataSource = Geral.ToListof <AgileE.Tabela>(agilee.getTabelas()).Where(x => x.TABLE_NAME.EndsWith(filtro_puro)).ToList();
}
else if (firstChar != "*" && lastChar == "*")
{
listTabelas.DataSource = Geral.ToListof <AgileE.Tabela>(agilee.getTabelas()).Where(x => x.TABLE_NAME.StartsWith(filtro_puro)).ToList();
}
else
{
listTabelas.DataSource = Geral.ToListof <AgileE.Tabela>(agilee.getTabelas()).Where(x => x.TABLE_NAME == filtro_puro).ToList();
}
listTabelas.ValueMember = "TABLE_NAME";
listTabelas.DisplayMember = "TABLE_NAME";
}
private void CarregarCamposTabelaERP()
{
listCampos.DataSource = Geral.ToListof <AgileE.Campo>(agilee.getCampos(listTabelas.SelectedValue.ToString())).OrderBy(x => x.ID).ToList();
listCampos.ValueMember = "COLUNA";
listCampos.DisplayMember = "COLUNA";
listCamposChave.DataSource = Geral.ToListof <AgileE.Campo>(agilee.getCampos(listTabelas.SelectedValue.ToString())).OrderBy(x => x.ID).ToList();
listCamposChave.ValueMember = "COLUNA";
listCamposChave.DisplayMember = "COLUNA";
}
private void CarregarListaTabelasERP()
{
listTabelas.ValueMember = "TABLE_NAME";
listTabelas.DisplayMember = "TABLE_NAME";
listTabelas.DataSource = Geral.ToListof <AgileE.Tabela>(agilee.getTabelas()).ToList();
}