using System.ComponentModel.DataAnnotations;
|
using System.ComponentModel.DataAnnotations.Schema;
|
using SqlSugar;
|
|
namespace MES.Service.Modes;
|
|
/// <summary>
|
/// 销售订单表
|
/// </summary>
|
[Table("MES_DEP_TASK")]
|
[SugarTable("MES_DEP_TASK")] //用于SqlSugar
|
public class MesDepTask
|
{
|
/// <summary>
|
/// </summary>
|
[Key]
|
[Column("ID")]
|
[SugarColumn(ColumnName = "ID")] //用于SqlSugar
|
public decimal Id { get; set; }
|
|
/// <summary>
|
/// 从表ID
|
/// </summary>
|
[Column("AUTOID")]
|
[SugarColumn(ColumnName = "AUTOID")] //用于SqlSugar
|
public decimal? Autoid { get; set; }
|
|
/// <summary>
|
/// 备损数量
|
/// </summary>
|
[Column("BACKUP_QTY")]
|
[SugarColumn(ColumnName = "BACKUP_QTY")] //用于SqlSugar
|
public decimal? BackupQty { 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(50, ErrorMessage = "成品编号长度不能超出50")]
|
public string BoardItem { get; set; }
|
|
/// <summary>
|
/// 成品名称
|
/// </summary>
|
[Column("BOARD_NAME")]
|
[SugarColumn(ColumnName = "BOARD_NAME")] //用于SqlSugar
|
[StringLength(200, ErrorMessage = "成品名称长度不能超出200")]
|
public string BoardName { get; set; }
|
|
/// <summary>
|
/// 产品型号
|
/// </summary>
|
[Column("BOARD_STYLE")]
|
[SugarColumn(ColumnName = "BOARD_STYLE")] //用于SqlSugar
|
[StringLength(50, ErrorMessage = "产品型号长度不能超出50")]
|
public string BoardStyle { get; set; }
|
|
/// <summary>
|
/// 关闭日期
|
/// </summary>
|
[Column("CLOSEDATE")]
|
[SugarColumn(ColumnName = "CLOSEDATE")] //用于SqlSugar
|
public DateTime? Closedate { 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(50, ErrorMessage = "Company长度不能超出50")]
|
public string Company { get; set; }
|
|
/// <summary>
|
/// 完工数量
|
/// </summary>
|
[Column("COMPLETE_QTY")]
|
[SugarColumn(ColumnName = "COMPLETE_QTY")] //用于SqlSugar
|
public decimal? CompleteQty { 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("CREATOR")]
|
[SugarColumn(ColumnName = "CREATOR")] //用于SqlSugar
|
[StringLength(200, ErrorMessage = "制单人长度不能超出200")]
|
public string Creator { get; set; }
|
|
/// <summary>
|
/// 客户编号
|
/// </summary>
|
[Column("CUST_NO")]
|
[SugarColumn(ColumnName = "CUST_NO")] //用于SqlSugar
|
[StringLength(20, ErrorMessage = "客户编号长度不能超出20")]
|
public string CustNo { get; set; }
|
|
/// <summary>
|
/// 客户PO
|
/// </summary>
|
[Column("CUST_PO")]
|
[SugarColumn(ColumnName = "CUST_PO")] //用于SqlSugar
|
[StringLength(50, ErrorMessage = "客户PO长度不能超出50")]
|
public string CustPo { get; set; }
|
|
/// <summary>
|
/// 客户机型
|
/// </summary>
|
[Column("CUST_STYLE")]
|
[SugarColumn(ColumnName = "CUST_STYLE")] //用于SqlSugar
|
[StringLength(100, ErrorMessage = "客户机型长度不能超出100")]
|
public string CustStyle { get; set; }
|
|
/// <summary>
|
/// </summary>
|
[Column("DATA_FROM")]
|
[SugarColumn(ColumnName = "DATA_FROM")] //用于SqlSugar
|
[StringLength(10, ErrorMessage = "DataFrom长度不能超出10")]
|
public string DataFrom { get; set; }
|
|
/// <summary>
|
/// </summary>
|
[Column("DOWN_FLAG")]
|
[SugarColumn(ColumnName = "DOWN_FLAG")] //用于SqlSugar
|
public decimal? DownFlag { get; set; }
|
|
/// <summary>
|
/// 下载时间
|
/// </summary>
|
[Column("DOWN_TIME")]
|
[SugarColumn(ColumnName = "DOWN_TIME")] //用于SqlSugar
|
public DateTime? DownTime { 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(20, ErrorMessage = "Factory长度不能超出20")]
|
public string Factory { get; set; }
|
|
/// <summary>
|
/// </summary>
|
[Column("FCHECK_BY")]
|
[SugarColumn(ColumnName = "FCHECK_BY")] //用于SqlSugar
|
[StringLength(30, ErrorMessage = "FcheckBy长度不能超出30")]
|
public string FcheckBy { get; set; }
|
|
/// <summary>
|
/// </summary>
|
[Column("FCHECK_DATE")]
|
[SugarColumn(ColumnName = "FCHECK_DATE")] //用于SqlSugar
|
public DateTime? FcheckDate { get; set; }
|
|
/// <summary>
|
/// </summary>
|
[Column("FCHECK_STATUS")]
|
[SugarColumn(ColumnName = "FCHECK_STATUS")] //用于SqlSugar
|
[StringLength(200, ErrorMessage = "FcheckStatus长度不能超出200")]
|
public string FcheckStatus { get; set; }
|
|
/// <summary>
|
/// </summary>
|
[Column("FIRST_ITEM_READY_TIME")]
|
[SugarColumn(ColumnName = "FIRST_ITEM_READY_TIME")] //用于SqlSugar
|
public DateTime? FirstItemReadyTime { get; set; }
|
|
/// <summary>
|
/// </summary>
|
[Column("FIRST_ITEM_RECEIPT_TIME")]
|
[SugarColumn(ColumnName = "FIRST_ITEM_RECEIPT_TIME")] //用于SqlSugar
|
public DateTime? FirstItemReceiptTime { get; set; }
|
|
/// <summary>
|
/// </summary>
|
[Column("FLAG")]
|
[SugarColumn(ColumnName = "FLAG")] //用于SqlSugar
|
public decimal? Flag { get; set; }
|
|
/// <summary>
|
/// </summary>
|
[Column("ISSUE_STATUS")]
|
[SugarColumn(ColumnName = "ISSUE_STATUS")] //用于SqlSugar
|
public decimal? IssueStatus { get; set; }
|
|
/// <summary>
|
/// </summary>
|
[Column("LASTUPDATE_BY")]
|
[SugarColumn(ColumnName = "LASTUPDATE_BY")] //用于SqlSugar
|
[StringLength(30, ErrorMessage = "LastupdateBy长度不能超出30")]
|
public string LastupdateBy { get; set; }
|
|
/// <summary>
|
/// </summary>
|
[Column("LASTUPDATE_DATE")]
|
[SugarColumn(ColumnName = "LASTUPDATE_DATE")] //用于SqlSugar
|
public DateTime? LastupdateDate { get; set; }
|
|
/// <summary>
|
/// 备注
|
/// </summary>
|
[Column("MEMO")]
|
[SugarColumn(ColumnName = "MEMO")] //用于SqlSugar
|
[StringLength(255, ErrorMessage = "备注长度不能超出255")]
|
public string Memo { get; set; }
|
|
/// <summary>
|
/// 生产工单
|
/// </summary>
|
[Column("MOCODE")]
|
[SugarColumn(ColumnName = "MOCODE")] //用于SqlSugar
|
[StringLength(50, ErrorMessage = "生产工单长度不能超出50")]
|
public string Mocode { get; set; }
|
|
/// <summary>
|
/// 主表ID
|
/// </summary>
|
[Column("MOID")]
|
[SugarColumn(ColumnName = "MOID")] //用于SqlSugar
|
public decimal? Moid { 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_TYPE")]
|
[SugarColumn(ColumnName = "PACK_SHIP_TYPE")] //用于SqlSugar
|
[StringLength(20, ErrorMessage = "包装类型长度不能超出20")]
|
public string PackShipType { get; set; }
|
|
/// <summary>
|
/// 计划开始时间
|
/// </summary>
|
[Column("PLAN_BEGIN_TIME")]
|
[SugarColumn(ColumnName = "PLAN_BEGIN_TIME")] //用于SqlSugar
|
public DateTime? PlanBeginTime { get; set; }
|
|
/// <summary>
|
/// 计划完工时间
|
/// </summary>
|
[Column("PLAN_FINISH_TIME")]
|
[SugarColumn(ColumnName = "PLAN_FINISH_TIME")] //用于SqlSugar
|
public DateTime? PlanFinishTime { get; set; }
|
|
/// <summary>
|
/// 数量
|
/// </summary>
|
[Column("PLAN_QTY")]
|
[SugarColumn(ColumnName = "PLAN_QTY")] //用于SqlSugar
|
public decimal? PlanQty { get; set; }
|
|
/// <summary>
|
/// 打印回定值
|
/// </summary>
|
[Column("PROC_PRINT_VALUE")]
|
[SugarColumn(ColumnName = "PROC_PRINT_VALUE")] //用于SqlSugar
|
[StringLength(50, ErrorMessage = "打印回定值长度不能超出50")]
|
public string ProcPrintValue { get; set; }
|
|
/// <summary>
|
/// 工单状态
|
/// </summary>
|
[Column("PRODUCE_STATE")]
|
[SugarColumn(ColumnName = "PRODUCE_STATE")] //用于SqlSugar
|
[StringLength(10, ErrorMessage = "工单状态长度不能超出10")]
|
public string ProduceState { get; set; }
|
|
/// <summary>
|
/// 实际开始时间
|
/// </summary>
|
[Column("REAL_BEGIN_TIME")]
|
[SugarColumn(ColumnName = "REAL_BEGIN_TIME")] //用于SqlSugar
|
public DateTime? RealBeginTime { get; set; }
|
|
/// <summary>
|
/// 实际完工时间
|
/// </summary>
|
[Column("REAL_FINISH_TIME")]
|
[SugarColumn(ColumnName = "REAL_FINISH_TIME")] //用于SqlSugar
|
public DateTime? RealFinishTime { get; set; }
|
|
/// <summary>
|
/// 环保代码
|
/// </summary>
|
[Column("ROHSE_CODE")]
|
[SugarColumn(ColumnName = "ROHSE_CODE")] //用于SqlSugar
|
[StringLength(20, ErrorMessage = "环保代码长度不能超出20")]
|
public string RohseCode { get; set; }
|
|
/// <summary>
|
/// 船头样
|
/// </summary>
|
[Column("SHIP_QTY")]
|
[SugarColumn(ColumnName = "SHIP_QTY")] //用于SqlSugar
|
public decimal? ShipQty { get; set; }
|
|
/// <summary>
|
/// 状态
|
/// </summary>
|
[Column("STATUS")]
|
[SugarColumn(ColumnName = "STATUS")] //用于SqlSugar
|
[StringLength(10, ErrorMessage = "状态长度不能超出10")]
|
public string Status { get; set; }
|
|
/// <summary>
|
/// 订单编号
|
/// </summary>
|
[Column("TASK_NO")]
|
[SugarColumn(ColumnName = "TASK_NO")] //用于SqlSugar
|
[StringLength(50, ErrorMessage = "订单编号长度不能超出50")]
|
public string TaskNo { get; set; }
|
|
/// <summary>
|
/// 工单类型
|
/// </summary>
|
[Column("TASK_TYPE")]
|
[SugarColumn(ColumnName = "TASK_TYPE")] //用于SqlSugar
|
[StringLength(20, ErrorMessage = "工单类型长度不能超出20")]
|
public string TaskType { 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(120, ErrorMessage = "版本长度不能超出120")]
|
public string Version { get; set; }
|
|
/// <summary>
|
/// 任务单行号
|
/// </summary>
|
[Column("WORK_LINE")]
|
[SugarColumn(ColumnName = "WORK_LINE")] //用于SqlSugar
|
public decimal? WorkLine { get; set; }
|
|
/// <summary>
|
/// 任务单号
|
/// </summary>
|
[Column("WORK_NO")]
|
[SugarColumn(ColumnName = "WORK_NO")] //用于SqlSugar
|
[StringLength(50, ErrorMessage = "任务单号长度不能超出50")]
|
public string WorkNo { get; set; }
|
}
|
