using Microsoft.EntityFrameworkCore; using System; using System.Collections.Generic; using System.ComponentModel.DataAnnotations; using System.Linq; using System.Text; using System.Threading.Tasks; namespace Business.Domain { /// /// 工单主表 /// [Comment("工单主表")] public class WorkOrdMaster { /// /// 主键 /// [Comment("主键")] [Key] public int RecID { get; set; } /// /// 域名 /// [Comment("域名")] public string Domain { get; set; } /// /// 计划开始日期 /// [Comment("计划开始日期")] public DateTime? OrdDate { get; set; } /// /// 计划结束日期 /// [Comment("计划结束日期")] public DateTime? DueDate { get; set; } /// /// 下达日期 /// [Comment("下达日期")] public DateTime? ReleaseDate { get; set; } /// /// 客户编号 /// [Comment("客户编号")] public string CustNo { get; set; } /// /// 工单 /// [Comment("工单")] public string WorkOrd { get; set; } /// /// ERP工单 /// [Comment("ERP工单")] public string Batch { get; set; } /// /// 物料编号 /// [Comment("物料编号")] public string ItemNum { get; set; } /// /// 订单数量 /// [Comment("订单数量")] public decimal QtyOrded { get; set; } /// /// 已完成数量 /// [Comment("已完成数量")] public decimal QtyCompleted { get; set; } /// /// 在库齐套数量 /// [Comment("在库齐套数量")] public decimal? LocationStock { get; set; } /// /// 在制数量 /// [Comment("在制数量")] public decimal? InProdcutQty { get; set; } /// /// 工序最大完成数 /// [Comment("工序最大完成数")] public decimal? OpQtyCompleted { get; set; } /// /// 工艺路线编码 /// [Comment("工艺路线编码")] public string RoutingCode { get; set; } /// /// 优先级 /// [Comment("优先级")] public decimal Priority { get; set; } /// /// 班次 /// [Comment("班次")] public short Period { get; set; } /// /// 状态:空是初始,P是发布,R为下达,W是投产,C是关闭 /// [Comment("状态")] public string Status { get; set; } /// /// 是否有效:1-有效;0-无效 /// [Comment("是否有效")] public bool IsActive { get; set; } /// /// 生产线 /// [Comment("状态")] public string ProdLine { get; set; } /// /// 确认 /// [Comment("确认")] public bool IsConfirm { get; set; } /// /// 创建时间 /// [Comment("创建时间")] public DateTime? CreateTime { get; set; } /// /// 修改时间 /// [Comment("修改时间")] public DateTime? UpdateTime { get; set; } /// /// 创建人 /// [Comment("创建人")] public string CreateUser { get; set; } /// /// 修改人 /// [Comment("修改人")] public string UpdateUser { get; set; } /// /// 类型:正常工单-空或者Null;反之则为特殊工单 /// [Comment("类型")] public string Typed { get; set; } /// /// 生产时长(小时) /// [Comment("生产时长")] public decimal LbrVar { get; set; } /// /// 正在生产的工单重新排产是否需要考虑产线准备时间:A-连续生产不需要考虑;B-日计划日期调整需要考虑 /// [Comment("生产状态")] public string JointTyped { get; set; } /// /// 流程id /// [Comment("流程id")] public long BusinessID { get; set; } public string SalesJob { get; set; } /// /// 生产批次号 /// [Comment("批次序列")] public string LotSerial { get; set; } /// /// 模拟计算版本号,不为空为年度长周期,为空为周计划 /// [Comment("模拟计算版本号,不为空为年度长周期,为空为周计划")] [StringLength(80)] public string AnalogCalcVersion { get; set; } /// /// 是否打标:1-打标;0-不达标 /// [Comment("是否打标")] public bool CreateGLforLaborVar { get; set; } /// /// 是否VMI结算 /// [Comment("是否VMI结算")] public string IssueSite { get; set; } /// /// 加急 /// [Comment("加急")] public int Urgent { get; set; } /// /// 客户优先级 /// [Comment("客户优先级")] public decimal? Class { get; set; } /// /// 优先级编号 /// [Comment("优先级编号")] public string PriorityNo { get; set; } /// /// BOM版本 /// [Comment("BOM版本")] public string Refs { get; set; } /// /// 部门 /// [Comment("部门")] public string Department { get; set; } } }