From f3529363cc63b4729a429f80a4827b71df0cd5dd Mon Sep 17 00:00:00 2001 From: cy <1664593601@qq.com> Date: 星期五, 10 十一月 2023 11:26:23 +0800 Subject: [PATCH] feat: 上传 --- consum-base/src/main/java/com/consum/base/service/FinSysTenantDepartmentServiceImpl.java | 18 +++++++++++++++++- 1 files changed, 17 insertions(+), 1 deletions(-) diff --git a/consum-base/src/main/java/com/consum/base/service/FinSysTenantDepartmentServiceImpl.java b/consum-base/src/main/java/com/consum/base/service/FinSysTenantDepartmentServiceImpl.java index 95321c8..ef8975f 100644 --- a/consum-base/src/main/java/com/consum/base/service/FinSysTenantDepartmentServiceImpl.java +++ b/consum-base/src/main/java/com/consum/base/service/FinSysTenantDepartmentServiceImpl.java @@ -47,7 +47,6 @@ sql.append(" and TENANT_ID =:TENANT_ID "); paramts.put("TENANT_ID", tenantId); } - return this.get(sql.toString(), paramts, new FinSysTenantDepartment()); } @@ -149,4 +148,21 @@ department.setUpdateBy(currentUser.getUserName()); return this.update(department); } + + /** + * 鏍规嵁鏈烘瀯id鏌ヨ閮ㄩ棬 + * @param agencyId + * @return + */ + public List<FinSysTenantDepartment> getByTenantId(Long agencyId) { + 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 =:TENANT_ID "); + paramts.put("TENANT_ID", agencyId); + } + return this.select(sql.toString(), paramts, new FinSysTenantDepartment()); + } } -- Gitblit v1.9.1