From fd95223d9703b9c038ed3c782474c885052dda08 Mon Sep 17 00:00:00 2001
From: futian.liu <liufutianyoo@163.com>
Date: 星期五, 22 十二月 2023 17:05:25 +0800
Subject: [PATCH] 代码整理

---
 consum-base/src/main/java/com/consum/base/service/impl/FinSysTenantDepartmentServiceImpl.java |   14 ++++++--------
 1 files changed, 6 insertions(+), 8 deletions(-)

diff --git a/consum-base/src/main/java/com/consum/base/service/impl/FinSysTenantDepartmentServiceImpl.java b/consum-base/src/main/java/com/consum/base/service/impl/FinSysTenantDepartmentServiceImpl.java
index 415b77a..f4d749d 100644
--- a/consum-base/src/main/java/com/consum/base/service/impl/FinSysTenantDepartmentServiceImpl.java
+++ b/consum-base/src/main/java/com/consum/base/service/impl/FinSysTenantDepartmentServiceImpl.java
@@ -25,8 +25,6 @@
 @Service
 public class FinSysTenantDepartmentServiceImpl extends BaseServiceImpl implements FinSysTenantDepartmentService {
 
-    private static final String QUERY_BY_CODE = "SELECT * FROM fin_sys_tenant_department WHERE CODE = ?";
-
     /**
      * @Description 鏍规嵁 閮ㄩ棬鍚嶇О鍜屾満鏋刬d 鏌ヨ閮ㄩ棬
      * @Author 鍗㈠簡闃�
@@ -44,8 +42,8 @@
         }
         // 鏈烘瀯id
         if (tenantId != null) {
-            sql.append(" and TENANT_ID =:TENANT_ID ");
-            paramts.put("TENANT_ID", tenantId);
+            sql.append(" and TENANT_ID =:tenantId ");
+            paramts.put("tenantId", tenantId);
         }
         if (!StringUtils.isEmpty(code)) {
             sql.append("and CODE = :code ");
@@ -102,8 +100,8 @@
         }
         // 鏈烘瀯id
         if (param.getTenantId() != null) {
-            sql.append(" and TENANT_ID =:TENANT_ID ");
-            paramts.put("TENANT_ID", param.getTenantId());
+            sql.append(" and TENANT_ID =:tenantId ");
+            paramts.put("tenantId", param.getTenantId());
         } else {
             sql.append(" and TENANT_ID = 100 ");
         }
@@ -165,8 +163,8 @@
 
         // 鏈烘瀯id
         if (agencyId != null) {
-            sql.append(" and TENANT_ID =:TENANT_ID ");
-            paramts.put("TENANT_ID", agencyId);
+            sql.append(" and TENANT_ID =:tenantId ");
+            paramts.put("tenantId", agencyId);
         }
         return this.select(sql.toString(), paramts, new FinSysTenantDepartment());
     }

--
Gitblit v1.9.1