From aa4fc5c90adf7c63b01a20474be23e1137b60d32 Mon Sep 17 00:00:00 2001
From: 许鹏程 <1821349743@qq.com>
Date: 星期二, 20 六月 2023 18:12:30 +0800
Subject: [PATCH] 查询结果编码转换
---
home-server-admin/src/main/java/com/home/xining/service/AdvanceNoticeService.java | 8 ++++----
1 files changed, 4 insertions(+), 4 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 2129ace..4f1bd14 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
@@ -89,16 +89,16 @@
public void addTypeSize(FieldSetEntity fs) throws BaseException {
String tableName = fs.getTableName();
String yearNo = fs.getString("no01");
-
+
//鏌ヨ鍚屽瓧鏁版嵁涓渶澶х殑鍙�
- FieldSetEntity fseMax =baseDao.getFieldSetEntityBySQL("SELECT IFNULL(MAX(no02),0)+1 no02 FROM "+tableName+" WHERE no01=?", new Object[] {yearNo}, false);
+ FieldSetEntity fseMax =baseDao.getFieldSetEntityBySQL("SELECT CONVERT(IFNULL(MAX(no02),0)+1,UNSIGNED INT ) 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