| | |
|---|
| | | } |
|---|
| | | return this.select(sql.toString(), paramts, new FinSysTenantDepartment()); |
|---|
| | | } |
|---|
| | | |
|---|
| | | @Override |
|---|
| | | public FinSysTenantDepartment getByTenantIdAndName(Long agencyId, String name) { |
|---|
| | | 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 =:tenantId "); |
|---|
| | | paramts.put("tenantId", agencyId); |
|---|
| | | } |
|---|
| | | // name |
|---|
| | | if (name != null) { |
|---|
| | | sql.append(" and name =:name "); |
|---|
| | | paramts.put("name", name); |
|---|
| | | } |
|---|
| | | List<FinSysTenantDepartment> select = this.select(sql.toString(), paramts, new FinSysTenantDepartment()); |
|---|
| | | if(select!=null && select.size()>0){ |
|---|
| | | return select.get(0); |
|---|
| | | } |
|---|
| | | return null; |
|---|
| | | } |
|---|
| | | } |
|---|
