kazelee
2025-06-27 d20ce230b49932d39ee4ce25e39fd78368c3b28a
core/WCSCore.cs
@@ -1,6 +1,8 @@
using System;
using System.Collections.Generic;
using System.Linq;
using System.Net;
using System.Net.Sockets;
using System.Text;
using System.Threading.Tasks;
@@ -12,6 +14,8 @@
using HH.WCS.Mobox3.DSZSH.wms;
using Newtonsoft.Json;
using Swashbuckle.Swagger;
using static HH.WCS.Mobox3.DSZSH.api.ApiModel;
@@ -72,7 +76,7 @@
                    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);
                        });
@@ -124,8 +128,8 @@
                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>()
@@ -143,8 +147,8 @@
                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;
@@ -205,11 +209,17 @@
            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);
@@ -292,7 +302,7 @@
        }
        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>()
@@ -442,12 +452,213 @@
            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;
        }
    }
}