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