using HH.WCS.ZhongCeJinTan.util;
|
using SqlSugar;
|
using System;
|
using System.Collections.Generic;
|
using System.Linq;
|
using System.Reflection.Emit;
|
using System.Text;
|
using System.Threading.Tasks;
|
|
namespace HH.WCS.ZhongCeJinTan.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;
|
public DateTime T_MODIFY { get; set; } = DateTime.Now;
|
|
|
}
|
|
|
[ST("作业流程表")]
|
public class WorkFlow : BaseModel
|
{
|
/// <summary>
|
/// 流程编号
|
/// </summary>
|
public string FLOWCODE { get; set; }
|
/// <summary>
|
/// 流程名称
|
/// </summary>
|
public string FLOWNAME { get; set; }
|
/// <summary>
|
/// 出入库
|
/// </summary>
|
public string INOROUT { get; set; }
|
/// <summary>
|
/// 是否通知立库
|
/// </summary>
|
/// </summary>
|
public string INFORMWCS { get; set; }
|
/// <summary>
|
/// 是否下达给立库
|
/// </summary>
|
public string SENDWCS { get; set; }
|
/// <summary>
|
/// 接驳位库区
|
/// </summary>
|
public string CONNECTION { get; set; }
|
/// <summary>
|
/// 起点库区
|
/// </summary>
|
public string STARTAREA { get; set; }
|
/// <summary>
|
/// 终点库区
|
/// </summary>
|
public string ENDAREA { get; set; }
|
/// <summary>
|
/// 异常库区
|
/// </summary>
|
public string ERRORAREA { get; set; }
|
/// <summary>
|
/// 工装类型
|
/// </summary>
|
public string TOOLSTYPE { get; set; }
|
/// <summary>
|
/// 巷道 1-2-3 形式
|
/// </summary>
|
public string ROADWAY { get; set; }
|
|
/// <summary>
|
/// 逻辑库区编码
|
/// </summary>
|
public string ZONECODE { get; set; }
|
|
}
|
|
[ST("货位表")]
|
public class Location : BaseModel
|
{
|
/// <summary>
|
/// 货位编码
|
/// </summary>
|
public string S_CODE { get; set; }
|
|
/// <summary>
|
/// 货位名称
|
/// </summary>
|
public string S_NAME { get; set; }
|
|
/// <summary>
|
/// 仓库编码
|
/// </summary>
|
public string S_WH_CODE { get; set; }
|
|
/// <summary>
|
/// 库区编码
|
/// </summary>
|
public string S_AREA_CODE { get; set; }
|
|
/// <summary>
|
/// 库区中文名称
|
/// </summary>
|
public string S_AREA_Name { get; set; }
|
|
/// <summary>
|
/// 巷道
|
/// </summary>
|
public int N_ROADWAY { get; set; }
|
|
/// <summary>
|
/// 排号
|
/// </summary>
|
public int N_ROW { get; set; }
|
|
/// <summary>
|
/// 列号
|
/// </summary>
|
public int N_COL { get; set; }
|
|
/// <summary>
|
/// 层
|
/// </summary>
|
public int N_LAYER { get; set; }
|
|
/// <summary>
|
/// 容量
|
/// </summary>
|
public string N_CAPACITY { get; set; }
|
|
/// <summary>
|
/// 当前数量
|
/// </summary>
|
public int N_CURRENT_NUM { get; set; }
|
|
/// <summary>
|
/// AGV站点
|
/// </summary>
|
public string S_AGV_SITE { get; set; }
|
|
/// <summary>
|
/// AGV站点层数
|
/// </summary>
|
public int N_AGV_SITE_LAYER { get; set; }
|
|
/// <summary>
|
/// 锁定状态
|
/// </summary>
|
public string S_LOCK_STATE { get; set; }
|
|
/// <summary>
|
/// 锁定状态值 1入库锁 2出库锁 0无锁
|
/// </summary>
|
public int N_LOCK_STATE { get; set; }
|
|
|
/// <summary>
|
/// 启用
|
/// </summary>
|
public string C_ENABLE { get; set; }
|
|
/// <summary>
|
/// 深度
|
/// </summary>
|
public string N_DEEP { get; set; }
|
|
[SugarColumn(IsIgnore = true)]
|
[Navigate(NavigateType.OneToOne, nameof(S_CODE))]
|
public LocCntrRel LocCntrRel { get; set; }
|
}
|
|
|
|
[ST("货位容器表")]
|
public class LocCntrRel : BaseModel
|
{
|
/// <summary>
|
/// 货位编码
|
/// </summary>
|
[SugarColumn(IsPrimaryKey = true)]
|
public string S_LOC_CODE { get; set; }
|
|
|
|
|
/// <summary>
|
/// 容器编码
|
/// </summary>
|
public string S_CNTR_CODE { get; set; }
|
|
/// <summary>
|
/// 动作类型
|
/// </summary>
|
//public string S_ACTION_TYPE { get; set; }
|
|
/// <summary>
|
/// 动作源
|
/// </summary>
|
public string S_ACTION_SRC { get; set; }
|
|
/// <summary>
|
/// 动作类型值
|
/// </summary>
|
// public int N_ACTION_TYPE { get; set; }
|
|
/// <summary>
|
/// 绑定方式
|
/// </summary>
|
public string S_BINDING_METHOD { get; set; }
|
|
/// <summary>
|
/// 绑定方式值
|
/// </summary>
|
public int N_BINDING_METHOD { get; set; }
|
|
/// <summary>
|
/// 深位
|
/// </summary>
|
//public int N_DEEP { 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; }
|
}
|
|
|
|
[ST("容器物料表")]
|
public class CntrItemRel : BaseModel
|
{
|
/// <summary>
|
/// 容器编码
|
/// </summary>
|
[SugarColumn(IsPrimaryKey = true)]
|
public string S_CNTR_CODE { 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_BATCH_NO { get; set; }
|
|
/// <summary>
|
/// 数量
|
/// </summary>
|
public decimal F_QTY { get; set; }
|
|
/// <summary>
|
/// 质检状态
|
/// </summary>
|
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; }
|
|
/// <summary>
|
/// 规格
|
/// </summary>
|
public string S_ITEM_SPEC { get; set; }
|
|
/// <summary>
|
/// 总重量
|
/// </summary>
|
public decimal F_SUM_QTY { get; set; }
|
|
/// <summary>
|
/// 入库时间
|
/// </summary>
|
public DateTime T_INSTOCK { get; set; }
|
|
/// <summary>
|
/// 工厂
|
/// </summary>
|
public string facnm { get; set; }
|
|
/// <summary>
|
/// 胶号
|
/// </summary>
|
public string cdrub { get; set; }
|
/// <summary>
|
/// 机台
|
/// </summary>
|
public string mchid { get; set; }
|
/// <summary>
|
/// 作业日期
|
/// </summary>
|
public string wdate { get; set; }
|
/// <summary>
|
/// 班次
|
/// </summary>
|
public string wsht { get; set; }
|
/// <summary>
|
/// 开始车次
|
/// </summary>
|
public string strbat { get; set; }
|
/// <summary>
|
/// 结束车次
|
/// </summary>
|
public string endbat { get; set; }
|
|
/// <summary>
|
/// 生产计划编号
|
/// </summary>
|
public string planno { get; set; }
|
|
/// <summary>
|
/// 胶料段
|
/// </summary>
|
public string stage { get; set; }
|
/// <summary>
|
/// 检验结果
|
/// </summary>
|
public string grd { get; set; }
|
/// <summary>
|
/// 工装重量
|
/// </summary>
|
//public decimal F_AVG_QTY { 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; }
|
}
|
|
//[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 float F_WEIGHT { get; set; }
|
//}
|
[ST("作业表")]
|
public class WmsWork : BaseModel
|
{
|
/// <summary>
|
/// 业务状态（0：等待，1：执行，2：完成，3：错误，4：启动失败，5：暂停启动，6：任务未创建、7：任务取消）
|
/// </summary>
|
public string S_B_STATE { get; set; } = "等待";
|
|
/// <summary>
|
/// 业务状态（0：等待，1：执行，2：完成，3：错误，4：启动失败，5：暂停启动，6：任务未创建、7：任务取消）
|
/// </summary>
|
public int N_B_STATE { get; set; } = 0;
|
|
/// <summary>
|
/// 接驳位，如果有二段任务需要当作业的中转货位，一段任务的终点，二段任务的起点
|
/// </summary>
|
public string CONNECTION { get; set; }
|
|
|
/// <summary>
|
/// 作业工装类型
|
/// </summary>
|
public string TOOLSTYPE { get; set; }
|
|
/// <summary>
|
/// 作业编码
|
/// </summary>
|
public string S_CODE { 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 int N_TYPE { get; set; }
|
|
/// <summary>
|
/// 作业定义名称
|
/// </summary>
|
public string S_OP_DEF_NAME { get; set; }
|
|
/// <summary>
|
/// 开始时间
|
/// </summary>
|
public DateTime? T_START_TIME { get; set; } = null;
|
|
/// <summary>
|
/// 结束时间
|
/// </summary>
|
public DateTime? T_END_TIME { get; set; } = null;
|
|
/// <summary>
|
/// 容器编码
|
/// </summary>
|
public string S_CNTR_CODE { get; set; }
|
|
|
|
/// <summary>
|
/// mobox脚本自动运行启动开关
|
/// </summary>
|
public string C_AUTO_START { get; set; } = "N";
|
|
/// <summary>
|
/// 起点仓库
|
/// </summary>
|
public string S_START_WH { get; set; } = "ZCCK";
|
|
/// <summary>
|
/// 起点库区
|
/// </summary>
|
public string S_START_AREA { get; set; }
|
|
/// <summary>
|
/// 终点仓库
|
/// </summary>
|
public string S_END_WH { get; set; } = "ZCCK";
|
|
/// <summary>
|
/// 终点库区
|
/// </summary>
|
public string S_END_AREA { get; set; }
|
|
|
/// <summary>
|
/// 起点库区名称
|
/// </summary>
|
public string S_START_AREA_NAME { get; set; }
|
/// <summary>
|
/// 终点库区名称
|
/// </summary>
|
public string S_END_AREA_NAME { get; set; }
|
/// <summary>
|
/// 接驳位库区名称
|
/// </summary>
|
public string CONNECTION_AREA { get; set; }
|
|
/// <summary>
|
/// 作业优先级
|
/// </summary>
|
public int N_PRIORITY { get; set; }
|
|
|
|
|
/// <summary>
|
/// 0 等待/1 执行/2 完成/3 错误/4 启劢失败 /5 暂停启劢
|
/// </summary>
|
/// <returns></returns>
|
internal static string GetStateStr(int state)
|
{
|
var status = "";
|
switch (state)
|
{
|
case 0: status = "等待"; break;
|
case 1: status = "执行"; break;
|
case 2: status = "完成"; break;
|
case 3: status = "错误"; break;
|
case 4: status = "启动失败"; break;
|
case 5: status = "暂停失败"; break;
|
case 6: status = "任务未创建"; break;
|
case 7: status = "任务取消"; break;
|
}
|
return status;
|
}
|
|
/// <summary>
|
/// 根据传递数字判断任务类型
|
/// 1：常规入库、2：常规出库、3：盘点入库、4：盘点出库、5：退库任务
|
/// </summary>
|
/// <param name="v"></param>
|
/// <returns></returns>
|
internal static string GetTypeStr(int v)
|
{
|
var str = "";
|
switch (v)
|
{
|
case 1: str = "常规入库"; break;
|
case 2: str = "常规出库"; break;
|
case 3: str = "点到点任务"; break;
|
case 4: str = "盘点出库"; break;
|
case 5: str = "特殊任务"; break;
|
}
|
return str;
|
}
|
|
/// <summary>
|
/// 根据传递数字判断任务中文名称
|
/// </summary>
|
/// <param name="v"></param>
|
/// <returns></returns>
|
public static string GetOpName(int v)
|
{
|
var str = "";
|
switch (v)
|
{
|
case 1: str = "码盘入库"; break;
|
case 2: str = "FTP出库"; break;
|
case 20: str = "点到点任务"; break;
|
case 4: str = "盘点出库"; break;
|
case 5: str = "特殊任务"; break;
|
}
|
return str;
|
}
|
}
|
|
[ST("任务表")]
|
public class WMSTask : BaseModel
|
{
|
/// <summary>
|
/// 作业工装类型
|
/// </summary>
|
public string TOOLSTYPE { get; set; }
|
|
|
/// <summary>
|
/// 任务编码
|
/// </summary>
|
public string S_CODE { get; set; }
|
|
/// <summary>
|
/// 任务类型值
|
/// </summary>
|
public int N_TYPE { get; set; }
|
|
/// <summary>
|
/// 任务类型
|
/// </summary>
|
public string S_TYPE { get; set; }
|
|
/// <summary>
|
/// 任务状态值
|
/// </summary>
|
public int N_B_STATE { get; set; }
|
|
/// <summary>
|
/// 任务状态
|
/// </summary>
|
public string S_B_STATE { get; set; }
|
|
|
/// <summary>
|
/// 作业编码
|
/// </summary>
|
public string S_OP_CODE { get; set; }
|
|
/// <summary>
|
/// 设备编号
|
/// </summary>
|
public string S_EQ_NO { get; set; }
|
|
/// <summary>
|
/// 开始时间
|
/// </summary>
|
public DateTime? T_START_TIME { get; set; } = null;
|
|
/// <summary>
|
/// 结束时间
|
/// </summary>
|
public DateTime? T_END_TIME { get; set; } = null;
|
|
/// <summary>
|
/// 调度类型值
|
/// </summary>
|
public int N_SCHEDULE_TYPE { get; set; }
|
|
/// <summary>
|
/// 调度类型
|
/// </summary>
|
public string S_SCHEDULE_TYPE { get; set; }
|
|
/// <summary>
|
/// 优先级
|
/// </summary>
|
public int N_PRIORITY { get; set; }
|
|
/// <summary>
|
/// 设备任务号
|
/// </summary>
|
public string S_EQ_TASK_CODE { get; set; }
|
|
/// <summary>
|
/// 起始仓库
|
/// </summary>
|
public string S_START_WH { get; set; }
|
|
/// <summary>
|
/// 起始库区编号
|
/// </summary>
|
public string S_START_AREA { get; set; }
|
|
/// <summary>
|
/// 起始库区编号
|
/// </summary>
|
public string S_START_AREA_NAME { get; set; }
|
|
/// <summary>
|
/// 目的库区编号
|
/// </summary>
|
public string S_END_AREA_NAME { get; set; }
|
|
/// <summary>
|
/// 起点
|
/// </summary>
|
public string S_START_LOC { get; set; }
|
|
/// <summary>
|
/// 起始货位站点
|
/// </summary>
|
public string S_START_SITE { get; set; }
|
|
/// <summary>
|
/// 起点层
|
/// </summary>
|
public int S_START_SITE_LAYER { get; set; }
|
|
/// <summary>
|
/// 目的仓库
|
/// </summary>
|
public string S_END_WH { get; set; }
|
|
/// <summary>
|
/// 目的库区编号
|
/// </summary>
|
public string S_END_AREA { get; set; }
|
|
/// <summary>
|
/// 终点
|
/// </summary>
|
public string S_END_LOC { get; set; }
|
|
/// <summary>
|
/// 目的货位站点
|
/// </summary>
|
public string S_END_SITE { get; set; }
|
|
/// <summary>
|
/// 终点层
|
/// </summary>
|
public int S_END_SITE_LAYER { get; set; }
|
|
/// <summary>
|
/// 备注
|
/// </summary>
|
public string S_NOTE { get; set; }
|
|
/// <summary>
|
/// 错误信息
|
/// </summary>
|
public string S_ERR { get; set; }
|
|
/// <summary>
|
/// 错误码
|
/// </summary>
|
public int N_ERR { get; set; }
|
|
/// <summary>
|
/// 容器编码
|
/// </summary>
|
public string S_CNTR_CODE { get; set; }
|
|
/// <summary>
|
/// 搬运的托盘数量
|
/// </summary>
|
public int N_CNTR_COUNT { get; set; }
|
|
|
/// <summary>
|
/// 车间编码
|
/// </summary>
|
public string S_WORKSHOP_NO { get; set; }
|
|
|
/// <summary>
|
/// 车间名称
|
/// </summary>
|
public string S_WORKSHOP_NAME { get; set; }
|
|
|
|
internal static string GetStateStr(int state)
|
{
|
//0等待 1已推送 2执行 3完成 4错误
|
var status = "";
|
switch (state)
|
{
|
case 0:
|
status = "等待";
|
break;
|
case 1:
|
status = "已推送";
|
break;
|
case 2:
|
status = "执行";
|
break;
|
case 3:
|
status = "完成";
|
break;
|
case 4:
|
status = "错误";
|
break;
|
case 5:
|
status = "取消";
|
break;
|
}
|
|
return status;
|
}
|
}
|
|
|
[ST("任务动作表")]
|
public class WmsTaskAction : BaseModel
|
{
|
/// <summary>
|
/// 设备类型
|
/// </summary>
|
public string S_EQ_TYPE { get; set; }
|
|
/// <summary>
|
/// 动作
|
/// </summary>
|
public string S_ACTION { get; set; }
|
|
/// <summary>
|
/// 任务编码
|
/// </summary>
|
public string S_TASK_CODE { get; set; }
|
|
/// <summary>
|
/// 设备号
|
/// </summary>
|
public string S_EQ_CODE { get; set; }
|
|
/// <summary>
|
/// 附加参数
|
/// </summary>
|
public string S_DATA { get; set; }
|
|
/// <summary>
|
/// 动作码
|
/// </summary>
|
public int N_ACTION_CODE { get; set; }
|
|
}
|
|
|
[ST("容器表")]
|
public class Container : BaseModel
|
{
|
/// <summary>
|
/// 容器编码
|
/// </summary>
|
public string S_CODE { get; set; }
|
|
/// <summary>
|
/// 容器类型值
|
/// </summary>
|
//public string N_TYPE { get; set; }
|
|
/// <summary>
|
/// 容器类型
|
/// </summary>
|
public string S_TYPE{ get; set; }
|
|
/// <summary>
|
/// 规格
|
/// </summary>
|
//public string S_SPEC { get; set; }
|
|
/// <summary>
|
/// 自重
|
/// </summary>
|
//public float F_WEIGHT { get; set; }
|
|
/// <summary>
|
/// 最大重量
|
/// </summary>
|
//public float F_MAX_WEIGHT { get; set; }
|
|
/// <summary>
|
/// 长
|
/// </summary>
|
//public int N_LENGTH { get; set; }
|
|
/// <summary>
|
/// 是否可用
|
/// </summary>
|
public string C_ENABLE { get; set; }
|
|
/// <summary>
|
/// 宽
|
/// </summary>
|
// public int N_WIDTH { get; set; }
|
|
/// <summary>
|
/// 虚拟容器
|
/// </summary>
|
//public string C_IS_VIRTUAL { get; set; }
|
|
/// <summary>
|
/// 高
|
/// </summary>
|
//public string N_HEIGHT { get; set; }
|
|
/// <summary>
|
/// 明细条数
|
/// </summary>
|
public int N_DETAIL_COUNT { get; set; }
|
|
/// <summary>
|
/// 容器业务状态
|
/// </summary>
|
//public int N_B_STATE { get; set; }
|
|
/// <summary>
|
/// 锁定业务号
|
/// </summary>
|
//public string S_LOCK_OP_CODE { get; set; }
|
|
/// <summary>
|
/// 锁状态
|
/// </summary>
|
//public string S_LOCK_STATE { get; set; }
|
|
/// <summary>
|
/// 锁状态
|
/// </summary>
|
//public int N_LOCK_STATE { get; set; }
|
|
/// <summary>
|
/// 货品重量
|
/// </summary>
|
//public float F_GOOD_WEIGHT { get; set; }
|
|
|
/// <summary>
|
/// 最大体积
|
/// </summary>
|
//public float F_MAX_VOLUME { get; set; }
|
|
/// <summary>
|
/// 货品体积
|
/// </summary>
|
//public float F_GOOD_VOLUME { get; set; }
|
|
/// <summary>
|
/// 满框
|
/// </summary>
|
//public string C_FULL { get; set; }
|
|
}
|
|
/// <summary>
|
/// MES任务记录表
|
/// </summary>
|
[ST("MES任务记录表")]
|
public class MesTask : BaseModel
|
{
|
/// <summary>
|
/// 任务号
|
/// </summary>
|
public string task_no { get; set; }
|
/// <summary>
|
/// 任务类型1:入库;2:出库
|
/// </summary>
|
public int Task_type { get; set; }
|
/// <summary>
|
/// 周转卡号
|
/// </summary>
|
public string TurnCardNum { get; set; }
|
/// <summary>
|
/// 标准重量
|
/// </summary>
|
public float standardWeight { get; set; }
|
/// <summary>
|
/// 工装类型 胎侧25,内衬35,胎体/帘布45,带束55,胎圈65,胎面15,纤维85，钢丝95
|
/// </summary>
|
public string TOOLS_TPYE { get; set; }
|
/// <summary>
|
/// 制品编号
|
/// </summary>
|
public string PROD_NO { get; set; }
|
/// <summary>
|
/// 工艺编号
|
/// </summary>
|
public string PROD_TECH { get; set; }
|
/// <summary>
|
/// 制品规格
|
/// </summary>
|
public string PROD_SPEC { get; set; }
|
/// <summary>
|
/// 制品类型
|
/// </summary>
|
public string PROD_BOM { get; set; }
|
/// <summary>
|
/// 制品特征值
|
/// </summary>
|
public string PROD_Feature { get; set; }
|
/// <summary>
|
/// 工装编号
|
/// </summary>
|
public string TOOLS_NO { get; set; }
|
/// <summary>
|
/// 载料数量
|
/// </summary>
|
public float ST_AMOUNT { get; set; }
|
/// <summary>
|
/// 当前数量
|
/// </summary>
|
public float CURRENT_AMOUNT { get; set; }
|
/// <summary>
|
/// 起始库位编号
|
/// </summary>
|
public string Location_From { get; set; }
|
/// <summary>
|
/// 目的库位编号
|
/// </summary>
|
public string Location_To { get; set; }
|
/// <summary>
|
/// 生产时间
|
/// </summary>
|
public DateTime PRODUCE_TIME { get; set; }
|
/// <summary>
|
/// 生效时间
|
/// </summary>
|
public DateTime SHELF_LIFE_TIME { get; set; }
|
/// <summary>
|
/// 失效时间
|
/// </summary>
|
public DateTime EXPIRED_TIME { get; set; }
|
/// <summary>
|
/// 缩短报告时间
|
/// </summary>
|
public float SHELF_REP { get; set; }
|
/// <summary>
|
/// 延长报告时间
|
/// </summary>
|
public float EXPIRED_REP { get; set; }
|
/// <summary>
|
/// 质检状态代码
|
/// </summary>
|
public string CHECK_CODE { get; set; }
|
/// <summary>
|
/// 质检状态
|
/// </summary>
|
public string CHECK_INFO { get; set; }
|
/// <summary>
|
/// 优先级0-普通：任务生成时，均为此级别;1-加急;2-紧急
|
/// </summary>
|
public int Priority { get; set; }
|
/// <summary>
|
/// 任务状态0-初始状态;1-进行中;2-完成;3-任务取消
|
/// </summary>
|
public int Data_status { get; set; }
|
/// <summary>
|
/// 业务类型
|
/// </summary>
|
public string BUSI_TYPE { get; set; }
|
|
/// <summary>
|
/// 创建时间
|
/// </summary>
|
public DateTime CreateDate { get; set; }
|
|
/// <summary>
|
/// 返回信息mes
|
/// </summary>
|
public string errMsg { get; set; }
|
|
/// <summary>
|
/// 返回码mes
|
/// </summary>
|
public int errCode { get; set; }
|
|
}
|
|
|
/// <summary>
|
/// 空托出缓存表
|
/// </summary>
|
[ST("空托出缓存表")]
|
public class MesKtTask : BaseModel
|
{
|
/// <summary>
|
/// 工装类型 胎侧25,内衬35,胎体/帘布45,带束55,胎圈65,胎面15,纤维85，钢丝95
|
/// </summary>
|
public string TOOLS_TPYE { get; set; }
|
|
/// <summary>
|
/// 起始库区编号
|
/// </summary>
|
public string Location_From_Area { get; set; }
|
/// <summary>
|
/// 目的库位编号
|
/// </summary>
|
public string Location_To { get; set; }
|
|
/// <summary>
|
/// 优先级0-普通：任务生成时，均为此级别;1-加急;2-紧急
|
/// </summary>
|
public int Priority { get; set; }
|
|
/// <summary>
|
/// 业务类型
|
/// </summary>
|
public string BUSI_TYPE { get; set; }
|
|
/// <summary>
|
/// 创建时间
|
/// </summary>
|
public DateTime CreateDate { get; set; }
|
|
/// <summary>
|
/// 空托任务是否创建 Y/N 默认N
|
/// </summary>
|
public string Status { get; set; }
|
}
|
|
|
/// <summary>
|
/// 上下架表
|
/// </summary>
|
[ST("上下架记录")]
|
public class RecordUpAndDown : BaseModel
|
{
|
|
|
/// <summary>
|
/// 上架下架
|
/// </summary>
|
public string S_ACTION { get; set; }
|
|
|
/// <summary>
|
/// 终点货位
|
/// </summary>
|
public string S_END_LOC { get; set; }
|
|
/// <summary>
|
/// 起点货位
|
/// </summary>
|
public string S_LOC_CODE { get; set; }
|
|
/// <summary>
|
/// 出入库时间
|
/// </summary>
|
public DateTime T_INBOUND_TIME { get; set; }
|
|
/// <summary>
|
/// 任务号
|
/// </summary>
|
public string S_OPTASK { get; set; }
|
|
/// <summary>
|
/// 托盘码
|
/// </summary>
|
public string S_CNTR_CODE { get; set; }
|
|
/// <summary>
|
/// 货品编码
|
/// </summary>
|
public string S_ITEM_CODE { get; set; }
|
|
/// <summary>
|
/// 生产时间
|
/// </summary>
|
public DateTime D_PRD_DATE { get; set; }
|
|
/// <summary>
|
/// 批次号
|
/// </summary>
|
public string S_BATCH_NO { get; set; }
|
|
|
/// <summary>
|
/// 托盘类型
|
/// </summary>
|
public string S_TRAY_TYPE { get; set; }
|
|
/// <summary>
|
/// 货品名称
|
/// </summary>
|
public string S_ITEM_NAME { get; set; }
|
|
/// <summary>
|
/// 数量
|
/// </summary>
|
public decimal F_QTY { get; set; }
|
|
/// <summary>
|
/// 质检状态
|
/// </summary>
|
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 string Level { get; set; }
|
|
/// <summary>
|
/// 规格
|
/// </summary>
|
public string S_ITEM_SPEC { get; set; }
|
|
/// <summary>
|
/// 总重量
|
/// </summary>
|
public decimal F_SUM_QTY { get; set; }
|
}
|
|
|
|
|
|
|
|
/// <summary>
|
/// AGV状态信息表
|
/// </summary>
|
[ST("AGV状态信息表")]
|
public class S_AGV_CONDITIONEntitys : BaseModel
|
{
|
/// <summary>
|
/// 车号
|
/// </summary>
|
[SugarColumn(IsPrimaryKey = true)]
|
public string forkliftNo { get; set; }
|
|
#region 电池信息
|
/// <summary>
|
/// 电池电量
|
/// </summary>
|
public string Battery_Soc { get; set; }
|
/// <summary>
|
/// 电池电压
|
/// </summary>
|
public string Battery_V { get; set; }
|
|
/// <summary>
|
/// 电池电流
|
/// </summary>
|
public string Battery_Amp { get; set; }
|
|
/// <summary>
|
/// 电池温度
|
/// </summary>
|
public string Battery_Temp { get; set; }
|
/// <summary>
|
/// 电池属性
|
/// </summary>
|
public string Battery_Prop { get; set; }
|
#endregion
|
|
#region 电机信息
|
/// <summary>
|
/// 电机电流
|
/// </summary>
|
public string Motor_Amp { get; set; }
|
/// <summary>
|
/// 电机温度
|
/// </summary>
|
public string Motor_Temp { get; set; }
|
|
/// <summary>
|
/// 油泵电机起升时电流
|
/// </summary>
|
public string Motor_Y_Amp { get; set; }
|
/// <summary>
|
/// 油泵电机实时温度
|
/// </summary>
|
public string Motor_Y_Temp { get; set; }
|
#endregion
|
#region 交通管制信息
|
/// <summary>
|
/// 布局位置点
|
/// </summary>
|
public string Traffic_Pt { get; set; }
|
/// <summary>
|
/// 布局位置段
|
/// </summary>
|
public string Traffic_Sec { get; set; }
|
/// <summary>
|
/// 堵塞逻辑线
|
/// </summary>
|
public string Traffic_Wire { get; set; }
|
/// <summary>
|
/// 堵塞单位编号
|
/// </summary>
|
public string Traffic_Unit { get; set; }
|
/// <summary>
|
/// 堵塞IO,ID
|
/// </summary>
|
public string Traffic_Io { get; set; }
|
#endregion
|
#region 开机时间
|
/// <summary>
|
/// 累计开机时间，单位（天）
|
/// </summary>
|
public string Time_D { get; set; }
|
/// <summary>
|
/// 累计开机时间，单位（h）
|
/// </summary>
|
public string time_H { get; set; }
|
#endregion
|
#region 里程
|
/// <summary>
|
/// 累计里程，单位（km）
|
/// </summary>
|
public string Mileage_Km { get; set; }
|
/// <summary>
|
/// 累计里程，单位（m）
|
/// </summary>
|
public string Mileage_m { get; set; }
|
#endregion
|
#region 举升次数
|
/// <summary>
|
/// 累计货叉举升次数，单位:1000次
|
/// </summary>
|
public string Lifts_Kc { get; set; }
|
/// <summary>
|
///累计货叉举升次数，单位:次
|
/// </summary>
|
public string Lifts_c { get; set; }
|
#endregion
|
|
#region 其他信息
|
/// <summary>
|
/// 车辆X坐标(cm)
|
/// </summary>
|
public string Pos_X { get; set; }
|
/// <summary>
|
/// 车辆Y坐标(cm)
|
/// </summary>
|
public string Pos_Y { get; set; }
|
/// <summary>
|
/// 车辆z坐标(起升高度)(mm)
|
/// </summary>
|
public string Pos_Z { get; set; }
|
#endregion
|
#region 转向角度
|
/// <summary>
|
/// 转向角度，单位:°
|
/// </summary>
|
public string Angle_Deg { get; set; }
|
#endregion
|
#region agv状态
|
public string Agvstate_s { get; set; }
|
#endregion
|
}
|
|
/// <summary>
|
/// AGV报警对照表
|
/// </summary>
|
[ST("AGV报警对照表")]
|
public class S_AGV_TYPEEntitys : BaseModel
|
{
|
/// <summary>
|
/// 错误类型
|
/// </summary>
|
public string S_AGV_TYPE { get; set; }
|
/// <summary>
|
/// AGV错误代码
|
/// </summary>
|
public string S_AGV_ERRCODE { get; set; }
|
/// <summary>
|
/// 1的位置
|
/// </summary>
|
public int N_CODE_1 { get; set; }
|
/// <summary>
|
/// 含义
|
/// </summary>
|
public string S_AGV_NOTE { get; set; }
|
/// <summary>
|
/// 开关
|
/// </summary>
|
public string S_IS_OPEN { get; set; }
|
}
|
|
/// <summary>
|
/// AGV报警信息表
|
/// </summary>
|
[ST("AGV报警信息表")]
|
public class AgvErrorReportEntitys : BaseModel
|
{
|
/// <summary>
|
/// 车号
|
/// </summary>
|
public string AgvLicense { get; set; }
|
/// <summary>
|
/// 错误信息
|
/// </summary>
|
public string AgvErrorMsg { get; set; }
|
}
|
|
/// <summary>
|
/// 任务拦截表
|
/// </summary>
|
[ST("任务拦截表")]
|
public class ManualTaskSwitch : BaseModel
|
{
|
|
/// <summary>
|
/// 任务拦截开关 Y/N Y表示拦截任务推送
|
/// </summary>
|
public string State { get; set; }
|
}
|
|
|
|
|
/// <summary>
|
/// 逻辑库区货位关联表
|
/// </summary>
|
[ST("逻辑库区货位关联表")]
|
public class ZoneLoc : BaseModel
|
{
|
//货位编码
|
[SugarColumn(IsPrimaryKey = true)]
|
public string S_LOC_CODE { get; set; }
|
//逻辑库区编码
|
public string S_ZONE_CODE { get; set; }
|
|
[SugarColumn(IsIgnore = true)]
|
[Navigate(NavigateType.OneToOne, nameof(S_LOC_CODE), nameof(Location.S_CODE))]
|
public Location Loc { get; set; }
|
}
|
|
|
/// <summary>
|
/// 逻辑编码相关逻辑库区关联
|
/// </summary>
|
[ST("逻辑编码关联表")]
|
public class Zone : BaseModel
|
{
|
public string S_NAME { get; set; }
|
public string S_NOTE { get; set; }
|
public string S_WH_CODE { get; set; }
|
public int N_EMPTY_MIN { get; set; }
|
public int N_EMPTY_MAX { get; set; }
|
[SugarColumn(IsPrimaryKey = true)]
|
public string S_CODE { get; set; }
|
public string S_AREA_CODE { get; set; }
|
public string S_LOC_RULE { get; set; }
|
public string S_ZONE_CLS_CODE { get; set; }
|
public int N_AVAILABLE_IN { get; set; }
|
public int N_TYPE { get; set; }
|
public string S_TYPE { get; set; }
|
public string S_ITEM_CODE { get; set; }
|
public string S_ITEM_NAME { get; set; }
|
public string S_BATCH_NO { get; set; }
|
public string S_ITEM_CATEGORY { get; set; }
|
public string S_OWNER_CODE { get; set; }
|
public string S_SUPPLIER_CODE { get; set; }
|
public int N_CONNECT_TYPE { get; set; }
|
public string S_CONNECT_TYPE { get; set; }
|
public int N_LOCK_STATE { get; set; }
|
public string S_LOCK_STATE { get; set; }
|
public string S_OWNER_NAME { get; set; }
|
public string S_SUPPLIER_NAME { get; set; }
|
public int N_STORE_MAX { get; set; }
|
public string S_STATE_PRE { get; set; }
|
|
public string C_IS_AREA { get; set; }
|
public string S_GROUP { get; set; }
|
|
[SugarColumn(IsIgnore = true)]
|
[Navigate(NavigateType.OneToMany, nameof(S_CODE), nameof(ZoneLoc.S_LOC_CODE))]
|
public List<ZoneLoc> ZoneLocs { get; set; }
|
}
|
|
|
}
|
