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

namespace MMDAL.Query.WorkCenter
{
    public static class WorkCenterQB
    {
        public const string GET_WORKCENTER = "";
        public const string UPDATE_WORKCENTER = "";
        public const string SAVE_WORKCENTER = "";
        public const string DELETE_WORKCENTER = "DELETE";
        public const string GET_WORKCENTER_LIST = "GET";    

        public const string GET_SELECTLIST_WORKCENTER = @"
WITH WorkCenter AS
(
    SELECT
        wc.WORKCENTERID        AS Id,
        wc.WORKCENTERCODE      AS Code,
        wc.WORKCENTERNAME      AS Name,

        ROW_NUMBER() OVER (ORDER BY wc.WORKCENTERNAME) AS RowNum

    FROM dbo.MWORKCENTER wc
)

SELECT *
FROM WorkCenter
WHERE
    (@firstnumber = -1 AND @maxresult = -1)
    OR (RowNum BETWEEN @firstnumber AND @maxresult);";

    }
}