From 10efbcfce9f0f17982f4714e76e8cad24fb8f982 Mon Sep 17 00:00:00 2001
From: yl <ykxkd@outlook.com>
Date: 星期二, 06 十二月 2022 09:25:16 +0800
Subject: [PATCH] SOP文件下拉列表排序
---
VueWebApi/DLL/DAL/ProductionManagementDAL.cs | 2 +-
1 files changed, 1 insertions(+), 1 deletions(-)
diff --git a/VueWebApi/DLL/DAL/ProductionManagementDAL.cs b/VueWebApi/DLL/DAL/ProductionManagementDAL.cs
index 7fffab8..68a619c 100644
--- a/VueWebApi/DLL/DAL/ProductionManagementDAL.cs
+++ b/VueWebApi/DLL/DAL/ProductionManagementDAL.cs
@@ -790,7 +790,7 @@
inner join TFlw_Rteqp E on B.step_code=E.step_code
inner join TEqpInfo Q on E.eqp_code=Q.code
inner join TEqpType T on Q.eqptype_code=T.code
- where A.materiel_code=@partcode and A.route_code=@routecode and B.step_code=@stepcode)";
+ where A.materiel_code=@partcode and A.route_code=@routecode and B.step_code=@stepcode) order by file_version desc";
dynamicParams.Add("@partcode", partcode);
dynamicParams.Add("@routecode", routecode);
dynamicParams.Add("@stepcode", stepcode);
--
Gitblit v1.9.3