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