void IS::on_pushButton_clicked()
{
IS conn;
QSqlQueryModel * modal=new QSqlQueryModel();
conn.connOpen();
QSqlQuery* qry=new QSqlQuery(conn.ZOO);
if (ui->radioButton->isChecked())
{
qry->prepare("select Name, Vid, Otr, Sem, Kol from ZOO1 order by Name") ;
}
if (ui->radioButton_2->isChecked())
{
qry->prepare("select Name, Vid, Otr, Sem, Kol from ZOO1 order by Vid") ;
}
if (ui->radioButton_3->isChecked())
{
qry->prepare("select Name, Vid, Otr, Sem, Kol from ZOO1 order by Otr") ;
}
if (ui->radioButton_4->isChecked())
{
qry->prepare("select Name, Vid, Otr, Sem, Kol from ZOO1 order by Sem") ;
}
if (ui->radioButton_5->isChecked())
{
qry->prepare("select Name, Vid, Otr, Sem, Kol from ZOO1 order by Kol") ;
}
qry->exec();
modal->setQuery(*qry);
ui->tableView->setModel(modal);
conn.connClose();
qDebug() << (modal->rowCount());
on_pushButton_loadtabl_clicked();
}