public virtual void AddOrderBy(string column, WhereParameter.Dir direction) { if (_orderBy.Length > 0) { _orderBy += ", "; } _orderBy += column; if (direction == WhereParameter.Dir.ASC) { _orderBy += " ASC"; } else { _orderBy += " DESC"; } }
/// <summary> /// Overloaded to support aggregates. /// Derived classes implement this, like SqlClientDynamicQuery and OleDbDynamicQuery /// to account for differences in DBMS systems. /// </summary> /// <param name="aggregate">This should be an entry from your Aggregate class</param> /// <param name="direction">Either Descending or Ascending</param> /// <example> /// <code> /// emps.Query.AddOrderBy(emps.Aggregate.CategoryID, WhereParameter.Dir.ASC)</code> /// </example> public virtual void AddOrderBy(AggregateParameter aggregate, WhereParameter.Dir direction) { }
/// <summary> /// Overloaded to let your Query order the data by COUNT(*). /// Used with Query.CountAll set to true. /// Derived classes implement this, like SqlClientDynamicQuery and OleDbDynamicQuery /// to account for differences in DBMS systems. /// </summary> /// <param name="countAll">This should be entity.Query</param> /// <param name="direction">Either Descending or Ascending</param> /// <example> /// <code> /// emps.Query.AddOrderBy(emps.Query, WhereParameter.Dir.ASC)</code> /// </example> public virtual void AddOrderBy(DynamicQuery countAll, WhereParameter.Dir direction) { }