From f7661ec17f87c4185bbe906fe98e114435a4da5a Mon Sep 17 00:00:00 2001
From: yl <ykxkd@outlook.com>
Date: 星期四, 19 十月 2023 12:21:25 +0800
Subject: [PATCH] 1.更改菜单接口排序问题，模具待维修接口过滤问题、增加APP菜单图标 2.更改模具维修申请单、维修单据流水号反写问题 3.增加模具查询功能接口
---
VueWebCoreApi/DLL/DAL/SystemSettingDAL.cs | 6 +++---
1 files changed, 3 insertions(+), 3 deletions(-)
diff --git a/VueWebCoreApi/DLL/DAL/SystemSettingDAL.cs b/VueWebCoreApi/DLL/DAL/SystemSettingDAL.cs
index 0bb40c2..f9015be 100644
--- a/VueWebCoreApi/DLL/DAL/SystemSettingDAL.cs
+++ b/VueWebCoreApi/DLL/DAL/SystemSettingDAL.cs
@@ -32,10 +32,10 @@
union ALL
select e.menucode, e.parent_id, e.menuname,e.menu_seq,e.Type
from TMenu e
- inner join RecursiveCTE r ON e.menucode = r.parent_id
+ inner join RecursiveCTE r ON e.menucode = r.parent_id
)
- select menucode, parent_id, menuname,Type
- from RecursiveCTE order by menu_seq";
+ select distinct menucode, parent_id, menuname,Type,menu_seq
+ from RecursiveCTE order by menucode, parent_id,Type,menu_seq";
var data = DapperHelper.selecttable(sql);
if (data.Rows.Count > 0)
{
--
Gitblit v1.9.3