From 3143aab798b6ea93a472a6b32f69a6aabc7da04e Mon Sep 17 00:00:00 2001 From: pansen <pansen626@sina.com> Date: 星期五, 08 三月 2019 16:28:25 +0800 Subject: [PATCH] Merge branch 'yw.1.2.fixbug' of ssh://192.168.1.226:29418/development/c++ into yw.1.2 --- QiaoJiaSystem/DataManagerServer/vss/dao/VssDevTblDao.h | 15 +++++++++++++++ 1 files changed, 15 insertions(+), 0 deletions(-) diff --git a/QiaoJiaSystem/DataManagerServer/vss/dao/VssDevTblDao.h b/QiaoJiaSystem/DataManagerServer/vss/dao/VssDevTblDao.h index 87b5963..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" @@ -37,6 +39,19 @@ /** 鍒犻櫎鍒涘缓涓�绾ц澶囪〃 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); } -- Gitblit v1.8.0