From 27f9d29760ee5457d7c0cb9e12cacab33c08eaea Mon Sep 17 00:00:00 2001
From: Rodney Chen <rodney.chen@hotmail.com>
Date: 星期四, 06 三月 2025 19:37:01 +0800
Subject: [PATCH] 更新WMS实体
---
Tiger.Model.Net/Entitys/WMS/BIZ_U9_ASN_DTL.cs | 14 +
Tiger.Model.Net/Entitys/WMS/BIZ_U9_ASN.cs | 10 +
Tiger.Model.Net/Entitys/WMS/BIZ_U9_RECEIPT_DTL.cs | 156 +++++++++++++++++
Tiger.Model.Net/Entitys/WMS/BIZ_U9_RECEIPT_SN.cs | 141 +++++++++++++++
Tiger.Model.Net/Entitys/WMS/BIZ_U9_RECEIPT.cs | 161 +++++++++++++++++
5 files changed, 480 insertions(+), 2 deletions(-)
diff --git a/Tiger.Model.Net/Entitys/WMS/BIZ_U9_ASN.cs b/Tiger.Model.Net/Entitys/WMS/BIZ_U9_ASN.cs
index 9ac8fa2..57da56e 100644
--- a/Tiger.Model.Net/Entitys/WMS/BIZ_U9_ASN.cs
+++ b/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("收货人")]
diff --git a/Tiger.Model.Net/Entitys/WMS/BIZ_U9_ASN_DTL.cs b/Tiger.Model.Net/Entitys/WMS/BIZ_U9_ASN_DTL.cs
index b0612aa..a3ca195 100644
--- a/Tiger.Model.Net/Entitys/WMS/BIZ_U9_ASN_DTL.cs
+++ b/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>
diff --git a/Tiger.Model.Net/Entitys/WMS/BIZ_U9_RECEIPT.cs b/Tiger.Model.Net/Entitys/WMS/BIZ_U9_RECEIPT.cs
new file mode 100644
index 0000000..c8be966
--- /dev/null
+++ b/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
+}
\ No newline at end of file
diff --git a/Tiger.Model.Net/Entitys/WMS/BIZ_U9_RECEIPT_DTL.cs b/Tiger.Model.Net/Entitys/WMS/BIZ_U9_RECEIPT_DTL.cs
new file mode 100644
index 0000000..0ccd778
--- /dev/null
+++ b/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
+}
\ No newline at end of file
diff --git a/Tiger.Model.Net/Entitys/WMS/BIZ_U9_RECEIPT_SN.cs b/Tiger.Model.Net/Entitys/WMS/BIZ_U9_RECEIPT_SN.cs
new file mode 100644
index 0000000..4e1de0f
--- /dev/null
+++ b/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
+}
\ No newline at end of file
--
Gitblit v1.9.3