From d91966256d4b507b3f49d9f1b231b258e52a019b Mon Sep 17 00:00:00 2001
From: yl <ykxkd@outlook.com>
Date: 星期四, 07 九月 2023 18:03:22 +0800
Subject: [PATCH] 1.仓库、仓位功能 1.设备类型、设备功能
---
VueWebCoreApi/DLL/DAL/LoginDAL.cs | 4 ++--
1 files changed, 2 insertions(+), 2 deletions(-)
diff --git a/VueWebCoreApi/DLL/DAL/LoginDAL.cs b/VueWebCoreApi/DLL/DAL/LoginDAL.cs
index 330b9c1..666a512 100644
--- a/VueWebCoreApi/DLL/DAL/LoginDAL.cs
+++ b/VueWebCoreApi/DLL/DAL/LoginDAL.cs
@@ -172,7 +172,7 @@
string codeString = string.Join(",", menuCodes);
//鏌ヨ鑿滃崟鏁版嵁
sql = @"select menucode,menuname,menu_seq,imgurl,'0' as flag,parent_id,is_show
- from TMenu where Type=@usertype order by menu_seq";
+ from TMenu where is_show='Y' and Type=@usertype order by menu_seq";
dynamicParams.Add("@usertype", usertype);
var data0 = DapperHelper.selectdata(sql, dynamicParams);
if (data0.Rows.Count > 0)
@@ -267,7 +267,7 @@
string codeString = string.Join(",", menuCodes);
//鏌ヨ鑿滃崟鏁版嵁
sql = @"select menucode,menuname,menu_seq,imgurl,'0' as flag,parent_id,is_show
- from TMenu where Type=@usertype order by menu_seq";
+ from TMenu where is_show='Y' and Type=@usertype order by menu_seq";
dynamicParams.Add("@usertype", usertype);
var data0 = DapperHelper.selectdata(sql, dynamicParams);
if (data0.Rows.Count > 0)
--
Gitblit v1.9.3