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

namespace FrameworkDAL.Query.ParameterMap
{
    public static class ParameterMapQB
    {
        public const string GET_PARAMETERMAP = @" 
        SELECT 
        PM.PARAMETERMAPID AS ParameterMapId,
        PM.PARAMETERMAPCODE AS ParameterMapCode,
        PM.PARAMETERMAPNAME AS ParameterMapName,
        PM.PARAMETERMAPTYPE AS ParameterMapType,
        PM.STARTTIMEPARAMETERID AS ParameterMapStartTimeParameterId,
        PM.ENDTIMEPARAMETERID AS ParameterMapEndTimeParameterId,
        PM.STARTFUELPARAMETERID AS ParameterMapStartFuelParameterId,
        PM.ENDFUELPARAMETERID AS ParameterMapEndFuelParameterId,
        PM.STARTUNITPARAMETERID AS ParameterMapStartUnitParameterId,
        PM.ENDUNITPARAMETERID AS ParameterMapEndUnitParameterId,
        PM.SORTORDER AS ParameterMapSortOrder,
        PM.STATUS AS ParameterMapStatus,
        PM.VERSION AS ParameterMapVersion,
        PM.SOURCETYPE AS ParameterMapSourceType,
        PM.CREATEDBYID AS ParameterMapCreatedById,
        PM.CREATEDON AS ParameterMapCreatedOn,
        PM.MODIFIEDBYID AS ParameterMapModifiedById,
        PM.MODIFIEDON AS ParameterMapModifiedOn

        FROM
        MPARAMETERMAP PM
        WHERE
        PM.PARAMETERMAPID = @ParameterMapId
        ";
    }
}