From 203edd6bbdf883e897a0075037a4ef68cd519ac9 Mon Sep 17 00:00:00 2001
From: yzh <snbbt@21cn.com>
Date: 星期四, 23 六月 2022 00:07:56 +0800
Subject: [PATCH] 系统账户管理列表用户角色显示优化
---
web/Dao/SysFlowNodeDao.cs | 2 +-
1 files changed, 1 insertions(+), 1 deletions(-)
diff --git a/web/Dao/SysFlowNodeDao.cs b/web/Dao/SysFlowNodeDao.cs
index c289723..767778d 100644
--- a/web/Dao/SysFlowNodeDao.cs
+++ b/web/Dao/SysFlowNodeDao.cs
@@ -172,7 +172,7 @@
}
if (sysFlowNode.UserId != null && sysFlowNode.UserId != "")
{
- stringBuilder.Append(" AND INSTR(','||USER_ID||',','" + sysFlowNode.UserId + "') > 0");
+ stringBuilder.Append(" AND INSTR(','||USER_ID||',', '" + sysFlowNode.UserId + "') > 0"); //瀵瑰簲MySql鐨凢IND_IN_SET璇硶銆�
}
stringBuilder.Append(" ORDER BY BUSINESS_TYPE ");
--
Gitblit v1.9.1