1

zxx

4 天以前 d66d362ee6d76f02331e56df1fdec1c2114c9f3e

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

@@ -1,4 +1,6 @@
using HH.WCS.XiaoMi.util;
using Newtonsoft.Json;
using Opc.Ua;
using SqlSugar;
using System;
using System.Collections.Generic;
@@ -341,6 +343,7 @@
            var res = false;
            var db = new SqlHelper<object>().GetInstance();
            var model = db.Queryable<Location>().Where(a => a.S_CODE == loc).First();
            LogHelper.Info("LockLoc 货位参数=====：" + JsonConvert.SerializeObject(model));
            if (model != null && model.S_LOCK_STATE.Trim() == "无")
            {
                model.N_LOCK_STATE = lockState;
@@ -404,6 +407,29 @@
            }
            return res;
        }
        public static bool UnBindingLocHj(string loc, string frame)
        {
            var res = false;
            var db = new SqlHelper<object>().GetInstance();
            var location = db.Queryable<Location>().Where(a => a.S_CODE.Trim() == loc).First();
            try
            {
                db.BeginTran();
                var lcrList = db.Queryable<LocCntrRel>().Where(a => a.S_LOC_CODE.Trim() == loc).ToList();
                var count = db.Deleteable<LocCntrRel>().Where(it => frame==it.S_FRAME_CODE.Trim() && it.S_LOC_CODE.Trim() == loc).ExecuteCommand();
                location.N_CURRENT_NUM = lcrList.Count - count;
                location.S_LOCK_STATE = "无";
                location.N_LOCK_STATE = 0;
                db.Updateable(location).UpdateColumns(it => new { it.N_CURRENT_NUM, it.S_LOCK_STATE, it.N_LOCK_STATE }).ExecuteCommand();
                db.CommitTran();
                res = true;
            }
            catch (Exception ex)
            {
                db.RollbackTran();
            }
            return res;
        }
        /// <summary>
        /// 货位绑定容器
        /// </summary>
@@ -443,7 +469,7 @@
            }
            return res;
        }

        
        /// <summary>
        /// 判断逻辑库区是否有可用货位
        /// </summary>