DEMOMySql/MicroServices/Business/Bussiness.Model/MES/IC/ic_plan.cs

using Business.Core.Attributes;
using Business.Model;
using Microsoft.EntityFrameworkCore;
using System.ComponentModel;
using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;

namespace Bussiness.Model.MES.IC
{
    /// <summary>
    /// 物料采购计划表
    /// </summary>
    [CollectionName("dopbase", "ic_plan")]
    public class ic_plan : BaseEntity
    {
        /// <summary>
        /// 物料id
        /// </summary>
        [Required]
        [Description("物料id")]
        public long icitem_id { get; set; }
        /// <summary>
        /// 物料名称
        /// </summary>
        [StringLength(80)]
        [Description("物料名称")]
        public string? icitem_name { get; set; }
        /// <summary>
        /// 计划员
        /// </summary>
        [StringLength(80)]
        [Description("计划员")]
        public string? planner_name { get; set; }
        /// <summary>
        /// 计划员_工号
        /// </summary>
        [StringLength(80)]
        [Description("计划员_工号")]
        public string? planner_num { get; set; }
        /// <summary>
        /// 工厂编码
        /// </summary>
        [StringLength(80)]
        [Description("工厂编码")]
        public string? factory_code { get; set; }
        /// <summary>
        /// 固定提前期(天)
        /// </summary>
        [Precision(20, 8)]
        [Description("固定提前期(天)")]
        public decimal? fix_leadtime { get; set; }
        /// <summary>
        /// 计划策略
        /// </summary>
        [Description("计划策略")]
        public int plan_trategy { get; set; }
        /// <summary>
        /// 订货策略
        /// </summary>
        [Description("订货策略")]
        public int order_trategy { get; set; }
        /// <summary>
        /// 订货间隔期_天
        /// </summary>
        [Precision(20, 8)]
        [Description("订货间隔期_天")]
        public decimal? order_inter_val { get; set; }
        /// <summary>
        /// 变动提前期
        /// </summary>
        [Precision(20, 8)]
        [Description("变动提前期")]
        public decimal? lead_time { get; set; }
        /// <summary>
        /// 变动提前期批量
        /// </summary>
        [Precision(20, 8)]
        [Description("变动提前期批量")]
        public decimal? bat_change_economy { get; set; }
        /// <summary>
        /// 累计提前期
        /// </summary>
        [Precision(20, 8)]
        [Description("累计提前期")]
        public decimal? total_tqq { get; set; }
        /// <summary>
        /// 再订货点
        /// </summary>
        [StringLength(80)]
        [Description("再订货点")]
        public string? order_point { get; set; }
        /// <summary>
        /// 设置为固定再订货点
        /// </summary>
        [Description("设置为固定再订货点")]
        public int isfixedreorder { get; set; }
        /// <summary>
        /// 安全库存数量
        /// </summary>
        [Precision(20, 8)]
        [Description("安全库存数量")]
        public decimal? secinv { get; set; }
        /// <summary>
        /// 安全库存触发采购比例
        /// </summary>
        [Precision(20, 8)]
        [Description("安全库存触发采购比例")]
        public decimal? secinv_ratio { get; set; }
        /// <summary>
        /// 是否需要进行订补货计划的运算
        /// </summary>
        [Description("是否需要进行订补货计划的运算")]
        public int book_plan { get; set; }
        /// <summary>
        /// 辅助属性参与计划运算
        /// </summary>
        [Description("辅助属性参与计划运算")]
        public int aux_prop_plan { get; set; }
        /// <summary>
        /// 计划备注
        /// </summary>
        [StringLength(1000)]
        [Description("计划备注")]
        public string? plannote { get; set; }

        /// <summary>
        /// 计算ID
        /// </summary>
        [Description("计算id")]
        [NotMapped]
        public long? bang_id { get; set; }
    }
}