DEMOMySql/MicroServices/Business/Bussiness.Model/Production/mes_morder.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.Linq;
using System.Text;
using System.Threading.Tasks;
using Volo.Abp;

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