From d3b7bbe7102cd089680a828f5d8f6402c8cf6342 Mon Sep 17 00:00:00 2001 From: pansen <pansen626@sina.com> Date: 星期四, 07 三月 2019 14:43:28 +0800 Subject: [PATCH] GB28181集成完成,集成推流模块 --- QiaoJiaSystem/DataManagerServer/vss/dao/VssDomainUnitTblDao.h | 260 ++++++++++++++++++++++++++-------------------------- 1 files changed, 130 insertions(+), 130 deletions(-) diff --git a/QiaoJiaSystem/DataManagerServer/vss/dao/VssDomainUnitTblDao.h b/QiaoJiaSystem/DataManagerServer/vss/dao/VssDomainUnitTblDao.h index 42cec10..d915bf3 100755 --- a/QiaoJiaSystem/DataManagerServer/vss/dao/VssDomainUnitTblDao.h +++ b/QiaoJiaSystem/DataManagerServer/vss/dao/VssDomainUnitTblDao.h @@ -1,130 +1,130 @@ - -#ifndef VSSDOMAINUNITTBL_MANAGER_H -#define VSSDOMAINUNITTBL_MANAGER_H - -#include "../model/VssDomainUnitTbl.h" -#include "BaseDao.h" - -#define VSSDomainUnitTbl_TABLE_NAME "VSSDomainUnitTbl" - -/** - * 鍒涘缓涓�绾ц澶囪〃绠$悊绫� - */ -class VssDomainUnitTblDao : public BaseDao { -private: - /** 鍒涘缓涓�绾ц澶囪〃鏋勯�犲嚱鏁� */ - VssDomainUnitTblDao() {} -public: - /** 鍒涘缓涓�绾ц澶囪〃鍗曚緥妯″紡 */ - static VssDomainUnitTblDao* instance() { - static VssDomainUnitTblDao instance; - return &instance; - } - - /** 娣诲姞鍒涘缓涓�绾ц澶囪〃 keyValuesToAdd 闇�瑕佹坊鍔犵殑鍒楀悕鍜屽垪鍊煎map*/ - mysqlpp::SimpleResult addVssDomainUnitTbl(std::map<std::string, std::string>& keyValuesToAdd) { - return add(keyValuesToAdd, VSSDomainUnitTbl_TABLE_NAME); - } - - /** 鍒犻櫎鍒涘缓涓�绾ц澶囪〃 whereKey 鍒楀悕锛泈hereValue 鍒楀�� */ - bool deleteByColumn(string whereKey, string whereValue) { - std::map<std::string, std::string> whereKeyValues; - whereKeyValues[whereKey] = whereValue; - return deleteVssDomainUnitTbl(whereKeyValues); - } - - /** 鍒犻櫎鍒涘缓涓�绾ц澶囪〃 whereColumnNameValues 鍒楀悕鍜屽垪鍊煎鏉′欢 */ - bool deleteVssDomainUnitTbl(std::map<std::string, std::string>& whereKeyValues) { - return del(VSSDomainUnitTbl_TABLE_NAME, whereKeyValues); - } - - /** 鏇存柊鍒涘缓涓�绾ц澶囪〃 keyValuesToUpdate 闇�瑕佹洿鏂扮殑鍒楀悕鍜屽垪鍊煎锛� whereKeyValues 鍒楀悕鍜屽垪鍊兼潯浠� */ - bool updateVssDomainUnitTbl(std::map<std::string, std::string>& keyValuesToUpdate, - std::map<std::string, std::string>& whereKeyValues) { - return update(keyValuesToUpdate, VSSDomainUnitTbl_TABLE_NAME, whereKeyValues); - } - - /** 鏇存柊鍒涘缓浜岀骇璁惧琛� keyValuesToUpdate 闇�瑕佹洿鏂扮殑鍒楀悕鍜屽垪鍊煎锛� whereKeyValues 鍒楀悕鍜屽垪鍊兼潯浠� */ - bool updateVssDomainUnitTbl(std::map<std::string, std::string>& keyValuesToUpdate, - string whereKey, - string whereValue) { - std::map<std::string, std::string> whereKeyValues; - whereKeyValues[whereKey] = whereValue; - return update(keyValuesToUpdate, VSSDomainUnitTbl_TABLE_NAME, whereKeyValues); - } - - /** 鏌ヨ鍒涘缓涓�绾ц澶囪〃鍒楄〃 querySql 瑕佹煡璇㈢殑sql璇彞 */ - vector<VssDomainUnitTbl> findVssDomainUnitTblList(string querySql) { - vector<VssDomainUnitTbl> vssDomainUnitTblVec; - vector<map<string, string>> rowDatList = findList(querySql); - vssDomainUnitTblVec.reserve(rowDatList.size()); - for (auto rowData : rowDatList) { - vssDomainUnitTblVec.emplace_back(mapToModel(rowData)); - } - return vssDomainUnitTblVec; - } - - /**鏌ヨ鍒涘缓涓�绾ц澶囪〃鍒楄〃 whereKeyValues 鍒楀悕鍜屽垪鍊煎鏉′欢 */ - vector<VssDomainUnitTbl> findVssDomainUnitTblList(std::map<std::string, std::string>& whereKeyValues) { - return findVssDomainUnitTblList(string("select * from ") + VSSDomainUnitTbl_TABLE_NAME + " where 1=1 " + getWhereColumnNameValuePair(whereKeyValues)); - } - - /**鏌ヨ鎵�鏈夊垱寤轰竴绾ц澶囪〃鍒楄〃 */ - vector<VssDomainUnitTbl> findAllVssDomainUnitTblList() { - return findVssDomainUnitTblList(string("select * from ") + VSSDomainUnitTbl_TABLE_NAME + " where 1=1 "); - } - - /** 鏌ヨmap鍒楄〃 querySql 瑕佹煡璇㈢殑sql璇彞 */ - vector<map<string, string>> findMapList(string querySql) { - return findList(querySql); - } - - /** 鎵цsql璇彞 */ - bool execute(string sql) { - return exec(move(sql)); - } - - /** map杞琺odel绫� */ - VssDomainUnitTbl mapToModel(map<string, string>& rowData) { - VssDomainUnitTbl vssDomainUnitTbl; - string IDValue = rowData[VssDomainUnitTbl_ID]; - if (IDValue.length() != 0 && IDValue != "NULL") { - vssDomainUnitTbl.ID = std::stoi(IDValue); - } - string DevPubIDValue = rowData[VssDomainUnitTbl_DevPubID]; - if (DevPubIDValue.length() != 0 && DevPubIDValue != "NULL") { - vssDomainUnitTbl.DevPubID = DevPubIDValue; - } - string DomainPubIDValue = rowData[VssDomainUnitTbl_DomainPubID]; - if (DomainPubIDValue.length() != 0 && DomainPubIDValue != "NULL") { - vssDomainUnitTbl.DomainPubID = DomainPubIDValue; - } - string NameValue = rowData[VssDomainUnitTbl_Name]; - if (NameValue.length() != 0 && NameValue != "NULL") { - vssDomainUnitTbl.Name = NameValue; - } - string BusinessGroupIDValue = rowData[VssDomainUnitTbl_BusinessGroupID]; - if (BusinessGroupIDValue.length() != 0 && BusinessGroupIDValue != "NULL") { - vssDomainUnitTbl.BusinessGroupID = BusinessGroupIDValue; - } - string ParentIdValue = rowData[VssDomainUnitTbl_ParentId]; - if (ParentIdValue.length() != 0 && ParentIdValue != "NULL") { - vssDomainUnitTbl.ParentId = ParentIdValue; - } - string DomainTypeValue = rowData[VssDomainUnitTbl_DomainType]; - if (DomainTypeValue.length() != 0 && DomainTypeValue != "NULL") { - vssDomainUnitTbl.DomainType = std::stoi(DomainTypeValue); - } - string UpdateTimeValue = rowData[VssDomainUnitTbl_UpdateTime]; - if (UpdateTimeValue.length() != 0 && UpdateTimeValue != "NULL") { - vssDomainUnitTbl.UpdateTime = UpdateTimeValue; - } - return vssDomainUnitTbl; - } - -}; - - -#endif //VSSDOMAINUNITTBL_MANAGER_H - - + +#ifndef VSSDOMAINUNITTBL_MANAGER_H +#define VSSDOMAINUNITTBL_MANAGER_H + +#include "../model/VssDomainUnitTbl.h" +#include "BaseDao.h" + +#define VSSDomainUnitTbl_TABLE_NAME "VSSDomainUnitTbl" + +/** + * 鍒涘缓涓�绾ц澶囪〃绠$悊绫� + */ +class VssDomainUnitTblDao : public BaseDao { +private: + /** 鍒涘缓涓�绾ц澶囪〃鏋勯�犲嚱鏁� */ + VssDomainUnitTblDao() {} +public: + /** 鍒涘缓涓�绾ц澶囪〃鍗曚緥妯″紡 */ + static VssDomainUnitTblDao* instance() { + static VssDomainUnitTblDao instance; + return &instance; + } + + /** 娣诲姞鍒涘缓涓�绾ц澶囪〃 keyValuesToAdd 闇�瑕佹坊鍔犵殑鍒楀悕鍜屽垪鍊煎map*/ + mysqlpp::SimpleResult addVssDomainUnitTbl(std::map<std::string, std::string>& keyValuesToAdd) { + return add(keyValuesToAdd, VSSDomainUnitTbl_TABLE_NAME); + } + + /** 鍒犻櫎鍒涘缓涓�绾ц澶囪〃 whereKey 鍒楀悕锛泈hereValue 鍒楀�� */ + bool deleteByColumn(string whereKey, string whereValue) { + std::map<std::string, std::string> whereKeyValues; + whereKeyValues[whereKey] = whereValue; + return deleteVssDomainUnitTbl(whereKeyValues); + } + + /** 鍒犻櫎鍒涘缓涓�绾ц澶囪〃 whereColumnNameValues 鍒楀悕鍜屽垪鍊煎鏉′欢 */ + bool deleteVssDomainUnitTbl(std::map<std::string, std::string>& whereKeyValues) { + return del(VSSDomainUnitTbl_TABLE_NAME, whereKeyValues); + } + + /** 鏇存柊鍒涘缓涓�绾ц澶囪〃 keyValuesToUpdate 闇�瑕佹洿鏂扮殑鍒楀悕鍜屽垪鍊煎锛� whereKeyValues 鍒楀悕鍜屽垪鍊兼潯浠� */ + bool updateVssDomainUnitTbl(std::map<std::string, std::string>& keyValuesToUpdate, + std::map<std::string, std::string>& whereKeyValues) { + return update(keyValuesToUpdate, VSSDomainUnitTbl_TABLE_NAME, whereKeyValues); + } + + /** 鏇存柊鍒涘缓浜岀骇璁惧琛� keyValuesToUpdate 闇�瑕佹洿鏂扮殑鍒楀悕鍜屽垪鍊煎锛� whereKeyValues 鍒楀悕鍜屽垪鍊兼潯浠� */ + bool updateVssDomainUnitTbl(std::map<std::string, std::string>& keyValuesToUpdate, + string whereKey, + string whereValue) { + std::map<std::string, std::string> whereKeyValues; + whereKeyValues[whereKey] = whereValue; + return update(keyValuesToUpdate, VSSDomainUnitTbl_TABLE_NAME, whereKeyValues); + } + + /** 鏌ヨ鍒涘缓涓�绾ц澶囪〃鍒楄〃 querySql 瑕佹煡璇㈢殑sql璇彞 */ + vector<VssDomainUnitTbl> findVssDomainUnitTblList(string querySql) { + vector<VssDomainUnitTbl> vssDomainUnitTblVec; + vector<map<string, string>> rowDatList = findList(querySql); + vssDomainUnitTblVec.reserve(rowDatList.size()); + for (auto rowData : rowDatList) { + vssDomainUnitTblVec.emplace_back(mapToModel(rowData)); + } + return vssDomainUnitTblVec; + } + + /**鏌ヨ鍒涘缓涓�绾ц澶囪〃鍒楄〃 whereKeyValues 鍒楀悕鍜屽垪鍊煎鏉′欢 */ + vector<VssDomainUnitTbl> findVssDomainUnitTblList(std::map<std::string, std::string>& whereKeyValues) { + return findVssDomainUnitTblList(string("select * from ") + VSSDomainUnitTbl_TABLE_NAME + " where 1=1 " + getWhereColumnNameValuePair(whereKeyValues)); + } + + /**鏌ヨ鎵�鏈夊垱寤轰竴绾ц澶囪〃鍒楄〃 */ + vector<VssDomainUnitTbl> findAllVssDomainUnitTblList() { + return findVssDomainUnitTblList(string("select * from ") + VSSDomainUnitTbl_TABLE_NAME + " where 1=1 "); + } + + /** 鏌ヨmap鍒楄〃 querySql 瑕佹煡璇㈢殑sql璇彞 */ + vector<map<string, string>> findMapList(string querySql) { + return findList(querySql); + } + + /** 鎵цsql璇彞 */ + bool execute(string sql) { + return exec(move(sql)); + } + + /** map杞琺odel绫� */ + VssDomainUnitTbl mapToModel(map<string, string>& rowData) { + VssDomainUnitTbl vssDomainUnitTbl; + string IDValue = rowData[VssDomainUnitTbl_ID]; + if (IDValue.length() != 0 && IDValue != "NULL") { + vssDomainUnitTbl.ID = std::stoi(IDValue); + } + string DevPubIDValue = rowData[VssDomainUnitTbl_DevPubID]; + if (DevPubIDValue.length() != 0 && DevPubIDValue != "NULL") { + vssDomainUnitTbl.DevPubID = DevPubIDValue; + } + string DomainPubIDValue = rowData[VssDomainUnitTbl_DomainPubID]; + if (DomainPubIDValue.length() != 0 && DomainPubIDValue != "NULL") { + vssDomainUnitTbl.DomainPubID = DomainPubIDValue; + } + string NameValue = rowData[VssDomainUnitTbl_Name]; + if (NameValue.length() != 0 && NameValue != "NULL") { + vssDomainUnitTbl.Name = NameValue; + } + string BusinessGroupIDValue = rowData[VssDomainUnitTbl_BusinessGroupID]; + if (BusinessGroupIDValue.length() != 0 && BusinessGroupIDValue != "NULL") { + vssDomainUnitTbl.BusinessGroupID = BusinessGroupIDValue; + } + string ParentIdValue = rowData[VssDomainUnitTbl_ParentId]; + if (ParentIdValue.length() != 0 && ParentIdValue != "NULL") { + vssDomainUnitTbl.ParentId = ParentIdValue; + } + string DomainTypeValue = rowData[VssDomainUnitTbl_DomainType]; + if (DomainTypeValue.length() != 0 && DomainTypeValue != "NULL") { + vssDomainUnitTbl.DomainType = std::stoi(DomainTypeValue); + } + string UpdateTimeValue = rowData[VssDomainUnitTbl_UpdateTime]; + if (UpdateTimeValue.length() != 0 && UpdateTimeValue != "NULL") { + vssDomainUnitTbl.UpdateTime = UpdateTimeValue; + } + return vssDomainUnitTbl; + } + +}; + + +#endif //VSSDOMAINUNITTBL_MANAGER_H + + -- Gitblit v1.8.0