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>
        /// 租户ID
        /// </summary>
        [Comment("租户ID")]
        public long? tenant_id { 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; }

        /// <summary>
        /// 工作中心
        /// </summary>
        [Comment("工作中心")]
        public string WorkCtr { get; set; }

        /// <summary>
        /// 工艺路线编码
        /// </summary>
        [Comment("工艺路线编码")]
        public string Ufld1 { get; set; }

        /// <summary>
        /// 生产车间
        /// </summary>
        [Comment("生产车间")]
        public string Ufld2 { get; set; }

        /// <summary>
        /// 工序控制码
        /// </summary>
        [Comment("工序控制码")]
        public string Ufld3 { get; set; }

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

        /// <summary>
        /// 工序委外提前期
        /// </summary>
        [Comment("工序委外提前期")]
        public decimal ProcessOutDay { get; set; }

        /// <summary>
        /// 工序委外供应商代码
        /// </summary>
        [Comment("工序委外供应商代码")]
        public string ProcessOutSupp { get; set; }

        /// <summary>
        /// 设备编码
        /// </summary>
        [Comment("设备编码")]
        public string Machine { get; set; }

        /// <summary>
        /// 模具编码
        /// </summary>
        [Comment("模具编码")]
        public string ToolCode { get; set; }

        /// <summary>
        /// 人员技能编号
        /// </summary>
        [Comment("人员技能编号")]
        public string Engineer { get; set; }

        /// <summary>
        /// 标准人数
        /// </summary>
        [Comment("标准人数")]
        public decimal RunCrew { get; set; }

        /// <summary>
        /// 产线
        /// </summary>
        [Comment("产线")]
        public string ProdLine { get; set; }

        /// <summary>
        /// 单位产能
        /// </summary>
        [Comment("单位产能")]
        public decimal MachBdnRate { get; set; }

        /// <summary>
        /// 准备时间
        /// </summary>
        [Comment("准备时间")]
        public decimal StdSetupTime { get; set; }

        /// <summary>
        /// 工序类型
        /// </summary>
        [Comment("工序类型")]
        public string WorkCode { get; set; }

        /// <summary>
        /// 作业编码
        /// </summary>
        [Comment("作业编码")]
        public string ChargeCode { get; set; }

        /// <summary>
        /// 作业编码
        /// </summary>
        [Comment("作业编码")]
        public string ERPfld2 { get; set; }

        /// <summary>
        /// 机器时间
        /// </summary>
        [Comment("机器时间")]
        public decimal MachinesperOp { get; set; }

        /// <summary>
        /// 准备时间
        /// </summary>
        [Comment("准备时间")]
        public decimal Setup { get; set; }

        /// <summary>
        /// 人工时间
        /// </summary>
        [Comment("人工时间")]
        public decimal Labor { get; set; }

        /// <summary>
        /// 更新时间
        /// </summary>
        [Comment("更新时间")]
        public DateTime? UpdateTime { get; set; }

        /// <summary>
        ///更新用户
        /// </summary>
        [Comment("更新用户")]
        public string UpdateUser { get; set; }
    }
}