prs/prs.desktop/Integrations/V6/Classes/V6Elevation.cs

using System.Collections.Generic;
using InABox.Core;

namespace PRSDesktop.Integrations.V6
{
    public class V6Elevation : V6Object
    {
        [IntegerEditor(Visible=Visible.Hidden)]
        [EditorSequence(1)]
        [RequiredColumn]
        public int ID { get; set; }
    
        [TextBoxEditor(Visible=Visible.Default)]
        [EditorSequence(2)]
        public string Description { get; set; }
    
        [IntegerEditor(Visible=Visible.Default)]
        [EditorSequence(3)]
        public int Quantity { get; set; }
        

        public override void ValidateQuery(string sql, List<string> errors)
        {
            ValidateField(sql, nameof(Description), errors);
            ValidateField(sql, nameof(Quantity), errors);
        }

        public static string SQL = $@"select  
    qi.quote_item_id as {nameof(ID)}, 
    qi.descr as {nameof(Description)}, 
    qi.quantity as {nameof(Quantity)}
from  
    Quote_item qi  
left outer join  
    quote q on qi.quote_id = q.quote_id and qi.quote_vers_start <= q.quote_vers and qi.quote_vers_stop >= q.quote_vers  
where  
    1=1";

    }
}