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_DeliveryOrder_Hty.cs | 70 ++++++++++++-----------------------
1 files changed, 24 insertions(+), 46 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_DeliveryOrder_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_DeliveryOrder_Hty.cs"
index 019b4a4..4632982 100644
--- "a/\346\226\260\345\273\272\346\226\207\344\273\266\345\244\271/WIDESEA_WMSServer/WIDESEA_Model/Models/SquareCabin/Dt_DeliveryOrder_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_DeliveryOrder_Hty.cs"
@@ -1,4 +1,5 @@
-锘縰sing SqlSugar;
+锘縰sing Magicodes.ExporterAndImporter.Core;
+using SqlSugar;
using System;
using System.Collections.Generic;
using System.Linq;
@@ -9,55 +10,32 @@
namespace WIDESEA_Model.Models
{
[SugarTable("Dt_DeliveryOrder_Hty", "鍑哄簱鍗曞巻鍙茶〃")]
- public class Dt_DeliveryOrder_Hty : BaseEntity
+ public class Dt_DeliveryOrder_Hty : Dt_DeliveryOrder, 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 = "Out_no", IsNullable = true, Length = 50, ColumnDescription = "鍑哄簱鍗曞彿")]
- public string Out_no { get; set; }
-
- [SugarColumn(ColumnName = "Out_type", IsNullable = true, Length = 3, ColumnDescription = "鍑哄簱鍗曠被鍨�")]
- public string Out_type { get; set; }
-
- [SugarColumn(ColumnName = "Client_no", IsNullable = true, Length = 50, ColumnDescription = "瀹㈡埛浠ｇ爜")]
- public string Client_no { get; set; }
-
-
- [SugarColumn(ColumnName = "Client_name", IsNullable = true, Length = 50, ColumnDescription = "瀹㈡埛鍚嶇О")]
- public string Client_name { get; set; }
-
-
- //搴撴埧鍙�
- [SugarColumn(ColumnName = "Warehouse_no", IsNullable = true, ColumnDescription = "搴撴埧鍙�")]
- public string Warehouse_no { get; set; }
-
-
-
-
- [SugarColumn(ColumnName = "Account_time", IsNullable = true, ColumnDescription = "鍑哄簱璁拌处鏃堕棿")]
- public DateTime? Account_time { get; set; }
+ [Navigate(NavigateType.OneToMany, nameof(Dt_DeliveryOrderDetail_Hty.DeliveryOrderId))]
+ public new List<Dt_DeliveryOrderDetail_Hty> Details { get; set; }
+ /// <summary>
+ /// 鍘熻〃涓婚敭
+ /// </summary>
+ [ImporterHeader(Name = "鍘熻〃涓婚敭")]
+ [ExporterHeader(DisplayName = "鍘熻〃涓婚敭")]
+ [SugarColumn(IsNullable = false, DefaultValue = "0", ColumnDescription = "鍘熻〃涓婚敭")]
+ public int SourceId { get; set; }
/// <summary>
- /// 琛ㄥご鐘舵�侊細鏂板缓锛屽紑濮嬶紝宸插畬鎴� //璇︽儏琛ㄥ叏閮ㄧ姸鎬佷负鍏ㄩ儴锛屽湪灏嗙姸鎬佹敼鎴愬畬鎴愬悗鎵嶄細涓婁紶缁欎笂娓哥郴缁�
+ /// 鎿嶄綔绫诲瀷
/// </summary>
- [SugarColumn(ColumnName = "OutStatus", IsNullable = true, ColumnDescription = "鐘舵��")]
- public string OutStatus { get; set; }
+ [ImporterHeader(Name = "鎿嶄綔绫诲瀷")]
+ [ExporterHeader(DisplayName = "鎿嶄綔绫诲瀷")]
+ [SugarColumn(IsNullable = false, Length = 50, ColumnDescription = "鎿嶄綔绫诲瀷")]
+ public string OperateType { get; set; }
- //鏄惁闇�瑕佷笅闈㈢殑瀛楁
- //浼樺厛绾� priority
- //鏄惁鍙栨秷 Is_cancel
-
- //浼樺厛绾� priority
- //[SugarColumn(ColumnName = "Priority", IsNullable = true, ColumnDescription = "浼樺厛绾�")]
- //public int Priority { get; set; }
-
- ////鏄惁鍙栨秷 Iscancel
- //[SugarColumn(ColumnName = "Iscancel", IsNullable = true, ColumnDescription = "鏄惁鍙栨秷")]
- //public int Iscancel { get; set; }
- [Navigate(NavigateType.OneToMany, nameof(Dt_DeliveryOrderDetail.DeliveryOrderId))]
- public List<Dt_DeliveryOrderDetail> Details { get; set; }
+ /// <summary>
+ /// 绉诲叆鍘嗗彶鏃堕棿
+ /// </summary>
+ [ImporterHeader(Name = "绉诲叆鍘嗗彶鏃堕棿")]
+ [ExporterHeader(DisplayName = "绉诲叆鍘嗗彶鏃堕棿")]
+ [SugarColumn(IsNullable = false, ColumnDescription = "绉诲叆鍘嗗彶鏃堕棿")]
+ public DateTime InsertTime { get; set; }
}
}
--
Gitblit v1.9.3