class DepartmentConf(QtGui.QDialog): def __init__(self,query,db,parent=None): QtGui.QDialog.__init__(self,parent) self.ui = Ui_Department() self.ui.setupUi(self) self.query = query self.db = db self.signal() self.fetch_dept() def signal(self): QtCore.QObject.connect(self.ui.add,QtCore.SIGNAL("clicked()"),self.onclick_add) def onclick_add(self): self.ui.departmentName.clear() if len(str(self.ui.departmentName.text())) == 0: QtGui.QMessageBox.warning(self,'Warning','Please Add Department!!!') else : self.query.exec_("""insert into department (department_name) values ('%s')"""%(self.ui.departmentName.text())) self.ui.treeWidget.clear() self.fetch_dept() QtGui.QMessageBox.information(self,'Information','Department Saved !!!') def fetch_dept(self): self.query.exec_(""" select department_name from department ;""") dept = [] while self.query.next(): dept.append(self.query.value(0).toString()) for i in range(len(dept)): item = QtGui.QTreeWidgetItem(self.ui.treeWidget) item.setText(0, dept[i])
def __init__(self,query,db,parent=None): QtGui.QDialog.__init__(self,parent) self.ui = Ui_Department() self.ui.setupUi(self) self.query = query self.db = db self.signal() self.fetch_dept()