From 521fdf6c46213cad7c5c55015401154db0e78848 Mon Sep 17 00:00:00 2001
From: dengjunjie <dengjunjie@hnkhzn.com>
Date: 星期五, 24 十月 2025 13:17:43 +0800
Subject: [PATCH] 优化出入库历史单据头表从表查询
---
新建文件夹/WIDESEA_WMSServer/WIDESEA_Model/Models/SquareCabin/Dt_DeliveryOrderDetail_Hty.cs | 71 +++++++++++------------------------
1 files changed, 22 insertions(+), 49 deletions(-)
diff --git "a/\346\226\260\345\273\272\346\226\207\344\273\266\345\244\271/WIDESEA_WMSServer/WIDESEA_Model/Models/SquareCabin/Dt_DeliveryOrderDetail_Hty.cs" "b/\346\226\260\345\273\272\346\226\207\344\273\266\345\244\271/WIDESEA_WMSServer/WIDESEA_Model/Models/SquareCabin/Dt_DeliveryOrderDetail_Hty.cs"
index 0c55bbe..5f233e4 100644
--- "a/\346\226\260\345\273\272\346\226\207\344\273\266\345\244\271/WIDESEA_WMSServer/WIDESEA_Model/Models/SquareCabin/Dt_DeliveryOrderDetail_Hty.cs"
+++ "b/\346\226\260\345\273\272\346\226\207\344\273\266\345\244\271/WIDESEA_WMSServer/WIDESEA_Model/Models/SquareCabin/Dt_DeliveryOrderDetail_Hty.cs"
@@ -1,4 +1,5 @@
-锘縰sing SqlSugar;
+锘縰sing Magicodes.ExporterAndImporter.Core;
+using SqlSugar;
using System;
using System.Collections.Generic;
using System.Linq;
@@ -9,59 +10,31 @@
namespace WIDESEA_Model.Models
{
[SugarTable("Dt_DeliveryOrderDetail_Hty", "鍑哄簱鏄庣粏鍘嗗彶琛�")]
- public class Dt_DeliveryOrderDetail_Hty : BaseEntity
+ public class Dt_DeliveryOrderDetail_Hty : Dt_DeliveryOrderDetail, IBaseHistoryEntity
{
- [SugarColumn(ColumnName = "HistoryId", IsPrimaryKey = true, IsIdentity = true, ColumnDescription = "鍘嗗彶璁板綍涓婚敭")]
- public int HistoryId { get; set; }
-
- [SugarColumn(ColumnName = "Id", ColumnDescription = "鍘熶富閿�")]
- public int Id { get; set; }
-
- [SugarColumn(ColumnName = "DeliveryOrderId", IsNullable = true, ColumnDescription = "鍏宠仈鍏ュ簱鍗旾D")]
- public int DeliveryOrderId { get; set; }
-
- [SugarColumn(ColumnName = "Reservoirarea", IsNullable = true, Length = 50, ColumnDescription = "搴撳尯")]
- public string Reservoirarea { get; set; }
-
- [SugarColumn(ColumnName = "Goods_no", IsNullable = true, Length = 50, ColumnDescription = "鑽搧缂栫爜")]
- public string Goods_no { get; set; }
-
-
- [SugarColumn(ColumnName = "Order_qty", IsNullable = true, ColumnDescription = "鍑哄簱閫�璐ф椂涓鸿礋鏁�")]
- public decimal Order_qty { get; set; }
-
-
- [SugarColumn(ColumnName = "Order_Outqty", IsNullable = true, ColumnDescription = "鍑哄簱瀹屾垚鏁伴噺")]
- public decimal Order_Outqty { get; set; }
-
- [SugarColumn(ColumnName = "Batch_num", IsNullable = true, Length = 50, ColumnDescription = "鎵瑰彿")]
- public string Batch_num { get; set; }
-
- [SugarColumn(ColumnName = "Exp_date", IsNullable = true, Length = 8, ColumnDescription = "鏍℃湡(yyyymmmdd)")]
- public string Exp_date { get; set; }
/// <summary>
- /// 璁㈠崟璇︽儏鐘舵�� 鏂板缓锛屽紑濮嬶紝宸插畬鎴�
- /// 搴撴埧鍙�+鐘舵��+锛堟柊寤猴級锛氬垽鏂槸鍚︿笅鍙戠粰wcs
- /// 璇︽儏寮�濮嬶紙寮�濮嬶級
- /// 璇︽儏瀹屾垚锛堝凡瀹屾垚锛岀Щ鍏ュ巻鍙茶〃鍒犻櫎淇℃伅锛�
+ /// 鍘熻〃涓婚敭
/// </summary>
- [SugarColumn(ColumnName = "OotDetailStatus", IsNullable = true, Length = 50, ColumnDescription = "鐘舵��")]
- public string OotDetailStatus { get; set; }
+ [ImporterHeader(Name = "鍘熻〃涓婚敭")]
+ [ExporterHeader(DisplayName = "鍘熻〃涓婚敭")]
+ [SugarColumn(IsNullable = false, DefaultValue = "0", ColumnDescription = "鍘熻〃涓婚敭")]
+ public int SourceId { get; set; }
+ /// <summary>
+ /// 鎿嶄綔绫诲瀷
+ /// </summary>
+ [ImporterHeader(Name = "鎿嶄綔绫诲瀷")]
+ [ExporterHeader(DisplayName = "鎿嶄綔绫诲瀷")]
+ [SugarColumn(IsNullable = false, Length = 50, ColumnDescription = "鎿嶄綔绫诲瀷")]
+ public string OperateType { get; set; }
- [SugarColumn(ColumnName = "Status", IsNullable = true, ColumnDescription = "涓嬫父鐘舵�侊紝鍚屾鐘舵�侊細0鏈悓姝ワ紝1宸插悓姝ワ紙鍚屾鍙戠粰wcs锛�")]
- public int Status { get; set; }
-
- // 瀵艰埅灞炴�э細涓�涓槑缁嗗搴斾竴涓嵂鍝佷俊鎭�
- // 淇瀵艰埅灞炴�э細浣跨敤 Goods_no 鍏宠仈 MaterielCode
- [Navigate(NavigateType.OneToOne, nameof(Goods_no), nameof(Dt_MaterielInfo.MaterielCode))]
- public Dt_MaterielInfo MedicineGoods { get; set; }
-
- //鏄惁闇�瑕佷笅闈㈢殑瀛楁
- //sku鍚嶇О productName
- //sku瑙勬牸 ProductSpecifications
- //鏁伴噺 quantity
- //鐩樹簭鏄庣粏 StocktakingDetails
+ /// <summary>
+ /// 绉诲叆鍘嗗彶鏃堕棿
+ /// </summary>
+ [ImporterHeader(Name = "绉诲叆鍘嗗彶鏃堕棿")]
+ [ExporterHeader(DisplayName = "绉诲叆鍘嗗彶鏃堕棿")]
+ [SugarColumn(IsNullable = false, ColumnDescription = "绉诲叆鍘嗗彶鏃堕棿")]
+ public DateTime InsertTime { get; set; }
}
}
--
Gitblit v1.9.3