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

namespace MMDAL.Query.ItemDetail
{
    public static class ItemDetailQB
    {
        public const string GET_ITEMDETAIL = @"SELECT
    ITEMDETAILID       AS ItemDetailId,
    ITEMID             AS ItemId,
    SLNO               AS ItemDetailSlNo,
    UOMID              AS UOMId,
    PARAMETERID        AS ParameterId,
    INPUTVALUE         AS InputValue,
    INPUTTEXT          AS InputText,
    INPUTDATE          AS InputDate,
    INPUTID            AS InputId,
    FINALVALUE         AS FinalValue,
    MINIMUM            AS Minimum,
    MAXIMUM            AS Maximum,
    TOLLERANCEPLUSPERCENT  AS TollerancePlusPercent,
    TOLLERANCEMINUSPERCENT AS TolleranceMinusPercent,
    STANDARDTEXT       AS StandardText,
    TYPE               AS Type,
    SKUID              AS SKUId
FROM MITEMDETAIL
WHERE ITEMDETAILID = @ItemDetailId;
;";
        public const string DELETE_ITEMDETAIL = @"DELETE FROM MITEMDETAIL
WHERE ITEMDETAILID = @ItemDetailId;
;";
    }
}