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 double QTY_GIFT { get; set; }
|
/// <summary>
|
/// 批次号
|
/// </summary>
|
[DisplayName("批次号")]
|
public string LOTNO { get; set; }
|
/// <summary>
|
/// ERP单据状态
|
/// </summary>
|
[DisplayName("ERP单据状态")]
|
public string ERP_STATUS_CODE { get; set; }
|
/// <summary>
|
/// ERP单据状态名称
|
/// </summary>
|
[DisplayName("ERP单据状态名称")]
|
public string ERP_STATUS_NAME { 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>
|
/// ERP编码
|
/// </summary>
|
[DisplayName("ERP编码")]
|
public string ERP_CODE { get; set; }
|
/// <summary>
|
/// 备注
|
/// </summary>
|
[DisplayName("备注")]
|
public string REMARK { get; set; }
|
#endregion
|
|
#region 虚拟属性
|
/*例子
|
[SugarColumn(IsIgnore = true)]
|
public string FieldName { get; set; }
|
*/
|
[SugarColumn(IsIgnore = true)]
|
public string ITEM_NAME => ItemInfo?.ITEM_NAME;
|
[SugarColumn(IsIgnore = true)]
|
public string ITEM_DESC => ItemInfo?.ITEM_DESC;
|
#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
|
*/
|
[Navigate(NavigateType.OneToMany, nameof(BAS_ITEM.ITEM_CODE), nameof(ITEM_CODE), "GHOST_ROW = 0")]//一对一 ClassAId是MES_WIP_DATA类里面的外键ID字段
|
public List<BAS_ITEM> _ItemInfos { get; set; } //注意禁止手动赋值，只能是null
|
[SugarColumn(IsIgnore = true)]
|
public BAS_ITEM ItemInfo => _ItemInfos?.FirstOrDefault(q => q.AUTH_ORG == AUTH_ORG);
|
#endregion
|
|
#region 枚举变量
|
/*例子
|
public enum FieldNames
|
{
|
[Description("枚举描述0")]
|
Enum0,
|
[Description("枚举描述1")]
|
Enum1,
|
}
|
*/
|
#endregion
|
|
#region 公共方法
|
|
#endregion
|
|
}//endClass
|
}
|
