/trunk/DBViewer/mainwindow.h |
---|
98,9 → 98,9 |
void showObjects(QTreeWidgetItem * parent_object_item, QTreeWidgetItem * model_item, QString filtr);// // îòîáðàçèì îáúåêòû êëàññîâà |
QString getPointerFieldName(QString parent_class_id, QString chield_class_id); // îïðåäåëÿåì èìÿ ïîëÿ, â êîòîðîì õðÿíÿòñÿ óêàçàòåëè íà îáúåêòû ðîäèòåëüñêîãî êëàññà |
SpinBoxDelegate spinDelegate; |
private slots: |
void on_comboBox_currentIndexChanged( int index ); |
void on_treeWidget_itemChanged ( QTreeWidgetItem * item, int column ); |
/trunk/DBViewer/database.cpp |
---|
187,6 → 187,8 |
void MainWindow::showObjects(QTreeWidgetItem * parent_object_item, QTreeWidgetItem * model_item, QString filtr){ |
QString classID; // èäåíòèôèêàòîð êëàññà |
QString parentClassID; // èäåíòèôèêàòîð ðîäèòåëüñêîãî êëàññà |
QString pointerField; // èìÿ ïîëÿ-óêàçàòåëÿ íà ðîäèòåëüñêèé êëàññ |
QString inctance; // èìÿ òàáëèöû, õðàíèëèùà |
QString className; // èìÿ êëàññà |
int field_ID; |
201,6 → 203,11 |
font.setBold(true); |
filtr_empty = filtr.isEmpty(); |
classID = model_item->text(1); |
parentClassID = model_item->parent()->text(1); |
pointerField = getPointerFieldName(parentClassID, classID); |
className = model_item->text(0); |
inctance = getClassInctance(classID); |
212,8 → 219,10 |
title_item->setText(1, tr("class")); |
title_item->setText(2, classID); |
title_item->setText(3, inctance); |
title_item->setText(4, pointerField); |
title_item->setTextColor(0, Qt::darkBlue); |
sql_str = tr("select * " |
" from " //íàõîäèì âñå îáúåêòû êëàññà â òàáëèöå - õðàíèëèùå îáúåêòîâ êëàññà |
); |
274,6 → 283,10 |
model_item_tmp = model_item->child(i); // îòîáðàæàåì îáúåêòû äî÷åðíèõ êëàññîâ |
pointer_name = getPointerFieldName(classID, model_item->child(i)->text(1)); |
itm->setText(4, pointer_name); |
// title_item->setText(4, pointer_name); |
pointer_isEmpty = pointer_name.isEmpty(); |
filtr_tmp = tr("where "); |
filtr_tmp.append(tr("`")); |
394,6 → 407,7 |
QString class_id; // èäåíòèôèêàòîð âûáðàííîãî êëàññà |
QString inctance; |
QString parent_class_inctance; |
QString pointer_name; |
QString filtr_tmp; |
// sql_mogel->clear(); |
409,8 → 423,11 |
class_id = item->text(2); |
inctance = item->text(3); |
pointer_name = parent_item->text(4); |
// parent_class_inctance = parent_item->parent()->text(3); // óçíàåì õðàíèëèùå îáúåêòîâ ðîäèòåëüñêîãî êëàññà |
// pointer_name = parent_item->text(4); |
pointer_name = item->text(4); |
delete sql_mogel; |
sql_mogel = new QSqlTableModel(); |
// sql_mogel = new QSqlTableModel(this); |
428,8 → 445,18 |
filtr_tmp.append(tr("'")); |
sql_mogel->setFilter(filtr_tmp); |
} |
/**************************************** |
spinDelegate.setInctance(parent_class_inctance); |
spinDelegate.getItems(); |
ui->tableView->setItemDelegateForColumn(2, &spinDelegate); |
***************************************/ |
sql_mogel->select(); |
pointer_index = sql_mogel->record().indexOf(pointer_name); |
ui->tableView->setModel(sql_mogel); |
/trunk/DBViewer/delegate.cpp |
---|
60,6 → 60,66 |
} |
//! [0] |
void SpinBoxDelegate::setInctance(QString newInctance){ |
inctance = newInctance; |
} |
void SpinBoxDelegate::getItems(){ |
QMap <QString, QString> result_map; |
QSqlQuery q; |
QString query_str; |
bool ok; |
if (SpinBoxDelegate::inctance.isEmpty()) |
{ |
items.clear(); |
return; |
} |
query_str = tr("select * from `"); |
query_str.append(inctance); |
query_str.append( tr("`")); |
q.prepare(query_str); |
ok = q.exec(); |
if (!ok) { |
/* |
QString error_str; |
error_str = tr("íå óäàëîñü ïîëó÷èòü ñïèñîê îáúåêòîâ èç òàáëèöû "); |
error_str.append(inctance); |
QMessageBox::critical( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå. |
this, // Ðîäèòåëüñêèé âèäæåò. |
QObject::tr("Database Error"), // Çàãîëîâîê. |
q.lastError().text()); // Òåêñò ñîîáùåíèÿ. |
// tr("íå óäàëîñü ïîëó÷èòü ñïèñîê îáúåêòîâ èç òàáëèöû ")); // Òåêñò ñîîáùåíèÿ. |
*/ |
items.clear(); |
return; |
} |
// field_inctance = q.record().indexOf(tr("TableWhithInstance")); |
while(q.next()){ |
QString ID; |
QString Name; |
ID = q.value(0).toString(); // îïðåäåëÿåì ID |
Name = q.value(1).toString(); // îïðåäåëÿåì Name |
items.insert(ID, Name); |
} |
// return result_map; |
} |
//! [1] |
QWidget *SpinBoxDelegate::createEditor(QWidget *parent, |
const QStyleOptionViewItem &/* option */, |
68,7 → 128,21 |
//QSpinBox *editor = new QSpinBox(parent); |
//editor->setMinimum(0); |
//editor->setMaximum(100); |
QStringList ID_list; |
QStringList Name_list; |
// getItems(); |
ID_list = items.keys(); |
Name_list = items.values(); |
QComboBox *editor = new QComboBox(parent); |
/* |
editor->addItem("0"); |
editor->addItem("1"); |
editor->addItem("2"); |
79,8 → 153,11 |
editor->addItem("7"); |
editor->addItem("8"); |
editor->addItem("9"); |
// editor->addItem("0"); |
*/ |
// editor->addItem("0"); |
editor->addItems(Name_list); |
return editor; |
} |
//! [1] |
95,6 → 172,17 |
// spinBox->setValue(value); |
QString value = index.model()->data(index, Qt::EditRole).toString(); |
QComboBox *comboBox = static_cast<QComboBox*>(editor); |
QStringList ID_list; |
QStringList Name_list; |
int curr_index; |
ID_list = items.keys(); |
Name_list = items.values(); |
curr_index = ID_list.indexOf(value); |
comboBox->setCurrentIndex(curr_index); |
/**************************************************** |
if (value == "0") comboBox->setCurrentIndex(0); |
if (value == "1") comboBox->setCurrentIndex(1); |
if (value == "2") comboBox->setCurrentIndex(2); |
105,6 → 193,7 |
if (value == "7") comboBox->setCurrentIndex(7); |
if (value == "8") comboBox->setCurrentIndex(8); |
if (value == "9") comboBox->setCurrentIndex(9); |
******************************************************/ |
comboBox->setEditable(true); |
122,11 → 211,18 |
// int value = spinBox->value(); |
// model->setData(index, value, Qt::EditRole); |
QStringList ID_list; |
QStringList Name_list; |
QComboBox *comboBox = static_cast<QComboBox*>(editor); |
int currIndex; |
currIndex = comboBox->currentIndex(); |
QString value = comboBox->itemText(currIndex); |
// QString value = comboBox->itemText(currIndex); |
ID_list = items.keys(); |
Name_list = items.values(); |
QString value = ID_list.at(currIndex); |
model->setData(index, value, Qt::EditRole); |
} |
//! [3] |
/trunk/DBViewer/delegate.h |
---|
6,8 → 6,12 |
#include <QObject> |
#include <QSize> |
#include <QSpinBox> |
#include <QSqlQuery> |
#include <QtSql> |
#include <QtGui> |
#include <QSqlDatabase> |
#include <QMessageBox> |
//#include <QMainWindow> |
//! [0] |
class SpinBoxDelegate : public QItemDelegate |
{ |
25,6 → 29,27 |
void updateEditorGeometry(QWidget *editor, |
const QStyleOptionViewItem &option, const QModelIndex &index) const; |
void setInctance(QString newInctance); |
void getItems(); // ïîëó÷àåì ñâÿçàííûé ñïèñîê |
private: |
QString inctance; // òàáëèöà-õðàíèëèùå, îòêóäà áóäåì áðàòü ñïèñîê |
QMap <QString, QString> items; // çäåñü áóäåì õðàíèòü ñâÿçàííûé ñïèñîê èìåò îáúåêòîâ è èõ èäåíòèôèêàòîðîâ ID |
}; |
//! [0] |