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