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