/// <summary> /// Instantiate the object. /// </summary> /// <param name="columnName">Column name on which to order results.</param> /// <param name="direction">Direction by which results should be returned.</param> public DbResultOrder(string columnName, DbOrderDirection direction) { if (String.IsNullOrEmpty(columnName)) { throw new ArgumentNullException(nameof(columnName)); } ColumnName = columnName; Direction = direction; }
public SqlOrderColumn(IDbSelectable selectable, DbOrderDirection direction = DbOrderDirection.Asc) { DbSelectable = selectable; Direction = direction; }
public IDbOrderByColumn BuildOrderByColumn(IDbSelectable selectable, DbOrderDirection direction = DbOrderDirection.Asc) { return(new SqlOrderColumn(selectable, direction)); }
public DbResult <Track> FindAll( string searchString = "", bool doPaging = false, int pageNo = 1, int pageSize = 25, string orderBy = "id", DbOrderDirection orderDirection = DbOrderDirection.ASC) { IEnumerable <Track> entities = null; var count = 0; using (IDbConnection conn = factory.GetConnection()) { #region Criteria if (!String.IsNullOrEmpty(searchString)) { throw new NotImplementedException(); } #endregion #region Sql Ordering var sqlOrderBy = String.Empty; if (!String.IsNullOrEmpty(orderBy) || orderSetting[orderBy] == null) { orderBy = "id"; } if (orderSetting[orderBy] != null) { sqlOrderBy = "order by " + orderSetting[orderBy]; if (orderDirection == DbOrderDirection.ASC) { sqlOrderBy = sqlOrderBy + " asc"; } else { sqlOrderBy = sqlOrderBy + " desc"; } } #endregion #region Find Count var sqlCount = "select count(*) from Track"; conn.Open(); count = conn.Query <int>(sqlCount, new { searchString = searchString }).FirstOrDefault <int>(); conn.Close(); #endregion #region Paging if (doPaging) { throw new NotImplementedException(); } #endregion var sql = String.Empty; sql = "select TrackId as Id, Name from Track"; conn.Open(); entities = conn.Query <Track>(sql); } return(new DbResult <Track>() { Items = entities, Count = count }); }
/// <summary> /// Instantiate the object. /// </summary> public DbResultOrder() { ColumnName = null; Direction = DbOrderDirection.Ascending; }