From 0392ad19b43e399f606615b38cf4bc5e2e96086c Mon Sep 17 00:00:00 2001
From: cuilei <ray_tsu1@163.com>
Date: 星期五, 16 五月 2025 15:51:29 +0800
Subject: [PATCH] 工具管理-修改工具台账明细表数量字段类型
---
lxzn-module-system/lxzn-system-biz/src/main/java/org/jeecg/modules/system/mapper/SysUserRoleMapper.java | 7 +++++++
1 files changed, 7 insertions(+), 0 deletions(-)
diff --git a/lxzn-module-system/lxzn-system-biz/src/main/java/org/jeecg/modules/system/mapper/SysUserRoleMapper.java b/lxzn-module-system/lxzn-system-biz/src/main/java/org/jeecg/modules/system/mapper/SysUserRoleMapper.java
index 84fa63b..15f8bb8 100644
--- a/lxzn-module-system/lxzn-system-biz/src/main/java/org/jeecg/modules/system/mapper/SysUserRoleMapper.java
+++ b/lxzn-module-system/lxzn-system-biz/src/main/java/org/jeecg/modules/system/mapper/SysUserRoleMapper.java
@@ -41,4 +41,11 @@
List<SysUser> getUsersByRoles(@Param("roleList") List<String> roleList);
+ /**
+ * 閫氳繃瑙掕壊id鑾峰彇鐢ㄦ埛username
+ * @param roleId
+ */
+ @Select("select username from sys_user where id in (select user_id from sys_user_role where role_id = #{roleId})")
+ List<String> getUserNameByRoleId(@Param("roleId") String roleId);
+
}
--
Gitblit v1.9.3