DEMOMySql/MicroServices/Business/Business.Domain/StructuredDB/SaleFcst/MonthlyProdCapacity.cs

using Microsoft.EntityFrameworkCore;
using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations.Schema;
using System.ComponentModel.DataAnnotations;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace Business.Domain
{
    /// <summary>
    /// 月度产能共识主表
    /// </summary>
    [Comment("月度产能共识主表")]
    [Index(nameof(Year), nameof(Month),nameof(PlanMonth), nameof(ProdLine), nameof(tenant_id),nameof(company_id), nameof(factory_id), IsUnique = true)]
    public class MonthlyProdCapacity:BaseEntity
    {

        /// <summary>
        /// 年
        /// </summary>
        [Comment("年")]
        public int? Year { get; set; }

        /// <summary>
        /// 月
        /// </summary>
        [Comment("月")]
        public int? Month { get; set; }

        /// <summary>
        /// 计划年月
        /// </summary>
        [Comment("计划年月")]
        public string PlanMonth { get; set; }

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

        /// <summary>
        /// 日工作时间(小时)
        /// </summary>
        [Comment("日工作时间(小时)")]
        public decimal DailyWorks { get; set; }

        /// <summary>
        /// 月工作天数(天)
        /// </summary>
        [Comment("月工作天数(天)")]
        public decimal MonthWorks { get; set; }

        /// <summary>
        /// 班次数
        /// </summary>
        [Comment("班次数")]
        public int FlightQty { get; set; }

        /// <summary>
        /// 月度可利用工作时间(小时)
        /// </summary>
        [Comment("月度可利用工作时间(小时)")]
        public decimal AvailableTimes { get; set; }

        /// <summary>
        /// 月度需求工作时间(小时)
        /// </summary>
        [Comment("月度需求工作时间(小时)")]
        public decimal NeedWorks { get; set; }

        /// <summary>
        /// 排产效率
        /// </summary>
        [Comment("排产效率")]
        public decimal ProdRate { get; set; }

        /// <summary>
        /// 产线标准产能符合率
        /// </summary>
        [Comment("产线标准产能符合率")]
        public decimal Rate { get; set; }

        /// <summary>
        /// 是否加班:是，否
        /// </summary>
        [Comment("是否加班")]
        public string IsOverTime { get; set; }

        /// <summary>
        /// 加班工时
        /// </summary>
        [Comment("加班工时")]
        public decimal OverTimes { get; set; }
    }
}