ПРИЛОЖЕНИЕ А

Информационная система предназначена для планирования междисциплинарных курсовых работ.

Она представляет собой программу.

Минимальные требования к клиенту:

· процессор класса Pentium с тактовой частотой 1 Гц и выше;

· объем свободного дискового пространства не менее 300 Мб;

· объем оперативной памяти не менее 1 Гб;

· ОС Windows 7;

· манипулятор типа “мышь”;

· монитор с разрешением 1280x1024.

А3. Подготовка к работе

Листинг основных компонентов информационной системы

#include "DisciplineDirectory.h"

#include <QLayout>

#include <QDebug>

#include <QSqlError>

#include <QHeaderView>

#include <QGroupBox>

#include <QTabWidget>

DisciplineDirectory::DisciplineDirectory(DBReaderNS::DBReader *dbReader, QWidget *parent) :

QWidget(parent),

m_dbReader(dbReader),

m_discSQLTableModel(0),

m_discTableView(new QTableView),

m_discAddButton(new QPushButton("Добавить")),

m_discRemoveButton(new QPushButton("Удалить")),

m_compSQLTableModel(0),

m_compTableView(new QTableView),

m_compAddButton(new QPushButton("Добавить")),

m_compRemoveButton(new QPushButton("Удалить")),

m_discLabel(new QLabel("Дисциплина:")),

m_discComboBox(new QComboBox),

m_compLeftModel(new DisciplineListModel),

m_compLeftView(new QListView),

m_compRightModel(new DisciplineListModel),

m_compRightView(new QListView),

m_oneLeftButton(new QPushButton("<")),

m_oneRightButton(new QPushButton(">")),

m_backButton(new QPushButton("Назад"))

{

QTabWidget* tabWidget = new QTabWidget;

m_discTableView->horizontalHeader()->setSectionResizeMode(QHeaderView::ResizeToContents);

{

QHBoxLayout* hbox = new QHBoxLayout;

hbox->addWidget(m_discAddButton);

hbox->addWidget(m_discRemoveButton);

QVBoxLayout* vbox = new QVBoxLayout;

vbox->addWidget(m_discTableView);

vbox->addLayout(hbox);

QWidget *widget = new QWidget;

widget->setLayout(vbox);

tabWidget->addTab(widget,"Дисциплины");

connect(m_discAddButton,&QPushButton::clicked,[=]()

{

m_discSQLTableModel->insertRow(m_discSQLTableModel->rowCount());

});

connect(m_discRemoveButton,&QPushButton::clicked,[=]()

{

m_discSQLTableModel->removeRow(m_discTableView->currentIndex().row());

m_discSQLTableModel->select();

});

}

{

QHBoxLayout* hbox = new QHBoxLayout;

hbox->addWidget(m_compAddButton);

hbox->addWidget(m_compRemoveButton);

QVBoxLayout* vbox = new QVBoxLayout;

vbox->addWidget(m_compTableView);

vbox->addLayout(hbox);

QWidget *widget = new QWidget;

widget->setLayout(vbox);

tabWidget->addTab(widget,"Компетенции");

connect(m_compAddButton,&QPushButton::clicked,[=]()

{

m_compSQLTableModel->insertRow(m_compSQLTableModel->rowCount());

});

connect(m_compRemoveButton,&QPushButton::clicked,[=]()

{

m_compSQLTableModel->removeRow(m_compTableView->currentIndex().row());

m_compSQLTableModel->select();

});

}

{

QHBoxLayout* workTitleLayout = new QHBoxLayout;

workTitleLayout->addWidget(m_discLabel);

workTitleLayout->addWidget(m_discComboBox);

QVBoxLayout* viewButtonsBox = new QVBoxLayout;

viewButtonsBox->insertStretch(0,1);

viewButtonsBox->addWidget(m_oneRightButton);

viewButtonsBox->addWidget(m_oneLeftButton);

viewButtonsBox->insertStretch(-1,1);

m_compLeftView->setModel(m_compLeftModel);

m_compRightView->setModel(m_compRightModel);

QHBoxLayout* viewBox = new QHBoxLayout;

viewBox->addWidget(m_compLeftView);

viewBox->addLayout(viewButtonsBox);

viewBox->addWidget(m_compRightView);

QVBoxLayout* mainLayout = new QVBoxLayout;

mainLayout->addLayout(workTitleLayout);

mainLayout->addLayout(viewBox);

QWidget *widget = new QWidget;

widget->setLayout(mainLayout);

tabWidget->addTab(widget,"Выбор компетенций");

connect(m_oneLeftButton,&QPushButton::clicked,[=]()

{

if(m_compRightModel->rowCount(QModelIndex()) == 0)

{

return;

}

int row = m_compRightView->currentIndex().row();

m_dbReader->query(QString("delete from comp_disc "

"where id_disc = %1 and id_comp = %2;")

.arg(m_discComboBox->currentData().toInt())

.arg(m_compRightModel->GetItem(row).first));

m_compLeftModel->AddItem(m_compRightModel->GetItem(row));

m_compRightModel->RemoveItem(row);

});

connect(m_oneRightButton,&QPushButton::clicked,[=]()

{

if(m_compLeftModel->rowCount(QModelIndex()) == 0)

{

return;

}

int row = m_compLeftView->currentIndex().row();

m_dbReader->query(QString("INSERT INTO comp_disc(id_disc, id_comp) values (%1, %2);")

.arg(m_discComboBox->currentData().toInt())

.arg(m_compLeftModel->GetItem(row).first));

m_compRightModel->AddItem(m_compLeftModel->GetItem(row));

m_compLeftModel->RemoveItem(row);

});

}

QVBoxLayout* vbox = new QVBoxLayout;

vbox->addWidget(tabWidget);

vbox->addWidget(m_backButton);

setLayout(vbox);

connect(m_backButton,&QPushButton::clicked,this,&DisciplineDirectory::backSignal);

connect(tabWidget,&QTabWidget::currentChanged,[=](int index)

{

if(index != 2)

{

return;

}

m_discComboBox->clear();

if(m_dbReader->query("select * from discipline;"))

{

DBReaderNS::SQLResult result = m_dbReader->getResult();

for(int i = 0; i < result.size();++i)

{

m_discComboBox->addItem(result.at(i).at(1).toString(), result.at(i).at(0).toInt());

}

}

});

connect(m_discComboBox,&QComboBox::currentTextChanged,[=]()

{

m_compLeftModel->RemoveModelData();

if(m_dbReader->query(QString("SELECT competence.id, competence.namee_c "

"FROM competence "

"WHERE competence.id not in "

"(SELECT competence.id "

"FROM competence INNER JOIN comp_disc ON competence.id = comp_disc.id_comp "

"WHERE comp_disc.id_disc = %1);").arg(m_discComboBox->currentData().toInt())))

{

DBReaderNS::SQLResult result = m_dbReader->getResult();

for(int i = 0; i < result.size();++i)

{

m_compLeftModel->AddItem(result.at(i).at(0).toInt(), result.at(i).at(1).toString());

}

}

m_compRightModel->RemoveModelData();

if(m_dbReader->query(QString("SELECT competence.id, competence.namee_c "

"FROM competence INNER JOIN comp_disc ON competence.id = comp_disc.id_comp "

"WHERE comp_disc.id_disc=%1;").arg(m_discComboBox->currentData().toInt())))

{

DBReaderNS::SQLResult result = m_dbReader->getResult();

for(int i = 0; i < result.size();++i)

{

m_compRightModel->AddItem(result.at(i).at(0).toInt(), result.at(i).at(1).toString());

}

}

});

}

void DisciplineDirectory::onOpen()

{

if(m_discSQLTableModel == 0)

{

m_discSQLTableModel = new QSqlTableModel(this, m_dbReader->getDB());

}

m_discSQLTableModel->setTable("discipline");

m_discSQLTableModel->select();

m_discTableView->horizontalHeader()->setSectionResizeMode(QHeaderView::ResizeToContents);

m_discTableView->setModel(m_discSQLTableModel);

if(m_compSQLTableModel == 0)

{

m_compSQLTableModel = new QSqlTableModel(this, m_dbReader->getDB());

}

m_compSQLTableModel->setTable("competence");

m_compSQLTableModel->select();

m_compTableView->horizontalHeader()->setSectionResizeMode(QHeaderView::ResizeToContents);

m_compTableView->setModel(m_compSQLTableModel);

}

#include "mainwindow.h"

#include <QStackedLayout>

#include <QStackedWidget>

#include <QDir>

#include <QCoreApplication>

#include <QDebug>

#include <QFileDialog>

#include <QTimer>

#include <QMessageBox>

#include <QGroupBox>

MainWindow::MainWindow(QWidget *parent)

: QMainWindow(parent),

m_dbReader(new DBReaderNS::DBReader),

m_userName(new QLabel),

m_loginWidget(new LoginWidget(m_dbReader)),

m_disciplineWidget(new DisciplineWidget(m_dbReader)),

m_competenceWidget(new CompetenceWidget(m_dbReader)),

m_resultWidget(new ResultWidget(m_dbReader)),

m_userDirectory(new UserDirectory(m_dbReader)),

m_discDirectory(new DisciplineDirectory(m_dbReader)),

m_resultDirectory(new ResultDirectory(m_dbReader)),

m_title(new QLabel("Рады приветствовать вас в информационной системе планирования \n"

"междисциплинарных курсовых работ в компетентностном аспекте")),

m_createNewWorkButton(new QPushButton("Сформировать междисциплинарную курсовую работу")),

m_userDirectoryButton(new QPushButton("Справочник пользователей")),

m_discDirectoryButton(new QPushButton("Справочник дисциплин и компетенций")),

m_resultDirectoryButton(new QPushButton("Справочник отчетов"))

{

QHBoxLayout *hbox = new QHBoxLayout;

hbox->insertStretch(0, 1);

hbox->addWidget(m_userName);

QGroupBox* gbox = new QGroupBox;

{

QHBoxLayout *hbox = new QHBoxLayout;

hbox->addWidget(m_title);

gbox->setLayout(hbox);

}

QVBoxLayout *vbox = new QVBoxLayout;

vbox->insertStretch(0,2);

vbox->addWidget(gbox);

vbox->insertStretch(2,1);

QHBoxLayout *buttonsBox = new QHBoxLayout;

buttonsBox->insertStretch(0, 1);

buttonsBox->addLayout(vbox);

buttonsBox->insertStretch(-1, 1);

QWidget *buttonsWidget = new QWidget;

buttonsWidget->setLayout(buttonsBox);

QStackedWidget* stack = new QStackedWidget;

stack->addWidget(m_loginWidget);

stack->addWidget(buttonsWidget);

stack->addWidget(m_disciplineWidget);

stack->addWidget(m_competenceWidget);

stack->addWidget(m_resultWidget);

stack->addWidget(m_resultDirectory);

stack->addWidget(m_userDirectory);

stack->addWidget(m_discDirectory);

QVBoxLayout *mainLayout = new QVBoxLayout;

mainLayout->addLayout(hbox);

mainLayout->addWidget(stack);

QWidget *widget = new QWidget;

widget->setLayout(mainLayout);

setCentralWidget(widget);

setWindowTitle("Информационная система планирования междисциплинарных курсовых работ в компетентностном аспекте");

connect(m_loginWidget,&LoginWidget::okSignal,[=](int i, QString name, QString role)

{

m_userId = i;

m_userName->setText(name);

if(role == "админ")

{

vbox->addWidget(m_userDirectoryButton);

vbox->addWidget(m_discDirectoryButton);

vbox->addWidget(m_resultDirectoryButton);

}

else

{

vbox->addWidget(m_createNewWorkButton);

vbox->addWidget(m_resultDirectoryButton);

}

vbox->insertStretch(-1,2);

stack->setCurrentWidget(buttonsWidget);

});

connect(m_loginWidget,&LoginWidget::cancelSignal,this,&MainWindow::close);

connect(m_createNewWorkButton,&QPushButton::clicked,[=]()

{

stack->setCurrentWidget(m_disciplineWidget);

m_disciplineWidget->onOpen();

});

connect(m_resultDirectoryButton,&QPushButton::clicked,[=]()

{

if(m_resultDirectory->isEmpty(-1))

{

QMessageBox box;

box.setWindowTitle("Ошибка");

box.setText("Список сохраненных работ пуст.");

box.exec();

}

else

{

stack->setCurrentWidget(m_resultDirectory);

m_resultDirectory->onOpen(-1);

}

});

connect(m_resultDirectory,&ResultDirectory::backSignal,[=]()

{

stack->setCurrentWidget(buttonsWidget);

});

connect(m_disciplineWidget,&DisciplineWidget::nextSignal,[=](QString s, QList<QPair<int, QString>> list)

{

m_workData.title = s;

m_workData.discList = list;

stack->setCurrentWidget(m_competenceWidget);

m_competenceWidget->onOpen(s, list);

});

connect(m_disciplineWidget,&DisciplineWidget::prevSignal,[=]()

{

stack->setCurrentWidget(buttonsWidget);

});

connect(m_competenceWidget,&CompetenceWidget::nextSignal,[=](QString s, QList<QPair<int, QString>> list, QMap<int, QString> map)

{

m_workData.title = s;

m_workData.compList = list;

m_workData.compComments = map;

stack->setCurrentWidget(m_resultWidget);

m_resultWidget->onOpen(m_userId, m_workData);

});

connect(m_competenceWidget,&CompetenceWidget::prevSignal,[=]()

{

stack->setCurrentWidget(m_disciplineWidget);

});

connect(m_resultWidget,&ResultWidget::prevSignal,[=]()

{

stack->setCurrentWidget(m_competenceWidget);

});

connect(m_resultWidget,&ResultWidget::nextSignal,[=]()

{

stack->setCurrentWidget(buttonsWidget);

});

connect(m_userDirectoryButton,&QPushButton::clicked,[=]()

{

stack->setCurrentWidget(m_userDirectory);

m_userDirectory->onOpen();

});

connect(m_userDirectory,&UserDirectory::backSignal,[=]()

{

stack->setCurrentWidget(buttonsWidget);

});

connect(m_discDirectoryButton,&QPushButton::clicked,[=]()

{

stack->setCurrentWidget(m_discDirectory);

m_discDirectory->onOpen();

});

connect(m_discDirectory,&DisciplineDirectory::backSignal,[=]()

{

stack->setCurrentWidget(buttonsWidget);

});

QString addr = QFileDialog::getOpenFileName(

this,

"Открыть Файл базы данных",

QCoreApplication::applicationDirPath(),

"Все форматы баз даных (*.accdb *.mdb *.sqlite);;SQLite (*.sqlite);;MS Access (*.accdb *.mdb)");

if(addr.isEmpty())

{

QTimer::singleShot(0, this, SLOT(close()));

}

m_dbReader->openDB(addr);

}

MainWindow::~MainWindow()

{

m_dbReader->closeDB();

}

Размещено на Allbest.ru