From 15b41114558fc0341f5b4e221167b67f7ce9e68e Mon Sep 17 00:00:00 2001
From: 许鹏程 <1821349743@qq.com>
Date: 星期二, 21 一月 2025 14:07:42 +0800
Subject: [PATCH] other:patch sql
---
home-server-admin/src/main/java/com/home/xining/service/AdvanceNoticeService.java | 133 ++++++++++++++++++++++----------------------
1 files changed, 67 insertions(+), 66 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..633dc9a 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
@@ -30,77 +30,78 @@
@Service
public class AdvanceNoticeService extends AbstractBaseService implements IAdvanceNoticeService {
- @Autowired
- public BaseDao baseDao;
- @Autowired
- PermissionService permissionService;
- @Autowired
- QueryFilterService queryFilterService;
+ @Autowired
+ public BaseDao baseDao;
+ @Autowired
+ PermissionService permissionService;
+ @Autowired
+ QueryFilterService queryFilterService;
- @Override
- public DataTableEntity listAdvanceNoticeg(FieldSetEntity fs) throws BaseException{
- String filter=fs.getString("filter");
- String dataFilter = permissionService.getDataFilter(fs.getTableName(),CmnConst.NO18);
+ @Override
+ public DataTableEntity listAdvanceNoticeg(FieldSetEntity fs) throws BaseException {
+ String filter = fs.getString("filter");
+ String dataFilter = permissionService.getDataFilter(fs.getTableName(), CmnConst.NO18);
- if(!StringUtils.isEmpty(dataFilter)){
- if(!StringUtils.isEmpty(filter)){
- filter += " and "+dataFilter;
- }else {
- filter = dataFilter;
- }
- }
- if(!BaseUtil.dataTableIsEmpty(fs.getSubDataTable("systemSeniorQueryString"))){
- filter = filter + " and " + queryFilterService.getQueryFilter(fs);
- }
+ if (!StringUtils.isEmpty(dataFilter)) {
+ if (!StringUtils.isEmpty(filter)) {
+ filter += " and " + dataFilter;
+ } else {
+ filter = dataFilter;
+ }
+ }
+ if (!BaseUtil.dataTableIsEmpty(fs.getSubDataTable("systemSeniorQueryString"))) {
+ 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," no00 desc",fs.getInteger(CmnConst.PAGESIZE),fs.getInteger(CmnConst.CPAGE));
- baseDao.loadPromptData(dt);
- return dt;
- }
+ 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;
+ }
- @Override
- public FieldSetEntity getAdvanceNotice(FieldSetEntity fs) {
- return baseDao.getFieldSet(CmnConst.APP_NOTICE_PUNISHMENT, fs.getUUID(), false);
- }
+ @Override
+ public FieldSetEntity getAdvanceNotice(FieldSetEntity fs) {
+ return baseDao.getFieldSet(CmnConst.APP_NOTICE_PUNISHMENT, fs.getUUID(), false);
+ }
- @Override
- @Transactional
- public String saveAdvanceNotice(FieldSetEntity fs)throws BaseException {
- String fsUUID = fs.getUUID();
- if(BaseUtil.strIsNull(fsUUID)){
- fsUUID = baseDao.add(fs);
- }else{
- baseDao.update(fs);
- }
- return fsUUID;
- }
+ @Override
+ @Transactional
+ public String saveAdvanceNotice(FieldSetEntity fs) throws BaseException {
+ String fsUUID = fs.getUUID();
+ if (BaseUtil.strIsNull(fsUUID)) {
+ fsUUID = baseDao.add(fs);
+ } else {
+ baseDao.update(fs);
+ }
+ return fsUUID;
+ }
- @Override
- @Transactional
- public String deleteAdvanceNotice(FieldSetEntity fs)throws BaseException {
- String uuids = fs.getString(CmnConst.UUID);
- String[] uuid = uuids.split(",");
- baseDao.delete(CmnConst.APP_NOTICE_PUNISHMENT, uuid);
- return uuids;
- }
+ @Override
+ @Transactional
+ public String deleteAdvanceNotice(FieldSetEntity fs) throws BaseException {
+ String uuids = fs.getString(CmnConst.UUID);
+ String[] uuid = uuids.split(",");
+ baseDao.delete(CmnConst.APP_NOTICE_PUNISHMENT, uuid);
+ return uuids;
+ }
- @Override
- @Transactional
- 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);
- 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()});
- }
- }
+ @Override
+ @Transactional
+ public void addTypeSize(FieldSetEntity fs) throws BaseException {
+ String tableName = fs.getTableName();
+ String yearNo = fs.getString("no01");
+
+ //鏌ヨ鍚屽瓧鏁版嵁涓渶澶х殑鍙�
+ 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()});
+ fs.setValue("no02", finalNo);
+ }
+ }
}
--
Gitblit v1.9.2