using System;

namespace AccountsDAL.Query.BIZDimensionValue
{
    public static class BizDimensionValueQB
    {
        public const string GET_BIZDIMENSIONVALUE_SELECTLIST = @"

WITH PagedBizDimensionValue AS (
    SELECT
        A.BIZDIMENSIONVALUEID AS Id,
        A.BIZDIMENSIONVALUECODE AS Code,
        A.BIZDIMENSIONVALUENAME AS Name,
        ROW_NUMBER() OVER (ORDER BY A.BIZDIMENSIONVALUEID) AS RowNum
    FROM MBIZDIMENSIONVALUE A
)
SELECT
    Id,
    Code,
    Name
FROM PagedBizDimensionValue
WHERE
    (@firstnumber = -1 AND @maxresult = -1)
    OR
    (RowNum BETWEEN (@firstnumber + 1) AND (@firstnumber + @maxresult));";
    }
}