From acaf02b70fca22bb94e6ae01aac048e6625a6df6 Mon Sep 17 00:00:00 2001
From: fcx <2246384483@qq.com>
Date: 星期三, 26 十一月 2025 16:46:58 +0800
Subject: [PATCH] 【平板端质检功能】去掉没有的功能，将现有的功能按指定顺序显示
---
StandardPda/MES.Service/service/LoginService.cs | 65 +++++++++++++++++++++++++-------
1 files changed, 50 insertions(+), 15 deletions(-)
diff --git a/StandardPda/MES.Service/service/LoginService.cs b/StandardPda/MES.Service/service/LoginService.cs
index 0c04e57..819823f 100644
--- a/StandardPda/MES.Service/service/LoginService.cs
+++ b/StandardPda/MES.Service/service/LoginService.cs
@@ -33,22 +33,57 @@
{
var sql = "";
- if ("PL017".Equals(name))
- sql = "select PAGE_VIEW,PATH,ICOIMG from MES_SYS_PAGEVIEW";
- else
- sql = string.Format(@"select PAGE_VIEW,PATH,ICOIMG
- from (select PAGE_VIEW,PATH,ICOIMG
- from MES_SYS_GUP_USER a
- join MES_SYS_PAGEVIEW b on a.PAGEID = b.ID
- join SYS_USER_ROLE c on to_char(c.ROLEID) = a.ROLEID
- where USERID = (select fid from SYS_USER where FCODE = '{0}')
- union all
- select PAGE_VIEW,PATH,ICOIMG
- from MES_SYS_GUP_USER a
- join MES_SYS_PAGEVIEW b on a.PAGEID = b.ID
- where a.ROLEID = (select FCODE from SYS_USER where FCODE = '{0}'))
- group by PATH, PAGE_VIEW, ICOIMG", name);
+ // if ("PL017".Equals(name))
+ // sql = "select PAGE_VIEW,PATH,ICOIMG from MES_SYS_PAGEVIEW";
+ // else
+ // sql = string.Format(@"select PAGE_VIEW,PATH,ICOIMG
+ // from (select PAGE_VIEW,PATH,ICOIMG
+ // from MES_SYS_GUP_USER a
+ // join MES_SYS_PAGEVIEW b on a.PAGEID = b.ID
+ // join SYS_USER_ROLE c on to_char(c.ROLEID) = a.ROLEID
+ // where USERID = (select fid from SYS_USER where FCODE = '{0}')
+ // union all
+ // select PAGE_VIEW,PATH,ICOIMG
+ // from MES_SYS_GUP_USER a
+ // join MES_SYS_PAGEVIEW b on a.PAGEID = b.ID
+ // where a.ROLEID = (select FCODE from SYS_USER where FCODE = '{0}'))
+ // group by PATH, PAGE_VIEW, ICOIMG", name);
+ // return SQLHelper.ExecuteQuery(sql);
+ //}
+
+
+
+ if ("PL017".Equals(name))
+ {
+ // 瓒呯骇绠＄悊鍛樻煡璇㈠叏閮ㄨ彍鍗曪紝骞舵寜 SORT_NO 鎺掑簭
+ sql = @"
+ select PAGE_VIEW, PATH, ICOIMG, SORT_NO
+ from MES_SYS_PAGEVIEW
+ order by SORT_NO asc";
+ }
+ else
+ {
+ // 鏅�氱敤鎴风殑鏉冮檺鏌ヨ
+ sql = string.Format(@"
+ select PAGE_VIEW, PATH, ICOIMG, SORT_NO
+ from (
+ select PAGE_VIEW, PATH, ICOIMG, SORT_NO
+ from MES_SYS_GUP_USER a
+ join MES_SYS_PAGEVIEW b on a.PAGEID = b.ID
+ join SYS_USER_ROLE c on to_char(c.ROLEID) = a.ROLEID
+ where USERID = (select fid from SYS_USER where FCODE = '{0}')
+
+ union all
+
+ select PAGE_VIEW, PATH, ICOIMG, SORT_NO
+ from MES_SYS_GUP_USER a
+ join MES_SYS_PAGEVIEW b on a.PAGEID = b.ID
+ where a.ROLEID = (select FCODE from SYS_USER where FCODE = '{0}')
+ )
+ group by PAGE_VIEW, PATH, ICOIMG, SORT_NO
+ order by SORT_NO asc", name);
+ }
return SQLHelper.ExecuteQuery(sql);
}
--
Gitblit v1.9.3