class Admin_list_window(QtGui.QMainWindow):
def __init__(self):
QtGui.QMainWindow.__init__(self)
self.ui = Ui_Admin_list()
self.ui.setupUi(self)
self.conn()
self.Admin_query = QSqlQuery()
self.Admin_query.exec_("select Admin_name from Admin")
model = QSqlQueryModel()
model.setQuery(self.Admin_query)
self.ui.Admin_listView.setModel(model)
self.ui.Detail_btn.setEnabled(False)
self.ui.Search_btn.clicked.connect(self.search_Admin)
self.ui.Detail_btn.clicked.connect(self.print_Detail)
self.ui.Add_btn.clicked.connect(self.add_Admin)
self.ui.Remove_btn.clicked.connect(self.remove_Admin)
self.ui.Admin_listView.clicked.connect(self.select_Admin)
def add_Admin(self):
self.adminDialog = addAdmin()
if self.adminDialog.exec_():
model = QSqlQueryModel()
model.setQuery(self.Admin_query)
self.ui.Admin_listView.setModel(model)
def remove_Admin(self):
self.removeDialog = removeAdmin()
if self.removeDialog.exec_():
model = QSqlQueryModel()
model.setQuery(self.Admin_query)
self.ui.Admin_listView.setModel(model)
def search_Admin(self):
input_Admin_name = self.ui.Admin_lineEdit.text()
Admin_query = QSqlQuery()
Admin_query.exec_("select Admin_name from Admin where Admin_name like '%%%s%%'" % input_Admin_name)
model = QSqlQueryModel()
model.setQuery(Admin_query)
self.ui.Admin_listView.setModel(model)
def print_Detail(self):
self.ui.detail = Admin_info_dialog(self.ui.name)
self.ui.detail.show()
def select_Admin(self, index):
self.ui.name = index.data()
self.ui.Detail_btn.setEnabled(True)
def conn(self):
self.db = QSqlDatabase.addDatabase("QMYSQL")
self.db.setHostName("services1.mcs.sdsmt.edu")
self.db.setDatabaseName("db_dancesoft_f15")
self.db.setUserName("dancesoft_f15")
self.db.setPassword("DanceSoft")
return self.db.open()
def __init__(self):
QtGui.QMainWindow.__init__(self)
self.ui = Ui_Admin_list()
self.ui.setupUi(self)
self.conn()
Admin_query = QSqlQuery()
Admin_query.exec_("select Admin_name from Admin")
model = QSqlQueryModel()
model.setQuery(Admin_query)
self.ui.Admin_listView.setModel(model)
self.ui.Detail_btn.setEnabled(False)
self.ui.Search_btn.clicked.connect(self.search_Admin)
self.ui.Detail_btn.clicked.connect(self.print_Detail)
self.ui.Admin_listView.clicked.connect(self.select_Admin)
class Admin_list_window(QtGui.QMainWindow):
def __init__(self):
QtGui.QMainWindow.__init__(self)
self.ui = Ui_Admin_list()
self.ui.setupUi(self)
self.conn()
Admin_query = QSqlQuery()
Admin_query.exec_("select Admin_name from Admin")
model = QSqlQueryModel()
model.setQuery(Admin_query)
self.ui.Admin_listView.setModel(model)
self.ui.Detail_btn.setEnabled(False)
self.ui.Search_btn.clicked.connect(self.search_Admin)
self.ui.Detail_btn.clicked.connect(self.print_Detail)
self.ui.Admin_listView.clicked.connect(self.select_Admin)
def search_Admin(self):
input_Admin_name = self.ui.Admin_lineEdit.text()
Admin_query = QSqlQuery()
Admin_query.exec_(
"select Admin_name from Admin where Admin_name like '%%%s%%'" %
input_Admin_name)
model = QSqlQueryModel()
model.setQuery(Admin_query)
self.ui.Admin_listView.setModel(model)
def print_Detail(self):
self.ui.detail = Admin_info_dialog(self.ui.name)
self.ui.detail.show()
def select_Admin(self, index):
self.ui.name = index.data()
self.ui.Detail_btn.setEnabled(True)
def conn(self):
self.db = QSqlDatabase.addDatabase("QMYSQL")
self.db.setHostName("services1.mcs.sdsmt.edu")
self.db.setDatabaseName("db_dancesoft_f15")
self.db.setUserName("dancesoft_f15")
self.db.setPassword("DanceSoft")
return self.db.open()
def __init__(self):
QtGui.QMainWindow.__init__(self)
self.ui = Ui_Admin_list()
self.ui.setupUi(self)
self.conn()
Admin_query = QSqlQuery()
Admin_query.exec_("select Admin_name from Admin")
model = QSqlQueryModel()
model.setQuery(Admin_query)
self.ui.Admin_listView.setModel(model)
self.ui.Detail_btn.setEnabled(False)
self.ui.Search_btn.clicked.connect(self.search_Admin)
self.ui.Detail_btn.clicked.connect(self.print_Detail)
self.ui.Admin_listView.clicked.connect(self.select_Admin)
