From a475d774d2a5302a8cd7549ab3da2bd8ed711fee Mon Sep 17 00:00:00 2001
From: linwei <872216696@qq.com>
Date: Thu, 23 Apr 2026 16:19:17 +0800
Subject: [PATCH] fix: 数据库兼容问题修复

---
 drone-service/drone-gd/src/main/java/org/sxkj/gd/workorder/service/impl/GdOperationalRevenueServiceImpl.java |   12 ++++++++----
 1 files changed, 8 insertions(+), 4 deletions(-)

diff --git a/drone-service/drone-gd/src/main/java/org/sxkj/gd/workorder/service/impl/GdOperationalRevenueServiceImpl.java b/drone-service/drone-gd/src/main/java/org/sxkj/gd/workorder/service/impl/GdOperationalRevenueServiceImpl.java
index 3cbe357..ed2e2f3 100644
--- a/drone-service/drone-gd/src/main/java/org/sxkj/gd/workorder/service/impl/GdOperationalRevenueServiceImpl.java
+++ b/drone-service/drone-gd/src/main/java/org/sxkj/gd/workorder/service/impl/GdOperationalRevenueServiceImpl.java
@@ -79,11 +79,15 @@
 			queryWrapper.like(GdOperationalRevenue::getNickName, nickName);
 		}
 		// 创建部门
-		List<Long> deptList = new ArrayList<>();
-		if (!AuthUtil.isAdministrator()) {
-			deptList = SysCache.getDeptChildIds(Long.valueOf(AuthUtil.getDeptId()));
+ 		if (!AuthUtil.isAdministrator()) {
+			List<Long> deptList = SysCache.getDeptChildIds(Long.valueOf(AuthUtil.getDeptId()));
+			// 将Long类型的部门ID转换为String类型
+			List<String> deptIdStrList = new ArrayList<>();
+			for (Long deptId : deptList) {
+				deptIdStrList.add(String.valueOf(deptId));
+			}
+			queryWrapper.in(GdOperationalRevenue::getCreateDept, deptIdStrList);
 		}
-		queryWrapper.in(GdOperationalRevenue::getCreateDept, deptList);
 		// 按创建时间倒序
 		queryWrapper.orderByDesc(GdOperationalRevenue::getCreateTime);
 

--
Gitblit v1.9.3