报废单 相关代码

luqingyang

2023-11-02 5e6c61b8753870ef2f8cde60eef47e3eeefe89e6

 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());
    }
}