优化出入库历史单据头表从表查询

dengjunjie

2025-10-24 521fdf6c46213cad7c5c55015401154db0e78848

 н¨Îļþ¼Ð/WIDESEA_WMSServer/WIDESEA_Model/Models/SquareCabin/Dt_DeliveryOrder_Hty.cs

@@ -1,4 +1,5 @@
using SqlSugar;
using 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; }
    }
}