using System;
using SqlSugar;
using System.Linq;
using System.ComponentModel;
using System.Collections.Generic;
namespace Tiger.Model
{
///
/// 实体:送货单(U9)明细
///
[Description("Primary:ID")]
[DisplayName("送货单(U9)明细")]
[Serializable]
[SugarTable("BIZ_U9_ASN_DTL")]
public class BIZ_U9_ASN_DTL : DbEntityWithAuth
{
#region 构造函数
///
/// 实体:送货单(U9)明细
///
public BIZ_U9_ASN_DTL() {}
#endregion
#region 公共属性
///
/// 单据号
///
[DisplayName("单据号")]
public string ORDER_NO { get; set; }
///
/// 单据行号
///
[DisplayName("单据行号")]
public string LINE_NO { get; set; }
///
/// 状态(同单据状态)
///
[DisplayName("状态(同单据状态)")]
public int STATUS { get; set; }
///
/// 物料编码
///
[DisplayName("物料编码")]
public string ITEM_CODE { get; set; }
///
/// 单位
///
[DisplayName("单位")]
public string UNIT { get; set; }
///
/// 单据数量
///
[DisplayName("单据数量")]
public double QTY { get; set; }
///
/// 包装数量
///
[DisplayName("包装数量")]
public double QTY_PACKING { get; set; }
///
/// 入库数量
///
[DisplayName("入库数量")]
public double QTY_IN { get; set; }
///
/// 良品数量
///
[DisplayName("良品数量")]
public double QTY_OK { get; set; }
///
/// 退货数量
///
[DisplayName("退货数量")]
public double QTY_RETURN { get; set; }
///
/// 赠品数量
///
[DisplayName("赠品数量")]
public double QTY_GIFT { get; set; }
///
/// 是否赠品(Y/N)
///
[DisplayName("是否赠品(Y/N)")]
public string IS_GIFT { get; set; }
///
/// 供应商编码
///
[DisplayName("供应商编码")]
public string SUPP_CODE { get; set; }
///
/// 供应商批次号
///
[DisplayName("供应商批次号")]
public string SUPP_LOTNO { get; set; }
///
/// 批次号
///
[DisplayName("批次号")]
public string LOTNO { get; set; }
///
/// 采购单ID
///
[DisplayName("采购单ID")]
public string PO_ID { get; set; }
///
/// 采购单号
///
[DisplayName("采购单号")]
public string PO_NO { get; set; }
///
/// 采购单行号
///
[DisplayName("采购单行号")]
public string PO_LINE { get; set; }
///
/// 采购数量
///
[DisplayName("采购数量")]
public double PO_QTY { get; set; }
///
/// 收货单ID
///
[DisplayName("收货单ID")]
public string RECEIVER_ID { get; set; }
///
/// 收货单号
///
[DisplayName("收货单号")]
public string RECEIVER_NO { get; set; }
///
/// 收货单行号
///
[DisplayName("收货单行号")]
public string RECEIVER_LINE { get; set; }
///
/// 收货人
///
[DisplayName("收货人")]
public string RECEIVER { get; set; }
///
/// 收货日期
///
[DisplayName("收货日期")]
public DateTime RECEIVE_DATE { get; set; } = DateTime.MinValue;
///
/// 送检单ID
///
[DisplayName("送检单ID")]
public string IQC_ID { get; set; }
///
/// 送检单号
///
[DisplayName("送检单号")]
public string IQC_NO { get; set; }
///
/// ERP编码
///
[DisplayName("ERP编码")]
public string ERP_CODE { get; set; }
///
/// 备注
///
[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 SnList { get; set; } = new List();
#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 ClassAList { get; set; }//注意禁止手动赋值,只能是null
//多对多外键导航
[Navigate(typeof(MappingClass), nameof(MappingClass.BIZ_U9_ASN_DTLId), nameof(MappingClass.ClassAId))]//注意顺序
public List 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 _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
}