合肥佳通优化

lss

2025-06-04 c4bcf24d506bdcd2e2b78bca63f0fbf08c356a86

 HH.WCS.Mobox3/HH.WCS.Mobox3.JiaTong/wms/LocationHelper.cs

@@ -3,6 +3,7 @@
using NLog.Fluent;
using SqlSugar;
using System;
using System.Collections;
using System.Collections.Generic;
using System.Linq;
using System.Text;
@@ -37,7 +38,7 @@
                //初始化LocationExt加入到集合缓存
                LocationExts = new Dictionary<string, LocationExt>();
                var exts = GetAllLocExtList();
             //   LogHelper.Info($"获取货位扩展表信息：{JsonConvert.SerializeObject(exts)}");
                //   LogHelper.Info($"获取货位扩展表信息：{JsonConvert.SerializeObject(exts)}");
                if (exts.Count > 0)
                {
                    exts.ForEach(a =>
@@ -193,6 +194,13 @@
            return result;

        }
        // 定义等级顺序（从高到低）
        private static readonly List<string> LevelOrder = new List<string>
    {
        "A", "B", "C", "D", "E", "F", "G", "H", "I", "J",
        "K", "L", "M", "N", "O", "P", "Q", "R", "S", "T",
        "U", "V", "W", "X", "Y", "Z"
    };
        /// <summary>
        /// 根据物料找托盘
        /// </summary>
@@ -204,13 +212,27 @@
        {
            List<Location> locs;
            var db = new SqlHelper<object>().GetInstance();

            var queryable = db.Queryable<Location>()
                    .LeftJoin<LocCntrRel>((a, b) => a.S_CODE == b.S_LOC_CODE)
                    .LeftJoin<CntrItemDetail>((a, b, c) => b.S_CNTR_CODE == c.S_CNTR_CODE)
                    .Where((a, b, c) => a.N_CURRENT_NUM > 0 && a.N_LOCK_STATE == 0 && a.S_AREA_CODE == areaCode && c.S_ITEM_CODE == ItemCode);
      .LeftJoin<LocCntrRel>((a, b) => a.S_CODE == b.S_LOC_CODE)
      .LeftJoin<CntrItemDetail>((a, b, c) => b.S_CNTR_CODE == c.S_CNTR_CODE)
      .Where((a, b, c) => a.N_CURRENT_NUM > 0 && a.N_LOCK_STATE == 0 && a.S_AREA_CODE == areaCode);
            //六位码匹配前六位，其他的全部配置
            if (ItemCode.Trim().Length == 6)
            {
                queryable = queryable.Where((a, b, c) => c.S_ITEM_CODE.StartsWith(ItemCode));

           // LogHelper.Info($"GetLocByItemCode=>根据库区编码:{areaCode}，物料编码:{ItemCode},物料优先级，物料等级计算出有托盘货位{JsonConvert.SerializeObject(queryable.ToList())}");
            }
            else
            {
                queryable = queryable.Where((a, b, c) => c.S_ITEM_CODE == ItemCode);
            }
            //int targetIndex = LevelOrder.IndexOf(lev);
            //// 获取所有低于或等于目标等级的等级
            //var validLevels = LevelOrder
            //.Skip(targetIndex)  // 跳过高于目标等级的等级
            //.ToList();

            // LogHelper.Info($"GetLocByItemCode=>根据库区编码:{areaCode}，物料编码:{ItemCode},物料优先级:{lev}，物料等级计算出有托盘货位{JsonConvert.SerializeObject(queryable.ToList())}");
            //判断需不需要物料等级查找，并优先出库余料
            if (string.IsNullOrEmpty(lev))
            {
@@ -220,7 +242,7 @@
            {
                locs = queryable.Where((a, b, c) => c.LEV == lev && c.S_BS_TYPE == "余料").ToList();
            }
           // LogHelper.Info($"GetLocByItemCode=>查找余料,{JsonConvert.SerializeObject(locs)}");
            //   LogHelper.Info($"GetLocByItemCode=>查找余料,{JsonConvert.SerializeObject(locs)}");

            //没有余料则寻找全部物料
            if (locs.Count == 0)
@@ -228,7 +250,20 @@
                queryable = db.Queryable<Location>()
                    .LeftJoin<LocCntrRel>((a, b) => a.S_CODE == b.S_LOC_CODE)
                    .LeftJoin<CntrItemDetail>((a, b, c) => b.S_CNTR_CODE == c.S_CNTR_CODE)
                    .Where((a, b, c) => a.N_CURRENT_NUM > 0 && a.N_LOCK_STATE == 0 && a.S_AREA_CODE == areaCode && c.S_ITEM_CODE == ItemCode);
                    .Where((a, b, c) => a.N_CURRENT_NUM > 0 && a.N_LOCK_STATE == 0 && a.S_AREA_CODE == areaCode);
                //六位码匹配前六位，其他的全部配置
                if (ItemCode.Trim().Length == 6)
                {
                    queryable = queryable.Where((a, b, c) => c.S_ITEM_CODE.StartsWith(ItemCode));

                }
                else
                {
                    queryable = queryable.Where((a, b, c) => c.S_ITEM_CODE == ItemCode);
                }
                //   LogHelper.Info($"GetLocByItemCode=>无余料,查找全部{JsonConvert.SerializeObject(queryable.ToList())}");


                if (string.IsNullOrEmpty(lev))
                {
                    locs = queryable.ToList();
@@ -237,13 +272,60 @@
                {
                    locs = queryable.Where((a, b, c) => c.LEV == lev).ToList();
                }
               // LogHelper.Info($"GetLocByItemCode=>无余料,查找全部{JsonConvert.SerializeObject(locs)}");
                //  LogHelper.Info($"GetLocByItemCode=>无余料,查找全部{JsonConvert.SerializeObject(locs)}");
            }

            return locs;
        }

        /// <summary>
        /// 根据库区获取空托
        /// </summary>
        /// <param name="areaCode">库区编码</param>
        /// <returns></returns>
        internal static Location GetLocByAreacode(string areaCode)
        {
            Location loc = new Location();
            var db = new SqlHelper<object>().GetInstance();
            var query = db.Queryable<Location>()
       .LeftJoin<LocCntrRel>((a, b) => a.S_CODE == b.S_LOC_CODE)
       .LeftJoin<CntrItemDetail>((a, b, c) => b.S_CNTR_CODE == c.S_CNTR_CODE)
       .Where((a, b, c) => a.S_AREA_CODE == areaCode && a.N_CURRENT_NUM == 1
                       && a.N_LOCK_STATE == 0
                       && b.S_CNTR_CODE != null && c.S_ITEM_CODE == null
                       );
            loc = query.First();
            return loc;
        }

        /// <summary>
        /// 分配电梯货位
        /// </summary>
        /// <returns></returns>
        internal static Location GetElevatorLoc()
        {
            var db = new SqlHelper<object>().GetInstance();
            Location location = new Location();
            //查找全部电梯，分配任务最少的电梯
            var devices = Settings.deviceInfos.Where(a => a.deviceType == 2 && a.enable == 1).ToList();
            string[] state = new string[] { "执行中", "开始取货", "取货完成" };
            Dictionary<int, string> dics = new Dictionary<int, string>();
            foreach (var deviceInfo in devices)
            {
                int mst = db.Queryable<WCSTask>().Where(a => a.S_TYPE.Contains("电梯") && state.Contains(a.S_B_STATE)).Count();
                dics.Add(mst, deviceInfo.TN_Location);
            }
            if (dics.Count > 0)
            {
                var dic = dics.OrderBy(a => a.Key).First();
                location = db.Queryable<Location>().Where(a => a.S_CODE == dic.Value).First();
                if (location == null)
                {
                    LogHelper.Info($"根据货位编码:{dic.Value},未找到对应货位");
                }
            }
            return location;
        }
        /// <summary>
        /// 根据物料编码，仓库编码获取托盘数量
        /// </summary>
@@ -423,15 +505,15 @@
        }

        /// <summary>
        /// 根据货位集合获取 没有容器 没有锁的货位
        /// 根据货位获取货位信息
        /// </summary>
        /// <param name="loc"></param>
        /// <returns></returns>
        internal static List<Location> GetLocListEmptyFree(List<string> loc)
        internal static Location GetLocByLoc(string loc)
        {
            //1.0 查货位容器表
            var db = new SqlHelper<object>().GetInstance();
            var list = db.Queryable<Location>().Where(a => loc.Contains(a.S_CODE) && a.N_CURRENT_NUM == 0 && a.S_LOCK_STATE.Trim() == "无").ToList();
            var list = db.Queryable<Location>().Where(a => a.S_CODE.Trim() == loc).First();
            return list;

        }
@@ -546,7 +628,7 @@
                var lcrList = db.Queryable<LocCntrRel>().Where(a => a.S_LOC_CODE.Trim() == loc).ToList();
                location.S_LOCK_STATE = "无";
                location.N_LOCK_STATE = 0;
                db.Updateable(location).UpdateColumns(it => new {  it.S_LOCK_STATE, it.N_LOCK_STATE }).ExecuteCommand();
                db.Updateable(location).UpdateColumns(it => new { it.S_LOCK_STATE, it.N_LOCK_STATE }).ExecuteCommand();
                db.CommitTran();
                res = true;
            }