From 584a165a8d4c0c82479663c9df988fc20226b714 Mon Sep 17 00:00:00 2001 From: luqingyang <lqy5492@163.com> Date: 星期五, 27 十月 2023 17:23:27 +0800 Subject: [PATCH] 出入库管理 相关代码 --- 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