using System;
|
using SqlSugar;
|
using System.Linq;
|
using System.ComponentModel;
|
using System.Collections.Generic;
|
|
namespace Tiger.Model
|
{
|
/// <summary>
|
/// 实体：盘点物品明细
|
/// </summary>
|
[Description("Primary:ID")]
|
[Serializable]
|
[SugarTable("WMS_COUNT_MDTL")]
|
public class WMS_COUNT_MDTL : DbEntityWithAuth
|
{
|
#region 构造函数
|
/// <summary>
|
/// 实体：盘点物品明细
|
/// </summary>
|
public WMS_COUNT_MDTL() {}
|
#endregion
|
|
#region 公共属性
|
/// <summary>
|
/// 盘点单号
|
/// </summary>
|
public string COUNT_NO { get; set; }
|
/// <summary>
|
/// 条码
|
/// </summary>
|
public string SN { get; set; }
|
/// <summary>
|
/// 条码类型(规则编码)
|
/// </summary>
|
public string SN_TYPE { get; set; }
|
/// <summary>
|
/// 盘点状态(0WaitCount待盘点|1Counted已盘点)
|
/// </summary>
|
public int STATUS { get; set; }
|
/// <summary>
|
/// 盘点结果(0NotFound未核实|1Founded已核实|2NewFound新找到)
|
/// </summary>
|
public int RESULT { get; set; }
|
/// <summary>
|
/// 物料编码
|
/// </summary>
|
public string ITEM_CODE { get; set; }
|
/// <summary>
|
/// 单位
|
/// </summary>
|
public string UNIT { get; set; }
|
/// <summary>
|
/// WMS数量
|
/// </summary>
|
public double QTY { get; set; }
|
/// <summary>
|
/// 实际数量
|
/// </summary>
|
public double ACT_QTY { 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 SUPP_CODE { get; set; }
|
/// <summary>
|
/// 供应商批次号
|
/// </summary>
|
public string SUPP_LOTNO { get; set; }
|
/// <summary>
|
/// 仓库ID
|
/// </summary>
|
public string WH_ID { get; set; }
|
/// <summary>
|
/// 储区ID
|
/// </summary>
|
public string REGION_ID { get; set; }
|
/// <summary>
|
/// 货架/料车ID
|
/// </summary>
|
public string SHELF_ID { get; set; }
|
/// <summary>
|
/// 储位ID
|
/// </summary>
|
public string LOCATION_ID { get; set; }
|
/// <summary>
|
/// ERP库位代码
|
/// </summary>
|
public string ERP_WH { get; set; }
|
/// <summary>
|
/// 处理方式(0NoAdjust无需处理|1InWarehouse入库上架|2ExWarehouse丢失下架)
|
/// </summary>
|
public int ACTION { get; set; }
|
/// <summary>
|
/// 审核人
|
/// </summary>
|
public string REVIEWER { get; set; }
|
/// <summary>
|
/// 审核日期
|
/// </summary>
|
public DateTime REVIEW_DATE { get; set; } = DateTime.MinValue;
|
/// <summary>
|
/// 备注
|
/// </summary>
|
public string REMARK { get; set; }
|
#endregion
|
|
#region 虚拟属性
|
/*例子
|
[SugarColumn(IsIgnore = true)]
|
public string FieldName { get; set; }
|
*/
|
#endregion
|
|
#region 外键属性
|
/*例子
|
//一对一外键导航
|
[Navigate(NavigateType.OneToOne, nameof(ClassAId))]//一对一 ClassAId是WMS_COUNT_MDTL类里面的外键ID字段
|
public ClassA ClassA { get; set; } //注意禁止手动赋值，只能是null
|
//一对多外键导航
|
[Navigate(NavigateType.OneToMany, nameof(ClassA.WMS_COUNT_MDTLId))]//ClassA表中的WMS_COUNT_MDTLId
|
public List<ClassA> ClassAList { get; set; }//注意禁止手动赋值，只能是null
|
//多对多外键导航
|
[Navigate(typeof(MappingClass), nameof(MappingClass.WMS_COUNT_MDTLId), nameof(MappingClass.ClassAId))]//注意顺序
|
public List<ClassA> ClassAList { get; set; } //注意禁止手动赋值，只能是null
|
*/
|
[Navigate(NavigateType.OneToOne, nameof(WH_ID), nameof(ID), "GHOST_ROW = 0")]//一对一 ClassAId是WMS_ITEM_PKG类里面的外键ID字段
|
public WMS_WAREHOUSE Warehouse { get; set; } //注意禁止手动赋值，只能是null
|
[Navigate(NavigateType.OneToOne, nameof(REGION_ID), nameof(ID), "GHOST_ROW = 0")]//一对一 ClassAId是WMS_ITEM_PKG类里面的外键ID字段
|
public WMS_REGION Region { get; set; } //注意禁止手动赋值，只能是null
|
[Navigate(NavigateType.OneToOne, nameof(SHELF_ID), nameof(ID), "GHOST_ROW = 0")]//一对一 ClassAId是WMS_ITEM_PKG类里面的外键ID字段
|
public WMS_SHELF Shelf { get; set; } //注意禁止手动赋值，只能是null
|
[Navigate(NavigateType.OneToOne, nameof(LOCATION_ID), nameof(ID), "GHOST_ROW = 0")]//一对一 ClassAId是WMS_ITEM_PKG类里面的外键ID字段
|
public WMS_LOCATION Location { get; set; } //注意禁止手动赋值，只能是null
|
#endregion
|
|
#region 枚举变量
|
/*例子
|
public enum FieldNames
|
{
|
[Description("枚举描述0")]
|
Enum0,
|
[Description("枚举描述1")]
|
Enum1,
|
}
|
*/
|
/// <summary>
|
/// 盘点状态(0WaitCount待盘点|1Counted已盘点)a
|
/// </summary>
|
public enum STATUSs
|
{
|
[Description("待盘点")]
|
WaitCount,
|
[Description("已盘点")]
|
Counted,
|
}
|
|
/// <summary>
|
/// 盘点结果(0NotFound未核实|1Founded已核实|2NewFound新找到)
|
/// </summary>
|
public enum RESULTs
|
{
|
[Description("未核实")]
|
NotFound,
|
[Description("已核实")]
|
Founded,
|
[Description("新找到")]
|
NewFound,
|
}
|
/// <summary>
|
/// 处理方式(0NoAdjust无需处理|1InWarehouse入库上架|2ExWarehouse丢失下架)
|
/// </summary>
|
public enum ACTIONs
|
{
|
[Description("无需处理")]
|
NoAdjust,
|
[Description("入库上架")]
|
InWarehouse,
|
[Description("丢失下架")]
|
ExWarehouse,
|
}
|
#endregion
|
|
#region 公共方法
|
|
#endregion
|
|
}//endClass
|
}
|
