整合代码

chenshijun

2019-03-15 684b55231257011c11caacc5ae72b0f0977c6114

 QiaoJiaSystem/DataManagerServer/vss/dao/CamDevSqliteDao.h

@@ -4,6 +4,7 @@

#include "../model/CamDev.h"
#include "BaseSqliteDao.h"
#include <qsqlfield.h>

#define CamDev_TABLE_NAME "cam_dev"

@@ -26,6 +27,14 @@
        Json::Value responseJsonValue;
        responseJsonValue["message"] = "添加失败！";
        responseJsonValue["success"] = "false";

        std::map<std::string, std::string> whereKeyValues;
        whereKeyValues["cam_dev_id"] = keyValuesToAdd["cam_dev_id"];
        if (this->findCamDevList(whereKeyValues)["data"].size() > 0) {
            responseJsonValue["message"] = "cam_dev_id exist！";
            return responseJsonValue;
        }

        QMutexLocker mutexLocker(m_mutexVisit);//TODO
        QSqlTableModel pModel(NULL, *m_db);

@@ -39,11 +48,11 @@
        rec.setGenerated("id", false);

        pModel.insertRecord(-1, rec);//TODO

        m_db->transaction();//开始事务操作

        auto id1 = pModel.query().lastInsertId();
        if (pModel.submitAll()) {
            m_db->commit();//提交
            responseJsonValue["id"] = pModel.query().lastInsertId().toString().toStdString();
            responseJsonValue["success"] = "true";
            responseJsonValue["message"] = "添加成功！";
        } else {
@@ -71,8 +80,9 @@
        QMutexLocker mutexLocker(m_mutexVisit);//TODO
        QSqlTableModel pModel(NULL, *m_db);
        pModel.setTable(CamDev_TABLE_NAME);
        for (auto whereKeyValue : whereKeyValues ) {
            pModel.setFilter(QObject::tr((string(whereKeyValue.first)+" = '%1'").c_str()).arg(QString::fromUtf8(whereKeyValue.second.c_str())));
        if (whereKeyValues.size() > 0) {
            auto filter = QObject::tr((string(" 1=1 ")+getWhereColumnNameValuePair(whereKeyValues)).c_str());
            pModel.setFilter(filter);
        }
        pModel.setEditStrategy(QSqlTableModel::OnManualSubmit);//OnManualSubmit OnFieldChange
        pModel.select();
@@ -110,8 +120,9 @@
        QMutexLocker mutexLocker(m_mutexVisit);//TODO
        QSqlTableModel pModel(NULL, *m_db);
        pModel.setTable(CamDev_TABLE_NAME);
        for (auto whereKeyValue : whereKeyValues) {
            pModel.setFilter(QObject::tr((whereKeyValue.first + " = '%1'").c_str()).arg(QString::fromStdString(whereKeyValue.second)));
        if (whereKeyValues.size() > 0) {
            auto filter = QObject::tr((string(" 1=1 ")+getWhereColumnNameValuePair(whereKeyValues)).c_str());
            pModel.setFilter(filter);
        }
        pModel.setEditStrategy(QSqlTableModel::OnManualSubmit);//OnManualSubmit OnFieldChange
        pModel.select();
@@ -172,8 +183,9 @@
        std::list<Record_Cut_Video_info> lst;
        QSqlTableModel pModel(NULL, *m_db);
        pModel.setTable(CamDev_TABLE_NAME);;
        for (auto whereKeyValue : whereKeyValues ) {
            pModel.setFilter(QObject::tr((string(whereKeyValue.first)+" = '%1'").c_str()).arg(QString::fromUtf8(whereKeyValue.second.c_str())));
        if (whereKeyValues.size() > 0) {
            auto filter = QObject::tr((string(" 1=1 ")+getWhereColumnNameValuePair(whereKeyValues)).c_str());
            pModel.setFilter(filter);
        }
        pModel.setEditStrategy(QSqlTableModel::OnManualSubmit);//OnManualSubmit OnFieldChange
        pModel.select();