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; }
|
}
|
