using Business.Domain; 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.StructuredDB.Replenishment { /// /// 周生产计划 /// public class ReplenishmentWeekPlan : BaseEntity { /// /// 排序编码(优先级) /// [Comment("排序编码(优先级)")] [Precision(18,5)] public decimal Priority { get; set; } /// /// 市场 /// [StringLength(128)] [Comment("市场")] public string? Area { get; set; } /// /// 开工日期 /// [Comment("开工日期")] public DateTime? PlanStartDate { get; set; } /// /// 开工日期星期 /// [StringLength(128)] [Comment("开工日期星期")] public string? Week { get; set; } /// /// 计算星期(标识已经计算的周次) /// [StringLength(128)] [Comment("计算星期")] public string? CalcWeek { get; set; } /// /// 订单号 /// [StringLength(128)] [Comment("订单号")] public string? OrderNO { get; set; } /// /// 生产指令 /// [StringLength(128)] [Comment("生产指令")] public string? ProductionOrder { get; set; } /// /// SAP工单号 /// [StringLength(128)] [Comment("SAP工单号")] public string? SAPOrderNO { get; set; } /// /// 指令类型 /// [StringLength(128)] [Comment("指令类型")] public string OrderType { get; set; } /// /// 生产批次 /// [StringLength(128)] [Comment("生产批次")] public string? ProductionBatch { get; set; } /// /// 发布状态 /// [StringLength(128)] [Comment("发布状态")] public string? ProductionStatus { get; set; } /// /// 产品线 /// [StringLength(128)] [Comment("产品线")] public string? ProdLine { get; set; } /// /// 产品系列 /// [StringLength(128)] [Comment("产品系列")] public string? ProdRange { get; set; } /// /// 车间线体(产线) /// [StringLength(128)] [Comment("车间线体(产线)")] public string? Line { get; set; } /// /// 物料编码 /// [StringLength(128)] [Comment("物料编码")] public string ItemNumber { get; set; } /// /// 规格型号 /// [StringLength(128)] [Comment("规格型号")] public string? Model { get; set; } /// /// 语种 /// [StringLength(128)] [Comment("语种")] public string? Languages { get; set; } /// /// 计划数量 /// [Precision(18,5)] [Comment("计划数量")] public decimal Qty { get; set; } /// /// 物料情况 /// [StringLength(128)] [Comment("物料情况")] public string? ItemStatus { get; set; } /// /// 预计齐套时间 /// [Precision(18, 5)] [Comment("预计齐套时间")] public DateTime? PlanKittingDate { get; set; } /// /// 灭菌开始日期 /// [Precision(18, 5)] [Comment("灭菌开始日期")] public DateTime? SterilizationDate { get; set; } /// /// 成品入库日期 /// [Precision(18, 5)] [Comment("成品入库日期")] public DateTime? InStockDate { get; set; } /// /// 组装工时 /// [Precision(18, 5)] [Comment("组装工时")] public decimal AssembleHours { get; set; } /// /// 热封工时 /// [Precision(18, 5)] [Comment("热封工时")] public decimal HeatSealHours { get; set; } /// /// 包装工时 /// [Precision(18, 5)] [Comment("包装工时")] public decimal PackageHours { get; set; } /// /// 总工时 /// [Precision(18, 5)] [Comment("包装工时")] public decimal TotalHours { get; set; } /// /// 销售/渠道 /// public string DistributionChannel { get; set; } /// /// 是否为周补货计划,Y/N /// public string IsReplenishmentModel { get; set; } //周生产计划的年 public int? Year { get; set; } //周生产计划的月份 public int? Month { get; set; } //周生产计划在月份中的周次,0,1,2,3 public int? WeekSeq { get; set; } //计划年月 public string? PlanMonth { get; set; } /// /// 父计划id /// public string ParentIds { get; set; } /// /// 父物料总需求数 /// [Precision(18, 5)] [Comment("父物料总需求数")] public decimal? ParentNeedCount { get; set; } /// /// 总库存 /// [Precision(18, 5)] [Comment("总库存")] public decimal? StokcQty { get; set; } /// /// 总在制 /// [Precision(18, 5)] [Comment("总在制")] public decimal? ProdcutQty { get; set; } } }