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