LogikalFinish.cs 779 B

1234567891011121314151617181920212223242526272829303132
  1. using InABox.Logikal;
  2. using System;
  3. using System.Collections.Generic;
  4. namespace Comal.Classes
  5. {
  6. public class LogikalFinish : LogikalItem, ILogikalFinish
  7. {
  8. public String Code { get; set; }
  9. public String Description { get; set; }
  10. public override void ValidateQuery(string sql, List<string> errors)
  11. {
  12. ValidateField(sql, nameof(Code), errors);
  13. ValidateField(sql, nameof(Description), errors);
  14. }
  15. public static String SQL =
  16. "select \n" +
  17. $" c.[PowderID] as {nameof(Code)}, \n" +
  18. $" c.[ColorName] as {nameof(Description)} \n" +
  19. "from \n" +
  20. " colors c \n" +
  21. "where \n" +
  22. " c.[PowderID] is not null";
  23. }
  24. }