From 365936930b2fb6e5a86cc6dda878fb24f15f0b9e Mon Sep 17 00:00:00 2001 From: yangle <admin@YINMOU> Date: 星期四, 05 九月 2024 12:22:08 +0800 Subject: [PATCH] Merge branch 'master' of http://101.37.171.70:10101/r/MES-WEB-API --- 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