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

namespace MMDAL.Query.WareHouse
{
    public static class WareHouseQB
    {
        // GB4 parity: WareHouse.svc/SelectList — WareHouseBLL.GetSelectListWareHouse loaded Id,Code,Name
        // via the generic NHibernate criteria loader against MWAREHOUSE (WareHouse.hbm.xml).
        public const string GET_SELECTLIST_WAREHOUSE = @"
            SELECT
                W.WAREHOUSEID   AS Id,
                W.WAREHOUSECODE AS Code,
                W.WAREHOUSENAME AS Name
            FROM MWAREHOUSE W
            WHERE W.TENANTID IN (@TenantId, -1)
            {DYNAMIC_WHERE}
            ORDER BY W.WAREHOUSENAME ASC";
    }
}