| | |
| | | namespace Tiger.Model |
| | | { |
| | | /// <summary> |
| | | /// 实体:送货单(U9)明细 |
| | | /// 实体:送货单(U9)明细 |
| | | /// </summary> |
| | | [Description("Primary:ID")] |
| | | [DisplayName("送货单(U9)明细")] |
| | | [DisplayName("送货单(U9)明细")] |
| | | [Serializable] |
| | | [SugarTable("BIZ_U9_ASN_DTL")] |
| | | public class BIZ_U9_ASN_DTL : DbEntityWithAuth |
| | | { |
| | | #region 构造函数 |
| | | #region 构造函数 |
| | | /// <summary> |
| | | /// 实体:送货单(U9)明细 |
| | | /// 实体:送货单(U9)明细 |
| | | /// </summary> |
| | | public BIZ_U9_ASN_DTL() {} |
| | | #endregion |
| | | |
| | | #region 公共属性 |
| | | #region 公共属性 |
| | | /// <summary> |
| | | /// 单据号 |
| | | /// 单据号 |
| | | /// </summary> |
| | | [DisplayName("单据号")] |
| | | [DisplayName("单据号")] |
| | | public string ORDER_NO { get; set; } |
| | | /// <summary> |
| | | /// 单据行号 |
| | | /// 单据行号 |
| | | /// </summary> |
| | | [DisplayName("单据行号")] |
| | | [DisplayName("单据行号")] |
| | | public string LINE_NO { get; set; } |
| | | /// <summary> |
| | | /// 状态(同单据状态) |
| | | /// 状态(同单据状态) |
| | | /// </summary> |
| | | [DisplayName("状态(同单据状态)")] |
| | | [DisplayName("状态(同单据状态)")] |
| | | public int STATUS { get; set; } |
| | | /// <summary> |
| | | /// 物料编码 |
| | | /// 物料编码 |
| | | /// </summary> |
| | | [DisplayName("物料编码")] |
| | | [DisplayName("物料编码")] |
| | | public string ITEM_CODE { get; set; } |
| | | /// <summary> |
| | | /// 单位 |
| | | /// 单位 |
| | | /// </summary> |
| | | [DisplayName("单位")] |
| | | [DisplayName("单位")] |
| | | public string UNIT { get; set; } |
| | | /// <summary> |
| | | /// 单据数量 |
| | | /// 单据数量 |
| | | /// </summary> |
| | | [DisplayName("单据数量")] |
| | | [DisplayName("单据数量")] |
| | | public double QTY { get; set; } |
| | | /// <summary> |
| | | /// 包装数量 |
| | | /// 包装数量 |
| | | /// </summary> |
| | | [DisplayName("包装数量")] |
| | | [DisplayName("包装数量")] |
| | | public double QTY_PACKING { get; set; } |
| | | /// <summary> |
| | | /// 入库数量 |
| | | /// 入库数量 |
| | | /// </summary> |
| | | [DisplayName("入库数量")] |
| | | [DisplayName("入库数量")] |
| | | public double QTY_IN { get; set; } |
| | | /// <summary> |
| | | /// 良品数量 |
| | | /// 良品数量 |
| | | /// </summary> |
| | | [DisplayName("良品数量")] |
| | | [DisplayName("良品数量")] |
| | | public double QTY_OK { get; set; } |
| | | /// <summary> |
| | | /// 退货数量 |
| | | /// 退货数量 |
| | | /// </summary> |
| | | [DisplayName("退货数量")] |
| | | [DisplayName("退货数量")] |
| | | public double QTY_RETURN { get; set; } |
| | | /// <summary> |
| | | /// 是否赠品(Y/N) |
| | | /// 赠品数量 |
| | | /// </summary> |
| | | [DisplayName("是否赠品(Y/N)")] |
| | | [DisplayName("赠品数量")] |
| | | public double QTY_GIFT { get; set; } |
| | | /// <summary> |
| | | /// 是否赠品(Y/N) |
| | | /// </summary> |
| | | [DisplayName("是否赠品(Y/N)")] |
| | | public string IS_GIFT { get; set; } |
| | | /// <summary> |
| | | /// 供应商编码 |
| | | /// 供应商编码 |
| | | /// </summary> |
| | | [DisplayName("供应商编码")] |
| | | [DisplayName("供应商编码")] |
| | | public string SUPP_CODE { get; set; } |
| | | /// <summary> |
| | | /// 供应商批次号 |
| | | /// 供应商批次号 |
| | | /// </summary> |
| | | [DisplayName("供应商批次号")] |
| | | [DisplayName("供应商批次号")] |
| | | public string SUPP_LOTNO { get; set; } |
| | | /// <summary> |
| | | /// 批次号 |
| | | /// 批次号 |
| | | /// </summary> |
| | | [DisplayName("批次号")] |
| | | [DisplayName("批次号")] |
| | | public string LOTNO { get; set; } |
| | | /// <summary> |
| | | /// 采购单ID |
| | | /// 采购单ID |
| | | /// </summary> |
| | | [DisplayName("采购单ID")] |
| | | [DisplayName("采购单ID")] |
| | | public string PO_ID { get; set; } |
| | | /// <summary> |
| | | /// 采购单号 |
| | | /// 采购单号 |
| | | /// </summary> |
| | | [DisplayName("采购单号")] |
| | | [DisplayName("采购单号")] |
| | | public string PO_NO { get; set; } |
| | | /// <summary> |
| | | /// 采购单行号 |
| | | /// 采购单行号 |
| | | /// </summary> |
| | | [DisplayName("采购单行号")] |
| | | [DisplayName("采购单行号")] |
| | | public string PO_LINE { get; set; } |
| | | /// <summary> |
| | | /// 送检单ID |
| | | /// 采购数量 |
| | | /// </summary> |
| | | [DisplayName("送检单ID")] |
| | | [DisplayName("采购数量")] |
| | | public double PO_QTY { get; set; } |
| | | /// <summary> |
| | | /// 收货单ID |
| | | /// </summary> |
| | | [DisplayName("收货单ID")] |
| | | public string RECEIVER_ID { get; set; } |
| | | /// <summary> |
| | | /// 收货单号 |
| | | /// </summary> |
| | | [DisplayName("收货单号")] |
| | | public string RECEIVER_NO { get; set; } |
| | | /// <summary> |
| | | /// 收货单行号 |
| | | /// </summary> |
| | | [DisplayName("收货单行号")] |
| | | public string RECEIVER_LINE { get; set; } |
| | | /// <summary> |
| | | /// 收货人 |
| | | /// </summary> |
| | | [DisplayName("收货人")] |
| | | public string RECEIVER { get; set; } |
| | | /// <summary> |
| | | /// 收货日期 |
| | | /// </summary> |
| | | [DisplayName("收货日期")] |
| | | public DateTime RECEIVE_DATE { get; set; } = DateTime.MinValue; |
| | | /// <summary> |
| | | /// 送检单ID |
| | | /// </summary> |
| | | [DisplayName("送检单ID")] |
| | | public string IQC_ID { get; set; } |
| | | /// <summary> |
| | | /// 送检单号 |
| | | /// 送检单号 |
| | | /// </summary> |
| | | [DisplayName("送检单号")] |
| | | [DisplayName("送检单号")] |
| | | public string IQC_NO { get; set; } |
| | | /// <summary> |
| | | /// 备注 |
| | | /// ERP编码 |
| | | /// </summary> |
| | | [DisplayName("备注")] |
| | | [DisplayName("ERP编码")] |
| | | public string ERP_CODE { get; set; } |
| | | /// <summary> |
| | | /// 备注 |
| | | /// </summary> |
| | | [DisplayName("备注")] |
| | | public string REMARK { get; set; } |
| | | /// <summary> |
| | | /// 追溯信息 |
| | | /// </summary> |
| | | [DisplayName("追溯信息")] |
| | | public string TRACE_INFO { get; set; } |
| | | #endregion |
| | | |
| | | #region 虚拟属性 |
| | | /*例子 |
| | | #region 虚拟属性 |
| | | /*例子 |
| | | [SugarColumn(IsIgnore = true)] |
| | | public string FieldName { get; set; } |
| | | */ |
| | |
| | | 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 |
| | | #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 |
| | | [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 枚举变量 |
| | | /*例子 |
| | | #region 枚举变量 |
| | | /*例子 |
| | | public enum FieldNames |
| | | { |
| | | [Description("枚举描述0")] |
| | | [Description("枚举描述0")] |
| | | Enum0, |
| | | [Description("枚举描述1")] |
| | | [Description("枚举描述1")] |
| | | Enum1, |
| | | } |
| | | */ |
| | | #endregion |
| | | #endregion |
| | | |
| | | #region 公共方法 |
| | | #region 公共方法 |
| | | |
| | | #endregion |
| | | #endregion |
| | | |
| | | }//endClass |
| | | }//endClass |
| | | } |