| | |
| | | @Service |
| | | public class FinSysTenantDepartmentServiceImpl extends BaseServiceImpl implements FinSysTenantDepartmentService { |
| | | |
| | | private static final String QUERY_BY_CODE = "SELECT * FROM fin_sys_tenant_department WHERE CODE = ?"; |
| | | |
| | | /** |
| | | * @Description 根据 部门名称和机构id 查询部门 |
| | | * @Author 卢庆阳 |
| | |
| | | } |
| | | // 机构id |
| | | if (tenantId != null) { |
| | | sql.append(" and TENANT_ID =:TENANT_ID "); |
| | | paramts.put("TENANT_ID", tenantId); |
| | | sql.append(" and TENANT_ID =:tenantId "); |
| | | paramts.put("tenantId", tenantId); |
| | | } |
| | | if (!StringUtils.isEmpty(code)) { |
| | | sql.append("and CODE = :code "); |
| | |
| | | } |
| | | // 机构id |
| | | if (param.getTenantId() != null) { |
| | | sql.append(" and TENANT_ID =:TENANT_ID "); |
| | | paramts.put("TENANT_ID", param.getTenantId()); |
| | | sql.append(" and TENANT_ID =:tenantId "); |
| | | paramts.put("tenantId", param.getTenantId()); |
| | | } else { |
| | | sql.append(" and TENANT_ID = 100 "); |
| | | } |
| | |
| | | |
| | | // 机构id |
| | | if (agencyId != null) { |
| | | sql.append(" and TENANT_ID =:TENANT_ID "); |
| | | paramts.put("TENANT_ID", agencyId); |
| | | sql.append(" and TENANT_ID =:tenantId "); |
| | | paramts.put("tenantId", agencyId); |
| | | } |
| | | return this.select(sql.toString(), paramts, new FinSysTenantDepartment()); |
| | | } |