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/IRoomServiceDao.java |   66 ++++++++++++++++++++++++++++++++
 1 files changed, 65 insertions(+), 1 deletions(-)

diff --git a/CommunityService/src/main/java/com/java110/community/dao/IRoomServiceDao.java b/CommunityService/src/main/java/com/java110/community/dao/IRoomServiceDao.java
index 17ba9f4..08f2ab2 100644
--- a/CommunityService/src/main/java/com/java110/community/dao/IRoomServiceDao.java
+++ b/CommunityService/src/main/java/com/java110/community/dao/IRoomServiceDao.java
@@ -1,7 +1,7 @@
 package com.java110.community.dao;
 
 
-import com.java110.common.exception.DAOException;
+import com.java110.utils.exception.DAOException;
 
 import java.util.List;
 import java.util.Map;
@@ -72,4 +72,68 @@
      */
     int queryRoomsCount(Map info);
 
+    /**
+     * 鏌ヨ灏忓尯鎴垮眿鎬绘暟
+     *
+     * @param info 灏忓尯鎴垮眿淇℃伅
+     * @return 灏忓尯鎴垮眿鏁伴噺
+     */
+    int queryRoomsByCommunityIdCount(Map info);
+
+    /**
+     * 鏌ヨ灏忓尯鎴垮眿锛堟湭閿�鍞級鎬绘暟
+     *
+     * @param info 灏忓尯鎴垮眿淇℃伅
+     * @return 灏忓尯鎴垮眿鏁伴噺
+     */
+    int queryRoomsWithOutSellByCommunityIdCount(Map info);
+
+    /**
+     * 鏌ヨ灏忓尯鎴垮眿锛堟湭閿�鍞級鎬绘暟
+     *
+     * @param info 灏忓尯鎴垮眿淇℃伅
+     * @return 灏忓尯鎴垮眿鏁伴噺
+     */
+    int queryRoomsWithSellByCommunityIdCount(Map info);
+
+
+    /**
+     * 鏌ヨ灏忓尯鎴垮眿淇℃伅
+     * 鏍规嵁bId 鏌ヨ灏忓尯鎴垮眿淇℃伅
+     *
+     * @param info bId 淇℃伅
+     * @return 灏忓尯鎴垮眿淇℃伅
+     */
+    List<Map> getRoomInfoByCommunityId(Map info);
+
+
+    /**
+     * 鏍规嵁涓氫富鏌ヨ灏忓尯鎴垮眿淇℃伅
+     * 鏍规嵁bId 鏌ヨ灏忓尯鎴垮眿淇℃伅
+     *
+     * @param info bId 淇℃伅
+     * @return 灏忓尯鎴垮眿淇℃伅
+     */
+    List<Map> getRoomInfoByOwner(Map info);
+
+
+    /**
+     * 鏌ヨ灏忓尯鎴垮眿淇℃伅
+     * 鏍规嵁bId 鏌ヨ灏忓尯鎴垮眿淇℃伅
+     *
+     * @param info bId 淇℃伅
+     * @return 灏忓尯鎴垮眿淇℃伅
+     */
+    List<Map> getRoomInfoWithOutSellByCommunityId(Map info);
+
+
+    /**
+     * 鏌ヨ灏忓尯鎴垮眿淇℃伅
+     * 鏍规嵁bId 鏌ヨ灏忓尯鎴垮眿淇℃伅
+     *
+     * @param info bId 淇℃伅
+     * @return 灏忓尯鎴垮眿淇℃伅
+     */
+    List<Map> getRoomInfoWithSellByCommunityId(Map info);
+
 }

--
Gitblit v1.8.0