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_ASN_DTL")]
|
public class BIZ_U9_ASN_DTL : DbEntityWithAuth
|
{
|
#region 构造函数
|
/// <summary>
|
/// 实体：送货单(U9)明细
|
/// </summary>
|
public BIZ_U9_ASN_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_RETURN { get; set; }
|
/// <summary>
|
/// 赠品数量
|
/// </summary>
|
[DisplayName("赠品数量")]
|
public double QTY_GIFT { get; set; }
|
/// <summary>
|
/// 是否赠品(Y/N)
|
/// </summary>
|
[DisplayName("是否赠品(Y/N)")]
|
public string IS_GIFT { get; set; }
|
/// <summary>
|
/// 供应商编码
|
/// </summary>
|
[DisplayName("供应商编码")]
|
public string SUPP_CODE { get; set; }
|
/// <summary>
|
/// 供应商批次号
|
/// </summary>
|
[DisplayName("供应商批次号")]
|
public string SUPP_LOTNO { get; set; }
|
/// <summary>
|
/// 批次号
|
/// </summary>
|
[DisplayName("批次号")]
|
public string LOTNO { get; set; }
|
/// <summary>
|
/// 采购单ID
|
/// </summary>
|
[DisplayName("采购单ID")]
|
public string PO_ID { get; set; }
|
/// <summary>
|
/// 采购单号
|
/// </summary>
|
[DisplayName("采购单号")]
|
public string PO_NO { get; set; }
|
/// <summary>
|
/// 采购单行号
|
/// </summary>
|
[DisplayName("采购单行号")]
|
public string PO_LINE { get; set; }
|
/// <summary>
|
/// 采购数量
|
/// </summary>
|
[DisplayName("采购数量")]
|
public double PO_QTY { get; set; }
|
/// <summary>
|
/// 送检单ID
|
/// </summary>
|
[DisplayName("送检单ID")]
|
public string IQC_ID { get; set; }
|
/// <summary>
|
/// 送检单号
|
/// </summary>
|
[DisplayName("送检单号")]
|
public string IQC_NO { 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;
|
[SugarColumn(IsIgnore = true)]
|
public double QTY_COUNTED { get; set; } = 0;
|
[SugarColumn(IsIgnore = true)]
|
public List<BIZ_U9_ASN_SN> SnList { get; set; } = new List<BIZ_U9_ASN_SN>();
|
#endregion
|
|
#region 外键属性
|
/*例子
|
//一对一外键导航
|
[Navigate(NavigateType.OneToOne, nameof(ClassAId))]//一对一 ClassAId是BIZ_U9_ASN_DTL类里面的外键ID字段
|
public ClassA ClassA { get; set; } //注意禁止手动赋值，只能是null
|
//一对多外键导航
|
[Navigate(NavigateType.OneToMany, nameof(ClassA.BIZ_U9_ASN_DTLId))]//ClassA表中的BIZ_U9_ASN_DTLId
|
public List<ClassA> ClassAList { get; set; }//注意禁止手动赋值，只能是null
|
//多对多外键导航
|
[Navigate(typeof(MappingClass), nameof(MappingClass.BIZ_U9_ASN_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
|
}
|
