public string GetSelect()
{
var fieldsAtr = new List <string>();
var fields = new List <string>();
foreach (var campo in _campos)
{
fieldsAtr.Add($"{campo.Atributo} as \"{campo.Atributo}\"");
fields.Add($"{campo.Nome} as {campo.Atributo}");
}
var sql =
$"select {string.Join(", ", fieldsAtr)}" +
$" from (select {string.Join(", ", fields)} from {_tabela.Nome})" +
(!string.IsNullOrWhiteSpace(_where) ? $" where {_where}" : string.Empty);
if (_qtde != -1)
{
sql = _tipoDatabase.GetSelectLim(sql, _qtde, _pagina);
}
return(sql);
}
//-- limits
public static string GetSelectLim <TObject>(this TipoDatabase tipoDatabase, string sql, int qtde, int pagina = 0)
{
return(tipoDatabase.GetSelectLim(sql, qtde, pagina));
}