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