From c4f47bbec99d71eba138745e7f16c03400d88ad1 Mon Sep 17 00:00:00 2001 From: pzy <2829717936@qq.com> Date: 星期三, 18 九月 2024 10:15:53 +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