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/PurchaseApplyDetailServiceDaoImpl.java | 51 +++++++++++++++++++++++++++------------------------
1 files changed, 27 insertions(+), 24 deletions(-)
diff --git a/service-store/src/main/java/com/java110/store/dao/impl/PurchaseApplyDetailServiceDaoImpl.java b/service-store/src/main/java/com/java110/store/dao/impl/PurchaseApplyDetailServiceDaoImpl.java
old mode 100644
new mode 100755
index 73623b5..535e094
--- a/service-store/src/main/java/com/java110/store/dao/impl/PurchaseApplyDetailServiceDaoImpl.java
+++ b/service-store/src/main/java/com/java110/store/dao/impl/PurchaseApplyDetailServiceDaoImpl.java
@@ -1,13 +1,13 @@
package com.java110.store.dao.impl;
import com.alibaba.fastjson.JSONObject;
+import com.java110.core.base.dao.BaseServiceDao;
import com.java110.store.dao.IPurchaseApplyDetailServiceDao;
import com.java110.utils.constant.ResponseConstant;
import com.java110.utils.exception.DAOException;
import com.java110.utils.util.DateUtil;
-import com.java110.core.base.dao.BaseServiceDao;
import org.slf4j.Logger;
-import org.slf4j.LoggerFactory;
+import com.java110.core.log.LoggerFactory;
import org.springframework.stereotype.Service;
import java.util.List;
@@ -25,6 +25,7 @@
/**
* 璁㈠崟鏄庣粏淇℃伅灏佽
+ *
* @param businessPurchaseApplyDetailInfo 璁㈠崟鏄庣粏淇℃伅 灏佽
* @throws DAOException DAO寮傚父
*/
@@ -32,17 +33,18 @@
public void saveBusinessPurchaseApplyDetailInfo(Map businessPurchaseApplyDetailInfo) throws DAOException {
businessPurchaseApplyDetailInfo.put("month", DateUtil.getCurrentMonth());
// 鏌ヨbusiness_user 鏁版嵁鏄惁宸茬粡瀛樺湪
- logger.debug("淇濆瓨璁㈠崟鏄庣粏淇℃伅 鍏ュ弬 businessPurchaseApplyDetailInfo : {}",businessPurchaseApplyDetailInfo);
- int saveFlag = sqlSessionTemplate.insert("purchaseApplyDetailServiceDaoImpl.saveBusinessPurchaseApplyDetailInfo",businessPurchaseApplyDetailInfo);
+ logger.debug("淇濆瓨璁㈠崟鏄庣粏淇℃伅 鍏ュ弬 businessPurchaseApplyDetailInfo : {}", businessPurchaseApplyDetailInfo);
+ int saveFlag = sqlSessionTemplate.insert("purchaseApplyDetailServiceDaoImpl.saveBusinessPurchaseApplyDetailInfo", businessPurchaseApplyDetailInfo);
- if(saveFlag < 1){
- throw new DAOException(ResponseConstant.RESULT_PARAM_ERROR,"淇濆瓨璁㈠崟鏄庣粏鏁版嵁澶辫触锛�"+ JSONObject.toJSONString(businessPurchaseApplyDetailInfo));
+ if (saveFlag < 1) {
+ throw new DAOException(ResponseConstant.RESULT_PARAM_ERROR, "淇濆瓨璁㈠崟鏄庣粏鏁版嵁澶辫触锛�" + JSONObject.toJSONString(businessPurchaseApplyDetailInfo));
}
}
/**
* 鏌ヨ璁㈠崟鏄庣粏淇℃伅
+ *
* @param info bId 淇℃伅
* @return 璁㈠崟鏄庣粏淇℃伅
* @throws DAOException DAO寮傚父
@@ -50,43 +52,44 @@
@Override
public List<Map> getBusinessPurchaseApplyDetailInfo(Map info) throws DAOException {
- logger.debug("鏌ヨ璁㈠崟鏄庣粏淇℃伅 鍏ュ弬 info : {}",info);
+ logger.debug("鏌ヨ璁㈠崟鏄庣粏淇℃伅 鍏ュ弬 info : {}", info);
- List<Map> businessPurchaseApplyDetailInfos = sqlSessionTemplate.selectList("purchaseApplyDetailServiceDaoImpl.getBusinessPurchaseApplyDetailInfo",info);
+ List<Map> businessPurchaseApplyDetailInfos = sqlSessionTemplate.selectList("purchaseApplyDetailServiceDaoImpl.getBusinessPurchaseApplyDetailInfo", info);
return businessPurchaseApplyDetailInfos;
}
-
/**
* 淇濆瓨璁㈠崟鏄庣粏淇℃伅 鍒� instance
- * @param info bId 淇℃伅
+ *
+ * @param info bId 淇℃伅
* @throws DAOException DAO寮傚父
*/
@Override
public void savePurchaseApplyDetailInfoInstance(Map info) throws DAOException {
- logger.debug("淇濆瓨璁㈠崟鏄庣粏淇℃伅Instance 鍏ュ弬 info : {}",info);
+ logger.debug("淇濆瓨璁㈠崟鏄庣粏淇℃伅Instance 鍏ュ弬 info : {}", info);
- int saveFlag = sqlSessionTemplate.insert("purchaseApplyDetailServiceDaoImpl.savePurchaseApplyDetailInfoInstance",info);
+ int saveFlag = sqlSessionTemplate.insert("purchaseApplyDetailServiceDaoImpl.savePurchaseApplyDetailInfoInstance", info);
- if(saveFlag < 1){
- throw new DAOException(ResponseConstant.RESULT_PARAM_ERROR,"淇濆瓨璁㈠崟鏄庣粏淇℃伅Instance鏁版嵁澶辫触锛�"+ JSONObject.toJSONString(info));
+ if (saveFlag < 1) {
+ throw new DAOException(ResponseConstant.RESULT_PARAM_ERROR, "淇濆瓨璁㈠崟鏄庣粏淇℃伅Instance鏁版嵁澶辫触锛�" + JSONObject.toJSONString(info));
}
}
/**
* 鏌ヨ璁㈠崟鏄庣粏淇℃伅锛坕nstance锛�
+ *
* @param info bId 淇℃伅
* @return List<Map>
* @throws DAOException DAO寮傚父
*/
@Override
public List<Map> getPurchaseApplyDetailInfo(Map info) throws DAOException {
- logger.debug("鏌ヨ璁㈠崟鏄庣粏淇℃伅 鍏ュ弬 info : {}",info);
+ logger.debug("鏌ヨ璁㈠崟鏄庣粏淇℃伅 鍏ュ弬 info : {}", info);
- List<Map> businessPurchaseApplyDetailInfos = sqlSessionTemplate.selectList("purchaseApplyDetailServiceDaoImpl.getPurchaseApplyDetailInfo",info);
+ List<Map> businessPurchaseApplyDetailInfos = sqlSessionTemplate.selectList("purchaseApplyDetailServiceDaoImpl.getPurchaseApplyDetailInfo", info);
return businessPurchaseApplyDetailInfos;
}
@@ -94,28 +97,28 @@
/**
* 淇敼璁㈠崟鏄庣粏淇℃伅
+ *
* @param info 淇敼淇℃伅
* @throws DAOException DAO寮傚父
*/
@Override
- public void updatePurchaseApplyDetailInfoInstance(Map info) throws DAOException {
- logger.debug("淇敼璁㈠崟鏄庣粏淇℃伅Instance 鍏ュ弬 info : {}",info);
+ public int updatePurchaseApplyDetailInfoInstance(Map info) throws DAOException {
+ logger.debug("淇敼璁㈠崟鏄庣粏淇℃伅Instance 鍏ュ弬 info : {}", info);
- int saveFlag = sqlSessionTemplate.update("purchaseApplyDetailServiceDaoImpl.updatePurchaseApplyDetailInfoInstance",info);
+ int saveFlag = sqlSessionTemplate.update("purchaseApplyDetailServiceDaoImpl.updatePurchaseApplyDetailInfoInstance", info);
- if(saveFlag < 1){
- throw new DAOException(ResponseConstant.RESULT_PARAM_ERROR,"淇敼璁㈠崟鏄庣粏淇℃伅Instance鏁版嵁澶辫触锛�"+ JSONObject.toJSONString(info));
- }
+ return saveFlag;
}
- /**
+ /**
* 鏌ヨ璁㈠崟鏄庣粏鏁伴噺
+ *
* @param info 璁㈠崟鏄庣粏淇℃伅
* @return 璁㈠崟鏄庣粏鏁伴噺
*/
@Override
public int queryPurchaseApplyDetailsCount(Map info) {
- logger.debug("鏌ヨ璁㈠崟鏄庣粏鏁版嵁 鍏ュ弬 info : {}",info);
+ logger.debug("鏌ヨ璁㈠崟鏄庣粏鏁版嵁 鍏ュ弬 info : {}", info);
List<Map> businessPurchaseApplyDetailInfos = sqlSessionTemplate.selectList("purchaseApplyDetailServiceDaoImpl.queryPurchaseApplyDetailsCount", info);
if (businessPurchaseApplyDetailInfos.size() < 1) {
--
Gitblit v1.8.0