using HH.WCS.NongFuChaYuan.TaskController;
|
using SqlSugar;
|
using System;
|
using System.Collections.Generic;
|
using System.Linq;
|
using System.Text;
|
using System.Threading.Tasks;
|
using ST = HH.WCS.NongFuChaYuan.OtherService.STAttribute;
|
|
namespace HH.WCS.NongFuChaYuan.WmsService
|
{
|
//---------------------------------------仓库信息---------------------------------------
|
public class BaseModel
|
{
|
[SugarColumn(IsPrimaryKey = true)]
|
public string S_ID { get; set; } = Guid.NewGuid().ToString("D");
|
public string S_CREATOR_ID { get; set; } = "sa";
|
public string S_CREATOR_NAME { get; set; } = "超级用户";
|
public DateTime T_CREATE { get; set; } = DateTime.Now;
|
public DateTime T_MODIFY { get; set; } = DateTime.Now;
|
}
|
|
/// <summary>
|
/// 货位表
|
/// 测试环境1:146-TN_0036
|
/// 测试环境2:198-TN_0038
|
/// 农夫均州:TN_0038
|
/// </summary>
|
[ST("货位表")]
|
//[SugarTable("dbo.TN_0036")]
|
public class Location : BaseModel
|
{
|
public string S_LOC_CODE { get; set; }
|
public string S_AREA_CODE { get; set; }
|
/// <summary>
|
/// 仓库名-不可用
|
/// </summary>
|
public string S_WH_CODE { get; set; }
|
public int N_CAPACITY { get; set; }
|
public string S_AGV_SITE { get; set; }
|
/// <summary>
|
/// 需要注意
|
/// </summary>
|
//[SugarColumn(IsIgnore = true)]
|
public int N_AGV_CODE { get; set; }
|
public int N_CURRENT_NUM { get; set; }
|
public DateTime T_FULL_TIME { get; set; }
|
public int N_ROADWAY { get; set; }
|
public string N_ROW { get; set; }
|
public int N_OROW { get; set; }
|
public int N_COL { get; set; }
|
public int N_LAYER { get; set; }
|
/// <summary>
|
/// 无/入库锁/出库锁/其它锁
|
/// </summary>
|
public string S_LOCK_STATE { get; set; }
|
/// <summary>
|
/// 淳安特殊字段--用于标记货位上放置的托盘类型 大板-小板
|
/// </summary>
|
public string S_NOTE { get; set; }
|
|
|
[SugarColumn(IsIgnore = true)]
|
[Navigate(NavigateType.OneToOne, nameof(S_LOC_CODE))]
|
public LocCntrRel LocCntrRel { get; set; }
|
}
|
/// <summary>
|
/// 货位容器表
|
/// 测试环境1:146-TN_0038
|
/// 测试环境2:198-TN_0130
|
/// 农夫均州:TN_0039
|
/// </summary>
|
//[SugarTable("dbo.TN_0038")]
|
[ST("货位容器表")]
|
public class LocCntrRel : BaseModel
|
{
|
/// <summary>
|
/// 注意，mapper方式不需要
|
/// </summary>
|
[SugarColumn(IsPrimaryKey = true)]
|
public string S_LOC_CODE { get; set; }
|
public string S_CNTR_CODE { get; set; }
|
[SugarColumn(IsIgnore = true)]
|
[Navigate(NavigateType.OneToOne, nameof(S_CNTR_CODE))]
|
public CntrItemRel CntrItemRel { get; set; }
|
[SugarColumn(IsIgnore = true)]
|
[Navigate(NavigateType.OneToOne, nameof(S_CNTR_CODE))]
|
public Container Container { get; set; }
|
/// <summary>
|
/// 托盘来源
|
/// </summary>
|
public string S_SRC { get; set; }
|
public string S_TRAY_TYPE { get; set; }
|
}
|
/// <summary>
|
/// 容器物料表
|
/// 测试环境1:146-TN_0030
|
/// 测试环境2:198-TN_0116
|
/// 农夫均州:TN_0028
|
/// </summary>
|
//[SugarTable("dbo.TN_0030")]
|
[ST("容器物料表")]
|
public class CntrItemRel : BaseModel
|
{
|
[SugarColumn(IsPrimaryKey = true)]
|
public string S_CNTR_CODE { get; set; }
|
public string S_ITEM_CODE { get; set; }
|
public string S_BATCH_NO { get; set; }
|
public string F_QTY { get; set; }
|
/// <summary>
|
/// 物料规格/层高
|
/// </summary>
|
public string S_ITEM_MODEL { get; set; }
|
public string S_ITEM_STATE { get; set; }
|
public string D_INSTOCK_DATE { get; set; }
|
/// <summary>
|
/// 分配量
|
/// </summary>
|
public double F_ALLOCATION { get; set; }
|
public string S_ORDER_NO { get; set; }
|
public string S_SRC { get; set; }
|
|
}
|
|
|
|
/// <summary>
|
/// 物料表
|
/// 测试环境1:146-TN_0030
|
/// 测试环境2:198-TN_0116
|
/// 农夫均州:TN_0028
|
/// </summary>
|
//[SugarTable("dbo.TN_0030")]
|
[ST("物料表")]
|
public class ItemRel : BaseModel
|
{
|
/// <summary>
|
/// 物料编码
|
/// </summary>
|
public string S_ITEM_CODE { get; set; }
|
/// <summary>
|
/// 物料名称
|
/// </summary>
|
public string S_ITEM_NAME { get; set; }
|
/// <summary>
|
/// 物料规格/层高
|
/// </summary>
|
public string S_ITEM_MODEL { get; set; }
|
/// <summary>
|
/// 下发TS高度值
|
/// </summary>
|
public string S_ITEM_LAYER { get; set; }
|
/// <summary>
|
/// 栈板类型
|
/// </summary>
|
public string S_TRAY_TYPE { get; set; }
|
|
}
|
/// <summary>
|
/// 排锁表
|
/// 测试环境1:146-TN_0031
|
/// 测试环境2:198-TN_0117
|
/// 农夫均州:TN_0029
|
/// </summary>
|
//[SugarTable("dbo.TN_0031")]
|
[ST("排锁表")]
|
public class RowLock : BaseModel
|
{
|
/// <summary>
|
/// 库区编码
|
/// </summary>
|
public string S_AREA_CODE { get; set; }
|
/// <summary>
|
/// 排号
|
/// </summary>
|
public string N_ROW { get; set; }
|
/// <summary>
|
/// 锁定状态--默认：无
|
/// </summary>
|
public string S_LOCK_STATE { get; set; }
|
/// <summary>
|
/// 工作模式
|
/// </summary>
|
public string S_WORK_MODE { get; set; }
|
/// <summary>
|
/// 锁来源
|
/// </summary>
|
public string S_LOCK_SRC { get; set; }
|
/// <summary>
|
/// 锁定时间
|
/// </summary>
|
public DateTime T_LOCK_TIME { get; set; }
|
/// <summary>
|
/// 解锁时间
|
/// </summary>
|
public DateTime T_UNLOCK_TIME { get; set; }
|
}
|
|
/// <summary>
|
/// 容器表
|
/// 测试环境1:146-TN_0028
|
/// 测试环境2:198-TN_0114
|
/// 农夫均州:TN_0026
|
/// </summary>
|
//[SugarTable("dbo.TN_0028")]
|
[ST("容器表")]
|
public class Container : BaseModel
|
{
|
/// <summary>
|
/// 容器编码
|
/// </summary>
|
public string S_CNTR_CODE { get; set; }
|
/// <summary>
|
/// 铁托盘、塑料托盘
|
/// </summary>
|
public string S_TYPE { get; set; }
|
/// <summary>
|
/// 规格
|
/// </summary>
|
public string S_SPEC { get; set; }
|
/// <summary>
|
/// 容器用途
|
/// </summary>
|
public string N_PURPOSE { get; set; }
|
/// <summary>
|
/// 容器来源
|
/// </summary>
|
public string S_SRC { get; set; }
|
/// <summary>
|
/// 容器目的地
|
/// </summary>
|
public string S_DEST { get; set; }
|
/// <summary>
|
/// 容器状态(空-已清洁-无-转运-待生产)
|
/// </summary>
|
public string S_CNTR_STATE { get; set; }
|
}
|
|
/// <summary>
|
/// 任务表
|
/// 测试环境1:146-TN_0026
|
/// 测试环境2:198-TN_0098
|
/// </summary>
|
//[SugarTable("dbo.TN_0026")]
|
[ST("任务表")]
|
public class WMSTask : BaseModel
|
{
|
public string S_TASK_NO { get; set; }
|
public string S_START_LAREA { get; set; }
|
public string S_END_LAREA { get; set; }
|
public string S_START_LOC { get; set; }
|
public string S_END_LOC { get; set; }
|
public string S_TYPE { get; set; }
|
/// <summary>
|
/// 淳安用于标记-物料层数 6，7，8
|
/// </summary>
|
public string S_NOTE { get; set; }
|
/// <summary>
|
/// 工单号-移库任务取货完成，需要减去工单 移库数量：因淳安无第三方下发任务，因此 来源号 存放 工单号
|
/// </summary>
|
public string S_SRC_SYS { get; set; }
|
public string S_SRC_NO { get; set; }
|
/// <summary>
|
/// agv/人工/输送线
|
/// </summary>
|
public string S_WORK_MODE { get; set; }
|
/// <summary>
|
/// ?-设置允许空值
|
/// </summary>
|
public DateTime? T_START_TIME { get; set; }
|
public DateTime? T_END_TIME { get; set; }
|
/// <summary>
|
/// 任务状态
|
/// </summary>
|
public string S_B_STATE { get; set; }
|
public int N_PRIORITY { get; set; }
|
/// <summary>
|
/// 搬运的托盘号，多个用英文逗号分开
|
/// </summary>
|
public string S_CNTRS { get; set; }
|
/// <summary>
|
/// 起点层
|
/// </summary>
|
public int N_START_LAYER { get; set; }
|
/// <summary>
|
/// 终点层
|
/// </summary>
|
public int N_END_LAYER { get; set; }
|
/// <summary>
|
/// 搬运的托盘数量
|
/// </summary>
|
public int N_CNTR_COUNT { get; set; }
|
/// <summary>
|
/// 设备号
|
/// </summary>
|
public string S_EQ_NO { get; set; }
|
/// <summary>
|
/// 物料编码
|
/// </summary>
|
public string S_ITEM_CODE { get; set; }
|
/// <summary>
|
/// 批次号
|
/// </summary>
|
public string S_BATCH_NO { get; set; }
|
public string S_CNTR_TYPE { get; set; }
|
}
|
|
/// <summary>
|
/// 任务动作表
|
/// 测试环境1:146-TN_0040
|
/// 测试环境2:198-TN_0146
|
/// </summary>
|
//[SugarTable("dbo.TN_0040")]
|
[ST("任务动作表")]
|
public class WmsTaskAction : BaseModel
|
{
|
public string S_TASK_NO { get; set; }
|
public string S_ACTION_CODE { get; set; }
|
/// <summary>
|
/// 设备号
|
/// </summary>
|
public string S_EQ_NO { get; set; }
|
/// <summary>
|
/// 设备类型
|
/// </summary>
|
public string S_EQ_TYPE { get; set; }
|
/// <summary>
|
/// 其它数据
|
/// </summary>
|
public string S_DATA { get; set; }
|
}
|
|
/// <summary>
|
/// 扩展货位表
|
/// 测试环境1:146-TN_0041
|
/// 测试环境2:198-TN_0132
|
/// </summary>
|
//[SugarTable("dbo.TN_0041")]
|
[ST("扩展货位表")]
|
public class LocationExt : BaseModel
|
{
|
/// <summary>
|
/// 货位
|
/// </summary>
|
public string S_LOC_CODE { get; set; }
|
/// <summary>
|
/// agv站点
|
/// </summary>
|
public string S_AGV_SITE { get; set; }
|
/// <summary>
|
/// 标识
|
/// </summary>
|
public string S_PICKUP_POINT { get; set; }
|
}
|
|
/// <summary>
|
/// 自由线段站点表
|
/// </summary>
|
//[SugarTable("dbo.TN_0041")]
|
[ST("自由线段站点表")]
|
public class flexibilloction : BaseModel
|
{
|
/// <summary>
|
/// 库区编码
|
/// </summary>
|
public string S_AREA_CODE { get; set; }
|
/// <summary>
|
/// 排号
|
/// </summary>
|
public string N_ROW { get; set; }
|
/// <summary>
|
/// 线段起点列
|
/// </summary>
|
public int S_START_COL { get; set; }
|
/// <summary>
|
/// 线段终点列
|
/// </summary>
|
public int S_END_COL { get; set; }
|
/// <summary>
|
/// 纸箱起点列
|
/// </summary>
|
//public int S_ZXSTART_COL { get; set; }
|
///// <summary>
|
///// 纸箱终点列
|
///// </summary>
|
//public int S_ZXEND_COL { get; set; }
|
/// <summary>
|
/// 一层站点
|
/// </summary>
|
public string S_First_Bit { get; set; }
|
/// <summary>
|
/// 二层站点
|
/// </summary>
|
public string S_Second_Bit { get; set; }
|
}
|
|
|
[ST("物料优先下线库区表")]
|
public class ItemArea : BaseModel
|
{
|
/// <summary>
|
/// 物料编码
|
/// </summary>
|
public string S_ITEM_CODE { get; set; }
|
/// <summary>
|
/// 物料名称
|
/// </summary>
|
public string S_ITEM_NAME { get; set; }
|
/// <summary>
|
/// 优先级
|
/// </summary>
|
public int S_PRIORITY { get; set; }
|
/// <summary>
|
/// 库区编码
|
/// </summary>
|
public string S_AREA_CODE { get; set; }
|
/// <summary>
|
/// 栈板类型
|
/// </summary>
|
public string S_TRAY_TYPE { get; set; }
|
}
|
|
/// <summary>
|
/// 库区表
|
/// 测试环境1:146-dbo.TN_0034
|
/// </summary>
|
//[SugarTable("dbo.TN_0034")]
|
[ST("库区表")]
|
public class AreaNoTable : BaseModel
|
{
|
/// <summary>
|
/// 仓库编码
|
/// </summary>
|
public string S_WH_CODE { get; set; }
|
/// <summary>
|
/// 库区编码
|
/// </summary>
|
public string S_AREA_CODE { get; set; }
|
public string S_NOTE { get; set; }
|
public int N_FLOOR { get; set; }
|
public string S_STRUCTURE { get; set; }
|
public string S_EXT_DATA { get; set; }
|
public string S_LOC_TYPE { get; set; }
|
public string S_AREA_NAME { get; set; }
|
}
|
}
|
