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 void AddPaged(string sql, PagedSqlCache cache)
{
_paged.Value[sql.GetHashCode()] = cache;
}
public void AddPaged(string sql, PagedSqlCache cache)
{
_paged.Value[sql.GetHashCode()] = cache;
}