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