DEMOMySql/MicroServices/Business/Business.Domain/StructuredDB/Production/WorkOrdRouting.cs

using Microsoft.EntityFrameworkCore;
using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace Business.Domain
{
    /// <summary>
    /// 工单工艺流程表
    /// </summary>
    [Comment("工单工艺流程表")]
    public class WorkOrdRouting
    {
        /// <summary>
        /// 主键
        /// </summary>
        [Comment("主键")]
        [Key]
        public int RecID { get; set; }

        /// <summary>
        /// 域名
        /// </summary>
        [Comment("域名")]
        public string Domain { get; set; }

        /// <summary>
        /// 描述
        /// </summary>
        [Comment("描述")]
        public string Descr { get; set; }

        /// <summary>
        /// 到期日期
        /// </summary>
        [Comment("到期日期")]
        public DateTime? DueDate { get; set; }

        /// <summary>
        /// 关键工序(需要报工的工序)
        /// </summary>
        [Comment("关键工序")]
        public bool MilestoneOp { get; set; }

        /// <summary>
        /// 工单
        /// </summary>
        [Comment("工单")]
        public string WorkOrd { get; set; }

        /// <summary>
        /// 工序
        /// </summary>
        [Comment("工序")]
        public int OP { get; set; }

        /// <summary>
        /// 父级工序
        /// </summary>
        [Comment("父级工序")]
        public int ParentOp { get; set; }

        /// <summary>
        /// 运行时间(标准节拍)
        /// </summary>
        [Comment("运行时间")]
        public decimal RunTime { get; set; }

        /// <summary>
        /// 物料编号
        /// </summary>
        [Comment("物料编号")]
        public string ItemNum { get; set; }

        /// <summary>
        /// 订单数量
        /// </summary>
        [Comment("订单数量")]
        public decimal? QtyOrded { get; set; }
        /// <summary>
        /// 报工数量
        /// </summary>
        [Comment("报工数量")]
        public decimal QtyComplete { get; set; }
        

        /// <summary>
        /// 工序清场时长(小时)
        /// </summary>
        [Comment("工序清场时长")]
        public decimal WaitTime { get; set; }

        /// <summary>
        /// 平行加工件数，下序开工前置数量
        /// </summary>
        [Comment("平行加工件数")]
        public int? OverlapUnits { get; set; }

        /// <summary>
        /// 状态：C为不可用状态
        /// </summary>
        [Comment("状态")]
        public string Status { get; set; }

        /// <summary>
        /// 是否换包
        /// </summary>
        [Comment("是否换包")]
        public int CommentIndex { get; set; }

        /// <summary>
        /// 是否有效：1-有效；0-无效
        /// </summary>
        [Comment("是否有效")]
        public bool IsActive { get; set; }

        /// <summary>
        /// 创建时间
        /// </summary>
        [Comment("创建时间")]
        public DateTime? CreateTime { get; set; }

        /// <summary>
        /// 工单主键
        /// </summary>
        [Comment("工单主键")]
        public long WorkOrdMasterRecID { get; set; }

        /// <summary>
        /// 报工批量
        /// </summary>
        [Comment("报工批量")]
        public decimal? PackingQty { get; set; }

        /// <summary>
        /// 最新报工时间
        /// </summary>
        [Comment("最新报工时间")]
        public DateTime? Last { get; set; }

        /// <summary>
        /// SAP工序
        /// </summary>
        [Comment("SAP工序")]
        public string StdOp { get; set; }
    }
}