using System;

namespace MMDAL.Query.Counter
{
    internal class CounterQB
    {
        public const string GET_SELECTLIST_COUNTER = @"
            WITH Counter AS
            (
                SELECT
                    A.COUNTERID   AS Id,
                    A.COUNTERCODE AS Code,
                    A.COUNTERNAME AS Name,
                    ROW_NUMBER() OVER (ORDER BY A.COUNTERID) AS RowNum
                FROM MCOUNTER A
            )
            SELECT
                Id,
                Code,
                Name
            FROM Counter
            WHERE
                (@firstnumber = -1 AND @maxresult = -1)
                OR (RowNum BETWEEN @firstnumber AND @maxresult);";
    }
}