示例#1
0
class Worker_Class(QtGui.QDialog):
    def __init__(self, nomcard, parent=None):
        QtGui.QDialog.__init__(self, parent)
        self.ui = Ui_Worker()
        self.ui.setupUi(self)

        self.fillWorker(nomcard)

        self.connect(self.ui.saveButton, QtCore.SIGNAL("clicked()"), QtCore.SLOT("on_click_saveButton()"))

    def on_click_saveButton(self):
        self.saveData(self.getParamsFromWindow())

    def getParamsFromWindow(self):
        name = self.ui.nameEdit.text()
        card = "{:0>16}".format(self.ui.cardEdit.text())
        employee = "{:0>16}".format(self.ui.employeeEdit.text())
        db = localDb_Class()
        company = db.select_val_by_col("company", "name", "'%s'" % self.ui.comboBox.currentText())["rows"][0][0]
        db.close_db()
        param = (company, card, name, employee)
        return param

    def fillWorker(self, nomcard):
        self.ui.cardEdit.setText(nomcard)
        map(self.setCompany, self.getCompany())

    def setCompany(self, row):
        self.ui.comboBox.insertItem(row[0], row[1])

    def getCompany(self):
        db = localDb_Class()
        val = [(t[0], t[1]) for t in db.select_all_val("company")["rows"]]
        db.close_db()
        return val

    def saveData(self, data):
        db = localDb_Class()
        try:
            db.insert_val("worker", data)
            self.close()

        except Exception as e:
            errWindow = QtGui.QWidget(self, QtCore.Qt.Window)
            errWindow.setWindowTitle(u"Ошибка")
            errWindow.setWindowModality(QtCore.Qt.WindowModal)
            errWindow.show()
        db.close_db()
示例#2
0
    def __init__(self, nomcard, parent=None):
        QtGui.QDialog.__init__(self, parent)
        self.ui = Ui_Worker()
        self.ui.setupUi(self)

        self.fillWorker(nomcard)

        self.connect(self.ui.saveButton, QtCore.SIGNAL("clicked()"), QtCore.SLOT("on_click_saveButton()"))