using HH.WCS.Hexafluo.util;
|
using SqlSugar;
|
using System;
|
|
namespace HH.WCS.Hexafluo.wms
|
{
|
|
//---------------------------------------仓库信息---------------------------------------
|
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;
|
/// <summary>
|
/// 修改时间
|
/// </summary>
|
public DateTime T_MODIFY { get; set; } = DateTime.Now;
|
|
|
}
|
|
[ST("货位表")]
|
public class Location : BaseModel
|
{
|
|
public string S_LOC_CODE { get; set; }
|
|
public string S_AREA_CODE { get; set; }
|
|
public string S_WH_CODE { get; set; }
|
/// <summary>
|
/// 容量
|
/// </summary>
|
public int N_CAPACITY { get; set; }
|
|
|
public string S_AGV_SITE { get; set; }
|
/// <summary>
|
/// 需要注意 agv站点1
|
/// </summary>
|
//[SugarColumn(IsIgnore = true)]
|
public int N_AGV_CODE { get; set; }
|
|
|
/// <summary>
|
/// agv站点2
|
/// </summary>
|
public int N_AGV_CODE_T { get; set; }
|
|
/// <summary>
|
/// 出库时间
|
/// </summary>
|
public DateTime? T_EMPTY_TIME { get; set; }
|
|
/// <summary>
|
/// 当前容量
|
/// </summary>
|
public int N_CURRENT_NUM { get; set; }
|
|
/// <summary>
|
/// 入库时间
|
/// </summary>
|
public DateTime T_FULL_TIME { get; set; }
|
public int N_ROADWAY { get; set; }
|
public int N_ROW { get; set; }
|
public int N_COL { get; set; }
|
public int N_LAYER { get; set; }
|
public int N_SIDE { get; set; }//侧
|
/// <summary>
|
/// 货位类型
|
/// </summary>
|
public string S_LOC_TYPE { get; set; }
|
/// <summary>
|
/// 无/入库锁/出库锁/其它锁
|
/// </summary>
|
public string S_LOCK_STATE { get; set; }
|
/// <summary>
|
/// 是否启用 启用Y 禁用 N
|
/// </summary>
|
public string C_ENABLE { get; set; }
|
|
//public string S_DEEP { get; set; }
|
|
/// <summary>
|
/// 托盘类型
|
/// </summary>
|
public string S_TRAY_TYPE { get; set; }
|
|
/// <summary>
|
/// 生产时间
|
/// </summary>
|
public string productionDate { get; set; }
|
|
/// <summary>
|
/// 生效时间
|
/// </summary>
|
public string takeEffectTime { get; set; }
|
|
/// <summary>
|
/// 失效时间
|
/// </summary>
|
public string expireTime { get; set; }
|
|
/// <summary>
|
/// 机台托盘类型
|
/// </summary>
|
public string S_MACH_TRAY_TYPE { 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; }
|
|
|
}
|
|
[ST("物料肉表")]
|
public class Item : BaseModel
|
{
|
/// <summary>
|
/// 物料类型(皇冠对应着库区)
|
/// </summary>
|
public string S_ITEM_TYPE { get; set; }
|
|
/// <summary>
|
/// 物料编码
|
/// </summary>
|
public string S_ITEM_CODE { get; set; }
|
|
/// <summary>
|
/// 物料名称
|
/// </summary>
|
public string S_ITEM_NAME { get; set; }
|
|
/// <summary>
|
/// 备注
|
/// </summary>
|
public string S_NOTE { get; set; }
|
|
/// <summary>
|
/// 规格
|
/// </summary>
|
public string S_SPEC { get; set; }
|
|
/// <summary>
|
/// 重量
|
/// </summary>
|
public float F_WEIGHT { get; set; }
|
|
public string S_UOM { get; set; }
|
|
public string S_DRAW_NO { get; set; }
|
public int N_SHELF_LIFE { get; set; }
|
public string C_ENABLE_OWNER { get; set; }
|
public int N_LENGTH { get; set; }
|
public int N_WIDTH { get; set; }
|
public int N_HEIGHT { get; set; }
|
}
|
|
[ST("托盘货位表")]
|
public class LocCntrRel : BaseModel
|
{
|
/// <summary>
|
/// 注意，mapper方式不需要
|
/// </summary>
|
[SugarColumn(IsPrimaryKey = true)]
|
public string S_LOC_CODE { get; set; }
|
/// <summary>
|
/// 容器类型
|
/// </summary>
|
public string S_TYPE { 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_LOC_CODE))]
|
public Container Container { get; set; }
|
}
|
|
|
[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_ITEM_NAME { get; set; }
|
public string S_BATCH_NO { get; set; }
|
public decimal F_QTY { get; set; }
|
public string S_ITEM_STATE { get; set; }
|
|
/// <summary>
|
/// 周转卡号
|
/// </summary>
|
public string TurnCardNum { get; set; }
|
/// <summary>
|
/// 物料特征 zc中 用来存工艺编号
|
/// </summary>
|
public string itemFeature { get; set; }
|
/// <summary>
|
/// 规格型号
|
/// </summary>
|
public string itemModel { get; set; }
|
|
/// <summary>
|
/// 失效时间
|
/// </summary>
|
public DateTime expireTime { get; set; }
|
|
/// <summary>
|
/// 生效时间
|
/// </summary>
|
public DateTime takeEffectTime { get; set; }
|
|
/// <summary>
|
/// 生产时间
|
/// </summary>
|
public DateTime productionDate { get; set; }
|
|
/// <summary>
|
/// 制品类型
|
/// </summary>
|
public string Level { get; set; }
|
|
public decimal F_ALLOCATION { get; set; }
|
/// <summary>
|
/// 规格
|
/// </summary>
|
public string S_ITEM_SPEC { get; set; }
|
|
/// <summary>
|
/// 总重量
|
/// </summary>
|
public decimal F_SUM_QTY { get; set; }
|
|
/// <summary>
|
/// 工装重量
|
/// </summary>
|
public decimal F_AVG_QTY { get; set; }
|
|
/// <summary>
|
/// 入库时间
|
/// </summary>
|
public DateTime T_INSTOCK { get; set; }
|
|
/// <summary>
|
/// 供应商编码
|
/// </summary>
|
public string S_SUPPLIER_N0 { get; set; }
|
/// <summary>
|
/// 供应商名称
|
/// </summary>
|
public string S_SUPPLIER { get; set; }
|
|
/// <summary>
|
/// 订单号
|
/// </summary>
|
public string S_Order_Number { get; set; }
|
|
/// <summary>
|
/// 班次
|
/// </summary>
|
public string S_Classes { get; set; }
|
|
/// <summary>
|
/// 机台号
|
/// </summary>
|
public int S_Drilling_Crew { get; set; }
|
|
/// <summary>
|
/// 车号
|
/// </summary>
|
public int S_Car_Num { get; set; }
|
|
/// <summary>
|
/// 第几个料
|
/// </summary>
|
public string S_Srequency { get; set; }
|
|
/// <summary>
|
/// 时间
|
/// </summary>
|
public string S_TIME { get; set; }
|
public string applyProdSpecList { get; set; }
|
// public string S_IsTask_Main { get; set; }
|
}
|
//均州现场
|
//[SugarTable("TN_0029")]
|
//198服务器
|
[SugarTable("TN_0117")]
|
public class RowLock : BaseModel
|
{
|
public string S_AREA_CODE { get; set; }
|
public int N_ROW { get; set; }
|
public string S_LOCK_STATE { get; set; }
|
public string S_WORK_MODE { get; set; }
|
public string S_LOCK_SRC { get; set; }
|
public DateTime T_LOCK_TIME { get; set; }
|
public DateTime T_UNLOCK_TIME { get; set; }
|
}
|
|
//均州现场
|
//[SugarTable("TN_0026")]
|
//198服务器
|
[SugarTable("TN_0114")]
|
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; }
|
}
|
|
[ST("任务表")]
|
public class WMSTask : BaseModel
|
{
|
/// <summary>
|
/// 任务号
|
/// </summary>
|
[SugarColumn(IsPrimaryKey = true)]
|
public string S_TASK_NO { get; set; }
|
/// <summary>
|
/// 起始库区编号
|
/// </summary>
|
public string S_START_LAREA { get; set; }
|
/// <summary>
|
/// 目的库区编号
|
/// </summary>
|
public string S_END_LAREA { get; set; }
|
/// <summary>
|
/// 起点
|
/// </summary>
|
public string S_START_LOC { get; set; }
|
/// <summary>
|
/// 终点
|
/// </summary>
|
public string S_END_LOC { get; set; }
|
/// <summary>
|
/// 业务类型
|
/// </summary>
|
public string S_TYPE { get; set; }
|
/// <summary>
|
/// 备注
|
/// </summary>
|
public string S_NOTE { get; set; }
|
/// <summary>
|
/// 来源业务
|
/// </summary>
|
public string S_SRC_SYS { get; set; }
|
|
/// <summary>
|
/// 订单号
|
/// </summary>
|
public string S_SRC_NO { get; set; }
|
/// <summary>
|
/// agv/人工/输送线
|
/// </summary>
|
public string S_WORK_MODE { get; set; }
|
public DateTime? T_START_TIME { get; set; } = null;
|
public DateTime? T_END_TIME { get; set; } = null;
|
|
/// <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_READ_LOCK { get; set; }
|
|
/// <summary>
|
/// 流程编码
|
/// </summary>
|
public string S_FlowNo { get; set; }
|
|
/// <summary>
|
/// 是否分发子任务
|
/// </summary>
|
public string S_Subtask { get; set; }
|
|
/// <summary>
|
/// 接驳位
|
/// </summary>
|
public string S_Jb_Bit { get; set; }
|
|
/// <summary>
|
/// 准备点
|
/// </summary>
|
public string S_Zb_Bit { get; set; }
|
|
/// <summary>
|
/// 更换前的终点货位
|
/// </summary>
|
public string S_END_LOC_AGO { get; set; }
|
|
/// <summary>
|
/// 工装类型
|
/// </summary>
|
public string S_TOOLS_TPYE { get; set; }
|
|
/// <summary>
|
/// RFID异常标记
|
/// </summary>
|
public string mark { get; set; }
|
|
/// <summary>
|
/// 设备号--车号
|
/// </summary>
|
public string S_EQ_NO { get; set; }
|
|
/// <summary>
|
/// 入库类型 有托入库Y --无托入库N
|
/// </summary>
|
public string S_InTaskType { get; set; }
|
/// <summary>
|
/// 上游任务号
|
/// </summary>
|
public string S_UpstreamNo { get; set; }
|
public string S_Main_task { get; set; }
|
}
|
[ST("任务动作表")]
|
public class WmsTaskAction : BaseModel
|
{
|
public string S_TASK_NO { get; set; }
|
/// <summary>
|
/// 信号码
|
/// </summary>
|
public string S_ACTION_CODE { get; set; }
|
/// <summary>
|
/// 信号备注
|
/// </summary>
|
public string S_ACTION_NOTE { 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; }
|
}
|
}
|
