| | |
|---|
| | | #define VSSDEVTBL_MANAGER_H
|
|---|
| | |
|
|---|
| | | #include "../model/VssDevTbl.h"
|
|---|
| | | #include "VssChannelTblDao.h"
|
|---|
| | | #include "BaseDao.h"
|
|---|
| | | #include "CamDevSqliteDao.h"
|
|---|
| | |
|
|---|
| | | #define VSSDevTbl_TABLE_NAME "VSSDevTbl"
|
|---|
| | |
|
|---|
| | |
|---|
| | | /** 删除创建一级设备表 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);
|
|---|
| | | }
|
|---|
| | |
|
|---|
