using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using OfficeOpenXml.FormulaParsing.Excel.Functions.Numeric;
using SqlSugar;
using WIDESEAWCS_Core.DB.Models;

namespace WIDESEAWCS_Model.Models
{
    [SugarTable(nameof(Dt_Formula), "配方信息表")]
    public class Dt_Formula : BaseEntity
    {
        /// <summary>
        /// 主键
        /// </summary>
        [SugarColumn(IsPrimaryKey = true, IsIdentity = true, ColumnDescription = "主键")]
        public int Id { get; set; }

        /// <summary>
        /// 成品编号
        /// </summary>
        [SugarColumn(IsNullable = false, Length = 50, ColumnDescription = "成品编号")]
        public string ProductCode { get; set; }

        /// <summary>
        /// 成品名称
        /// </summary>
        [SugarColumn(IsNullable = false, Length = 50, ColumnDescription = "成品名称")]
        public string ProductName { get; set; }

        /// <summary>
        /// 压装位产品长度
        /// </summary>
        [SugarColumn(IsNullable = true, DecimalDigits =2, ColumnDescription = "压装位产品长度")]
        public decimal ProductLength { get; set; }

        /// <summary>
        /// 压装位产品宽度
        /// </summary>
        [SugarColumn(IsNullable = true, DecimalDigits = 2, ColumnDescription = "压装位产品宽度")]
        public decimal ProductWidth { get; set; }

        /// <summary>
        /// 压装位产品高度
        /// </summary>
        [SugarColumn(IsNullable = true, DecimalDigits = 2, ColumnDescription = "压装位产品高度")]
        public decimal ProductHeight { get; set; }

        /// <summary>
        /// 压装位拧紧下降高度
        /// </summary>
        [SugarColumn(IsNullable = true, DecimalDigits = 2, ColumnDescription = "压装位拧紧下降高度")]
        public decimal ScrewDownsetDistance { get; set; }

        /// <summary>
        /// 压装位拧紧扭力
        /// </summary>
        [SugarColumn(IsNullable = true, DecimalDigits = 2, ColumnDescription = "压装位拧紧扭力")]
        public decimal ScrewTorqueOutput { get; set; }

        /// <summary>
        /// 压装位自动拧紧打开
        /// </summary>
        [SugarColumn(IsNullable = true, DecimalDigits = 2, ColumnDescription = "压装位自动拧紧打开")]
        public int DintAutoScrewOn { get; set; }

        /// <summary>
        /// 检测位X偏移距离1
        /// </summary>
        [SugarColumn(IsNullable = true, DecimalDigits = 2, ColumnDescription = "检测位X偏移距离1")]
        public decimal XDirectionDistance1 { get; set; }

        /// <summary>
        /// 检测位Z高度1
        /// </summary>
        [SugarColumn(IsNullable = true, DecimalDigits = 2, ColumnDescription = "检测位Z高度1")]
        public decimal YDirectionHeight1 { get; set; }

        /// <summary>
        /// 检测位X偏移距离2
        /// </summary>
        [SugarColumn(IsNullable = true, DecimalDigits = 2, ColumnDescription = "检测位X偏移距离2")]
        public decimal XDirectionDistance2 { get; set; }

        /// <summary>
        /// 检测位Z高度2
        /// </summary>
        [SugarColumn(IsNullable = true, DecimalDigits = 2, ColumnDescription = "检测位Z高度2")]
        public decimal YDirectionHeight2 { get; set; }

        /// <summary>
        /// 检测位X偏移距离3
        /// </summary>
        [SugarColumn(IsNullable = true, DecimalDigits = 2, ColumnDescription = "检测位X偏移距离3")]
        public decimal XDirectionDistance3 { get; set; }

        /// <summary>
        /// 检测位Z高度3
        /// </summary>
        [SugarColumn(IsNullable = true, DecimalDigits = 2, ColumnDescription = "检测位Z高度3")]
        public decimal YDirectionHeight3 { get; set; }

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