jia_tan_diyic/handle/database.h

#ifndef DATABASE_H
#define DATABASE_H

#include <QDebug>
#include <QSqlDatabase>
#include <QSqlError>
#include <QSqlQuery>
#include <QSqlTableModel>

struct product_data
{
    int goods_id;
    QString code_single;
    int quantity;
    QString batch_no;
    QString category;
    int level_id;
    int tube_number;
    int gross_weight;
    int net_weight;
    QString machine_no;
    QString packing_time;
    QString packing_type;
    QString carton_type;
    int operator_id;
    QString specs;
    QString denier;
    QString dtex;
    QString fiber;
    QString remark;
};

struct details_data
{
    QString code_single;
    QString case_number;
    int box_weight;
    int tube_number;
    int bucket_weight;
    int gross_weight;
    int net_weight;
    QString sort;
    QString remark;
};

class Database : public QObject
{
    Q_OBJECT
public:
    explicit Database(QObject *parent = 0);
    ~Database();
//    void connectDB(QString dbName, QString username, QString password);
//    void insertData();
//    void deleteData();
    void SetTableName(QString table);
    bool openDB();
    bool createProductDatabase();
    bool createDetailsDatabase();
//    bool insert(QString &table, QStringList &names, QStringList &values);
    bool update(QString &table, QStringList &names, QStringList &values, QString &expression);
    bool del(QString &table, QString &expression);
    QList<QMap<QString,QString>> GetValues(QString table, QStringList &values,QString condition = "");
    QStringList GetValuesList(QString table, QString value,QString condition = "");
    int GetTablePage();

    bool insertProduct(product_data productData);
    bool insertDetails(details_data detailsData);
    bool changeState(QString xianghao);



private:
    QSqlDatabase _database;
    QSqlTableModel *model;
    QString _tableName;
    QList<QMap<QString,QString>> dbmxlist;
    QMap<QString,QString> dbmxdata;
};

#endif // DATABASE_H