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

namespace FrameworkDAL.Query.EnumDetail
{
    public static class EnumDetailQB
    {
        public const string GET_SELECTLIST_ENUMDETAIL = @"SELECT
                                                A.ENUMID                       AS EnumarationId,
                                                A.ENUMNAME                     AS EnumarationName,
                                                B.ENUMDETAILID                 AS EnumarationDetailId,
                                                B.ENUMVALUE                    AS EnumarationDetailEnumValue,
                                                B.ENUMVALUEDESCRIPTION         AS EnumarationDetailEnumValueDescription
                                            FROM MENUM A
                                            JOIN MENUMDETAIL B ON B.ENUMID = A.ENUMID
                                            WHERE A.STATUS = 1
                                              AND (@enumid IS NULL OR A.ENUMID = @enumid)
                                            ORDER BY B.SLNO;";
    }
}