-
Notifications
You must be signed in to change notification settings - Fork 2
/
deptwidget.cpp
66 lines (61 loc) · 2.28 KB
/
deptwidget.cpp
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
#include "deptwidget.h"
#include "ui_deptwidget.h"
DeptWidget::DeptWidget(QWidget *parent) :
QWidget(parent),
ui(new Ui::DeptWidget)
{
ui->setupUi(this);
//加载院系信息
QSqlQuery query;
query.exec("select * from Dept");
if(query.lastError().type()==QSqlError::NoError){
while(query.next()){
qDebug()<<query.value(0).toString()<<" "<<query.value(1).toString();
ui->DeptMsgWidget->setRowCount(ui->DeptMsgWidget->rowCount()+1);
ui->DeptMsgWidget->setItem(ui->DeptMsgWidget->rowCount()-1,0,new QTableWidgetItem(query.value(0).toString()));
ui->DeptMsgWidget->setItem(ui->DeptMsgWidget->rowCount()-1,1,new QTableWidgetItem(query.value(1).toString()));
}
}else{
QMessageBox::warning(this,"错误",query.lastError().text());
}
}
DeptWidget::~DeptWidget()
{
delete ui;
}
void DeptWidget::on_ModifyDeptInfoButton_clicked()
{
QList<QTableWidgetItem*> items = ui->DeptMsgWidget->selectedItems();
if(items.size()<=0){
QMessageBox::warning(this,"错误","您没有选中任何院系!");
}else{
int rowIndex=ui->DeptMsgWidget->row(items.at(0));
QString name=ui->DeptMsgWidget->item(rowIndex,0)->text();
QString info=ui->DeptMsgWidget->item(rowIndex,1)->text();
ModifyDeptMsgWidget *widget=new ModifyDeptMsgWidget();
widget->getCurrentDept(name,info);
widget->show();
}
}
void DeptWidget::on_toolButton_clicked()
{
ui->DeptMsgWidget->clearContents();
ui->DeptMsgWidget->setRowCount(0);
QSqlQuery query;
query.exec("select * from Dept");
if(query.lastError().type()==QSqlError::NoError){
while(query.next()){
qDebug()<<query.value(0).toString()<<" "<<query.value(1).toString();
ui->DeptMsgWidget->setRowCount(ui->DeptMsgWidget->rowCount()+1);
ui->DeptMsgWidget->setItem(ui->DeptMsgWidget->rowCount()-1,0,new QTableWidgetItem(query.value(0).toString()));
ui->DeptMsgWidget->setItem(ui->DeptMsgWidget->rowCount()-1,1,new QTableWidgetItem(query.value(1).toString()));
}
}else{
QMessageBox::warning(this,"错误",query.lastError().text());
}
}
void DeptWidget::on_AddDeptButton_clicked()
{
AddDeptWidget *widget=new AddDeptWidget();
widget->show();
}