金坛修改

海波 张

2025-06-23 0ac2d4112295d2d4ef9ca7502af509c2b165f337

 wms/TaskHelper.cs

@@ -984,7 +984,7 @@

            var db = new SqlHelper<object>().GetInstance();

            return db.Queryable<UnlimitedLoc>().ToList();
            return db.Queryable<UnlimitedLoc>().Where(a=>a.Enable=="Y").ToList();
        }


@@ -1000,6 +1000,39 @@
            return db.Queryable<InPri>().Where(a=>a.Enable=="Y") .ToList();
        }

        

        /// <summary>
        /// 添加agv动作缓存
        /// </summary>
        /// <param name="agv"></param>
        /// <returns></returns>
        internal static bool CreateAgvActionState(AgvActionState agv)
        {
            try
            {
                var db = new SqlHelper<object>().GetInstance();
                return db.Insertable<AgvActionState>(agv).ExecuteCommand() > 0;
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.Message);
                throw;
            }
        }


        /// <summary>
        /// 获取agv动作
        /// </summary>
        /// <returns></returns>
        internal static List<AgvActionState> GetAgvActionState( string taskNo)
        {

            var db = new SqlHelper<object>().GetInstance();

            return db.Queryable<AgvActionState>().Where(a => a.task_no==taskNo).ToList();
        }


    }
}