コード例 #1
0
 def cargarviewtbarniz(self):
     self.modeltbarniz = QtSql.QSqlTableModel(self)
     self.modeltbarniz.setTable("tipo_barniz")
     listaref = self.cadenadereferencias(
         DAO.TBarnizFicha().leerTBarnizEnFicha(self.edicion))
     self.modeltbarniz.setFilter("idTBarniz  in {0}".format(listaref))
     self.modeltbarniz.setEditStrategy(QtSql.QSqlTableModel.OnManualSubmit)
     self.modeltbarniz.select()
     self.ui.viewTipoBarniz.setModel(self.modeltbarniz)
     self.ui.viewTipoBarniz.hideColumn(0)
     pass
コード例 #2
0
    def deleteRecordsTBarniz(self):
        try:
            fila = []
            for col in range(self.modeltbarniz.columnCount()):
                index = self.modeltbarniz.index(
                    self.ui.viewTipoBarniz.currentIndex().row(), col)
                fila.append(str(self.modeltbarniz.data(index).toString()))
            tbarniz = DTO.TipoBarniz()
            tbarniz.setIdTBarniz(fila[0])
            DAO.TBarnizFicha().eliminarReferencia(fila[0], self.edicion)
            DAO.TipoBarniz(tbarniz).eliminarTBarniz()

        except Exception as e:
            MostrarError(str(e.message))
        else:
            self.modeltbarniz.submitAll()
コード例 #3
0
    def insertRecordsTBarniz(self):
        try:
            tbarniz = DTO.TipoBarniz()
            tbarniz.setProveedor(self.ui.leProveedorTBarnizMod.text())
            tbarniz.setTipo(self.ui.leTipoTBarnizMod.text())
            tbarniz.setAnilox(self.ui.leAniloxTBarnizMod.text())

            DAO.TipoBarniz(tbarniz).ingresarTBarniz()
            "crear referencia de forma inmediata"
            tbf = DAO.TBarnizFicha()
            tbf.setIdFicha(self.edicion)
            tbf.setIdTBarniz(DAO.TipoBarniz().idUltimoTBarniz())
            tbf.insertarTBarnizFicha()
            self.cargarviewtbarniz()
        except Exception as e:
            MostrarError(str(e.message))

        else:
            self.modeltbarniz.submitAll()