唐承乾

1
# PyQt5中使用的基本控件都在PyQt5.QtWidgets模块中
2
from PyQt5.QtWidgets import QApplication, QMainWindow
3
# 导入程序运行必须模块
4
import sys
5
# 导入designer工具生成的login模块
6
from qs11 import Ui_MainWindow
7
# 导入自定义的类
8
from student import *
9
from functools import partial
10
import operator  # 用于排序的包
11
from PyQt5 import QtCore
12
from qt_material import apply_stylesheet
13

14
all_student = []  # 存放所有的学生
15

16

17
class MyMainForm(QMainWindow, Ui_MainWindow):
18
    def __init__(self, parent=None):
19
        super(MyMainForm, self).__init__(parent)
20
        self.cursot = None
21
        self.setupUi(self)
22
        self.save_button.clicked.connect(partial(self.save_issue))
23
        self.dis_button.clicked.connect(partial(self.display_inf))
24
        self.clear_counter.clicked.connect(partial(self.clearStudent))
25

26
    # 存储学生信息
27
    def save_issue(self):
28
        person = student()
29
        person.setName(self.user_line.text())
30
        person.setGrade(int(self.grade_line.text()))
31
        all_student.append(person)
32

33
        self.user_line.clear()
34
        self.grade_line.clear()
35

36
    def printf(self, mes):
37
        self.inf_dis.append(mes)  # 在指定的区域显示提示信息
38
        self.cursot = self.inf_dis.textCursor()
39
        self.inf_dis.moveCursor(self.cursot.End)
40

41
    def display_inf(self):
42
        # 排序
43
        cmpfun = operator.attrgetter('grade', 'name')
44
        all_student.sort(key=cmpfun, reverse=True)
45
        # 清空上次显示的内容
46
        self.inf_dis.clear()
47
        # 显示当前排序好后的内容
48
        for i in range(len(all_student)):
49
            self.printf("%s %d" % (all_student[i].name, all_student[i].grade))
50

51
    # 清空存储的学生信息
52
    def clearStudent(self):
53
        self.user_line.clear()
54
        self.grade_line.clear()
55
        self.inf_dis.clear()
56
        all_student.clear()
57

58

59
if __name__ == '__main__':
60
    QtCore.QCoreApplication.setAttribute(QtCore.Qt.AA_EnableHighDpiScaling)  # 解决页面显示不一致的问题
61
    app = QApplication(sys.argv)
62

63
    myWin = MyMainForm()
64
    apply_stylesheet(app, theme='dark_red.xml')
65
    myWin.show()
66

67
    sys.exit(app.exec_())

1
class student:
2
    def __init__(self):
3
        self.grade = None  # 用户成绩
4
        self.name = ' '  # 用户姓名
5

6
    # 设置成绩
7
    def setGrade(self, grade):
8
        self.grade = grade
9

10
    # 设置姓名
11
    def setName(self, name):
12
        self.name = name

1
# PyQt5中使用的基本控件都在PyQt5.QtWidgets模块中
2
from PyQt5.QtWidgets import QApplication, QMainWindow
3
from PyQt5 import QtCore
4
# 导入程序运行必须模块
5
import sys
6
# 导入designer工具生成的login模块
7
from qus12 import Ui_MainWindow
8
from functools import partial
9
import random
10
from qt_material import apply_stylesheet
11

12
num_all = 0  # 总共输入的次数
13
num_cor = 0  # 正确输入的次数
14

15

16
# 获取随机字符串
17
def GetRandomStr():
18
    lst = random.sample('zyxwvutsrqponmlkjihgfedcba', random.randint(1, 10))
19
    s2 = "".join([str(e) for e in lst])  # 使用空字符串拼接字符串列表
20
    return s2
21

22

23
class MyMainForm(QMainWindow, Ui_MainWindow):
24
    def __init__(self, parent=None):
25
        super(MyMainForm, self).__init__(parent)
26
        self.cursot = None
27
        self.setupUi(self)
28
        self.bar.setMaximum(100)
29
        self.bar.setMinimum(0)
30
        self.bar.setValue(100)
31
        self.rightnot.append("")
32
        self.lineEdit.setText(GetRandomStr())
33
        self.lineEdit_2.returnPressed.connect(partial(self.input_call))
34
        self.clear_button.clicked.connect(partial(self.clear_app))
35

36
    # 当输入完成并敲击回车后，调用此函数
37
    def input_call(self):
38
        global num_all
39
        global num_cor
40
        num_all += 1
41
        str1 = self.lineEdit.text()
42
        str2 = self.lineEdit_2.text()
43
        # 比较是否正确
44
        if str1 == str2:
45
            num_cor += 1
46
            self.rightnot.setText("正确")
47
        else:
48
            self.rightnot.setText("错误")
49
        # 显示正确率
50
        self.accuracy.setText("%2.1f" % (num_cor * 100 / num_all) + '%')
51
        self.bar.setValue((num_cor * 100 / num_all))
52
        # 更新随机字符串
53
        self.lineEdit.setText(GetRandomStr())
54
        self.lineEdit_2.clear()
55

56
    # 清空屏幕和归零正确率
57
    def clear_app(self):
58
        global num_all
59
        global num_cor
60
        self.lineEdit_2.clear()
61
        self.rightnot.clear()
62
        self.accuracy.clear()
63
        num_all = 0
64
        num_cor = 0
65

66

67
if __name__ == '__main__':
68
    QtCore.QCoreApplication.setAttribute(QtCore.Qt.AA_EnableHighDpiScaling)
69
    app = QApplication(sys.argv)
70

71
    myWin = MyMainForm()
72
    apply_stylesheet(app, theme='dark_red.xml')
73
    myWin.show()
74

75
    sys.exit(app.exec_())

1
import sys
2
# PyQt5中使用的基本控件都在PyQt5.QtWidgets模块中
3
from PyQt5.QtWidgets import QApplication, QMainWindow
4
# 导入程序运行必须模块
5
import sys
6
# 导入designer工具生成的login模块
7
from qus13 import Ui_MainWindow
8
from PyQt5 import QtCore
9
from functools import partial
10
import os
11
from qt_material import apply_stylesheet
12

13

14
class MyMainForm(QMainWindow, Ui_MainWindow):
15
    def __init__(self, parent=None):
16
        super(MyMainForm, self).__init__(parent)
17
        self.cursot = None
18
        self.setupUi(self)
19
        self.f = ''
20
        self.open_file.clicked.connect(partial(self.input_path))
21
        self.write_file.clicked.connect(partial(self.write_content))
22

23
    def input_path(self):
24
        if os.path.exists(self.path_edit.text()):
25
            with open(self.path_edit.text(), 'r+') as self.f:
26
                self.textEdit.setText('')
27
                for str in self.f.readlines():
28
                    self.printf(str)
29
                self.f.close()
30
        else:
31
            open(self.path_edit.text(), 'w')
32

33
    def printf(self, mes):
34
        self.textEdit.insertPlainText(mes)  # 在指定的区域显示提示信息
35

36
    def write_content(self):
37
        with open(self.path_edit.text(), 'r+') as self.f:
38
            self.f.truncate()
39
            self.f.writelines(self.textEdit.toPlainText())
40
            self.f.close()
41

42

43
if __name__ == '__main__':
44
    QtCore.QCoreApplication.setAttribute(QtCore.Qt.AA_EnableHighDpiScaling)
45
    app = QApplication(sys.argv)
46

47
    myWin = MyMainForm()
48
    apply_stylesheet(app, theme='dark_red.xml')
49
    myWin.show()
50

51
    sys.exit(app.exec_())

1
# PyQt5中使用的基本控件都在PyQt5.QtWidgets模块中
2
from PyQt5.QtWidgets import QApplication, QMainWindow
3
# 导入程序运行必须模块
4
import sys
5
# 导入designer工具生成的login模块
6
from qus14 import Ui_MainWindow
7
from PyQt5 import QtCore
8
from functools import partial
9
from qt_material import apply_stylesheet
10

11
# str应为字符串，k为整数
12
# 返回加密后的字符串
13
def encrypt(str, k):
14
    lis = []
15
    for i in range(len(str)):
16
        lis.append(str[i])
17
        lis[i] = chr(ord(lis[i]) + k)
18
    return "".join([e for e in lis])
19

20

21
class MyMainForm(QMainWindow, Ui_MainWindow):
22
    def __init__(self, parent=None):
23
        super(MyMainForm, self).__init__(parent)
24
        self.cursot = None
25
        self.setupUi(self)
26
        self.conv.clicked.connect(partial(self.my_conversion))
27

28
    def my_conversion(self):
29
        self.textEdit.clear()  # 清空上次的显示
30

31
        # 更新新的显示
32
        str = self.line1.text()
33
        K = int(self.line2.text())
34
        str_dis = encrypt(str, K)
35

36
        self.textEdit.append(str_dis)
37

38

39
if __name__ == '__main__':
40
    QtCore.QCoreApplication.setAttribute(QtCore.Qt.AA_EnableHighDpiScaling)  # 解决页面显示不一致的问题
41

42
    app = QApplication(sys.argv)
43

44
    myWin = MyMainForm()
45
    apply_stylesheet(app, theme='dark_red.xml')
46
    myWin.show()
47

48
    sys.exit(app.exec_())

1
# PyQt5中使用的基本控件都在PyQt5.QtWidgets模块中
2
from PyQt5.QtWidgets import QApplication, QMainWindow
3
# 导入程序运行必须模块
4
import sys
5
# 导入designer工具生成的login模块
6
from qus15 import Ui_MainWindow
7
from PyQt5 import QtCore
8
from functools import partial
9
from qt_material import apply_stylesheet
10

11

12
class MyMainForm(QMainWindow, Ui_MainWindow):
13
    def __init__(self, parent=None):
14
        super(MyMainForm, self).__init__(parent)
15
        self.setupUi(self)
16

17
        # 变量定义
18
        self.ori_sys = 0  # 原始进制格式
19
        self.tar_sys = 0  # 目标进制格式
20
        self.origin_sys = 0  # 原始进制格式的十进制表示
21

22
        self.target_dis = ''  # 用于进行显示的字符串
23
        # 信号事件定义
24
        self.cb1.currentIndexChanged.connect(partial(self.cb1_call))
25
        self.cb2.currentIndexChanged.connect(partial(self.cb2_call))
26
        self.conv.clicked.connect(partial(self.conv_call))
27

28
    def cb1_call(self):
29
        self.ori_sys = self.cb1.currentIndex()
30
        # print("原始进制为：%d" % self.ori_sys)
31

32
    def cb2_call(self):
33
        self.tar_sys = self.cb2.currentIndex()
34
        # print("目标进制为：%d" % self.tar_sys)
35

36
    def conv_call(self):
37
        # 统一进制表示
38
        if self.ori_sys == 0:
39
            self.origin_sys = 2
40
        elif self.ori_sys == 1:
41
            self.origin_sys = 8
42
        elif self.ori_sys == 2:
43
            self.origin_sys = 10
44
        else:
45
            self.origin_sys = 16
46
        try:
47
            origin = int(self.line1.text(), self.origin_sys)
48

49
            if self.tar_sys == 0:
50
                self.target_dis = bin(origin)
51
            elif self.tar_sys == 1:
52
                self.target_dis = oct(origin)
53
            elif self.tar_sys == 2:
54
                self.target_dis = origin
55
            else:
56
                self.target_dis = hex(origin)
57

58
            self.line2.setText(str(self.target_dis))
59
        except ValueError:
60
            self.line2.setText("输入错误")
61

62

63
if __name__ == '__main__':
64
    QtCore.QCoreApplication.setAttribute(QtCore.Qt.AA_EnableHighDpiScaling)  # 解决页面显示不一致的问题
65

66
    app = QApplication(sys.argv)
67

68
    myWin = MyMainForm()
69
    apply_stylesheet(app, theme='dark_red.xml')
70
    myWin.show()
71

72
    sys.exit(app.exec_())

1
class student:
2
    def __init__(self):
3
        self.id = ''#学号
4
        self.name = ''#姓名
5
        self.myclass=''#班级
6
        self.lesson = []  # 存储课程成绩

1
class lesson:
2
    def __init__(self):
3
        self.name_lesson = []  # 课程名称
4
        self.grade_usual = 0  # 平时成绩
5
        self.grade_mid = 0  # 期中成绩
6
        self.grade_final = 0  # 期末成绩
7
        self.grade_gene = 0  # 加权总成绩
8
        self.rank = []  # 等地
9

10
    def get_rank(self):
11
        global rank
12
        self.grade_gene = self.grade_usual * rank.weight_rank['平时'] + self.grade_mid * rank.weight_rank[
13
            '期中'] + self.grade_final * rank.weight_rank['期末']
14
        if rank.excellent_low <= self.grade_gene <= rank.excellent_high:
15
            self.rank = rank.excellent
16
        elif rank.good_low <= self.grade_gene < rank.good_high:
17
            self.rank = rank.good
18
        elif rank.medium_low <= self.grade_gene < rank.medium_high:
19
            self.rank = rank.medium
20
        elif rank.mypass_low <= self.grade_gene < rank.mypass_high:
21
            self.rank = rank.mypass
22
        elif rank.myfail_low <= self.grade_gene < rank.myfail_high:
23
            self.rank = rank.myfail

1
import xlrd
2
from class_student import *
3
# PyQt5中使用的基本控件都在PyQt5.QtWidgets模块中
4
from PyQt5.QtWidgets import QApplication, QMainWindow, QTableWidgetItem
5
# 导入程序运行必须模块
6
import sys
7
# 导入designer工具生成的login模块
8
from qus21 import Ui_MainWindow
9
from PyQt5 import QtCore
10
from functools import partial
11
from qt_material import apply_stylesheet
12

13

14
class STUDENT_ALL:
15
    def __init__(self):
16
        self.num = 0
17
        self.grade_all = []  # 每门课的平均分数
18
        self.lesson_rank_rate = []
19
        self.student_list = []
20
        self.rate_excell = 0
21
        self.rate_good = 0
22
        self.rate_medium = 0
23
        self.rate_mypass = 0
24
        self.rate_myfail = 0
25

26
    def student_init(self, excel):
27
        self.num = excel.sheets[0].rows  # 获取学生数量
28
        for student_ind in range(self.num):
29
            # 对学生的姓名，学号，班级初始化
30
            student_temp = student()
31
            student_temp.name = excel.sheets[0].sheet.cell(student_ind, 0).value
32
            student_temp.myclass = excel.sheets[0].sheet.cell(student_ind, 1).value
33
            student_temp.id = excel.sheets[0].sheet.cell(student_ind, 2).value
34

35
            # 导入课程成绩、等地
36
            for lesson_ind in range(excel.sheet_num):
37
                lesson_temp = lesson()
38
                lesson_temp.name_lesson = excel.sheet_names[lesson_ind]
39
                lesson_temp.grade_usual = excel.sheets[lesson_ind].sheet.cell(student_ind, 3).value
40
                lesson_temp.grade_mid = excel.sheets[lesson_ind].sheet.cell(student_ind, 4).value
41
                lesson_temp.grade_final = excel.sheets[lesson_ind].sheet.cell(student_ind, 5).value
42

43
                lesson_temp.get_rank()
44
                student_temp.lesson.append(lesson_temp)
45

46
            self.student_list.append(student_temp)
47
        self.grade_all_init(excel)
48
        self.lesson_rank_init(excel)
49

50
    # 生成每个科目的平均成绩
51
    def grade_all_init(self, excel):
52
        for lesson_ind in range(excel.sheet_num):
53
            sum = 0
54
            for student_ind in range(len(self.student_list)):
55
                sum = sum + self.student_list[student_ind].lesson[lesson_ind].grade_gene
56
                pass
57
            sum = sum / len(self.student_list)
58
            self.grade_all.append(sum)
59

60
    def lesson_rank_init(self, excel):
61
        global rank
62
        for lesson_ind in range(excel.sheet_num):
63
            self.rate_excell = 0
64
            self.rate_good = 0
65
            self.rate_medium = 0
66
            self.rate_mypass = 0
67
            self.rate_myfail = 0
68
            for student_ind in range(len(self.student_list)):
69
                rank_temp = self.student_list[student_ind].lesson[lesson_ind].rank
70
                if rank_temp == rank.excellent:
71
                    self.rate_excell += 1
72
                elif rank_temp == rank.good:
73
                    self.rate_good += 1
74
                elif rank_temp == rank.medium:
75
                    self.rate_medium += 1
76
                elif rank_temp == rank.mypass:
77
                    self.rate_mypass += 1
78
                else:
79
                    self.rate_myfail += 1
80
            lesson_rank_temp = lesson_rank()
81
            lesson_rank_temp.rate_excell = self.rate_excell / len(self.student_list)
82
            lesson_rank_temp.rate_good = self.rate_good / len(self.student_list)
83
            lesson_rank_temp.rate_medium = self.rate_medium / len(self.student_list)
84
            lesson_rank_temp.rate_mypass = self.rate_mypass / len(self.student_list)
85
            lesson_rank_temp.rate_myfail = self.rate_myfail / len(self.student_list)
86
            self.lesson_rank_rate.append(lesson_rank_temp)
87

88

89
class lesson_rank:
90
    def __init__(self):
91
        self.rate_excell = 0
92
        self.rate_good = 0
93
        self.rate_medium = 0
94
        self.rate_mypass = 0
95
        self.rate_myfail = 0
96

97

98
class EXCEL:
99
    # excel数据表对象
100
    def __init__(self, wb):
101
        self.wb = wb  # excel文件对象
102
        self.sheet_num = wb.nsheets  # sheet的数量
103
        self.sheet_names = wb.sheet_names()  # sheet的名字
104
        self.sheets = []
105
        # 初始化
106
        self.get_sheets()
107

108
    def get_sheets(self):
109
        for i in range(self.sheet_num):
110
            sheet_temp = SHEET()
111
            sheet_temp.sheet = self.wb.sheet_by_index(i)
112
            sheet_temp.name = self.sheet_names[i]
113
            sheet_temp.rows = self.wb.sheet_by_index(i).nrows
114
            sheet_temp.cols = self.wb.sheet_by_index(i).ncols
115
            self.sheets.append(sheet_temp)
116

117

118
class SHEET:
119
    # 表单对象
120
    def __init__(self):
121
        self.sheet = []  # sheet的对象
122
        self.name = []  # sheet的名字，方便调用
123
        self.rows = 0  # sheet的列数
124
        self.cols = 0  # sheet对象
125

126

127
rank = rank_def()
128
excel = EXCEL(xlrd.open_workbook("成绩单.xlsx"))
129
student_all = STUDENT_ALL()
130
student_all.student_init(excel)
131

132

133
class MyMainForm(QMainWindow, Ui_MainWindow):
134
    def __init__(self, parent=None):
135
        super(MyMainForm, self).__init__(parent)
136
        self.cursot = None
137
        self.setupUi(self)
138
        self.student_dis = []
139
        self.pushButton.clicked.connect(partial(self.refresh))
140

141
    def refresh(self):
142
        global student_all
143
        global excel
144
        global rank
145
        self.student_dis.clear()
146
        lesson_index = self.lesson.currentIndex()  # 获取当前课程号
147
        class_index = self.classroom.currentIndex()  # 获取当前课程号
148
        rank_index = self.rank.currentIndex()  # 获取当前等地要求
149

150
        for i in range(len(student_all.student_list)):
151
            # 筛选判断依据
152
            if class_index == 0:
153
                class_wei = 1
154
            else:
155
                class_wei = (student_all.student_list[i].myclass == self.classroom.currentText())
156
            if rank_index == 0:
157
                rank_wei = 1
158
            else:
159
                rank_wei = (student_all.student_list[i].lesson[lesson_index].rank == self.rank.currentText())
160

161
            if (class_wei and rank_wei):
162
                self.student_dis.append(student_all.student_list[i])
163

164
        print(len(self.student_dis))
165
        self.display()
166

167
    def display(self):
168
        self.table.clear()
169
        self.table.setRowCount(len(self.student_dis))
170
        self.table.setColumnCount(8)
171
        self.table2.clear()
172
        self.table2.setRowCount(2)
173
        self.table2.setColumnCount(4)
174
        self.table2.setRowHeight(0, 50)
175
        # 显示成绩
176
        headers = ['姓名', '班级', '学号', '平时成绩', '期中成绩', '期末成绩', '加权成绩', '等地']
177
        self.table.setHorizontalHeaderLabels(headers);
178
        for student_ind in range(len(self.student_dis)):
179
            self.table.setItem(student_ind, 0, QTableWidgetItem(self.student_dis[student_ind].name))  # 姓名
180
            self.table.setItem(student_ind, 1, QTableWidgetItem(self.student_dis[student_ind].myclass))  # 班级
181
            self.table.setItem(student_ind, 2, QTableWidgetItem("%.0f" % self.student_dis[student_ind].id))  # 学号
182
            self.table.setItem(student_ind, 3, QTableWidgetItem("%.2f" %
183
                                                                self.student_dis[student_ind].lesson[
184
                                                                    self.lesson.currentIndex()].grade_usual))  # 平时成绩
185
            self.table.setItem(student_ind, 4, QTableWidgetItem("%.2f" %
186
                                                                self.student_dis[student_ind].lesson[
187
                                                                    self.lesson.currentIndex()].grade_mid))  # 期中成绩
188
            self.table.setItem(student_ind, 5, QTableWidgetItem("%.2f" %
189
                                                                self.student_dis[student_ind].lesson[
190
                                                                    self.lesson.currentIndex()].grade_final))  # 期末成绩
191
            self.table.setItem(student_ind, 6, QTableWidgetItem("%.2f" %
192
                                                                self.student_dis[student_ind].lesson[
193
                                                                    self.lesson.currentIndex()].grade_gene))  # 加权成绩
194
            self.table.setItem(student_ind, 7, QTableWidgetItem(
195
                self.student_dis[student_ind].lesson[self.lesson.currentIndex()].rank))  # 等地
196

197
        # 显示分数段占比
198
        row = 0
199
        self.table2.setItem(row, 0, QTableWidgetItem("优秀人数(率):"))
200
        self.table2.setItem(row, 1, QTableWidgetItem("良好人数(率):"))
201
        self.table2.setItem(row, 2, QTableWidgetItem("中等人数(率):"))
202
        self.table2.setItem(row, 3, QTableWidgetItem("及格人数(率):"))
203
        self.table2.setItem(row, 4, QTableWidgetItem("不及格人数(率):"))
204

205
        self.table2.setItem(row + 1, 0,
206
                            QTableWidgetItem("%d(%.2f%%)" % (student_all.rate_excell, student_all.lesson_rank_rate[
207
                                self.lesson.currentIndex()].rate_excell * 100)))
208
        self.table2.setItem(row + 1, 1,
209
                            QTableWidgetItem("%d(%.2f%%)" % (student_all.rate_good, student_all.lesson_rank_rate[
210
                                self.lesson.currentIndex()].rate_good * 100)))
211
        self.table2.setItem(row + 1, 2,
212
                            QTableWidgetItem("%d(%.2f%%)" % (student_all.rate_medium, student_all.lesson_rank_rate[
213
                                self.lesson.currentIndex()].rate_medium * 100)))
214
        self.table2.setItem(row + 1, 3,
215
                            QTableWidgetItem("%d(%.2f%%)" % (student_all.rate_mypass, student_all.lesson_rank_rate[
216
                                self.lesson.currentIndex()].rate_mypass * 100)))
217
        self.table2.setItem(row + 1, 4,
218
                            QTableWidgetItem("%d(%.2f%%)" % (student_all.rate_myfail, student_all.lesson_rank_rate[
219
                                self.lesson.currentIndex()].rate_myfail * 100)))
220

221
if __name__ == '__main__':
222
    QtCore.QCoreApplication.setAttribute(QtCore.Qt.AA_EnableHighDpiScaling)  # 解决页面显示不一致的问题
223

224
    app = QApplication(sys.argv)
225

226
    myWin = MyMainForm()
227
    apply_stylesheet(app, theme='dark_red.xml')
228
    myWin.show()
229

230
    sys.exit(app.exec_())

1
class student:
2
    def __init__(self):
3
        self.id = ''#学号
4
        self.name = ''#姓名
5
        self.myclass=''#班级
6
        self.lesson = []  # 存储课程成绩
7

8

9
class lesson:
10
    def __init__(self):
11
        self.name_lesson = []  # 课程名称
12
        self.grade_usual = 0  # 平时成绩
13
        self.grade_mid = 0  # 期中成绩
14
        self.grade_final = 0  # 期末成绩
15
        self.grade_gene = 0  # 加权总成绩
16
        self.rank = []  # 等地
17

18
    def get_rank(self):
19
        global rank
20
        self.grade_gene = self.grade_usual * rank.weight_rank['平时'] + self.grade_mid * rank.weight_rank[
21
            '期中'] + self.grade_final * rank.weight_rank['期末']
22
        if rank.excellent_low <= self.grade_gene <= rank.excellent_high:
23
            self.rank = rank.excellent
24
        elif rank.good_low <= self.grade_gene < rank.good_high:
25
            self.rank = rank.good
26
        elif rank.medium_low <= self.grade_gene < rank.medium_high:
27
            self.rank = rank.medium
28
        elif rank.mypass_low <= self.grade_gene < rank.mypass_high:
29
            self.rank = rank.mypass
30
        elif rank.myfail_low <= self.grade_gene < rank.myfail_high:
31
            self.rank = rank.myfail
32

33
class rank_def:
34
    # 用来计算加权分数和评定等地的常量
35
    def __init__(self):
36
        # 等地划分依据
37
        self.excellent_low = 90
38
        self.excellent_high = 100
39
        self.good_low = 80
40
        self.good_high = 90
41
        self.medium_low = 70
42
        self.medium_high = 80
43
        self.mypass_low = 60
44
        self.mypass_high = 70
45
        self.myfail_low = 0
46
        self.myfail_high = 60
47

48
        # 等地名称
49
        self.excellent = '优'
50
        self.good = '良'
51
        self.medium = '中'
52
        self.mypass = '及格'
53
        self.myfail = '不及格'
54

55
        # 成绩加权比例
56
        self.weight_rank = {'平时': 0.3, '期中': 0.3, '期末': 0.4}
57

58

59
rank = rank_def()

1
from myclass import *
2
import xlrd  # 引入库
3
import math
4
import openpyxl
5
# PyQt5中使用的基本控件都在PyQt5.QtWidgets模块中
6
from PyQt5.QtWidgets import QApplication, QMainWindow, QTableWidgetItem
7
# 导入程序运行必须模块
8
import sys
9
# 导入designer工具生成的login模块
10
from qus22 import Ui_MainWindow
11
from PyQt5 import QtCore
12
from functools import partial
13
from qt_material import apply_stylesheet
14

15
excel = EXCEL(xlrd.open_workbook("通话.xlsx"))
16

17
hd = []
18
fl = []
19
yh = []
20
fy = []
21
dic = dict()  # 创建一个空字典，用来通过电话快速访问用户名
22

23
hf_dis = []
24
hd_dis = []
25

26

27
def dict_init():
28
    for i in range(len(yh)):
29
        dic[yh[i].tele_user] = yh[i].name
30

31

32
# 设置用于展示的hf_dis，hd_dis
33
def inf_dis_init():
34
    global hd
35
    global fl
36
    global yh
37
    global fy
38
    for i in range(len(yh)):
39
        hf_dis_tem = hf_dis_class()
40
        hf_dis_tem.name = yh[i].name
41
        hf_dis_tem.tele = yh[i].tele_user
42
        hf_dis_tem.money_local = 0
43
        hf_dis_tem.money_far = 0
44
        for j in range(len(fy)):
45
            if fy[j].tele == hf_dis_tem.tele:
46
                if fy[j].call_type == '本地':
47
                    hf_dis_tem.money_local += fy[j].money
48
                else:
49
                    hf_dis_tem.money_far += fy[j].money
50
        hf_dis_tem.money_total = hf_dis_tem.money_local + hf_dis_tem.money_far
51
        hf_dis.append(hf_dis_tem)
52

53
    for i in range(len(hd)):
54
        hd_dis_tem = hd_dis_class()
55
        hd_dis_tem.tele_m = hd[i].tele_m
56
        hd_dis_tem.tele_s = hd[i].tele_s
57
        hd_dis_tem.time = hd[i].time
58
        hd_dis_tem.name = dic[hd[i].tele_m]
59
        hd_dis.append(hd_dis_tem)
60

61

62
# 初始化各个数据信息
63
def init_hfyf():
64
    global hd
65
    global fl
66
    global yh
67
    global fy
68
    global excel
69
    for i in range(excel.sheets[0].rows):
70
        hd_tem = hd_class()
71
        hd_tem.region_m = excel.sheets[0].sheet.cell(i, 0).value
72
        hd_tem.tele_m = excel.sheets[0].sheet.cell(i, 1).value
73
        hd_tem.region_s = excel.sheets[0].sheet.cell(i, 2).value
74
        hd_tem.tele_s = excel.sheets[0].sheet.cell(i, 3).value
75
        hd_tem.time = excel.sheets[0].sheet.cell(i, 4).value
76
        hd.append(hd_tem)
77

78
    for i in range(excel.sheets[1].rows):
79
        fl_tem = fl_class()
80
        fl_tem.region = excel.sheets[1].sheet.cell(i, 0).value
81
        fl_tem.rate = excel.sheets[1].sheet.cell(i, 1).value
82
        fl.append(fl_tem)
83

84
    for i in range(excel.sheets[2].rows):
85
        yh_tem = yh_class()
86
        yh_tem.tele_user = excel.sheets[2].sheet.cell(i, 0).value
87
        yh_tem.name = excel.sheets[2].sheet.cell(i, 1).value
88
        yh.append(yh_tem)
89

90
    # 对每一条费用进行初始化
91
    for i in range(len(hd)):
92
        fy_temp = fy_class()
93
        fy_temp.tele = hd[i].tele_m
94

95
        if hd[i].region_m == hd[i].region_s:  # 同区域通话
96
            fy_temp.call_type = '本地'
97
            time = math.ceil(hd[i].time / 60)
98
            if time <= 3:
99
                fy_temp.money = 0.5
100
            else:
101
                time2 = math.ceil((time - 3) / 3)  # 向上取整算是超过了几个3min
102
                fy_temp.money = 0.5 + time2 * 0.2
103
        else:
104
            fy_temp.call_type = '长途'
105
            time = math.ceil(hd[i].time / 60)
106
            # 计算本地通话金额
107
            if time <= 3:
108
                money1 = 0.5
109
            else:
110
                time2 = math.ceil((time - 3) / 3)  # 向上取整算是超过了几个3min
111
                money1 = 0.5 + time2 * 0.2
112
            # 计算长途通话金额
113
            fl_rate = 0
114
            for j in range(len(fl)):
115
                if fl[j].region == hd[i].region_s:
116
                    fl_rate = fl[j].rate
117
                    break
118
            money2 = time * fl_rate
119
            fy_temp.money = money1 + money2
120
        fy.append(fy_temp)
121

122
    for i in range(len(fy)):
123
        excel_tem = openpyxl.load_workbook("通话.xlsx")
124
        sheet_tem = excel_tem['费用文件']
125
        sheet_tem.cell(i + 1, 1).value = fy[i].tele
126
        sheet_tem.cell(i + 1, 2).value = fy[i].call_type
127
        sheet_tem.cell(i + 1, 3).value = fy[i].money
128
        excel_tem.save('通话.xlsx')
129
    dict_init()
130
    inf_dis_init()
131

132

133
class MyMainForm(QMainWindow, Ui_MainWindow):
134
    def __init__(self, parent=None):
135
        super(MyMainForm, self).__init__(parent)
136
        self.cursot = None
137
        self.setupUi(self)
138
        self.mode = 0  # 0为话费查询，1为话单查询
139
        self.button.clicked.connect(partial(self.refresh))
140

141
    def refresh(self):
142
        self.mode = self.comboBox.currentIndex()
143
        self.tableWidget.clear()
144

145
        # 话费查询
146
        if self.mode == 0:
147
            tele_tar = int(self.lineEdit.text())  # 目标电话
148
            # print(self.lineEdit.text())
149
            self.tableWidget.setColumnCount(5)  # 控制表格有几列
150
            self.tableWidget.setRowCount(1)  # 控制表格有几行
151
            headers = ['姓名', '电话', '本地话费', '长途话费', '总话费']
152
            self.tableWidget.setHorizontalHeaderLabels(headers)  # 设置表头
153
            for i in range(len(hf_dis)):
154
                if hf_dis[i].tele == tele_tar:
155
                    self.tableWidget.setItem(0, 0, QTableWidgetItem(hf_dis[i].name))
156
                    self.tableWidget.setItem(0, 1, QTableWidgetItem("%d" % hf_dis[i].tele))
157
                    self.tableWidget.setItem(0, 2, QTableWidgetItem("%.2f" % hf_dis[i].money_local))
158
                    self.tableWidget.setItem(0, 3, QTableWidgetItem("%.2f" % hf_dis[i].money_far))
159
                    self.tableWidget.setItem(0, 4, QTableWidgetItem("%.2f" % hf_dis[i].money_total))
160
                    break
161
        elif self.mode == 1:
162
            tele_tar = int(self.lineEdit.text())  # 目标电话
163
            lis_dis = []
164
            for i in range(len(hd_dis)):
165
                if hd_dis[i].tele_m == tele_tar:
166
                    lis_dis.append(hd_dis[i])
167
            self.tableWidget.setColumnCount(4)  # 控制表格有几列
168
            self.tableWidget.setRowCount(len(lis_dis))  # 控制表格有几行
169
            headers = ['姓名', '主叫电话', '被叫电话', '通话时长']
170
            self.tableWidget.setHorizontalHeaderLabels(headers)  # 设置表头
171
            for i in range(len(lis_dis)):
172
                self.tableWidget.setItem(i, 0, QTableWidgetItem(lis_dis[i].name))
173
                self.tableWidget.setItem(i, 1, QTableWidgetItem("%d" % lis_dis[i].tele_m))
174
                self.tableWidget.setItem(i, 2, QTableWidgetItem("%d" % lis_dis[i].tele_s))
175
                self.tableWidget.setItem(i, 3, QTableWidgetItem("%d秒" % lis_dis[i].time))
176
        else:
177
            self.tableWidget.setColumnCount(3)  # 控制表格有几列
178
            self.tableWidget.setRowCount(len(fy))  # 控制表格有几行
179
            headers = ['主叫电话', '通话类型', '话费']
180
            self.tableWidget.setHorizontalHeaderLabels(headers)  # 设置表头
181
            for i in range(len(fy)):
182
                self.tableWidget.setItem(i, 0, QTableWidgetItem("%d" % fy[i].tele))
183
                self.tableWidget.setItem(i, 1, QTableWidgetItem(fy[i].call_type))
184
                self.tableWidget.setItem(i, 2, QTableWidgetItem("%.2f" % fy[i].money))
185

186

187
if __name__ == '__main__':
188
    init_hfyf()
189
    QtCore.QCoreApplication.setAttribute(QtCore.Qt.AA_EnableHighDpiScaling)  # 解决页面显示不一致的问题
190

191
    app = QApplication(sys.argv)
192

193
    myWin = MyMainForm()
194
    apply_stylesheet(app, theme='dark_red.xml')
195
    myWin.show()
196

197
    sys.exit(app.exec_())