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

namespace LogisticsDAL.Query.Driver
{
    public static class DriverQB
    {
        public const string GET_DRIVER_SELECTLIST_SQL = @"
            WITH DriverSelectList AS (
                SELECT
                    d.DRIVERID      AS Id,
                    d.DRIVERCODE    AS DriverCode,
                    d.DRIVERNAME    AS DriverName,
                    d.DRIVERMOBILE  AS DriverMobile,
                    ROW_NUMBER() OVER (ORDER BY d.DRIVERID) AS RowNum
                FROM MDRIVER d
                WHERE 1=1
            )
            SELECT
                Id,
                DriverCode,
                DriverName,
                DriverMobile
            FROM DriverSelectList
            WHERE
                  (@firstnumber = -1 AND @maxresult = -1)
               OR (RowNum BETWEEN @firstnumber AND @maxresult);
            ";

        public const string GET_DRIVER_SELECTLIST_PG = @"
            WITH ""DriverSelectList"" AS (
                SELECT
                    d.DRIVERID      AS ""Id"",
                    d.DRIVERCODE    AS ""DriverCode"",
                    d.DRIVERNAME    AS ""DriverName"",
                    d.DRIVERMOBILE  AS ""DriverMobile"",
                    ROW_NUMBER() OVER (ORDER BY d.DRIVERID) AS ""RowNum""
                FROM MDRIVER d
                WHERE 1=1
            )
            SELECT
                ""Id"",
                ""DriverCode"",
                ""DriverName"",
                ""DriverMobile""
            FROM ""DriverSelectList""
            WHERE
                  (:firstnumber = -1 AND :maxresult = -1)
               OR (""RowNum"" BETWEEN :firstnumber AND :maxresult);
            ";

        public const string GET_DRIVER_SELECTLIST_ORACLE = @";";
        public const string GET_DRIVER_SELECTLIST_MYSQL = @";";
    }
}