From 0ac2d4112295d2d4ef9ca7502af509c2b165f337 Mon Sep 17 00:00:00 2001
From: 海波 张 <2956280567@qq.com>
Date: 星期一, 23 六月 2025 17:31:15 +0800
Subject: [PATCH] 金坛修改

---
 wms/TaskHelper.cs |   37 +++++++++++++++++++++++++++++++++++--
 1 files changed, 35 insertions(+), 2 deletions(-)

diff --git a/wms/TaskHelper.cs b/wms/TaskHelper.cs
index e26dd41..05a3184 100644
--- a/wms/TaskHelper.cs
+++ b/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();
+        }
+
+
     }
 }

--
Gitblit v1.9.1