public string getOrderByParams(DataBase.DataBase nDataBase)
{
var OrderByParams = new StringBuilder("");
foreach (var Item in this._Columns)
{
if (OrderByParams.Length > 0)
OrderByParams.Append(", ");
OrderByParams.Append(nDataBase.FormatToDatabaseColumnName(Item.ColumnName) + " " + (Item.Ascendente ? nDataBase.Identifier_OrderBy_ASC : nDataBase.Identifier_OrderBy_DESC));
}
return OrderByParams.ToString();
}
public string ToColumnsString(DataBase.DataBase nDataBase)
{
var columns = new StringBuilder("");
foreach (var Item in this._Columns)
{
if (columns.Length > 0)
columns.Append(", ");
if( nDataBase != null )
columns.Append(nDataBase.FormatToDatabaseColumnName(Item.ColumnName));
else
columns.Append(Item.ColumnName);
}
return columns.ToString();
}
