更新WMS实体

Rodney Chen

2025-03-06 27f9d29760ee5457d7c0cb9e12cacab33c08eaea

更新WMS实体

 Tiger.Model.Net/Entitys/WMS/BIZ_U9_ASN.cs

@@ -59,6 +59,16 @@
        [DisplayName("预计送达日期")]
        public DateTime PLANARRIVED_DATE { get; set; } = DateTime.MinValue;
        /// <summary>
        /// é‡‡è´­å•ID
        /// </summary>
        [DisplayName("采购单ID")]
        public string PO_ID { get; set; }
        /// <summary>
        /// é‡‡è´­å•å·
        /// </summary>
        [DisplayName("采购单号")]
        public string PO_NO { get; set; }
        /// <summary>
        /// æ”¶è´§äºº
        /// </summary>
        [DisplayName("收货人")]

 Tiger.Model.Net/Entitys/WMS/BIZ_U9_ASN_DTL.cs

@@ -94,20 +94,30 @@
        [DisplayName("批次号")]
        public string LOTNO { get; set; }
        /// <summary>
        /// é‡‡è´­å•ID
        /// </summary>
        [DisplayName("采购单ID")]
        public string PO_ID { get; set; }
        /// <summary>
        /// é‡‡è´­å•å·
        /// </summary>
        [DisplayName("采购单号")]
        public string PO { get; set; }
        public string PO_NO { get; set; }
        /// <summary>
        /// é‡‡è´­å•è¡Œå·
        /// </summary>
        [DisplayName("采购单行号")]
        public string PO_LINE { get; set; }
        /// <summary>
        /// é€æ£€å•ID
        /// </summary>
        [DisplayName("送检单ID")]
        public string IQC_ID { get; set; }
        /// <summary>
        /// é€æ£€å•å·
        /// </summary>
        [DisplayName("送检单号")]
        public string IQC_ORDER { get; set; }
        public string IQC_NO { get; set; }
        /// <summary>
        /// å¤‡æ³¨
        /// </summary>

 Tiger.Model.Net/Entitys/WMS/BIZ_U9_RECEIPT.cs

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,161 @@
using System;
using SqlSugar;
using System.Linq;
using System.ComponentModel;
using System.Collections.Generic;

namespace Tiger.Model
{
    /// <summary>
    /// å®žä½“：收货单(U9)
    /// </summary>
    [Description("Primary:ID")]
    [DisplayName("收货单(U9)")]
    [Serializable]
    [SugarTable("BIZ_U9_RECEIPT")]
    public class BIZ_U9_RECEIPT : DbEntityWithAuth
    {
        #region æž„造函数
        /// <summary>
        /// å®žä½“：收货单(U9)
        /// </summary>
        public BIZ_U9_RECEIPT() {}
        #endregion

        #region å…¬å…±å±žæ€§
        /// <summary>
        /// å•æ®å·
        /// </summary>
        [DisplayName("单据号")]
        public string ORDER_NO { get; set; }
        /// <summary>
        /// çŠ¶æ€(0Init初始化|1Imported已导入|2Arrived已送达|3Counting清点中|4InQC检验中|5Storing上架中|6Review待审核|7Finished已完成|8Cancel已作废)
        /// </summary>
        [DisplayName("状态(0Init初始化|1Imported已导入|2Arrived已送达|3Counting清点中|4InQC检验中|5Storing上架中|6Review待审核|7Finished已完成|8Cancel已作废)")]
        public int STATUS { get; set; }
        /// <summary>
        /// ä¾›åº”商编码
        /// </summary>
        [DisplayName("供应商编码")]
        public string SUPP_CODE { get; set; }
        /// <summary>
        /// ä¾›åº”商名称
        /// </summary>
        [DisplayName("供应商名称")]
        public string SUPP_NAME { get; set; }
        /// <summary>
        /// å•æ®æ—¥æœŸ
        /// </summary>
        [DisplayName("单据日期")]
        public DateTime ORDER_DATE { get; set; } = DateTime.MinValue;
        /// <summary>
        /// æ”¶è´§äºº
        /// </summary>
        [DisplayName("收货人")]
        public string RECEIVER { get; set; }
        /// <summary>
        /// æ”¶è´§æ—¥æœŸ
        /// </summary>
        [DisplayName("收货日期")]
        public DateTime RECEIVE_DATE { get; set; } = DateTime.MinValue;
        /// <summary>
        /// é€è´§å•ID
        /// </summary>
        [DisplayName("送货单ID")]
        public string ASN_ID { get; set; }
        /// <summary>
        /// é€è´§å•å·
        /// </summary>
        [DisplayName("送货单号")]
        public string ASN_NO { get; set; }
        /// <summary>
        /// å¤‡æ³¨
        /// </summary>
        [DisplayName("备注")]
        public string REMARK { get; set; }
        /// <summary>
        /// -1:未处理，0:同步处理完，>0:同步处理失败次数
        /// </summary>
        [DisplayName("-1:未处理，0:同步处理完，>0:同步处理失败次数")]
        public int HANDLED { get; set; }
        /// <summary>
        /// æœ€åŽä¸€æ¬¡åŒæ­¥å¤„理日期
        /// </summary>
        [DisplayName("最后一次同步处理日期")]
        public DateTime HANDLED_DATE { get; set; } = DateTime.MinValue;
        /// <summary>
        /// è¿‡è´¦æäº¤çš„JSON
        /// </summary>
        [DisplayName("过账提交的JSON")]
        public string COMMIT_JSON { get; set; }
        /// <summary>
        /// è¿‡è´¦æäº¤çš„返回信息
        /// </summary>
        [DisplayName("过账提交的返回信息")]
        public string COMMIT_MSG { get; set; }
        #endregion

        #region è™šæ‹Ÿå±žæ€§
        /*例子
        [SugarColumn(IsIgnore = true)]
        public string FieldName { get; set; }
        */
        #endregion

        #region å¤–键属性
        /*例子
        //一对一外键导航
        [Navigate(NavigateType.OneToOne, nameof(ClassAId))]//一对一 ClassAId是BIZ_U9_RECEIPT类里面的外键ID字段
        public ClassA ClassA { get; set; } //注意禁止手动赋值，只能是null
        //一对多外键导航
        [Navigate(NavigateType.OneToMany, nameof(ClassA.BIZ_U9_RECEIPTId))]//ClassA表中的BIZ_U9_RECEIPTId
        public List<ClassA> ClassAList { get; set; }//注意禁止手动赋值，只能是null
        //多对多外键导航
        [Navigate(typeof(MappingClass), nameof(MappingClass.BIZ_U9_RECEIPTId), nameof(MappingClass.ClassAId))]//注意顺序
        public List<ClassA> ClassAList { get; set; } //注意禁止手动赋值，只能是null
        */
        #endregion

        #region æžšä¸¾å˜é‡
        /*例子
        public enum FieldNames
        {
            [Description("枚举描述0")]
            Enum0,
            [Description("枚举描述1")]
            Enum1,
        }
        */

        /// <summary>
        /// æžšä¸¾ï¼šçŠ¶æ€(0Init初始化|1Imported已导入|2Arrived已送达|3Counting清点中|4InQC检验中|5Storing上架中|6Review待审核|7Finished已完成|8Cancel已作废)
        /// </summary>
        public enum STATUSs
        {
            [Description("初始化")]
            Init = 0,
            [Description("已导入")]
            Imported = 1,
            [Description("已送达")]
            Arrived = 2,
            [Description("清点中")]
            Counting = 3,
            [Description("检验中")]
            InQC = 4,
            [Description("上架中")]
            Storing = 5,
            [Description("待审核")]
            Review = 6,
            [Description("已完成")]
            Finished = 7,
            [Description("已作废")]
            Cancel = 8,
        }
        #endregion

        #region å…¬å…±æ–¹æ³•

        #endregion

    }//endClass
}

 Tiger.Model.Net/Entitys/WMS/BIZ_U9_RECEIPT_DTL.cs

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,156 @@
using System;
using SqlSugar;
using System.Linq;
using System.ComponentModel;
using System.Collections.Generic;

namespace Tiger.Model
{
    /// <summary>
    /// å®žä½“：收货单(U9)明细
    /// </summary>
    [Description("Primary:ID")]
    [DisplayName("收货单(U9)明细")]
    [Serializable]
    [SugarTable("BIZ_U9_RECEIPT_DTL")]
    public class BIZ_U9_RECEIPT_DTL : DbEntityWithAuth
    {
        #region æž„造函数
        /// <summary>
        /// å®žä½“：收货单(U9)明细
        /// </summary>
        public BIZ_U9_RECEIPT_DTL() {}
        #endregion

        #region å…¬å…±å±žæ€§
        /// <summary>
        /// å•æ®å·
        /// </summary>
        [DisplayName("单据号")]
        public string ORDER_NO { get; set; }
        /// <summary>
        /// å•æ®è¡Œå·
        /// </summary>
        [DisplayName("单据行号")]
        public string LINE_NO { get; set; }
        /// <summary>
        /// çŠ¶æ€(同单据状态)
        /// </summary>
        [DisplayName("状态(同单据状态)")]
        public int STATUS { get; set; }
        /// <summary>
        /// ç‰©æ–™ç¼–码
        /// </summary>
        [DisplayName("物料编码")]
        public string ITEM_CODE { get; set; }
        /// <summary>
        /// å•ä½
        /// </summary>
        [DisplayName("单位")]
        public string UNIT { get; set; }
        /// <summary>
        /// å•æ®æ•°é‡
        /// </summary>
        [DisplayName("单据数量")]
        public double QTY { get; set; }
        /// <summary>
        /// åŒ…装数量
        /// </summary>
        [DisplayName("包装数量")]
        public double QTY_PACKING { get; set; }
        /// <summary>
        /// å…¥åº“数量
        /// </summary>
        [DisplayName("入库数量")]
        public double QTY_IN { get; set; }
        /// <summary>
        /// è‰¯å“æ•°é‡
        /// </summary>
        [DisplayName("良品数量")]
        public double QTY_OK { get; set; }
        /// <summary>
        /// ä¸è‰¯æ•°é‡
        /// </summary>
        [DisplayName("不良数量")]
        public double QTY_NG { get; set; }
        /// <summary>
        /// æŠ¥åºŸæ•°é‡
        /// </summary>
        [DisplayName("报废数量")]
        public double QTY_SCRAP { get; set; }
        /// <summary>
        /// æ‰¹æ¬¡å·
        /// </summary>
        [DisplayName("批次号")]
        public string LOTNO { get; set; }
        /// <summary>
        /// é€è´§å•ID
        /// </summary>
        [DisplayName("送货单ID")]
        public string ASN_ID { get; set; }
        /// <summary>
        /// é€è´§å•å·
        /// </summary>
        [DisplayName("送货单号")]
        public string ASN_NO { get; set; }
        /// <summary>
        /// é€è´§å•è¡ŒID
        /// </summary>
        [DisplayName("送货单行ID")]
        public string ASN_LINE_ID { get; set; }
        /// <summary>
        /// é€è´§å•è¡Œå·
        /// </summary>
        [DisplayName("送货单行号")]
        public string ASN_LINE { get; set; }
        /// <summary>
        /// é€æ£€å•å·
        /// </summary>
        [DisplayName("送检单号")]
        public string IQC_ORDER { get; set; }
        /// <summary>
        /// å¤‡æ³¨
        /// </summary>
        [DisplayName("备注")]
        public string REMARK { get; set; }
        #endregion

        #region è™šæ‹Ÿå±žæ€§
        /*例子
        [SugarColumn(IsIgnore = true)]
        public string FieldName { get; set; }
        */
        #endregion

        #region å¤–键属性
        /*例子
        //一对一外键导航
        [Navigate(NavigateType.OneToOne, nameof(ClassAId))]//一对一 ClassAId是BIZ_U9_RECEIPT_DTL类里面的外键ID字段
        public ClassA ClassA { get; set; } //注意禁止手动赋值，只能是null
        //一对多外键导航
        [Navigate(NavigateType.OneToMany, nameof(ClassA.BIZ_U9_RECEIPT_DTLId))]//ClassA表中的BIZ_U9_RECEIPT_DTLId
        public List<ClassA> ClassAList { get; set; }//注意禁止手动赋值，只能是null
        //多对多外键导航
        [Navigate(typeof(MappingClass), nameof(MappingClass.BIZ_U9_RECEIPT_DTLId), nameof(MappingClass.ClassAId))]//注意顺序
        public List<ClassA> ClassAList { get; set; } //注意禁止手动赋值，只能是null
        */
        #endregion

        #region æžšä¸¾å˜é‡
        /*例子
        public enum FieldNames
        {
            [Description("枚举描述0")]
            Enum0,
            [Description("枚举描述1")]
            Enum1,
        }
        */
        #endregion

        #region å…¬å…±æ–¹æ³•

        #endregion

    }//endClass
}

 Tiger.Model.Net/Entitys/WMS/BIZ_U9_RECEIPT_SN.cs

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,141 @@
using System;
using SqlSugar;
using System.Linq;
using System.ComponentModel;
using System.Collections.Generic;

namespace Tiger.Model
{
    /// <summary>
    /// å®žä½“：收货单(U9)条码明细
    /// </summary>
    [Description("Primary:ID")]
    [DisplayName("收货单(U9)条码明细")]
    [Serializable]
    [SugarTable("BIZ_U9_RECEIPT_SN")]
    public class BIZ_U9_RECEIPT_SN : DbEntityWithAuth
    {
        #region æž„造函数
        /// <summary>
        /// å®žä½“：收货单(U9)条码明细
        /// </summary>
        public BIZ_U9_RECEIPT_SN() {}
        #endregion

        #region å…¬å…±å±žæ€§
        /// <summary>
        /// å•æ®å·
        /// </summary>
        [DisplayName("单据号")]
        public string ORDER_NO { get; set; }
        /// <summary>
        /// å•æ®è¡Œå·
        /// </summary>
        [DisplayName("单据行号")]
        public string LINE_NO { get; set; }
        /// <summary>
        /// æ¡ç 
        /// </summary>
        [DisplayName("条码")]
        public string SN { get; set; }
        /// <summary>
        /// å…ƒæ¡ç 
        /// </summary>
        [DisplayName("元条码")]
        public string META_SN { get; set; }
        /// <summary>
        /// ç‰©æ–™ç¼–码
        /// </summary>
        [DisplayName("物料编码")]
        public string ITEM_CODE { get; set; }
        /// <summary>
        /// ×´Ì¬(ͬWMS_ITEM״̬)
        /// </summary>
        [DisplayName("״̬(ͬWMS_ITEM״̬)")]
        public int STATUS { get; set; }
        /// <summary>
        /// æ•°é‡
        /// </summary>
        [DisplayName("数量")]
        public double QTY { get; set; }
        /// <summary>
        /// å•ä½
        /// </summary>
        [DisplayName("单位")]
        public string UNIT { get; set; }
        /// <summary>
        /// æ˜¯å¦è‰¯å“(Y/N)
        /// </summary>
        [DisplayName("是否良品(Y/N)")]
        public string IS_OK { get; set; }
        /// <summary>
        /// æ˜¯å¦å…¥åº“(Y/N)
        /// </summary>
        [DisplayName("是否入库(Y/N)")]
        public string IS_IN { get; set; }
        /// <summary>
        /// æ˜¯å¦æŠ¥åºŸ(Y/N)
        /// </summary>
        [DisplayName("是否报废(Y/N)")]
        public string IS_SCRAP { get; set; }
        /// <summary>
        /// æ‰¹æ¬¡å·
        /// </summary>
        [DisplayName("批次号")]
        public string LOTNO { get; set; }
        /// <summary>
        /// ç®±å·
        /// </summary>
        [DisplayName("箱号")]
        public string CARTON_NO { get; set; }
        /// <summary>
        /// æ ˆæ¿å·
        /// </summary>
        [DisplayName("栈板号")]
        public string PALLET_NO { get; set; }
        /// <summary>
        /// å¤‡æ³¨
        /// </summary>
        [DisplayName("备注")]
        public string REMARK { get; set; }
        #endregion

        #region è™šæ‹Ÿå±žæ€§
        /*例子
        [SugarColumn(IsIgnore = true)]
        public string FieldName { get; set; }
        */
        #endregion

        #region å¤–键属性
        /*例子
        //一对一外键导航
        [Navigate(NavigateType.OneToOne, nameof(ClassAId))]//一对一 ClassAId是BIZ_U9_RECEIPT_SN类里面的外键ID字段
        public ClassA ClassA { get; set; } //注意禁止手动赋值，只能是null
        //一对多外键导航
        [Navigate(NavigateType.OneToMany, nameof(ClassA.BIZ_U9_RECEIPT_SNId))]//ClassA表中的BIZ_U9_RECEIPT_SNId
        public List<ClassA> ClassAList { get; set; }//注意禁止手动赋值，只能是null
        //多对多外键导航
        [Navigate(typeof(MappingClass), nameof(MappingClass.BIZ_U9_RECEIPT_SNId), nameof(MappingClass.ClassAId))]//注意顺序
        public List<ClassA> ClassAList { get; set; } //注意禁止手动赋值，只能是null
        */
        #endregion

        #region æžšä¸¾å˜é‡
        /*例子
        public enum FieldNames
        {
            [Description("枚举描述0")]
            Enum0,
            [Description("枚举描述1")]
            Enum1,
        }
        */
        #endregion

        #region å…¬å…±æ–¹æ³•

        #endregion

    }//endClass
}