-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathMainWindow.py
124 lines (106 loc) · 4.43 KB
/
MainWindow.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
from PyQt5.QtWidgets import *
from PyQt5.QtCore import *
from PyQt5.QtSql import *
import sip
from ui.Main import Ui_MainWindow
from meetingWidget import MeetingWidget
from investWidget import InvestWidget
from instructWdiget import InstructWidget
from inspectWidget import InspectWidget
from changePassword import change_password
import os
class Main(QMainWindow,Ui_MainWindow):
def __init__(self):
super(Main, self).__init__()
self.setupUi(self)
self.db = QSqlDatabase.addDatabase("QSQLITE")
self.db.setDatabaseName('./cmdb.sqlite')
self.db.open()
self.init()
self.actionmeeting.triggered.connect(self.meetingshow)
self.actioninvest.triggered.connect(self.investshow)
self.actioninstruct.triggered.connect(self.instructshow)
self.actioninspect.triggered.connect(self.inspectshow)
self.actioninput.triggered.connect(self.inputexcel)
self.actionoutput.triggered.connect(self.outputexcel)
self.actionprint.triggered.connect(self.print)
self.actionperpage.triggered.connect(self.page_setting)
self.actionhelp.triggered.connect(self.help)
self.actionAbout_Us.triggered.connect(self.about)
self.actionchangepassword.triggered.connect(self.changepasswordshow)
def init(self):
self.actionperpage.setEnabled(True)
self.actionprint.setEnabled(True)
self.actionmeeting.setEnabled(True)
self.actioninvest.setEnabled(True)
self.actioninstruct.setEnabled(True)
self.actioninspect.setEnabled(True)
self.actioninput.setEnabled(True)
self.actionoutput.setEnabled(True)
#self.actionData_Analytical.setEnabled(True)
self.actionhelp.setEnabled(True)
self.meetingshow()
self.actionmeeting.setChecked(True)
def help(self):
fd = os.startfile("help.pdf")
def about(self):
reply = QMessageBox.about(self,"About","Audit Information Statistics Platform V1.0\nDevelop by R.Nadeera Sampath\n")
def meetingshow(self):
self.widget = MeetingWidget()
self.setCentralWidget(self.widget)
if self.actioninvest.isChecked():
self.actioninvest.setChecked(False)
if self.actioninstruct.isChecked():
self.actioninstruct.setChecked(False)
if self.actioninspect.isChecked():
self.actioninspect.setChecked(False)
def investshow(self):
sip.delete(self.widget)
self.widget = InvestWidget()
self.setCentralWidget(self.widget)
if self.actionmeeting.isChecked():
self.actionmeeting.setChecked(False)
if self.actioninstruct.isChecked():
self.actioninstruct.setChecked(False)
if self.actioninspect.isChecked():
self.actioninspect.setChecked(False)
def instructshow(self):
sip.delete(self.widget)
self.widget = InstructWidget()
self.setCentralWidget(self.widget)
if self.actionmeeting.isChecked():
self.actionmeeting.setChecked(False)
if self.actioninvest.isChecked():
self.actioninvest.setChecked(False)
if self.actioninspect.isChecked():
self.actioninspect.setChecked(False)
def inspectshow(self):
sip.delete(self.widget)
self.widget = InspectWidget()
self.setCentralWidget(self.widget)
if self.actionmeeting.isChecked():
self.actionmeeting.setChecked(False)
if self.actioninvest.isChecked():
self.actioninvest.setChecked(False)
if self.actioninstruct.isChecked():
self.actioninstruct.setChecked(False)
def changepasswordshow(self):
sip.delete(self.widget)
self.widget = change_password()
self.setCentralWidget(self.widget)
if self.actionmeeting.isChecked():
self.widget.retshow = self.meetingshow
if self.actioninvest.isChecked():
self.widget.retshow = self.investshow
if self.actioninstruct.isChecked():
self.widget.retshow = self.structshow
if self.actioninspect.isChecked():
self.widget.retshow = self.inspectshow
def inputexcel(self):
self.widget.storageView.imp_excel_data()
def outputexcel(self):
self.widget.storageView.xpt_excel_data()
def print(self):
self.widget.storageView.prt_row_data()
def page_setting(self):
self.widget.storageView.prt_setup_data()