cy
2023-10-27 5b39a22aa4d21610f643c4b6b74f23cdda8dcc0f
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());
    }
}