From c56015c5c73861b5f794cac48064d0394f8fd37d Mon Sep 17 00:00:00 2001
From: pansen <pansen626@sina.com>
Date: 星期二, 02 四月 2019 15:48:39 +0800
Subject: [PATCH] 对抓拍记录的picMaxUrl字段赋值(大图路径)

---
 QiaoJiaSystem/DataManagerServer/vss/dao/VssDevTblDao.h |   21 +++++++++++++++++++++
 1 files changed, 21 insertions(+), 0 deletions(-)

diff --git a/QiaoJiaSystem/DataManagerServer/vss/dao/VssDevTblDao.h b/QiaoJiaSystem/DataManagerServer/vss/dao/VssDevTblDao.h
index ffcd6fe..ad688f8 100755
--- a/QiaoJiaSystem/DataManagerServer/vss/dao/VssDevTblDao.h
+++ b/QiaoJiaSystem/DataManagerServer/vss/dao/VssDevTblDao.h
@@ -3,7 +3,9 @@
 #define VSSDEVTBL_MANAGER_H
 
 #include "../model/VssDevTbl.h"
+#include "VssChannelTblDao.h"
 #include "BaseDao.h"
+#include "CamDevSqliteDao.h"
 
 #define VSSDevTbl_TABLE_NAME "VSSDevTbl"
 
@@ -23,6 +25,7 @@
     
     /** 娣诲姞鍒涘缓涓�绾ц澶囪〃 keyValuesToAdd 闇�瑕佹坊鍔犵殑鍒楀悕鍜屽垪鍊煎map*/
     mysqlpp::SimpleResult addVssDevTbl(std::map<std::string, std::string>& keyValuesToAdd) {
+        QMutexLocker mutexLocker(&m_mutexVisit);
         return add(keyValuesToAdd, VSSDevTbl_TABLE_NAME);
     }
     
@@ -35,12 +38,27 @@
 
     /** 鍒犻櫎鍒涘缓涓�绾ц澶囪〃 whereColumnNameValues 鍒楀悕鍜屽垪鍊煎鏉′欢 */
     bool deleteVssDevTbl(std::map<std::string, std::string>& whereKeyValues) {
+        QMutexLocker mutexLocker(&m_mutexVisit);
+        vector<map<string, string>> devRowDataList = findList(string("select * from ")
+                                                          + VSSDevTbl_TABLE_NAME + " where 1=1 "
+                                                                                   + getWhereColumnNameValuePair(whereKeyValues));
+        if (devRowDataList.size() > 0) {
+            auto DevPubID = devRowDataList.at(0)[VssDevTbl_DevPubID];
+            vector<map<string, string>> channelRowDataList = findList(string("select * from ")
+                                                                 + VSSChannelTbl_TABLE_NAME + " where 1=1 AND DevPubID='"+DevPubID+"'");
+            for (auto channelRowData : channelRowDataList) {
+                auto ChanPubID = channelRowData[VssChannelTbl_ChanPubID];
+                CamDevSqliteDao::instance()->deleteByColumn(CamDev_cam_dev_id, ChanPubID);
+            }
+            CamDevSqliteDao::instance()->deleteByColumn(CamDev_cam_dev_id, DevPubID);
+        }
         return del(VSSDevTbl_TABLE_NAME, whereKeyValues);
     }
     
     /** 鏇存柊鍒涘缓涓�绾ц澶囪〃 keyValuesToUpdate 闇�瑕佹洿鏂扮殑鍒楀悕鍜屽垪鍊煎锛� whereKeyValues 鍒楀悕鍜屽垪鍊兼潯浠� */
 	bool updateVssDevTbl(std::map<std::string, std::string>& keyValuesToUpdate, 
 									std::map<std::string, std::string>& whereKeyValues) {
+        QMutexLocker mutexLocker(&m_mutexVisit);
 		return update(keyValuesToUpdate, VSSDevTbl_TABLE_NAME, whereKeyValues);
 	}
 	
@@ -55,6 +73,7 @@
 	
 	/** 鏌ヨ鍒涘缓涓�绾ц澶囪〃鍒楄〃  querySql 瑕佹煡璇㈢殑sql璇彞 */
 	vector<VssDevTbl> findVssDevTblList(string querySql) {
+        QMutexLocker mutexLocker(&m_mutexVisit);
         vector<VssDevTbl> vssDevTblVec;
         vector<map<string, string>> rowDatList = findList(querySql);
         vssDevTblVec.reserve(rowDatList.size());
@@ -76,11 +95,13 @@
 	
 	/** 鏌ヨmap鍒楄〃 querySql 瑕佹煡璇㈢殑sql璇彞 */
 	vector<map<string, string>> findMapList(string querySql) {
+        QMutexLocker mutexLocker(&m_mutexVisit);
 		return findList(querySql);
 	}
     
     /** 鎵цsql璇彞 */
     bool execute(string sql) {
+        QMutexLocker mutexLocker(&m_mutexVisit);
         return exec(move(sql));
     }
     

--
Gitblit v1.8.0