From e88e345fc018255aeca8533c25a89826a9bbf631 Mon Sep 17 00:00:00 2001
From: 许鹏程 <1821349743@qq.com>
Date: 星期四, 08 六月 2023 18:10:12 +0800
Subject: [PATCH] commit
---
home-server-admin/src/main/java/com/home/xining/service/AdvanceNoticeService.java | 5 +++--
1 files changed, 3 insertions(+), 2 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 704ec8f..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
@@ -51,7 +51,7 @@
filter = filter + " and " + queryFilterService.getQueryFilter(fs);
}
// fs.getInteger(CmnConst.PAGESIZE),fs.getInteger(CmnConst.CPAGE)
- DataTableEntity dt = baseDao.listTable(CmnConst.APP_NOTICE_PUNISHMENT,filter, null,null,null,fs.getInteger(CmnConst.PAGESIZE),fs.getInteger(CmnConst.CPAGE));
+ DataTableEntity dt = baseDao.listTable(CmnConst.APP_NOTICE_PUNISHMENT,filter, null,null," no00 desc",fs.getInteger(CmnConst.PAGESIZE),fs.getInteger(CmnConst.CPAGE));
baseDao.loadPromptData(dt);
return dt;
}
@@ -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