From b513ce3a4527e998da66c6f179a279472c7262a8 Mon Sep 17 00:00:00 2001
From: wangxinhui <wangxinhui@hnkhzn.com>
Date: 星期二, 18 十一月 2025 10:59:46 +0800
Subject: [PATCH] 代码更新优化
---
项目代码/WMS/WMSServices/WIDESEA_Model/Models/Stock/Dt_StockInfo.cs | 199 +++++++++++++++++++++++++++++++++++++++++++++----
1 files changed, 183 insertions(+), 16 deletions(-)
diff --git "a/\351\241\271\347\233\256\344\273\243\347\240\201/WMS/WMSServices/WIDESEA_Model/Models/Stock/Dt_StockInfo.cs" "b/\351\241\271\347\233\256\344\273\243\347\240\201/WMS/WMSServices/WIDESEA_Model/Models/Stock/Dt_StockInfo.cs"
index 73cc45c..f1430e3 100644
--- "a/\351\241\271\347\233\256\344\273\243\347\240\201/WMS/WMSServices/WIDESEA_Model/Models/Stock/Dt_StockInfo.cs"
+++ "b/\351\241\271\347\233\256\344\273\243\347\240\201/WMS/WMSServices/WIDESEA_Model/Models/Stock/Dt_StockInfo.cs"
@@ -1,4 +1,5 @@
-锘縰sing SqlSugar;
+锘縰sing Magicodes.ExporterAndImporter.Core;
+using SqlSugar;
using System;
using System.Collections.Generic;
using System.Linq;
@@ -9,62 +10,228 @@
namespace WIDESEA_Model.Models
{
/// <summary>
- /// 搴撳瓨淇℃伅
+ /// 鍘熸枡/鍗婃垚鍝佺焊鍗峰簱瀛樹俊鎭�
/// </summary>
- [SugarTable(nameof(Dt_StockInfo), "搴撳瓨淇℃伅")]
+ [SugarTable(nameof(Dt_StockInfo), "鍘熸枡/鍗婃垚鍝佺焊鍗峰簱瀛樹俊鎭�")]
+ [SugarIndex("unique_stockinfo_stockcode", nameof(PalletCode), OrderByType.Asc, true)]
public class Dt_StockInfo : BaseEntity
{
/// <summary>
/// 涓婚敭
/// </summary>
+ [ExporterHeader(DisplayName = "涓婚敭")]
+ [ImporterHeader(Name = "涓婚敭")]
[SugarColumn(IsPrimaryKey = true, IsIdentity = true, ColumnDescription = "涓婚敭")]
public int Id { get; set; }
/// <summary>
- /// 鎵樼洏缂栧彿
+ /// 鏉＄爜缂栧彿
/// </summary>
- [SugarColumn(IsNullable = false, Length = 50, ColumnDescription = "鎵樼洏缂栧彿")]
+ [ExporterHeader(DisplayName = "鏉＄爜缂栧彿")]
+ [ImporterHeader(Name = "鏉＄爜缂栧彿")]
+ [SugarColumn(IsNullable = false, Length = 50, ColumnDescription = "鏉＄爜缂栧彿")]
public string PalletCode { get; set; }
+
+ /// <summary>
+ /// RFID淇℃伅
+ /// </summary>
+ [ExporterHeader(DisplayName = "RFID淇℃伅")]
+ [ImporterHeader(Name = "RFID淇℃伅")]
+ [SugarColumn(IsNullable = false, Length = 50, ColumnDescription = "RFID淇℃伅")]
+ public string RfidCode { get; set; }
/// <summary>
/// 鎵樼洏绫诲瀷
/// </summary>
+ [ExporterHeader(DisplayName = "鎵樼洏绫诲瀷")]
+ [ImporterHeader(Name = "鎵樼洏绫诲瀷")]
[SugarColumn(IsNullable = false, ColumnDescription = "鎵樼洏绫诲瀷")]
public int PalletType { get; set; }
/// <summary>
/// 璐т綅缂栧彿
/// </summary>
+ [ExporterHeader(DisplayName = "璐т綅缂栧彿")]
+ [ImporterHeader(Name = "璐т綅缂栧彿")]
[SugarColumn(IsNullable = true, Length = 30, ColumnDescription = "璐т綅缂栧彿")]
public string LocationCode { get; set; }
/// <summary>
/// 浠撳簱涓婚敭
/// </summary>
+ [ExporterHeader(DisplayName = "浠撳簱涓婚敭")]
+ [ImporterHeader(Name = "浠撳簱涓婚敭")]
[SugarColumn(IsNullable = false, ColumnDescription = "浠撳簱涓婚敭")]
public int WarehouseId { get; set; }
/// <summary>
+ /// 搴撳瓨缁勭粐
+ /// </summary>
+ [ExporterHeader(DisplayName = "搴撳瓨缁勭粐")]
+ [ImporterHeader(Name = "搴撳瓨缁勭粐")]
+ [SugarColumn(IsNullable = false, ColumnDescription = "搴撳瓨缁勭粐")]
+ public int MaterielInvOrgId { get; set; }
+
+ /// <summary>
+ /// 搴撳瓨灞炴��(鍘熺焊,鍗婃垚...)
+ /// </summary>
+ [ExporterHeader(DisplayName = "搴撳瓨灞炴��")]
+ [ImporterHeader(Name = "搴撳瓨灞炴��")]
+ [SugarColumn(IsNullable = false, ColumnDescription = "搴撳瓨灞炴��")]
+ public int StockAttribute { get; set; }
+
+ /// <summary>
/// 搴撳瓨鐘舵��
/// </summary>
+ [ExporterHeader(DisplayName = "搴撳瓨鐘舵��")]
+ [ImporterHeader(Name = "搴撳瓨鐘舵��")]
[SugarColumn(IsNullable = false, ColumnDescription = "搴撳瓨鐘舵��")]
public int StockStatus { get; set; }
/// <summary>
- /// 澶囨敞
+ /// 鐗╂枡Id
/// </summary>
- [SugarColumn(IsNullable = true, ColumnDescription = "澶囨敞")]
- public string Remark { get; set; }
- /// <summary>
- /// 搴撳瓨鐗╂枡闀垮害GM/PP
- /// </summary>
- [SugarColumn(IsNullable = true, ColumnDescription = "搴撳瓨鐗╂枡闀垮害")]
- public int StockLength { get; set; }
+ [ExporterHeader(DisplayName = "鐗╂枡Id")]
+ [ImporterHeader(Name = "鐗╂枡Id")]
+ [SugarColumn(IsNullable = true, ColumnDescription = "鐗╂枡Id")]
+ public int MaterielId { get; set; }
/// <summary>
- /// 搴撳瓨鏄庣粏
+ /// 鐗╂枡缂栧彿
/// </summary>
- [Navigate(NavigateType.OneToMany, nameof(Dt_StockInfoDetail.StockId), nameof(Id))]
- public List<Dt_StockInfoDetail> Details { get; set; }
+ [ExporterHeader(DisplayName = "鐗╂枡缂栧彿")]
+ [ImporterHeader(Name = "鐗╂枡缂栧彿")]
+ [SugarColumn(IsNullable = false, Length = 50, ColumnDescription = "鐗╂枡缂栧彿")]
+ public string MaterielCode { get; set; }
+
+ /// <summary>
+ /// 鐗╂枡鍚嶇О
+ /// </summary>
+ [ExporterHeader(DisplayName = "鐗╂枡鍚嶇О")]
+ [ImporterHeader(Name = "鐗╂枡鍚嶇О")]
+ [SugarColumn(IsNullable = false, Length = 200, ColumnDescription = "鐗╂枡鍚嶇О")]
+ public string MaterielName { get; set; }
+
+ /// <summary>
+ /// 鐗╂枡瑙勬牸
+ /// </summary>
+ [ExporterHeader(DisplayName = "鐗╂枡瑙勬牸")]
+ [ImporterHeader(Name = "鐗╂枡瑙勬牸")]
+ [SugarColumn(IsNullable = true, Length = 200, ColumnDescription = "鐗╂枡瑙勬牸")]
+ public string MaterielSpec { get; set; }
+
+ /// <summary>
+ /// 鎵规鍙�
+ /// </summary>
+ [ExporterHeader(DisplayName = "鎵规鍙�")]
+ [ImporterHeader(Name = "鎵规鍙�")]
+ [SugarColumn(IsNullable = true, Length = 100, ColumnDescription = "鎵规鍙�")]
+ public string BatchNo { get; set; }
+
+ /// <summary>
+ /// 璁㈠崟鍙�
+ /// </summary>
+ [ExporterHeader(DisplayName = "璁㈠崟鍙�")]
+ [ImporterHeader(Name = "璁㈠崟鍙�")]
+ [SugarColumn(IsNullable = true, Length = 100, ColumnDescription = "璁㈠崟鍙�")]
+ public string OrderNo { get; set; }
+
+ /// <summary>
+ /// 搴撳瓨鐗╂枡鎬婚暱(m)
+ /// </summary>
+ [ExporterHeader(DisplayName = "搴撳瓨鐗╂枡鎬婚暱")]
+ [ImporterHeader(Name = "搴撳瓨鐗╂枡鎬婚暱")]
+ [SugarColumn(IsNullable = true, ColumnDescription = "搴撳瓨鐗╂枡鎬婚暱(m)")]
+ public decimal StockLength { get; set; }
+
+ /// <summary>
+ /// 鐗╂枡閲嶉噺
+ /// </summary>
+ [ExporterHeader(DisplayName = "鐗╂枡閲嶉噺")]
+ [ImporterHeader(Name = "鐗╂枡閲嶉噺")]
+ [SugarColumn(IsNullable = true, ColumnDescription = "鐗╂枡閲嶉噺")]
+ public decimal? MaterielWeight { get; set; }
+
+ /// <summary>
+ /// 妫�娴嬮噸閲�
+ /// </summary>
+ [ExporterHeader(DisplayName = "妫�娴嬮噸閲�")]
+ [ImporterHeader(Name = "妫�娴嬮噸閲�")]
+ [SugarColumn(IsNullable = true, ColumnDescription = "妫�娴嬮噸閲�")]
+ public decimal? CheckWeight { get; set; }
+
+ /// <summary>
+ /// 鐗╂枡鐩村緞/楂樺害
+ /// </summary>
+ [ExporterHeader(DisplayName = "鐗╂枡鐩村緞")]
+ [ImporterHeader(Name = "鐗╂枡鐩村緞")]
+ [SugarColumn(IsNullable = true, ColumnDescription = "鐗╂枡鐩村緞/楂樺害")]
+ public decimal? MaterielThickness { get; set; }
+
+ /// <summary>
+ /// 妫�娴嬬洿寰�
+ /// </summary>
+ [ExporterHeader(DisplayName = "妫�娴嬬洿寰�")]
+ [ImporterHeader(Name = "妫�娴嬬洿寰�")]
+ [SugarColumn(IsNullable = true, ColumnDescription = "妫�娴嬬洿寰�")]
+ public decimal? CheckThickness { get; set; }
+
+ /// <summary>
+ /// 鐗╂枡渚ч潰骞呭(m)
+ /// </summary>
+ [ExporterHeader(DisplayName = "鐗╂枡渚ч潰骞呭")]
+ [ImporterHeader(Name = "鐗╂枡渚ч潰骞呭")]
+ [SugarColumn(IsNullable = true, ColumnDescription = "鐗╂枡渚ч潰骞呭(m)")]
+ public decimal? MaterielWide { get; set; }
+
+ /// <summary>
+ /// 妫�娴嬪箙瀹�
+ /// </summary>
+ [ExporterHeader(DisplayName = "妫�娴嬪箙瀹�")]
+ [ImporterHeader(Name = "妫�娴嬪箙瀹�")]
+ [SugarColumn(IsNullable = true, ColumnDescription = "妫�娴嬪箙瀹�")]
+ public decimal? CheckWide { get; set; }
+
+ /// <summary>
+ /// 鍑哄簱鐗╂枡鏁伴噺
+ /// </summary>
+ [ExporterHeader(DisplayName = "鍑哄簱鐗╂枡鏁伴噺")]
+ [ImporterHeader(Name = "鍑哄簱鐗╂枡鏁伴噺")]
+ [SugarColumn(IsNullable = false, ColumnDescription = "鍑哄簱鐗╂枡鏁伴噺", DefaultValue = "0")]
+ public decimal StockOutLength { get; set; }
+
+ /// <summary>
+ /// 鏁村嵎/娈嬪嵎
+ /// </summary>
+ [ExporterHeader(DisplayName = "鏁村嵎/娈嬪嵎")]
+ [ImporterHeader(Name = "鏁村嵎/娈嬪嵎")]
+ [SugarColumn(IsNullable = false, ColumnDescription = "鏁村嵎/娈嬪嵎", DefaultValue = "0")]
+ public int IsFull { get; set; }
+
+ /// <summary>
+ /// 鏄惁棰嗘枡<br/>
+ /// 0 鍚�<br/>
+ /// 1 鏄�<br/>
+ /// </summary>
+ [ExporterHeader(DisplayName = "鏄惁棰嗘枡(1鏄�0鍚�)")]
+ [ImporterHeader(Name = "鏄惁棰嗘枡(1鏄�0鍚�)")]
+ [SugarColumn(IsNullable = false, ColumnDescription = "鏄惁棰嗘枡", DefaultValue = "0")]
+ public int IsPick { get; set; }
+
+ /// <summary>
+ /// 鍗曚綅
+ /// </summary>
+ [ExporterHeader(DisplayName = "鍗曚綅")]
+ [ImporterHeader(Name = "鍗曚綅")]
+ [SugarColumn(IsNullable = true, ColumnDescription = "鍗曚綅")]
+ public string Unit { get; set; }
+
+ /// <summary>
+ /// 澶囨敞
+ /// </summary>
+ [ExporterHeader(DisplayName = "澶囨敞")]
+ [ImporterHeader(Name = "澶囨敞")]
+ [SugarColumn(IsNullable = true, ColumnDescription = "澶囨敞")]
+ public string Remark { get; set; }
}
}
--
Gitblit v1.9.3