using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace CRMDAL.Query.Problem
{
    public static class ProblemQB
    {
        public const string GET_SELECTLIST_PROBLEM_SQL = @"
                                                    WITH ProblemList AS (
                                                        SELECT
                                                            p.PROBLEMID   AS Id,
                                                            p.PROBLEMCODE AS Code,
                                                            p.PROBLEMNAME AS Name,
                                                            ROW_NUMBER() OVER (ORDER BY p.PROBLEMID) AS RowNum
                                                        FROM MPROBLEM p
                                                        WHERE 1 = 1
                                                          AND p.STATUS = 1
                                                    )
                                                    SELECT
                                                        Id,
                                                        Code,
                                                        Name
                                                    FROM ProblemList
                                                    WHERE
                                                          (@firstnumber = -1 AND @maxresult = -1)
                                                       OR (RowNum BETWEEN @firstnumber AND @maxresult);
                                                    ";

        public const string GET_SELECTLIST_PROBLEM_PG = @"
                                                    WITH ProblemList AS (
                                                        SELECT
                                                            p.PROBLEMID   AS ""Id"",
                                                            p.PROBLEMCODE AS ""Code"",
                                                            p.PROBLEMNAME AS ""Name"",
                                                            ROW_NUMBER() OVER (ORDER BY p.PROBLEMID) AS ""RowNum""
                                                        FROM MPROBLEM p
                                                        WHERE 1 = 1
                                                          AND p.STATUS = 1
                                                    )
                                                    SELECT
                                                        ""Id"",
                                                        ""Code"",
                                                        ""Name""
                                                    FROM ProblemList
                                                    WHERE
                                                          (:firstnumber = -1 AND :maxresult = -1)
                                                       OR (""RowNum"" BETWEEN :firstnumber AND :maxresult);
                                                    ";

        public const string GET_SELECTLIST_PROBLEM_ORACLE = @";";

        public const string GET_SELECTLIST_PROBLEM_MYSQL = @";";
    }
}