From fd95223d9703b9c038ed3c782474c885052dda08 Mon Sep 17 00:00:00 2001 From: futian.liu <liufutianyoo@163.com> Date: 星期五, 22 十二月 2023 17:05:25 +0800 Subject: [PATCH] 代码整理 --- consum-base/src/main/java/com/consum/base/service/impl/FinSysTenantDepartmentServiceImpl.java | 14 ++++++-------- 1 files changed, 6 insertions(+), 8 deletions(-) diff --git a/consum-base/src/main/java/com/consum/base/service/impl/FinSysTenantDepartmentServiceImpl.java b/consum-base/src/main/java/com/consum/base/service/impl/FinSysTenantDepartmentServiceImpl.java index 415b77a..f4d749d 100644 --- a/consum-base/src/main/java/com/consum/base/service/impl/FinSysTenantDepartmentServiceImpl.java +++ b/consum-base/src/main/java/com/consum/base/service/impl/FinSysTenantDepartmentServiceImpl.java @@ -25,8 +25,6 @@ @Service public class FinSysTenantDepartmentServiceImpl extends BaseServiceImpl implements FinSysTenantDepartmentService { - private static final String QUERY_BY_CODE = "SELECT * FROM fin_sys_tenant_department WHERE CODE = ?"; - /** * @Description 鏍规嵁 閮ㄩ棬鍚嶇О鍜屾満鏋刬d 鏌ヨ閮ㄩ棬 * @Author 鍗㈠簡闃� @@ -44,8 +42,8 @@ } // 鏈烘瀯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 "); @@ -102,8 +100,8 @@ } // 鏈烘瀯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 "); } @@ -165,8 +163,8 @@ // 鏈烘瀯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()); } -- Gitblit v1.9.1