From 9c24799e797b079f49452a0c8d56f6ae6c599a54 Mon Sep 17 00:00:00 2001
From: Rodney Chen <rodney.chen@hotmail.com>
Date: 星期五, 27 十二月 2024 10:19:30 +0800
Subject: [PATCH] 优化物料信息导航
---
Tiger.Model.Net/Entitys/WMS/V_BIZ_ERP_SALE_OUT_DTL.cs | 84 +++++++++++++++++++++--------------------
1 files changed, 43 insertions(+), 41 deletions(-)
diff --git a/Tiger.Model.Net/Entitys/WMS/V_BIZ_ERP_SALE_OUT_DTL.cs b/Tiger.Model.Net/Entitys/WMS/V_BIZ_ERP_SALE_OUT_DTL.cs
index 93c91a1..fe2d831 100644
--- a/Tiger.Model.Net/Entitys/WMS/V_BIZ_ERP_SALE_OUT_DTL.cs
+++ b/Tiger.Model.Net/Entitys/WMS/V_BIZ_ERP_SALE_OUT_DTL.cs
@@ -7,127 +7,129 @@
namespace Tiger.Model
{
/// <summary>
- /// 实体：销售出库单(ERP)明细
+ /// 瀹炰綋锛氶攢鍞嚭搴撳崟(ERP)鏄庣粏
/// </summary>
[Description("Primary:ID")]
[Serializable]
[SugarTable("V_BIZ_ERP_SALE_OUT_DTL")]
public class V_BIZ_ERP_SALE_OUT_DTL : DbEntityWithAuth
{
- #region 构造函数
+ #region 鏋勯�犲嚱鏁�
/// <summary>
- /// 实体：销售出库单(ERP)明细
+ /// 瀹炰綋锛氶攢鍞嚭搴撳崟(ERP)鏄庣粏
/// </summary>
public V_BIZ_ERP_SALE_OUT_DTL() {}
#endregion
- #region 公共属性
+ #region 鍏叡灞炴��
/// <summary>
- /// 单据代码
+ /// 鍗曟嵁浠ｇ爜
/// </summary>
public string BILLCODE { get; set; }
/// <summary>
- /// 单据行号
+ /// 鍗曟嵁琛屽彿
/// </summary>
public string BILLLINE { get; set; }
/// <summary>
- /// 单据行状态
+ /// 鍗曟嵁琛岀姸鎬�
/// </summary>
public int LINESTATUS { get; set; }
/// <summary>
- /// 物料编码
+ /// 鐗╂枡缂栫爜
/// </summary>
public string ITEM_CODE { get; set; }
/// <summary>
- /// 单位代码
+ /// 鍗曚綅浠ｇ爜
/// </summary>
public string UNITCODE { get; set; }
/// <summary>
- /// 需求数量
+ /// 闇�姹傛暟閲�
/// </summary>
public decimal PRQTY { get; set; }
/// <summary>
- /// 数量
+ /// 鏁伴噺
/// </summary>
public decimal QTY { get; set; }
/// <summary>
- /// 发货日期
+ /// 鍙戣揣鏃ユ湡
/// </summary>
public DateTime DELIVERYDATE { get; set; } = DateTime.MinValue;
/// <summary>
- /// 仓库代码
+ /// 浠撳簱浠ｇ爜
/// </summary>
public string WAREHOUSECODE { get; set; }
/// <summary>
- /// 来源单据类型
+ /// 鏉ユ簮鍗曟嵁绫诲瀷
/// </summary>
public int SOURCETYPE { get; set; }
/// <summary>
- /// 来源单据代码
+ /// 鏉ユ簮鍗曟嵁浠ｇ爜
/// </summary>
public string SOURCECODE { get; set; }
/// <summary>
- /// 来源单据行号
+ /// 鏉ユ簮鍗曟嵁琛屽彿
/// </summary>
public string SOURCELINE { get; set; }
/// <summary>
- /// 备注
+ /// 澶囨敞
/// </summary>
public string REMARK { get; set; }
/// <summary>
- /// 客户代码
+ /// 瀹㈡埛浠ｇ爜
/// </summary>
public string CUST_CODE { get; set; }
/// <summary>
- /// ERP单据代码
+ /// ERP鍗曟嵁浠ｇ爜
/// </summary>
public string ERP_BILL_CODE { get; set; }
/// <summary>
- /// 物料名称
+ /// 鐗╂枡鍚嶇О
/// </summary>
public string ITEM_NAME { get;set; }
/// <summary>
- /// 欠发数量
+ /// 娆犲彂鏁伴噺
/// </summary>
public decimal OWE_QTY { get; set; }
#endregion
- #region 虚拟属性
- /*例子
+ #region 铏氭嫙灞炴��
+ /*渚嬪瓙
[SugarColumn(IsIgnore = true)]
public string FieldName { get; set; }
*/
#endregion
- #region 外键属性
- /*例子
- //一对一外键导航
- [Navigate(NavigateType.OneToOne, nameof(ClassAId))]//一对一 ClassAId是BIZ_ERP_SALE_OUT_DTL类里面的外键ID字段
- public ClassA ClassA { get; set; } //注意禁止手动赋值，只能是null
- //一对多外键导航
- [Navigate(NavigateType.OneToMany, nameof(ClassA.BIZ_ERP_SALE_OUT_DTLId))]//ClassA表中的BIZ_ERP_SALE_OUT_DTLId
- public List<ClassA> ClassAList { get; set; }//注意禁止手动赋值，只能是null
- //多对多外键导航
- [Navigate(typeof(MappingClass), nameof(MappingClass.BIZ_ERP_SALE_OUT_DTLId), nameof(MappingClass.ClassAId))]//注意顺序
- public List<ClassA> ClassAList { get; set; } //注意禁止手动赋值，只能是null
+ #region 澶栭敭灞炴��
+ /*渚嬪瓙
+ //涓�瀵逛竴澶栭敭瀵艰埅
+ [Navigate(NavigateType.OneToOne, nameof(ClassAId))]//涓�瀵逛竴 ClassAId鏄疊IZ_ERP_SALE_OUT_DTL绫婚噷闈㈢殑澶栭敭ID瀛楁
+ public ClassA ClassA { get; set; } //娉ㄦ剰绂佹鎵嬪姩璧嬪�硷紝鍙兘鏄痭ull
+ //涓�瀵瑰澶栭敭瀵艰埅
+ [Navigate(NavigateType.OneToMany, nameof(ClassA.BIZ_ERP_SALE_OUT_DTLId))]//ClassA琛ㄤ腑鐨凚IZ_ERP_SALE_OUT_DTLId
+ public List<ClassA> ClassAList { get; set; }//娉ㄦ剰绂佹鎵嬪姩璧嬪�硷紝鍙兘鏄痭ull
+ //澶氬澶氬閿鑸�
+ [Navigate(typeof(MappingClass), nameof(MappingClass.BIZ_ERP_SALE_OUT_DTLId), nameof(MappingClass.ClassAId))]//娉ㄦ剰椤哄簭
+ public List<ClassA> ClassAList { get; set; } //娉ㄦ剰绂佹鎵嬪姩璧嬪�硷紝鍙兘鏄痭ull
*/
- [Navigate(NavigateType.OneToOne, nameof(ITEM_CODE), nameof(BAS_ITEM.ITEM_CODE), "GHOST_ROW = 0")]//一对一 ClassAId是BIZ_ERP_PROD_OUT_DTL类里面的外键ID字段
- public BAS_ITEM ItemInfo { get; set; }
+ [Navigate(NavigateType.OneToMany, nameof(BAS_ITEM.ITEM_CODE), nameof(ITEM_CODE), "GHOST_ROW = 0")]
+ public List<BAS_ITEM> _ItemInfos { get; set; } //娉ㄦ剰绂佹鎵嬪姩璧嬪�硷紝鍙兘鏄痭ull
+ [SugarColumn(IsIgnore = true)]
+ public BAS_ITEM ItemInfo => _ItemInfos?.FirstOrDefault(q => q.AUTH_ORG == AUTH_ORG);
#endregion
- #region 枚举变量
- /*例子
+ #region 鏋氫妇鍙橀噺
+ /*渚嬪瓙
public enum FieldNames
{
- [Description("枚举描述0")]
+ [Description("鏋氫妇鎻忚堪0")]
Enum0,
- [Description("枚举描述1")]
+ [Description("鏋氫妇鎻忚堪1")]
Enum1,
}
*/
#endregion
- #region 公共方法
+ #region 鍏叡鏂规硶
#endregion
--
Gitblit v1.9.3