def __init__(self, Class_name=None):
QtGui.QDialog.__init__(self)
self.ui = Ui_Addstu_detail()
self.ui.setupUi(self)
Stu_query = QSqlQuery()
self.class_name = Class_name
Stu_query.exec_(
"Select S.Student_name from Student_Class as SC,Student as S where\
SC.Class_id = (Select Class_id from Class where Class_name = '%s') \
and SC.Student_id = S.Student_id and SC.Class_finished <> 1 and \
SC.Class_approval <> 1" % self.class_name)
model = QSqlQueryModel()
model.setQuery(Stu_query)
self.ui.Addstu_detail_listView.setModel(model)
self.ui.Addstu_detail_listView.clicked.connect(self.add_student)
self.ui.Addstu_detail_btn.setEnabled(False)
self.ui.Addstu_detail_btn.clicked.connect(self.set_student)
