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

using System.Collections.Generic;
using InABox.Integration.V6;

namespace PRSDesktop.Integrations.V6
{
    public class V6Glass : V6BOMItem, IV6Glass
    {
        
        public string Treatment { get; set; }
        public double Height { get; set; }
        public double Width { get; set; }
        public string Location { get; set; }

        public override void ValidateQuery(string sql, List<string> errors)
        {
            base.ValidateQuery(sql, errors);
            ValidateField(sql, nameof(Treatment), errors);
            ValidateField(sql, nameof(Height), errors);
            ValidateField(sql, nameof(Width), errors);
            ValidateField(sql, nameof(Location), errors);
        }
        
        public static string SQL = $@"select 
    bf.location as {nameof(Location)}, 
    f.fill_code as {nameof(Code)}, 
    f.descr as {nameof(Description)}, 
    bf.fill_height as {nameof(Height)}, 
    bf.fill_width as {nameof(Width)}, 
    bf.fill_count as {nameof(Quantity)}, 
    bf.treatment as {nameof(Treatment)}, 
    bf.cost as {nameof(Cost)} 
from 
    bom_fill bf 
left outer join 
    fill f on bf.fill_lib_id = f.fill_lib_id and bf.fill_id = f.fill_id 
left outer join 
    quote_item qi on qi.quote_item_id = bf.quote_item_id 
left outer join 
    quote q on q.quote_id = qi.quote_id 
where 
    1=1";

        

    }
}