def deleteRecordsTintas(self): try: fila = [] for col in range(self.modelTinta.columnCount()): index = self.modelTinta.index( self.ui.viewTintas.currentIndex().row(), col) fila.append(str(self.modelTinta.data(index).toString())) tin = DTO.Tinta() tin.setIdTinta(fila[0]) DAO.TintaFicha().eliminarReferencia(fila[0], self.edicion) DAO.Tinta(tin).eliminarTinta() except Exception as e: MostrarError(str(e.message)) else: self.modelTinta.submitAll()
def updateRecordsTintas(self): try: fila = [] for col in range(self.modelTinta.columnCount()): index = self.modelTinta.index( self.ui.viewTintas.currentIndex().row(), col) fila.append(str(self.modelTinta.data(index).toString())) tin = DTO.Tinta() tin.setIdTinta(fila[0]) tin.setColor(str(fila[1])) tin.setTipo(str(fila[2])) tin.setAnilox(str(fila[3])) tin.setProveedor1(str(fila[4])) tin.setProveedor2(str(fila[5])) tin.setProveedor3(str(fila[6])) dialog = editarTinta.vEditarTinta() dialog.ui.leColorTinta.setText(tin.getColor()) dialog.ui.leTipoTinta.setText(tin.getTipo()) dialog.ui.leAniloxTinta.setText(tin.getAnilox()) dialog.ui.leProveedorTinta.setText(tin.getProveedor1()) dialog.ui.leProveedorTinta2.setText(tin.getProveedor2()) dialog.ui.leProveedorTinta3.setText(tin.getProveedor3()) dialog.exec_() except Exception as e: MostrarError(str(e.message)) else: if dialog.tintaEditada is not None: if (dialog.aceptado): tin.setColor(dialog.ui.leColorTinta.text()) tin.setTipo(dialog.ui.leTipoTinta.text()) tin.setAnilox(dialog.ui.leAniloxTinta.text()) tin.setProveedor1(dialog.ui.leProveedorTinta.text()) tin.setProveedor2(dialog.ui.leProveedorTinta2.text()) tin.setProveedor3(dialog.ui.leProveedorTinta3.text()) DAO.Tinta(tin).modificarTinta() self.modelTinta.submitAll() pass
def insertRecordsTintas(self): try: tin = DTO.Tinta() tin.setColor(self.ui.leColorTintaMod.text()) tin.setTipo(self.ui.leTipoTintaMod.text()) tin.setAnilox(self.ui.leAniloxTintaMod.text()) tin.setProveedor1(self.ui.leProveedorTintaMod.text()) tin.setProveedor2(self.ui.leProveedorTinta2Mod.text()) tin.setProveedor3(self.ui.leProveedorTinta3Mod.text()) DAO.Tinta(tin).ingresarTinta() "crear referencia de forma inmediata" tf = DAO.TintaFicha() tf.setIdFicha(self.edicion) tf.setIdTinta(DAO.Tinta().idUltimaTinta()) tf.insertarTintaFicha() self.cargarviewtintas() "" except Exception as e: MostrarError(str(e.message)) else: self.modelTinta.submitAll() "limpiarFormulario"