prs/prs.desktop/Integrations/Logikal/Classes/LogikalGasket.cs

using InABox.Integration.Logikal;

namespace PRSDesktop.Integrations.Logikal;

public class LogikalGasket : LogikalBOMItem, ILogikalGasket
{
    public double Length { get; set; }
    
    public static string BillOfMaterialsSQL =
        "select \n" +
        $"  a.[ArticleCode_BaseNumber] as {nameof(Code)}, \n" +
        $"  a.[description] as {nameof(Description)}, \n" +
        $"  1.0 as {nameof(Length)}, \n" +
        $"  a.[units] as {nameof(Quantity)}, \n" +
        $"  a.[Price] as {nameof(Cost)} \n" +
        "from \n" +
        "  allarticles a \n" +
        "where \n" +
        "  a.[ArticleType] = 5 \n";
        
    public static string DesignSQL =
        "select \n" +
        $"  a.[ArticleCode_BaseNumber] as {nameof(Code)}, \n" +
        $"  a.[description] as {nameof(Description)}, \n" +
        $"  1.0 as {nameof(Length)}, \n" +
        $"  a.[units] as {nameof(Quantity)}, \n" +
        $"  a.[Price] as {nameof(Cost)} \n" +
        "from \n" +
        "  articles a \n" +
        "where \n" +
        "  a.[ArticleType] = 5 \n";
}