From 7e3a731b960455b16016c3c4e2e727caa8190bb0 Mon Sep 17 00:00:00 2001
From: java110 <928255095@qq.com>
Date: 星期一, 01 六月 2020 12:03:04 +0800
Subject: [PATCH] 优化查询小区多条是报错问题
---
CommunityService/src/main/java/com/java110/community/dao/impl/UnitServiceDaoImpl.java | 52 ++++++++++++++++++++++++++++++++++++++++++++++++----
1 files changed, 48 insertions(+), 4 deletions(-)
diff --git a/CommunityService/src/main/java/com/java110/community/dao/impl/UnitServiceDaoImpl.java b/CommunityService/src/main/java/com/java110/community/dao/impl/UnitServiceDaoImpl.java
index 4555245..0a1b59c 100644
--- a/CommunityService/src/main/java/com/java110/community/dao/impl/UnitServiceDaoImpl.java
+++ b/CommunityService/src/main/java/com/java110/community/dao/impl/UnitServiceDaoImpl.java
@@ -1,9 +1,9 @@
package com.java110.community.dao.impl;
import com.alibaba.fastjson.JSONObject;
-import com.java110.common.constant.ResponseConstant;
-import com.java110.common.exception.DAOException;
-import com.java110.common.util.DateUtil;
+import com.java110.utils.constant.ResponseConstant;
+import com.java110.utils.exception.DAOException;
+import com.java110.utils.util.DateUtil;
import com.java110.community.dao.IUnitServiceDao;
import com.java110.core.base.dao.BaseServiceDao;
import org.slf4j.Logger;
@@ -21,7 +21,7 @@
//@Transactional
public class UnitServiceDaoImpl extends BaseServiceDao implements IUnitServiceDao {
- private static Logger logger = LoggerFactory.getLogger(UnitServiceDaoImpl.class);
+ private static Logger logger = LoggerFactory.getLogger(UnitServiceDaoImpl.class);
/**
* 灏忓尯鍗曞厓淇℃伅灏佽
@@ -112,5 +112,49 @@
}
}
+ /**
+ * 鏌ヨ灏忓尯鍗曞厓鏁伴噺
+ *
+ * @param info 灏忓尯鍗曞厓淇℃伅
+ * @return 灏忓尯鍗曞厓鏁伴噺
+ */
+ @Override
+ public int queryUnitsCount(Map info) {
+ logger.debug("鏌ヨ灏忓尯鍗曞厓鏁版嵁 鍏ュ弬 info : {}", info);
+
+ List<Map> businessUnitInfos = sqlSessionTemplate.selectList("unitServiceDaoImpl.queryUnitsCount", info);
+ if (businessUnitInfos.size() < 1) {
+ return 0;
+ }
+
+ return Integer.parseInt(businessUnitInfos.get(0).get("count").toString());
+ }
+
+
+ @Override
+ public List<Map> queryUnitsByCommunityId(Map info) {
+ logger.debug("鏌ヨqueryUnitsByCommunityId鏁版嵁 鍏ュ弬 info : {}", info);
+
+ List<Map> units = sqlSessionTemplate.selectList("unitServiceDaoImpl.queryUnitsByCommunityId", info);
+
+ return units;
+ }
+
+ /**
+ * 鏌ヨ灏忓尯鍗曞厓淇℃伅锛坕nstance锛�
+ *
+ * @param info bId 淇℃伅
+ * @return
+ * @throws DAOException
+ */
+ @Override
+ public List<Map> getFloorAndUnitInfo(Map info) throws DAOException {
+ logger.debug("鏌ヨ灏忓尯鍗曞厓淇℃伅 鍏ュ弬 info : {}", info);
+
+ List<Map> businessUnitInfos = sqlSessionTemplate.selectList("unitServiceDaoImpl.getFloorAndUnitInfo", info);
+
+ return businessUnitInfos;
+ }
+
}
--
Gitblit v1.8.0