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