From 11f925fdce0f58d1f321f3a13a3f3e84221c6912 Mon Sep 17 00:00:00 2001 From: futian.liu <liufutianyoo@163.com> Date: 星期一, 13 十一月 2023 09:27:14 +0800 Subject: [PATCH] 整理代码 --- consum-base/src/main/java/com/consum/base/service/FinSysTenantDepartmentServiceImpl.java | 23 ++++++++++++++++++----- 1 files changed, 18 insertions(+), 5 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..99b1cbd 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 @@ -2,12 +2,9 @@ import com.consum.base.Constants; import com.consum.base.pojo.FinSysTenantDepartmentParam; -import com.consum.base.util.IdUtil; -import com.consum.model.po.BaseCategory; -import com.consum.model.po.FinSysTenant; +import com.consum.base.core.utils.IdUtil; import com.consum.model.po.FinSysTenantDepartment; import com.consum.model.po.FinSysTenantUser; -import com.iplatform.model.po.S_user_core; import com.walker.db.page.GenericPager; import com.walker.infrastructure.utils.DateUtils; import com.walker.infrastructure.utils.StringUtils; @@ -47,7 +44,6 @@ sql.append(" and TENANT_ID =:TENANT_ID "); paramts.put("TENANT_ID", tenantId); } - return this.get(sql.toString(), paramts, new FinSysTenantDepartment()); } @@ -149,4 +145,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