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

namespace MMDAL.Query.Scheme
{
    public static class SchemeQB
    {
        // GB4 parity: Scheme.svc/SelectList — SchemeBLL.GetSelectListScheme loaded Id,Code,Name
        // via the generic NHibernate criteria loader against MSCHEME (Scheme.hbm.xml).
        public const string GET_SELECTLIST_SCHEME = @"
            SELECT
                S.SCHEMEID   AS Id,
                S.SCHEMECODE AS Code,
                S.SCHEMENAME AS Name
            FROM MSCHEME S
            WHERE 1 = 1
            {DYNAMIC_WHERE}
            ORDER BY S.SCHEMENAME ASC";
    }
}