From 1742240f8f6841e2d930e549caabab94f2a58ece Mon Sep 17 00:00:00 2001 From: futian.liu <liufutianyoo@163.com> Date: 星期三, 22 十一月 2023 18:37:10 +0800 Subject: [PATCH] --报废单 --- consum-base/src/main/java/com/consum/base/service/FinSysTenantServiceImpl.java | 70 +++++------------------------------ 1 files changed, 10 insertions(+), 60 deletions(-) diff --git a/consum-base/src/main/java/com/consum/base/service/FinSysTenantServiceImpl.java b/consum-base/src/main/java/com/consum/base/service/FinSysTenantServiceImpl.java index 452bd0c..60fb4a2 100644 --- a/consum-base/src/main/java/com/consum/base/service/FinSysTenantServiceImpl.java +++ b/consum-base/src/main/java/com/consum/base/service/FinSysTenantServiceImpl.java @@ -7,10 +7,7 @@ import com.walker.infrastructure.utils.DateUtils; import com.walker.infrastructure.utils.StringUtils; import com.walker.jdbc.service.BaseServiceImpl; -import java.text.ParseException; -import java.text.SimpleDateFormat; import java.util.ArrayList; -import java.util.Date; import java.util.HashMap; import java.util.List; import java.util.Map; @@ -22,10 +19,8 @@ private static final String QUERY_TREE_ALL = "select * from FIN_SYS_TENANT where is_delete = 0 and status = 1 order by parent_id, LV ASC"; private static final String QUERY_TREE_BY_CODE = "SELECT * FROM FIN_SYS_TENANT "; - private static final String QUERY_BY_PARENT_ID = "SELECT * FROM FIN_SYS_TENANT WHERE parent_id = ?"; - private static final String QUERY_BY_PARENT_CODE = "SELECT * FROM FIN_SYS_TENANT WHERE CODE = ?"; private static final String QUERY_LIST_BY_CITY_CODE = "SELECT ID, NAME, CODE, CASE WHEN LV = 2 THEN ID ELSE PARENT_ID END AS PARENT_ID, LV, TENANT_TYPE, BELONG_PROVINCE FROM FIN_SYS_TENANT "; - private static final String QUERY_LIST_BY_PARENT_ID = "SELECT * FROM FIN_SYS_TENANT WHERE PARENT_ID = ? ORDER BY LV ASC"; + private static final String QUERY_LV2_ALL = "SELECT * FROM FIN_SYS_TENANT WHERE LV < 3 ORDER BY CODE ASC"; /** * @Author 锛歱ower @@ -41,8 +36,6 @@ return null; } - - private static final String QUERY_LV2_ALL = "SELECT * FROM FIN_SYS_TENANT WHERE LV < 3 ORDER BY CODE ASC"; public List<FinSysTenant> queryForTree() { // 灞曠ず鍏ㄩ儴鑺傜偣 @@ -101,37 +94,6 @@ return this.select(QUERY_LV2_ALL, new Object[]{}, new FinSysTenant()); } - /** - * @Description 鏍规嵁鐖剁骇id鑾峰彇涓嬬骇鍒楄〃 - * @Author wh - * @Date 2023/7/25 13:53 - */ - public List<FinSysTenant> getByParentId(Long parentId) { - return this.select(QUERY_LIST_BY_PARENT_ID, new Object[]{parentId}, new FinSysTenant()); - } - - /** - * @Description 鏍规嵁parentId鏌ヨ - * @Author wh - * @Date 2023/9/11 19:16 - */ - public FinSysTenant selectByParentId(String parentId) { - List<FinSysTenant> select = this.select(QUERY_BY_PARENT_ID, new Object[]{parentId}, new FinSysTenant()); - if (StringUtils.isEmptyList(select)) { - return null; - } else { - return select.get(0); - } - } - - public FinSysTenant selectByTenantId(String tenantCode) { - List<FinSysTenant> select = this.select(QUERY_BY_PARENT_CODE, new Object[]{tenantCode}, new FinSysTenant()); - if (StringUtils.isEmptyList(select)) { - return null; - } else { - return select.get(0); - } - } /** * 鍒犻櫎 @@ -144,7 +106,7 @@ finSysTenant.setTempId(param.getId()); finSysTenant.setStatus(0); finSysTenant.setIsDelete(1); - finSysTenant.setModified(getCurrentDate()); + finSysTenant.setModified(DateUtils.getDate("yyyy-MM-dd HH:mm:ss")); finSysTenant.setUpdateTime(DateUtils.getDateTimeNumber(System.currentTimeMillis())); finSysTenant.setUpdateBy(sysInfo.getUserName()); return this.update(finSysTenant); @@ -182,7 +144,7 @@ finSysTenant.setCode(param.getCode()); //璁剧疆璇︾粏鍦板潃鍙婄粡绾害 finSysTenant.setName(param.getName()); - finSysTenant.setCreateTime3(getCurrentDate()); + finSysTenant.setCreateTime3(DateUtils.getDate("yyyy-MM-dd HH:mm:ss")); finSysTenant.setCreateTime(DateUtils.getDateTimeNumber(System.currentTimeMillis())); finSysTenant.setSummary(param.getSummary()); finSysTenant.setCreateBy(sysInfo.getUserName()); @@ -262,24 +224,6 @@ /** - * 鑾峰彇褰撳墠鏃ユ湡 - * - * @author 鍗㈠簡闃� - * @date 2023/10/4 - */ - private Date getCurrentDate() { - Date currentDate = new Date(); - SimpleDateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); - String formattedDate = dateFormat.format(currentDate); - try { - Date convertedDate = dateFormat.parse(formattedDate); - } catch (ParseException e) { - e.printStackTrace(); - } - return currentDate; - } - - /** * 缂栬緫 * * @author 鍗㈠簡闃� @@ -294,9 +238,15 @@ } else { finSysTenant.setLv3Name(finSysTenant.getName()); } - finSysTenant.setModified(getCurrentDate()); + finSysTenant.setModified(DateUtils.getDate("yyyy-MM-dd HH:mm:ss")); finSysTenant.setUpdateTime(DateUtils.getDateTimeNumber(System.currentTimeMillis())); finSysTenant.setUpdateBy(sysInfo.getUserName()); return this.update(finSysTenant); } + + public FinSysTenant selectById(Long id) { + FinSysTenant tenant = new FinSysTenant(); + tenant.setTempId(id); + return this.get(tenant); + } } -- Gitblit v1.9.1