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