using System;
using System.Collections.Generic;
using System.Text;

namespace CRMDAL.Query.Solution
{
    public static class SolutionQB
    {
        public const string GET_SOLUTION_SELECTLIST = @"

WITH PagedSolution AS (
    SELECT
        A.SOLUTIONID AS Id,
        A.SOLUTIONCODE AS SolutionCode,
        A.SOLUTIONNAME AS SolutionName,
        A.REMARKS AS Remarks,
        ROW_NUMBER() OVER (ORDER BY A.SOLUTIONID) AS RowNum
    FROM MSOLUTION A
)
SELECT
    Id,
    SolutionCode,
    SolutionName,
    Remarks
FROM PagedSolution
WHERE
    (@firstnumber = -1 AND @maxresult = -1)
    OR
    (RowNum BETWEEN (@firstnumber + 1) AND (@firstnumber + @maxresult));";
    }
}