|
|
"""
|
|
|
|
|
|
代码功能：主界面和功能的设计与实现
|
|
|
"""
|
|
|
|
|
|
# 导入所需模块
|
|
|
import os
|
|
|
from PyQt5 import QtCore, QtWidgets
|
|
|
import sys
|
|
|
import qtawesome
|
|
|
from PyQt5.QtWidgets import *
|
|
|
import pandas as pd
|
|
|
from PyQt5.QtCore import Qt, pyqtSignal, QRect
|
|
|
|
|
|
from AddAdmin import AddAdmin
|
|
|
from EditAdmin import EditAdmin
|
|
|
from sqls import *
|
|
|
from db import *
|
|
|
import Config as C
|
|
|
|
|
|
# 全局变量
|
|
|
header_field = ['全选'] # 表头字段
|
|
|
global all_header_combobox # 用来装行表头所有复选框
|
|
|
global all_class, class_dict, class_dict2
|
|
|
global data_list # 存放数据库数据列表
|
|
|
global activat_menu # 当前激活的菜单按钮
|
|
|
|
|
|
activat_menu = None # 记录当前选中的菜单
|
|
|
|
|
|
|
|
|
# 自定义表头类
|
|
|
class CheckBoxHeader(QHeaderView):
|
|
|
# 自定义 复选框全选信号
|
|
|
select_all_clicked = pyqtSignal(bool)
|
|
|
# 这4个变量控制列头复选框的样式，位置以及大小
|
|
|
_x_offset = 21
|
|
|
_y_offset = 10
|
|
|
_width = 20
|
|
|
_height = 20
|
|
|
|
|
|
def __init__(self, orientation=Qt.Horizontal, parent=None):
|
|
|
super(CheckBoxHeader, self).__init__(orientation, parent)
|
|
|
self.isOn = False # 控制全选
|
|
|
|
|
|
# paintSection 绘制部分，主要用于绘制复选框，主要设置QStyleOptionButton的状态
|
|
|
def paintSection(self, painter, rect, logicalIndex):
|
|
|
painter.save()
|
|
|
super(CheckBoxHeader, self).paintSection(painter, rect, logicalIndex)
|
|
|
painter.restore()
|
|
|
self._y_offset = int((rect.height() - self._width) / 2.)
|
|
|
if logicalIndex == 0:
|
|
|
option = QStyleOptionButton()
|
|
|
option.rect = QRect(rect.x() + self._x_offset, rect.y() + self._y_offset, self._width, self._height)
|
|
|
option.state = QStyle.State_Enabled | QStyle.State_Active
|
|
|
if self.isOn:
|
|
|
option.state |= QStyle.State_On
|
|
|
else:
|
|
|
option.state |= QStyle.State_Off
|
|
|
self.style().drawControl(QStyle.CE_CheckBox, option, painter)
|
|
|
|
|
|
# 覆写鼠标点击事件(点击全选框效果)
|
|
|
def mousePressEvent(self, event):
|
|
|
index = self.logicalIndexAt(event.pos())
|
|
|
if 0 == index:
|
|
|
x = self.sectionPosition(index)
|
|
|
if x + self._x_offset < event.pos().x() < x + self._x_offset + self._width and self._y_offset < event.pos().y() < self._y_offset + self._height:
|
|
|
if self.isOn:
|
|
|
self.isOn = False
|
|
|
print(self.isOn)
|
|
|
else:
|
|
|
self.isOn = True
|
|
|
print(self.isOn)
|
|
|
# 当用户点击了行表头复选框，发射 自定义信号 select_all_clicked()
|
|
|
self.select_all_clicked.emit(self.isOn)
|
|
|
self.updateSection(0)
|
|
|
super(CheckBoxHeader, self).mousePressEvent(event)
|
|
|
|
|
|
# 改变勾选状态
|
|
|
def change_state(self, isOn):
|
|
|
# 如果行表头复选框为勾选状态
|
|
|
if isOn:
|
|
|
# 将所有的复选框都设为勾选状态
|
|
|
for i in all_header_combobox:
|
|
|
i.setCheckState(Qt.Checked)
|
|
|
else:
|
|
|
for i in all_header_combobox:
|
|
|
i.setCheckState(Qt.Unchecked)
|
|
|
|
|
|
|
|
|
# 界面设计与实现
|
|
|
class MainUi(QtWidgets.QMainWindow):
|
|
|
def __init__(self):
|
|
|
super().__init__()
|
|
|
self.init_ui()
|
|
|
|
|
|
# 初始化界面
|
|
|
def init_ui(self):
|
|
|
self.setFixedSize(960, 700)
|
|
|
self.main_widget = QtWidgets.QWidget() # 创建窗口主部件
|
|
|
self.main_layout = QtWidgets.QGridLayout() # 创建主部件的网格布局
|
|
|
self.main_widget.setLayout(self.main_layout) # 设置窗口主部件布局为网格布局
|
|
|
|
|
|
self.left_widget = QtWidgets.QWidget() # 创建左侧部件
|
|
|
self.left_widget.setObjectName('left_widget') # 部件命名，设置样式用
|
|
|
self.left_layout = QtWidgets.QGridLayout() # 创建左侧部件的网格布局层
|
|
|
self.left_widget.setLayout(self.left_layout) # 设置左侧部件布局为网格
|
|
|
self.main_layout.addWidget(self.left_widget, 0, 0, 12, 2) # 左侧部件在第0行第0列，占12行2列
|
|
|
self.setCentralWidget(self.main_widget) # 设置窗口主部件
|
|
|
|
|
|
self.left_label_1 = QtWidgets.QPushButton('欢迎您，' + C.USER[3])
|
|
|
self.left_label_1.setObjectName('left_label')
|
|
|
self.left_label_3 = QtWidgets.QPushButton("个人中心")
|
|
|
self.left_label_3.setObjectName('left_label')
|
|
|
|
|
|
self.left_button_1 = QtWidgets.QPushButton(qtawesome.icon('fa.users', color='white'), "学生管理")
|
|
|
self.left_button_1.setObjectName('left_button')
|
|
|
self.left_button_1.clicked.connect(lambda: self.setRightWidget(C.FLAG_STUDENT))
|
|
|
self.left_button_2 = QtWidgets.QPushButton(qtawesome.icon('fa.id-card', color='white'), "成绩管理")
|
|
|
self.left_button_2.setObjectName('left_button')
|
|
|
self.left_button_2.clicked.connect(lambda: self.setRightWidget(C.FLAG_GRADE))
|
|
|
# 管理员账号
|
|
|
if C.USER[0] == 1:
|
|
|
self.left_button_3 = QtWidgets.QPushButton(qtawesome.icon('fa.institution', color='white'), "班级管理")
|
|
|
self.left_button_3.setObjectName('left_button')
|
|
|
self.left_button_3.clicked.connect(lambda: self.setRightWidget(C.FLAG_CLASS))
|
|
|
self.left_button_4 = QtWidgets.QPushButton(qtawesome.icon('fa.user-secret', color='white'), "角色管理")
|
|
|
self.left_button_4.setObjectName('left_button')
|
|
|
self.left_button_4.clicked.connect(lambda: self.setRightWidget(C.FLAG_ADMIN))
|
|
|
else:
|
|
|
# 表格布局用于占位
|
|
|
self.left_button_3 = QtWidgets.QPushButton()
|
|
|
self.left_button_4 = QtWidgets.QPushButton()
|
|
|
self.left_button_5 = QtWidgets.QPushButton()
|
|
|
self.left_button_6 = QtWidgets.QPushButton()
|
|
|
self.left_button_7 = QtWidgets.QPushButton()
|
|
|
self.left_button_8 = QtWidgets.QPushButton(qtawesome.icon('fa.pencil-square-o', color='white'), "修改资料")
|
|
|
self.left_button_8.setObjectName('left_button')
|
|
|
self.left_button_8.clicked.connect(lambda: self.setRightWidget(C.FLAG_INFO))
|
|
|
self.left_button_9 = QtWidgets.QPushButton(qtawesome.icon('fa.sign-out', color='white'), "退出登录")
|
|
|
self.left_button_9.setObjectName('left_button')
|
|
|
self.left_button_9.clicked.connect(lambda: self.logOut(True))
|
|
|
self.left_xxx = QtWidgets.QPushButton(" ")
|
|
|
|
|
|
self.left_layout.addWidget(self.left_label_1, 1, 0, 1, 3)
|
|
|
self.left_layout.addWidget(self.left_button_1, 2, 0, 1, 3)
|
|
|
self.left_layout.addWidget(self.left_button_2, 3, 0, 1, 3)
|
|
|
self.left_layout.addWidget(self.left_button_3, 4, 0, 1, 3)
|
|
|
self.left_layout.addWidget(self.left_button_4, 6, 0, 1, 3)
|
|
|
self.left_layout.addWidget(self.left_label_3, 8, 0, 1, 3)
|
|
|
self.left_layout.addWidget(self.left_button_8, 9, 0, 1, 3)
|
|
|
self.left_layout.addWidget(self.left_button_9, 10, 0, 1, 3)
|
|
|
self.left_layout.addWidget(self.left_button_5, 11, 0, 1, 3)
|
|
|
self.left_layout.addWidget(self.left_button_6, 12, 0, 1, 3)
|
|
|
self.left_layout.addWidget(self.left_button_7, 7, 0, 1, 3)
|
|
|
|
|
|
# 设置样式
|
|
|
self.left_widget.setStyleSheet('''
|
|
|
QPushButton{border:none;color:white;}
|
|
|
QPushButton#left_label{
|
|
|
border:none;
|
|
|
border-bottom:1px solid white;
|
|
|
padding-bottom:2px;
|
|
|
font-size:16px;
|
|
|
font-weight:500;
|
|
|
font-family: "Helvetica Neue", Helvetica, Arial, sans-serif;
|
|
|
}
|
|
|
QPushButton#left_button{
|
|
|
width:20px;
|
|
|
font-size:15px;
|
|
|
}
|
|
|
QPushButton#left_button:hover{font-weight:700;}
|
|
|
QWidget#left_widget{
|
|
|
background:#607d8b;
|
|
|
border-top:1px solid white;
|
|
|
border-bottom:1px solid white;
|
|
|
border-left:1px solid white;
|
|
|
}
|
|
|
''')
|
|
|
self.right_widget = None
|
|
|
self.setRightWidget()
|
|
|
self.main_layout.setSpacing(0)
|
|
|
|
|
|
# 设置右方显示界面内容布局
|
|
|
def setRightWidget(self, flag=C.FLAG_GRADE):
|
|
|
# 学生管理
|
|
|
if flag == C.FLAG_STUDENT:
|
|
|
self.right_widget = self.student_management()
|
|
|
# 成绩管理
|
|
|
elif flag == C.FLAG_GRADE:
|
|
|
self.right_widget = self.grade_management()
|
|
|
# 班级管理（管理员）
|
|
|
elif flag == C.FLAG_CLASS:
|
|
|
self.right_widget = self.class_management()
|
|
|
# 角色管理（管理员）
|
|
|
elif flag == C.FLAG_ADMIN:
|
|
|
self.right_widget = self.admin_management()
|
|
|
# 修改信息
|
|
|
elif flag == C.FLAG_INFO:
|
|
|
self.right_widget = self.change_info()
|
|
|
|
|
|
# 学生管理界面设计
|
|
|
def student_management(self):
|
|
|
global all_class, class_dict, class_dict2
|
|
|
class_dict = {}
|
|
|
class_dict2 = {}
|
|
|
if self.right_widget:
|
|
|
self.main_layout.removeWidget(self.right_widget) # 移除已有右侧组件
|
|
|
self.setWindowTitle('Python学生管理系统-学生管理')
|
|
|
self.setLeftMenu(self.left_button_1) # 标记选中
|
|
|
self.right_widget = QtWidgets.QWidget() # 创建右侧部件
|
|
|
self.right_widget.setObjectName('right_widget')
|
|
|
self.verticalLayout = QtWidgets.QVBoxLayout()
|
|
|
self.verticalLayout.setObjectName("verticalLayout")
|
|
|
|
|
|
self.right_layout = self.verticalLayout
|
|
|
self.right_widget.setLayout(self.right_layout) # 设置右侧部件布局为网格
|
|
|
|
|
|
self.main_layout.addWidget(self.right_widget, 0, 2, 12, 10) # 右侧部件在第0行第2列，占12行10列
|
|
|
|
|
|
self.widget = QtWidgets.QWidget()
|
|
|
self.horizontalLayout = QtWidgets.QHBoxLayout(self.widget)
|
|
|
self.horizontalLayout.setObjectName("horizontalLayout")
|
|
|
self.label = QtWidgets.QLabel(self.widget)
|
|
|
self.label.setObjectName("label")
|
|
|
self.horizontalLayout.addWidget(self.label)
|
|
|
# 班级列表下拉框
|
|
|
self.cb = QComboBox(self)
|
|
|
# 单个添加条目
|
|
|
self.cb.addItem('All')
|
|
|
# 多个添加条目
|
|
|
all_class = self.getClassList()
|
|
|
print(all_class)
|
|
|
for class_ in all_class:
|
|
|
# 添加班级字典
|
|
|
class_dict[class_[0]] = class_[1]
|
|
|
class_dict2[class_[1]] = class_[0]
|
|
|
self.cb.addItem(str(class_[0]) + '.' + class_[1])
|
|
|
print(class_dict) # 班级字典
|
|
|
print(class_dict2)
|
|
|
# 传递改变条件的信号
|
|
|
self.cb.currentIndexChanged[int].connect(lambda: self.getDataList(C.FLAG_STUDENT)) # 条目发生改变，发射信号，传递条目索引
|
|
|
|
|
|
self.cb.setStyleSheet(''' text-align : center;
|
|
|
height : 30px;
|
|
|
padding-left: 5px;
|
|
|
font : 12px ''')
|
|
|
self.horizontalLayout.addWidget(self.cb)
|
|
|
self.label_2 = QtWidgets.QLabel(self.widget)
|
|
|
self.label_2.setObjectName("label_2")
|
|
|
self.horizontalLayout.addWidget(self.label_2)
|
|
|
# 姓名输入框
|
|
|
self.input_name = QtWidgets.QLineEdit(self.widget)
|
|
|
self.input_name.setObjectName("input_name")
|
|
|
self.horizontalLayout.addWidget(self.input_name)
|
|
|
self.input_name.setStyleSheet(''' height : 30px;
|
|
|
border-style: outset;
|
|
|
padding-left: 5px;
|
|
|
border: 1px solid #ccc;
|
|
|
border-radius: 5px;
|
|
|
font : 12px ''')
|
|
|
# 查询按钮
|
|
|
self.pushButton_2 = QtWidgets.QPushButton(self.widget)
|
|
|
self.pushButton_2.setObjectName("pushButton_2")
|
|
|
self.horizontalLayout.addWidget(self.pushButton_2)
|
|
|
self.pushButton_2.clicked.connect(lambda: self.getDataList(C.FLAG_STUDENT))
|
|
|
self.pushButton_2.setStyleSheet(''' text-align : center;
|
|
|
background-color : #03a9f4;
|
|
|
height : 30px;
|
|
|
width: 50px;
|
|
|
border-style: outset;
|
|
|
border-radius: 5px;
|
|
|
color: #fff;
|
|
|
font : 12px ''')
|
|
|
# 空格
|
|
|
spacerItem = QtWidgets.QSpacerItem(40, 20, QtWidgets.QSizePolicy.Expanding, QtWidgets.QSizePolicy.Minimum)
|
|
|
self.horizontalLayout.addItem(spacerItem)
|
|
|
|
|
|
# 批量删除按钮
|
|
|
self.pushButton_del = QtWidgets.QPushButton(self.widget)
|
|
|
self.pushButton_del.setObjectName("pushButton_del")
|
|
|
self.horizontalLayout.addWidget(self.pushButton_del)
|
|
|
self.pushButton_del.clicked.connect(lambda: self.batchDelete(C.FLAG_STUDENT))
|
|
|
self.pushButton_del.setStyleSheet(''' text-align : center;
|
|
|
background-color : #f44336;
|
|
|
height : 30px;
|
|
|
width: 80px;
|
|
|
border-style: outset;
|
|
|
border-radius: 5px;
|
|
|
color: #fff;
|
|
|
font : 12px ''')
|
|
|
|
|
|
# 导入按钮
|
|
|
self.pushButton_3 = QtWidgets.QPushButton(self.widget)
|
|
|
self.pushButton_3.setObjectName("pushButton")
|
|
|
self.horizontalLayout.addWidget(self.pushButton_3)
|
|
|
self.pushButton_3.clicked.connect(lambda: self.open_file(C.FLAG_STUDENT))
|
|
|
self.pushButton_3.setStyleSheet(''' text-align : center;
|
|
|
background-color : #009688;
|
|
|
height : 30px;
|
|
|
width: 50px;
|
|
|
border-style: outset;
|
|
|
border-radius: 5px;
|
|
|
color: #fff;
|
|
|
font : 12px ''')
|
|
|
|
|
|
# 导出按钮
|
|
|
self.pushButton = QtWidgets.QPushButton(self.widget)
|
|
|
self.pushButton.setObjectName("pushButton")
|
|
|
self.horizontalLayout.addWidget(self.pushButton)
|
|
|
self.pushButton.clicked.connect(lambda: self.data_export(C.FLAG_STUDENT))
|
|
|
self.pushButton.setStyleSheet(''' text-align : center;
|
|
|
background-color : #ff9800;
|
|
|
height : 30px;
|
|
|
width: 50px;
|
|
|
border-style: outset;
|
|
|
border-radius: 5px;
|
|
|
color: #fff;
|
|
|
font : 12px ''')
|
|
|
# 内容区域
|
|
|
self.verticalLayout.addWidget(self.widget)
|
|
|
self.tableWidget = QtWidgets.QTableWidget()
|
|
|
self.tableWidget.setSelectionBehavior(QtWidgets.QAbstractItemView.SelectRows)
|
|
|
self.tableWidget.setObjectName("tableWidget")
|
|
|
self.tableWidget.setColumnCount(7)
|
|
|
|
|
|
item = QtWidgets.QTableWidgetItem()
|
|
|
self.tableWidget.setHorizontalHeaderItem(0, item)
|
|
|
item = QtWidgets.QTableWidgetItem()
|
|
|
self.tableWidget.setHorizontalHeaderItem(1, item)
|
|
|
item = QtWidgets.QTableWidgetItem()
|
|
|
self.tableWidget.setHorizontalHeaderItem(2, item)
|
|
|
item = QtWidgets.QTableWidgetItem()
|
|
|
self.tableWidget.setHorizontalHeaderItem(3, item)
|
|
|
item = QtWidgets.QTableWidgetItem()
|
|
|
self.tableWidget.setHorizontalHeaderItem(4, item)
|
|
|
item = QtWidgets.QTableWidgetItem()
|
|
|
self.tableWidget.setHorizontalHeaderItem(5, item)
|
|
|
item = QtWidgets.QTableWidgetItem()
|
|
|
self.tableWidget.setHorizontalHeaderItem(6, item)
|
|
|
self.verticalLayout.addWidget(self.tableWidget)
|
|
|
|
|
|
# 设置显示名
|
|
|
_translate = QtCore.QCoreApplication.translate
|
|
|
self.label.setText(_translate("Form", "班级"))
|
|
|
self.label_2.setText(_translate("Form", "姓名"))
|
|
|
self.pushButton_2.setText(_translate("Form", "查询"))
|
|
|
self.pushButton_del.setText(_translate("Form", "批量删除"))
|
|
|
self.pushButton_3.setText(_translate("Form", "导入"))
|
|
|
self.pushButton.setText(_translate("Form", "导出"))
|
|
|
|
|
|
# 表头内容
|
|
|
item = self.tableWidget.horizontalHeaderItem(1)
|
|
|
item.setText(_translate("Form", "ID"))
|
|
|
item = self.tableWidget.horizontalHeaderItem(2)
|
|
|
item.setText(_translate("Form", "姓名"))
|
|
|
item = self.tableWidget.horizontalHeaderItem(3)
|
|
|
item.setText(_translate("Form", "学号"))
|
|
|
item = self.tableWidget.horizontalHeaderItem(4)
|
|
|
item.setText(_translate("Form", "性别"))
|
|
|
item = self.tableWidget.horizontalHeaderItem(5)
|
|
|
item.setText(_translate("Form", "班级"))
|
|
|
item = self.tableWidget.horizontalHeaderItem(6)
|
|
|
item.setText(_translate("Form", "操作"))
|
|
|
|
|
|
# 选择框
|
|
|
header = CheckBoxHeader() # 实例化自定义表头
|
|
|
self.tableWidget.setHorizontalHeader(header) # 设置表头
|
|
|
header.select_all_clicked.connect(header.change_state) # 行表头复选框单击信号与槽
|
|
|
self.tableWidget.setColumnWidth(0, 50)
|
|
|
self.tableWidget.setColumnWidth(1, 70)
|
|
|
self.tableWidget.setColumnWidth(5, 197)
|
|
|
|
|
|
# 其余列宽设置
|
|
|
self.tableWidget.verticalHeader().setDefaultSectionSize(32)
|
|
|
|
|
|
# 获取数据
|
|
|
self.getDataList(C.FLAG_STUDENT)
|
|
|
return self.right_widget
|
|
|
|
|
|
# 成绩管理界面设计
|
|
|
def grade_management(self):
|
|
|
global all_class, class_dict, class_dict2
|
|
|
class_dict = {}
|
|
|
class_dict2 = {}
|
|
|
if self.right_widget:
|
|
|
self.main_layout.removeWidget(self.right_widget) # 移除已有右侧组件
|
|
|
self.setWindowTitle('Python学生管理系统-成绩管理')
|
|
|
self.setLeftMenu(self.left_button_2)
|
|
|
self.right_widget = QtWidgets.QWidget() # 创建右侧部件
|
|
|
self.right_widget.setObjectName('right_widget')
|
|
|
self.verticalLayout = QtWidgets.QVBoxLayout()
|
|
|
self.verticalLayout.setObjectName("verticalLayout")
|
|
|
|
|
|
self.right_layout = self.verticalLayout
|
|
|
self.right_widget.setLayout(self.right_layout) # 设置右侧部件布局为网格
|
|
|
self.main_layout.addWidget(self.right_widget, 0, 2, 12, 10) # 右侧部件在第0行第2列，占12行10列
|
|
|
|
|
|
self.widget = QtWidgets.QWidget()
|
|
|
self.horizontalLayout = QtWidgets.QHBoxLayout(self.widget)
|
|
|
self.horizontalLayout.setObjectName("horizontalLayout")
|
|
|
self.label = QtWidgets.QLabel(self.widget)
|
|
|
self.label.setObjectName("label")
|
|
|
self.horizontalLayout.addWidget(self.label)
|
|
|
# 班级列表下拉框
|
|
|
self.cb = QComboBox(self)
|
|
|
# 单个添加条目
|
|
|
self.cb.addItem('All')
|
|
|
# 多个添加条目
|
|
|
all_class = self.getClassList()
|
|
|
for class_ in all_class:
|
|
|
# 添加班级字典
|
|
|
class_dict[class_[0]] = class_[1]
|
|
|
class_dict2[class_[1]] = class_[0]
|
|
|
self.cb.addItem(str(class_[0]) + '.' + class_[1])
|
|
|
|
|
|
# 信号
|
|
|
self.cb.currentIndexChanged[int].connect(lambda: self.getDataList(C.FLAG_GRADE)) # 条目发生改变，发射信号，传递条目索引
|
|
|
|
|
|
self.cb.setStyleSheet(''' text-align : center;
|
|
|
height : 30px;
|
|
|
padding-left: 5px;
|
|
|
font : 12px ''')
|
|
|
self.horizontalLayout.addWidget(self.cb)
|
|
|
self.label_2 = QtWidgets.QLabel(self.widget)
|
|
|
self.label_2.setObjectName("label_2")
|
|
|
self.horizontalLayout.addWidget(self.label_2)
|
|
|
|
|
|
# 姓名输入框
|
|
|
self.input_name = QtWidgets.QLineEdit(self.widget)
|
|
|
self.input_name.setObjectName("input_name")
|
|
|
self.horizontalLayout.addWidget(self.input_name)
|
|
|
self.input_name.setStyleSheet(''' height : 30px;
|
|
|
border-style: outset;
|
|
|
padding-left: 5px;
|
|
|
border: 1px solid #ccc;
|
|
|
border-radius: 5px;
|
|
|
font : 12px ''')
|
|
|
# 查询按钮
|
|
|
self.pushButton_2 = QtWidgets.QPushButton(self.widget)
|
|
|
self.pushButton_2.setObjectName("pushButton_2")
|
|
|
self.horizontalLayout.addWidget(self.pushButton_2)
|
|
|
self.pushButton_2.clicked.connect(lambda: self.getDataList(C.FLAG_GRADE))
|
|
|
self.pushButton_2.setStyleSheet(''' text-align : center;
|
|
|
background-color : #03a9f4;
|
|
|
height : 30px;
|
|
|
width: 50px;
|
|
|
border-style: outset;
|
|
|
border-radius: 5px;
|
|
|
color: #fff;
|
|
|
font : 12px ''')
|
|
|
|
|
|
spacerItem = QtWidgets.QSpacerItem(40, 20, QtWidgets.QSizePolicy.Expanding, QtWidgets.QSizePolicy.Minimum)
|
|
|
self.horizontalLayout.addItem(spacerItem)
|
|
|
|
|
|
# 批量清零按钮
|
|
|
self.pushButton_del = QtWidgets.QPushButton(self.widget)
|
|
|
self.pushButton_del.setObjectName("pushButton_del")
|
|
|
self.horizontalLayout.addWidget(self.pushButton_del)
|
|
|
self.pushButton_del.clicked.connect(lambda: self.batchDelete(C.FLAG_GRADE))
|
|
|
self.pushButton_del.setStyleSheet(''' text-align : center;
|
|
|
background-color : #f44336;
|
|
|
height : 30px;
|
|
|
width: 80px;
|
|
|
border-style: outset;
|
|
|
border-radius: 5px;
|
|
|
color: #fff;
|
|
|
font : 12px ''')
|
|
|
|
|
|
# 导入按钮
|
|
|
self.pushButton_3 = QtWidgets.QPushButton(self.widget)
|
|
|
self.pushButton_3.setObjectName("pushButton")
|
|
|
self.horizontalLayout.addWidget(self.pushButton_3)
|
|
|
self.pushButton_3.clicked.connect(lambda: self.open_file(C.FLAG_GRADE))
|
|
|
self.pushButton_3.setStyleSheet(''' text-align : center;
|
|
|
background-color : #009688;
|
|
|
height : 30px;
|
|
|
width: 50px;
|
|
|
border-style: outset;
|
|
|
border-radius: 5px;
|
|
|
color: #fff;
|
|
|
font : 12px ''')
|
|
|
|
|
|
# 导出按钮
|
|
|
self.pushButton = QtWidgets.QPushButton(self.widget)
|
|
|
self.pushButton.setObjectName("pushButton")
|
|
|
self.horizontalLayout.addWidget(self.pushButton)
|
|
|
self.pushButton.clicked.connect(lambda: self.data_export(C.FLAG_GRADE))
|
|
|
self.pushButton.setStyleSheet(''' text-align : center;
|
|
|
background-color : #ff9800;
|
|
|
height : 30px;
|
|
|
width: 50px;
|
|
|
border-style: outset;
|
|
|
border-radius: 5px;
|
|
|
color: #fff;
|
|
|
font : 12px ''')
|
|
|
|
|
|
self.verticalLayout.addWidget(self.widget)
|
|
|
self.tableWidget = QtWidgets.QTableWidget()
|
|
|
self.tableWidget.setSelectionBehavior(QtWidgets.QAbstractItemView.SelectRows)
|
|
|
self.tableWidget.setObjectName("tableWidget")
|
|
|
self.tableWidget.setColumnCount(8)
|
|
|
|
|
|
item = QtWidgets.QTableWidgetItem()
|
|
|
self.tableWidget.setHorizontalHeaderItem(0, item)
|
|
|
item = QtWidgets.QTableWidgetItem()
|
|
|
self.tableWidget.setHorizontalHeaderItem(1, item)
|
|
|
item = QtWidgets.QTableWidgetItem()
|
|
|
self.tableWidget.setHorizontalHeaderItem(2, item)
|
|
|
item = QtWidgets.QTableWidgetItem()
|
|
|
self.tableWidget.setHorizontalHeaderItem(3, item)
|
|
|
item = QtWidgets.QTableWidgetItem()
|
|
|
self.tableWidget.setHorizontalHeaderItem(4, item)
|
|
|
item = QtWidgets.QTableWidgetItem()
|
|
|
self.tableWidget.setHorizontalHeaderItem(5, item)
|
|
|
item = QtWidgets.QTableWidgetItem()
|
|
|
self.tableWidget.setHorizontalHeaderItem(6, item)
|
|
|
item = QtWidgets.QTableWidgetItem()
|
|
|
self.tableWidget.setHorizontalHeaderItem(7, item)
|
|
|
self.verticalLayout.addWidget(self.tableWidget)
|
|
|
|
|
|
_translate = QtCore.QCoreApplication.translate
|
|
|
self.label.setText(_translate("Form", "班级"))
|
|
|
self.label_2.setText(_translate("Form", "姓名"))
|
|
|
self.pushButton_2.setText(_translate("Form", "查询"))
|
|
|
self.pushButton_del.setText(_translate("Form", "批量清零"))
|
|
|
self.pushButton_3.setText(_translate("Form", "导入"))
|
|
|
self.pushButton.setText(_translate("Form", "导出"))
|
|
|
|
|
|
item = self.tableWidget.horizontalHeaderItem(1)
|
|
|
item.setText(_translate("Form", "姓名"))
|
|
|
item = self.tableWidget.horizontalHeaderItem(2)
|
|
|
item.setText(_translate("Form", "学号"))
|
|
|
item = self.tableWidget.horizontalHeaderItem(3)
|
|
|
item.setText(_translate("Form", "语文"))
|
|
|
item = self.tableWidget.horizontalHeaderItem(4)
|
|
|
item.setText(_translate("Form", "数学"))
|
|
|
item = self.tableWidget.horizontalHeaderItem(5)
|
|
|
item.setText(_translate("Form", "英语"))
|
|
|
item = self.tableWidget.horizontalHeaderItem(6)
|
|
|
item.setText(_translate("Form", "总分"))
|
|
|
item = self.tableWidget.horizontalHeaderItem(7)
|
|
|
item.setText(_translate("Form", "操作"))
|
|
|
|
|
|
header = CheckBoxHeader() # 实例化自定义表头
|
|
|
self.tableWidget.setHorizontalHeader(header) # 设置表头
|
|
|
header.select_all_clicked.connect(header.change_state) # 行表头复选框单击信号与槽
|
|
|
self.tableWidget.setColumnWidth(0, 50)
|
|
|
self.tableWidget.setColumnWidth(3, 80)
|
|
|
self.tableWidget.setColumnWidth(4, 80)
|
|
|
self.tableWidget.setColumnWidth(5, 80)
|
|
|
self.tableWidget.setColumnWidth(7, 130)
|
|
|
|
|
|
# 列宽
|
|
|
self.tableWidget.verticalHeader().setDefaultSectionSize(32)
|
|
|
|
|
|
self.getDataList(C.FLAG_GRADE)
|
|
|
return self.right_widget
|
|
|
|
|
|
# 班级管理界面设计
|
|
|
def class_management(self):
|
|
|
global all_class, class_dict, class_dict2
|
|
|
class_dict = {}
|
|
|
class_dict2 = {}
|
|
|
if self.right_widget:
|
|
|
self.main_layout.removeWidget(self.right_widget) # 移除已有右侧组件
|
|
|
self.setWindowTitle('Python学生管理系统-班级管理')
|
|
|
self.setLeftMenu(self.left_button_3)
|
|
|
self.right_widget = QtWidgets.QWidget() # 创建右侧部件
|
|
|
self.right_widget.setObjectName('right_widget')
|
|
|
self.verticalLayout = QtWidgets.QVBoxLayout()
|
|
|
self.verticalLayout.setObjectName("verticalLayout")
|
|
|
|
|
|
self.right_layout = self.verticalLayout
|
|
|
self.right_widget.setLayout(self.right_layout) # 设置右侧部件布局为网格
|
|
|
|
|
|
self.main_layout.addWidget(self.right_widget, 0, 2, 12, 10)
|
|
|
|
|
|
self.widget = QtWidgets.QWidget()
|
|
|
self.horizontalLayout = QtWidgets.QHBoxLayout(self.widget)
|
|
|
self.horizontalLayout.setObjectName("horizontalLayout")
|
|
|
|
|
|
# 新增按钮
|
|
|
self.pushButton_3 = QtWidgets.QPushButton(self.widget)
|
|
|
self.pushButton_3.setObjectName("pushButton")
|
|
|
self.horizontalLayout.addWidget(self.pushButton_3)
|
|
|
self.pushButton_3.clicked.connect(lambda: self.createData(C.FLAG_CLASS))
|
|
|
self.pushButton_3.setStyleSheet(''' text-align : center;
|
|
|
background-color : #009688;
|
|
|
height : 30px;
|
|
|
width: 80px;
|
|
|
border-style: outset;
|
|
|
border-radius: 5px;
|
|
|
color: #fff;
|
|
|
font : 12px ''')
|
|
|
self.label_2 = QtWidgets.QLabel(self.widget)
|
|
|
self.label_2.setObjectName("label_2")
|
|
|
self.horizontalLayout.addWidget(self.label_2)
|
|
|
|
|
|
# 班级输入框
|
|
|
self.input_name = QtWidgets.QLineEdit(self.widget)
|
|
|
self.input_name.setObjectName("input_name")
|
|
|
self.horizontalLayout.addWidget(self.input_name)
|
|
|
self.input_name.setStyleSheet(''' height : 30px;
|
|
|
border-style: outset;
|
|
|
padding-left: 5px;
|
|
|
border: 1px solid #ccc;
|
|
|
border-radius: 5px;
|
|
|
font : 12px ''')
|
|
|
# 查询按钮
|
|
|
self.pushButton_2 = QtWidgets.QPushButton(self.widget)
|
|
|
self.pushButton_2.setObjectName("pushButton_2")
|
|
|
self.horizontalLayout.addWidget(self.pushButton_2)
|
|
|
self.pushButton_2.clicked.connect(lambda: self.getDataList(C.FLAG_CLASS, i=-1))
|
|
|
self.pushButton_2.setStyleSheet(''' text-align : center;
|
|
|
background-color : #03a9f4;
|
|
|
height : 30px;
|
|
|
width: 50px;
|
|
|
border-style: outset;
|
|
|
border-radius: 5px;
|
|
|
color: #fff;
|
|
|
font : 12px ''')
|
|
|
|
|
|
spacerItem = QtWidgets.QSpacerItem(40, 20, QtWidgets.QSizePolicy.Expanding, QtWidgets.QSizePolicy.Minimum)
|
|
|
self.horizontalLayout.addItem(spacerItem)
|
|
|
|
|
|
# 批量删除按钮
|
|
|
self.pushButton_del = QtWidgets.QPushButton(self.widget)
|
|
|
self.pushButton_del.setObjectName("pushButton_del")
|
|
|
self.horizontalLayout.addWidget(self.pushButton_del)
|
|
|
self.pushButton_del.clicked.connect(lambda: self.batchDelete(C.FLAG_CLASS))
|
|
|
self.pushButton_del.setStyleSheet(''' text-align : center;
|
|
|
background-color : #f44336;
|
|
|
height : 30px;
|
|
|
width: 80px;
|
|
|
border-style: outset;
|
|
|
border-radius: 5px;
|
|
|
color: #fff;
|
|
|
font : 12px ''')
|
|
|
|
|
|
self.verticalLayout.addWidget(self.widget)
|
|
|
self.tableWidget = QtWidgets.QTableWidget()
|
|
|
self.tableWidget.setSelectionBehavior(QtWidgets.QAbstractItemView.SelectRows)
|
|
|
self.tableWidget.setObjectName("tableWidget")
|
|
|
self.tableWidget.setColumnCount(4)
|
|
|
|
|
|
item = QtWidgets.QTableWidgetItem()
|
|
|
self.tableWidget.setHorizontalHeaderItem(0, item)
|
|
|
item = QtWidgets.QTableWidgetItem()
|
|
|
self.tableWidget.setHorizontalHeaderItem(1, item)
|
|
|
item = QtWidgets.QTableWidgetItem()
|
|
|
self.tableWidget.setHorizontalHeaderItem(2, item)
|
|
|
item = QtWidgets.QTableWidgetItem()
|
|
|
self.tableWidget.setHorizontalHeaderItem(3, item)
|
|
|
self.verticalLayout.addWidget(self.tableWidget)
|
|
|
|
|
|
_translate = QtCore.QCoreApplication.translate
|
|
|
self.pushButton_3.setText(_translate("Form", "新增班级"))
|
|
|
self.label_2.setText(_translate("Form", "班级"))
|
|
|
self.pushButton_2.setText(_translate("Form", "查询"))
|
|
|
self.pushButton_del.setText(_translate("Form", "批量删除"))
|
|
|
|
|
|
item = self.tableWidget.horizontalHeaderItem(1)
|
|
|
item.setText(_translate("Form", "ID"))
|
|
|
item = self.tableWidget.horizontalHeaderItem(2)
|
|
|
item.setText(_translate("Form", "班级名称"))
|
|
|
item = self.tableWidget.horizontalHeaderItem(2)
|
|
|
item.setText(_translate("Form", "班级名称"))
|
|
|
item = self.tableWidget.horizontalHeaderItem(3)
|
|
|
item.setText(_translate("Form", "操作"))
|
|
|
|
|
|
header = CheckBoxHeader() # 实例化自定义表头
|
|
|
self.tableWidget.setHorizontalHeader(header) # 设置表头
|
|
|
header.select_all_clicked.connect(header.change_state) # 行表头复选框单击信号与槽
|
|
|
self.tableWidget.setColumnWidth(0, 50)
|
|
|
self.tableWidget.setColumnWidth(1, 70)
|
|
|
self.tableWidget.setColumnWidth(2, 510)
|
|
|
|
|
|
self.tableWidget.verticalHeader().setDefaultSectionSize(32)
|
|
|
|
|
|
self.getDataList(C.FLAG_CLASS, i=-1)
|
|
|
return self.right_widget
|
|
|
|
|
|
# 角色管理界面设计
|
|
|
def admin_management(self):
|
|
|
global all_class, class_dict, class_dict2
|
|
|
class_dict = {}
|
|
|
class_dict2 = {}
|
|
|
if self.right_widget:
|
|
|
self.main_layout.removeWidget(self.right_widget) # 移除已有右侧组件
|
|
|
self.setWindowTitle('Python学生管理系统-角色管理')
|
|
|
self.setLeftMenu(self.left_button_4)
|
|
|
self.right_widget = QtWidgets.QWidget() # 创建右侧部件
|
|
|
self.right_widget.setObjectName('right_widget')
|
|
|
self.verticalLayout = QtWidgets.QVBoxLayout()
|
|
|
self.verticalLayout.setObjectName("verticalLayout")
|
|
|
|
|
|
self.right_layout = self.verticalLayout
|
|
|
self.right_widget.setLayout(self.right_layout) # 设置右侧部件布局为网格
|
|
|
|
|
|
self.main_layout.addWidget(self.right_widget, 0, 2, 12, 10)
|
|
|
|
|
|
self.widget = QtWidgets.QWidget()
|
|
|
self.horizontalLayout = QtWidgets.QHBoxLayout(self.widget)
|
|
|
self.horizontalLayout.setObjectName("horizontalLayout")
|
|
|
|
|
|
# 新增按钮
|
|
|
self.pushButton_3 = QtWidgets.QPushButton(self.widget)
|
|
|
self.pushButton_3.setObjectName("pushButton")
|
|
|
self.horizontalLayout.addWidget(self.pushButton_3)
|
|
|
self.pushButton_3.clicked.connect(lambda: self.addAdmin())
|
|
|
self.pushButton_3.setStyleSheet(''' text-align : center;
|
|
|
background-color : #009688;
|
|
|
height : 30px;
|
|
|
width: 80px;
|
|
|
border-style: outset;
|
|
|
border-radius: 5px;
|
|
|
color: #fff;
|
|
|
font : 12px ''')
|
|
|
self.label_2 = QtWidgets.QLabel(self.widget)
|
|
|
self.label_2.setObjectName("label_2")
|
|
|
self.horizontalLayout.addWidget(self.label_2)
|
|
|
|
|
|
# 姓名输入框
|
|
|
self.input_name = QtWidgets.QLineEdit(self.widget)
|
|
|
self.input_name.setObjectName("input_name")
|
|
|
self.horizontalLayout.addWidget(self.input_name)
|
|
|
self.input_name.setStyleSheet(''' height : 30px;
|
|
|
border-style: outset;
|
|
|
padding-left: 5px;
|
|
|
border: 1px solid #ccc;
|
|
|
border-radius: 5px;
|
|
|
font : 12px ''')
|
|
|
|
|
|
# 查询按钮
|
|
|
self.pushButton_2 = QtWidgets.QPushButton(self.widget)
|
|
|
self.pushButton_2.setObjectName("pushButton_2")
|
|
|
self.horizontalLayout.addWidget(self.pushButton_2)
|
|
|
self.pushButton_2.clicked.connect(lambda: self.getDataList(C.FLAG_ADMIN, i=-1))
|
|
|
self.pushButton_2.setStyleSheet(''' text-align : center;
|
|
|
background-color : #03a9f4;
|
|
|
height : 30px;
|
|
|
width: 50px;
|
|
|
border-style: outset;
|
|
|
border-radius: 5px;
|
|
|
color: #fff;
|
|
|
font : 12px ''')
|
|
|
|
|
|
spacerItem = QtWidgets.QSpacerItem(40, 20, QtWidgets.QSizePolicy.Expanding, QtWidgets.QSizePolicy.Minimum)
|
|
|
self.horizontalLayout.addItem(spacerItem)
|
|
|
|
|
|
# 批量删除按钮
|
|
|
self.pushButton_del = QtWidgets.QPushButton(self.widget)
|
|
|
self.pushButton_del.setObjectName("pushButton_del")
|
|
|
self.horizontalLayout.addWidget(self.pushButton_del)
|
|
|
self.pushButton_del.clicked.connect(lambda: self.batchDelete(C.FLAG_ADMIN))
|
|
|
self.pushButton_del.setStyleSheet(''' text-align : center;
|
|
|
background-color : #f44336;
|
|
|
height : 30px;
|
|
|
width: 80px;
|
|
|
border-style: outset;
|
|
|
border-radius: 5px;
|
|
|
color: #fff;
|
|
|
font : 12px ''')
|
|
|
|
|
|
self.verticalLayout.addWidget(self.widget)
|
|
|
self.tableWidget = QtWidgets.QTableWidget()
|
|
|
self.tableWidget.setSelectionBehavior(QtWidgets.QAbstractItemView.SelectRows)
|
|
|
self.tableWidget.setObjectName("tableWidget")
|
|
|
self.tableWidget.setColumnCount(6)
|
|
|
|
|
|
item = QtWidgets.QTableWidgetItem()
|
|
|
self.tableWidget.setHorizontalHeaderItem(0, item)
|
|
|
item = QtWidgets.QTableWidgetItem()
|
|
|
self.tableWidget.setHorizontalHeaderItem(1, item)
|
|
|
item = QtWidgets.QTableWidgetItem()
|
|
|
self.tableWidget.setHorizontalHeaderItem(2, item)
|
|
|
item = QtWidgets.QTableWidgetItem()
|
|
|
self.tableWidget.setHorizontalHeaderItem(3, item)
|
|
|
item = QtWidgets.QTableWidgetItem()
|
|
|
self.tableWidget.setHorizontalHeaderItem(4, item)
|
|
|
item = QtWidgets.QTableWidgetItem()
|
|
|
self.tableWidget.setHorizontalHeaderItem(5, item)
|
|
|
self.verticalLayout.addWidget(self.tableWidget)
|
|
|
|
|
|
_translate = QtCore.QCoreApplication.translate
|
|
|
self.pushButton_3.setText(_translate("Form", "新增角色"))
|
|
|
self.label_2.setText(_translate("Form", "用户名"))
|
|
|
self.pushButton_2.setText(_translate("Form", "查询"))
|
|
|
self.pushButton_del.setText(_translate("Form", "批量删除"))
|
|
|
|
|
|
item = self.tableWidget.horizontalHeaderItem(1)
|
|
|
item.setText(_translate("Form", "ID"))
|
|
|
item = self.tableWidget.horizontalHeaderItem(2)
|
|
|
item.setText(_translate("Form", "用户名"))
|
|
|
item = self.tableWidget.horizontalHeaderItem(3)
|
|
|
item.setText(_translate("Form", "备注"))
|
|
|
item = self.tableWidget.horizontalHeaderItem(4)
|
|
|
item.setText(_translate("Form", "可管理班级"))
|
|
|
item = self.tableWidget.horizontalHeaderItem(5)
|
|
|
item.setText(_translate("Form", "操作"))
|
|
|
|
|
|
header = CheckBoxHeader() # 实例化自定义表头
|
|
|
self.tableWidget.setHorizontalHeader(header) # 设置表头
|
|
|
header.select_all_clicked.connect(header.change_state) # 行表头复选框单击信号与槽
|
|
|
self.tableWidget.setColumnWidth(0, 50)
|
|
|
self.tableWidget.setColumnWidth(1, 70)
|
|
|
self.tableWidget.setColumnWidth(2, 120)
|
|
|
self.tableWidget.setColumnWidth(3, 160)
|
|
|
self.tableWidget.setColumnWidth(4, 240)
|
|
|
|
|
|
self.tableWidget.verticalHeader().setDefaultSectionSize(32)
|
|
|
|
|
|
self.getDataList(C.FLAG_ADMIN, i=-1)
|
|
|
return self.right_widget
|
|
|
|
|
|
# 修改资料界面设计
|
|
|
def change_info(self):
|
|
|
if self.right_widget:
|
|
|
self.main_layout.removeWidget(self.right_widget) # 移除已有右侧组件
|
|
|
self.setWindowTitle('Python学生管理系统-资料修改')
|
|
|
self.setLeftMenu(self.left_button_8)
|
|
|
self.right_widget = QtWidgets.QWidget() # 创建右侧部件
|
|
|
self.right_widget.setObjectName('right_widget')
|
|
|
self.verticalLayout = QtWidgets.QVBoxLayout()
|
|
|
self.verticalLayout.setObjectName("verticalLayout")
|
|
|
self.right_widget.setStyleSheet(''' background-image : url('image/bg.png');
|
|
|
background-position:center;
|
|
|
background-repeat:no-repeat;''')
|
|
|
|
|
|
self.right_layout = self.verticalLayout
|
|
|
self.right_widget.setLayout(self.right_layout) # 设置右侧部件布局为网格
|
|
|
|
|
|
self.main_layout.addWidget(self.right_widget, 0, 2, 12, 10) # 右侧部件在第0行第3列，占8行9列
|
|
|
|
|
|
self.widget = QtWidgets.QWidget()
|
|
|
self.horizontalLayout = QtWidgets.QHBoxLayout(self.widget)
|
|
|
self.horizontalLayout.setObjectName("horizontalLayout")
|
|
|
spacerItem = QtWidgets.QSpacerItem(40, 20, QtWidgets.QSizePolicy.Expanding, QtWidgets.QSizePolicy.Minimum)
|
|
|
|
|
|
self.label_2 = QtWidgets.QLabel(self.widget)
|
|
|
self.label_2.setObjectName("label_2")
|
|
|
self.horizontalLayout.addItem(spacerItem)
|
|
|
self.horizontalLayout.addWidget(self.label_2)
|
|
|
|
|
|
# 用户名输入框
|
|
|
self.input_name = QtWidgets.QLineEdit(self.widget)
|
|
|
self.input_name.setObjectName("input_name")
|
|
|
self.input_name.setText(C.USER[1])
|
|
|
self.horizontalLayout.addWidget(self.input_name)
|
|
|
self.input_name.setStyleSheet(''' height : 30px;
|
|
|
border-style: outset;
|
|
|
padding-left: 5px;
|
|
|
border: 1px solid #ccc;
|
|
|
border-radius: 5px;
|
|
|
font : 12px ''')
|
|
|
|
|
|
self.widget2 = QtWidgets.QWidget()
|
|
|
self.horizontalLayout2 = QtWidgets.QHBoxLayout(self.widget2)
|
|
|
|
|
|
spacerItem2 = QtWidgets.QSpacerItem(40, 20, QtWidgets.QSizePolicy.Expanding, QtWidgets.QSizePolicy.Minimum)
|
|
|
self.horizontalLayout2.addItem(spacerItem2)
|
|
|
self.label_pass0 = QtWidgets.QLabel(self.widget2)
|
|
|
self.label_pass0.setText(' 原密码')
|
|
|
self.horizontalLayout2.addWidget(self.label_pass0)
|
|
|
|
|
|
# 原密码输入框
|
|
|
self.input_pass0 = QtWidgets.QLineEdit(self.widget2)
|
|
|
self.input_pass0.setEchoMode(QtWidgets.QLineEdit.Password)
|
|
|
self.input_pass0.setPlaceholderText('请输入原密码')
|
|
|
self.horizontalLayout2.addWidget(self.input_pass0)
|
|
|
self.input_pass0.setStyleSheet(''' height : 30px;
|
|
|
border-style: outset;
|
|
|
padding-left: 5px;
|
|
|
border: 1px solid #ccc;
|
|
|
border-radius: 5px;
|
|
|
font : 12px ''')
|
|
|
|
|
|
self.widget3 = QtWidgets.QWidget()
|
|
|
self.horizontalLayout3 = QtWidgets.QHBoxLayout(self.widget3)
|
|
|
|
|
|
spacerItem3 = QtWidgets.QSpacerItem(40, 20, QtWidgets.QSizePolicy.Expanding, QtWidgets.QSizePolicy.Minimum)
|
|
|
self.horizontalLayout3.addItem(spacerItem3)
|
|
|
self.label_pass1 = QtWidgets.QLabel(self.widget3)
|
|
|
self.label_pass1.setText(' 新密码')
|
|
|
# 新密码输入框
|
|
|
self.input_pass1 = QtWidgets.QLineEdit(self.widget3)
|
|
|
self.input_pass1.setObjectName("input_pass1")
|
|
|
self.input_pass1.setEchoMode(QtWidgets.QLineEdit.Password)
|
|
|
self.input_pass1.setPlaceholderText('请输入新密码')
|
|
|
self.horizontalLayout3.addWidget(self.label_pass1)
|
|
|
self.horizontalLayout3.addWidget(self.input_pass1)
|
|
|
self.input_pass1.setStyleSheet(''' height : 30px;
|
|
|
border-style: outset;
|
|
|
padding-left: 5px;
|
|
|
border: 1px solid #ccc;
|
|
|
border-radius: 5px;
|
|
|
font : 12px ''')
|
|
|
|
|
|
self.widget4 = QtWidgets.QWidget()
|
|
|
self.horizontalLayout4 = QtWidgets.QHBoxLayout(self.widget4)
|
|
|
spacerItem4 = QtWidgets.QSpacerItem(40, 20, QtWidgets.QSizePolicy.Expanding, QtWidgets.QSizePolicy.Minimum)
|
|
|
self.horizontalLayout4.addItem(spacerItem4)
|
|
|
self.label_pass2 = QtWidgets.QLabel(self.widget4)
|
|
|
self.label_pass2.setText('重复密码')
|
|
|
# 重复密码输入框
|
|
|
self.input_pass2 = QtWidgets.QLineEdit(self.widget4)
|
|
|
self.input_pass2.setObjectName("input_pass2")
|
|
|
self.input_pass2.setEchoMode(QtWidgets.QLineEdit.Password)
|
|
|
self.input_pass2.setPlaceholderText('请重复新密码')
|
|
|
self.horizontalLayout4.addWidget(self.label_pass2)
|
|
|
self.horizontalLayout4.addWidget(self.input_pass2)
|
|
|
self.input_pass2.setStyleSheet(''' height : 30px;
|
|
|
border-style: outset;
|
|
|
padding-left: 5px;
|
|
|
border: 1px solid #ccc;
|
|
|
border-radius: 5px;
|
|
|
font : 12px ''')
|
|
|
self.widget5 = QtWidgets.QWidget()
|
|
|
self.horizontalLayout5 = QtWidgets.QHBoxLayout(self.widget5)
|
|
|
spacerItem5 = QtWidgets.QSpacerItem(40, 20, QtWidgets.QSizePolicy.Expanding, QtWidgets.QSizePolicy.Minimum)
|
|
|
self.horizontalLayout5.addItem(spacerItem5)
|
|
|
|
|
|
# 提交按钮
|
|
|
self.pushButton_3 = QtWidgets.QPushButton(self.widget5)
|
|
|
self.pushButton_3.setObjectName("pushButton")
|
|
|
self.horizontalLayout5.addWidget(self.pushButton_3)
|
|
|
self.pushButton_3.clicked.connect(lambda: self.modifyPassw())
|
|
|
self.pushButton_3.setStyleSheet(''' text-align : center;
|
|
|
background-color : #009688;
|
|
|
height : 30px;
|
|
|
width: 80px;
|
|
|
border-style: outset;
|
|
|
border-radius: 5px;
|
|
|
color: #fff;
|
|
|
font : 12px ''')
|
|
|
# 修改按钮
|
|
|
self.pushButton_2 = QtWidgets.QPushButton(self.widget)
|
|
|
self.pushButton_2.setObjectName("pushButton_2")
|
|
|
self.horizontalLayout.addWidget(self.pushButton_2)
|
|
|
self.pushButton_2.clicked.connect(lambda: self.editUsername())
|
|
|
self.pushButton_2.setStyleSheet(''' text-align : center;
|
|
|
background-color : #03a9f4;
|
|
|
height : 30px;
|
|
|
width: 50px;
|
|
|
border-style: outset;
|
|
|
border-radius: 5px;
|
|
|
color: #fff;
|
|
|
font : 12px ''')
|
|
|
|
|
|
spacerItem = QtWidgets.QSpacerItem(40, 20, QtWidgets.QSizePolicy.Expanding, QtWidgets.QSizePolicy.Minimum)
|
|
|
self.horizontalLayout.addItem(spacerItem)
|
|
|
spacerItem = QtWidgets.QSpacerItem(40, 20, QtWidgets.QSizePolicy.Expanding, QtWidgets.QSizePolicy.Minimum)
|
|
|
self.horizontalLayout2.addItem(spacerItem)
|
|
|
spacerItem = QtWidgets.QSpacerItem(40, 20, QtWidgets.QSizePolicy.Expanding, QtWidgets.QSizePolicy.Minimum)
|
|
|
self.horizontalLayout3.addItem(spacerItem)
|
|
|
spacerItem = QtWidgets.QSpacerItem(40, 20, QtWidgets.QSizePolicy.Expanding, QtWidgets.QSizePolicy.Minimum)
|
|
|
self.horizontalLayout4.addItem(spacerItem)
|
|
|
spacerItem = QtWidgets.QSpacerItem(40, 20, QtWidgets.QSizePolicy.Expanding, QtWidgets.QSizePolicy.Minimum)
|
|
|
self.horizontalLayout5.addItem(spacerItem)
|
|
|
|
|
|
spacerItem = QtWidgets.QSpacerItem(40, 100, QtWidgets.QSizePolicy.Expanding, QtWidgets.QSizePolicy.Minimum)
|
|
|
self.verticalLayout.addItem(spacerItem)
|
|
|
self.verticalLayout.addWidget(self.widget)
|
|
|
spacerItem = QtWidgets.QSpacerItem(40, 300, QtWidgets.QSizePolicy.Expanding, QtWidgets.QSizePolicy.Minimum)
|
|
|
self.verticalLayout.addItem(spacerItem)
|
|
|
self.verticalLayout.addWidget(self.widget2)
|
|
|
self.verticalLayout.addWidget(self.widget3)
|
|
|
self.verticalLayout.addWidget(self.widget4)
|
|
|
self.verticalLayout.addWidget(self.widget5)
|
|
|
|
|
|
spacerItem = QtWidgets.QSpacerItem(40, 200, QtWidgets.QSizePolicy.Expanding, QtWidgets.QSizePolicy.Minimum)
|
|
|
self.verticalLayout.addItem(spacerItem)
|
|
|
|
|
|
_translate = QtCore.QCoreApplication.translate
|
|
|
self.pushButton_3.setText(_translate("Form", "修改密码"))
|
|
|
self.label_2.setText(_translate("Form", "用户名"))
|
|
|
self.pushButton_2.setText(_translate("Form", "修改"))
|
|
|
|
|
|
return self.right_widget
|
|
|
|
|
|
# 设置行可编辑
|
|
|
def editRow(self, id, flag, editable=True):
|
|
|
"""
|
|
|
:param id: 数据库id
|
|
|
:param flag: 1. 学生 2.班级 3.角色
|
|
|
:param editable: 是否设置单元格可编辑，默认true
|
|
|
:return:
|
|
|
"""
|
|
|
button = self.sender()
|
|
|
if button:
|
|
|
# 确定位置的时候这里是关键
|
|
|
row = self.tableWidget.indexAt(button.parent().pos()).row()
|
|
|
FLAGS = QtCore.Qt.ItemIsEnabled
|
|
|
if editable:
|
|
|
FLAGS = QtCore.Qt.ItemIsEditable | QtCore.Qt.ItemIsSelectable | FLAGS
|
|
|
BUTTONS = self.buttonForRowEdit(id, flag)
|
|
|
else:
|
|
|
BUTTONS = self.buttonForRow(id, flag)
|
|
|
|
|
|
if flag == C.FLAG_STUDENT:
|
|
|
item2 = self.tableWidget.item(row, 2)
|
|
|
item2.setFlags(FLAGS)
|
|
|
item2 = self.tableWidget.item(row, 3)
|
|
|
item2.setFlags(FLAGS)
|
|
|
item2 = self.tableWidget.item(row, 4)
|
|
|
item2.setFlags(FLAGS)
|
|
|
item2 = self.tableWidget.item(row, 5)
|
|
|
item2.setFlags(FLAGS)
|
|
|
self.tableWidget.setCellWidget(row, 6, BUTTONS)
|
|
|
elif flag == C.FLAG_GRADE:
|
|
|
item2 = self.tableWidget.item(row, 3)
|
|
|
item2.setFlags(FLAGS)
|
|
|
item2 = self.tableWidget.item(row, 4)
|
|
|
item2.setFlags(FLAGS)
|
|
|
item2 = self.tableWidget.item(row, 5)
|
|
|
item2.setFlags(FLAGS)
|
|
|
self.tableWidget.setCellWidget(row, 7, BUTTONS)
|
|
|
|
|
|
# 提交数据
|
|
|
def submitData(self, id, flag):
|
|
|
"""
|
|
|
:param id: 数据库id
|
|
|
:param flag: 1. 学生 2.班级 3.角色
|
|
|
:return:
|
|
|
"""
|
|
|
global class_dict2
|
|
|
# 调用sender()方法可以判断发送信号的信号源是哪一个
|
|
|
button = self.sender()
|
|
|
if button:
|
|
|
# 确定位置
|
|
|
row = self.tableWidget.indexAt(button.parent().pos()).row()
|
|
|
# 学生管理
|
|
|
if flag == C.FLAG_STUDENT:
|
|
|
name = self.tableWidget.item(row, 2).text()
|
|
|
number = self.tableWidget.item(row, 3).text()
|
|
|
sex = '1' if self.tableWidget.item(row, 4).text() == '男' else '2'
|
|
|
class_ = self.tableWidget.item(row, 5).text()
|
|
|
if class_ not in class_dict2.keys():
|
|
|
QMessageBox.critical(self, '输入有误', "该班级不存在！")
|
|
|
return
|
|
|
else:
|
|
|
try:
|
|
|
class_ = class_dict2[class_]
|
|
|
sql_execute(updateStudentById(id, name, number, sex, class_))
|
|
|
QMessageBox.about(self, '成功', "修改成功！")
|
|
|
self.editRow(id, flag, False)
|
|
|
except Exception as e:
|
|
|
print(e)
|
|
|
QMessageBox.critical(self, '编辑失败', "提交失败，请检查输入！")
|
|
|
return
|
|
|
|
|
|
# 成绩管理
|
|
|
elif flag == C.FLAG_GRADE:
|
|
|
chinese = self.tableWidget.item(row, 3).text()
|
|
|
math = self.tableWidget.item(row, 4).text()
|
|
|
english = self.tableWidget.item(row, 5).text()
|
|
|
if not chinese.isdigit() or not math.isdigit() or not english.isdigit():
|
|
|
QMessageBox.critical(self, '输入有误', "成绩只能为整数哦！")
|
|
|
return
|
|
|
else:
|
|
|
try:
|
|
|
sql_execute(updateGradeById(id, chinese, math, english))
|
|
|
self.tableWidget.item(row, 6).setText(str(int(chinese) + int(math) + int(english)))
|
|
|
self.editRow(id, flag, False)
|
|
|
|
|
|
except Exception as e:
|
|
|
print(e)
|
|
|
QMessageBox.critical(self, '失败', "提交失败，请检查输入！")
|
|
|
return
|
|
|
|
|
|
# 批量删除
|
|
|
def batchDelete(self, flag):
|
|
|
global all_header_combobox
|
|
|
ids = [-1]
|
|
|
for i in range(len(all_header_combobox)):
|
|
|
try:
|
|
|
if all_header_combobox[i].checkState() == 2:
|
|
|
if flag == C.FLAG_GRADE:
|
|
|
ids.append(self.tableWidget.item(i, 2).text())
|
|
|
else:
|
|
|
ids.append(self.tableWidget.item(i, 1).text())
|
|
|
except Exception as e:
|
|
|
print(e)
|
|
|
if len(ids) == 1:
|
|
|
QMessageBox.information(self, '失败', "未选择数据！")
|
|
|
return
|
|
|
self.deleteRow(ids, flag)
|
|
|
|
|
|
# 删除数据
|
|
|
def deleteRow(self, ids, flag):
|
|
|
"""
|
|
|
:param ids: 数据库id列表
|
|
|
:param flag: 1.学生 2.班级 3.角色 4.班级
|
|
|
:return:
|
|
|
"""
|
|
|
global all_header_combobox
|
|
|
if flag == C.FLAG_GRADE:
|
|
|
title = '清零'
|
|
|
tips = '确定清零该学生成绩?' if len(ids) == 1 else '确定清零' + str(len(ids) - 1) + '个学生成绩?'
|
|
|
else:
|
|
|
title = '删除'
|
|
|
tips = '确定删除该条数据?' if len(ids) == 1 else '确定删除' + str(len(ids) - 1) + '条数据?'
|
|
|
|
|
|
reply = QMessageBox.question(self, title, tips, QMessageBox.Yes | QMessageBox.No, QMessageBox.No)
|
|
|
if reply == QMessageBox.Yes:
|
|
|
if len(ids) <= 1:
|
|
|
button = self.sender()
|
|
|
if button:
|
|
|
# 确定位置的时候这里是关键
|
|
|
row = self.tableWidget.indexAt(button.parent().pos()).row()
|
|
|
if flag == C.FLAG_STUDENT:
|
|
|
result = sql_execute(delStudentById(ids[0]))
|
|
|
self.tableWidget.removeRow(row)
|
|
|
del all_header_combobox[row]
|
|
|
elif flag == C.FLAG_GRADE:
|
|
|
result = sql_execute(updateGradeById(ids[0], '0', '0', '0'))
|
|
|
self.tableWidget.item(row, 3).setText('0')
|
|
|
self.tableWidget.item(row, 4).setText('0')
|
|
|
self.tableWidget.item(row, 5).setText('0')
|
|
|
self.tableWidget.item(row, 6).setText('0')
|
|
|
elif flag == C.FLAG_CLASS:
|
|
|
result = sql_execute(getStudentByClassId(ids[0]))
|
|
|
if len(result) > 0:
|
|
|
QMessageBox.information(self, '失败', "该班级还有学生！请移除学生后再删除该班级。")
|
|
|
return
|
|
|
else:
|
|
|
sql_execute(delClassById(ids[0]))
|
|
|
self.tableWidget.removeRow(row)
|
|
|
elif flag == C.FLAG_ADMIN:
|
|
|
if ids[0] == 1:
|
|
|
QMessageBox.information(self, '失败', "超管账号不可删除！")
|
|
|
return
|
|
|
else:
|
|
|
sql_execute(delAdminById(ids[0]))
|
|
|
self.tableWidget.removeRow(row)
|
|
|
|
|
|
else:
|
|
|
errIds = []
|
|
|
i = None
|
|
|
for id in ids:
|
|
|
if flag == C.FLAG_STUDENT:
|
|
|
result = sql_execute(delStudentById(id))
|
|
|
elif flag == C.FLAG_GRADE:
|
|
|
result = sql_execute(updateGradeByNum(id, '0', '0', '0'))
|
|
|
elif flag == C.FLAG_CLASS:
|
|
|
result = sql_execute(getStudentByClassId(id))
|
|
|
if len(result) > 0:
|
|
|
errIds.append(id)
|
|
|
continue
|
|
|
else:
|
|
|
sql_execute(delClassById(id))
|
|
|
elif flag == C.FLAG_ADMIN:
|
|
|
if id == '1':
|
|
|
QMessageBox.information(self, '失败', "超管账号不可删除！")
|
|
|
continue
|
|
|
else:
|
|
|
sql_execute(delAdminById(id))
|
|
|
i = -1
|
|
|
if flag == C.FLAG_CLASS:
|
|
|
if len(errIds) == 0:
|
|
|
QMessageBox.about(self, '操作完成', "成功删除班级%d个。" % (len(ids) - 1))
|
|
|
else:
|
|
|
QMessageBox.information(self, '操作完成',
|
|
|
"成功删除班级%d个，失败%d个。\n失败班级id：%s\n这些班级内还有学生，无法删除，请移除学生后再进行该操作！"
|
|
|
% (len(ids) - len(errIds) - 1, len(errIds), str(errIds)))
|
|
|
self.getDataList(flag=flag, i=-1)
|
|
|
return
|
|
|
self.getDataList(flag=flag, i=i)
|
|
|
|
|
|
# 查看详情
|
|
|
def viewTable(self, id, flag):
|
|
|
"""
|
|
|
:param id: 数据库id
|
|
|
:param flag: xx管理
|
|
|
:return:
|
|
|
"""
|
|
|
if flag == C.FLAG_GRADE:
|
|
|
result = sql_execute(getStudentById(id))
|
|
|
result = result[0]
|
|
|
sex = '男' if result[3] == 1 else '女'
|
|
|
class_ = result[4]
|
|
|
if class_ not in class_dict.keys():
|
|
|
class_ = '/'
|
|
|
else:
|
|
|
class_ = class_dict[class_]
|
|
|
total = result[5] + result[6] + result[7]
|
|
|
str = 'id：%d\n姓名：%s \n学号：%d\n性别：%s\n班级：%s\n语文成绩：%d\n数学成绩：%d\n英语成绩：%d\n总成绩：%d' \
|
|
|
% (result[0], result[1], result[2], sex, class_, result[5], result[6], result[7], total)
|
|
|
|
|
|
QMessageBox.about(self, '详情', str)
|
|
|
|
|
|
# 编辑、添加、提交、删除按钮
|
|
|
def buttonForRow(self, id, flag, info=''):
|
|
|
"""
|
|
|
:param id: 数据库中数据id
|
|
|
:param flag: xx管理
|
|
|
:param info: 其他附加信息
|
|
|
:return:
|
|
|
"""
|
|
|
widget = QWidget()
|
|
|
|
|
|
# 编辑
|
|
|
updateBtn = QPushButton('编辑')
|
|
|
updateBtn.setStyleSheet(''' text-align : center;
|
|
|
background-color : orange;
|
|
|
height : 30px;
|
|
|
border-style: outset;
|
|
|
border-radius: 5px;
|
|
|
color: #fff;
|
|
|
font : 12px ''')
|
|
|
if flag == C.FLAG_CLASS:
|
|
|
updateBtn.clicked.connect(lambda: self.editClass(id, info))
|
|
|
elif flag == C.FLAG_ADMIN:
|
|
|
updateBtn.clicked.connect(lambda: self.editAdmin(id))
|
|
|
else:
|
|
|
updateBtn.clicked.connect(lambda: self.editRow(id, flag))
|
|
|
|
|
|
# 删除
|
|
|
deleteBtn = QPushButton('删除')
|
|
|
deleteBtn.setStyleSheet(''' text-align : center;
|
|
|
background-color : LightCoral;
|
|
|
height : 30px;
|
|
|
border-style: outset;
|
|
|
border-radius: 5px;
|
|
|
color: #fff;
|
|
|
font : 13px; ''')
|
|
|
deleteBtn.clicked.connect(lambda: self.deleteRow([id], flag))
|
|
|
|
|
|
# 成绩管理
|
|
|
if flag == C.FLAG_GRADE:
|
|
|
updateBtn.setText("编辑")
|
|
|
deleteBtn.setText("清零")
|
|
|
# 查看
|
|
|
viewBtn = QPushButton('详情')
|
|
|
viewBtn.setStyleSheet(''' text-align : center;
|
|
|
background-color : #5dc7f1;
|
|
|
height : 30px;
|
|
|
border-style: outset;
|
|
|
border-radius: 5px;
|
|
|
color: #fff;
|
|
|
font : 13px; ''')
|
|
|
|
|
|
viewBtn.clicked.connect(lambda: self.viewTable(id, flag))
|
|
|
|
|
|
hLayout = QHBoxLayout()
|
|
|
hLayout.addWidget(updateBtn)
|
|
|
if flag == C.FLAG_GRADE:
|
|
|
hLayout.addWidget(viewBtn)
|
|
|
hLayout.addWidget(deleteBtn)
|
|
|
hLayout.setContentsMargins(5, 2, 5, 2)
|
|
|
widget.setLayout(hLayout)
|
|
|
return widget
|
|
|
|
|
|
# 添加提交、取消按钮
|
|
|
def buttonForRowEdit(self, id, flag):
|
|
|
"""
|
|
|
:param id: 数据库中数据id
|
|
|
:param flag: xx管理
|
|
|
:return:
|
|
|
"""
|
|
|
widget = QWidget()
|
|
|
# 提交
|
|
|
updateBtn = QPushButton('提交')
|
|
|
updateBtn.setStyleSheet(''' text-align : center;
|
|
|
background-color : DarkSeaGreen;
|
|
|
height : 30px;
|
|
|
border-style: outset;
|
|
|
border-radius: 5px;
|
|
|
color: #fff;
|
|
|
font : 12px ''')
|
|
|
|
|
|
updateBtn.clicked.connect(lambda: self.submitData(id, flag))
|
|
|
|
|
|
# 取消
|
|
|
cancelBtn = QPushButton('取消')
|
|
|
cancelBtn.setStyleSheet(''' text-align : center;
|
|
|
background-color : #aaa;
|
|
|
height : 30px;
|
|
|
border-style: outset;
|
|
|
border-radius: 5px;
|
|
|
color: #fff;
|
|
|
font : 13px; ''')
|
|
|
cancelBtn.clicked.connect(lambda: self.editRow(id, flag, False))
|
|
|
|
|
|
hLayout = QHBoxLayout()
|
|
|
hLayout.addWidget(updateBtn)
|
|
|
hLayout.addWidget(cancelBtn)
|
|
|
hLayout.setContentsMargins(5, 2, 5, 2)
|
|
|
widget.setLayout(hLayout)
|
|
|
return widget
|
|
|
|
|
|
# 获取并更新数据列表 i: 班级index
|
|
|
def getDataList(self, flag, i=None):
|
|
|
global all_class, data_list
|
|
|
data_list = ()
|
|
|
name = self.input_name.text()
|
|
|
if i is None:
|
|
|
i = self.cb.currentIndex()
|
|
|
if i == 0:
|
|
|
classIds = C.USER[4]
|
|
|
elif i < 0:
|
|
|
pass
|
|
|
else:
|
|
|
classIds = str(all_class[i - 1][0])
|
|
|
if flag == C.FLAG_STUDENT:
|
|
|
data_list = sql_execute(getStudentList(classIds, name))
|
|
|
elif flag == C.FLAG_GRADE:
|
|
|
data_list = sql_execute(getGradeList(classIds, name))
|
|
|
elif flag == C.FLAG_CLASS:
|
|
|
data_list = self.getClassList(name)
|
|
|
elif flag == C.FLAG_ADMIN:
|
|
|
data_list = sql_execute(getAdminList(name))
|
|
|
self.addTableRow(flag, data_list)
|
|
|
|
|
|
# 添加数据
|
|
|
def addTableRow(self, flag, dataList):
|
|
|
global all_header_combobox, class_dict
|
|
|
all_header_combobox = []
|
|
|
|
|
|
self.tableWidget.setRowCount(0)
|
|
|
if len(dataList) == 0:
|
|
|
self.tableWidget.setRowCount(1)
|
|
|
item = QTableWidgetItem()
|
|
|
item.setTextAlignment(QtCore.Qt.AlignCenter)
|
|
|
item.setText("无数据")
|
|
|
self.tableWidget.setItem(0, 0, item)
|
|
|
return
|
|
|
|
|
|
self.tableWidget.setRowCount(len(dataList))
|
|
|
i = 0
|
|
|
for data in dataList:
|
|
|
if not (flag == C.FLAG_ADMIN and data[0] == 1):
|
|
|
checkbox1 = QtWidgets.QCheckBox()
|
|
|
# 将所有的复选框都添加到 全局变量 all_header_combobox 中
|
|
|
all_header_combobox.append(checkbox1)
|
|
|
# 1.实例化一个新布局
|
|
|
hLayout = QtWidgets.QFormLayout()
|
|
|
# 2.在布局里添加checkBox
|
|
|
hLayout.addWidget(checkbox1)
|
|
|
# 3.在布局里居中放置checkbox1
|
|
|
hLayout.setAlignment(checkbox1, QtCore.Qt.AlignCenter)
|
|
|
# 4.实例化一个QWidget（控件）
|
|
|
widget = QtWidgets.QWidget()
|
|
|
# 5.在QWidget放置布局
|
|
|
widget.setLayout(hLayout)
|
|
|
# 6.在tableWidget1放置widget
|
|
|
self.tableWidget.setCellWidget(i, 0, widget)
|
|
|
if flag == C.FLAG_STUDENT:
|
|
|
item = QTableWidgetItem(str(data[0]))
|
|
|
item.setTextAlignment(QtCore.Qt.AlignCenter)
|
|
|
item.setFlags(QtCore.Qt.ItemIsEnabled)
|
|
|
self.tableWidget.setItem(i, 1, item)
|
|
|
item = QTableWidgetItem()
|
|
|
item.setTextAlignment(QtCore.Qt.AlignCenter)
|
|
|
item.setText(data[1])
|
|
|
item.setFlags(QtCore.Qt.ItemIsEnabled)
|
|
|
self.tableWidget.setItem(i, 2, item)
|
|
|
item = QTableWidgetItem()
|
|
|
item.setTextAlignment(QtCore.Qt.AlignCenter)
|
|
|
item.setText(str(data[2]))
|
|
|
item.setFlags(QtCore.Qt.ItemIsEnabled)
|
|
|
self.tableWidget.setItem(i, 3, item)
|
|
|
item = QTableWidgetItem()
|
|
|
item.setTextAlignment(QtCore.Qt.AlignCenter)
|
|
|
item.setText('男' if data[3] == 1 else '女')
|
|
|
item.setFlags(QtCore.Qt.ItemIsEnabled)
|
|
|
self.tableWidget.setItem(i, 4, item)
|
|
|
item = QTableWidgetItem()
|
|
|
item.setTextAlignment(QtCore.Qt.AlignCenter)
|
|
|
item.setText(class_dict[data[4]])
|
|
|
item.setFlags(QtCore.Qt.ItemIsEnabled)
|
|
|
self.tableWidget.setItem(i, 5, item)
|
|
|
self.tableWidget.setCellWidget(i, 6, self.buttonForRow(data[0], C.FLAG_STUDENT))
|
|
|
elif flag == C.FLAG_GRADE:
|
|
|
item = QTableWidgetItem(str(data[1]))
|
|
|
item.setTextAlignment(QtCore.Qt.AlignCenter)
|
|
|
item.setFlags(QtCore.Qt.ItemIsEnabled)
|
|
|
self.tableWidget.setItem(i, 1, item)
|
|
|
item = QTableWidgetItem()
|
|
|
item.setTextAlignment(QtCore.Qt.AlignCenter)
|
|
|
item.setText(str(data[2]))
|
|
|
item.setFlags(QtCore.Qt.ItemIsEnabled)
|
|
|
self.tableWidget.setItem(i, 2, item)
|
|
|
|
|
|
chinese = data[5] if data[5] is not None else 0
|
|
|
math = data[6] if data[6] is not None else 0
|
|
|
english = data[7] if data[7] is not None else 0
|
|
|
total = chinese + math + english
|
|
|
|
|
|
item = QTableWidgetItem()
|
|
|
item.setTextAlignment(QtCore.Qt.AlignCenter)
|
|
|
item.setText(str(chinese))
|
|
|
item.setFlags(QtCore.Qt.ItemIsEnabled)
|
|
|
self.tableWidget.setItem(i, 3, item)
|
|
|
item = QTableWidgetItem()
|
|
|
item.setTextAlignment(QtCore.Qt.AlignCenter)
|
|
|
item.setText(str(math))
|
|
|
item.setFlags(QtCore.Qt.ItemIsEnabled)
|
|
|
self.tableWidget.setItem(i, 4, item)
|
|
|
item = QTableWidgetItem()
|
|
|
item.setTextAlignment(QtCore.Qt.AlignCenter)
|
|
|
item.setText(str(english))
|
|
|
item.setFlags(QtCore.Qt.ItemIsEnabled)
|
|
|
self.tableWidget.setItem(i, 5, item)
|
|
|
item = QTableWidgetItem()
|
|
|
item.setTextAlignment(QtCore.Qt.AlignCenter)
|
|
|
item.setText(str(total))
|
|
|
item.setFlags(QtCore.Qt.ItemIsEnabled)
|
|
|
self.tableWidget.setItem(i, 6, item)
|
|
|
self.tableWidget.setCellWidget(i, 7, self.buttonForRow(data[0], C.FLAG_GRADE))
|
|
|
elif flag == C.FLAG_CLASS:
|
|
|
item = QTableWidgetItem(str(data[0]))
|
|
|
item.setTextAlignment(QtCore.Qt.AlignCenter)
|
|
|
item.setFlags(QtCore.Qt.ItemIsEnabled)
|
|
|
self.tableWidget.setItem(i, 1, item)
|
|
|
item = QTableWidgetItem()
|
|
|
item.setTextAlignment(QtCore.Qt.AlignCenter)
|
|
|
item.setText(str(data[1]))
|
|
|
item.setFlags(QtCore.Qt.ItemIsEnabled)
|
|
|
self.tableWidget.setItem(i, 2, item)
|
|
|
self.tableWidget.setCellWidget(i, 3, self.buttonForRow(data[0], C.FLAG_CLASS, info=data[1]))
|
|
|
elif flag == C.FLAG_ADMIN:
|
|
|
item = QTableWidgetItem(str(data[0]))
|
|
|
item.setTextAlignment(QtCore.Qt.AlignCenter)
|
|
|
item.setFlags(QtCore.Qt.ItemIsEnabled)
|
|
|
self.tableWidget.setItem(i, 1, item)
|
|
|
item = QTableWidgetItem()
|
|
|
item.setTextAlignment(QtCore.Qt.AlignCenter)
|
|
|
item.setText(str(data[1]))
|
|
|
item.setFlags(QtCore.Qt.ItemIsEnabled)
|
|
|
self.tableWidget.setItem(i, 2, item)
|
|
|
item = QTableWidgetItem()
|
|
|
item.setTextAlignment(QtCore.Qt.AlignCenter)
|
|
|
item.setText(str(data[3]))
|
|
|
item.setFlags(QtCore.Qt.ItemIsEnabled)
|
|
|
self.tableWidget.setItem(i, 3, item)
|
|
|
item = QTableWidgetItem()
|
|
|
item.setTextAlignment(QtCore.Qt.AlignCenter)
|
|
|
try:
|
|
|
class_dict = {}
|
|
|
all_class = self.getClassList()
|
|
|
for class_ in all_class:
|
|
|
# 添加班级字典
|
|
|
class_dict[str(class_[0])] = class_[1]
|
|
|
classs = 'All'
|
|
|
if data[4] == '':
|
|
|
classs = '无'
|
|
|
elif data[4] != '0':
|
|
|
data4 = data[4].split(',')
|
|
|
classs = "/".join(class_dict[d] for d in data4)
|
|
|
except Exception as e:
|
|
|
classs = 'err: 数据有误！'
|
|
|
item.setText(classs)
|
|
|
item.setFlags(QtCore.Qt.ItemIsEnabled)
|
|
|
self.tableWidget.setItem(i, 4, item)
|
|
|
# 超管
|
|
|
if data[0] == 1:
|
|
|
item = QTableWidgetItem()
|
|
|
item.setTextAlignment(QtCore.Qt.AlignCenter)
|
|
|
item.setText('无权限')
|
|
|
item.setFlags(QtCore.Qt.ItemIsEnabled)
|
|
|
self.tableWidget.setItem(i, 5, item)
|
|
|
else:
|
|
|
self.tableWidget.setCellWidget(i, 5, self.buttonForRow(data[0], C.FLAG_ADMIN))
|
|
|
i += 1
|
|
|
|
|
|
# 获取班级列表
|
|
|
def getClassList(self, name=''):
|
|
|
print("获取班级列表")
|
|
|
return sql_execute(getClassList(C.USER[4], name))
|
|
|
|
|
|
# 设置左侧选中菜单按钮的样式
|
|
|
def setLeftMenu(self, button):
|
|
|
global activat_menu
|
|
|
if activat_menu != None:
|
|
|
activat_menu.setStyleSheet('''
|
|
|
width:20px;
|
|
|
font-size:15px;
|
|
|
''')
|
|
|
activat_menu = button
|
|
|
button.setStyleSheet('''
|
|
|
width:20px;
|
|
|
font-size:15px;
|
|
|
border-left:4px solid #00bcd4;
|
|
|
font-weight:700;
|
|
|
''')
|
|
|
|
|
|
# 新增数据
|
|
|
def createData(self, flag):
|
|
|
if flag == C.FLAG_CLASS:
|
|
|
text, okPressed = QInputDialog.getText(self, "新增班级", "班级名称:", QLineEdit.Normal, "")
|
|
|
if okPressed and text != '':
|
|
|
try:
|
|
|
sql_execute(insertClass(text))
|
|
|
QMessageBox.about(self, '成功', '新增班级成功！')
|
|
|
self.getDataList(flag, i=-1)
|
|
|
except Exception as e:
|
|
|
QMessageBox.critical(self, '失败', '新增班级失败：\n' + e)
|
|
|
|
|
|
# 编辑班级
|
|
|
def editClass(self, id, old):
|
|
|
text, okPressed = QInputDialog.getText(self, "编辑班级", "班级名称:", QLineEdit.Normal, old)
|
|
|
if okPressed and text != '':
|
|
|
try:
|
|
|
sql_execute(updateClassById(id, text))
|
|
|
QMessageBox.about(self, '成功', '班级编辑成功！')
|
|
|
self.getDataList(C.FLAG_CLASS, i=-1)
|
|
|
except Exception as e:
|
|
|
QMessageBox.critical(self, '失败', '编辑班级失败：\n' + e)
|
|
|
|
|
|
# 退出登录
|
|
|
def logOut(self, tips=False):
|
|
|
if tips:
|
|
|
reply = QMessageBox.question(self, '退出登录', '确定要退出登录吗？', QMessageBox.Yes | QMessageBox.No,
|
|
|
QMessageBox.No)
|
|
|
if reply != QMessageBox.Yes:
|
|
|
return
|
|
|
gl_user = ()
|
|
|
self.aw = C.LOGIN_WINDOW # 创建主窗体对象，实例化Ui_MainWindow
|
|
|
self.w = QMainWindow() # 实例化QMainWindow类
|
|
|
self.aw.setupUi(self.w) # 主窗体对象调用setupUi方法，对QMainWindow对象进行设置
|
|
|
self.w.show() # 显示主窗体
|
|
|
self.hide()
|
|
|
|
|
|
# 修改用户名
|
|
|
def editUsername(self):
|
|
|
reply = QMessageBox.question(self, '修改用户名', '修改用户名后，需要重新登录。是否继续？',
|
|
|
QMessageBox.Yes | QMessageBox.No, QMessageBox.No)
|
|
|
if reply == QMessageBox.Yes:
|
|
|
username = self.input_name.text()
|
|
|
sql_execute(updateUsernameById(C.USER[0], username))
|
|
|
QMessageBox.about(self, '成功', '用户名修改成功！请重新登录。')
|
|
|
self.logOut(False)
|
|
|
# self.aw = Ui_MainWindow() # 创建主窗体对象，实例化Ui_MainWindow
|
|
|
# self.w = QMainWindow() # 实例化QMainWindow类
|
|
|
# self.aw.setupUi(self.w) # 主窗体对象调用setupUi方法，对QMainWindow对象进行设置
|
|
|
# self.w.show() # 显示主窗体
|
|
|
|
|
|
# 修改密码
|
|
|
def modifyPassw(self):
|
|
|
pass0 = self.input_pass0.text()
|
|
|
pass1 = self.input_pass1.text()
|
|
|
pass2 = self.input_pass2.text()
|
|
|
if pass1 != pass2:
|
|
|
QMessageBox.information(self, '错误', '两次密码输入不一致。')
|
|
|
return
|
|
|
else:
|
|
|
if C.USER[2] != md5(pass0):
|
|
|
QMessageBox.information(self, '错误', '原密码不正确！')
|
|
|
return
|
|
|
else:
|
|
|
sql_execute(resetAdminPasswById(C.USER[0], pass1))
|
|
|
QMessageBox.about(self, '成功', '密码修改成功！请重新登录。')
|
|
|
self.logOut(False)
|
|
|
|
|
|
# 编辑角色
|
|
|
def editAdmin(self, id):
|
|
|
self.aw = EditAdmin() # 创建主窗体对象，实例化Ui_MainWindow
|
|
|
self.w = QMainWindow() # 实例化QMainWindow类
|
|
|
self.aw.setupUi(self.w, id) # 主窗体对象调用setupUi方法，对QMainWindow对象进行设置
|
|
|
self.w.show() # 显示主窗体
|
|
|
|
|
|
# 新增角色
|
|
|
def addAdmin(self):
|
|
|
self.aw = AddAdmin() # 创建主窗体对象，实例化Ui_MainWindow
|
|
|
self.w = QMainWindow() # 实例化QMainWindow类
|
|
|
self.aw.setupUi(self.w) # 主窗体对象调用setupUi方法，对QMainWindow对象进行设置
|
|
|
self.w.show() # 显示主窗体
|
|
|
|
|
|
# 导入数据
|
|
|
def open_file(self, flag):
|
|
|
"""
|
|
|
:param flag: xx管理
|
|
|
:return:
|
|
|
"""
|
|
|
data_format = ''
|
|
|
if flag == C.FLAG_STUDENT:
|
|
|
data_format = '姓名/学号/性别/班级'
|
|
|
elif flag == C.FLAG_GRADE:
|
|
|
data_format = '姓名/学号/语文成绩/数学成绩/英语成绩'
|
|
|
QMessageBox.information(self, '导入',
|
|
|
"请在弹出的文件选择框中选择数据文件（仅支持csv格式文件）！\n 数据格式：%s，从第2行开始读数据" % data_format)
|
|
|
fileName, fileType = QtWidgets.QFileDialog.getOpenFileName(self, "选取文件", os.getcwd()+'/data', "CSV Files(*.csv)")
|
|
|
if fileName == '':
|
|
|
return
|
|
|
try:
|
|
|
data = pd.read_csv(fileName)
|
|
|
except Exception as e:
|
|
|
data = pd.read_csv(fileName, encoding='gbk')
|
|
|
print(e)
|
|
|
|
|
|
success_count = fail_count = 0
|
|
|
errText = ''
|
|
|
|
|
|
for d in data.itertuples():
|
|
|
try:
|
|
|
# 学生管理
|
|
|
if flag == C.FLAG_STUDENT:
|
|
|
sex = '1' if d[3] == '男' else '2'
|
|
|
class_ = d[4]
|
|
|
if class_ not in class_dict2.keys():
|
|
|
fail_count += 1
|
|
|
errText += '\n %s : 班级[%s]不存在/无权访问！' % (d[1], class_)
|
|
|
continue
|
|
|
else:
|
|
|
class_ = class_dict2[class_]
|
|
|
sql_execute(insertStudent(d[1], d[2], sex, class_))
|
|
|
success_count += 1
|
|
|
elif flag == C.FLAG_GRADE:
|
|
|
sql_execute(updateGradeByNum(d[2], d[3], d[4], d[5]))
|
|
|
success_count += 1
|
|
|
except Exception as e:
|
|
|
fail_count += 1
|
|
|
errText += '\n %s : %s' % (d[1], e)
|
|
|
|
|
|
if fail_count > 0:
|
|
|
QMessageBox.about(self, '导入完成',
|
|
|
"数据成功导入%d条，失败%d条。\n错误信息如下：%s" % (success_count, fail_count, errText))
|
|
|
else:
|
|
|
QMessageBox.about(self, '导入成功', "成功导入数据%d条！" % success_count)
|
|
|
# 刷新列表
|
|
|
self.getDataList(flag)
|
|
|
|
|
|
# 数据导出
|
|
|
def data_export(self, flag):
|
|
|
"""
|
|
|
:param flag: xx管理
|
|
|
:return:
|
|
|
"""
|
|
|
global data_list
|
|
|
self.getDataList(flag)
|
|
|
filename = ''
|
|
|
columns = []
|
|
|
if flag == C.FLAG_STUDENT:
|
|
|
filename = 'Students'
|
|
|
columns = ['姓名', '学号', '性别', '班级']
|
|
|
elif flag == C.FLAG_GRADE:
|
|
|
filename = 'Grade'
|
|
|
columns = ['姓名', '学号', '语文成绩', '数学成绩', '英语成绩', '总分', '排名']
|
|
|
# 保存文件对话框
|
|
|
file_path = QFileDialog.getSaveFileName(self, "数据导出", "data/%s.csv" % filename,
|
|
|
"CSV Files(*.csv);;all files(*.*)")
|
|
|
if file_path[0] == '':
|
|
|
return
|
|
|
try:
|
|
|
save_data = pd.DataFrame(columns=columns)
|
|
|
for index, data in enumerate(data_list):
|
|
|
d = []
|
|
|
if flag == C.FLAG_STUDENT:
|
|
|
sex = '男' if data[3] == 1 else '女'
|
|
|
class_ = data[4]
|
|
|
if class_ not in class_dict.keys():
|
|
|
class_ = '/'
|
|
|
else:
|
|
|
class_ = class_dict[class_]
|
|
|
d = [data[1], data[2], sex, class_]
|
|
|
elif flag == C.FLAG_GRADE:
|
|
|
total = int(data[5]) + int(data[6]) + int(data[7])
|
|
|
d = [data[1], data[2], data[5], data[6], data[7], total, index + 1]
|
|
|
save_data.loc[index] = d
|
|
|
save_data.to_csv(file_path[0], index=False)
|
|
|
QMessageBox.about(self, '成功', "数据成功导出至：%s" % file_path[0])
|
|
|
except Exception as e:
|
|
|
QMessageBox.critical(self, '保存失败', "保存失败：%s" % e)
|
|
|
print(e)
|
|
|
|
|
|
|
|
|
def main():
|
|
|
app = QtWidgets.QApplication(sys.argv)
|
|
|
gui = MainUi()
|
|
|
gui.show()
|
|
|
sys.exit(app.exec_())
|
|
|
|
|
|
|
|
|
# 测试用入口
|
|
|
if __name__ == '__main__':
|
|
|
main()
|
