| 476,25 → 476,37 |
|---|
| sql_mogel->select(); |
| |
| QMap <QString, QString> pointersList = getPointersList(class_id); // ïîëó÷àåì ñïèñîê ïîëåé-óêàçàòåëåé |
| QStringList dateFieldList = getDataFieldList(class_id); // ïîëó÷àåì ñïèñîê ïîëåé c òèïîì "DATE" |
| |
| QMap <int, QString> pointersToModel; |
| |
| QStringList pointersNames; |
| //QStringList pointersNames; |
| static QList<int> colomns_indexes; // ñïèñîê íîìåðîâ ñòîëáöîâ òàáëèöû ñ íåñòàíäàðòíûìè äåëåãàòàìè |
| static QList<int> date_colomns_indexes; // ñïèñîê íîìåðîâ ñòîëáöîâ òàáëèöû ñ äåëåãàòàìè äëÿ òèïà "DATE" |
| static QList<SpinBoxDelegate *> spin_delegate_list;// ñïèñîê óêàçàòåëåé íà íåñòàíäàðòíûå äåëåãàòû |
| SpinBoxDelegate * spin_delegate_tmp; |
| |
| |
| // Ñïåðâà "î÷èñòèì" òàáëèöó îò íåñòàíäàðòíûõ äåëåãàòîâ |
| for (i=0; i < colomns_indexes.size(); i++){ // äëÿ âñåõ ïîëåé-óêàçàòåëåé: |
| ui->tableView->setItemDelegateForColumn(colomns_indexes.at(i), &standart_delegate ); // è ïðèñâàèâàåì ñòàíäàðòíûé äåëåãàò |
| // ui->tableView->setItemDelegateForColumn(colomns_indexes.at(i), &picture_delegate); |
| |
| } |
| colomns_indexes.clear(); // î÷èùàåñ ñïèñîê ñòîëáöîâ ñ íåñòàíäàðòíûìè äåëåãàòàìè |
| |
| |
| ui->tableView->setItemDelegateForColumn(colomns_indexes.at(i), &standart_delegate ); // è ïðèñâàèâàåì ñòàíäàðòíûé äåëåãàò |
| // "Î÷èñòèì" òàáëèöó îò äåëåãàòîâ äëÿ òèïà "DATE" |
| for (i=0; i < date_colomns_indexes.size(); i++){ // äëÿ âñåõ ïîëåé-óêàçàòåëåé: |
| ui->tableView->setItemDelegateForColumn(date_colomns_indexes.at(i), &standart_delegate ); // è ïðèñâàèâàåì ñòàíäàðòíûé äåëåãàò |
| // ui->tableView->setItemDelegateForColumn(colomns_indexes.at(i), &picture_delegate); |
| |
| } |
| date_colomns_indexes.clear(); // î÷èùàåì ñïèñîê ñòîëáöîâ ñ äåëåãàòàìè äëÿ òèïà "DATE" |
| |
| |
| colomns_indexes.clear(); // î÷èùàåñ ñïèñîê ñòîëáöîâ ñ íåñòàíäàðòíûìè äåëåãàòàìè |
| |
| |
| |
| for (int i=0; i < spin_delegate_list.count(); i++){ // óäàëÿåì íåñòàíäàðòíûå äåëåãàòû |
| delete spin_delegate_list.at(i); |
| } |
| 501,6 → 513,7 |
|---|
| |
| spin_delegate_list.clear(); // î÷èùàåì ñïèñîê óêàçàòåëåé íà íåñòàíäàðòíûå äåëåãàòû |
| |
| QStringList pointersNames; |
| pointersNames = pointersList.keys(); //çäåñü ñïèñîê èìåí ïîëåé-óêàçàòåëåé íà ðîäèòåëüñêèå êëàññû |
| |
| |
| 507,7 → 520,6 |
|---|
| |
| |
| |
| |
| // ui->tableView->setItemDelegateForColumn(2, picture_delegate); |
| |
| // ui->tableView->setRowHeight(1, 100); |
| 775,7 → 787,54 |
|---|
| |
| |
| |
| QStringList MainWindow::getDataFieldList(QString class_id){ // ïîëó÷àåì ñïèñîê âñåõ ïîëåé c òèïîì "Äàòà", â êà÷åñòâå êëþ÷åé ïîëó÷èì èìåíà ïîëåé |
| // â êà÷åñòâå çíà÷åíèé ïîëó÷èì ñïèñîê òàáëèö-õðàíèëèù îáúåêòîâ ðîäèòåëüñêèõ êëàññîâ |
| |
| QStringList result_str; |
| QSqlQuery q; |
| QString sql_str; |
| QString str_tmp; |
| QString field; |
| QString result; |
| int field_name, field_default_value; |
| bool ok; |
| sql_str = tr("select * " |
| " from `DescriptionOfClasses` where `DescriptionOfClasses`.`FieldType` = 'DATE' and `DescriptionOfClasses`.`ClassIdentifer` = " //íàõîäèì âñå îáúåêòû êëàññà â òàáëèöå - õðàíèëèùå îáúåêòîâ êëàññà |
| ); |
| |
| sql_str.append(tr("'")); |
| sql_str.append(class_id); |
| sql_str.append(tr("' ")); |
| // sql_str.append(tr(" and `DescriptionOfClasses`.`ClassIdentifer` = '")); |
| // sql_str.append(chield_class_id); |
| // sql_str.append(tr("'")); |
| q.prepare(sql_str); |
| |
| ok = q.exec(); |
| if (!ok) { |
| QMessageBox::critical( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå. |
| this, // Ðîäèòåëüñêèé âèäæåò. |
| QObject::tr("Database Error"), // Çàãîëîâîê. |
| q.lastError().text()); // Òåêñò ñîîáùåíèÿ. |
| return result_str; |
| } |
| field_name = q.record().indexOf(tr("FieldName")); |
| // field_default_value = q.record().indexOf(tr("DefaultValue")); |
| while(q.next()){ |
| QString DataFieldName; |
| |
| DataFieldName = q.value(field_name).toString(); |
| result_str.append(DataFieldName); |
| |
| |
| } |
| |
| return result_str; |
| } |
| |
| |
| |
| |
| // Ñ÷èòûâàåì íàñòðîéêè |
| |
| void MainWindow::readSettings() |