def __init__(self, Id=1):
QtGui.QMainWindow.__init__(self)
self.ui = Ui_Role_window()
self.ui.setupUi(self)
self.conn() #need cathch exeption
Class_query = QSqlQuery()
Class_query.exec_(
"Select C.Class_name from Teacher_Class as T, Class as C where \
T.Class_id = C.Class_id and T.Teacher_id = '%s'" %
Id)
self.ui.Role_listView.setModel(QSqlQueryModel().setQuery(Class_query))
def __init__(self, Id=1):
QtGui.QMainWindow.__init__(self)
self.ui = Ui_Role_window()
self.ui.setupUi(self)
self.conn() #need cathch exeption
Class_query = QSqlQuery()
Class_query.exec_(
"Select C.Class_name from Teacher_Class as T, Class as C where \
T.Class_id = C.Class_id and T.Teacher_id = '%d'" %
Id)
model = QSqlQueryModel()
model.setQuery(Class_query)
self.ui.Role_listView.setModel(model)
self.ui.Role_listView.clicked.connect(self.show_class)
self.ui.Role_print_btn.clicked.connect(self.print_student)
self.ui.Role_print_btn.setEnabled(False)
def __init__(self, name):
QtGui.QMainWindow.__init__(self)
self.ui = Ui_Role_window()
self.ui.setupUi(self)
self.conn() #need catch exeption
Class_query = QSqlQuery()
Class_query.exec_("Select Class_name from Class as C, Teacher_Class as\
TC, Teacher as T where T.Teacher_id = TC.Teacher_id and \
T.Teacher_id = (select Teacher_id from Account where User_name = \
'%s') and TC.Class_id = C.Class_id ORDER BY Class_name"
% name)
model = QSqlQueryModel()
model.setQuery(Class_query)
self.ui.Role_listView.setModel(model)
self.ui.Role_listView.clicked.connect(self.show_class)
self.ui.Role_print_btn.clicked.connect(self.print_student)
self.ui.Role_print_btn.setEnabled(False)
