namespace MMDAL.Query.ECR
{
    public static class ECRQB
    {
        public const string GET_SELECTLIST_ECR_SQL = @"
                                                    WITH Paged AS (
                                                        SELECT
                                                            e.ECRID     AS Id,
                                                            e.ECRNUMBER AS EcrNumber,
                                                            e.ECRDATE   AS EcrDate,
                                                            e.ECRSTATUS AS EcrStatus,
                                                            ROW_NUMBER() OVER (ORDER BY e.ECRID DESC) AS RowNum
                                                        FROM TECR e
                                                        WHERE 1 = 1
                                                    )
                                                    SELECT
                                                        Id,
                                                        EcrNumber,
                                                        EcrDate,
                                                        EcrStatus
                                                    FROM Paged
                                                    WHERE
                                                          (@firstnumber = -1 AND @maxresult = -1)
                                                       OR (RowNum BETWEEN @firstnumber AND @maxresult);
                                                    ";

        public const string GET_SELECTLIST_ECR_PG = @"
                                                    WITH Paged AS (
                                                        SELECT
                                                            e.ECRID     AS ""Id"",
                                                            e.ECRNUMBER AS ""EcrNumber"",
                                                            e.ECRDATE   AS ""EcrDate"",
                                                            e.ECRSTATUS AS ""EcrStatus"",
                                                            ROW_NUMBER() OVER (ORDER BY e.ECRID DESC) AS ""RowNum""
                                                        FROM TECR e
                                                        WHERE 1 = 1
                                                    )
                                                    SELECT
                                                        ""Id"",
                                                        ""EcrNumber"",
                                                        ""EcrDate"",
                                                        ""EcrStatus""
                                                    FROM Paged
                                                    WHERE
                                                          (:firstnumber = -1 AND :maxresult = -1)
                                                       OR (""RowNum"" BETWEEN :firstnumber AND :maxresult);
                                                    ";

        public const string GET_SELECTLIST_ECR_ORACLE = @";";
        public const string GET_SELECTLIST_ECR_MYSQL = @";";
    }
}