Example #1
0
 public IEnumerable <T> QueryPage <T>(object predicate, IList <ISort> sort, int page, int resultsPerPage, DbTransaction transaction, int?commandTimeout, bool buffered) where T : Cissy.Database.IEntity
 {
     return(_dapper.GetPage <T>(Connection, predicate, sort, page, resultsPerPage, transaction, commandTimeout, buffered));
 }
Example #2
0
 public IEnumerable <T> GetPage <T>(object predicate, IList <ISort> sort, int page, int resultsPerPage, IDbTransaction transaction, int?commandTimeout, bool buffered) where T : class
 {
     return(_dapper.GetPage <T>(Connection, predicate, sort, page, resultsPerPage, transaction, commandTimeout, buffered));
 }
Example #3
0
        ///// <summary>
        ///// 根据查询条件选择满足条件的记录并返回IEnumerable<T>
        ///// Executes a select query using the specified predicate, returning an IEnumerable data typed as per T.
        ///// </summary>
        ///// <typeparam name="T">实体类型</typeparam>
        ///// <param name="connection">数据库连接</param>
        ///// <param name="predicate">查询条件</param>
        ///// <param name="sort">排序列表</param>
        ///// <param name="transaction">事务</param>
        ///// <param name="commandTimeout">超时时间</param>
        ///// <param name="buffered">是否缓存,默认不缓存</param>
        ///// <returns>T类型的枚举器</returns>
        //public static IEnumerable<T> GetList<T>(this IDbConnection connection, Expression func, IDbTransaction transaction = null, int? commandTimeout = null, bool buffered = false) where T : class
        //{
        //    return Instance.GetList<T>(connection, func, transaction, commandTimeout, buffered);
        //}
        #endregion

        /// <summary>
        /// 根据查询条件分页选择满足条件的记录并返回当前页数据IEnumerable<T>
        /// 返回的数据由当前数据页和页大小决定
        /// Executes a select query using the specified predicate, returning an IEnumerable data typed as per T.
        /// Data returned is dependent upon the specified page and resultsPerPage.
        /// </summary>
        /// <typeparam name="T">实体类型</typeparam>
        /// <param name="connection">数据库连接</param>
        /// <param name="predicate">查询条件</param>
        /// <param name="sort">排序列表</param>
        /// <param name="page">页索引</param>
        /// <param name="resultsPerPage">页大小</param>
        /// <param name="transaction">事务</param>
        /// <param name="commandTimeout">超时时间</param>
        /// <param name="buffered">是否缓存,默认为false</param>
        /// <returns>当前页的数据</returns>
        public static IEnumerable <T> GetPage <T>(this IDbConnection connection, object predicate, IList <ISort> sort, int page, int resultsPerPage, IDbTransaction transaction = null, int?commandTimeout = null, bool buffered = false) where T : class
        {
            return(Instance.GetPage <T>(connection, predicate, sort, page, resultsPerPage, transaction, commandTimeout, buffered));
        }