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

        /// <summary>
        /// 计算ID
        /// </summary>
        [Comment("计算id")]
        [NotMapped]
        public long? bang_id { get; set; }
        /// <summary>
        /// 自检提前期
        /// </summary>
        [Precision(20, 8)]
        [Comment("自检提前期")]
        public decimal? self_inspection_date { get; set; }
        /// <summary>
        /// 入库提前期
        /// </summary>
        [Precision(20, 8)]
        [Comment("入库提前期")]
        public decimal? Warehousing_date { get; set; }
        /// <summary>
        /// 发运提前期
        /// </summary>
        [Precision(20, 8)]
        [Comment("发运提前期")]
        public decimal? Shipping_date { get; set; }
    }
}