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