From b784d019c3848718eb95eb0d34dde34c6a262b06 Mon Sep 17 00:00:00 2001
From: dengjunjie <dengjunjie@hnkhzn.com>
Date: 星期一, 13 四月 2026 11:14:18 +0800
Subject: [PATCH] 组盘表添加供方代码
---
代码管理/WIDESEAWCS_Server/WIDESEAWCS_Server/WIDESEAWCS_Model/Models/BasicInfo/Dt_Formula.cs | 154 ++++++++++++++++++++++++++++++++++++++-------------
1 files changed, 115 insertions(+), 39 deletions(-)
diff --git "a/\344\273\243\347\240\201\347\256\241\347\220\206/WIDESEAWCS_Server/WIDESEAWCS_Server/WIDESEAWCS_Model/Models/BasicInfo/Dt_Formula.cs" "b/\344\273\243\347\240\201\347\256\241\347\220\206/WIDESEAWCS_Server/WIDESEAWCS_Server/WIDESEAWCS_Model/Models/BasicInfo/Dt_Formula.cs"
index 4665677..75cb8be 100644
--- "a/\344\273\243\347\240\201\347\256\241\347\220\206/WIDESEAWCS_Server/WIDESEAWCS_Server/WIDESEAWCS_Model/Models/BasicInfo/Dt_Formula.cs"
+++ "b/\344\273\243\347\240\201\347\256\241\347\220\206/WIDESEAWCS_Server/WIDESEAWCS_Server/WIDESEAWCS_Model/Models/BasicInfo/Dt_Formula.cs"
@@ -1,12 +1,13 @@
-锘縰sing System;
+锘縰sing 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 OfficeOpenXml.FormulaParsing.Excel.Functions.Numeric;
-using SqlSugar;
using WIDESEAWCS_Core.DB.Models;
-
+using Magicodes.IE.Core;
namespace WIDESEAWCS_Model.Models
{
[SugarTable(nameof(Dt_Formula), "閰嶆柟淇℃伅琛�")]
@@ -15,95 +16,170 @@
/// <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>
- [SugarColumn(IsNullable = false, Length = 50, ColumnDescription = "鎴愬搧缂栧彿")]
+ ///
+ [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>
- [SugarColumn(IsNullable = true, ColumnDescription = "鍘嬭浣嶄骇鍝侀暱搴�")]
- public float ProductLength { get; set; }
+ [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>
- [SugarColumn(IsNullable = true, ColumnDescription = "鍘嬭浣嶄骇鍝佸搴�")]
- public float ProductWidth { get; set; }
+ [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>
- [SugarColumn(IsNullable = true, ColumnDescription = "鍘嬭浣嶄骇鍝侀珮搴�")]
- public float ProductHeight { get; set; }
+ [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>
- [SugarColumn(IsNullable = true, ColumnDescription = "鍘嬭浣嶆嫥绱т笅闄嶉珮搴�")]
- public float ScrewDownsetDistance { get; set; }
+ [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>
- [SugarColumn(IsNullable = true, ColumnDescription = "鍘嬭浣嶆嫥绱ф壄鍔�")]
- public float ScrewTorqueOutput { get; set; }
+ [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>
- [SugarColumn(IsNullable = true, ColumnDescription = "鍘嬭浣嶈嚜鍔ㄦ嫥绱ф墦寮�")]
- public int DintAutoScrewOn { get; set; }
+ [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>
- /// 妫�娴嬩綅X鍋忕Щ璺濈1
+ /// 涓績楂樺害
/// </summary>
- [SugarColumn(IsNullable = true, ColumnDescription = "妫�娴嬩綅X鍋忕Щ璺濈1")]
- public float XDirectionDistance1 { get; set; }
+ [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>
- /// 妫�娴嬩綅Z楂樺害1
+ /// 鍘嬭浣嶈嚜鍔ㄦ嫥绱х▼搴忓彿
/// </summary>
- [SugarColumn(IsNullable = true, ColumnDescription = "妫�娴嬩綅Z楂樺害1")]
- public float YDirectionHeight1 { get; set; }
+ [ImporterHeader(Name = "鑷姩鎷х揣绋嬪簭鍙�")]
+ [ExporterHeader(null, 11f, null, true, true, false, 0, KnownColor.Empty, DisplayName = "鑷姩鎷х揣绋嬪簭鍙�")]
+ [SugarColumn(IsNullable = true, ColumnDescription = "鍘嬭浣嶈嚜鍔ㄦ嫥绱х▼搴忓彿")]
+ public int? DintAutoScrewOn { get; set; }
/// <summary>
- /// 妫�娴嬩綅X鍋忕Щ璺濈2
+ /// 鍘嬭浣嶇揣鍥烘壄鐭�
/// </summary>
- [SugarColumn(IsNullable = true, ColumnDescription = "妫�娴嬩綅X鍋忕Щ璺濈2")]
- public float XDirectionDistance2 { get; set; }
+ [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>
- /// 妫�娴嬩綅Z楂樺害2
+ /// P0P1瀹藉害
/// </summary>
- [SugarColumn(IsNullable = true, ColumnDescription = "妫�娴嬩綅Z楂樺害2")]
- public float YDirectionHeight2 { get; set; }
+ [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>
- /// 妫�娴嬩綅X鍋忕Щ璺濈3
+ /// P0P2瀹藉害
/// </summary>
- [SugarColumn(IsNullable = true, ColumnDescription = "妫�娴嬩綅X鍋忕Щ璺濈3")]
- public float XDirectionDistance3 { get; set; }
+ [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>
- /// 妫�娴嬩綅Z楂樺害3
+ /// P0P3瀹藉害
/// </summary>
- [SugarColumn(IsNullable = true, ColumnDescription = "妫�娴嬩綅Z楂樺害3")]
- public float YDirectionHeight3 { get; set; }
+ [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; }
+
}
-}
+}
\ No newline at end of file
--
Gitblit v1.9.3