#include "mainwindow.h"
#include "ui_mainwindow.h"
#include "insertsensor.h"

MainWindow::MainWindow(QWidget *parent) :
    QMainWindow(parent),
    ui(new Ui::MainWindow)
{
    ui->setupUi(this);
    //显示查询的结果
    QString name=ui->namelineEdit->text();//收件人姓名
    tel=ui->tellineEdit->text();//获取电话信息
    QString danhao=ui->numlineEdit->text();//获取单号信息
    QSqlQueryModel *model = new QSqlQueryModel;
    QSqlQueryModel *model = new QSqlQueryModel(ui->tableView);
    model->setQuery("select *from thing where thing.thing_id='"+danhao+"' "
                      "and thing.recive_pho='"+name+"'");
    model->setHeaderData(0, Qt::Horizontal, tr("订单号"));
    model->setHeaderData(1, Qt::Horizontal, tr("收件人"));
    model->setHeaderData(2, Qt::Horizontal, tr("寄件人"));
    model->setHeaderData(3, Qt::Horizontal, tr("验证码"));
    model->setHeaderData(4, Qt::Horizontal, tr("箱子号"));
    model->setHeaderData(5, Qt::Horizontal, tr("物品状态"));
    //qDebug()<<name<<danhao;
    ui->tableView->setModel(model);
    //ui->tableView->show();


    model = new QSqlTableModel(this);
    model->setTable("Sensors");
    model->setEditStrategy(QSqlTableModel::OnManualSubmit);
    model->select(); //选取整个表的所有行

    //不显示name属性列,如果这时添加记录，则该属性的值添加不上
    // model->removeColumn(1);

    ui->tableView->setModel(model);

    //使其不可编辑
    ui->tableView->setEditTriggers(QAbstractItemView::NoEditTriggers);

}

MainWindow::~MainWindow()
{
    delete ui;
}

void MainWindow::on_pushButton_4_clicked()
{
     ui->stackedWidget->setCurrentIndex(0);
}

void MainWindow::on_selectButton_clicked()
{
     ui->stackedWidget->setCurrentIndex(1);
}

void MainWindow::on_showButton_clicked()
{
     ui->stackedWidget->setCurrentIndex(2);
}
//添加传感器信息对话框
void MainWindow::on_pushButton_2_clicked()
{
    insertSensor dlg;
    if (dlg.exec() == QDialog::Accepted){

        dlg.close();
    }
}