From a84c2a6d8298e67e43080ba71facd83b79f95809 Mon Sep 17 00:00:00 2001
From: cy <1664593601@qq.com>
Date: 星期一, 30 十月 2023 15:18:37 +0800
Subject: [PATCH] feat: 更改数据库
---
consum-base/src/main/java/com/consum/base/service/BaseCategoryServiceImpl.java | 12 +++++++-----
1 files changed, 7 insertions(+), 5 deletions(-)
diff --git a/consum-base/src/main/java/com/consum/base/service/BaseCategoryServiceImpl.java b/consum-base/src/main/java/com/consum/base/service/BaseCategoryServiceImpl.java
index 0e79236..deb6a52 100644
--- a/consum-base/src/main/java/com/consum/base/service/BaseCategoryServiceImpl.java
+++ b/consum-base/src/main/java/com/consum/base/service/BaseCategoryServiceImpl.java
@@ -94,8 +94,10 @@
}
//鐘舵��
if (param.getStates() != null) {
- sql.append(" and status =:status ");
- paramts.put("status", param.getStates());
+ sql.append(" and states =:states ");
+ paramts.put("states", param.getStates());
+ } else {
+ sql.append(" and states !=3 ");
}
sql.append(" ORDER BY ORDER_NUMBER,CREATE_TIME DESC ");
return selectSplit(sql.toString(), paramts, new BaseCategory());
@@ -120,12 +122,12 @@
}
/**
- * @Description 鏍规嵁鑺傜偣id鍒犻櫎鑺傜偣(閫昏緫鍒犻櫎)
+ * @Description 鏍规嵁id鍒犻櫎鐗╁搧鍒嗙被
* @Author 鍗㈠簡闃�
* @Date 2023/10/23
*/
public int updateById(BaseCategory baseCategory, S_user_core currentUser) {
- baseCategory.setStates(Constants.CATEGORY_DELETED);
+ baseCategory.setStates(Constants.STATES_DELETED);
//鍒犻櫎鏃堕棿
baseCategory.setDTime(DateUtils.getDateTimeNumber(System.currentTimeMillis()));
//鍒犻櫎浜篿d鍜屽垹闄や汉濮撳悕
@@ -137,7 +139,7 @@
/**
* 鏍规嵁鑺傜偣id鏌ヨ鑺傜偣璇︽儏
* @author 鍗㈠簡闃�
- * @date 2023/9/26
+ * @Date 2023/10/23
*/
public BaseCategory getById(Long id) {
return this.get(new BaseCategory(id));
--
Gitblit v1.9.1