using HH.WCS.QingXigongchang.process;
|
using HH.WCS.QingXigongchang.util;
|
using SqlSugar;
|
using System;
|
|
namespace HH.WCS.QingXigongchang.wms
|
{
|
|
//---------------------------------------工单信息---------------------------------------
|
|
//198服务器
|
//[SugarTable("dbo.TN_0138")]
|
//均州现场
|
//[SugarTable("dbo.TN_0002")]
|
//新安江
|
//[SugarTable("dbo.TN_0026")]
|
[SuGG("工单表")]
|
public class WorkOrder : BaseModel
|
{
|
/// <summary>
|
/// 板子类型
|
/// </summary>
|
public string B_Type { get; set; }
|
|
//工单自动转运终点区域
|
/// <summary>
|
/// 不存入
|
/// 具体库区
|
/// </summary>
|
public string TurnArea { get; set; }
|
|
/// <summary>
|
/// AutoTurn
|
/// TurnComplete
|
/// TurnFail
|
/// 同时当作Note用
|
/// </summary>
|
public string TurnState { get; set; }
|
/// <summary>
|
/// 批次号
|
/// </summary>
|
public string SQL_BatchNo { get; set; }
|
/// <summary>
|
/// 产线号
|
/// </summary>
|
public string SQL_PLineNo { get; set; }
|
public string FuLe_PLine_No { get; set; }
|
|
/// <summary>
|
/// 物料再托盘上 堆叠的层数。
|
/// </summary>
|
public int ItemLayer { get; set; }
|
/// <summary>
|
/// 瓶盖机机无，翻斗机线边区连接到翻斗机暂存区
|
/// --- 瓶坯 链接 翻斗机 settings 中添加了 瓶坯的终点即产
|
/// </summary>
|
public string SQL_LinkLineNO { get; set; }
|
/// <summary>
|
/// 连接区域,瓶盖机连接v8或无；翻斗机连接线边区
|
/// 设置 机台的对应。终点区域。（即产时使用 ）
|
/// </summary>
|
public string SQL_Area { get; set; }
|
/// <summary>
|
/// 入库区 瓶坯的入库选择区域。瓶坯的翻斗机 出去区域。
|
/// </summary>
|
public string SQL_Area1 { get; set; }
|
//SQL_LinkLineNo2
|
[SugarColumn(ColumnName = "SQL_LinkLineNo2")]
|
public string SQL_LinkLineNO1 { get; set; }
|
/// <summary>
|
/// 即产即用
|
/// </summary>
|
public string SQL_UsingNow { get; set; }//SQL_UsingNow "Y"|"N"
|
/// <summary>
|
/// 外调
|
/// </summary>
|
public string SQL_Out { get; set; }//SQL_Out "Y"|"N"
|
/// <summary>
|
/// 工单状态
|
/// </summary>
|
public string SQL_State { get; set; }//SQL_State
|
/// <summary>
|
/// 工单号
|
/// </summary>
|
public string SQL_WorkNo { get; set; }//SQL_WorkNo
|
|
/// <summary>
|
/// 工单限制数。 限制任务中 最大锁排数量 -
|
/// </summary>
|
public int N_LimitNum { get; set; }//SQL_WorkNo
|
/// <summary>
|
/// 物料编码
|
/// </summary>
|
public string SQL_ItemCode { get; set; }
|
/// <summary>
|
/// 物料名称
|
/// </summary>
|
public string SQL_ItemName { get; set; }//SQL_ItemName
|
/// <summary>
|
/// 总数
|
/// </summary>
|
public string SQL_Total { get; set; }//SQL_Total
|
/// <summary>
|
/// 即产即用数量
|
/// </summary>
|
public string SQL_UsingNowTotal { get; set; }
|
|
/// <summary>
|
/// 每批运输数量
|
/// </summary>
|
[SugarColumn(IsIgnore = !TaskProcess.UPFule)]
|
public string SQL_PCNumber_using { get; set; } = "0";//SQL_PCNumber=""
|
public string SQL_PCNumber { get; set; }//SQL_PCNumber
|
/// <summary>s
|
/// 计数（已执行数量）
|
/// </summary>
|
public string SQL_Current { get; set; }//SQL_Current
|
/// <summary>
|
/// 当前工单执行时间
|
/// </summary>
|
public string SQL_Modify { get; set; }//SQL_Modify
|
/// <summary>
|
/// 当前工单结束时间
|
/// </summary>
|
public string SQL_PLAN_END { get; set; }
|
/// <summary>
|
/// 是、否
|
/// </summary>
|
public string SQL_AutoComplete { get; set; }
|
|
[SugarColumn(IsIgnore = true)]
|
public bool IsFinished { get; set; } = false;
|
|
/// <summary>
|
/// 库区a=1-2-3 独占 库区a的 123排
|
/// </summary>
|
public string S_ROW { get; set; }
|
|
/// <summary>
|
/// 同 s_row , 瓶坯的入库库区排， 瓶坯翻斗机的出库库区排
|
/// </summary>
|
public string S_ROW1 { get; set; }
|
/// <summary>
|
/// 工单执行时 写时间。 用于执行延迟10秒以后 工单判断
|
/// </summary>
|
public DateTime? SQL_Modify_TIme { get; set; }
|
/// <summary>
|
/// Y S_ROW 不足时按正常逻辑 N 等待。
|
/// </summary>
|
public string S_Is_Auto { get; set; } = "";
|
/// 是 或 （） <summary>
|
//[SugarColumn(IsIgnore = true)]
|
public string FromFuLe { get; set; }
|
|
|
/// <summary>
|
/// 产线关联工单号。
|
/// </summary>
|
[SugarColumn(IsIgnore = !TaskProcess.UPFule)]
|
public string Sign { get; set; }
|
|
[SugarColumn(IsIgnore = true)]
|
public int pcnumusing
|
{
|
get
|
{
|
int q = 0;
|
int.TryParse(SQL_PCNumber_using?.Split('.')[0], out q);
|
return q;
|
}
|
}
|
[SugarColumn(IsIgnore = true)]
|
public int pcnum
|
{
|
get
|
{
|
int q = 0;
|
int.TryParse(SQL_PCNumber?.Split('.')[0], out q);
|
return q;
|
}
|
}
|
[SugarColumn(IsIgnore = true)]
|
public int current
|
{
|
get
|
{
|
int q = 0;
|
int.TryParse(SQL_Current?.Split('.')[0], out q);
|
return q;
|
}
|
}
|
}
|
|
/// <summary>
|
/// 原物料工单表
|
/// </summary>
|
[SuGG("原物料工单表")]
|
public class YWLWorkOrder : BaseModel
|
{
|
/// <summary>
|
/// 产线号
|
/// </summary>
|
public string SQL_PLineNo { get; set; }
|
public string FuLe_PLine_No { get; set; }
|
|
/// <summary>
|
/// 瓶盖机机无，翻斗机线边区连接到翻斗机暂存区
|
/// --- 瓶坯 链接 翻斗机 settings 中添加了 瓶坯的终点即产
|
/// </summary>
|
public string SQL_LinkLineNO { get; set; }
|
/// <summary>
|
/// 连接区域,瓶盖机连接v8或无；翻斗机连接线边区
|
/// 设置 机台的对应。终点区域。（即产时使用 ）
|
/// </summary>
|
public string SQL_Area { get; set; }
|
|
/// <summary>
|
/// 即产即用
|
/// </summary>
|
public string SQL_UsingNow { get; set; }//SQL_UsingNow "Y"|"N"
|
|
/// <summary>
|
/// 工单状态
|
/// </summary>
|
public string SQL_State { get; set; }//SQL_State
|
|
/// <summary>
|
/// 工单号
|
/// </summary>
|
public string SQL_WorkNo { get; set; }//SQL_WorkNo
|
public string S_ROW { get; set; }
|
|
/// <summary>
|
/// 物料编码
|
/// </summary>
|
public string SQL_ItemCode { get; set; }
|
|
/// <summary>
|
/// 物料名称
|
/// </summary>
|
public string SQL_ItemName { get; set; }//SQL_ItemName
|
|
/// <summary>
|
/// 6:2 , 5:2 ,3:1 等等， 成品信号数:出库托盘数（按托盘数算，比如仓库是2层，就是2个托盘）
|
/// </summary>
|
public string SQL_charge { get; set; }
|
|
/// <summary>
|
/// 统计信号总数 - 出发outNum+1 后重置
|
/// </summary>
|
public int SQL_Total { get; set; }//SQL_Total
|
|
/// <summary>
|
/// 当前工单结束时间
|
/// </summary>
|
public string SQL_PLAN_END { get; set; }
|
/// <summary>
|
/// 工单执行时 写时间。 用于执行延迟10秒以后 工单判断
|
/// </summary>
|
public DateTime? SQL_Modify_TIme { get; set; }
|
|
/// <summary>
|
/// 出库领料数， 根据信号操作增加。
|
/// </summary>
|
public int OutNum { get; set; } = 0;
|
|
/// <summary>
|
/// 1.退料
|
/// 2.入库
|
/// 6.上料
|
/// </summary>
|
public int WorkType { get; internal set; } = 0;
|
public string MidArea { get; internal set; }
|
|
/// <summary>
|
/// 弃用， 改为记录上次库区-
|
/// </summary>
|
public string TagOver { get; internal set; } = "";
|
|
public DateTime? TagOverTime { get; internal set; }
|
public string S_BQ_TRAY_TYPE { get; internal set; } = "";
|
/// <summary>
|
/// 厂家
|
/// </summary>
|
public string S_CJ_NAME { get; set; }
|
}
|
|
[SuGG("半成品区域表")]
|
public class BcpQyOrder : BaseModel
|
{
|
}
|
|
[SuGG("厂家时间表")]
|
public class CjTimeOrder : BaseModel
|
{
|
/// <summary>
|
/// 厂家名称
|
/// </summary>
|
public string S_CJ_NAME { get; set; }
|
/// <summary>
|
/// 厂家时间
|
/// </summary>
|
public DateTime T_CJ_TIME { get; set; }
|
/// <summary>
|
/// 物料编码
|
/// </summary>
|
public string S_ITEM_CODE { get; set; }
|
/// <summary>
|
/// 物料名称
|
/// </summary>
|
public string S_ITEM_NAME { get; set; }
|
}
|
|
[SuGG("瓶盖工单表")]
|
public class PGWorkOrder : BaseModel
|
{
|
/// <summary>
|
/// 板子类型
|
/// </summary>
|
public string B_Type { get; set; }
|
|
//工单自动转运终点区域
|
/// <summary>
|
/// 不存入
|
/// 具体库区
|
/// </summary>
|
public string TurnArea { get; set; }
|
|
/// <summary>
|
/// AutoTurn
|
/// TurnComplete
|
/// TurnFail
|
/// 同时当作Note用
|
/// </summary>
|
public string TurnState { get; set; }
|
/// <summary>
|
/// 批次号
|
/// </summary>
|
public string SQL_BatchNo { get; set; }
|
/// <summary>
|
/// 产线号
|
/// </summary>
|
public string SQL_PLineNo { get; set; }
|
public string FuLe_PLine_No { get; set; }
|
|
/// <summary>
|
/// 物料再托盘上 堆叠的层数。
|
/// </summary>
|
public int ItemLayer { get; set; }
|
/// <summary>
|
/// 瓶盖机机无，翻斗机线边区连接到翻斗机暂存区
|
/// --- 瓶坯 链接 翻斗机 settings中添加了 瓶坯的终点即产
|
/// </summary>
|
public string SQL_LinkLineNO { get; set; }
|
/// <summary>
|
/// 连接区域,瓶盖机连接v8或无；翻斗机连接线边区
|
/// 设置 机台的对应。终点区域。（即产时使用 ）
|
/// </summary>
|
public string SQL_Area { get; set; }
|
/// <summary>
|
/// 入库区 瓶坯的入库选择区域。瓶坯的翻斗机 出去区域。
|
/// </summary>
|
public string SQL_Area1 { get; set; }
|
//SQL_LinkLineNo2
|
[SugarColumn(ColumnName = "SQL_LinkLineNo2")]
|
public string SQL_LinkLineNO1 { get; set; }
|
/// <summary>
|
/// 即产即用
|
/// </summary>
|
public string SQL_UsingNow { get; set; }//SQL_UsingNow "Y"|"N"
|
/// <summary>
|
/// 外调
|
/// </summary>
|
public string SQL_Out { get; set; }//SQL_Out "Y"|"N"
|
/// <summary>
|
/// 工单状态
|
/// </summary>
|
public string SQL_State { get; set; }//SQL_State
|
/// <summary>
|
/// 工单号
|
/// </summary>
|
public string SQL_WorkNo { get; set; }//SQL_WorkNo
|
|
/// <summary>
|
/// 工单限制数。 限制任务中 最大锁排数量 -
|
/// </summary>
|
public int N_LimitNum { get; set; }//SQL_WorkNo
|
/// <summary>
|
/// 物料编码
|
/// </summary>
|
public string SQL_ItemCode { get; set; }
|
/// <summary>
|
/// 物料名称
|
/// </summary>
|
public string SQL_ItemName { get; set; }//SQL_ItemName
|
/// <summary>
|
/// 总数
|
/// </summary>
|
public string SQL_Total { get; set; }//SQL_Total
|
/// <summary>
|
/// 即产即用数量
|
/// </summary>
|
public string SQL_UsingNowTotal { get; set; }
|
|
/// <summary>
|
/// 每批运输数量
|
/// </summary>
|
[SugarColumn(IsIgnore = !TaskProcess.UPFule)]
|
public string SQL_PCNumber_using { get; set; } = "0";//SQL_PCNumber=""
|
public string SQL_PCNumber { get; set; }//SQL_PCNumber
|
/// <summary>s
|
/// 计数（已执行数量）
|
/// </summary>
|
public string SQL_Current { get; set; }//SQL_Current
|
/// <summary>
|
/// 当前工单执行时间
|
/// </summary>
|
public string SQL_Modify { get; set; }//SQL_Modify
|
/// <summary>
|
/// 当前工单结束时间
|
/// </summary>
|
public string SQL_PLAN_END { get; set; }
|
/// <summary>
|
/// 是、否
|
/// </summary>
|
public string SQL_AutoComplete { get; set; }
|
|
[SugarColumn(IsIgnore = true)]
|
public bool IsFinished { get; set; } = false;
|
|
/// <summary>
|
/// 库区a=1-2-3 独占 库区a的 123排
|
/// </summary>
|
public string S_ROW { get; set; }
|
|
/// <summary>
|
/// 同 s_row , 瓶坯的入库库区排， 瓶坯翻斗机的出库库区排
|
/// </summary>
|
public string S_ROW1 { get; set; }
|
/// <summary>
|
/// Y S_ROW 不足时按正常逻辑 N 等待。
|
/// </summary>
|
public string S_Is_Auto { get; set; }
|
/// 是 或 （） <summary>
|
//[SugarColumn(IsIgnore = true)]
|
public string FromFuLe { get; set; }
|
|
|
/// <summary>
|
/// 产线关联工单号。
|
/// </summary>
|
[SugarColumn(IsIgnore = !TaskProcess.UPFule)]
|
public string Sign { get; set; }
|
|
[SugarColumn(IsIgnore = true)]
|
public int pcnumusing
|
{
|
get
|
{
|
int q = 0;
|
int.TryParse(SQL_PCNumber_using?.Split('.')[0], out q);
|
return q;
|
}
|
}
|
[SugarColumn(IsIgnore = true)]
|
public int pcnum
|
{
|
get
|
{
|
int q = 0;
|
int.TryParse(SQL_PCNumber?.Split('.')[0], out q);
|
return q;
|
}
|
}
|
[SugarColumn(IsIgnore = true)]
|
public int current
|
{
|
get
|
{
|
int q = 0;
|
int.TryParse(SQL_Current?.Split('.')[0], out q);
|
return q;
|
}
|
}
|
}
|
//[SuGG("自动移库工单表")]
|
//public class AutoTurnWorkOrder : BaseModel
|
//{
|
|
//}
|
|
[SuGG("富勒托盘下发")]
|
public class FuLeTrayCode : BaseModel
|
{
|
public string deviceName { get; set; }
|
public string workNo { get; set; }
|
public string trayCode { get; set; }
|
public string trayNum { get; set; }
|
public string dateTime { get; set; }
|
public string batchNo { get; set; }
|
public string trayRule { get; set; }
|
public string itemLayer { get; set; }
|
public string SQL_State { get; set; } = "下发";
|
}
|
|
/// <summary>
|
/// 原物料纸箱转运移库。
|
/// </summary>
|
[SuGG("库库转运")]
|
public class YWLZXtake : BaseModel
|
{
|
public string SQL_WorkNo { get; set; }
|
public string S_START_AREA { get; set; }
|
public int N_START_ROW { get; set; }
|
public int N_END_ROW { get; set; }
|
public string S_ZZ_AREA { get; set; }
|
public string S_END_AREA { get; set; }
|
public string S_ZX_STATE { get; set; }
|
|
/// <summary>
|
/// 编码 名称 厂家， 本来不需要， 为了ab区不足时，触发转运。 防止重复物料单据
|
/// </summary>
|
public string S_ITEM_CODE { get; set; }
|
public string S_ITEM_NAME { get; set; }
|
/// <summary>
|
/// 厂家
|
/// </summary>
|
public string S_CJ_NAME { get; set; }
|
|
}
|
|
[SuGG("移库工单表")]
|
public class TurnWorkOrder : BaseModel
|
{
|
/// <summary>
|
/// 来源单号。 单据单号。 - 比如 由
|
/// </summary>
|
public string FROM_NO { set; get; }
|
///工单号
|
public string SQL_WorkNo { get; set; }
|
/// <summary>
|
/// 手动移库
|
/// 自动移库
|
/// </summary>
|
public string Turn_Type { get; set; } = "手动移库";
|
/// <summary>
|
/// 产线号。
|
/// </summary>
|
public string LineNo { get; set; }
|
/// <summary>
|
/// 起点库区
|
/// </summary>
|
public string start_area { get; set; }
|
/// <summary>
|
/// 起点排
|
/// </summary>
|
public string start_row { get; set; }
|
///终点库区
|
public string end_area { get; set; }
|
/// <summary>
|
/// 终点排
|
/// </summary>
|
public string end_row { get; set; }
|
/// <summary>
|
/// 工单状态
|
/// </summary>
|
public string SQL_State { get; set; }
|
/// <summary>
|
/// 优先级
|
/// </summary>
|
public int priority { get; set; } = 60;
|
/// <summary>
|
/// 大 小板 集化板
|
/// </summary>
|
public string size { get; set; }
|
|
//[SugarColumn(ColumnName = "note")]
|
public string Note { get; set; }
|
|
/// <summary>
|
/// 指定 移库的数量
|
/// </summary>
|
public int TrayCount { get; set; } = 0;
|
/// <summary>
|
/// 已经移库数量
|
/// </summary>
|
public int AlQty { get; set; } = 0;
|
}
|
|
[SuGG("备货单表")]
|
public class OutOrder : BaseModel
|
{
|
/// <summary>
|
/// 出库单号，或者自定义。 必须的
|
/// </summary>
|
public string S_Work_NO { get; set; }
|
public string S_ITEM_CODE { get; set; }
|
public string S_ITEM_NAME { get; set; }
|
|
public string S_Strart_Area { get; set; }
|
public string S_Strart_Row { get; set; }
|
public string S_END_ROW { get; set; }
|
|
|
/// <summary>
|
/// 库区｛=排-排｝
|
/// </summary>
|
public string S_END_AREA { get; set; }
|
public string S_NOTE { get; set; }
|
/// <summary>
|
/// 执行时的唯一标识。 记录到 移库单号里。 用来FFROMNO 关联 来标记完成的依据
|
/// </summary>
|
public string S_bsID { get; set; } = string.Empty;
|
/// <summary>
|
/// 出库数量
|
/// </summary>
|
public int N_Stock { get; set; } = 0;
|
public string S_Work_State { get; set; } = "新建";
|
}
|
|
[SuGG("任务类型转换表")]
|
public class TaskTypeConvTable : BaseModel
|
{
|
/// <summary>
|
/// 内部任务名称
|
/// </summary>
|
public string taskTypeName { get; set; }
|
/// <summary>
|
/// 对应的富勒编码
|
/// </summary>
|
public string taskType { get; set; }
|
}
|
|
[SuGG("AGV设备信息")]
|
public class AGVDeviceDataTable : BaseModel
|
{
|
/// <summary>
|
/// 车辆类型
|
/// </summary>
|
public string equipmentType { get; set; }
|
/// <summary>
|
/// 车辆型号
|
/// </summary>
|
public string equipmentMold { get; set; }
|
/// <summary>
|
/// 车辆铭牌号
|
/// </summary>
|
public string equipmentCode { get; set; }
|
/// <summary>
|
/// 车辆区域
|
/// </summary>
|
public string equipmentArea { get; set; }
|
/// <summary>
|
/// 对应工厂编号
|
/// </summary>
|
public string orgCode { get; set; }
|
/// <summary>
|
/// 车辆投放状态
|
/// </summary>
|
public string equipmentStatus { get; set; }
|
/// <summary>
|
/// 唯一标识码
|
/// </summary>
|
public string proxyInterfaceCode { get; set; }
|
/// <summary>
|
/// 工厂名称
|
/// </summary>
|
public string orgName { get; set; }
|
/// <summary>
|
/// 车辆编码
|
/// </summary>
|
public string equipmentNo { get; set; }
|
}
|
|
|
|
[SuGG("任务切面表")]
|
public class TaskAudio
|
{
|
/// <summary>
|
/// 产线号
|
/// </summary>
|
public string S_PlineNo { get; set; }
|
|
/// <summary>
|
/// 目标区域
|
/// </summary>
|
public string S_Area { get; set; }
|
|
/// <summary>
|
/// 目标排
|
/// </summary>
|
public int N_ROW { get; set; }
|
|
/// <summary>
|
/// 目标货位
|
/// </summary>
|
public string S_LOC_CODE { get; set; }
|
|
/// <summary>
|
/// 0 新建
|
/// 1 同意
|
/// 2 拒绝
|
/// 3 废弃 - 界面不要显示3的数据
|
/// </summary>
|
public int N_AUDIO { get; set; }
|
|
public DateTime CreateTime { get; set; }
|
|
/// <summary>
|
/// 记录数据。字段要varchar 要长。 在变更状态时， 按照（;时间-状态;）格式追加
|
/// </summary>
|
public string S_Note { get; set; }
|
}
|
|
[SuGG("领料单表")]
|
public class LingOrder : BaseModel
|
{
|
public string WorkNo { get; set; }
|
public string State { get; set; } = "执行";
|
}
|
|
|
[SuGG("领料单子表")]
|
public class LingItemOrder : BaseModel
|
{
|
public string WorkNo { get; set; }
|
public string WorkFromNo { get; set; }
|
public string ItemCode { get; set; }
|
public string OutAreaNum { get; set; }
|
[SugarColumn(IsIgnore = true)]
|
public int AreaNum
|
{
|
get
|
{
|
int q = 0;
|
int.TryParse(OutAreaNum?.Split('.')[0], out q);
|
return q;
|
}
|
}
|
public string DeviceNo { get; set; }
|
public string OutCurrentNum { get; set; } = "0";
|
public int AllocQTY { get; set; } = 0;
|
[SugarColumn(IsIgnore = true)]
|
public int current
|
{
|
get
|
{
|
int q = 0;
|
int.TryParse(OutCurrentNum?.Split('.')[0], out q);
|
return q;
|
}
|
}
|
public string State { get; set; } = "执行";
|
}
|
|
}
|
