From 61ece19b5b178d1b23bed16c733b01af1185f838 Mon Sep 17 00:00:00 2001 From: 海波 张 <2956280567@qq.com> Date: 星期日, 20 七月 2025 23:11:43 +0800 Subject: [PATCH] 0720 --- wms/TaskHelper.cs | 12 +++++++++++- 1 files changed, 11 insertions(+), 1 deletions(-) diff --git a/wms/TaskHelper.cs b/wms/TaskHelper.cs index dda45de..9bfeac9 100644 --- a/wms/TaskHelper.cs +++ b/wms/TaskHelper.cs @@ -65,7 +65,7 @@ internal static WmsWork GetWmsWork(string no) { var db = new SqlHelper<WmsWork>().GetInstance(); - return db.Queryable<WmsWork>().Where(it => it.S_CODE == no).First(); + return db.Queryable<WmsWork>().Where(it => it.S_CODE == no).OrderByDescending(b=>b.T_CREATE).First(); } @@ -932,6 +932,8 @@ return db.Queryable<WorkFlow>().Where(a => a.FLOWCODE == flowCode && a.TOOLSTYPE == type).First(); } + + //鏍规嵁娴佺▼缂栧彿鍜岃捣鐐瑰簱鍖烘煡鎵句綔涓氭祦绋� public static WorkFlow selectWorkFlowByStratArea(string flowCode, string startArea) { @@ -939,6 +941,14 @@ return db.Queryable<WorkFlow>().Where(a => a.FLOWCODE == flowCode && a.STARTAREA==startArea).First(); } + //鏍规嵁娴佺▼缂栧彿鍜岀粓鐐瑰簱鍖烘煡鎵句綔涓氭祦绋�+ public static WorkFlow selectWorkFlowByEndArea(string flowCode, string endArea) + { + var db = new SqlHelper<WorkFlow>().GetInstance(); + return db.Queryable<WorkFlow>().Where(a => a.FLOWCODE == flowCode && a.ENDAREA == endArea).First(); + } + + /// <summary> /// 鏍规嵁浠诲姟鐘舵�鑾峰彇agv浠诲姟 /// </summary> -- Gitblit v1.9.1