金坛优化

海波 张

2025-06-24 112c9bd20afed95d582b7eb227075ab8d10cdd12

 wms/LocationHelper.cs

@@ -112,7 +112,7 @@
            foreach (var item in locList)
            {
                var ConnectionList = 0;
                ConnectionList = db.Queryable<WMSTask>().Where(a => (a.S_END_LOC.Contains(item) || a.S_START_LOC.Contains(item)) && a.S_B_STATE != "完成" && a.S_B_STATE != "取消" && a.S_B_STATE != "错误").ToList().Count();
                ConnectionList = db.Queryable<WMSTask>().Where(a => (a.S_END_LOC.Contains(item) || a.S_START_LOC.Contains(item)) && a.S_B_STATE != "完成" && a.S_B_STATE != "取消" && a.S_B_STATE != "失败" && a.S_B_STATE != "已完成" &&  a.S_B_STATE != "未执行").ToList().Count();
                var re = new connectionBalance();
                var con = LocationHelper.GetLoc(item);
                re.loc = con;
@@ -122,7 +122,17 @@
            return result.OrderBy(a => a.taskCount).ToList();
        }

   
        /// <summary>
        /// 返回当前接驳位执行任务数量
        /// </summary>
        internal static int GetConnectionTaskCount(string connection)
        {
            var db = new SqlHelper<object>().GetInstance();

                var ConnectionList = 0;
                ConnectionList = db.Queryable<WMSTask>().Where(a => (a.S_END_LOC.Contains(connection) || a.S_START_LOC.Contains(connection)) && a.S_B_STATE != "完成" && a.S_B_STATE != "取消" && a.S_B_STATE != "失败" && a.S_B_STATE != "已完成" ).ToList().Count();
            return ConnectionList;
        }


        /// <summary>