From 62b6a7fac3f2acde70b578431147c4a01f19c182 Mon Sep 17 00:00:00 2001
From: 黎星凯 <13949086503@163.com>
Date: 星期一, 15 四月 2024 09:07:05 +0800
Subject: [PATCH] bug修改

---
 consum-base/src/main/java/com/consum/base/service/impl/FinSysTenantDepartmentServiceImpl.java |   35 +++++++++++++++++++++++++++++++++++
 1 files changed, 35 insertions(+), 0 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 f4d749d..5121104 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
@@ -168,4 +168,39 @@
         }
         return this.select(sql.toString(), paramts, new FinSysTenantDepartment());
     }
+
+    @Override
+    public FinSysTenantDepartment getByTenantIdAndName(Long agencyId, String name) {
+        StringBuilder sql = new StringBuilder("SELECT * FROM fin_sys_tenant_department WHERE 1 = 1 and is_delete = 0 ");
+        HashMap<String, Object> paramts = new HashMap<>();
+
+        // 鏈烘瀯id
+        if (agencyId != null) {
+            sql.append(" and TENANT_ID =:tenantId ");
+            paramts.put("tenantId", agencyId);
+        }
+        // name
+        if (name != null) {
+            sql.append(" and name =:name ");
+            paramts.put("name", name);
+        }
+        List<FinSysTenantDepartment> select = this.select(sql.toString(), paramts, new FinSysTenantDepartment());
+        if(select!=null && select.size()>0){
+            return select.get(0);
+        }
+        return null;
+    }
+
+    @Override
+    public List<FinSysTenantDepartment> queryDataList(FinSysTenantDepartmentParam param) {
+        StringBuilder sql = new StringBuilder("SELECT * FROM fin_sys_tenant_department WHERE 1 = 1");
+        HashMap<String, Object> paramts = new HashMap<>();
+        // 缂栧彿
+        if (!StringUtils.isEmpty(param.getCode())) {
+            sql.append(" and code =:code ");
+            paramts.put("code", param.getCode());
+        }
+        List<FinSysTenantDepartment> select = this.select(sql.toString(), paramts, new FinSysTenantDepartment());
+        return select;
+    }
 }

--
Gitblit v1.9.1