| | |
|---|
| | | List<FinSysTenantDepartment> select = this.select(sql.toString(), paramts, new FinSysTenantDepartment()); |
|---|
| | | return select; |
|---|
| | | } |
|---|
| | | |
|---|
| | | /** |
|---|
| | | * 根据部门和机构名查找对应的部门信息 |
|---|
| | | * @param tenantName |
|---|
| | | * @param departmentName |
|---|
| | | * @return |
|---|
| | | */ |
|---|
| | | @Override |
|---|
| | | public FinSysTenantDepartment queryIdByTenDepName(String tenantName, String departmentName ) { |
|---|
| | | StringBuilder sql = new StringBuilder("SELECT * FROM fin_sys_tenant_department \n" + |
|---|
| | | "WHERE TENANT_ID = ( SELECT id FROM fin_sys_tenant WHERE NAME = '"+tenantName+"' LIMIT 1 ) AND NAME = '"+departmentName+"' LIMIT 1 "); |
|---|
| | | HashMap<String, Object> paramts = new HashMap<>(); |
|---|
| | | return this.get(sql.toString(), paramts, new FinSysTenantDepartment()); |
|---|
| | | } |
|---|
| | | |
|---|
| | | } |
|---|
