public async Task <PagedList <TTarget> > QueryPageAsync <TTarget>(string sql, int pageIndex, int pageSize, string orderBy = null, TEntity objParameter = null, CommandType cmdType = CommandType.Text) { int cacheKey = RepositoryHelper.GetHashKey(this.ConnString, sql + orderBy ?? ""); sql = RepositoryHelper.GetPagingCache(cacheKey, this.ConnString, sql, pageIndex, pageSize, orderBy, this.Provider); return(await this.QueryPageImplAsync <TTarget>(cacheKey, typeof(TTarget), sql, cmdType, objParameter)); }
public PagedList <TEntity> QueryPage(string sql, int pageIndex, int pageSize, string orderBy = null, TEntity objParameter = null, CommandType cmdType = CommandType.Text) { int cacheKey = RepositoryHelper.GetHashKey(this.ConnString, sql + orderBy ?? ""); sql = RepositoryHelper.GetPagingCache(cacheKey, this.ConnString, sql, pageIndex, pageSize, orderBy, this.Provider); return(this.QueryPageImpl <TEntity>(cacheKey, Mapper.EntityType, sql, cmdType, objParameter)); }
public PagedList <TEntity> QueryPage <TEntity>(string sql, int pageIndex, int pageSize, string orderBy = null, object objParameter = null, CommandType cmdType = CommandType.Text) { Type paramType = objParameter != null?objParameter.GetType() : null; int cacheKey = RepositoryHelper.GetHashKey(this.ConnString, sql + orderBy ?? "", paramType); sql = RepositoryHelper.GetPagingCache(cacheKey, this.ConnString, sql, pageIndex, pageSize, orderBy, this.Provider); return(this.QueryPageImpl <TEntity>(cacheKey, typeof(TEntity), sql, cmdType, objParameter, paramType)); }