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; }
}
}