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