using System; using SqlSugar; using System.Linq; using System.ComponentModel; using System.Collections.Generic; using System.Security.Cryptography; namespace Tiger.Model { /// /// 实体:库存历史 /// [Description("Primary:ID")] [Serializable] [SugarTable("WMS_ITEM_HIS")] public class WMS_ITEM_HIS : DbEntityWithAuth { #region 构造函数 /// /// 实体:库存历史 /// public WMS_ITEM_HIS() {} /// /// 实体:库存历史 /// /// 历史的来源Item /// 追溯信息 public WMS_ITEM_HIS(WMS_ITEM item, string traceInfo) { ID = Guid.NewGuid().ToString("N"); CREATE_USER = item.CREATE_USER; UPDATE_USER = item.UPDATE_USER; AUTH_ORG = item.AUTH_ORG; AUTH_PROD = item.AUTH_PROD; AUTH_WH = item.AUTH_WH; SN = item.SN; SN_TYPE = item.SN_TYPE; STATUS = item.STATUS; ITEM_CODE = item.ITEM_CODE; QTY = item.QTY; UNIT = item.UNIT; PROD_DATE = item.PROD_DATE; FIRST_IN_DATE = item.FIRST_IN_DATE; TRANS_CODE = item.TRANS_CODE; TRANS_NO = item.TRANS_NO; TRANS_LINE = item.TRANS_LINE; SUPP_CODE = item.SUPP_CODE; SUPP_LOTNO = item.SUPP_LOTNO; LOTNO = item.LOTNO; CARTON_NO = item.CARTON_NO; PALLET_NO = item.PALLET_NO; WH_ID = item.WH_ID; REGION_ID = item.REGION_ID; SHELF_ID = item.SHELF_ID; LOCATION_ID = item.LOCATION_ID; ERP_WH = item.ERP_WH; IS_LOCKED = item.IS_LOCKED; REMARK = item.REMARK; TRACE_INFO = traceInfo; } #endregion #region 公共属性 /// /// 条码 /// public string SN { get; set; } /// /// 物料编码 /// public string ITEM_CODE { get; set; } /// /// 条码类型(规则编码) /// public string SN_TYPE { get; set; } /// /// 储存状态(0NotExists不存在|10Incoming送货中|20WaitTest待检验|21Rejected需退货|30WaitIn待入库|40InStore在库|50OffShelf已下架|60Sended已发料|65Received被接收|70Loaded已上料|80UseUp已耗尽|90Returned已退料|100Shipped已出货) /// public int STATUS { get; set; } /// /// 数量 /// public double QTY { get; set; } /// /// 单位 /// public string UNIT { get; set; } /// /// 生产日期 /// public DateTime PROD_DATE { get; set; } = DateTime.MinValue; /// /// 首次入库日期 /// public DateTime FIRST_IN_DATE { get; set; } = DateTime.MinValue; /// /// 业务单据编码 /// public string TRANS_CODE { get; set; } /// /// 业务单据号码 /// public string TRANS_NO { get; set; } /// /// 业务单据行号 /// public string TRANS_LINE { get; set; } /// /// 来源单据编码 /// public string SOURCE_CODE { get; set; } /// /// 来源单据号码 /// public string SOURCE_ORDER { get; set; } /// /// 来源单据行号 /// public string SOURCE_LINE { get; set; } /// /// 供应商代码 /// public string SUPP_CODE { get; set; } /// /// 供应商批次号 /// public string SUPP_LOTNO { get; set; } /// /// 批次号 /// public string LOTNO { get; set; } /// /// 箱号 /// public string CARTON_NO { get; set; } /// /// 栈板号 /// public string PALLET_NO { get; set; } /// /// 仓库代码 /// public string WH_ID { get; set; } /// /// 储区代码 /// public string REGION_ID { get; set; } /// /// 货架/料车编码 /// public string SHELF_ID { get; set; } /// /// 储位代码 /// public string LOCATION_ID { get; set; } /// /// ERP库位代码 /// public string ERP_WH { get; set; } /// /// 是否被单据锁定(Y/N) /// public string IS_LOCKED { get; set; } /// /// 备注 /// public string REMARK { get; set; } /// /// 追溯信息 /// public string TRACE_INFO { get; set; } #endregion #region 虚拟属性 /*例子 [SugarColumn(IsIgnore = true)] public string FieldName { get; set; } */ #endregion #region 外键属性 /*例子 //一对一外键导航 [Navigate(NavigateType.OneToOne, nameof(ClassAId))]//一对一 ClassAId是WMS_ITEM_HIS类里面的外键ID字段 public ClassA ClassA { get; set; } //注意禁止手动赋值,只能是null //一对多外键导航 [Navigate(NavigateType.OneToMany, nameof(ClassA.WMS_ITEM_HISId))]//ClassA表中的WMS_ITEM_HISId public List ClassAList { get; set; }//注意禁止手动赋值,只能是null //多对多外键导航 [Navigate(typeof(MappingClass), nameof(MappingClass.WMS_ITEM_HISId), nameof(MappingClass.ClassAId))]//注意顺序 public List ClassAList { get; set; } //注意禁止手动赋值,只能是null */ #endregion #region 枚举变量 /*例子 public enum FieldNames { [Description("枚举描述0")] Enum0, [Description("枚举描述1")] Enum1, } */ #endregion #region 公共方法 #endregion }//endClass }