| | |
| | | using System.Linq; |
| | | using System.ComponentModel; |
| | | using System.Collections.Generic; |
| | | using Tiger.Model.Base; |
| | | |
| | | namespace Tiger.Model |
| | | { |
| | |
| | | /// 实体:调拨单(WMS)明细 |
| | | /// </summary> |
| | | [Description("Primary:ID")] |
| | | [DisplayName("调拨单(WMS)明细")] |
| | | [Serializable] |
| | | [SugarTable("BIZ_WMS_TRANSFER_DTL")] |
| | | public class BIZ_WMS_TRANSFER_DTL : DbEntityWithAuth |
| | | { |
| | | public class BIZ_WMS_TRANSFER_DTL : DbEntityWithAuth, iPrepPickItem |
| | | { |
| | | #region 构造函数 |
| | | /// <summary> |
| | | /// 实体:调拨单(WMS)明细 |
| | |
| | | |
| | | #region 公共属性 |
| | | /// <summary> |
| | | /// 单据代码 |
| | | /// 调拨单号 |
| | | /// </summary> |
| | | public string BILLCODE { get; set; } |
| | | [DisplayName("调拨单号")] |
| | | public string ORDER_NO { get; set; } |
| | | /// <summary> |
| | | /// 单据行号 |
| | | /// 调拨单行号 |
| | | /// </summary> |
| | | public string BILLLINE { get; set; } |
| | | [DisplayName("调拨单行号")] |
| | | public string ORDER_LINE { get; set; } |
| | | /// <summary> |
| | | /// 单据行状态 |
| | | /// </summary> |
| | | public int LINESTATUS { get; set; } |
| | | [DisplayName("单据行状态")] |
| | | public int STATUS { get; set; } |
| | | /// <summary> |
| | | /// 物料编码 |
| | | /// </summary> |
| | | [DisplayName("物料编码")] |
| | | public string ITEM_CODE { get; set; } |
| | | /// <summary> |
| | | /// 单位代码 |
| | | /// 单位 |
| | | /// </summary> |
| | | public string UNITCODE { get; set; } |
| | | [DisplayName("单位")] |
| | | public string UNIT { get; set; } |
| | | /// <summary> |
| | | /// 需求数量 |
| | | /// </summary> |
| | | public decimal PRQTY { get; set; } |
| | | [DisplayName("需求数量")] |
| | | public double QTY_REQ { get; set; } |
| | | /// <summary> |
| | | /// 出库数量 |
| | | /// 调出数量 |
| | | /// </summary> |
| | | public decimal OUTQTY { get; set; } |
| | | [DisplayName("调出数量")] |
| | | public double QTY_OUT { get; set; } |
| | | /// <summary> |
| | | /// 入库数量 |
| | | /// 拨入数量 |
| | | /// </summary> |
| | | public decimal INQTY { get; set; } |
| | | [DisplayName("拨入数量")] |
| | | public double QTY_IN { get; set; } |
| | | /// <summary> |
| | | /// 出库仓库代码 |
| | | /// 调出仓库 |
| | | /// </summary> |
| | | public string OUTWAREHOUSECODE { get; set; } |
| | | [DisplayName("调出仓库")] |
| | | public string OUT_WH_CODE { get; set; } |
| | | /// <summary> |
| | | /// 入库仓库代码 |
| | | /// 拨入仓库 |
| | | /// </summary> |
| | | public string INWAREHOUSECODE { 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> |
| | | /// ERP单据代码 |
| | | /// </summary> |
| | | public string ERP_BILL_CODE { get; set; } |
| | | /// <summary> |
| | | /// 库存数量 |
| | | /// </summary> |
| | | public decimal INVENTORYQTY { get; set; } = 0; |
| | | [DisplayName("拨入仓库")] |
| | | public string IN_WH_CODE { get; set; } |
| | | /// <summary> |
| | | /// 拨入批号 |
| | | /// 调出储位 |
| | | /// </summary> |
| | | [DisplayName("调出储位")] |
| | | public string OUT_LOCATION_CODE { get; set; } |
| | | /// <summary> |
| | | /// 拨入储位 |
| | | /// </summary> |
| | | public string BATCH_NO_IN { get; set; } |
| | | [DisplayName("拨入储位")] |
| | | public string IN_LOCATION_CODE { get; set; } |
| | | /// <summary> |
| | | /// 拨出批号 |
| | | /// </summary> |
| | | public string BATCH_NO_OUT { get; set; } |
| | | #endregion |
| | | [DisplayName("拨出批号")] |
| | | public string OUT_LOTNO { get; set; } |
| | | /// <summary> |
| | | /// 拨入批号 |
| | | /// </summary> |
| | | [DisplayName("拨入批号")] |
| | | public string IN_LOTNO { get; set; } |
| | | /// <summary> |
| | | /// 来源单据编码,多个用“,”分隔 |
| | | /// </summary> |
| | | [DisplayName("来源单据编码,多个用“,”分隔")] |
| | | public string SOURCE_CODE { get; set; } |
| | | /// <summary> |
| | | /// 来源单号,多个用“,”分隔,跟编码一一对应 |
| | | /// </summary> |
| | | [DisplayName("来源单号,多个用“,”分隔,跟编码一一对应")] |
| | | public string SOURCE_ORDER { get; set; } |
| | | /// <summary> |
| | | /// 来源单行号,多个用“,”分隔,跟编码一一对应 |
| | | /// </summary> |
| | | [DisplayName("来源单行号,多个用“,”分隔,跟编码一一对应")] |
| | | public string SOURCE_LINE { get; set; } |
| | | /// <summary> |
| | | /// ERP单据号码 |
| | | /// </summary> |
| | | [DisplayName("ERP单据号码")] |
| | | public string ERP_ORDER { get; set; } |
| | | /// <summary> |
| | | /// 备注 |
| | | /// </summary> |
| | | [DisplayName("备注")] |
| | | public string REMARK { get; set; } |
| | | #endregion |
| | | |
| | | #region 虚拟属性 |
| | | /*例子 |
| | | #region 虚拟属性 |
| | | /*例子 |
| | | [SugarColumn(IsIgnore = true)] |
| | | public string FieldName { get; set; } |
| | | */ |
| | | #endregion |
| | | #endregion |
| | | |
| | | #region 外键属性 |
| | | /*例子 |
| | | #region 外键属性 |
| | | /*例子 |
| | | //一对一外键导航 |
| | | [Navigate(NavigateType.OneToOne, nameof(ClassAId))]//一对一 ClassAId是BIZ_WMS_TRANSFER_DTL类里面的外键ID字段 |
| | | public ClassA ClassA { get; set; } //注意禁止手动赋值,只能是null |
| | |
| | | [Navigate(typeof(MappingClass), nameof(MappingClass.BIZ_WMS_TRANSFER_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; } //注意禁止手动赋值,只能是null |
| | | [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 枚举变量 |
| | |
| | | #endregion |
| | | |
| | | #region 公共方法 |
| | | |
| | | public BIZ_WMS_PREP_SRC_DTL GetPickItem() |
| | | { |
| | | return new BIZ_WMS_PREP_SRC_DTL() |
| | | { |
| | | Source = this, |
| | | AUTH_ORG = AUTH_ORG, |
| | | ITEM_CODE = ITEM_CODE, |
| | | UNIT = UNIT, |
| | | SOURCE_CODE = nameof(BIZ_WMS_TRANSFER), |
| | | SOURCE_ORDER = ORDER_NO, |
| | | SOURCE_LINE = ORDER_LINE, |
| | | QTY_REQ = QTY_REQ, |
| | | QTY_ACT_REQ = QTY_REQ - QTY_OUT, |
| | | }; |
| | | } |
| | | #endregion |
| | | |
| | | }//endClass |