protected void CarregarDados(String owner, String tabela)
{
if (tabela.Length < 4 || tabela.Trim() == String.Empty)
{
lblvalidacao.Text = "Informe pelo menos 4 caracteres!";
return;
}
dvtabelas.Visible = false;
dvcolunas.Visible = false;
dvindices.Visible = false;
dvconstraint.Visible = false;
dvgrant.Visible = false;
if (!CarregaTabelasPrincipais(owner, ref tabela))
{
dvcolunas.Visible = true;
dvindices.Visible = true;
dvconstraint.Visible = true;
dvgrant.Visible = true;
var DataColumns = new dExecutorScripts().ObterColunasdaTabela(owner, tabela);
var DataIndices = new dExecutorScripts().ObterIndicesdaTabela(owner, tabela);
var DataConstraints = new dExecutorScripts().ObterConstraintsdaTabela(owner, tabela);
var DataGrants = new dExecutorScripts().ObterGrantsTabela(owner, tabela);
AssociarDadosGrid(dgcolunas, DataColumns, lblcoluna);
AssociarDadosGrid(dgindices, DataIndices, lblindice);
AssociarDadosGrid(dgconstraint, DataConstraints, lblconstraint);
AssociarDadosGrid(dggrant, DataGrants, lblgrant);
}
}
protected bool CarregaTabelasPrincipais(string owner, ref string tabela)
{
bool bIndicaMaisdeUmRegistro = false;
var DataTables = new dExecutorScripts().ObterTabela(owner, tabela);
if (DataTables.Rows.Count == 0)
{
DataTables = new dExecutorScripts().ObterTabelas(owner, tabela);
if (DataTables.Rows.Count > 1 || DataTables.Rows.Count == 0)
{
bIndicaMaisdeUmRegistro = true;
dvtabelas.Visible = true;
AssociarDadosGrid(dgtabelas, DataTables, lbltabelas);
}
else
{
//indica que encontrou somente um parecido
tabela = (string)DataTables.Rows[0]["table_name"];
}
}
return bIndicaMaisdeUmRegistro;
}
protected bool CarregaTabelasPrincipais(String owner, String tabela)
{
bool bIndicaMaisdeUmRegistro = false;
var DataTables = new dExecutorScripts().ObterTabela(owner, tabela);
if (DataTables.Rows.Count == 0)
{
bIndicaMaisdeUmRegistro = true;
dvtabelas.Visible = true;
AssociarDadosGrid(dgtabelas, DataTables, lbltabelas);
}
return bIndicaMaisdeUmRegistro;
}