DEMOMySql/MicroServices/Business/Business.Domain/StructuredDB/Production/mes_oorder.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_oorder")]
    [Comment("委外订单表")]
    public class mes_oorder : BaseEntity
    {
        ///// <summary>
        ///// 委外订单id
        ///// </summary>
        //[Key]
        //[Comment("委外订单id")]
        //public long oorder_id { get; set; }
        /// <summary>
        /// 生产工单编号
        /// </summary>
        [StringLength(50)]
        [Comment("生产工单编号")]
        public string oorder_no { get; set; }
        /// <summary>
        /// 生产工单类型
        /// </summary>
        [StringLength(80)]
        [Comment("生产工单类型")]
        public string oorder_type { get; set; }
        /// <summary>
        /// 委外订单日期
        /// </summary>
        [Comment("委外订单日期")]
        public DateTime? oorder_date { get; set; }
        /// <summary>
        /// 订单状态
        /// </summary>
        [StringLength(50)]
        [Comment("订单状态")]
        public string oorder_state { get; set; }
        /// <summary>
        /// 生产组织
        /// </summary>
        [Comment("生产组织")]
        public long? ooentry_prd { get; set; }
        /// <summary>
        /// 生产组织名称
        /// </summary>
        [StringLength(50)]
        [Comment("生产组织名称")]
        public string ooentry_prdname { get; set; }
        /// <summary>
        /// 工作中心id
        /// </summary>
        [Comment("工作中心id")]
        public long? ooentry_wrkc { get; set; }
        /// <summary>
        /// 工作中心名称
        /// </summary>
        [StringLength(50)]
        [Comment("工作中心名称")]
        public string ooentry_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? ooentry_stime { get; set; }
        /// <summary>
        /// 计划完工日期
        /// </summary>
        [Comment("计划完工日期")]
        public DateTime? ooentry_etime { get; set; }
        /// <summary>
        /// 产品代码
        /// </summary>
        [StringLength(80)]
        [Comment("产品代码")]
        public string product_code { get; set; }
        /// <summary>
        /// fms旧料号
        /// </summary>
        [StringLength(80)]
        [Comment("fms旧料号")]
        public string ffms_number { get; set; }
        /// <summary>
        /// 产品名称
        /// </summary>
        [StringLength(500)]
        [Comment("产品名称")]
        public string product_name { get; set; }
        /// <summary>
        /// 规格型号
        /// </summary>
        [StringLength(500)]
        [Comment("规格型号")]
        public string specification_model { 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(500)]
        [Comment("工单进度")]
        public string morder_progress { get; set; }
        /// <summary>
        /// 工单生产数量(计划数量)
        /// </summary>
        [Precision(20, 10)]
        [Comment("工单生产数量(计划数量)")]
        public decimal? morder_production_number { get; set; }
        /// <summary>
        /// 需求数量
        /// </summary>
        [Precision(20, 10)]
        [Comment("需求数量")]
        public decimal? need_number { get; set; }
        /// <summary>
        /// 剩余可用数量
        /// </summary>
        [Precision(20, 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>
        [Precision(23, 10)]
        [Comment("已开通知单数量")]
        public decimal? notice_qty { get; set; }
        /// <summary>
        /// 启动状态
        /// </summary>
        [Comment("启动状态")]
        public int? moentry_on { 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>
        //public string ext { get; set; }
        /// <summary>
        /// 项目名称
        /// </summary>
        [StringLength(255)]
        [Comment("项目名称")]
        public string project_name { get; set; }
        /// <summary>
        /// 发料状态 1-待发料  2-已发料
        /// </summary>
        [Comment("发料状态 1-待发料  2-已发料")]
        public int? sent_status { get; set; }
        /// <summary>
        /// 加工单位
        /// </summary>
        [StringLength(100)]
        [Comment("加工单位")]
        public string production_unit { get; set; }
        /// <summary>
        /// 加工单位编码
        /// </summary>
        [StringLength(20)]
        [Comment("加工单位编码")]
        public string production_unit_code { get; set; }
        /// <summary>
        /// 所需物料是否充足  1-充足 0-缺料
        /// </summary>
        [Comment("所需物料是否充足  1-充足 0-缺料")]
        public int? need_icitem_status { get; set; }

        /// <summary>
        /// 计算ID
        /// </summary>
        [Comment("计算id")]
        [NotMapped]
        public long? bang_id { get; set; }

        /// <summary>
        /// 订单行id
        /// </summary>
        [Comment("订单行id")]
        public long? sentry_id { get; set; }
    }
}