DEMOMySql/MicroServices/Business/Bussiness.Model/Production/mes_oorder.cs

using Business.Core.Attributes;
using Business.Model;
using Microsoft.EntityFrameworkCore;
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace Bussiness.Model.Production
{
    /// <summary>
    /// 委外订单表
    /// </summary>
    [CollectionName("dopbase", "mes_oorder")]
    public class mes_oorder : BaseEntity
    {
        ///// <summary>
        ///// 委外订单id
        ///// </summary>
        //[Key]
        //[Description("委外订单id")]
        //public long oorder_id { get; set; }
        /// <summary>
        /// 生产工单编号
        /// </summary>
        [StringLength(50)]
        [Description("生产工单编号")]
        public string? oorder_no { get; set; }
        /// <summary>
        /// 生产工单类型
        /// </summary>
        [StringLength(80)]
        [Description("生产工单类型")]
        public string? oorder_type { get; set; }
        /// <summary>
        /// 委外订单日期
        /// </summary>
        [Description("委外订单日期")]
        public DateTime? oorder_date { get; set; }
        /// <summary>
        /// 订单状态
        /// </summary>
        [StringLength(50)]
        [Description("订单状态")]
        public string? oorder_state { get; set; }
        /// <summary>
        /// 生产组织
        /// </summary>
        [Description("生产组织")]
        public long? ooentry_prd { get; set; }
        /// <summary>
        /// 生产组织名称
        /// </summary>
        [StringLength(50)]
        [Description("生产组织名称")]
        public string? ooentry_prdname { get; set; }
        /// <summary>
        /// 工作中心id
        /// </summary>
        [Description("工作中心id")]
        public long? ooentry_wrkc { get; set; }
        /// <summary>
        /// 工作中心名称
        /// </summary>
        [StringLength(50)]
        [Description("工作中心名称")]
        public string? ooentry_wrkcname { get; set; }
        /// <summary>
        /// 计划员工号
        /// </summary>
        [StringLength(80)]
        [Description("计划员工号")]
        public string? planner_num { get; set; }
        /// <summary>
        /// 计划员名称
        /// </summary>
        [StringLength(80)]
        [Description("计划员名称")]
        public string? planner_name { get; set; }
        /// <summary>
        /// 计划开工日期
        /// </summary>
        [Description("计划开工日期")]
        public DateTime? ooentry_stime { get; set; }
        /// <summary>
        /// 计划完工日期
        /// </summary>
        [Description("计划完工日期")]
        public DateTime? ooentry_etime { get; set; }
        /// <summary>
        /// 产品代码
        /// </summary>
        [StringLength(80)]
        [Description("产品代码")]
        public string? product_code { get; set; }
        /// <summary>
        /// fms旧料号
        /// </summary>
        [StringLength(80)]
        [Description("fms旧料号")]
        public string? ffms_number { get; set; }
        /// <summary>
        /// 产品名称
        /// </summary>
        [StringLength(500)]
        [Description("产品名称")]
        public string? product_name { get; set; }
        /// <summary>
        /// 规格型号
        /// </summary>
        [StringLength(500)]
        [Description("规格型号")]
        public string? specification_model { get; set; }
        /// <summary>
        /// bom编码
        /// </summary>
        [StringLength(80)]
        [Description("bom编码")]
        public string? bom_number { get; set; }
        /// <summary>
        /// 单位
        /// </summary>
        [StringLength(80)]
        [Description("单位")]
        public string? unit { get; set; }
        /// <summary>
        /// 工单进度
        /// </summary>
        [StringLength(500)]
        [Description("工单进度")]
        public string? morder_progress { get; set; }
        /// <summary>
        /// 工单生产数量(计划数量)
        /// </summary>
        [Precision(20, 10)]
        [Description("工单生产数量(计划数量)")]
        public decimal? morder_production_number { get; set; }
        /// <summary>
        /// 需求数量
        /// </summary>
        [Precision(20, 10)]
        [Description("需求数量")]
        public decimal? need_number { get; set; }
        /// <summary>
        /// 剩余可用数量
        /// </summary>
        [Precision(20, 10)]
        [Description("剩余可用数量")]
        public decimal? remaining_number { get; set; }
        /// <summary>
        /// 报工数量
        /// </summary>
        [Precision(20, 8)]
        [Description("报工数量")]
        public decimal? work_number { get; set; }
        /// <summary>
        /// 报检数量
        /// </summary>
        [Precision(20, 8)]
        [Description("报检数量")]
        public decimal? inspection_number { get; set; }
        /// <summary>
        /// 合格数量
        /// </summary>
        [Precision(20, 8)]
        [Description("合格数量")]
        public decimal? qualified_number { get; set; }
        /// <summary>
        /// 入库数量
        /// </summary>
        [Precision(20, 8)]
        [Description("入库数量")]
        public decimal? inventory_number { get; set; }
        /// <summary>
        /// 已开通知单数量
        /// </summary>
        [Precision(20, 8)]
        [Description("已开通知单数量")]
        public decimal? notice_qty { get; set; }
        /// <summary>
        /// 启动状态
        /// </summary>
        [Description("启动状态")]
        public int? moentry_on { get; set; }
        /// <summary>
        /// 开始时间
        /// </summary>
        [Description("开始时间")]
        public DateTime? start_time { get; set; }
        /// <summary>
        /// 最近暂停时间
        /// </summary>
        [Description("最近暂停时间")]
        public DateTime? pause_time { get; set; }
        /// <summary>
        /// 最近重启时间
        /// </summary>
        [Description("最近重启时间")]
        public DateTime? restart_time { get; set; }
        ///// <summary>
        ///// 扩展
        ///// </summary>
        //public string ext { get; set; }
        /// <summary>
        /// 项目名称
        /// </summary>
        [StringLength(255)]
        [Description("项目名称")]
        public string? project_name { get; set; }
        /// <summary>
        /// 发料状态 1-待发料  2-已发料
        /// </summary>
        [Description("发料状态 1-待发料  2-已发料")]
        public int? sent_status { get; set; }
        /// <summary>
        /// 加工单位
        /// </summary>
        [StringLength(100)]
        [Description("加工单位")]
        public string? production_unit { get; set; }
        /// <summary>
        /// 加工单位编码
        /// </summary>
        [StringLength(20)]
        [Description("加工单位编码")]
        public string? production_unit_code { get; set; }
        /// <summary>
        /// 所需物料是否充足  1-充足 0-缺料
        /// </summary>
        [Description("所需物料是否充足  1-充足 0-缺料")]
        public int? need_icitem_status { get; set; }

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