using System; using SqlSugar; using System.Linq; using System.ComponentModel; using System.Collections.Generic; namespace Tiger.Model { /// /// 实体:其他出库单(ERP)明细 /// [Description("Primary:ID")] [Serializable] [SugarTable("V_BIZ_ERP_OTH_OUT_DTL")] public class V_BIZ_ERP_OTH_OUT_DTL : DbEntityWithAuth { #region 构造函数 /// /// 实体:其他出库单(ERP)明细 /// public V_BIZ_ERP_OTH_OUT_DTL() {} #endregion #region 公共属性 /// /// 单据号码 /// public string BILLCODE { get; set; } /// /// 单据行号 /// public string BILLLINE { get; set; } /// /// 单据行状态 /// public int LINESTATUS { get; set; } /// /// 物料代码 /// public string ITEM_CODE { get; set; } /// /// 单位代码 /// public string UNITCODE { get; set; } /// /// 需求数量 /// public double PRQTY { get; set; } /// /// 数量 /// public double QTY { get; set; } /// /// 送货时间 /// public DateTime DELIVERYDATE { get; set; } = DateTime.MinValue; /// /// 仓库代码 /// public string WAREHOUSECODE { get; set; } /// /// 来源类型 /// public int SOURCETYPE { get; set; } /// /// 来源代码 /// public string SOURCECODE { get; set; } /// /// 来源行号 /// public string SOURCELINE { get; set; } /// /// 备注 /// public string REMARK { get; set; } /// /// ERP单据代码 /// public string ERP_BILL_CODE { get; set; } /// /// 物料名称 /// public string ITEM_NAME { get; set; } /// /// 欠发数量 /// public double OWE_QTY { get; set; } #endregion #region 虚拟属性 /*例子 [SugarColumn(IsIgnore = true)] public string FieldName { get; set; } */ #endregion #region 外键属性 /*例子 //一对一外键导航 [Navigate(NavigateType.OneToOne, nameof(ClassAId))]//一对一 ClassAId是BIZ_ERP_OTH_OUT_DTL类里面的外键ID字段 public ClassA ClassA { get; set; } //注意禁止手动赋值,只能是null //一对多外键导航 [Navigate(NavigateType.OneToMany, nameof(ClassA.BIZ_ERP_OTH_OUT_DTLId))]//ClassA表中的BIZ_ERP_OTH_OUT_DTLId public List ClassAList { get; set; }//注意禁止手动赋值,只能是null //多对多外键导航 [Navigate(typeof(MappingClass), nameof(MappingClass.BIZ_ERP_OTH_OUT_DTLId), nameof(MappingClass.ClassAId))]//注意顺序 public List ClassAList { get; set; } //注意禁止手动赋值,只能是null */ [Navigate(NavigateType.OneToMany, nameof(BAS_ITEM.ITEM_CODE), nameof(ITEM_CODE), "GHOST_ROW = 0")] 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 }