def __init__(self): QtGui.QDialog.__init__(self) self.ui = Ui_Stu_reg_dialog() self.ui.setupUi(self) self.ui.Update_detail_btn.clicked.connect(self.update) self.ui.Id_detail_lineEdit.setDisabled(True) stu_query = QSqlQuery() stu_query.exec_( "select Student_id from Student order by Student_id DESC") stu_query.next() self.id = stu_query.value(0) + 1 self.ui.Id_detail_lineEdit.setText(str(self.id))
def __init__(self): QtGui.QDialog.__init__(self) self.ui = Ui_Stu_reg_dialog() self.ui.setupUi(self) self.ui.Update_detail_btn.clicked.connect(self.update) self.ui.Id_detail_lineEdit.setDisabled(True) stu_query = QSqlQuery() stu_query.exec_( "select Student_id from Student order by Student_id DESC") stu_query.next() self.id = stu_query.value(0) + 1 self.ui.Id_detail_lineEdit.setText(str(self.id)) guradian_query = QSqlQuery() new_id = -1 guradian_query.exec_("select Guardian_name, Guardian_id from Guardian") self.g_dict = {} index = self.ui.State_detail_ComboBox.findText("South Dakota") self.ui.State_detail_ComboBox.setCurrentIndex(index) while guradian_query.next(): self.ui.Pguradian_detail_comboBox.addItem(guradian_query.value(0)) self.g_dict[guradian_query.value(0)] = guradian_query.value(1) if guradian_query.value(1) > new_id: new_id = guradian_query.value(1) self.ui.Sguardian_detail_comboBox.addItem(guradian_query.value(0)) self.highest = new_id + 1 self.ui.Add_first_btn.clicked.connect(partial(self.add_guradian, 0)) self.ui.Add_second_btn.clicked.connect(partial(self.add_guradian, 1)) self.ui.Update_detail_btn.clicked.connect(self.add_stu) self.ui.p_id = 0 self.ui.s_id = 0