| | |
| | | private: |
| | | /** 摄像头设备构造函数 */ |
| | | CamDevSqliteDao() {} |
| | | |
| | | public: |
| | | /** 摄像头设备单例模式 */ |
| | | static CamDevSqliteDao* instance() { |
| | |
| | | |
| | | QSqlRecord rec = pModel.record(); |
| | | for (auto keyValueToAdd : keyValuesToAdd) { |
| | | rec.setValue(QString::fromUtf8(keyValueToAdd.first.c_str()), QString::fromUtf8(keyValueToAdd.second.c_str())); |
| | | rec.setValue(QString::fromUtf8(keyValueToAdd.first.c_str()), |
| | | QString::fromUtf8(keyValueToAdd.second.c_str())); |
| | | } |
| | | rec.setGenerated("id", false); |
| | | |
| | |
| | | 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()))); |
| | | pModel.setFilter(QObject::tr((string(whereKeyValue.first) + " = '%1'").c_str()).arg( |
| | | QString::fromUtf8(whereKeyValue.second.c_str()))); |
| | | } |
| | | pModel.setEditStrategy(QSqlTableModel::OnManualSubmit);//OnManualSubmit OnFieldChange |
| | | pModel.select(); |
| | |
| | | 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))); |
| | | pModel.setFilter(QObject::tr((whereKeyValue.first + " = '%1'").c_str()).arg( |
| | | QString::fromStdString(whereKeyValue.second))); |
| | | } |
| | | pModel.setEditStrategy(QSqlTableModel::OnManualSubmit);//OnManualSubmit OnFieldChange |
| | | pModel.select(); |
| | |
| | | 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()))); |
| | | pModel.setFilter(QObject::tr((string(whereKeyValue.first) + " = '%1'").c_str()).arg( |
| | | QString::fromUtf8(whereKeyValue.second.c_str()))); |
| | | } |
| | | pModel.setEditStrategy(QSqlTableModel::OnManualSubmit);//OnManualSubmit OnFieldChange |
| | | pModel.select(); |