def detail_show(self):
curIndex = self.ui.Student_view.currentIndex().row()
if curIndex == -1:
QtGui.QMessageBox.warning(self, 'Error', 'Please select a row')
return curIndex
self.detail = Stu_info_dialog()
self.detail.show()
self.detail.record = self.ui.student.record(curIndex)
address = QSqlQuery()
self.detail.Address_id = self.detail.record.field(1).value()
address.exec_("select * from Address where Address_id = %d" %
self.detail.Address_id)
address.next()
self.detail.record_A = address.record()
#check weather the data exists in database
#StuID
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()))
#StuName
if not isinstance(
self.detail.record.field(2).value(), QtCore.QPyNullVariant):
self.detail.ui.Name_detail_lineEdit.setText(
self.detail.record.field(2).value())
#StuGender
if not isinstance(
self.detail.record.field(3).value(), QtCore.QPyNullVariant):
self.detail.ui.Gender_detail_lineEdit.setText(
self.detail.record.field(3).value())
#StuEmail
if not isinstance(
self.detail.record.field(4).value(), QtCore.QPyNullVariant):
self.detail.ui.Email_detail_lineEdit.setText(
self.detail.record.field(4).value())
#need detail
#StuBirth
if not isinstance(
self.detail.record.field(6).value(), QtCore.QPyNullVariant):
self.detail.ui.Birth_detail_dateEdit.setDate(
self.detail.record.field(5).value())
#StuPhone
if not isinstance(
self.detail.record.field(7).value(), QtCore.QPyNullVariant):
self.detail.ui.Phone_detail_lineEdit.setText(
self.detail.record.field(6).value())
#StuPG
if not isinstance(
self.detail.record.field(8).value(), QtCore.QPyNullVariant):
self.detail.ui.Pguradian_detail_lineEdit.setText(
self.detail.record.field(8).value())
#StuSG
if not isinstance(
self.detail.record.field(9).value(), QtCore.QPyNullVariant):
self.detail.ui.Sguardian_detail_lineEdit.setText(
self.detail.record.field(9).value())
#StuEcon
if not isinstance(
self.detail.record.field(10).value(), QtCore.QPyNullVariant):
self.detail.ui.Econtact_detail_lineEdit.setText(
self.detail.record.field(10).value())
#StuEphone
if not isinstance(
self.detail.record.field(11).value(), QtCore.QPyNullVariant):
self.detail.ui.Ephone_detail_lineEdit.setText(
self.detail.record.field(11).value())
#StuTuition
if not isinstance(
self.detail.record.field(13).value(), QtCore.QPyNullVariant):
self.detail.ui.Tuition_detail_lineEdit.setText(
str(self.detail.record.field(13).value()))
if not isinstance(
self.detail.record.field(1).value(), QtCore.QPyNullVariant):
self.detail.ui.Address_detail_lineEdit.setText(
self.detail.record_A.field(1).value())
if not isinstance(
self.detail.record_A.field(2).value(), QtCore.QPyNullVariant):
self.detail.ui.City_detail_lineEdit.setText(
self.detail.record_A.field(2).value())
if not isinstance(
self.detail.record_A.field(3).value(), QtCore.QPyNullVariant):
self.detail.ui.State_detail_lineEdit.setText(
self.detail.record_A.field(3).value())
if not isinstance(
self.detail.record.field(12).value(), QtCore.QPyNullVariant):
self.detail.ui.Medical_detail_textEdit.setText(
self.detail.record.field(12).value())
self.detail.ui.Close_detail_btn.clicked.connect(self.detail.close)
self.detail.ui.Update_detail_btn.clicked.connect(self.stuinfo_update)
def detail_show(self):
curIndex = self.ui.Student_view.currentIndex().row()
if curIndex == -1:
QtGui.QMessageBox.warning(self, 'Error', 'Please select a row')
return curIndex
self.detail = Stu_info_dialog()
self.detail.show()
self.detail.record = self.ui.student.record(curIndex)
address = QSqlQuery()
self.detail.Address_id = self.detail.record.field(1).value()
address.exec_("select * from Address where Address_id = %d" %
self.detail.Address_id)
address.next()
self.detail.record_A = address.record()
self.detail.ui.Id_detail_lineEdit.setDisabled(True)
cphone_query = QSqlQuery()
cphone_query.exec_(
"select Student_cell_phone from Student where Student_id = %d" %
self.detail.record.field(0).value())
cphone_query.next()
#check weather the data exists in database
#populate to combobox
guradian_query = QSqlQuery()
guradian_query.exec_("select Guardian_name, Guardian_id from Guardian")
self.g_dict = {}
while guradian_query.next():
self.detail.ui.Pguradian_detail_comboBox.addItem(
guradian_query.value(0))
self.g_dict[guradian_query.value(0)] = guradian_query.value(1)
self.detail.ui.Sguardian_detail_comboBox.addItem(
guradian_query.value(0))
#Cell Phone
if not isinstance(cphone_query.value(0), QtCore.QPyNullVariant):
self.detail.ui.Cphone_detail_lineEdit.setText(
cphone_query.value(0))
#StuID
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()))
#StuName
if not isinstance(
self.detail.record.field(2).value(), QtCore.QPyNullVariant):
self.detail.ui.Name_detail_lineEdit.setText(
self.detail.record.field(2).value())
#StuGender
if not isinstance(
self.detail.record.field(3).value(), QtCore.QPyNullVariant):
self.detail.ui.Gender_comboBox.addItem("Male")
self.detail.ui.Gender_comboBox.addItem("Female")
if self.detail.record.field(3).value() == "Male":
self.detail.ui.Gender_comboBox.setCurrentIndex(0)
else:
self.detail.ui.Gender_comboBox.setCurrentIndex(1)
#StuEmail
if not isinstance(
self.detail.record.field(4).value(), QtCore.QPyNullVariant):
self.detail.ui.Email_detail_lineEdit.setText(
self.detail.record.field(4).value())
#need detail
#StuBirth
if not isinstance(
self.detail.record.field(6).value(), QtCore.QPyNullVariant):
self.detail.ui.Birth_detail_dateEdit.setDate(
self.detail.record.field(5).value())
#StuPhone
if not isinstance(
self.detail.record.field(7).value(), QtCore.QPyNullVariant):
self.detail.ui.Phone_detail_lineEdit.setText(
self.detail.record.field(6).value())
#StuPG
if not isinstance(
self.detail.record.field(8).value(), QtCore.QPyNullVariant):
StuPG = self.detail.record.field(8).value()
index = self.detail.ui.Pguradian_detail_comboBox.findText(StuPG)
self.detail.ui.Pguradian_detail_comboBox.setCurrentIndex(index)
#StuSG
if not isinstance(
self.detail.record.field(9).value(), QtCore.QPyNullVariant):
StuSG = self.detail.record.field(9).value()
index = self.detail.ui.Sguardian_detail_comboBox.findText(StuSG)
self.detail.ui.Sguardian_detail_comboBox.setCurrentIndex(index)
#StuEcon
if not isinstance(
self.detail.record.field(10).value(), QtCore.QPyNullVariant):
self.detail.ui.Econtact_detail_lineEdit.setText(
self.detail.record.field(10).value())
#StuEphone
if not isinstance(
self.detail.record.field(11).value(), QtCore.QPyNullVariant):
self.detail.ui.Ephone_detail_lineEdit.setText(
self.detail.record.field(11).value())
#medical
if not isinstance(
self.detail.record.field(12).value(), QtCore.QPyNullVariant):
self.detail.ui.Medical_detail_textEdit.setText(
self.detail.record.field(12).value())
#address
if not isinstance(
self.detail.record.field(1).value(), QtCore.QPyNullVariant):
self.detail.ui.Address_detail_lineEdit.setText(
self.detail.record_A.field(1).value())
if not isinstance(
self.detail.record_A.field(2).value(), QtCore.QPyNullVariant):
self.detail.ui.City_detail_lineEdit.setText(
self.detail.record_A.field(2).value())
if not isinstance(
self.detail.record_A.field(3).value(), QtCore.QPyNullVariant):
index = self.detail.ui.State_detail_ComboBox.findText(
self.detail.record_A.field(3).value())
self.detail.ui.State_detail_ComboBox.setCurrentIndex(index)
if not isinstance(
self.detail.record_A.field(4).value(), QtCore.QPyNullVariant):
self.detail.ui.Zipcode_detail_lineEdit.setText(
str(self.detail.record_A.field(4).value()))
self.detail.ui.Close_detail_btn.clicked.connect(self.detail.close)
self.detail.ui.Update_detail_btn.clicked.connect(self.stuinfo_update)
