DEMOMySql/MicroServices/Business/Business.Domain/StructuredDB/Bang/b_order_detail.cs

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

namespace Business.Domain
{
    /// <summary>
    /// 物料齐套明细
    /// </summary>
    [CollectionName("dopbase", "b_order_detail")]
    [Comment("物料齐套明细")]
    public class b_order_detail : BaseEntity
    {
        /// <summary>
        /// 工单齐套检查id
        /// </summary>
        [Comment("工单齐套检查id")]
        public long? order_examine_id { get; set; }

        /// <summary>
        /// 本级id
        /// </summary>
        [Comment("本级id")]
        public long fid { get; set; }

        /// <summary>
        /// 父级
        /// </summary>
        [Comment("父级")]
        public long? parent_id { get; set; }

        /// <summary>
        /// 物料id
        /// </summary>
        [Comment("物料id")]
        public long? item_id { get; set; }

        /// <summary>
        /// bom编号
        /// </summary>
        [Comment("bom编号")]
        public string bom_number { get; set; }

        /// <summary>
        /// 物料编号
        /// </summary>
        [Comment("物料编号")]
        public string item_number { get; set; }

        /// <summary>
        /// 物料名称
        /// </summary>
        [Comment("物料名称")]
        public string item_name { get; set; }

        /// <summary>
        /// 项次号
        /// </summary>
        [Comment("项次号")]
        [StringLength(50)]
        public string num { get; set; }

        /// <summary>
        /// 排序使用
        /// </summary>
        [Comment("排序使用")]
        public long? num_order { get; set; }

        /// <summary>
        /// 用量
        /// </summary>
        [Comment("用量")]
        [Precision(23, 10)]
        public decimal? qty { get; set; }

        /// <summary>
        /// 本级缺料数量
        /// </summary>
        [Comment("本级缺料数量")]
        [Precision(23, 10)]
        public decimal? self_lack_qty { get; set; }

        /// <summary>
        /// 库存数量
        /// </summary>
        [Comment("库存数量")]
        [Precision(23, 10)]
        public decimal? sqty { get; set; }

        /// <summary>
        /// 库存占用数量
        /// </summary>
        [Comment("库存占用数量")]
        [Precision(23, 10)]
        public decimal? use_qty { get; set; }

        /// <summary>
        /// 在制占用数量
        /// </summary>
        [Comment("在制占用数量")]
        [Precision(23, 10)]
        public decimal? mo_qty { get; set; }

        /// <summary>
        /// 自制数量
        /// </summary>
        [Comment("自制数量")]
        [Precision(23, 10)]
        public decimal? make_qty { get; set; }

        /// <summary>
        /// 采购数量
        /// </summary>
        [Comment("采购数量")]
        [Precision(23, 10)]
        public decimal? purchase_qty { get; set; }

        /// <summary>
        /// 采购明细占用数量
        /// </summary>
        [Comment("采购明细占用数量")]
        [Precision(23, 10)]
        public decimal? purchase_occupy_qty { get; set; }

        /// <summary>
        /// 委外数量
        /// </summary>
        [Comment("委外数量")]
        [Precision(23, 10)]
        public decimal? subcontracting_qty { get; set; }

        /// <summary>
        /// 齐套时间
        /// </summary>
        [Comment("齐套时间")]
        public DateTime? kitting_time { get; set; }

        /// <summary>
        /// 群组代码
        /// </summary>
        [Comment("群组代码")]
        public string substitute_code { get; set; }

        /// <summary>
        /// 替代策略
        /// </summary>
        [Comment("替代策略")]
        public int? substitute_strategy { get; set; }

        /// <summary>
        /// 替代方式
        /// </summary>
        [Comment("替代方式")]
        public int? substitute_mode { get; set; }

        /// <summary>
        /// 是否使用此物料
        /// </summary>
        [Comment("是否使用此物料")]
        public bool? is_use { get; set; }
    }
}