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

using Business.Core.Attributes;
using Microsoft.EntityFrameworkCore;
using System;
using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;

namespace Business.Domain
{
    /// <summary>
    /// 工单主表
    /// </summary>
    [CollectionName("dopbase", "mes_morder")]
    [Comment("工单主表")]
    public class mes_morder : BaseEntity
    {
        ///// <summary>
        ///// 生产工单id
        ///// </summary>
        //[Key]
        //[Comment("生产工单id")]
        //public long morder_id { get; set; }
        /// <summary>
        /// 上级工单id
        /// </summary>
        [Comment("上级工单id")]
        public long? parent_id { get; set; }
        /// <summary>
        /// 关联工单id
        /// </summary>
        [Comment("关联工单id")]
        public long? relation_moid { get; set; }
        /// <summary>
        /// 关联编号
        /// </summary>   
        [StringLength(50)]
        [Comment("关联编号")]
        public string relation_mono { get; set; }
        /// <summary>
        /// 生产工单编号
        /// </summary>
        [Required]
        [StringLength(50)]
        [Comment("生产工单编号")]
        public string morder_no { get; set; }
        /// <summary>
        /// 生产工单类型(类型：计划工单、销售工单、委外工单、预测工单)
        /// </summary>
        [StringLength(50)]
        [Comment("生产工单类型(类型：计划工单、销售工单、委外工单、预测工单)")]
        public string morder_type { get; set; }
        /// <summary>
        /// 工单所属物料类型
        /// </summary>
        [StringLength(255)]
        [Comment("工单所属物料类型")]
        public string morder_icitem_type { get; set; }
        /// <summary>
        /// 工单类型(类型：发货工单、试产工单、备库工单、常规工单、返工工单)
        /// </summary>
        [StringLength(255)]
        [Comment("工单类型(类型：发货工单、试产工单、备库工单、常规工单、返工工单)")]
        public string work_order_type { get; set; }
        /// <summary>
        /// 生产工单日期
        /// </summary>
        [Comment("生产工单日期")]
        public DateTime? morder_date { get; set; }
        /// <summary>
        /// 生产工单状态(订单状态:初始，下达，暂停、完成)
        /// </summary>
        [StringLength(50)]
        [Comment("生产工单状态(订单状态:初始，下达，暂停、完成)")]
        public string morder_state { get; set; }
        /// <summary>
        /// 生产组织id
        /// </summary>
        [Comment("生产组织id")]
        public long? moentry_prd { get; set; }
        /// <summary>
        /// 生产组织名称
        /// </summary>
        [StringLength(50)]
        [Comment("生产组织名称")]
        public string moentry_prdname { get; set; }
        /// <summary>
        /// 工作中心id
        /// </summary>
        [Comment("工作中心id")]
        public long? moentry_wrkc { get; set; }
        /// <summary>
        /// 工作中心名称
        /// </summary>
        [StringLength(50)]
        [Comment("工作中心名称")]
        public string moentry_wrkcname { get; set; }
        /// <summary>
        /// 计划员工号
        /// </summary>
        [StringLength(80)]
        [Comment("计划员工号")]
        public string planner_num { get; set; }
        /// <summary>
        /// 计划员名称
        /// </summary>
        [StringLength(80)]
        [Comment("计划员名称")]
        public string planner_name { get; set; }
        /// <summary>
        /// 生产工单开始日期
        /// </summary>
        [Comment("生产工单开始日期")]
        public DateTime? moentry_stime { get; set; }
        /// <summary>
        /// 生产工单结束日期
        /// </summary>
        [Comment("生产工单结束日期")]
        public DateTime? moentry_etime { get; set; }
        /// <summary>
        /// 系统建议开工时间
        /// </summary>
        [Comment("系统建议开工时间")]
        public DateTime? moentry_sys_stime { get; set; }
        /// <summary>
        /// 系统建议完工时间
        /// </summary>
        [Comment("系统建议完工时间")]
        public DateTime? moentry_sys_etime { get; set; }
        /// <summary>
        /// 实际开始时间
        /// </summary>
        [Comment("实际开始时间")]
        public DateTime? reality_start_time { get; set; }
        /// <summary>
        /// 实际结束时间
        /// </summary>
        [Comment("实际结束时间")]
        public DateTime? reality_end_time { get; set; }
        /// <summary>
        /// 计划员设定开始时间
        /// </summary>
        [Comment("计划员设定开始时间")]
        public DateTime? planner_start_date { get; set; }
        /// <summary>
        /// 计划员设定结束时间
        /// </summary>
        [Comment("计划员设定结束时间")]
        public DateTime? planner_end_date { get; set; }
        /// <summary>
        /// 基于物料开始时间
        /// </summary>
        [Comment("基于物料开始时间")]
        public DateTime? mat_start_date { get; set; }
        /// <summary>
        /// 基于物料结束时间
        /// </summary>
        [Comment("基于物料结束时间")]
        public DateTime? mat_end_date { get; set; }
        /// <summary>
        /// 产品代码
        /// </summary>
        [StringLength(80)]
        [Comment("产品代码")]
        public string product_code { get; set; }
        /// <summary>
        /// 产品名称
        /// </summary>
        [StringLength(500)]
        [Comment("产品名称")]
        public string product_name { get; set; }
        /// <summary>
        /// fms旧料号
        /// </summary>
        [StringLength(80)]
        [Comment("fms旧料号")]
        public string fms_number { get; set; }
        /// <summary>
        /// 规格型号
        /// </summary>
        [StringLength(500)]
        [Comment("规格型号")]
        public string fmodel { get; set; }
        /// <summary>
        /// bom编码
        /// </summary>
        [StringLength(80)]
        [Comment("bom编码")]
        public string bom_number { get; set; }
        /// <summary>
        /// 单位
        /// </summary>
        [StringLength(80)]
        [Comment("单位")]
        public string unit { get; set; }
        /// <summary>
        /// 工单进度
        /// </summary>
        [StringLength(1000)]
        [Comment("工单进度")]
        public string morder_progress { get; set; }
        /// <summary>
        /// 工单所需工时
        /// </summary>
        [Precision(23, 10)]
        [Comment("工单所需工时")]
        public decimal? morder_need_time { get; set; }
        /// <summary>
        /// 工单生产数量(计划数量)
        /// </summary>
        [Precision(23, 10)]
        [Comment("工单生产数量(计划数量)")]
        public decimal? morder_production_number { get; set; }
        /// <summary>
        /// 需求数量
        /// </summary>
        [Precision(23, 10)]
        [Comment("需求数量")]
        public decimal? need_number { get; set; }
        /// <summary>
        /// 剩余可用数量
        /// </summary>
        [Precision(23, 10)]
        [Comment("剩余可用数量")]
        public decimal? remaining_number { get; set; }
        /// <summary>
        /// 报工数量
        /// </summary>
        [Precision(23, 10)]
        [Comment("报工数量")]
        public decimal? work_number { get; set; }
        /// <summary>
        /// 报检数量
        /// </summary>
        [Precision(23, 10)]
        [Comment("报检数量")]
        public decimal? inspection_number { get; set; }
        /// <summary>
        /// 合格数量
        /// </summary>
        [Precision(23, 10)]
        [Comment("合格数量")]
        public decimal? qualified_number { get; set; }
        /// <summary>
        /// 入库数量
        /// </summary>
        [Precision(23, 10)]
        [Comment("入库数量")]
        public decimal? inventory_number { get; set; }
        ///// <summary>
        ///// 扩展
        ///// </summary>
        //public string ext { get; set; }
        /// <summary>
        /// 已开入库通知单数量
        /// </summary>
        [Precision(23, 10)]
        [Comment("已开入库通知单数量")]
        public decimal? notice_qty { get; set; }
        /// <summary>
        /// 启动状态
        /// </summary>
        [Comment("启动状态")]
        public int? moentry_startup_status { get; set; }
        /// <summary>
        /// 开始时间
        /// </summary>
        [Comment("开始时间")]
        public DateTime? start_time { get; set; }
        /// <summary>
        /// 最近暂停时间
        /// </summary>
        [Comment("最近暂停时间")]
        public DateTime? pause_time { get; set; }
        /// <summary>
        /// 最近重启时间
        /// </summary>
        [Comment("最近重启时间")]
        public DateTime? restart_time { get; set; }
        /// <summary>
        /// 项目名称
        /// </summary>
        [StringLength(255)]
        [Comment("项目名称")]
        public string project_name { get; set; }
        /// <summary>
        /// 逾期原因备注
        /// </summary>
        [StringLength(255)]
        [Comment("逾期原因备注")]
        public string overdue_Remark { get; set; }
        /// <summary>
        /// 已领料数量
        /// </summary>
        [Precision(23, 10)]
        [Comment("已领料数量")]
        public decimal? picking_qty { get; set; }
        /// <summary>
        /// 前状态--计划、下达、完成、关闭
        /// </summary>
        [StringLength(50)]
        [Comment("前状态--计划、下达、完成、关闭")]
        public string morder_fstate { get; set; }
        /// <summary>
        /// 工单批号--(批号管理的物料出入库要使用)
        /// </summary>
        [StringLength(100)]
        [Comment("工单批号--(批号管理的物料出入库要使用)")]
        public string morder_batchno { get; set; }
        /// <summary>
        /// 物料情况
        /// </summary>
        [StringLength(50)]
        [Comment("物料情况")]
        public string? MaterialSituation { get; set; }
        /// <summary>
        /// 下达日期
        /// </summary>
        [Comment("下达日期")]
        public DateTime? convey_date { get; set; }
        /// <summary>
        /// 计算ID
        /// </summary>
        [Comment("计算id")]
        [NotMapped]
        public long? bang_id { get; set; }

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