public PagedBuilderResult Build(string sql,object[] args,Pagination page) { var result=new PagedBuilderResult(); var provCache = _info.GetSqlCache(_provider.ProviderId); var cache = provCache.GetPaged(sql); var pm = new ParametersManager(args); if (cache == null) { cache = new PagedSqlCache(); cache.CountSql = GetCountSql(sql); cache.PagedSql = _provider.FormatQueryPagination(sql, page, pm); provCache.AddPaged(sql, cache); } else { pm.AddValues(page.Skip, page.PageSize); } result.CountSql = cache.CountSql; result.PagedSql = cache.PagedSql; result.Args=pm.ToArray(); return result; }
public PagedBuilderResult Build(string sql, object[] args, Pagination page) { var result = new PagedBuilderResult(); var provCache = _info.GetSqlCache(_provider.ProviderId); var cache = provCache.GetPaged(sql); var pm = new ParametersManager(args); if (cache == null) { cache = new PagedSqlCache(); cache.CountSql = GetCountSql(sql); cache.PagedSql = _provider.FormatQueryPagination(sql, page, pm); provCache.AddPaged(sql, cache); } else { pm.AddValues(page.Skip, page.PageSize); } result.CountSql = cache.CountSql; result.PagedSql = cache.PagedSql; result.Args = pm.ToArray(); return(result); }