From ca9d62ee372b3377c3336d23a392c6009e1483e1 Mon Sep 17 00:00:00 2001
From: cy <1664593601@qq.com>
Date: 星期五, 27 十月 2023 17:10:30 +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