using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;
using SqlSugar;

namespace MES.Service.Modes;

/// <summary>
///     产品信息表
/// </summary>
[Table("MES_BOARD_BASE_INFO")]
[SugarTable("MES_BOARD_BASE_INFO")] //用于SqlSugar
public class MesBoardBaseInfo
{
    /// <summary>
    ///     ID
    /// </summary>
    [Key]
    [Column("ID")]
    [SugarColumn(ColumnName = "ID")] //用于SqlSugar
    public decimal Id { get; set; }

    /// <summary>
    ///     条码类型ID
    /// </summary>
    [Column("BARCODE_TYPE_ID")]
    [SugarColumn(ColumnName = "BARCODE_TYPE_ID")] //用于SqlSugar
    public decimal? BarcodeTypeId { get; set; }

    /// <summary>
    ///     产品编码
    /// </summary>
    [Column("BOARD_ITEM")]
    [SugarColumn(ColumnName = "BOARD_ITEM")] //用于SqlSugar
    [StringLength(64, ErrorMessage = "产品编码长度不能超出64")]
    public string BoardItem { get; set; }

    /// <summary>
    ///     产品生产线体
    /// </summary>
    [Column("BOARD_LINENO")]
    [SugarColumn(ColumnName = "BOARD_LINENO")] //用于SqlSugar
    [StringLength(50, ErrorMessage = "产品生产线体长度不能超出50")]
    public string BoardLineno { get; set; }

    /// <summary>
    ///     产品规格
    /// </summary>
    [Column("BOARD_MODEL")]
    [SugarColumn(ColumnName = "BOARD_MODEL")] //用于SqlSugar
    [StringLength(500, ErrorMessage = "产品规格长度不能超出500")]
    public string BoardModel { get; set; }

    /// <summary>
    ///     产品名称(原单板名称)
    /// </summary>
    [Column("BOARD_NAME")]
    [SugarColumn(ColumnName = "BOARD_NAME")] //用于SqlSugar
    [StringLength(500, ErrorMessage = "产品名称(原单板名称)长度不能超出500")]
    public string BoardName { get; set; }

    /// <summary>
    ///     产品机型
    /// </summary>
    [Column("BOARD_STYLE")]
    [SugarColumn(ColumnName = "BOARD_STYLE")] //用于SqlSugar
    [StringLength(500, ErrorMessage = "产品机型长度不能超出500")]
    public string BoardStyle { get; set; }

    /// <summary>
    ///     适配计件型号
    /// </summary>
    [Column("BOARD_STYLE_J")]
    [SugarColumn(ColumnName = "BOARD_STYLE_J")] //用于SqlSugar
    [StringLength(50, ErrorMessage = "适配计件型号长度不能超出50")]
    public string BoardStyleJ { get; set; }

    /// <summary>
    ///     单位
    /// </summary>
    [Column("BOARD_UNIT")]
    [SugarColumn(ColumnName = "BOARD_UNIT")] //用于SqlSugar
    [StringLength(10, ErrorMessage = "单位长度不能超出10")]
    public string BoardUnit { get; set; }

    /// <summary>
    ///     是否BOM扁平化
    /// </summary>
    [Column("BOM_FLAT_FLAG")]
    [SugarColumn(ColumnName = "BOM_FLAT_FLAG")] //用于SqlSugar
    public decimal? BomFlatFlag { get; set; }

    /// <summary>
    ///     颜色
    /// </summary>
    [Column("COLOR_NAME")]
    [SugarColumn(ColumnName = "COLOR_NAME")] //用于SqlSugar
    [StringLength(500, ErrorMessage = "颜色长度不能超出500")]
    public string ColorName { get; set; }

    /// <summary>
    /// </summary>
    [Column("COMPANY")]
    [SugarColumn(ColumnName = "COMPANY")] //用于SqlSugar
    [StringLength(20, ErrorMessage = "Company长度不能超出20")]
    public string Company { get; set; }

    /// <summary>
    ///     记录创建人
    /// </summary>
    [Column("CREATE_BY")]
    [SugarColumn(ColumnName = "CREATE_BY")] //用于SqlSugar
    [StringLength(30, ErrorMessage = "记录创建人长度不能超出30")]
    public string CreateBy { get; set; }

    /// <summary>
    ///     创建时间
    /// </summary>
    [Column("CREATE_DATE")]
    [SugarColumn(ColumnName = "CREATE_DATE")] //用于SqlSugar
    public DateTime? CreateDate { get; set; }

    /// <summary>
    ///     默认仓库
    /// </summary>
    [Column("DEPOT_CODE")]
    [SugarColumn(ColumnName = "DEPOT_CODE")] //用于SqlSugar
    [StringLength(50, ErrorMessage = "默认仓库长度不能超出50")]
    public string DepotCode { get; set; }

    /// <summary>
    ///     默认库位
    /// </summary>
    [Column("DEPOT_SECTION_CODE")]
    [SugarColumn(ColumnName = "DEPOT_SECTION_CODE")] //用于SqlSugar
    [StringLength(50, ErrorMessage = "默认库位长度不能超出50")]
    public string DepotSectionCode { get; set; }

    /// <summary>
    ///     备注
    /// </summary>
    [Column("DESCRIPTION")]
    [SugarColumn(ColumnName = "DESCRIPTION")] //用于SqlSugar
    [StringLength(255, ErrorMessage = "备注长度不能超出255")]
    public string Description { get; set; }

    /// <summary>
    ///     元件数
    /// </summary>
    [Column("ELEMENT_QTY")]
    [SugarColumn(ColumnName = "ELEMENT_QTY")] //用于SqlSugar
    public decimal? ElementQty { get; set; }

    /// <summary>
    ///     ERP料号
    /// </summary>
    [Column("ERP_ITEM_NO")]
    [SugarColumn(ColumnName = "ERP_ITEM_NO")] //用于SqlSugar
    [StringLength(50, ErrorMessage = "ERP料号长度不能超出50")]
    public string ErpItemNo { get; set; }

    /// <summary>
    ///     工厂
    /// </summary>
    [Column("FACTORY")]
    [SugarColumn(ColumnName = "FACTORY")] //用于SqlSugar
    [StringLength(10, ErrorMessage = "工厂长度不能超出10")]
    public string Factory { get; set; }

    /// <summary>
    ///     审核人
    /// </summary>
    [Column("FCHECKED_BY1")]
    [SugarColumn(ColumnName = "FCHECKED_BY1")] //用于SqlSugar
    [StringLength(20, ErrorMessage = "审核人长度不能超出20")]
    public string FcheckedBy1 { get; set; }

    /// <summary>
    ///     审核人
    /// </summary>
    [Column("FCHECKED_BY2")]
    [SugarColumn(ColumnName = "FCHECKED_BY2")] //用于SqlSugar
    [StringLength(20, ErrorMessage = "审核人长度不能超出20")]
    public string FcheckedBy2 { get; set; }

    /// <summary>
    ///     审核日期
    /// </summary>
    [Column("FCHECKED_DATE1")]
    [SugarColumn(ColumnName = "FCHECKED_DATE1")] //用于SqlSugar
    public DateTime? FcheckedDate1 { get; set; }

    /// <summary>
    ///     审核日期
    /// </summary>
    [Column("FCHECKED_DATE2")]
    [SugarColumn(ColumnName = "FCHECKED_DATE2")] //用于SqlSugar
    public DateTime? FcheckedDate2 { get; set; }

    /// <summary>
    ///     审批标识
    /// </summary>
    [Column("FCHECK_FLAG1")]
    [SugarColumn(ColumnName = "FCHECK_FLAG1")] //用于SqlSugar
    public decimal? FcheckFlag1 { get; set; }

    /// <summary>
    ///     审批标识
    /// </summary>
    [Column("FCHECK_FLAG2")]
    [SugarColumn(ColumnName = "FCHECK_FLAG2")] //用于SqlSugar
    public decimal? FcheckFlag2 { get; set; }

    /// <summary>
    ///     审批状态
    /// </summary>
    [Column("FCHECK_TYP")]
    [SugarColumn(ColumnName = "FCHECK_TYP")] //用于SqlSugar
    [StringLength(200, ErrorMessage = "审批状态长度不能超出200")]
    public string FcheckTyp { get; set; }

    /// <summary>
    ///     颜色标识(1：工序BOM维护错误)
    /// </summary>
    [Column("FCOLOR")]
    [SugarColumn(ColumnName = "FCOLOR")] //用于SqlSugar
    public decimal? Fcolor { get; set; }

    /// <summary>
    ///     MRPII首工序序号
    /// </summary>
    [Column("FIRST_SEQ")]
    [SugarColumn(ColumnName = "FIRST_SEQ")] //用于SqlSugar
    public decimal? FirstSeq { get; set; }

    /// <summary>
    ///     最近更新人
    /// </summary>
    [Column("LASTUPDATE_BY")]
    [SugarColumn(ColumnName = "LASTUPDATE_BY")] //用于SqlSugar
    [StringLength(30, ErrorMessage = "最近更新人长度不能超出30")]
    public string LastupdateBy { get; set; }

    /// <summary>
    ///     最近更新时间
    /// </summary>
    [Column("LASTUPDATE_DATE")]
    [SugarColumn(ColumnName = "LASTUPDATE_DATE")] //用于SqlSugar
    public DateTime? LastupdateDate { get; set; }

    /// <summary>
    ///     是否纳入MES管理
    /// </summary>
    [Column("MES_FLAG")]
    [SugarColumn(ColumnName = "MES_FLAG")] //用于SqlSugar
    public decimal? MesFlag { get; set; }

    /// <summary>
    ///     是否MRPII单板
    /// </summary>
    [Column("MRP_ITEM")]
    [SugarColumn(ColumnName = "MRP_ITEM")] //用于SqlSugar
    public decimal? MrpItem { get; set; }

    /// <summary>
    ///     负极配方用量
    /// </summary>
    [Column("NEG_QTY")]
    [SugarColumn(ColumnName = "NEG_QTY")] //用于SqlSugar
    public decimal? NegQty { get; set; }

    /// <summary>
    ///     行业标准描述
    /// </summary>
    [Column("NORMT")]
    [SugarColumn(ColumnName = "NORMT")] //用于SqlSugar
    [StringLength(100, ErrorMessage = "行业标准描述长度不能超出100")]
    public string Normt { get; set; }

    /// <summary>
    ///     组织
    /// </summary>
    [Column("ORG")]
    [SugarColumn(ColumnName = "ORG")] //用于SqlSugar
    [StringLength(10, ErrorMessage = "组织长度不能超出10")]
    public string Org { get; set; }

    /// <summary>
    ///     每箱数量
    /// </summary>
    [Column("PACK_BOX_QTY")]
    [SugarColumn(ColumnName = "PACK_BOX_QTY")] //用于SqlSugar
    public decimal? PackBoxQty { get; set; }

    /// <summary>
    ///     每卡板箱数
    /// </summary>
    [Column("PACK_CB_QTY")]
    [SugarColumn(ColumnName = "PACK_CB_QTY")] //用于SqlSugar
    public decimal? PackCbQty { get; set; }

    /// <summary>
    ///     包装注意事项
    /// </summary>
    [Column("PACK_SHIP_MEMO")]
    [SugarColumn(ColumnName = "PACK_SHIP_MEMO")] //用于SqlSugar
    [StringLength(255, ErrorMessage = "包装注意事项长度不能超出255")]
    public string PackShipMemo { get; set; }

    /// <summary>
    ///     出货包装方式
    /// </summary>
    [Column("PACK_SHIP_NO")]
    [SugarColumn(ColumnName = "PACK_SHIP_NO")] //用于SqlSugar
    [StringLength(10, ErrorMessage = "出货包装方式长度不能超出10")]
    public string PackShipNo { get; set; }

    /// <summary>
    ///     每箱产品数量
    /// </summary>
    [Column("PACK_SHIP_QTY")]
    [SugarColumn(ColumnName = "PACK_SHIP_QTY")] //用于SqlSugar
    public decimal? PackShipQty { get; set; }

    /// <summary>
    ///     配方
    /// </summary>
    [Column("PEIFANG")]
    [SugarColumn(ColumnName = "PEIFANG")] //用于SqlSugar
    [StringLength(20, ErrorMessage = "配方长度不能超出20")]
    public string Peifang { get; set; }

    /// <summary>
    ///     产品图片路径
    /// </summary>
    [Column("PIC_PATH")]
    [SugarColumn(ColumnName = "PIC_PATH")] //用于SqlSugar
    [StringLength(255, ErrorMessage = "产品图片路径长度不能超出255")]
    public string PicPath { get; set; }

    /// <summary>
    ///     正极配方用量
    /// </summary>
    [Column("POS_QTY")]
    [SugarColumn(ColumnName = "POS_QTY")] //用于SqlSugar
    public decimal? PosQty { get; set; }

    /// <summary>
    ///     成品2，半成品1
    /// </summary>
    [Column("PRD_FLAG")]
    [SugarColumn(ColumnName = "PRD_FLAG")] //用于SqlSugar
    public decimal? PrdFlag { get; set; }

    /// <summary>
    ///     工艺属性(数值只能是1,2,3)
    /// </summary>
    [Column("PROC_CAPTION")]
    [SugarColumn(ColumnName = "PROC_CAPTION")] //用于SqlSugar
    [StringLength(20, ErrorMessage = "工艺属性(数值只能是1,2,3)长度不能超出20")]
    public string ProcCaption { get; set; }

    /// <summary>
    ///     产品类别
    /// </summary>
    [Column("PRODUCT_TYPE")]
    [SugarColumn(ColumnName = "PRODUCT_TYPE")] //用于SqlSugar
    [StringLength(20, ErrorMessage = "产品类别长度不能超出20")]
    public string ProductType { get; set; }

    /// <summary>
    ///     SAP物料小类
    /// </summary>
    [Column("PROPERTY_NO")]
    [SugarColumn(ColumnName = "PROPERTY_NO")] //用于SqlSugar
    [StringLength(50, ErrorMessage = "SAP物料小类长度不能超出50")]
    public string PropertyNo { get; set; }

    /// <summary>
    ///     工艺类别编号
    /// </summary>
    [Column("PTYPE_NO")]
    [SugarColumn(ColumnName = "PTYPE_NO")] //用于SqlSugar
    [StringLength(10, ErrorMessage = "工艺类别编号长度不能超出10")]
    public string PtypeNo { get; set; }

    /// <summary>
    ///     检验模式(全检\抽检)
    /// </summary>
    [Column("QC_MODE")]
    [SugarColumn(ColumnName = "QC_MODE")] //用于SqlSugar
    [StringLength(20, ErrorMessage = "检验模式(全检/抽检)长度不能超出20")]
    public string QcMode { get; set; }

    /// <summary>
    ///     默认收货地址(客户地址)
    /// </summary>
    [Column("SHIP_TO")]
    [SugarColumn(ColumnName = "SHIP_TO")] //用于SqlSugar
    [StringLength(200, ErrorMessage = "默认收货地址(客户地址)长度不能超出200")]
    public string ShipTo { get; set; }

    /// <summary>
    ///     贴放数
    /// </summary>
    [Column("SMT_QTY")]
    [SugarColumn(ColumnName = "SMT_QTY")] //用于SqlSugar
    public decimal? SmtQty { get; set; }

    /// <summary>
    ///     软件版本
    /// </summary>
    [Column("SOFTVERSION")]
    [SugarColumn(ColumnName = "SOFTVERSION")] //用于SqlSugar
    [StringLength(20, ErrorMessage = "软件版本长度不能超出20")]
    public string Softversion { get; set; }

    /// <summary>
    ///     停用日期
    /// </summary>
    [Column("STOPDATE")]
    [SugarColumn(ColumnName = "STOPDATE")] //用于SqlSugar
    public DateTime? Stopdate { get; set; }

    /// <summary>
    ///     入库方式
    /// </summary>
    [Column("STORE_MODE")]
    [SugarColumn(ColumnName = "STORE_MODE")] //用于SqlSugar
    [StringLength(20, ErrorMessage = "入库方式长度不能超出20")]
    public string StoreMode { get; set; }

    /// <summary>
    /// </summary>
    [Column("STYLE_TMP1")]
    [SugarColumn(ColumnName = "STYLE_TMP1")] //用于SqlSugar
    [StringLength(500, ErrorMessage = "StyleTmp1长度不能超出500")]
    public string StyleTmp1 { get; set; }

    /// <summary>
    /// </summary>
    [Column("STYLE_TMP2")]
    [SugarColumn(ColumnName = "STYLE_TMP2")] //用于SqlSugar
    [StringLength(50, ErrorMessage = "StyleTmp2长度不能超出50")]
    public string StyleTmp2 { get; set; }

    /// <summary>
    ///     焊点数
    /// </summary>
    [Column("THT_QTY")]
    [SugarColumn(ColumnName = "THT_QTY")] //用于SqlSugar
    public decimal? ThtQty { get; set; }

    /// <summary>
    ///     最新下载更新标识
    /// </summary>
    [Column("UPDATE_FLG")]
    [SugarColumn(ColumnName = "UPDATE_FLG")] //用于SqlSugar
    public decimal? UpdateFlg { get; set; }

    /// <summary>
    ///     单板版本
    /// </summary>
    [Column("VERSION")]
    [SugarColumn(ColumnName = "VERSION")] //用于SqlSugar
    [StringLength(20, ErrorMessage = "单板版本长度不能超出20")]
    public string Version { get; set; }
}