From 0cc1531f55cfa7927abec8624ddce3db45201ee7 Mon Sep 17 00:00:00 2001
From: yl <ykxkd@outlook.com>
Date: 星期二, 24 十月 2023 17:24:43 +0800
Subject: [PATCH] 1.班组工资报表功能接口、人员工资明细报表功能接口 2.委外报表功能接口、不良明细报表功能接口、维修明细报表功能接口 3.模具清单查看履历接口、模具上机过滤已上模设备接口 4.模具点检记录报表功能接口、模具保养记录报表功能接口 5.模具维修记录报表功能接口
---
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