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

namespace MMDAL.Query.SKU
{
    public static class SKUQB
    {
        public const string GET_SKU_SQL = @"
WITH PagedSKU AS (
    SELECT 
        sku.SKUID AS Id,
        sku.SKUCODE AS Code,
        sku.SKUNAME AS Name,
        sku.NETWEIGHT AS SKUNetWeight,
        ROW_NUMBER() OVER (ORDER BY sku.SKUID) AS RowNum
    FROM MSKU sku
)
SELECT 
    Id,
    Code,
    Name,
    SKUNetWeight
FROM PagedSKU
WHERE RowNum BETWEEN (@firstnumber + 1) AND (@firstnumber + @maxresult);
";
    }
}