| | |
| | | using System; |
| | | using System.Collections.Generic; |
| | | using System.Linq; |
| | | using System.Net; |
| | | using System.Net.Sockets; |
| | | using System.Text; |
| | | using System.Threading.Tasks; |
| | | |
| | |
| | | using HH.WCS.Mobox3.DSZSH.wms; |
| | | |
| | | using Newtonsoft.Json; |
| | | |
| | | using Swashbuckle.Swagger; |
| | | |
| | | using static HH.WCS.Mobox3.DSZSH.api.ApiModel; |
| | | |
| | |
| | | WCSHelper.UpdateStatus(TN_Task, "取货完成"); // 任务状态改成取货完成 |
| | | TaskProcess.OperateStatus(TN_Task, 4); // 起点容器货位解绑,解锁起点 |
| | | |
| | | if (TN_Task.S_TYPE == TaskName.C成品胶出库) { |
| | | if (TN_Task.S_TYPE == ETask.C成品胶出库.Name()) { |
| | | var nextOutboundTask = Task.Run(() => { |
| | | UpdateOutboundTaskState(3); |
| | | }); |
| | |
| | | var cgDetail = new TN_CG_Detail(); // 如果没有信息,默认就是空值,可以直接填入,不需要判断 |
| | | |
| | | //var emptyTask = false; // 空托/空箱任务 |
| | | if (task.S_TYPE != TaskName.H好运箱_空箱上线 && task.S_TYPE != TaskName.H好运箱_空箱入库 && |
| | | task.S_TYPE != TaskName.T托盘_空托上线 && task.S_TYPE != TaskName.T托盘_空托入库) { |
| | | if (task.S_TYPE != ETask.K空托上线出库.Name() && task.S_TYPE != ETask.K空托入库.Name() && |
| | | task.S_TYPE != ETask.K空箱上线出库.Name() && task.S_TYPE != ETask.K空箱入库.Name()) { |
| | | // 非空托/空箱任务(空托/空箱任务无法在CGDetail查到物料信息) |
| | | //emptyTask= true; |
| | | cgDetail = db.Queryable<TN_CG_Detail>() |
| | |
| | | |
| | | var isInbound = false; // 入库类型的任务(包括移库类任务) |
| | | var inboundTasks = new List<string> { |
| | | TaskName.H好运箱_满箱下线入库, TaskName.H好运箱_空箱入库, TaskName.T托盘_满托下线入库, TaskName.T托盘_空托入库, |
| | | TaskName.C抽检_合格回库, TaskName.C抽检_不合格移库, TaskName.Y移库 |
| | | ETask.M满托下线入库.Name(), ETask.K空箱入库.Name(), ETask.M满托下线入库.Name(), ETask.K空托入库.Name(), |
| | | ETask.C抽检合格回库.Name(), ETask.C抽检不合格移库.Name(), ETask.Y移库.Name() |
| | | }; |
| | | if (inboundTasks.Contains(task.S_TYPE)) { |
| | | isInbound= true; |
| | |
| | | try { |
| | | ModbusHelper.Relink(); |
| | | |
| | | //var loc = db.Queryable<TN_Location>() |
| | | // .Where(l => l.S_AGV_SITE == model.station_name && Settings.AreaMap[AreaName.包装区].Contains(l.S_AREA_CODE)) |
| | | // .First(); |
| | | var BZQ = Settings.GetTaskInfo(ETask.M满托下线入库).StartAreas; |
| | | var loc = db.Queryable<TN_Location>() |
| | | .Where(l => BZQ.Contains(l.S_AREA_CODE) && l.S_AGV_SITE == model.station_name).First(); |
| | | |
| | | if (!Settings.AgvSite_ProdLineCodeMap.TryGetValue(model.station_name, out int prodIndex)) { |
| | | if (loc == null) { |
| | | info = $"AGV 站点{model.station_name}不是合法的产线接驳位站点"; |
| | | LogHelper.Info(info); |
| | | return NewReturnResult(1, info); |
| | | } |
| | | |
| | | if (!Settings.LocProdIdMap.TryGetValue(loc.S_CODE, out var prodIndex)) { |
| | | info = $"AGV 站点{model.station_name}不是合法的产线接驳位站点"; |
| | | LogHelper.Info(info); |
| | | return NewReturnResult(1, info); |
| | |
| | | } |
| | | |
| | | public static void UpdateOutboundTaskState(int spotStateCode) { |
| | | var taskName = TaskName.C成品胶出库; |
| | | var taskName = ETask.C成品胶出库.Name(); |
| | | var db = new SqlHelper<object>().GetInstance(); |
| | | |
| | | var detail = db.Queryable<TN_Outbound_Detail>() |
| | |
| | | if (list.Count > 0) { |
| | | list.ForEach(task => { |
| | | //使用自定义任务推送 |
| | | TaskProcess.SendTask(task);//调度NDC或杭奥或国自设备 |
| | | //TaskProcess.SendTask(task);//调度NDC或杭奥或国自设备 |
| | | TaskProcess.SendNDCTask(task); |
| | | }); |
| | | } |
| | | else { |
| | | LogHelper.Info("暂无任务"); |
| | | } |
| | | } |
| | | |
| | | // TCP 非轮询方式 模拟产线下线的尝试 |
| | | |
| | | public static void StartServer() { |
| | | var ListenPort = 6000; |
| | | TcpListener listener = new TcpListener(IPAddress.Any, ListenPort); |
| | | listener.Start(); |
| | | Console.WriteLine($"后台服务已启动,监听端口 {ListenPort}..."); |
| | | |
| | | while (true) { |
| | | try { |
| | | // 接受产线连接 |
| | | System.Net.Sockets.TcpClient client = listener.AcceptTcpClient(); |
| | | Console.WriteLine($"产线客户端已连接: {client.Client.RemoteEndPoint}"); |
| | | |
| | | // 处理客户端请求(使用Task避免阻塞主线程) |
| | | Task.Run(() => HandleClientRequest(client)); |
| | | } |
| | | catch (Exception ex) { |
| | | Console.WriteLine($"服务端异常: {ex.Message}"); |
| | | } |
| | | } |
| | | } |
| | | |
| | | public static void HandleClientRequest(System.Net.Sockets.TcpClient client) { |
| | | var db = new SqlHelper<object>().GetInstance(); |
| | | using (client) |
| | | using (NetworkStream stream = client.GetStream()) { |
| | | try { |
| | | // 读取产线消息 |
| | | byte[] buffer = new byte[1024]; |
| | | int bytesRead = stream.Read(buffer, 0, buffer.Length); |
| | | string jsonMessage = Encoding.UTF8.GetString(buffer, 0, bytesRead); |
| | | |
| | | // 解析消息 |
| | | var message = JsonConvert.DeserializeObject<ProductCompletedMessage>(jsonMessage); |
| | | //Console.WriteLine($"收到产品完成通知 - 物料:{message.ItemCode};批次号:{message.BatchNo};容器号:{message.CntrCode}"); |
| | | LogHelper.Info($"收到产品下线通知:"+message); |
| | | |
| | | string startLocCode = ""; |
| | | |
| | | // A. 如果是单个产线PLC,通过TCP传播,需要传递产线ID,根据ID计算起点货位 |
| | | //startLocCode = Settings.ProductionLines[message.Id].OffLoc[0]; // 理论上应该只有1个OffLoc,否则应该注明是哪一个 |
| | | |
| | | // B. 如果是每条产线各一个客户端,更简单,直接根据IP地址确定终点货位 |
| | | // TODO 具体逻辑待后续确定时补完 |
| | | |
| | | var success = CreateInboundTask(startLocCode, message.CntrCode).Value; |
| | | |
| | | // 发送响应 |
| | | string response = success ? "ACK: 机器人已调度" : "NAK: 调度失败"; |
| | | byte[] responseData = Encoding.UTF8.GetBytes(response); |
| | | stream.Write(responseData, 0, responseData.Length); |
| | | } |
| | | catch (Exception ex) { |
| | | Console.WriteLine($"处理客户端请求异常: {ex.Message}"); |
| | | } |
| | | } |
| | | } |
| | | |
| | | /// <summary> |
| | | /// 入库作业创建只接收起点货位和容器号(物料信息待定、通过产线号计算起点的逻辑放在方法外) |
| | | /// </summary> |
| | | /// <param name="startLocCode"></param> |
| | | /// <param name="cntrCode"></param> |
| | | /// <returns></returns> |
| | | public static Result<bool> CreateInboundTask(string startLocCode, string cntrCode) { |
| | | var db = new SqlHelper<object>().GetInstance(); |
| | | var info = ""; |
| | | |
| | | var taskInfo = Settings.GetTaskInfo(ETask.M满托下线入库); |
| | | var taskName = taskInfo.TaskName; |
| | | var startAreas = taskInfo.StartAreas; |
| | | var endAreas = taskInfo.EndAreas; |
| | | const string cntrType = "托盘"; |
| | | |
| | | try { |
| | | var startLoc = db.Queryable<TN_Location>() |
| | | .Where(l => l.S_CODE == startLocCode) |
| | | .Where(l => startAreas.Contains(l.S_AREA_CODE)) |
| | | .Where(l => l.N_LOCK_STATE == 0 && l.S_LOCK_STATE == "无" && l.C_ENABLE == "Y") |
| | | //.Where(l => l.N_CURRENT_NUM == 0) // 绑定前 |
| | | .First(); |
| | | |
| | | if (startLoc == null) { |
| | | info = $"没有找到起点货位'{startLocCode}',或不满足要求:未上锁、当前容器数量=0"; |
| | | LogHelper.Info(info); |
| | | return new Result<bool>(false, info); |
| | | } |
| | | |
| | | var locCntrRelOld = db.Queryable<TN_Loc_Container>() |
| | | .Where(c => c.S_CNTR_CODE == cntrCode).First(); |
| | | |
| | | // 绑定货位和容器号 |
| | | var locCntrRel = new TN_Loc_Container { |
| | | S_LOC_CODE = startLocCode, |
| | | S_CNTR_CODE = cntrCode, |
| | | S_CNTR_TYPE = cntrType, |
| | | }; |
| | | |
| | | startLoc.N_CURRENT_NUM = 1; // 绑定后 |
| | | |
| | | var endLoc = db.Queryable<TN_Location>() |
| | | .Where(a => endAreas.Contains(a.S_AREA_CODE)) |
| | | .Where(a => a.N_LOCK_STATE == 0 && a.S_LOCK_STATE == "无" && a.C_ENABLE == "Y") // 筛选:未上锁 |
| | | .Where(a => a.N_CURRENT_NUM == 0) // 筛选:空货位 |
| | | .OrderBy(l => l.N_LAYER) |
| | | .First(); |
| | | |
| | | if (endLoc == null) { |
| | | info = $"没有找到合适的【终点货位】,需要满足要求:未上锁、当前容器数量=0"; |
| | | LogHelper.Info(info); |
| | | return new Result<bool>(false, info); |
| | | } |
| | | |
| | | var cntId = locCntrRel.S_CNTR_CODE; |
| | | var task = WCSHelper.BuildTask(startLoc, endLoc, cntId, taskName); |
| | | |
| | | LocationHelper.LockStartLoc(ref startLoc); // 起点出库锁 |
| | | LocationHelper.LockEndLoc(ref endLoc); // 终点入库锁 |
| | | |
| | | using (var tran = db.Ado.UseTran()) { |
| | | if (locCntrRelOld != null) { |
| | | if (db.Deleteable<TN_Loc_Container>(locCntrRelOld).ExecuteCommand() <= 0 && |
| | | db.Updateable<TN_Location>().SetColumns(l => l.N_CURRENT_NUM == 0).Where(l => l.S_CODE == locCntrRelOld.S_LOC_CODE).ExecuteCommand() <= 0) { |
| | | tran.RollbackTran(); |
| | | info = $"删除旧货位容器关系表失败:货位编码{locCntrRelOld.S_LOC_CODE},容器编码{locCntrRelOld.S_CNTR_CODE}"; |
| | | LogHelper.Info(info); |
| | | return new Result<bool>(false, info); |
| | | } |
| | | } |
| | | |
| | | if (db.Insertable<TN_Loc_Container>(locCntrRel).ExecuteCommand() <= 0) { |
| | | tran.RollbackTran(); |
| | | info = $"插入货位容器关系表失败:货位编码{locCntrRel.S_LOC_CODE},容器编码{locCntrRel.S_CNTR_CODE}"; |
| | | LogHelper.Info(info); |
| | | return new Result<bool>(false, info); |
| | | } |
| | | |
| | | if (db.Updateable<TN_Location>(startLoc).UpdateColumns(it => new { |
| | | it.N_LOCK_STATE, |
| | | it.S_LOCK_STATE, |
| | | it.S_LOCK_OP, |
| | | it.T_MODIFY, |
| | | it.N_CURRENT_NUM, // 起点货位绑定后,将货位状态更新 |
| | | }).ExecuteCommand() <= 0) { |
| | | tran.RollbackTran(); |
| | | info = $"生成任务'{taskName}'失败:更新起点货位{startLoc.S_CODE}锁状态失败"; |
| | | LogHelper.Info(info); |
| | | return new Result<bool>(false, info); |
| | | } |
| | | |
| | | if (db.Updateable<TN_Location>(endLoc).UpdateColumns(it => new { |
| | | it.N_LOCK_STATE, |
| | | it.S_LOCK_STATE, |
| | | it.S_LOCK_OP, |
| | | it.T_MODIFY, |
| | | }).ExecuteCommand() <= 0) { |
| | | tran.RollbackTran(); |
| | | info = $"生成任务'{taskName}'失败:更新终点货位{endLoc.S_CODE}锁状态失败"; |
| | | LogHelper.Info(info); |
| | | return new Result<bool>(false, info); |
| | | } |
| | | |
| | | if (db.Insertable<TN_Task>(task).ExecuteCommand() <= 0) { |
| | | tran.RollbackTran(); |
| | | info = $"生成任务'{taskName}'失败,任务号={task.S_CODE},容器号={cntId},起点={startLoc.S_CODE},终点={endLoc.S_CODE}"; |
| | | LogHelper.Info(info); |
| | | return new Result<bool>(false, info); |
| | | } |
| | | |
| | | tran.CommitTran(); |
| | | info = $"生成任务'{taskName}'成功,任务号={task.S_CODE},容器号={cntId},起点={startLoc.S_CODE},终点={endLoc.S_CODE}"; |
| | | LogHelper.Info(info); |
| | | return new Result<bool>(true, info); |
| | | } |
| | | } |
| | | catch (Exception ex) { |
| | | LogHelper.InfoEx(ex); |
| | | return new Result<bool>(false, ex.Message); |
| | | } |
| | | } |
| | | |
| | | } |
| | | |
| | | public class ProductCompletedMessage { |
| | | public int Id { get; set; } |
| | | //public string ItemCode { get; set; } |
| | | //public string BatchNo { get; set; } |
| | | public string CntrCode { get; set; } |
| | | } |
| | | |
| | | public class Result<T> { |
| | | public T Value { get; set; } |
| | | public string Content { get; set; } |
| | | |
| | | public Result(T value, string content) { |
| | | Value = value; |
| | | Content = content; |
| | | } |
| | | } |
| | | } |