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

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.Model.MES.IC
{
    /// <summary>
    /// 标准BOM表
    /// </summary>
    public class ProductStructureMaster
    {
        /// <summary>
        /// 主键
        /// </summary>
        [Comment("主键")]
        [Key]
        public int RecID { get; set; }

        /// <summary>
        /// 域名
        /// </summary>
        [Comment("域名")]
        public string? Domain { get; set; }

        /// <summary>
        /// 父零件
        /// </summary>
        [Comment("父零件")]
        public string ParentItem { get; set; }

        /// <summary>
        /// 子零件
        /// </summary>
        [Comment("子零件")]
        public string ComponentItem { get; set; }

        /// <summary>
        /// 结构类型:X-虚拟件，需要通过ComponentItem查询其子级
        /// </summary>
        [Comment("结构类型")]
        public string? StructureType { get; set; }

        /// <summary>
        /// 工序
        /// </summary>
        [Comment("工序")]
        public int Op { get; set; }

        /// <summary>
        /// 数量
        /// </summary>
        [Comment("数量")]
        public decimal Qty { get; set; }

        /// <summary>
        /// 序列号
        /// </summary>
        [Comment("序列号")]
        public int SequenceNum { get; set; }

        /// <summary>
        /// 开始生效
        /// </summary>
        [Comment("开始生效")]
        public DateTime? StartEff { get; set; }


        /// <summary>
        /// 终止生效
        /// </summary>
        [Comment("终止生效")]
        public DateTime? EndEff { get; set; }


        /// <summary>
        /// 版本
        /// </summary>
        [Comment("版本")]
        public string? Refs { get; set; }

        /// <summary>
        /// 单位
        /// </summary>
        [Comment("单位")]
        public string? UM { get; set; }

        /// <summary>
        /// 是否有效：1-有效；0-无效
        /// </summary>
        [Comment("是否有效")]
        public Boolean IsActive { get; set; }
    }
}