From 971023df5fd3795e24d10d4d4d03ee112df12297 Mon Sep 17 00:00:00 2001
From: java110 <928255095@qq.com>
Date: 星期四, 24 三月 2022 12:17:41 +0800
Subject: [PATCH] 优化查询为空问题
---
service-store/src/main/java/com/java110/store/dao/impl/ResourceStoreServiceDaoImpl.java | 52 +++++++++++++++++++++++++++++++++++-----------------
1 files changed, 35 insertions(+), 17 deletions(-)
diff --git a/service-store/src/main/java/com/java110/store/dao/impl/ResourceStoreServiceDaoImpl.java b/service-store/src/main/java/com/java110/store/dao/impl/ResourceStoreServiceDaoImpl.java
old mode 100644
new mode 100755
index f3349f7..c3549a1
--- a/service-store/src/main/java/com/java110/store/dao/impl/ResourceStoreServiceDaoImpl.java
+++ b/service-store/src/main/java/com/java110/store/dao/impl/ResourceStoreServiceDaoImpl.java
@@ -2,12 +2,13 @@
import com.alibaba.fastjson.JSONObject;
import com.java110.core.base.dao.BaseServiceDao;
+import com.java110.dto.resourceStore.ResourceStoreDto;
import com.java110.store.dao.IResourceStoreServiceDao;
import com.java110.utils.constant.ResponseConstant;
import com.java110.utils.exception.DAOException;
import com.java110.utils.util.DateUtil;
import org.slf4j.Logger;
-import org.slf4j.LoggerFactory;
+import com.java110.core.log.LoggerFactory;
import org.springframework.stereotype.Service;
import java.util.List;
@@ -35,7 +36,6 @@
// 鏌ヨbusiness_user 鏁版嵁鏄惁宸茬粡瀛樺湪
logger.debug("淇濆瓨璧勬簮淇℃伅 鍏ュ弬 businessResourceStoreInfo : {}", businessResourceStoreInfo);
int saveFlag = sqlSessionTemplate.insert("resourceResourceStoreServiceDaoImpl.saveBusinessResourceStoreInfo", businessResourceStoreInfo);
-
if (saveFlag < 1) {
throw new DAOException(ResponseConstant.RESULT_PARAM_ERROR, "淇濆瓨璧勬簮鏁版嵁澶辫触锛�" + JSONObject.toJSONString(businessResourceStoreInfo));
}
@@ -51,11 +51,8 @@
*/
@Override
public List<Map> getBusinessResourceStoreInfo(Map info) throws DAOException {
-
logger.debug("鏌ヨ璧勬簮淇℃伅 鍏ュ弬 info : {}", info);
-
List<Map> businessResourceStoreInfos = sqlSessionTemplate.selectList("resourceResourceStoreServiceDaoImpl.getBusinessResourceStoreInfo", info);
-
return businessResourceStoreInfos;
}
@@ -69,11 +66,24 @@
@Override
public void saveResourceStoreInfoInstance(Map info) throws DAOException {
logger.debug("淇濆瓨璧勬簮淇℃伅Instance 鍏ュ弬 info : {}", info);
-
int saveFlag = sqlSessionTemplate.insert("resourceResourceStoreServiceDaoImpl.saveResourceStoreInfoInstance", info);
-
if (saveFlag < 1) {
throw new DAOException(ResponseConstant.RESULT_PARAM_ERROR, "淇濆瓨璧勬簮淇℃伅Instance鏁版嵁澶辫触锛�" + JSONObject.toJSONString(info));
+ }
+ }
+
+ /**
+ * 淇濆瓨鐗╁搧淇℃伅
+ *
+ * @param info
+ * @throws DAOException
+ */
+ @Override
+ public void saveResourceStoreInfo(Map info) throws DAOException {
+ logger.debug("淇濆瓨鐗╁搧淇℃伅鍏ュ弬 info : {}", info);
+ int saveFlag = sqlSessionTemplate.insert("resourceResourceStoreServiceDaoImpl.saveResourceStoreInfo", info);
+ if (saveFlag < 1) {
+ throw new DAOException(ResponseConstant.RESULT_PARAM_ERROR, "淇濆瓨鐗╁搧淇℃伅鏁版嵁澶辫触锛�" + JSONObject.toJSONString(info));
}
}
@@ -88,9 +98,7 @@
@Override
public List<Map> getResourceStoreInfo(Map info) throws DAOException {
logger.debug("鏌ヨ璧勬簮淇℃伅 鍏ュ弬 info : {}", info);
-
List<Map> businessResourceStoreInfos = sqlSessionTemplate.selectList("resourceResourceStoreServiceDaoImpl.getResourceStoreInfo", info);
-
return businessResourceStoreInfos;
}
@@ -102,14 +110,10 @@
* @throws DAOException DAO寮傚父
*/
@Override
- public void updateResourceStoreInfoInstance(Map info) throws DAOException {
+ public int updateResourceStoreInfoInstance(Map info) throws DAOException {
logger.debug("淇敼璧勬簮淇℃伅Instance 鍏ュ弬 info : {}", info);
-
int saveFlag = sqlSessionTemplate.update("resourceResourceStoreServiceDaoImpl.updateResourceStoreInfoInstance", info);
-
- if (saveFlag < 1) {
- throw new DAOException(ResponseConstant.RESULT_PARAM_ERROR, "淇敼璧勬簮淇℃伅Instance鏁版嵁澶辫触锛�" + JSONObject.toJSONString(info));
- }
+ return saveFlag;
}
/**
@@ -121,14 +125,28 @@
@Override
public int queryResourceStoresCount(Map info) {
logger.debug("鏌ヨ璧勬簮鏁版嵁 鍏ュ弬 info : {}", info);
-
List<Map> businessResourceStoreInfos = sqlSessionTemplate.selectList("resourceResourceStoreServiceDaoImpl.queryResourceStoresCount", info);
if (businessResourceStoreInfos.size() < 1) {
return 0;
}
-
return Integer.parseInt(businessResourceStoreInfos.get(0).get("count").toString());
}
+ /**
+ * 鏌ヨ璧勬簮鎬讳环
+ *
+ * @param info 璧勬簮淇℃伅
+ * @return 璧勬簮鏁伴噺
+ */
+ @Override
+ public String queryResourceStoresTotalPrice(Map info) {
+ logger.debug("鏌ヨ璧勬簮鏁版嵁 鍏ュ弬 info : {}", info);
+ List<Map> businessResourceStoreInfos = sqlSessionTemplate.selectList("resourceResourceStoreServiceDaoImpl.queryResourceStoresTotalPrice", info);
+ if (businessResourceStoreInfos == null || businessResourceStoreInfos.size() < 1) {
+ return "0";
+ }
+ return businessResourceStoreInfos.get(0).get("totalPrice").toString();
+ }
+
}
--
Gitblit v1.8.0