forked from Russell-A/database-course-design
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathadd_flight.py
251 lines (236 loc) · 17.8 KB
/
add_flight.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
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
# -*- coding: utf-8 -*-
# Form implementation generated from reading ui file add_flight.ui
#
# Created by: PyQt5 UI code generator 5.9.2
#
# WARNING! All changes made in this file will be lost!
from PyQt5 import QtCore, QtGui, QtWidgets, QtSql
import PyQt5.QtSql
from PyQt5.QtWidgets import QMessageBox
class Ui_Dialog(object):
def setupUi(self, Dialog):
Dialog.setObjectName("Dialog")
Dialog.setWindowModality(QtCore.Qt.NonModal)
Dialog.resize(900, 600)
Dialog.setSizeGripEnabled(False)
self.verticalLayout_2 = QtWidgets.QVBoxLayout(Dialog)
self.verticalLayout_2.setObjectName("verticalLayout_2")
self.verticalLayout = QtWidgets.QVBoxLayout()
self.verticalLayout.setObjectName("verticalLayout")
spacerItem = QtWidgets.QSpacerItem(40, 20, QtWidgets.QSizePolicy.Expanding, QtWidgets.QSizePolicy.Minimum)
self.verticalLayout.addItem(spacerItem)
self.horizontalLayout = QtWidgets.QHBoxLayout()
self.horizontalLayout.setObjectName("horizontalLayout")
self.label_flight_number = QtWidgets.QLabel(Dialog)
self.label_flight_number.setObjectName("label_flight_number")
self.horizontalLayout.addWidget(self.label_flight_number)
self.lineEdit_flight_number = QtWidgets.QLineEdit(Dialog)
self.lineEdit_flight_number.setObjectName("lineEdit_flight_number")
self.horizontalLayout.addWidget(self.lineEdit_flight_number)
self.verticalLayout.addLayout(self.horizontalLayout)
spacerItem1 = QtWidgets.QSpacerItem(40, 20, QtWidgets.QSizePolicy.Expanding, QtWidgets.QSizePolicy.Minimum)
self.verticalLayout.addItem(spacerItem1)
self.horizontalLayout_2 = QtWidgets.QHBoxLayout()
self.horizontalLayout_2.setObjectName("horizontalLayout_2")
self.label_departure_time = QtWidgets.QLabel(Dialog)
self.label_departure_time.setObjectName("label_departure_time")
self.horizontalLayout_2.addWidget(self.label_departure_time)
self.dateTimeEdit_departure_time = QtWidgets.QDateTimeEdit(Dialog)
self.dateTimeEdit_departure_time.setObjectName("dateTimeEdit_departure_time")
self.horizontalLayout_2.addWidget(self.dateTimeEdit_departure_time)
self.label_arrival_time = QtWidgets.QLabel(Dialog)
self.label_arrival_time.setObjectName("label_arrival_time")
self.horizontalLayout_2.addWidget(self.label_arrival_time)
self.dateTimeEdit_arrival_time = QtWidgets.QDateTimeEdit(Dialog)
self.dateTimeEdit_arrival_time.setObjectName("dateTimeEdit_arrival_time")
self.horizontalLayout_2.addWidget(self.dateTimeEdit_arrival_time)
self.verticalLayout.addLayout(self.horizontalLayout_2)
spacerItem2 = QtWidgets.QSpacerItem(40, 20, QtWidgets.QSizePolicy.Expanding, QtWidgets.QSizePolicy.Minimum)
self.verticalLayout.addItem(spacerItem2)
self.checkBox_transit = QtWidgets.QCheckBox(Dialog)
self.checkBox_transit.setObjectName("checkBox_transit")
self.verticalLayout.addWidget(self.checkBox_transit)
self.horizontalLayout_3 = QtWidgets.QHBoxLayout()
self.horizontalLayout_3.setObjectName("horizontalLayout_3")
self.label_arrival_transit_time = QtWidgets.QLabel(Dialog)
self.label_arrival_transit_time.setLayoutDirection(QtCore.Qt.LeftToRight)
self.label_arrival_transit_time.setObjectName("label_arrival_transit_time")
self.horizontalLayout_3.addWidget(self.label_arrival_transit_time)
self.dateTimeEdit_arrival_transit_time = QtWidgets.QDateTimeEdit(Dialog)
self.dateTimeEdit_arrival_transit_time.setObjectName("dateTimeEdit_arrival_transit_time")
self.horizontalLayout_3.addWidget(self.dateTimeEdit_arrival_transit_time)
self.label_departure_transit_time = QtWidgets.QLabel(Dialog)
self.label_departure_transit_time.setObjectName("label_departure_transit_time")
self.horizontalLayout_3.addWidget(self.label_departure_transit_time)
self.dateTimeEdit_departure_transit_time = QtWidgets.QDateTimeEdit(Dialog)
self.dateTimeEdit_departure_transit_time.setObjectName("dateTimeEdit_departure_transit_time")
self.horizontalLayout_3.addWidget(self.dateTimeEdit_departure_transit_time)
self.verticalLayout.addLayout(self.horizontalLayout_3)
spacerItem3 = QtWidgets.QSpacerItem(40, 20, QtWidgets.QSizePolicy.Expanding, QtWidgets.QSizePolicy.Minimum)
self.verticalLayout.addItem(spacerItem3)
self.label_departure_transit = QtWidgets.QLabel(Dialog)
self.label_departure_transit.setObjectName("label_departure_transit")
self.verticalLayout.addWidget(self.label_departure_transit)
self.horizontalLayout_4 = QtWidgets.QHBoxLayout()
self.horizontalLayout_4.setObjectName("horizontalLayout_4")
self.label_price_economy_departure_transit = QtWidgets.QLabel(Dialog)
self.label_price_economy_departure_transit.setObjectName("label_price_economy_departure_transit")
self.horizontalLayout_4.addWidget(self.label_price_economy_departure_transit)
self.lineEdit_price_economy_departure_transit = QtWidgets.QLineEdit(Dialog)
self.lineEdit_price_economy_departure_transit.setObjectName("lineEdit_price_economy_departure_transit")
self.horizontalLayout_4.addWidget(self.lineEdit_price_economy_departure_transit)
self.label_price_business_departure_transit = QtWidgets.QLabel(Dialog)
self.label_price_business_departure_transit.setObjectName("label_price_business_departure_transit")
self.horizontalLayout_4.addWidget(self.label_price_business_departure_transit)
self.lineEdit_price_business_departure_transit = QtWidgets.QLineEdit(Dialog)
self.lineEdit_price_business_departure_transit.setObjectName("lineEdit_price_business_departure_transit")
self.horizontalLayout_4.addWidget(self.lineEdit_price_business_departure_transit)
self.label_price_first_departure_transit = QtWidgets.QLabel(Dialog)
self.label_price_first_departure_transit.setObjectName("label_price_first_departure_transit")
self.horizontalLayout_4.addWidget(self.label_price_first_departure_transit)
self.lineEdit_price_first_departure_transit = QtWidgets.QLineEdit(Dialog)
self.lineEdit_price_first_departure_transit.setObjectName("lineEdit_price_first_departure_transit")
self.horizontalLayout_4.addWidget(self.lineEdit_price_first_departure_transit)
self.verticalLayout.addLayout(self.horizontalLayout_4)
spacerItem4 = QtWidgets.QSpacerItem(40, 20, QtWidgets.QSizePolicy.Expanding, QtWidgets.QSizePolicy.Minimum)
self.verticalLayout.addItem(spacerItem4)
self.label_transit_arrival = QtWidgets.QLabel(Dialog)
self.label_transit_arrival.setObjectName("label_transit_arrival")
self.verticalLayout.addWidget(self.label_transit_arrival)
self.horizontalLayout_5 = QtWidgets.QHBoxLayout()
self.horizontalLayout_5.setObjectName("horizontalLayout_5")
self.label_price_economy_transit_arrival = QtWidgets.QLabel(Dialog)
self.label_price_economy_transit_arrival.setObjectName("label_price_economy_transit_arrival")
self.horizontalLayout_5.addWidget(self.label_price_economy_transit_arrival)
self.lineEdit_price_economy_transit_arrival = QtWidgets.QLineEdit(Dialog)
self.lineEdit_price_economy_transit_arrival.setObjectName("lineEdit_price_economy_transit_arrival")
self.horizontalLayout_5.addWidget(self.lineEdit_price_economy_transit_arrival)
self.label_price_business_transit_arrival = QtWidgets.QLabel(Dialog)
self.label_price_business_transit_arrival.setObjectName("label_price_business_transit_arrival")
self.horizontalLayout_5.addWidget(self.label_price_business_transit_arrival)
self.lineEdit_price_business_transit_arrival = QtWidgets.QLineEdit(Dialog)
self.lineEdit_price_business_transit_arrival.setObjectName("lineEdit_price_business_transit_arrival")
self.horizontalLayout_5.addWidget(self.lineEdit_price_business_transit_arrival)
self.label_price_first_transit_arrival = QtWidgets.QLabel(Dialog)
self.label_price_first_transit_arrival.setObjectName("label_price_first_transit_arrival")
self.horizontalLayout_5.addWidget(self.label_price_first_transit_arrival)
self.lineEdit_price_first_transit_arrival = QtWidgets.QLineEdit(Dialog)
self.lineEdit_price_first_transit_arrival.setObjectName("lineEdit_price_first_transit_arrival")
self.horizontalLayout_5.addWidget(self.lineEdit_price_first_transit_arrival)
self.verticalLayout.addLayout(self.horizontalLayout_5)
spacerItem5 = QtWidgets.QSpacerItem(40, 20, QtWidgets.QSizePolicy.Expanding, QtWidgets.QSizePolicy.Minimum)
self.verticalLayout.addItem(spacerItem5)
self.label_departure_arrival = QtWidgets.QLabel(Dialog)
self.label_departure_arrival.setObjectName("label_departure_arrival")
self.verticalLayout.addWidget(self.label_departure_arrival)
self.horizontalLayout_6 = QtWidgets.QHBoxLayout()
self.horizontalLayout_6.setObjectName("horizontalLayout_6")
self.label_price_economy_departure_arrival = QtWidgets.QLabel(Dialog)
self.label_price_economy_departure_arrival.setObjectName("label_price_economy_departure_arrival")
self.horizontalLayout_6.addWidget(self.label_price_economy_departure_arrival)
self.lineEdit_price_economy_departure_arrival = QtWidgets.QLineEdit(Dialog)
self.lineEdit_price_economy_departure_arrival.setObjectName("lineEdit_price_economy_departure_arrival")
self.horizontalLayout_6.addWidget(self.lineEdit_price_economy_departure_arrival)
self.label_price_business_departure_arrival = QtWidgets.QLabel(Dialog)
self.label_price_business_departure_arrival.setObjectName("label_price_business_departure_arrival")
self.horizontalLayout_6.addWidget(self.label_price_business_departure_arrival)
self.lineEdit_price_business_departure_arrival = QtWidgets.QLineEdit(Dialog)
self.lineEdit_price_business_departure_arrival.setObjectName("lineEdit_price_business_departure_arrival")
self.horizontalLayout_6.addWidget(self.lineEdit_price_business_departure_arrival)
self.label_price_first_departure_arrival = QtWidgets.QLabel(Dialog)
self.label_price_first_departure_arrival.setObjectName("label_price_first_departure_arrival")
self.horizontalLayout_6.addWidget(self.label_price_first_departure_arrival)
self.lineEdit_price_first_departure_arrival = QtWidgets.QLineEdit(Dialog)
self.lineEdit_price_first_departure_arrival.setObjectName("lineEdit_price_first_departure_arrival")
self.horizontalLayout_6.addWidget(self.lineEdit_price_first_departure_arrival)
self.verticalLayout.addLayout(self.horizontalLayout_6)
spacerItem6 = QtWidgets.QSpacerItem(40, 20, QtWidgets.QSizePolicy.Expanding, QtWidgets.QSizePolicy.Minimum)
self.verticalLayout.addItem(spacerItem6)
self.pushButton_insert = QtWidgets.QPushButton(Dialog)
self.pushButton_insert.setObjectName("pushButton_insert")
self.verticalLayout.addWidget(self.pushButton_insert)
self.verticalLayout_2.addLayout(self.verticalLayout)
self.retranslateUi(Dialog)
self.pushButton_insert.clicked.connect(self.Insert_Flight)
QtCore.QMetaObject.connectSlotsByName(Dialog)
def retranslateUi(self, Dialog):
_translate = QtCore.QCoreApplication.translate
Dialog.setWindowTitle(_translate("Dialog", "添加航程"))
self.label_flight_number.setText(_translate("Dialog", "航班编号："))
self.label_departure_time.setText(_translate("Dialog", "计划出发时间："))
self.label_arrival_time.setText(_translate("Dialog", "计划到达时间："))
self.checkBox_transit.setText(_translate("Dialog", "是否经停？"))
self.label_arrival_transit_time.setText(_translate("Dialog", "计划到达经停机场时间："))
self.label_departure_transit_time.setText(_translate("Dialog", "计划从经停机场出发时间："))
self.label_departure_transit.setText(_translate("Dialog", "出发-经停："))
self.label_price_economy_departure_transit.setText(_translate("Dialog", "经济舱票价:"))
self.label_price_business_departure_transit.setText(_translate("Dialog", "商务舱票价:"))
self.label_price_first_departure_transit.setText(_translate("Dialog", "头等舱票价:"))
self.label_transit_arrival.setText(_translate("Dialog", "经停-到达："))
self.label_price_economy_transit_arrival.setText(_translate("Dialog", "经济舱票价:"))
self.label_price_business_transit_arrival.setText(_translate("Dialog", "商务舱票价:"))
self.label_price_first_transit_arrival.setText(_translate("Dialog", "头等舱票价:"))
self.label_departure_arrival.setText(_translate("Dialog", "出发-到达："))
self.label_price_economy_departure_arrival.setText(_translate("Dialog", "经济舱票价:"))
self.label_price_business_departure_arrival.setText(_translate("Dialog", "商务舱票价:"))
self.label_price_first_departure_arrival.setText(_translate("Dialog", "头等舱票价:"))
self.pushButton_insert.setText(_translate("Dialog", "添加"))
def Insert_Flight(self):
query = QtSql.QSqlQuery()
query.prepare("INSERT INTO 飞行计划安排(航班编号, 计划出发时间, 计划到达经停机场时间, 计划从经停机场出发时间,计划到达时间, "
"[票价（开始-到达，经济舱）], [票价（开始-经停，经济舱）], [票价（经停-到达，经济舱）],"
"[票价（开始-到达，商务舱）], [票价（开始-经停，商务舱）], [票价（经停-到达，商务舱）], "
"[票价（开始-到达，头等舱）], [票价（开始-经停，头等舱）], [票价（经停-到达，头等舱）])"
"VALUES(:flight_number, :plan_departure, :plan_transit_arrival, :plan_transit_departure , :plan_arrival ,"
" :price_departure_arrival_economy , :price_departure_transit_economy , :price_transit_arrival_economy , "
" :price_departure_arrival_business , :price_departure_transit_business , :price_transit_arrival_business , "
" :price_departure_arrival_first , :price_departure_transit_first , :price_transit_arrival_first )" )
query.bindValue(":flight_number", self.lineEdit_flight_number.text())
query.bindValue(":plan_departure", self.dateTimeEdit_departure_time.dateTime().toString("yyyy-MM-dd HH:mm"))
query.bindValue(":plan_arrival", self.dateTimeEdit_arrival_time.dateTime().toString("yyyy-MM-dd HH:mm"))
if self.checkBox_transit.isChecked():
query.bindValue(":plan_transit_arrival", self.dateTimeEdit_arrival_transit_time.dateTime().toString("yyyy-MM-dd HH:mm") )
query.bindValue(":plan_transit_departure", self.dateTimeEdit_departure_transit_time.dateTime().toString("yyyy-MM-dd HH:mm") )
else:
query.bindValue(":plan_transit_arrival", QtCore.QVariant())
query.bindValue(":plan_transit_departure", QtCore.QVariant())
if self.lineEdit_price_economy_departure_arrival.text() == '':
query.bindValue(":price_departure_arrival_economy", QtCore.QVariant())
else:
query.bindValue(":price_departure_arrival_economy", self.lineEdit_price_economy_departure_arrival.text())
if self.lineEdit_price_business_departure_arrival.text() == '':
query.bindValue(":price_departure_arrival_business", QtCore.QVariant())
else:
query.bindValue(":price_departure_arrival_business", self.lineEdit_price_business_departure_arrival.text())
if self.lineEdit_price_first_departure_arrival.text() == '':
query.bindValue(":price_departure_arrival_first", QtCore.QVariant())
else:
query.bindValue(":price_departure_arrival_first", self.lineEdit_price_first_departure_arrival.text())
if self.lineEdit_price_economy_departure_transit.text() == '':
query.bindValue(":price_departure_transit_economy", QtCore.QVariant())
else:
query.bindValue(":price_departure_transit_economy", self.lineEdit_price_economy_departure_transit.text())
if self.lineEdit_price_business_departure_transit.text() == '':
query.bindValue(":price_departure_transit_business", QtCore.QVariant())
else:
query.bindValue(":price_departure_transit_business", self.lineEdit_price_business_departure_transit.text())
if self.lineEdit_price_first_departure_transit.text() == '':
query.bindValue(":price_departure_transit_first", QtCore.QVariant())
else:
query.bindValue(":price_departure_transit_first", self.lineEdit_price_first_departure_transit.text())
if self.lineEdit_price_economy_transit_arrival.text() == '':
query.bindValue(":price_transit_arrival_economy", QtCore.QVariant())
else:
query.bindValue(":price_transit_arrival_economy", self.lineEdit_price_economy_transit_arrival.text())
if self.lineEdit_price_business_transit_arrival.text() == '':
query.bindValue(":price_transit_arrival_business", QtCore.QVariant())
else:
query.bindValue(":price_transit_arrival_business", self.lineEdit_price_business_transit_arrival.text())
if self.lineEdit_price_first_transit_arrival.text() == '':
query.bindValue(":price_transit_arrival_first", QtCore.QVariant())
else:
query.bindValue(":price_transit_arrival_first", self.lineEdit_price_first_transit_arrival.text())
if query.exec_():
print(QMessageBox.information(self, "提示", "添加数据成功!", QMessageBox.Ok))
else:
print(QMessageBox.warning(self, "提示", "添加数据失败!", QMessageBox.Ok))