From 1fe633ce55c6a0e18fdbb7d593a73249b7ecb8bb Mon Sep 17 00:00:00 2001 From: shichongfu <shi_chongfu@163.com> Date: 星期四, 08 六月 2023 12:13:02 +0800 Subject: [PATCH] Merge branch 'master' of http://nonxin.cn:8090/r/project/xnfg --- home-server-admin/src/main/java/com/home/xining/service/AdvanceNoticeService.java | 23 ++++++++++++++++------- 1 files changed, 16 insertions(+), 7 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..2129ace 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 @@ -17,6 +17,8 @@ import org.springframework.stereotype.Component; import org.springframework.stereotype.Service; +import java.text.DecimalFormat; +import java.text.Format; import java.text.ParseException; /** @@ -86,12 +88,19 @@ @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 no02 = String.valueOf(Integer.parseInt(dataTableEntity.getFieldSetEntity(0).getString("no02")) + 1); - while (no02.length() < 3){ - no02 = "0" + no02; - } - fs.setValue("no02",no02); - baseDao.update(fs); + String yearNo = fs.getString("no01"); + + //鏌ヨ鍚屽瓧鏁版嵁涓渶澶х殑鍙� + FieldSetEntity fseMax =baseDao.getFieldSetEntityBySQL("SELECT IFNULL(MAX(no02),0)+1 no02 FROM "+tableName+" WHERE no01=?", new Object[] {yearNo}, false); + if (fseMax!=null) { + Integer maxNo = fseMax.getInteger("no02"); + + //鏍煎紡鍖栧彿 + Format format = new DecimalFormat("000"); + String finalNo= format.format(maxNo); + + //淇敼鏁版嵁 + baseDao.executeUpdate("UPDATE "+ tableName +" SET no02 =? WHERE uuid=?", new Object[] {finalNo, fs.getUUID()}); + } } } -- Gitblit v1.9.2