def detail_show(self):
curIndex = self.ui.Class_view.currentIndex().row()
if curIndex == -1:
QtGui.QMessageBox.warning(self, 'Error', 'Please select a row')
return curIndex
self.detail = Class_info_dialog()
self.detail.show()
self.detail.record = self.ui.Class.record(curIndex)
# location check
self.location_query = QSqlQuery()
self.location_query.exec_("SELECT DISTINCT Class_location FROM Class")
while self.location_query.next():
record = self.location_query.record()
self.location = str(record.value(0))
self.detail.ui.locationComboBox.addItem(self.location)
#check weather the data exists in database
self.detail.ui.Cost_detail_doubleSpinBox.setMinimum(0.0)
self.detail.ui.Capacity_detail_spinBox.setMinimum(0)
self.detail.ui.Age_start_detail_spinBox.setMinimum(0)
self.detail.ui.Age_end_detail_spinBox.setMinimum(0)
#ClassID
if not isinstance(
self.detail.record.field(0).value(), QtCore.QPyNullVariant):
self.detail.ui.Id_detail_lineEdit.setText(
str(self.detail.record.field(0).value()))
#ClassName
if not isinstance(
self.detail.record.field(1).value(), QtCore.QPyNullVariant):
self.detail.ui.Name_detail_lineEdit.setText(
self.detail.record.field(1).value())
#ClassCost
if not isinstance(
self.detail.record.field(2).value(), QtCore.QPyNullVariant):
self.detail.ui.Cost_detail_doubleSpinBox.setValue(
self.detail.record.field(2).value())
#ClassTimeStart
if not isinstance(
self.detail.record.field(3).value(), QtCore.QPyNullVariant):
self.detail.ui.Time_start_detail_timeEdit.setTime(
self.detail.record.field(3).value())
#need detail
#ClassTimeEnd
if not isinstance(
self.detail.record.field(4).value(), QtCore.QPyNullVariant):
self.detail.ui.Time_end_detail_timeEdit.setTime(
self.detail.record.field(4).value())
#ClassDay
if not isinstance(
self.detail.record.field(5).value(), QtCore.QPyNullVariant):
index = self.detail.ui.Day_detail_comboBox.findText(
self.detail.record.field(5).value())
self.detail.ui.Day_detail_comboBox.setCurrentIndex(index)
#ClassDay
if not isinstance(
self.detail.record.field(6).value(), QtCore.QPyNullVariant):
index = self.detail.ui.locationComboBox.findText(
self.detail.record.field(6).value())
self.detail.ui.locationComboBox.setCurrentIndex(index)
#ClassCapacity
if not isinstance(
self.detail.record.field(7).value(), QtCore.QPyNullVariant):
self.detail.ui.Capacity_detail_spinBox.setValue(
self.detail.record.field(7).value())
#ClassClothing
if not isinstance(
self.detail.record.field(8).value(), QtCore.QPyNullVariant):
self.detail.ui.Clothing_detail_lineEdit.setText(
self.detail.record.field(8).value())
#ClassDateStart
if not isinstance(
self.detail.record.field(10).value(), QtCore.QPyNullVariant):
self.detail.ui.Date_start_detail_dateEdit.setDate(
self.detail.record.field(10).value())
#ClassDateEnd
if not isinstance(
self.detail.record.field(11).value(), QtCore.QPyNullVariant):
self.detail.ui.Date_end_detail_dateEdit.setDate(
self.detail.record.field(11).value())
#ClassAgeStart
if not isinstance(
self.detail.record.field(12).value(), QtCore.QPyNullVariant):
self.detail.ui.Age_start_detail_spinBox.setValue(
self.detail.record.field(12).value())
#ClassAgeEnd
if not isinstance(
self.detail.record.field(13).value(), QtCore.QPyNullVariant):
self.detail.ui.Age_end_detail_spinBox.setValue(
self.detail.record.field(13).value())
#ClassDescription
if not isinstance(
self.detail.record.field(9).value(), QtCore.QPyNullVariant):
self.detail.ui.Description_detail_textEdit.setText(
self.detail.record.field(9).value())
self.detail.ui.Id_detail_lineEdit.setDisabled(True)
self.detail.ui.Close_detail_btn.clicked.connect(self.detail.close)
self.detail.ui.Update_detail_btn.clicked.connect(self.Classinfo_update)
def detail_show(self):
curIndex = self.ui.Class_view.currentIndex().row()
if curIndex == -1:
QtGui.QMessageBox.warning(self, 'Error', 'Please select a row')
return curIndex
self.detail = Class_info_dialog()
self.detail.show()
self.detail.record = self.ui.Class.record(curIndex)
#check weather the data exists in database
#ClassID
if not isinstance(
self.detail.record.field(0).value(), QtCore.QPyNullVariant):
self.detail.ui.Id_detail_lineEdit.setText(
str(self.detail.record.field(0).value()))
#ClassName
if not isinstance(
self.detail.record.field(1).value(), QtCore.QPyNullVariant):
self.detail.ui.Name_detail_lineEdit.setText(
self.detail.record.field(1).value())
#ClassCost
if not isinstance(
self.detail.record.field(2).value(), QtCore.QPyNullVariant):
self.detail.ui.Cost_detail_lineEdit.setText(
str(self.detail.record.field(2).value()))
#ClassTimeStart
if not isinstance(
self.detail.record.field(3).value(), QtCore.QPyNullVariant):
self.detail.ui.Time_start_detail_timeEdit.setTime(
self.detail.record.field(3).value())
#need detail
#ClassTimeEnd
if not isinstance(
self.detail.record.field(4).value(), QtCore.QPyNullVariant):
self.detail.ui.Time_end_detail_timeEdit.setTime(
self.detail.record.field(4).value())
#ClassDay
if not isinstance(
self.detail.record.field(5).value(), QtCore.QPyNullVariant):
self.detail.ui.Day_detail_lineEdit.setText(
self.detail.record.field(5).value())
#ClassLocation
if not isinstance(
self.detail.record.field(6).value(), QtCore.QPyNullVariant):
self.detail.ui.Location_detail_lineEdit.setText(
self.detail.record.field(6).value())
#ClassCapacity
if not isinstance(
self.detail.record.field(7).value(), QtCore.QPyNullVariant):
self.detail.ui.Capacity_detail_lineEdit.setText(
str(self.detail.record.field(7).value()))
#ClassClothing
if not isinstance(
self.detail.record.field(8).value(), QtCore.QPyNullVariant):
self.detail.ui.Clothing_detail_lineEdit.setText(
self.detail.record.field(8).value())
#ClassDateStart
if not isinstance(
self.detail.record.field(10).value(), QtCore.QPyNullVariant):
self.detail.ui.Date_start_detail_dateEdit.setDate(
self.detail.record.field(10).value())
#ClassDateEnd
if not isinstance(
self.detail.record.field(11).value(), QtCore.QPyNullVariant):
self.detail.ui.Date_end_detail_dateEdit.setDate(
self.detail.record.field(11).value())
#ClassAgeStart
if not isinstance(
self.detail.record.field(12).value(), QtCore.QPyNullVariant):
self.detail.ui.Age_start_detail_lineEdit.setText(
str(self.detail.record.field(12).value()))
#ClassAgeEnd
if not isinstance(
self.detail.record.field(13).value(), QtCore.QPyNullVariant):
self.detail.ui.Age_end_detail_lineEdit.setText(
str(self.detail.record.field(13).value()))
#ClassDescription
if not isinstance(
self.detail.record.field(9).value(), QtCore.QPyNullVariant):
self.detail.ui.Description_detail_textEdit.setText(
self.detail.record.field(9).value())
self.detail.ui.Close_detail_btn.clicked.connect(self.detail.close)
self.detail.ui.Update_detail_btn.clicked.connect(self.Classinfo_update)
