RegCashLinux/dbutility.h at develop · lemoeb/RegCashLinux · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
#ifndef DBUTILITY_H
#define DBUTILITY_H

#include <QtSql>
#include <QFileInfo>
#include <QSqlError>
#include <QDebug>
#include "customtable.h"
#include "azioni.h"
#include "errori.h"

class dbUtility
{
public:
    dbUtility();

    bool dbConnectMySql(QString,QString,QString,QString);
    bool dbConnectSqlite(void);

    QSqlQuery ricercaArticolo(QString);
    QSqlQuery recuperaSconti(void);
    int recuperaScontoSpecifico(int);
    bool salvaSconti(int,int,int,int,int);

    int chiudiScontrino(float,int,customTable *,QString *,QString *);
    int salvaArticolo (QString,QString ,float, int,int);
    QSqlQuery report(QString *,int *,int,QString,QString,int,QString,int,int,int);

private:
    QSqlDatabase db;// = QSqlDatabase::database();
    int dbType;
};

#endif // DBUTILITY_H