Выполнение SQL запроса.

#include "pricelist.h"
#include <QSqlQuery>
#include <QString>
#include <QStringList>
#include <QVariant>
#include <QSqlTableModel>
 
...
 
QSqlQueryModel* PriceList::Search(QString model, QString type, QString man, QString cost_d, QString cost_h)
{
    QSqlQueryModel *sort = new QSqlQueryModel;
    QString request("SELECT Model FROM Price WHERE Model LIKE '*");
    request.append(model);
    request.append("*' AND Type = '");
    request.append(type);
    request.append("' AND Manufacturer = '");
    request.append(man);
    request.append("' AND Cost > ");
    request.append(cost_d);
    request.append(" AND Cost < ");
    request.append(cost_h);
 
    sort->setQuery(request);
    sort->setHeaderData(0, Qt::Horizontal, "Model");
    sort->setHeaderData(1, Qt::Horizontal, "Type");
    sort->setHeaderData(2, Qt::Horizontal, "Manufacturer");
    sort->setHeaderData(3, Qt::Horizontal, "Cost");
 
    return sort;
}

#ifndef PRICELIST_H
#define PRICELIST_H
#include <QStringList>
#include <QSqlTableModel>
#include <QSqlQueryModel>
 
class PriceList
{
    QSqlTableModel *table;
public:
    PriceList();
    ~PriceList();
 
    QStringList TypeFill();
    QStringList ManFill();
    QSqlTableModel* setModel();
    QSqlQueryModel* Search(QString, QString, QString, QString, QString);
};
 
#endif // PRICELIST_H