DEMOMySql/MicroServices/Business/Business.Domain/StructuredDB/Production/ScheduleResultOpMaster.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 ScheduleResultOpMaster
    {
        /// <summary>
        /// 主键
        /// </summary>
        [Comment("主键")]
        [Key]
        public long RecID { get; set; }

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

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

        /// <summary>
        /// 生产线
        /// </summary>
        [Comment("生产线")]
        public string Line { get; set; }

        /// <summary>
        /// 工作中心
        /// </summary>
        [Comment("工作中心")]
        public string WorkCtr { get; set; }

        /// <summary>
        /// 工序名称
        /// </summary>
        [Comment("工序名称")]
        public string OpDescr { get; set; }

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

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

        /// <summary>
        /// 计划日期
        /// </summary>
        [Comment("计划日期")]
        public DateTime? WorkDate { get; set; }

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

        /// <summary>
        /// 换型开始时间
        /// </summary>
        [Comment("换型开始时间")]
        public DateTime? SetupStartTime { get; set; }

        /// <summary>
        /// 换型结束时间
        /// </summary>
        [Comment("换型结束时间")]
        public DateTime? SetupEndTime { get; set; }

        /// <summary>
        /// 换型时间
        /// </summary>
        [Comment("换型时间")]
        public decimal SetupTime { get; set; }

        /// <summary>
        /// 开工时间
        /// </summary>
        [Comment("开工时间")]
        public DateTime WorkStartTime { get; set; }

        /// <summary>
        /// 开工时间=开始时间+换型时间
        /// </summary>
        [Comment("开工时间")]
        public DateTime WorkActivateTime { get; set; }

        /// <summary>
        /// 结束时间
        /// </summary>
        [Comment("结束时间")]
        public DateTime WorkEndTime { get; set; }

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

        /// <summary>
        /// 厂内设备编码
        /// </summary>
        [Comment("厂内设备编码")]
        public string InternalEquipmentCode { get; set; }

        /// <summary>
        /// 排产设备数量
        /// </summary>
        [Comment("排产设备数量")]
        public int DeviceAllocationCount { get; set; }

        /// <summary>
        /// 模具类型编码
        /// </summary>
        [Comment("模具类型编码")]
        public string MoldTypeCode { get; set; }
        /// <summary>
        /// 排产模具数量
        /// </summary>
        [Comment("排产模具数量")]
        public int MoldAllocationCount { get; set; }
        /// <summary>
        /// 分配人员数量
        /// </summary>
        [Comment("分配人员数量")]
        public decimal AssignedPersonnelCount { get; set; }

        /// <summary>
        /// 分配人员工号
        /// </summary>
        [Comment("分配人员工号")]
        public string AssignedEmployeeID { get; set; }
        /// <summary>
        ///人员技能编码
        /// </summary>
        [Comment("人员技能编码")]
        public string SkillNo { get; set; }

    }
}