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 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 }