From c9d401e11bea0cc09bf6fbbe5ebf2e21a09c717c Mon Sep 17 00:00:00 2001
From: czt <czt18638530771@163.com>
Date: 星期三, 31 十二月 2025 15:23:21 +0800
Subject: [PATCH] 去重
---
fzzy-igdss-core/src/main/java/com/fzzy/igds/mapper/CoreDeptMapper.java | 2 +-
1 files changed, 1 insertions(+), 1 deletions(-)
diff --git a/fzzy-igdss-core/src/main/java/com/fzzy/igds/mapper/CoreDeptMapper.java b/fzzy-igdss-core/src/main/java/com/fzzy/igds/mapper/CoreDeptMapper.java
index f536ee7..66ae630 100644
--- a/fzzy-igdss-core/src/main/java/com/fzzy/igds/mapper/CoreDeptMapper.java
+++ b/fzzy-igdss-core/src/main/java/com/fzzy/igds/mapper/CoreDeptMapper.java
@@ -23,7 +23,7 @@
* @param queryWrapper
* @return
*/
- @Select("SELECT d.* FROM d_pledge_contract c LEFT JOIN d_dept d ON d.id = c.pledge_dept ${ew.customSqlSegment}")
+ @Select("SELECT DISTINCT d.* FROM d_pledge_contract c LEFT JOIN d_dept d ON d.id = c.pledge_dept ${ew.customSqlSegment}")
List<Dept> selectDeptByBankId(@Param("ew") QueryWrapper<PledgeContract> queryWrapper);
}
--
Gitblit v1.9.3