using SqlSugar;
|
using System;
|
using System.Collections.Generic;
|
|
using Hanhe.iWCS.Common;
|
|
namespace Hanhe.iWCS.TaizhouGEMTwoProtocol
|
{
|
public class MoboxHelper
|
{
|
static MoboxHelper() {
|
}
|
|
/// <summary>
|
/// 获取数据
|
/// </summary>
|
/// <param name="lineNo"></param>
|
/// <returns></returns>
|
public WorkOrder GetWorkOrder(string lineNo) {
|
var order = new SqlHelper<WorkOrder>().Get(a => a.SQL_PLineNo == lineNo && (a.SQL_State == "执行中" || a.SQL_State == "已完成"), a => a.T_CREATE);
|
if (order == null) Console.WriteLine($"SQLSERVER Error:未获取到当前条件的相关数据！当前查询条件：{lineNo}");
|
return order;
|
}
|
/// <summary>
|
/// 插入数据
|
/// </summary>
|
/// <param name="orderno"></param>
|
/// <returns></returns>
|
public bool AddNewData(string data)
|
{
|
var result = false;
|
new SqlHelper<WorkOrder>().ExecuteSql($"insert into dbo.TN_0004(S_ID,SQL_PLineNo) Values('{Guid.NewGuid()}','33333')");
|
return result;
|
}
|
/// <summary>
|
/// 更新车号
|
/// </summary>
|
/// <param name="taskNo"></param>
|
/// <param name="endBit"></param>
|
public static bool UpdateEndBit(string taskNo, string agvNo)
|
{
|
var result = false;
|
try
|
{
|
CMMLog.Info($"SQLServer 更新任务车号：任务号：{taskNo},更改车号：{agvNo}");
|
result = new SqlHelper<SQL_TN_I_TASK_MST>().ExecuteSql($"update dbo.tn_am_task_mst set CN_N_AGV_NO='{agvNo}' where CN_S_TASK_NO='{taskNo}'");
|
}
|
catch(Exception ex)
|
{
|
CMMLog.Error($"SQLServer 更新任务车号异常：{ex.Message}");
|
}
|
|
return result;
|
}
|
|
public static bool UpdateTaskState(string taskNo, int state)
|
{
|
var result = false;
|
try
|
{
|
string taskState = state == 3 ? "开始取货" : state == 4 ? "取货完成" : state == 5 ? "开始卸货" : state == 6 ? "卸货完成" : state == 2 ? "完成" : "";
|
CMMLog.Info($"SQLServer 更新任务状态：任务号：{taskNo},更改状态：{taskState}");
|
if (!string.IsNullOrEmpty(taskState)) result = new SqlHelper<SQL_TN_I_TASK_MST>().ExecuteSql($"update dbo.tn_am_task_mst set CN_S_STATUS='{taskState}' where CN_S_TASK_NO='{taskNo}'");
|
}
|
catch (Exception ex)
|
{
|
CMMLog.Error($"SQLServer 更新任务状态异常：{ex.Message}");
|
}
|
|
return result;
|
}
|
|
/// <summary>
|
/// 删除数据
|
/// </summary>
|
/// <param name="orderno"></param>
|
/// <returns></returns>
|
public bool DelData(string orderno)
|
{
|
var result = false;
|
new SqlHelper<WorkOrder>().ExecuteSql($"delete dbo.TN_0004 where SQL_PLineNo='2222222'");
|
return result;
|
}
|
|
public static void AddRecordNew(WorkOrder record)
|
{
|
var helper = new SqlHelper<WorkOrder>();
|
var old = helper.Get(a => a.SQL_PLineNo == record.SQL_PLineNo);
|
if (old != null)
|
{
|
helper.Deleteable(a => a.SQL_PLineNo == record.SQL_PLineNo);
|
helper.Insert(record);
|
}
|
else
|
{
|
//更新数据
|
//if (old != null)
|
//{
|
// old.TransportStatus = record.TransportStatus;
|
// old.HasBeenReceived = record.HasBeenReceived;
|
// var cols = new List<string>() { "TransportStatus", "HasBeenReceived" };
|
// if (record.TransportStatus == 2)
|
// {
|
// cols.Add("ExecutionTime");
|
// old.ExecutionTime = record.ExecutionTime;
|
// }
|
// if (record.TransportStatus == 4 || record.TransportStatus == 12 || record.TransportStatus == 13 || record.TransportStatus == 6)
|
// {
|
// cols.Add("CompleteTime");
|
// old.CompleteTime = record.CompleteTime;
|
// }
|
// if (!string.IsNullOrEmpty(record.AgvNo))
|
// {
|
// cols.Add("AgvNo");
|
// old.AgvNo = record.AgvNo;
|
// }
|
// helper.Update(old, cols.ToArray());
|
//}
|
}
|
}
|
|
/// <summary>
|
/// 工单表
|
/// 梅坪现场工单表名："dbo.TN_0001"
|
/// 模拟测试工单表名："dbo.TN_0004"
|
/// </summary>
|
[SugarTable("dbo.TN_0004")]
|
public class WorkOrder
|
{
|
public string S_ID { get; set; } = "";
|
public string S_STATE { get; set; } = "";
|
public string S_CREATOR_ID { get; set; } = "";
|
public string S_CREATOR_NAME { get; set; } = "";
|
public DateTime T_CREATE { get; set; } = DateTime.MinValue;
|
public string S_DEPART_ID { get; set; } = "";
|
public string S_DEPART_NAME { get; set; } = "";
|
public string S_MODIFIER_ID { get; set; } = "";
|
public string S_MODIFIER_NAME { get; set; } = "";
|
public DateTime T_MODIFY { get; set; } = DateTime.MinValue;
|
public int N_CREATEMETHOD { get; set; } = 0;
|
public string G_SOURCE_OBJ { get; set; } = "";
|
/// <summary>
|
/// 工单号
|
/// </summary>
|
public string SQL_WorkNo { get; set; } = "";
|
/// <summary>
|
/// 产线号
|
/// </summary>
|
public string SQL_PLineNo { get; set; } = "";
|
/// <summary>
|
/// 即产即用
|
/// </summary>
|
public string SQL_UsingNo { get; set; } = "";
|
/// <summary>
|
/// 工单类型
|
/// </summary>
|
public string SQL_ORDER_TYPE { get; set; } = "";
|
/// <summary>
|
/// 工单状态
|
/// </summary>
|
public string SQL_State { get; set; } = "";
|
/// <summary>
|
/// 批次号
|
/// </summary>
|
public string SQL_BatchNo { get; set; } = "";
|
/// <summary>
|
/// 物料编码
|
/// </summary>
|
public string SQL_ItemCode { get; set; } = "";
|
/// <summary>
|
/// 物料名称
|
/// </summary>
|
public string SQL_ItemName { get; set; } = "";
|
/// <summary>
|
/// 总数
|
/// </summary>
|
public string SQL_Total { get; set; } = "";
|
/// <summary>
|
/// 库区或者列或者排编号
|
/// </summary>
|
public string SQL_Area { get; set; } = "";
|
/// <summary>
|
/// 固定每批运输数量
|
/// </summary>
|
public string SQL_PCNumber { get; set; } = "";
|
/// <summary>
|
/// 计数（已执行数量）
|
/// </summary>
|
public string SQL_Current { get; set; } = "";
|
/// <summary>
|
/// 当前工单执行时间
|
/// </summary>
|
public string SQL_Modify { get; set; } = "";
|
/// <summary>
|
/// 当前工单结束时间
|
/// </summary>
|
public string SQL_PLAN_END { get; set; } = "";
|
/// <summary>
|
/// 连接产线号
|
/// </summary>
|
public string SQL_LinkLineNO { get; set; } = "";
|
/// <summary>
|
/// 是否栈板
|
/// </summary>
|
public string SQL_PaperBox { get; set; } = "";
|
}
|
/// <summary>
|
/// SQL-AMS任务主表
|
/// </summary>
|
[SugarTable("dbo.tn_am_task_mst")]
|
public class SQL_TN_I_TASK_MST
|
{
|
public string CN_S_BATCH_NO { get; set; }
|
public int CN_S_ORDER_NO { get; set; }
|
public string CN_S_TASK_NO { get; set; }
|
public string CN_S_SOURCE_SYS { get; set; }
|
public string CN_S_SOURCE_NO { get; set; }
|
public string CN_S_PROCESS_CODE { get; set; }
|
public string CN_S_TASK_TYPE { get; set; }
|
public string CN_S_START_AREA { get; set; }
|
public string CN_S_START_AREA_NAME { get; set; }
|
public string CN_S_START_BIT { get; set; }
|
public int CN_N_START_AGVBIT { get; set; }
|
public string CN_S_END_AREA { get; set; }
|
public string CN_S_END_AREA_NAME { get; set; }
|
public string CN_S_END_BIT { get; set; }
|
public int CN_N_END_AGVBIT { get; set; }
|
public string CN_S_STATUS { get; set; }
|
public string CN_S_BEF_STATUS { get; set; }
|
public string CN_S_BEFORE_NO { get; set; }
|
public string CN_S_AFTER_NO { get; set; }
|
public string CN_T_START_WORKING { get; set; }
|
public string CN_T_END_WORKING { get; set; }
|
public int CN_N_PRIORITY { get; set; }
|
public int CN_N_CUR_STEP { get; set; }
|
public string CN_S_CREATOR { get; set; }
|
public string CN_S_CREATOR_NAME { get; set; }
|
public string CN_T_CREATE { get; set; }
|
public string CN_S_MENDER { get; set; }
|
public string CN_S_MODIFY_NAME { get; set; }
|
public string CN_T_MODIFY { get; set; }
|
public string CN_S_TASK_MODEL { get; set; }
|
public string CN_S_EXT1 { get; set; }
|
public string CN_S_EXT2 { get; set; }
|
public string CN_S_EXT3 { get; set; }
|
public string CN_N_AGV_NO { get; set; }
|
public string CN_S_TRANSPORT_INFO { get; set; }
|
}
|
|
/// <summary>
|
/// SQL-MOBOX任务主表
|
/// </summary>
|
[SugarTable("dbo.TN_0001")]
|
public class Mobox_MST_TASK
|
{
|
public string S_ID { get; set; }//g
|
public string S_STATE { get; set; }
|
public string S_CREATOR_ID { get; set; }
|
public string S_CREATOR_NAME { get; set; }
|
public DateTime T_CREATE { get; set; }
|
public string S_DEPART_ID { get; set; }//g
|
public string S_DEPART_NAME { get; set; }
|
public string S_MODIFIER_ID { get; set; }
|
public string S_MODIFIER_NAME { get; set; }
|
public DateTime T_MODIFY { get; set; }
|
public int N_CREATEMETHOD { get; set; }
|
public string G_SOURCE_OBJ { get; set; }//g
|
|
|
public string CN_S_BATCH_NO { get; set; }
|
public string CN_S_TASK_NO { get; set; }
|
public string CN_S_SOURCE_NO { get; set; }
|
public string CN_S_START_BIT { get; set; }
|
public string CN_S_END_BIT { get; set; }
|
public string CN_S_STATUS { get; set; }
|
public int CN_N_PRIORITY { get; set; }
|
public string CN_T_MODIFY { get; set; }
|
}
|
|
|
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>
|
/// 设备报警信息表
|
/// </summary>
|
[SugarTable("dbo.TN_0081")]
|
public class CallWcsWarningTable : BaseModel
|
{
|
/// <summary>
|
/// 请求编号，每个请求都要一个唯一编号， 同一个请求重复提交， 使用同一编号。由上层系统提供
|
/// </summary>
|
public string requestPK { get; set; }
|
/// <summary>
|
/// 故障代码
|
/// </summary>
|
public string errorNO { get; set; }
|
/// <summary>
|
/// 故障描述
|
/// </summary>
|
public string errorDes { get; set; }
|
/// <summary>
|
/// 任务编码
|
/// </summary>
|
public string taskCode { get; set; }
|
/// <summary>
|
/// 设备编码
|
/// </summary>
|
public string dvcNo { get; set; }
|
/// <summary>
|
/// 操作人
|
/// </summary>
|
public string @operator { get; set; }
|
/// <summary>
|
/// 操作时间
|
/// </summary>
|
public DateTime operationTime { get; set; }
|
}
|
|
/// <summary>
|
/// 海康报警信息表
|
/// </summary>
|
[SugarTable("dbo.TN_0082")]
|
public class WarnCallbackTable : BaseModel
|
{
|
/// <summary>
|
/// 请求编号，每个请求都要一个唯一编号，同一个请求重复提交，使用同一编号。
|
/// </summary>
|
public string reqCode { get; set; }
|
/// <summary>
|
/// 请求时间戳，格式: “yyyy-MM-dd HH:mm:ss”。
|
/// </summary>
|
public string reqTime { get; set; }
|
/// <summary>
|
/// 客户端编号，如 PDA，HCWMS 等。
|
/// </summary>
|
public string clientCode { get; set; }
|
/// <summary>
|
/// 令牌号,由调度系统颁发。
|
/// </summary>
|
public string tokenCode { get; set; }
|
/// <summary>
|
/// 车号
|
/// </summary>
|
public string robotCode { get; set; }
|
/// <summary>
|
/// 告警开始时间
|
/// </summary>
|
public string beginTime { get; set; }
|
/// <summary>
|
/// 告警内容
|
/// </summary>
|
public string warnContent { get; set; }
|
/// <summary>
|
/// 任务号
|
/// </summary>
|
public string taskCode { get; set; }
|
}
|
}
|
}
|
