using System;
|
using SqlSugar;
|
using System.Linq;
|
using System.ComponentModel;
|
using System.Collections.Generic;
|
using Tiger.Model.Minsun;
|
using Tiger.Model.Extensions;
|
using Microsoft.SqlServer.Server;
|
|
namespace Tiger.Model
|
{
|
/// <summary>
|
/// 实体：库存信息
|
/// </summary>
|
[Description("Primary:ID")]
|
[Serializable]
|
[SugarTable("WMS_ITEM")]
|
public class WMS_ITEM : DbEntityWithAuth
|
{
|
#region 构造函数
|
|
/// <summary>
|
/// 实体：库存信息
|
/// </summary>
|
public WMS_ITEM()
|
{ }
|
|
#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待检验|21Rejected需退货|30WaitIn待入库|40InStore在库|50OffShelf已下架|60Sended已发料|65Received被接收|70Loaded已上料|80UseUp已耗尽|90Returned已退料|100Shipped已出货)
|
/// </summary>
|
public int STATUS { get; set; }
|
|
/// <summary>
|
/// 数量
|
/// </summary>
|
public double 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>
|
/// 机型
|
/// </summary>
|
public string ITEM_MODEL { get; set; }
|
|
/// <summary>
|
/// 是否被单据锁定(Y/N)
|
/// </summary>
|
public string IS_LOCKED { get; set; } = "N";
|
|
/// <summary>
|
/// 备注
|
/// </summary>
|
public string REMARK { get; set; }
|
|
/// <summary>
|
/// 是否允许超期
|
/// </summary>
|
public string IsAllowOverdue { get; set; }
|
|
/// <summary>
|
/// 延期时间
|
/// </summary>
|
//public double PostponeDays { get; set; }
|
|
#endregion 公共属性
|
|
#region 虚拟属性
|
|
/*例子
|
[SugarColumn(IsIgnore = true)]
|
public string FieldName { get; set; }
|
*/
|
|
#endregion 虚拟属性
|
|
#region 外键属性
|
|
/*例子
|
//一对一外键导航
|
[Navigate(NavigateType.OneToOne, nameof(ClassAId))]//一对一 ClassAId是WMS_ITEM类里面的外键ID字段
|
public ClassA ClassA { get; set; } //注意禁止手动赋值，只能是null
|
//一对多外键导航
|
[Navigate(NavigateType.OneToMany, nameof(ClassA.WMS_ITEMId))]//ClassA表中的WMS_ITEMId
|
public List<ClassA> ClassAList { get; set; }//注意禁止手动赋值，只能是null
|
//多对多外键导航
|
[Navigate(typeof(MappingClass), nameof(MappingClass.WMS_ITEMId), nameof(MappingClass.ClassAId))]//注意顺序
|
public List<ClassA> ClassAList { get; set; } //注意禁止手动赋值，只能是null
|
*/
|
|
#endregion 外键属性
|
|
#region 枚举变量
|
|
/// <summary>
|
/// 储存状态(0NotExists不存在|10Incoming送货中|20WaitTest待检验|21Rejected需退货|30WaitIn待入库|40InStore在库|50OffShelf已下架|60Sended已发料|65Received被接收|70Loaded已上料|80UseUp已耗尽|90Returned已退料|100Shipped已出货)
|
/// </summary>
|
public enum STATUSs
|
{
|
[Description("不存在")]
|
NotExists = 0,
|
|
[Description("送货中")]
|
Incoming = 10,
|
|
[Description("已清点")]
|
Counted = 15,
|
|
[Description("待检验")]
|
WaitTest = 20,
|
|
[Description("需退货")]
|
Rejected = 22,
|
|
[Description("待入库")]
|
WaitIn = 30,
|
|
[Description("在库中")]
|
InStore = 40,
|
|
[Description("已下架")]
|
OffShelf = 50,
|
|
[Description("已发料")]
|
Sended = 60,
|
|
[Description("被接收")]
|
Received = 65,
|
|
[Description("已上料")]
|
Loaded = 70,
|
|
[Description("已耗尽")]
|
UseUp = 80,
|
|
[Description("已退料")]
|
Returned = 90,
|
|
[Description("已出货")]
|
Shipped = 100,
|
|
[Description("已重工")]
|
Rework = 110,
|
}
|
|
#endregion 枚举变量
|
}//endClass
|
|
/// <summary>
|
/// 上架执行信息
|
/// </summary>
|
public class PutOnInfo
|
{
|
public WMS_WAREHOUSE Warehouse { get; set; }
|
public WMS_REGION Region { get; set; }
|
public WMS_SHELF Shelf { get; set; }
|
public WMS_LOCATION Location { get; set; }
|
public List<WMS_ITEM_PKG> Packages { get; set; } = new List<WMS_ITEM_PKG>();
|
public List<WMS_ITEM> Items { get; set; } = new List<WMS_ITEM>();
|
public List<WMS_ITEM_HIS> History { get; set; } = new List<WMS_ITEM_HIS>();
|
public List<WMS_ITEM_EXT> ItemsExt { get; set; } = new List<WMS_ITEM_EXT>();
|
}
|
|
/// <summary>
|
/// 下架执行信息
|
/// </summary>
|
public class TakeDownInfo
|
{
|
public List<WMS_ITEM_PKG> Packages { get; set; } = new List<WMS_ITEM_PKG>();
|
public List<WMS_ITEM> Items { get; set; } = new List<WMS_ITEM>();
|
public List<WMS_ITEM_HIS> History { get; set; } = new List<WMS_ITEM_HIS>();
|
}
|
|
/// <summary>
|
/// 下架推荐策略实体
|
/// </summary>
|
public class SuggestStrategy
|
{
|
public bool isFIFO { get; set; } = true;
|
public WMS_WAREHOUSE Warehouse { get; set; }
|
public WMS_REGION Region { get; set; }
|
public WMS_SHELF Shelf { get; set; }
|
public WMS_LOCATION Location { get; set; }
|
public List<WMS_ITEM_PKG> Packages { get; set; } = new List<WMS_ITEM_PKG>();
|
public List<WMS_ITEM> Items { get; set; } = new List<WMS_ITEM>();
|
public List<WMS_ITEM_HIS> History { get; set; } = new List<WMS_ITEM_HIS>();
|
}
|
|
/// <summary>
|
/// 下架推荐策略实体
|
/// </summary>
|
public class SuggestItem
|
{
|
public WMS_ITEM Item { get; set; }
|
public WMS_ITEM_POOL poolItem { get; set; }
|
public WMS_WAREHOUSE Warehouse { get; set; }
|
public WMS_REGION Region { get; set; }
|
public WMS_SHELF Shelf { get; set; }
|
public WMS_LOCATION Location { get; set; }
|
}
|
|
public class QueryItemInputDtl : BasePageInput
|
{
|
public bool? IsK { get; set; }
|
}
|
|
public class QueryItemInput : BaseInput
|
{
|
public bool? IsK { get; set; }
|
}
|
|
public class QueryItemView
|
{
|
public string ItemCode { get; set; }
|
public string ItemName { get; set; }
|
public string SumInfo { get; set; }
|
}
|
}
|
