| | |
| | | namespace Tiger.Model |
| | | { |
| | | /// <summary> |
| | | /// 实体:销售出库单(ERP)明细 |
| | | /// 实体:销售出库单(ERP)明细 |
| | | /// </summary> |
| | | [Description("Primary:ID")] |
| | | [Serializable] |
| | | [SugarTable("V_BIZ_ERP_SALE_OUT_DTL")] |
| | | public class V_BIZ_ERP_SALE_OUT_DTL : DbEntityWithAuth |
| | | { |
| | | #region 构造函数 |
| | | #region 构造函数 |
| | | /// <summary> |
| | | /// 实体:销售出库单(ERP)明细 |
| | | /// 实体:销售出库单(ERP)明细 |
| | | /// </summary> |
| | | public V_BIZ_ERP_SALE_OUT_DTL() {} |
| | | #endregion |
| | | |
| | | #region 公共属性 |
| | | #region 公共属性 |
| | | /// <summary> |
| | | /// 单据代码 |
| | | /// 单据代码 |
| | | /// </summary> |
| | | public string BILLCODE { get; set; } |
| | | /// <summary> |
| | | /// 单据行号 |
| | | /// 单据行号 |
| | | /// </summary> |
| | | public string BILLLINE { get; set; } |
| | | /// <summary> |
| | | /// 单据行状态 |
| | | /// 单据行状态 |
| | | /// </summary> |
| | | public int LINESTATUS { get; set; } |
| | | /// <summary> |
| | | /// 物料编码 |
| | | /// 物料编码 |
| | | /// </summary> |
| | | public string ITEM_CODE { get; set; } |
| | | /// <summary> |
| | | /// 单位代码 |
| | | /// 单位代码 |
| | | /// </summary> |
| | | public string UNITCODE { get; set; } |
| | | /// <summary> |
| | | /// 需求数量 |
| | | /// 需求数量 |
| | | /// </summary> |
| | | public decimal PRQTY { get; set; } |
| | | public double PRQTY { get; set; } |
| | | /// <summary> |
| | | /// 数量 |
| | | /// 数量 |
| | | /// </summary> |
| | | public decimal QTY { get; set; } |
| | | public double QTY { get; set; } |
| | | /// <summary> |
| | | /// 发货日期 |
| | | /// 发货日期 |
| | | /// </summary> |
| | | public DateTime DELIVERYDATE { get; set; } = DateTime.MinValue; |
| | | /// <summary> |
| | | /// 仓库代码 |
| | | /// 仓库代码 |
| | | /// </summary> |
| | | public string WAREHOUSECODE { get; set; } |
| | | /// <summary> |
| | | /// 来源单据类型 |
| | | /// 来源单据类型 |
| | | /// </summary> |
| | | public int SOURCETYPE { get; set; } |
| | | /// <summary> |
| | | /// 来源单据代码 |
| | | /// 来源单据代码 |
| | | /// </summary> |
| | | public string SOURCECODE { get; set; } |
| | | /// <summary> |
| | | /// 来源单据行号 |
| | | /// 来源单据行号 |
| | | /// </summary> |
| | | public string SOURCELINE { get; set; } |
| | | /// <summary> |
| | | /// 备注 |
| | | /// 备注 |
| | | /// </summary> |
| | | public string REMARK { get; set; } |
| | | /// <summary> |
| | | /// 客户代码 |
| | | /// 客户代码 |
| | | /// </summary> |
| | | public string CUST_CODE { get; set; } |
| | | /// <summary> |
| | | /// ERP单据代码 |
| | | /// ERP单据代码 |
| | | /// </summary> |
| | | public string ERP_BILL_CODE { get; set; } |
| | | /// <summary> |
| | | /// 物料名称 |
| | | /// 物料名称 |
| | | /// </summary> |
| | | public string ITEM_NAME { get;set; } |
| | | /// <summary> |
| | | /// 欠发数量 |
| | | /// 欠发数量 |
| | | /// </summary> |
| | | public decimal OWE_QTY { get; set; } |
| | | public double OWE_QTY { get; set; } |
| | | #endregion |
| | | |
| | | #region 虚拟属性 |
| | | /*例子 |
| | | #region 虚拟属性 |
| | | /*例子 |
| | | [SugarColumn(IsIgnore = true)] |
| | | public string FieldName { get; set; } |
| | | */ |
| | | #endregion |
| | | |
| | | #region 外键属性 |
| | | /*例子 |
| | | //一对一外键导航 |
| | | [Navigate(NavigateType.OneToOne, nameof(ClassAId))]//一对一 ClassAId是BIZ_ERP_SALE_OUT_DTL类里面的外键ID字段 |
| | | public ClassA ClassA { get; set; } //注意禁止手动赋值,只能是null |
| | | //一对多外键导航 |
| | | [Navigate(NavigateType.OneToMany, nameof(ClassA.BIZ_ERP_SALE_OUT_DTLId))]//ClassA表中的BIZ_ERP_SALE_OUT_DTLId |
| | | public List<ClassA> ClassAList { get; set; }//注意禁止手动赋值,只能是null |
| | | //多对多外键导航 |
| | | [Navigate(typeof(MappingClass), nameof(MappingClass.BIZ_ERP_SALE_OUT_DTLId), nameof(MappingClass.ClassAId))]//注意顺序 |
| | | public List<ClassA> ClassAList { get; set; } //注意禁止手动赋值,只能是null |
| | | #region 外键属性 |
| | | /*例子 |
| | | //一对一外键导航 |
| | | [Navigate(NavigateType.OneToOne, nameof(ClassAId))]//一对一 ClassAId是BIZ_ERP_SALE_OUT_DTL类里面的外键ID字段 |
| | | public ClassA ClassA { get; set; } //注意禁止手动赋值,只能是null |
| | | //一对多外键导航 |
| | | [Navigate(NavigateType.OneToMany, nameof(ClassA.BIZ_ERP_SALE_OUT_DTLId))]//ClassA表中的BIZ_ERP_SALE_OUT_DTLId |
| | | public List<ClassA> ClassAList { get; set; }//注意禁止手动赋值,只能是null |
| | | //多对多外键导航 |
| | | [Navigate(typeof(MappingClass), nameof(MappingClass.BIZ_ERP_SALE_OUT_DTLId), nameof(MappingClass.ClassAId))]//注意顺序 |
| | | public List<ClassA> ClassAList { get; set; } //注意禁止手动赋值,只能是null |
| | | */ |
| | | [Navigate(NavigateType.OneToOne, nameof(ITEM_CODE), nameof(BAS_ITEM.ITEM_CODE), "GHOST_ROW = 0")]//一对一 ClassAId是BIZ_ERP_PROD_OUT_DTL类里面的外键ID字段 |
| | | public BAS_ITEM ItemInfo { get; set; } |
| | | [Navigate(NavigateType.OneToMany, nameof(BAS_ITEM.ITEM_CODE), nameof(ITEM_CODE), "GHOST_ROW = 0")] |
| | | 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 枚举变量 |
| | | /*例子 |
| | | #region 枚举变量 |
| | | /*例子 |
| | | public enum FieldNames |
| | | { |
| | | [Description("枚举描述0")] |
| | | [Description("枚举描述0")] |
| | | Enum0, |
| | | [Description("枚举描述1")] |
| | | [Description("枚举描述1")] |
| | | Enum1, |
| | | } |
| | | */ |
| | | #endregion |
| | | |
| | | #region 公共方法 |
| | | #region 公共方法 |
| | | |
| | | #endregion |
| | | |