Хранилища Subversion OpenInventory

Сравнить редакции

Не учитывать пробелы Редакция 125 → Редакция 126

/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]
 
/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);