using System.ComponentModel.DataAnnotations; using System.ComponentModel.DataAnnotations.Schema; using SqlSugar; namespace MES.Service.Modes; /// /// 工单表 /// [Table("WOMCAA")] [SugarTable("WOMCAA")] //用于SqlSugar public class Womcaa { /// /// 单号 /// [Column("CAA001")] [SugarColumn(ColumnName = "CAA001")] //用于SqlSugar [StringLength(50, ErrorMessage = "单号长度不能超出50")] public string? Caa001 { get; set; } /// /// ERP工单批次 /// [Column("CAA002")] [SugarColumn(ColumnName = "CAA002")] //用于SqlSugar [StringLength(50, ErrorMessage = "ERP工单批次长度不能超出50")] public string? Caa002 { get; set; } /// /// 客户编号 /// [Column("CAA003")] [SugarColumn(ColumnName = "CAA003")] //用于SqlSugar [StringLength(50, ErrorMessage = "客户编号长度不能超出50")] public string? Caa003 { get; set; } /// /// 单据类型 /// [Column("CAA004")] [SugarColumn(ColumnName = "CAA004")] //用于SqlSugar [StringLength(50, ErrorMessage = "单据类型长度不能超出50")] public string? Caa004 { get; set; } /// /// 开单日期 /// [Column("CAA005")] [SugarColumn(ColumnName = "CAA005")] //用于SqlSugar [StringLength(50, ErrorMessage = "开单日期长度不能超出50")] public string? Caa005 { get; set; } /// /// 产品编码 /// [Column("CAA006")] [SugarColumn(ColumnName = "CAA006")] //用于SqlSugar [StringLength(50, ErrorMessage = "产品编码长度不能超出50")] public string? Caa006 { get; set; } /// /// 产品名称 /// [Column("CAA007")] [SugarColumn(ColumnName = "CAA007")] //用于SqlSugar [StringLength(100, ErrorMessage = "产品名称长度不能超出100")] public string? Caa007 { get; set; } /// /// 产品规格 /// [Column("CAA008")] [SugarColumn(ColumnName = "CAA008")] //用于SqlSugar [StringLength(200, ErrorMessage = "产品规格长度不能超出200")] public string? Caa008 { get; set; } /// /// 单位 /// [Column("CAA009")] [SugarColumn(ColumnName = "CAA009")] //用于SqlSugar [StringLength(50, ErrorMessage = "单位长度不能超出50")] public string? Caa009 { get; set; } /// /// 预计开工时间 /// [Column("CAA010")] [SugarColumn(ColumnName = "CAA010")] //用于SqlSugar [StringLength(50, ErrorMessage = "预计开工时间长度不能超出50")] public string? Caa010 { get; set; } /// /// 预计完工时间 /// [Column("CAA011")] [SugarColumn(ColumnName = "CAA011")] //用于SqlSugar [StringLength(50, ErrorMessage = "预计完工时间长度不能超出50")] public string? Caa011 { get; set; } /// /// 数量 /// [Column("CAA012")] [SugarColumn(ColumnName = "CAA012")] //用于SqlSugar public decimal? Caa012 { get; set; } /// /// BOM版次 /// [Column("CAA013")] [SugarColumn(ColumnName = "CAA013")] //用于SqlSugar [StringLength(50, ErrorMessage = "BOM版次长度不能超出50")] public string? Caa013 { get; set; } /// /// 客户订单号 /// [Column("CAA014")] [SugarColumn(ColumnName = "CAA014")] //用于SqlSugar [StringLength(50, ErrorMessage = "客户订单号长度不能超出50")] public string? Caa014 { get; set; } /// /// 销售订单号 /// [Column("CAA015")] [SugarColumn(ColumnName = "CAA015")] //用于SqlSugar [StringLength(50, ErrorMessage = "销售订单号长度不能超出50")] public string? Caa015 { get; set; } /// /// 备注 /// [Column("CAA016")] [SugarColumn(ColumnName = "CAA016")] //用于SqlSugar [StringLength(200, ErrorMessage = "备注长度不能超出200")] public string? Caa016 { get; set; } /// /// 已排数量 /// [Column("CAA017")] [SugarColumn(ColumnName = "CAA017")] //用于SqlSugar public decimal? Caa017 { get; set; } /// /// ERP源单ID /// [Column("CAA018")] [SugarColumn(ColumnName = "CAA018")] //用于SqlSugar public decimal? Caa018 { get; set; } /// /// ERP源单行号 /// [Column("CAA019")] [SugarColumn(ColumnName = "CAA019")] //用于SqlSugar public decimal? Caa019 { get; set; } /// /// ERP源单单号(任务单号) /// [Column("CAA020")] [SugarColumn(ColumnName = "CAA020")] //用于SqlSugar [StringLength(50, ErrorMessage = "ERP源单单号(任务单号)长度不能超出50")] public string? Caa020 { get; set; } /// /// 工作车间 /// [Column("CAA021")] [SugarColumn(ColumnName = "CAA021")] //用于SqlSugar [StringLength(50, ErrorMessage = "工作车间长度不能超出50")] public string? Caa021 { get; set; } /// /// 未排数量 /// [Column("CAA022")] [SugarColumn(ColumnName = "CAA022")] //用于SqlSugar public decimal? Caa022 { get; set; } /// /// 状态 完工,未完工 /// [Column("CAA023")] [SugarColumn(ColumnName = "CAA023")] //用于SqlSugar [StringLength(20, ErrorMessage = "状态 完工,未完工长度不能超出20")] public string? Caa023 { get; set; } /// /// 已入库数量 /// [Column("CAA024")] [SugarColumn(ColumnName = "CAA024")] //用于SqlSugar public decimal? Caa024 { get; set; } /// /// 结案标识 /// [Column("CAA025")] [SugarColumn(ColumnName = "CAA025")] //用于SqlSugar public decimal? Caa025 { get; set; } /// /// 失败原因 /// [Column("CAA026")] [SugarColumn(ColumnName = "CAA026")] //用于SqlSugar [StringLength(50, ErrorMessage = "失败原因长度不能超出50")] public string? Caa026 { get; set; } /// /// 结案时间 /// [Column("CAA027")] [SugarColumn(ColumnName = "CAA027")] //用于SqlSugar public DateTime? Caa027 { get; set; } /// /// 供应商编码 /// [Column("CAA028")] [SugarColumn(ColumnName = "CAA028")] //用于SqlSugar [StringLength(50, ErrorMessage = "供应商编码长度不能超出50")] public string? Caa028 { get; set; } /// /// 审核日期 /// [Column("CHECK_DATE")] [SugarColumn(ColumnName = "CHECK_DATE")] //用于SqlSugar public DateTime? CheckDate { get; set; } /// /// 审核人 /// [Column("CHECK_USER")] [SugarColumn(ColumnName = "CHECK_USER")] //用于SqlSugar [StringLength(20, ErrorMessage = "审核人长度不能超出20")] public string? CheckUser { get; set; } /// /// ERPID /// [Column("ERPID")] [SugarColumn(ColumnName = "ERPID")] //用于SqlSugar public decimal? Erpid { get; set; } /// /// 审核码 /// [Column("FSTATUS")] [SugarColumn(ColumnName = "FSTATUS")] //用于SqlSugar public decimal? Fstatus { get; set; } /// /// 自增列 /// [Column("ID")] [SugarColumn(ColumnName = "ID")] //用于SqlSugar public decimal? Id { get; set; } /// /// 更新日期 /// [Column("LASTTIME")] [SugarColumn(ColumnName = "LASTTIME")] //用于SqlSugar [StringLength(50, ErrorMessage = "更新日期长度不能超出50")] public string? Lasttime { get; set; } /// /// 模具号 /// [Column("MOLD_NO")] [SugarColumn(ColumnName = "MOLD_NO")] //用于SqlSugar [StringLength(200, ErrorMessage = "模具号长度不能超出200")] public string? MoldNo { get; set; } /// /// 工艺路线 /// [Column("TLA021")] [SugarColumn(ColumnName = "TLA021")] //用于SqlSugar [StringLength(50, ErrorMessage = "工艺路线长度不能超出50")] public string? Tla021 { get; set; } /// /// 需求单据号码 /// [Column("TLA022")] [SugarColumn(ColumnName = "TLA022")] //用于SqlSugar [StringLength(50, ErrorMessage = "需求单据号码长度不能超出50")] public string? Tla022 { get; set; } /// /// 行号 /// [Column("TLA023")] [SugarColumn(ColumnName = "TLA023")] //用于SqlSugar [StringLength(50, ErrorMessage = "行号长度不能超出50")] public string? Tla023 { get; set; } /// /// 生产订单号码 /// [Column("TLA024")] [SugarColumn(ColumnName = "TLA024")] //用于SqlSugar [StringLength(50, ErrorMessage = "生产订单号码长度不能超出50")] public string? Tla024 { get; set; } /// /// 生产订单号码 /// [Column("TLA025")] [SugarColumn(ColumnName = "TLA025")] //用于SqlSugar [StringLength(50, ErrorMessage = "生产订单号码长度不能超出50")] public string? Tla025 { get; set; } /// /// [Column("TLA025A")] [SugarColumn(ColumnName = "TLA025A")] //用于SqlSugar [StringLength(50, ErrorMessage = "Tla025a长度不能超出50")] public string? Tla025a { get; set; } /// /// 入库货主类型 /// [Column("TLA026")] [SugarColumn(ColumnName = "TLA026")] //用于SqlSugar [StringLength(50, ErrorMessage = "入库货主类型长度不能超出50")] public string? Tla026 { get; set; } /// /// 入库货主 /// [Column("TLA027")] [SugarColumn(ColumnName = "TLA027")] //用于SqlSugar [StringLength(50, ErrorMessage = "入库货主长度不能超出50")] public string? Tla027 { get; set; } /// /// 入库组织 /// [Column("TLA028")] [SugarColumn(ColumnName = "TLA028")] //用于SqlSugar [StringLength(50, ErrorMessage = "入库组织长度不能超出50")] public string? Tla028 { get; set; } /// /// [Column("TLA029")] [SugarColumn(ColumnName = "TLA029")] //用于SqlSugar [StringLength(50, ErrorMessage = "Tla029长度不能超出50")] public string? Tla029 { get; set; } /// /// [Column("TLA030")] [SugarColumn(ColumnName = "TLA030")] //用于SqlSugar [StringLength(50, ErrorMessage = "Tla030长度不能超出50")] public string? Tla030 { get; set; } /// /// 计划跟踪号 /// [Column("TLA031")] [SugarColumn(ColumnName = "TLA031")] //用于SqlSugar [StringLength(50, ErrorMessage = "计划跟踪号长度不能超出50")] public string? Tla031 { get; set; } /// /// 工单状态 /// [Column("TLA032")] [SugarColumn(ColumnName = "TLA032")] //用于SqlSugar [StringLength(10, ErrorMessage = "工单状态长度不能超出10")] public string? Tla032 { get; set; } /// /// 整灯型号 /// [Column("TLA033")] [SugarColumn(ColumnName = "TLA033")] //用于SqlSugar [StringLength(500, ErrorMessage = "整灯型号长度不能超出500")] public string? Tla033 { get; set; } /// /// 工序计划号 /// [Column("TLA034")] [SugarColumn(ColumnName = "TLA034")] //用于SqlSugar [StringLength(100, ErrorMessage = "工序计划号长度不能超出100")] public string? Tla034 { get; set; } /// /// 客户 /// [Column("TLA035")] [SugarColumn(ColumnName = "TLA035")] //用于SqlSugar [StringLength(100, ErrorMessage = "客户长度不能超出100")] public string? Tla035 { get; set; } /// /// 单据类型 /// [Column("TLA036")] [SugarColumn(ColumnName = "TLA036")] //用于SqlSugar [StringLength(100, ErrorMessage = "单据类型长度不能超出100")] public string? Tla036 { get; set; } /// /// 更新次数 /// [Column("UPCX")] [SugarColumn(ColumnName = "UPCX")] //用于SqlSugar public decimal? Upcx { get; set; } /// /// 更新标识 /// [Column("UPFLAG")] [SugarColumn(ColumnName = "UPFLAG")] //用于SqlSugar [StringLength(2, ErrorMessage = "更新标识长度不能超出2")] public string? Upflag { get; set; } /// /// 版本 /// [Column("VNO")] [SugarColumn(ColumnName = "VNO")] //用于SqlSugar public decimal? Vno { get; set; } }