using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;
using SqlSugar;

namespace MES.Service.Modes;

/// <summary>
///     排产结果表
/// </summary>
[Table("MES_SCHEME_RESULT")]
[SugarTable("MES_SCHEME_RESULT")] //用于SqlSugar
public class MesSchemeResult
{
    /// <summary>
    ///     可排数量
    /// </summary>
    [Column("ALLOW_QTY")]
    [SugarColumn(ColumnName = "ALLOW_QTY")] //用于SqlSugar
    public decimal? AllowQty { get; set; }

    /// <summary>
    ///     计划编号
    /// </summary>
    [Column("BILL_NO")]
    [SugarColumn(ColumnName = "BILL_NO")] //用于SqlSugar
    [StringLength(50, ErrorMessage = "计划编号长度不能超出50")]
    public string BillNo { 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_SIDE")]
    [SugarColumn(ColumnName = "BOARD_SIDE")] //用于SqlSugar
    [StringLength(20, ErrorMessage = "板面长度不能超出20")]
    public string BoardSide { get; set; }

    /// <summary>
    ///     标准产能
    /// </summary>
    [Column("CAT_QTY")]
    [SugarColumn(ColumnName = "CAT_QTY")] //用于SqlSugar
    public decimal? CatQty { get; set; }

    /// <summary>
    /// </summary>
    [Column("CHECK_BY")]
    [SugarColumn(ColumnName = "CHECK_BY")] //用于SqlSugar
    [StringLength(20, ErrorMessage = "CheckBy长度不能超出20")]
    public string CheckBy { get; set; }

    /// <summary>
    /// </summary>
    [Column("CHECK_DATE")]
    [SugarColumn(ColumnName = "CHECK_DATE")] //用于SqlSugar
    public DateTime? CheckDate { get; set; }

    /// <summary>
    ///     SMT齐套标志(未检查,不齐套,齐套,接口表无数据)
    /// </summary>
    [Column("CHECK_FLAG")]
    [SugarColumn(ColumnName = "CHECK_FLAG")] //用于SqlSugar
    [StringLength(20, ErrorMessage = "SMT齐套标志(未检查,不齐套,齐套,接口表无数据)长度不能超出20")]
    public string CheckFlag { get; set; }

    /// <summary>
    ///     班次号
    /// </summary>
    [Column("CLASS_NO")]
    [SugarColumn(ColumnName = "CLASS_NO")] //用于SqlSugar
    [StringLength(20, ErrorMessage = "班次号长度不能超出20")]
    public string ClassNo { get; set; }

    /// <summary>
    ///     公司代码
    /// </summary>
    [Column("COMPANY")]
    [SugarColumn(ColumnName = "COMPANY")] //用于SqlSugar
    [StringLength(20, ErrorMessage = "公司代码长度不能超出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("DETAIL_MEM")]
    [SugarColumn(ColumnName = "DETAIL_MEM")] //用于SqlSugar
    [StringLength(500, ErrorMessage = "派工物料备注长度不能超出500")]
    public string DetailMem { get; set; }

    /// <summary>
    ///     分厂编码
    /// </summary>
    [Column("FACTORY")]
    [SugarColumn(ColumnName = "FACTORY")] //用于SqlSugar
    [StringLength(20, ErrorMessage = "分厂编码长度不能超出20")]
    public string Factory { get; set; }

    /// <summary>
    ///     SEQ_MES_SCHEME_RESULT
    /// </summary>
    [Column("ID")]
    [SugarColumn(IsPrimaryKey = true,
        OracleSequenceName = "SEQ_MES_SCHEME_RESULT",
        ColumnName = "ID")] //用于SqlSugar
    public decimal Id { get; set; }

    /// <summary>
    ///     发布人
    /// </summary>
    [Column("ISSUED_BY")]
    [SugarColumn(ColumnName = "ISSUED_BY")] //用于SqlSugar
    [StringLength(50, ErrorMessage = "发布人长度不能超出50")]
    public string IssuedBy { get; set; }

    /// <summary>
    ///     发布时间
    /// </summary>
    [Column("ISSUED_DATE")]
    [SugarColumn(ColumnName = "ISSUED_DATE")] //用于SqlSugar
    public DateTime? IssuedDate { 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>
    ///     线体号
    /// </summary>
    [Column("LINE_NO")]
    [SugarColumn(ColumnName = "LINE_NO")] //用于SqlSugar
    [StringLength(20, ErrorMessage = "线体号长度不能超出20")]
    public string LineNo { 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>
    /// </summary>
    [Column("MOCODE_LINE")]
    [SugarColumn(ColumnName = "MOCODE_LINE")] //用于SqlSugar
    [StringLength(5, ErrorMessage = "MocodeLine长度不能超出5")]
    public string MocodeLine { get; set; }

    /// <summary>
    ///     加工顺序号
    /// </summary>
    [Column("ORDER_NO")]
    [SugarColumn(ColumnName = "ORDER_NO")] //用于SqlSugar
    public decimal? OrderNo { get; set; }

    /// <summary>
    ///     轨道
    /// </summary>
    [Column("PATHWAY")]
    [SugarColumn(ColumnName = "PATHWAY")] //用于SqlSugar
    [StringLength(20, ErrorMessage = "轨道长度不能超出20")]
    public string Pathway { 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_TURN_TIME")]
    [SugarColumn(ColumnName = "PLAN_TURN_TIME")] //用于SqlSugar
    public decimal? PlanTurnTime { get; set; }

    /// <summary>
    ///     转产标识
    /// </summary>
    [Column("PMOVE_MK")]
    [SugarColumn(ColumnName = "PMOVE_MK")] //用于SqlSugar
    public decimal? PmoveMk { get; set; }

    /// <summary>
    ///     可排产数量
    /// </summary>
    [Column("PROCESS_QTY")]
    [SugarColumn(ColumnName = "PROCESS_QTY")] //用于SqlSugar
    public decimal? ProcessQty { get; set; }

    /// <summary>
    ///     工序号
    /// </summary>
    [Column("PROC_NO")]
    [SugarColumn(ColumnName = "PROC_NO")] //用于SqlSugar
    [StringLength(20, ErrorMessage = "工序号长度不能超出20")]
    public string ProcNo { get; set; }

    /// <summary>
    ///     工序顺序号
    /// </summary>
    [Column("PROC_ORDER")]
    [SugarColumn(ColumnName = "PROC_ORDER")] //用于SqlSugar
    public decimal? ProcOrder { get; set; }

    /// <summary>
    ///     生产状态
    /// </summary>
    [Column("PROC_STATUS")]
    [SugarColumn(ColumnName = "PROC_STATUS")] //用于SqlSugar
    [StringLength(10, ErrorMessage = "生产状态长度不能超出10")]
    public string ProcStatus { 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("REAL_TURN_TIME")]
    [SugarColumn(ColumnName = "REAL_TURN_TIME")] //用于SqlSugar
    public decimal? RealTurnTime { get; set; }

    /// <summary>
    ///     完工原因
    /// </summary>
    [Column("REM")]
    [SugarColumn(ColumnName = "REM")] //用于SqlSugar
    [StringLength(20, ErrorMessage = "完工原因长度不能超出20")]
    public string Rem { get; set; }

    /// <summary>
    ///     排产数量
    /// </summary>
    [Column("SCHEME_QTY")]
    [SugarColumn(ColumnName = "SCHEME_QTY")] //用于SqlSugar
    public decimal? SchemeQty { get; set; }

    /// <summary>
    ///     状态(0-排产,10-发布)
    /// </summary>
    [Column("STATUS")]
    [SugarColumn(ColumnName = "STATUS")] //用于SqlSugar
    public decimal? 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("TB_FLAG")]
    [SugarColumn(ColumnName = "TB_FLAG")] //用于SqlSugar
    public decimal? TbFlag { get; set; }

    /// <summary>
    /// </summary>
    [Column("WSCHEME_QTY")]
    [SugarColumn(ColumnName = "WSCHEME_QTY")] //用于SqlSugar
    public decimal? WschemeQty { get; set; }

    /// <summary>
    ///     原排计划
    /// </summary>
    [Column("YBILL_NO")]
    [SugarColumn(ColumnName = "YBILL_NO")] //用于SqlSugar
    [StringLength(50, ErrorMessage = "原排计划长度不能超出50")]
    public string YbillNo { get; set; }

    /// <summary>
    ///     原排产线
    /// </summary>
    [Column("YLINE_NO")]
    [SugarColumn(ColumnName = "YLINE_NO")] //用于SqlSugar
    [StringLength(50, ErrorMessage = "原排产线长度不能超出50")]
    public string YlineNo { get; set; }

    /// <summary>
    ///     原计划数
    /// </summary>
    [Column("YSCHEME_QTY")]
    [SugarColumn(ColumnName = "YSCHEME_QTY")] //用于SqlSugar
    public decimal? YschemeQty { get; set; }

    [SugarColumn(IsIgnore = true)] public string? BoardModel { get; set; }

    [SugarColumn(IsIgnore = true)] public decimal? PlanQty { get; set; }

    [SugarColumn(IsIgnore = true)] public string? BoardStyle { get; set; }
}