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 CustNo { get; set; }

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

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

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

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

        /// <summary>
        /// 已完成数量
        /// </summary>
        [Comment("已完成数量")]
        public decimal QtyCompleted { get; set; }

        /// <summary>
        /// 在库齐套数量
        /// </summary>
        [Comment("在库齐套数量")]
        public decimal? LocationStock { get; set; }

        /// <summary>
        /// 在制数量
        /// </summary>
        [Comment("在制数量")]
        public decimal? InProdcutQty { get; set; }

        /// <summary>
        /// 工序最大完成数
        /// </summary>
        [Comment("工序最大完成数")]
        public decimal? OpQtyCompleted { 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>
        /// 状态：空是初始,P是发布，R为下达，W是投产，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>
        /// 修改时间
        /// </summary>
        [Comment("修改时间")]
        public DateTime? UpdateTime { get; set; }

        /// <summary>
        /// 创建人
        /// </summary>
        [Comment("创建人")]
        public string CreateUser { get; set; }

        /// <summary>
        /// 修改人
        /// </summary>
        [Comment("修改人")]
        public string UpdateUser { 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; }

        /// <summary>
        /// 生产批次号
        /// </summary>
        [Comment("批次序列")]
        public string LotSerial { get; set; }

        /// <summary>
        /// 模拟计算版本号，不为空为年度长周期，为空为周计划
        /// </summary>
        [Comment("模拟计算版本号，不为空为年度长周期，为空为周计划")]
        [StringLength(80)]
        public string AnalogCalcVersion { get; set; }

        /// <summary>
        /// 是否打标：1-打标；0-不达标
        /// </summary>
        [Comment("是否打标")]
        public bool CreateGLforLaborVar { get; set; }

        /// <summary>
        /// 是否VMI结算
        /// </summary>
        [Comment("是否VMI结算")]
        public string IssueSite { get; set; }

        /// <summary>
        /// 加急
        /// </summary>
        [Comment("加急")]
        public int Urgent { get; set; }

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

        /// <summary>
        /// 优先级编号
        /// </summary>
        [Comment("优先级编号")]
        public string PriorityNo { get; set; }

        /// <summary>
        /// BOM版本
        /// </summary>
        [Comment("BOM版本")]
        public string Refs { get; set; }

        /// <summary>
        /// 部门
        /// </summary>
        [Comment("部门")]
        public string Department { get; set; }

    }
}