DEMOMySql/MicroServices/Business/Business.Domain/StructuredDB/Production/WorkOrdMaster.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 WorkOrdMaster
    {
        /// <summary>
        /// 主键
        /// </summary>
        [Comment("主键")]
        [Key]
        public int RecID { get; set; }

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

        /// <summary>
        /// 计划开始日期
        /// </summary>
        [Comment("计划开始日期")]
        public DateTime? OrdDate { get; set; }

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

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

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

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

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

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

        /// <summary>
        /// 优先级
        /// </summary>
        [Comment("优先级")]
        public decimal Priority { get; set; }

        /// <summary>
        /// 班次
        /// </summary>
        [Comment("班次")]
        public short Period { get; set; }

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

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

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

        /// <summary>
        /// 确认
        /// </summary>
        [Comment("确认")]
        public bool IsConfirm { get; set; }

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

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

        /// <summary>
        /// 类型:正常工单-空或者Null；反之则为特殊工单
        /// </summary>
        [Comment("类型")]
        public string Typed { get; set; }

        /// <summary>
        /// 生产时长(小时)
        /// </summary>
        [Comment("生产时长")]
        public decimal LbrVar { get; set; }

        /// <summary>
        /// 正在生产的工单重新排产是否需要考虑产线准备时间：A-连续生产不需要考虑;B-日计划日期调整需要考虑
        /// </summary>
        [Comment("生产时长")]
        public string JointTyped { get; set; }

        /// <summary>
        /// 流程id
        /// </summary>
        [Comment("流程id")]
        public long BusinessID { get; set; }

        public string SalesJob { get; set; }
    }
}