/// <summary>
    ///  分页查询
    /// </summary>
    /// <param name="input"></param>
    /// <returns></returns>
    [HttpPost]
    [ApiDescriptionSettings(Name = "Page")]
    public virtual async Task<SqlSugarPagedList<Formula>> Page(PageQueryInput input)
    {
        var whereList = _db.Utilities.JsonToConditionalModels(input.QueryJson);
        var query = _rep.AsQueryable();
        query.IncludesAllFirstLayer(_ignoreColumns);
        query.Where(whereList);
        query.OrderBy(input.OrderByModels);
        return await query.ToPagedListAsync(input.Page, input.PageSize);
    }

SELECT * FROM (SELECT [ArtifactId],[BomId],[EffectCode],[Remark],[Code],[Name],[TenantId],[CreateTime],[UpdateTime],[CreateUserId],[CreateUserName],[UpdateUserId],[UpdateUserName],[IsDelete],[Id],ROW_NUMBER() OVER( ORDER BY GetDate() ) AS RowIndex  FROM [Formula] 
WHERE  (    [code] LIKE '%A%'   OR   [name] LIKE '%A%'   )  ) T 
WHERE RowIndex BETWEEN 1 AND 20