Хранилища Subversion OpenInventory

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

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

/trunk/DBViewer/mainwindow.cpp
23,6 → 23,10
 
ui->treeWidget->setAlternatingRowColors(true);
ui->treeWidget_2->setAlternatingRowColors(true);
 
 
MainWindow::readSettings();
 
MainWindow::openDataBase();
MainWindow::buildPreviewModel(tr("Ìîÿ ìîäåëü"), tr("1"));
MainWindow::initComboBox();
36,7 → 40,13
ui->pushButton_3->setEnabled(false);
ui->pushButton_4->setEnabled(false);
 
// setFrm.show();
 
connect(ui->getsettingAct, SIGNAL(triggered()), this, SLOT(getSetting())); // âûáîð â ãëàâíîé ôîðìå â ìåíþ "Áàçà äàííûõ" ïóíêòà "Ïàðàìåòðû ñîåäèíåíèÿ"
connect(setFrm.pushButton, SIGNAL(clicked()), this, SLOT(applySetting()));
 
 
 
}
 
MainWindow::~MainWindow()
254,15 → 264,30
sql = QSqlDatabase::addDatabase("QMYSQL");
// sql.setDatabaseName(tr("an_db"));
 
sql.setDatabaseName(tr("inventory"));
sql.setHostName(tr("localhost"));
// // // sql.setDatabaseName(tr("inventory"));
 
sql.setDatabaseName(baseName);
 
 
 
sql.setUserName(tr("an"));
sql.setPassword(tr("393939"));
// // // sql.setHostName(tr("localhost"));
 
sql.setHostName(hostName);
 
 
// // // sql.setUserName(tr("an"));
 
sql.setUserName(userName);
 
 
 
// // // sql.setPassword(tr("393939"));
 
 
sql.setPassword(password);
 
 
 
bool ok;
ok = sql.open();
 
607,6 → 632,9
tmp_stringList << tmp_str;
 
}
// int count = ui->comboBox->count();
 
ui->comboBox->clear();
ui->comboBox->addItems(tmp_stringList);
 
 
617,6 → 645,8
QStringList classesNameList;
QStringList classesID_list;
QString ID_str;
if (index == -1) return;
 
classesID_list = class_list_map.keys();
classesNameList = class_list_map.values();
ID_str = classesID_list[index];
647,7 → 677,7
classesID_list = class_list_map.keys();
classesNameList = class_list_map.values();
index = classesID_list.indexOf(item->child(0)->text(1));
ui->comboBox->setCurrentIndex(index);
if (index != -1) ui->comboBox->setCurrentIndex(index);
 
ui->comboBox->setEnabled(true);
 
/trunk/DBViewer/mainwindow.h
5,7 → 5,7
//#include "mysql.h"
 
#include "mymodel.h"
 
#include "settingform.h"
#include "delegate.h"
 
#include <QMainWindow>
61,6 → 61,19
private:
Ui::MainWindow *ui;
 
settingForm setFrm;
//ïåðåìåííûå äëÿ ñîåäèíåíèÿ ñ áàçîé
QString baseName;
QString hostName;
QString userName;
QString password;
QString tableName;
 
void readSettings();
void writeSettings();
 
 
 
QList<QTreeWidgetItem *> root_items_list;
QStandardItemModel *model;
QStandardItem *item;
110,6 → 123,13
SpinBoxDelegate spinDelegate;
QItemDelegate standart_delegate;
 
 
 
 
 
 
 
 
private slots:
void on_comboBox_currentIndexChanged( int index );
void on_treeWidget_itemChanged ( QTreeWidgetItem * item, int column );
120,7 → 140,8
void on_pushButton_3_clicked();// íàæàòèå êíîïêè "Ïðèìåíèòü"
void on_pushButton_4_clicked();// íàæàòèå êíîïêè "Ñáðîñèòü èçìåíåíèÿ"
void on_sql_mogel_dataChanged ( const QModelIndex & topLeft, const QModelIndex & bottomRight ); // èçìåíèëè ñâîéñòâà îáúåêòà èëè äîáàâèëè íîâûé îáúåêò
 
void applySetting();
void getSetting(); // îòêðîåì îêíî íàñòðîåê
};
 
 
/trunk/DBViewer/database.cpp
650,3 → 650,73
return result_map;
}
 
 
 
 
 
 
// Ñ÷èòûâàåì íàñòðîéêè
 
void MainWindow::readSettings()
{
QSettings settings("Trolltech", "Application Example");
baseName = settings.value("baseName", "an_db").toString();
userName = settings.value("userName", "an").toString();
password = settings.value("password", "393939").toString();
tableName = settings.value("tableName", "inventar").toString();
hostName = settings.value("hostName", "server").toString();
// resize(size);
// move(pos);tableName
}
 
 
void MainWindow::writeSettings()
{
QSettings settings("Trolltech", "Application Example");
settings.setValue("baseName", baseName);
settings.setValue("userName", userName);
settings.setValue("password", password);
settings.setValue("tableName", tableName);
settings.setValue("hostName", hostName);
}
 
 
 
void MainWindow::applySetting()
{
bool ok;
baseName = setFrm.lineEdit->text();
userName = setFrm.lineEdit_2->text();
password = setFrm.lineEdit_3->text();
// tableName = setFrm->lineEdit_4->text();
hostName = setFrm.lineEdit_5->text();
writeSettings();
 
 
ok=openDataBase();
if (!ok) return;
// // // ui->treeWidget->clear(); // î÷èùàåì äåðåâî ñ ìîäåëüþ
 
// // // buildPreviewModel(tr("Ìîÿ ìîäåëü"), tr("1"));
class_list_map.clear(); // î÷èùàåì ñïèñîê êëàññîâ
initComboBox();
// // // getDatabaseData();
// delete setFrm;
setFrm.close();
}
 
 
void MainWindow::getSetting()
{
// setFrm = new settingForm;
// // // connect(setFrm.pushButton, SIGNAL(clicked()), this, SLOT(applySetting()));
setFrm.lineEdit->setText(baseName);
setFrm.lineEdit_2->setText(userName);
setFrm.lineEdit_3->setText(password);
// setFrm->lineEdit_4->setText(tableName);
setFrm.lineEdit_5->setText(hostName);
setFrm.show();
 
 
 
}
/trunk/DBViewer/DBViewer.pro
17,9 → 17,12
mainwindow.cpp \
database.cpp \
delegate.cpp \
mymodel.cpp
mymodel.cpp \
settingform.cpp
HEADERS += mainwindow.h \
delegate.h \
mymodel.h
FORMS += mainwindow.ui
mymodel.h \
settingform.h
FORMS += mainwindow.ui \
settingform.ui
RESOURCES += dbviewer.qrc
/trunk/DBViewer/mainwindow.ui
226,6 → 226,13
<height>27</height>
</rect>
</property>
<widget class="QMenu" name="menu">
<property name="title">
<string>База данных</string>
</property>
<addaction name="getsettingAct"/>
</widget>
<addaction name="menu"/>
</widget>
<widget class="QToolBar" name="mainToolBar">
<attribute name="toolBarArea">
236,6 → 243,11
</attribute>
</widget>
<widget class="QStatusBar" name="statusBar"/>
<action name="getsettingAct">
<property name="text">
<string>Параметры соединения</string>
</property>
</action>
</widget>
<layoutdefault spacing="6" margin="11"/>
<resources/>