namespace CMSDAL.Query.PageTemplate;
public static class PageTemplateQB
{
    public const string GET_BY_SITETEMPLATE = @"
        SELECT
            pt.PAGETEMPLATEID    AS PageTemplateId,
            pt.SITETEMPLATEID    AS SiteTemplateId,
            pt.PAGETEMPLATECODE  AS PageTemplateCode,
            pt.PAGETEMPLATENAME  AS PageTemplateName,
            pt.URLPATHPATTERN    AS UrlPathPattern,
            pt.ISHOMEPAGE        AS IsHomePage,
            pt.CONTAINERTREEJSON AS ContainerTreeJson,
            pt.SORTORDER         AS SortOrder,
            pt.STATUS            AS Status,
            pt.TENANTID          AS TenantId
        FROM DBO.MCMSPAGETEMPLATE pt
        WHERE pt.SITETEMPLATEID = @SiteTemplateId AND pt.STATUS = 1
          AND (pt.TENANTID = @TenantId OR pt.TENANTID = -1)
        ORDER BY pt.SORTORDER";
}