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