using Magicodes.ExporterAndImporter.Core;
using OfficeOpenXml.FormulaParsing.Excel.Functions.Numeric;
using SqlSugar;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using WIDESEAWCS_Core.DB.Models;
using Magicodes.IE.Core;
namespace WIDESEAWCS_Model.Models
{
    [SugarTable(nameof(Dt_Formula), "配方信息表")]
    public class Dt_Formula : BaseEntity
    {
        /// <summary>
        /// 主键
        /// </summary>
        /// 
        [ImporterHeader(IsIgnore = true)]
        [ExporterHeader(null, 11f, null, true, true, false, 0, KnownColor.Empty, DisplayName = "主键")]
        [SugarColumn(IsPrimaryKey = true, IsIdentity = true, ColumnDescription = "主键")]
        public int Id { get; set; }

        /// <summary>
        /// 成品编号
        /// </summary>
        /// 
        [ImporterHeader(Name = "成品编号")]
        [ExporterHeader(null, 11f, null, true, true, false, 0, KnownColor.Empty, DisplayName = "成品编号")]
        [SugarColumn(IsNullable = true, Length = 50, ColumnDescription = "成品编号")]
        public string ProductCode { get; set; }

        /// <summary>
        /// 成品名称
        /// </summary>
        [ImporterHeader(Name = "成品名称")]
        [ExporterHeader(null, 11f, null, true, true, false, 0, KnownColor.Empty, DisplayName = "成品名称")]
        [SugarColumn(IsNullable = false, Length = 50, ColumnDescription = "成品名称")]
        public string ProductName { get; set; }

        /// <summary>
        /// 压装位产品长度
        /// </summary>
        [ImporterHeader(Name = "产品长度")]
        [ExporterHeader(null, 11f, null, true, true, false, 0, KnownColor.Empty, DisplayName = "产品长度")]
        [SugarColumn(IsNullable = true, DecimalDigits = 2, ColumnDescription = "压装位产品长度")]
        public decimal? ProductLength { get; set; }

        /// <summary>
        /// 压装位产品宽度
        /// </summary>
        [ImporterHeader(Name = "产品宽度")]
        [ExporterHeader(null, 11f, null, true, true, false, 0, KnownColor.Empty, DisplayName = "产品宽度")]
        [SugarColumn(IsNullable = true, DecimalDigits = 2, ColumnDescription = "压装位产品宽度")]
        public decimal? ProductWidth { get; set; }

        /// <summary>
        /// 压装位产品高度
        /// </summary>
        [ImporterHeader(Name = "产品高度")]
        [ExporterHeader(null, 11f, null, true, true, false, 0, KnownColor.Empty, DisplayName = "产品高度")]
        [SugarColumn(IsNullable = true, DecimalDigits = 2, ColumnDescription = "压装位产品高度")]
        public decimal? ProductHeight { get; set; }

        /// <summary>
        /// 压装位不拧紧
        /// </summary>
        [ImporterHeader(Name = "不拧紧")]
        [ExporterHeader(null, 11f, null, true, true, false, 0, KnownColor.Empty, DisplayName = "不拧紧")]
        [SugarColumn(IsNullable = true, DefaultValue = "0", ColumnDescription = "压装位不拧紧")]
        public int? PressNoTighten { get; set; }

        /// <summary>
        /// 压装位不测底板
        /// 0-检测 1-不检测
        /// </summary>
        [ImporterHeader(Name = "不测底板")]
        [ExporterHeader(null, 11f, null, true, true, false, 0, KnownColor.Empty, DisplayName = "不测底板")]
        [SugarColumn(IsNullable = true, DefaultValue = "0", ColumnDescription = "压装位不测底板")]
        public int? PressNoCheckBottomPlate { get; set; }

        /// <summary>
        /// 保压压力
        /// </summary>
        [ImporterHeader(Name = "保压压力")]
        [ExporterHeader(null, 11f, null, true, true, false, 0, KnownColor.Empty, DisplayName = "保压压力")]
        [SugarColumn(IsNullable = true, DecimalDigits = 2, ColumnDescription = "保压压力")]
        public decimal? ScrewDownsetDistance { get; set; }

        /// <summary>
        /// 中心高度
        /// </summary>
        [ImporterHeader(Name = "中心高度")]
        [ExporterHeader(null, 11f, null, true, true, false, 0, KnownColor.Empty, DisplayName = "中心高度")]
        [SugarColumn(IsNullable = true, DecimalDigits = 2, ColumnDescription = "中心高度")]
        public decimal? ScrewTorqueOutput { get; set; }

        /// <summary>
        /// 压装位自动拧紧程序号
        /// </summary>
        [ImporterHeader(Name = "自动拧紧程序号")]
        [ExporterHeader(null, 11f, null, true, true, false, 0, KnownColor.Empty, DisplayName = "自动拧紧程序号")]
        [SugarColumn(IsNullable = true, ColumnDescription = "压装位自动拧紧程序号")]
        public int? DintAutoScrewOn { get; set; }

        /// <summary>
        /// 压装位紧固扭矩
        /// </summary>
        [ImporterHeader(Name = "紧固扭矩")]
        [ExporterHeader(null, 11f, null, true, true, false, 0, KnownColor.Empty, DisplayName = "紧固扭矩")]
        [SugarColumn(IsNullable = true, DecimalDigits = 2, ColumnDescription = "压装位紧固扭矩", DefaultValue = "0.00")]
        public decimal? PressFastenTorque { get; set; }

        /// <summary>
        /// P0P1宽度
        /// </summary>
        [ImporterHeader(Name = "P0P1宽度")]
        [ExporterHeader(null, 11f, null, true, true, false, 0, KnownColor.Empty, DisplayName = "P0P1宽度")]
        [SugarColumn(IsNullable = true, DecimalDigits = 2, ColumnDescription = "P0P1宽度")]
        public decimal? P0P1Width { get; set; }

        /// <summary>
        /// P0P2宽度
        /// </summary>
        [ImporterHeader(Name = "P0P2宽度")]
        [ExporterHeader(null, 11f, null, true, true, false, 0, KnownColor.Empty, DisplayName = "P0P2宽度")]
        [SugarColumn(IsNullable = true, DecimalDigits = 2, ColumnDescription = "P0P2宽度")]
        public decimal? P0P2Width { get; set; }

        /// <summary>
        /// P0P3宽度
        /// </summary>
        [ImporterHeader(Name = "P0P3宽度")]
        [ExporterHeader(null, 11f, null, true, true, false, 0, KnownColor.Empty, DisplayName = "P0P3宽度")]
        [SugarColumn(IsNullable = true, DecimalDigits = 2, ColumnDescription = "P0P3宽度")]
        public decimal? P0P3Width { get; set; }

        /// <summary>
        /// 垫片高度
        /// </summary>
        [ImporterHeader(Name = "垫片高度")]
        [ExporterHeader(null, 11f, null, true, true, false, 0, KnownColor.Empty, DisplayName = "垫片高度")]
        [SugarColumn(IsNullable = true, DecimalDigits = 2, ColumnDescription = "垫片高度")]
        public decimal? GasketHeight { get; set; }


        /// <summary>
        /// 压装压力差值
        /// </summary>
        [ImporterHeader(Name = "压力差值")]
        [ExporterHeader(null, 11f, null, true, true, false, 0, KnownColor.Empty, DisplayName = "压力差值")]
        [SugarColumn(IsNullable = true, DecimalDigits = 2, ColumnDescription = "压装压力差值")]
        public decimal? PressPressureDiff { get; set; }

        /// <summary>
        /// 压装扭力差值
        /// </summary>
        [ImporterHeader(Name = "扭力差值")]
        [ExporterHeader(null, 11f, null, true, true, false, 0, KnownColor.Empty, DisplayName = "扭力差值")]
        [SugarColumn(IsNullable = true, DecimalDigits = 2, ColumnDescription = "压装扭力差值")]
        public decimal? PressTorqueDiff { get; set; }

        /// <summary>
        /// 检测高度差值
        /// </summary>
        [ImporterHeader(Name = "高度差值")]
        [ExporterHeader(null, 11f, null, true, true, false, 0, KnownColor.Empty, DisplayName = "高度差值")]
        [SugarColumn(IsNullable = true, DecimalDigits = 2, ColumnDescription = "检测高度差值")]
        public decimal? DetectHeightDiff { get; set; }

        /// <summary>
        /// 螺纹位置差值
        /// </summary>
        [ImporterHeader(Name = "螺纹差值")]
        [ExporterHeader(null, 11f, null, true, true, false, 0, KnownColor.Empty, DisplayName = "螺纹差值")]
        [SugarColumn(IsNullable = true, DecimalDigits = 2, ColumnDescription = "螺纹位置差值")]
        public decimal? ScrewPositionDiff { get; set; }

        [SugarColumn(IsIgnore = true)]//不参与数据库映射，测试使用
        [Navigate(NavigateType.OneToMany, nameof(Dt_FormulaDetail.FormulaId), nameof(Id))]
        public List<Dt_FormulaDetail> Details { get; set; }

    }
}