From cf4e7f7472f7945169a3fc589c8fcbce6623f7eb Mon Sep 17 00:00:00 2001
From: wtt <1985833171@qq.com>
Date: 星期二, 31 十二月 2024 14:33:39 +0800
Subject: [PATCH] 1

---
 WebAPI/Controllers/PublicPageMethodController.cs |    2 +-
 1 files changed, 1 insertions(+), 1 deletions(-)

diff --git a/WebAPI/Controllers/PublicPageMethodController.cs b/WebAPI/Controllers/PublicPageMethodController.cs
index 8a9a2a5..45881d2 100644
--- a/WebAPI/Controllers/PublicPageMethodController.cs
+++ b/WebAPI/Controllers/PublicPageMethodController.cs
@@ -3473,7 +3473,7 @@
             SQLHelper.ClsCN SubCn = new SQLHelper.ClsCN();
             string sql = string.Format(@"select '鏉冮檺绠$悊-鐢ㄦ埛' id,'' HNumber,'鏉冮檺绠$悊--鐢ㄦ埛' title,'' ParentID
                                          union all
-                                         select gnbm id,gnsy HNumber,gnmc as title, case when sjgnbm='' then '鏉冮檺绠$悊--鐢ㄦ埛' else sjgnbm end  ParentID  from Xt_Xtgnb where sjgnbm=''
+                                         select gnbm id,gnsy HNumber,gnmc as title, case when sjgnbm='' then '鏉冮檺绠$悊--鐢ㄦ埛' else sjgnbm end  ParentID  from Xt_Xtgnb where sjgnbm=''  and useflag=1
                                          union all
                                          Select gnbm id,gnsy HNumber,gnmc as title,sjgnbm as ParentID
                                          from Xt_Xtgnb  where mjbz=0 and useflag=1 and rightflag=1 and sjgnbm in(

--
Gitblit v1.9.1