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

namespace LogisticsDAL.Query.Manifest
{
    public static class ManifestQB
    {
        public const string GET_MANIFEST_SELECTLIST_SQL = @"
            WITH ManifestSelectList AS (
                SELECT
                    m.MANIFESTID        AS ManifestId,
                    m.MANIFESTNUMBER    AS ManifestNumber,
                    m.MANIFESTDATE      AS ManifestDate,
                    m.TRIPID            AS TripId,
                    t.TRIPNUMBER        AS TripNumber,
                    ROW_NUMBER() OVER (ORDER BY m.MANIFESTID DESC) AS RowNum
                FROM TMANIFEST m
                LEFT JOIN TTRIP t ON t.TRIPID = m.TRIPID
                WHERE 1=1
            )
            SELECT
                ManifestId,
                ManifestNumber,
                ManifestDate,
                TripId,
                TripNumber
            FROM ManifestSelectList
            WHERE
                  (@firstnumber = -1 AND @maxresult = -1)
               OR (RowNum BETWEEN @firstnumber AND @maxresult);
            ";

        public const string GET_MANIFEST_SELECTLIST_PG = @"
            WITH ""ManifestSelectList"" AS (
                SELECT
                    m.MANIFESTID        AS ""ManifestId"",
                    m.MANIFESTNUMBER    AS ""ManifestNumber"",
                    m.MANIFESTDATE      AS ""ManifestDate"",
                    m.TRIPID            AS ""TripId"",
                    t.TRIPNUMBER        AS ""TripNumber"",
                    ROW_NUMBER() OVER (ORDER BY m.MANIFESTID DESC) AS ""RowNum""
                FROM TMANIFEST m
                LEFT JOIN TTRIP t ON t.TRIPID = m.TRIPID
                WHERE 1=1
            )
            SELECT
                ""ManifestId"",
                ""ManifestNumber"",
                ""ManifestDate"",
                ""TripId"",
                ""TripNumber""
            FROM ""ManifestSelectList""
            WHERE
                  (:firstnumber = -1 AND :maxresult = -1)
               OR (""RowNum"" BETWEEN :firstnumber AND :maxresult);
            ";

        public const string GET_MANIFEST_SELECTLIST_ORACLE = @";";
        public const string GET_MANIFEST_SELECTLIST_MYSQL = @";";
    }
}