From 2418543dfc6c61fa5091e242042a7d7635f6c7c5 Mon Sep 17 00:00:00 2001
From: linwei <872216696@qq.com>
Date: Thu, 02 Apr 2026 14:27:16 +0800
Subject: [PATCH] opt: sql改造其他模块改造9

---
 drone-service/drone-system/src/main/java/org/sxkj/system/controller/RoleController.java |    3 ++-
 1 files changed, 2 insertions(+), 1 deletions(-)

diff --git a/drone-service/drone-system/src/main/java/org/sxkj/system/controller/RoleController.java b/drone-service/drone-system/src/main/java/org/sxkj/system/controller/RoleController.java
index 083fb40..519fdba 100644
--- a/drone-service/drone-system/src/main/java/org/sxkj/system/controller/RoleController.java
+++ b/drone-service/drone-system/src/main/java/org/sxkj/system/controller/RoleController.java
@@ -93,7 +93,8 @@
 		QueryWrapper<Role> queryWrapper = Condition.getQueryWrapper(role, Role.class);
 		// 不查询超级管理员角色
 		// if (!AuthUtil.isAdministrator()) {
-		queryWrapper.ne("id", "1123598816738675201");
+		// 使用 apply 手动指定类型转换
+		queryWrapper.apply("id <> {0}::bigint", "1123598816738675201");
 		// }
 		List<Role> list = roleService.list(queryWrapper);
 		return R.data(RoleWrapper.build().listNodeVO(list));

--
Gitblit v1.9.3