From 763850af4dd0a51ca3f6b69cf667beb60769820a Mon Sep 17 00:00:00 2001 From: 许鹏程 <1821349743@qq.com> Date: 星期三, 07 六月 2023 19:46:09 +0800 Subject: [PATCH] commit --- home-server-admin/src/main/java/com/home/xining/service/AdvanceNoticeService.java | 3 ++- 1 files changed, 2 insertions(+), 1 deletions(-) diff --git a/home-server-admin/src/main/java/com/home/xining/service/AdvanceNoticeService.java b/home-server-admin/src/main/java/com/home/xining/service/AdvanceNoticeService.java index b8e900b..3d9f2bc 100644 --- a/home-server-admin/src/main/java/com/home/xining/service/AdvanceNoticeService.java +++ b/home-server-admin/src/main/java/com/home/xining/service/AdvanceNoticeService.java @@ -86,7 +86,8 @@ @Transactional public void addTypeSize(FieldSetEntity fs) throws BaseException { String tableName = fs.getTableName(); - DataTableEntity dataTableEntity = baseDao.listTable("SELECT IFNULL(MAX(no02),0) no02 FROM "+tableName, new String[]{}); + String year = fs.getString("no01"); + DataTableEntity dataTableEntity = baseDao.listTable("SELECT IFNULL(MAX(no02),0) no02 FROM "+tableName+" where no01=?", new String[]{year}); String no02 = String.valueOf(Integer.parseInt(dataTableEntity.getFieldSetEntity(0).getString("no02")) + 1); while (no02.length() < 3){ no02 = "0" + no02; -- Gitblit v1.9.2