From 9445c4660740dc8a544b5c2440fe365a218bab12 Mon Sep 17 00:00:00 2001
From: yl <ykxkd@outlook.com>
Date: 星期四, 26 十月 2023 17:26:39 +0800
Subject: [PATCH] 1.修改仓位信息列表接口 2.新增仓库库位基础资料接口 3.修改模具出入库提交接口(增加库位) 、模具清单增加库位 4.新增模具上下机记录报表、模具借还记录报表
---
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