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

namespace MMDAL.Query.Target
{
    public static class TargetQB
    {
        // GB4 parity: Target.svc/SelectList — TargetBLL.GetSelectListTarget loaded Id,Code,Name
        // via the generic NHibernate criteria loader against MTARGET (Target.hbm.xml).
        public const string GET_SELECTLIST_TARGET = @"
            SELECT
                T.TARGETID   AS Id,
                T.TARGETCODE AS Code,
                T.TARGETNAME AS Name
            FROM MTARGET T
            WHERE T.TENANTID IN (@TenantId, -1)
            {DYNAMIC_WHERE}
            ORDER BY T.TARGETNAME ASC";
    }
}