46 lines
2.0 KiB
C++
46 lines
2.0 KiB
C++
#ifndef SQLITEDB_H
|
|
#define SQLITEDB_H
|
|
#include <QSqlDatabase>
|
|
#include <qdebug.h>
|
|
#include <QFileDialog>
|
|
#include <QSqlError>
|
|
#include <QSqlQuery>
|
|
#include <QPluginLoader>
|
|
#include <QApplication>
|
|
#include <qlibraryinfo.h>
|
|
#include "global.h"
|
|
|
|
typedef QVector<QString> vec_t;
|
|
typedef QVector<vec_t> array_t;
|
|
|
|
class SqliteDB
|
|
{
|
|
public:
|
|
SqliteDB();
|
|
QSqlDatabase database;
|
|
int OpenDataBase();
|
|
int CloseDataBase();
|
|
int CreateDataBase();
|
|
int InsertData(QString& tablename,QString& sql);
|
|
int UpdataData(QString& tablename, QString& columnName, QString& columnValue, QString whereColName = "", QString whereColValue = "");
|
|
int UpdataDataCol(QString& tablename, QString& updateColumn, QString& whereCond);
|
|
int UpdateDataSql(QString& tablename,QString& UpdataSql);
|
|
int QueryData(QString& tablename, QString& column, QString& whereCon);
|
|
QVector<ChannelSetting> GetDataMultiLine(QString tablename, QString column = "", QString whereCon = "");
|
|
QVector<WorkConditionChannels_t> GetWorkConditionChannels(QString tablename);
|
|
QVector<WorkCondition_t> GetWorkCondition(QString tablename,QString whereCon = "");
|
|
QVector<WorkConditionInfo_t> GetWorkConditionInfo(QString tablename,QString whereCon = "");
|
|
QVector<TriggerConfig_t> GetTriggerConfig(QString tablename,QString whereCon = "");
|
|
QVector<TriggerEvent_t> GetTriggerEvent(QString tablename,QString whereCon = "");
|
|
QVector<TriggerAlarmStatusInfo_t> GetTriggerAlarmStatusInfo(QString tablename,QString whereCon = "");
|
|
QVector<UnitConfiguration_t> GetUnitConfigurationInfo(QString tablename,QString whereCon = "");
|
|
QString GetSingelLine(QString& tablename, QString& column, QString whereCon = "");
|
|
int DeleteData(QString& tablename, QString condColumnName = "", QVariant condColumnValue = "");
|
|
int DeleteDataW(QString& tablename, QString whereCon = "");
|
|
int ExeSqlData(QString& strSql);
|
|
int initTable();
|
|
|
|
};
|
|
extern SqliteDB* g_SqliteDB;
|
|
#endif // SQLITEDB_H
|