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

namespace MMDAL.Query.InspectionParameter
{
    public static class InspectionParameterQB
    {
        public const string GET_INSPECTIONPARAMETER_LIST = "";
        public const string DELETE_INSPECTIONPARAMETER = "DELETE";
        public const string UPDATE_INSPECTIONPARAMETER = "";
        public const string GET_INSPECTIONPARAMETER = GET_INSPECTIONPARAMETER_LIST;
        public const string SAVE_INSPECTIONPARAMETER = "";
        public const string GET_SELECTLIST_INSPECTIONPARAMETER = @"
WITH InspectionParameter AS
(
    SELECT
        ip.INSPECTIONPARAMETERID        AS InspectionParameterId,

        ip.INSPECTIONDETAILID           AS InspectionDetailId,

        ip.SLNO                         AS InspectionParameterSlNo,
        ip.SAMPLENUMBER                 AS InspectionParameterSampleNumber,
        ip.PARAMETERSLNO                AS InspectionParameterParameterSlNo,

        ip.PARAMETERID                  AS ParameterId,
        p.PARAMETERCODE                 AS ParameterCode,
        p.PARAMETERNAME                 AS ParameterName,

        ip.UOMID                        AS UomId,
        u.UOMCODE                       AS UomCode,
        u.UOMNAME                       AS UomName,

        ip.INPUTVALUE                   AS InspectionParameterInputValue,
        ip.INPUTTEXT                    AS InspectionParameterInputText,
        ip.INPUTDATE                    AS InspectionParameterInputDate,

        ip.FINALVALUE                   AS InspectionParameterFinalValue,

        p.MINVAL                        AS MinVal,
        p.MAXVAL                        AS MaxVal,

        ROW_NUMBER() OVER (ORDER BY ip.INSPECTIONPARAMETERID) AS RowNum

    FROM dbo.MINSPECTIONPARAMETER ip

    LEFT JOIN dbo.MPARAMETER p
           ON ip.PARAMETERID = p.PARAMETERID

    LEFT JOIN dbo.MUOM u
           ON ip.UOMID = u.UOMID
)

SELECT *
FROM InspectionParameter
WHERE
    (@firstnumber = -1 AND @maxresult = -1)
    OR (RowNum BETWEEN @firstnumber AND @maxresult);";
    }
}