848,6 → 848,10 |
} |
filter_model->submitAll(); |
// getDatabaseData(); |
model_is_build = false; |
MainWindow::readModels(); |
model_is_build = true; |
MainWindow::getDatabaseData(); |
|
} |
|
856,6 → 860,11 |
filter_model->submitAll(); |
ui->pushButton_11->setEnabled(false); |
ui->pushButton_12->setEnabled(false); |
|
model_is_build = false; |
MainWindow::readModels(); |
model_is_build = true; |
MainWindow::getDatabaseData(); |
} |
|
void MainWindow::on_pushButton_12_clicked()// íàæàòèå êíîïêè "Ñáðîñèòü èçìåíåíèÿ" (íà âêëàäêå ôèëüòðîâ) |
1229,6 → 1238,7 |
|
|
rootItems.clear(); |
root_items_list.clear(); |
ui->treeWidget->clear(); |
for (int i=0; i < row; i++){ |
QTreeWidgetItem * item_tmp; |
1369,3 → 1379,57 |
} |
return result_map; |
} |
|
|
|
|
QString MainWindow::getFiltrString(QString model_id, QString class_id){ // ïîëó÷àåì ñòðîêó-ôèëüòð äëÿ äàííîãî êëàññà äàííîé ìîäåëè |
|
QSqlQuery q; |
QString sql_str; |
QString result_str; |
sql_str = tr("select * from `Filters` where `Filters`.`Model_ID` = '"); |
sql_str.append(model_id); |
sql_str.append(tr("' and `Filters`.`Class_ID` = '")); |
sql_str.append(class_id); |
sql_str.append(tr("' order by `Filters`.`ID`")); |
bool ok; |
ok = q.prepare(sql_str); |
ok = q.exec(); |
|
if (!ok) { |
QMessageBox::critical( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå. |
this, // Ðîäèòåëüñêèé âèäæåò. |
QObject::tr("Database Error"), // Çàãîëîâîê. |
q.lastError().text()); // Òåêñò ñîîáùåíèÿ. |
return result_str; |
} |
result_str.clear(); |
while(q.next()){ |
QString Condition, FieldName, ConditionalSymbol, ValueForComparison, PostCondition; |
Condition = q.record().value(3).toString(); |
FieldName = q.record().value(4).toString(); |
ConditionalSymbol = q.record().value(5).toString(); |
ValueForComparison = q.record().value(6).toString(); |
PostCondition = q.record().value(7).toString(); |
|
|
result_str.append(Condition); |
result_str.append(tr(" ")); |
result_str.append(FieldName); |
result_str.append(tr(" ")); |
result_str.append(ConditionalSymbol); |
result_str.append(tr(" ")); |
result_str.append(ValueForComparison); |
result_str.append(tr(" ")); |
result_str.append(PostCondition); |
|
|
} |
|
|
return result_str; |
|
} |
|
|