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

using Business.Models;
using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Volo.Abp;

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