using System;
|
using SqlSugar;
|
using System.Linq;
|
using System.ComponentModel;
|
using System.Collections.Generic;
|
|
namespace Tiger.Model
|
{
|
/// <summary>
|
/// 实体：备料库存池
|
/// </summary>
|
[Description("Primary:ID")]
|
[DisplayName("备料库存池")]
|
[Serializable]
|
[SugarTable("WMS_ITEM_POOL")]
|
public class WMS_ITEM_POOL : DbEntityNoGhostWithAuth
|
{
|
#region 构造函数
|
/// <summary>
|
/// 实体：备料库存池
|
/// </summary>
|
public WMS_ITEM_POOL() {}
|
#endregion
|
|
#region 公共属性
|
/// <summary>
|
/// 事务ID
|
/// </summary>
|
[DisplayName("事务ID")]
|
public string TRANS_ID { get; set; }
|
/// <summary>
|
/// 业务单据编码
|
/// </summary>
|
[DisplayName("业务单据编码")]
|
public string TRANS_CODE { get; set; }
|
/// <summary>
|
/// 业务单据号码
|
/// </summary>
|
[DisplayName("业务单据号码")]
|
public string TRANS_NO { get; set; }
|
/// <summary>
|
/// 业务单据行号
|
/// </summary>
|
[DisplayName("业务单据行号")]
|
public string TRANS_LINE { 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>
|
/// 备料策略（位标志枚举）(0None不启用|1FIFO先进先出|2FSFO/尾数优先)
|
/// </summary>
|
[DisplayName("备料策略（位标志枚举）(0None不启用|1FIFO先进先出|2FSFO/尾数优先)")]
|
public int STRATEGY { get; set; }
|
/// <summary>
|
/// 发料方式(0Supply正常发料|1First首套发料)
|
/// </summary>
|
[DisplayName("发料方式(0Supply正常发料|1First首套发料)")]
|
public int DLVY_MODE { get; set; }
|
/// <summary>
|
/// 是否被锁定(Y/N)，锁定则不允许其他事务分配当前物料
|
/// </summary>
|
[DisplayName("是否被锁定(Y/N)，锁定则不允许其他事务分配当前物料")]
|
public string IS_LOCKED { get; set; }
|
/// <summary>
|
/// 物料编码
|
/// </summary>
|
[DisplayName("物料编码")]
|
public string ITEM_CODE { get; set; }
|
/// <summary>
|
/// 物料条码
|
/// </summary>
|
[DisplayName("物料条码")]
|
public string SN { get; set; }
|
/// <summary>
|
/// 物料数量
|
/// </summary>
|
[DisplayName("物料数量")]
|
public double QTY { get; set; }
|
/// <summary>
|
/// 已分配数量
|
/// </summary>
|
[DisplayName("已分配数量")]
|
public double ALLOC_QTY { get; set; }
|
/// <summary>
|
/// 生产日期
|
/// </summary>
|
[DisplayName("生产日期")]
|
public DateTime PROD_DATE { get; set; } = DateTime.MinValue;
|
/// <summary>
|
/// 仓库ID
|
/// </summary>
|
[DisplayName("仓库ID")]
|
public string WH_ID { get; set; }
|
/// <summary>
|
/// 储区ID
|
/// </summary>
|
[DisplayName("储区ID")]
|
public string REGION_ID { get; set; }
|
/// <summary>
|
/// 货架/料车ID
|
/// </summary>
|
[DisplayName("货架/料车ID")]
|
public string SHELF_ID { get; set; }
|
/// <summary>
|
/// 储位ID
|
/// </summary>
|
[DisplayName("储位ID")]
|
public string LOCATION_ID { get; set; }
|
/// <summary>
|
/// 是否首套料(Y/N)
|
/// </summary>
|
[DisplayName("是否首套料(Y/N)")]
|
public string IS_FIRST { get; set; }
|
/// <summary>
|
/// 分配状态(0AllAllocated全部分配|1PartialAllocate部分分配)
|
/// </summary>
|
[DisplayName("分配状态(0AllAllocated全部分配|1PartialAllocate部分分配)")]
|
public int ALLOC_MODE { get; set; }
|
/// <summary>
|
/// 状态(0WaitPick待捡料|1Picking捡料中|2WaitSend待发料|3Sended已发料|4Close已关闭|5Cancel作废)
|
/// </summary>
|
[DisplayName("状态(0WaitPick待捡料|1Picking捡料中|2WaitSend待发料|3Sended已发料|4Close已关闭|5Cancel作废)")]
|
public int STATUS { get; set; }
|
/// <summary>
|
/// 加工段
|
/// </summary>
|
[DisplayName("加工段")]
|
public string SEGMENT { get; set; }
|
/// <summary>
|
/// 目标产线编码
|
/// </summary>
|
[DisplayName("目标产线编码")]
|
public string LINE_CODE { get; set; }
|
/// <summary>
|
/// 备注
|
/// </summary>
|
[DisplayName("备注")]
|
public string REMARK { get; set; }
|
#endregion
|
|
#region 虚拟属性
|
/*例子
|
[SugarColumn(IsIgnore = true)]
|
public string FieldName { get; set; }
|
*/
|
#endregion
|
|
#region 外键属性
|
/*例子
|
//一对一外键导航
|
[Navigate(NavigateType.OneToOne, nameof(ClassAId))]//一对一 ClassAId是WMS_ITEM_POOL类里面的外键ID字段
|
public ClassA ClassA { get; set; } //注意禁止手动赋值，只能是null
|
//一对多外键导航
|
[Navigate(NavigateType.OneToMany, nameof(ClassA.WMS_ITEM_POOLId))]//ClassA表中的WMS_ITEM_POOLId
|
public List<ClassA> ClassAList { get; set; }//注意禁止手动赋值，只能是null
|
//多对多外键导航
|
[Navigate(typeof(MappingClass), nameof(MappingClass.WMS_ITEM_POOLId), nameof(MappingClass.ClassAId))]//注意顺序
|
public List<ClassA> ClassAList { get; set; } //注意禁止手动赋值，只能是null
|
*/
|
#endregion
|
|
#region 枚举变量
|
/*例子
|
public enum FieldNames
|
{
|
[Description("枚举描述0")]
|
Enum0,
|
[Description("枚举描述1")]
|
Enum1,
|
}
|
*/
|
|
/// <summary>
|
/// 枚举：备料策略（位标志枚举）(0None不启用|1FIFO先进先出|2FSFO/尾数优先)
|
/// </summary>
|
public enum STRATEGYs
|
{
|
[Description("不启用")]
|
None = 0,
|
[Description("先进先出")]
|
FIFO = 1,
|
[Description("尾数优先")]
|
FSFO = 2,
|
}
|
|
/// <summary>
|
/// 枚举：发料方式(0Supply正常发料|1First首套发料)
|
/// </summary>
|
public enum DLVY_MODEs
|
{
|
[Description("正常发料")]
|
Supply = 0,
|
[Description("首套发料")]
|
First = 1,
|
}
|
|
/// <summary>
|
/// 枚举：分配状态(0AllAllocated全部分配|1PartialAllocate部分分配)
|
/// </summary>
|
public enum ALLOC_MODEs
|
{
|
[Description("全部分配")]
|
AllAllocated = 0,
|
[Description("部分分配")]
|
PartialAllocate = 1,
|
}
|
|
/// <summary>
|
/// 枚举：状态(0WaitPick待捡料|1Picking捡料中|2WaitSend待发料|3Sended已发料|4Close已关闭|5Cancel作废)
|
/// </summary>
|
public enum STATUSs
|
{
|
[Description("待捡料")]
|
WaitPick = 0,
|
[Description("捡料中")]
|
Picking = 1,
|
[Description("待发料")]
|
WaitSend = 2,
|
[Description("已发料")]
|
Sended = 3,
|
[Description("已关闭")]
|
Close = 4,
|
[Description("作废")]
|
Cancel = 5,
|
}
|
#endregion
|
|
#region 公共方法
|
|
#endregion
|
|
}//endClass
|
}
|
