DEMOMySql/MicroServices/Business/Business.Domain/StructuredDB/Production/WorkOrdDetail.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.Domain
{
    /// <summary>
    /// 工单物料明细表
    /// </summary>
    [Comment("工单物料明细表")]
    public class WorkOrdDetail
    {
        /// <summary>
        /// 主键
        /// </summary>
        [Comment("主键")]
        [Key]
        public int RecID { get; set; }

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

        /// <summary>
        /// 租户ID
        /// </summary>
        [Comment("租户ID")]
        public long? tenant_id { get; set; }

        /// <summary>
        /// 工单
        /// </summary>
        [Comment("工单")]
        public string WorkOrd { get; set; }

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

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

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

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

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

        /// <summary>
        /// 冻结BOM数量
        /// </summary>
        [Comment("冻结BOM数量")]
        public decimal FrozenBOMQty { get; set; }

        /// <summary>
        /// 状态：C为不可用状态
        /// </summary>
        [Comment("状态")]
        public string Status { get; set; }

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

        /// <summary>
        /// 创建时间
        /// </summary>
        [Comment("创建时间")]
        public DateTime? CreateTime { get; set; }

        /// <summary>
        /// 批次序列
        /// </summary>
        [Comment("批次序列")]
        public string LotSerial { get; set; }

        /// <summary>
        /// 工单主键
        /// </summary>
        [Comment("工单主键")]
        public long WorkOrdMasterRecID { get; set; }

        /// <summary>
        /// 损耗率
        /// </summary>
        [Comment("损耗率")]
        public decimal Yield { get; set; }

        /// <summary>
        /// 序号
        /// </summary>
        [Comment("序号")]
        public short Line { get; set; }

        /// <summary>
        /// 库位
        /// </summary>
        [Comment("库位")]
        public string Location { get; set; }

        /// <summary>
        /// 更新时间
        /// </summary>
        [Comment("更新时间")]
        public DateTime? UpdateTime { get; set; }

        /// <summary>
        ///更新用户
        /// </summary>
        [Comment("更新用户")]
        public string UpdateUser { get; set; }
    }
}