DEMOMySql/MicroServices/Business/Business.Domain/StructuredDB/Replenishment/ReplenishmentWeekPlan.cs

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
{

    /// <summary>
    ///  周生产计划    
    /// </summary>
    public class ReplenishmentWeekPlan : BaseEntity
    {
        /// <summary>
        /// 排序编码(优先级)    
        /// </summary>
        [Comment("排序编码(优先级)")]
        [Precision(18,5)]
        public decimal Priority { get; set; }

        /// <summary>
        /// 市场    
        /// </summary>
        [StringLength(128)]
        [Comment("市场")]
        public string? Area { get; set; }

        /// <summary>
        /// 开工日期
        /// </summary>
        [Comment("开工日期")]
        public DateTime? PlanStartDate { get; set; }

        /// <summary>
        /// 开工日期星期
        /// </summary>
        [StringLength(128)]
        [Comment("开工日期星期")]
        public string? Week { get; set; }

        /// <summary>
        /// 计算星期(标识已经计算的周次)
        /// </summary>
        [StringLength(128)]
        [Comment("计算星期")]
        public string? CalcWeek { get; set; }

        /// <summary>
        /// 订单号
        /// </summary>
        [StringLength(128)]
        [Comment("订单号")]
        public string? OrderNO { get; set; }

        /// <summary>
        /// 生产指令
        /// </summary>
        [StringLength(128)]
        [Comment("生产指令")]
        public string? ProductionOrder { get; set; }

        /// <summary>
        /// SAP工单号
        /// </summary>
        [StringLength(128)]
        [Comment("SAP工单号")]
        public string? SAPOrderNO { get; set; }


        /// <summary>
        /// 指令类型
        /// </summary>
        [StringLength(128)]
        [Comment("指令类型")]
        public string OrderType { get; set; }

        /// <summary>
        /// 生产批次
        /// </summary>
        [StringLength(128)]
        [Comment("生产批次")]
        public string? ProductionBatch { get; set; }

        /// <summary>
        /// 发布状态
        /// </summary>
        [StringLength(128)]
        [Comment("发布状态")]
        public string? ProductionStatus { get; set; }

        /// <summary>
        /// 产品线    
        /// </summary>
        [StringLength(128)]
        [Comment("产品线")]
        public string? ProdLine { get; set; }

        /// <summary>
        /// 产品系列    
        /// </summary>
        [StringLength(128)]
        [Comment("产品系列")]
        public string? ProdRange { get; set; }

        /// <summary>
        /// 车间线体(产线)    
        /// </summary>
        [StringLength(128)]
        [Comment("车间线体(产线)")]
        public string? Line { get; set; }

        /// <summary>
        /// 物料编码   
        /// </summary>
        [StringLength(128)]
        [Comment("物料编码")]
        public string ItemNumber { get; set; }

        /// <summary>
        /// 规格型号    
        /// </summary>
        [StringLength(128)]
        [Comment("规格型号")]
        public string? Model { get; set; }

        /// <summary>
        /// 语种    
        /// </summary>
        [StringLength(128)]
        [Comment("语种")]
        public string? Languages { get; set; }

        /// <summary>
        /// 计划数量    
        /// </summary>
        [Precision(18,5)]
        [Comment("计划数量")]
        public decimal Qty { get; set; }

        /// <summary>
        /// 物料情况    
        /// </summary>
        [StringLength(128)]
        [Comment("物料情况")]
        public string? ItemStatus { get; set; }

        /// <summary>
        /// 预计齐套时间    
        /// </summary>
        [Precision(18, 5)]
        [Comment("预计齐套时间")]
        public DateTime? PlanKittingDate { get; set; }

        /// <summary>
        /// 灭菌开始日期    
        /// </summary>
        [Precision(18, 5)]
        [Comment("灭菌开始日期")]
        public DateTime? SterilizationDate { get; set; }


        /// <summary>
        /// 成品入库日期    
        /// </summary>
        [Precision(18, 5)]
        [Comment("成品入库日期")]
        public DateTime? InStockDate { get; set; }

        /// <summary>
        /// 组装工时    
        /// </summary>
        [Precision(18, 5)]
        [Comment("组装工时")]
        public decimal AssembleHours { get; set; }

        /// <summary>
        /// 热封工时    
        /// </summary>
        [Precision(18, 5)]
        [Comment("热封工时")]
        public decimal HeatSealHours { get; set; }

        /// <summary>
        /// 包装工时    
        /// </summary>
        [Precision(18, 5)]
        [Comment("包装工时")]
        public decimal PackageHours { get; set; }

        /// <summary>
        /// 总工时    
        /// </summary>
        [Precision(18, 5)]
        [Comment("包装工时")]
        public decimal TotalHours { get; set; }

        /// <summary>
        /// 销售/渠道   
        /// </summary>
        public string DistributionChannel { get; set; }

        /// <summary>
        /// 是否为周补货计划，Y/N
        /// </summary>
        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; }

        /// <summary>
        /// 父计划id   
        /// </summary>
        public string ParentIds { get; set; }

        /// <summary>
        /// 父物料总需求数    
        /// </summary>
        [Precision(18, 5)]
        [Comment("父物料总需求数")]
        public decimal? ParentNeedCount { get; set; }

        /// <summary>
        /// 总库存    
        /// </summary>
        [Precision(18, 5)]
        [Comment("总库存")]
        public decimal? StokcQty { get; set; }

        /// <summary>
        /// 总在制    
        /// </summary>
        [Precision(18, 5)]
        [Comment("总在制")]
        public decimal? ProdcutQty { get; set; }
    }
}