class Ui_CinsEkle(object): def setupUi(self, CinsEkle): CinsEkle.setObjectName("CinsEkle") CinsEkle.resize(382, 54) icon = QtGui.QIcon() icon.addPixmap(QtGui.QPixmap("logo.png"), QtGui.QIcon.Normal, QtGui.QIcon.Off) CinsEkle.setWindowIcon(icon) self.gridLayout = QtWidgets.QGridLayout(CinsEkle) self.gridLayout.setObjectName("gridLayout") self.label = QtWidgets.QLabel(CinsEkle) self.label.setObjectName("label") self.gridLayout.addWidget(self.label, 0, 0, 1, 1) self.lineEdit = QtWidgets.QLineEdit(CinsEkle) self.lineEdit.setObjectName("lineEdit") self.gridLayout.addWidget(self.lineEdit, 0, 1, 1, 1) self.pushButton = QtWidgets.QPushButton(CinsEkle) self.pushButton.setObjectName("pushButton") self.gridLayout.addWidget(self.pushButton, 0, 2, 1, 1) self.retranslateUi(CinsEkle) self.pushButton.clicked.connect(self.cins_yaz) QtCore.QMetaObject.connectSlotsByName(CinsEkle) def retranslateUi(self, CinsEkle): _translate = QtCore.QCoreApplication.translate CinsEkle.setWindowTitle(_translate("CinsEkle", "Gemi Türü Ekle")) self.label.setText(_translate("CinsEkle", "Yeni Gemi Türü Ekle")) self.pushButton.setText(_translate("CinsEkle", "Ekle")) def cins_yaz(self): self.yaz = VbagKur() ad = self.lineEdit.text() if ad == "": mesaj = "Lütfen bir gemi türü giriniz !!" mes.uyari(mesaj, "Bilgi Giriş Hatası") else: self.yaz.isle("INSERT INTO gemitur VALUES(NULL, '{}')".format(ad)) mesaj = ad + " türü veritabanına eklendi" mes.uyari(mesaj, "Kayıt Eklendi") self.lineEdit.clear()
class Ui_BolgeYerSil(QtWidgets.QDialog): signal = QtCore.pyqtSignal(int) def __init__(self): super(Ui_BolgeYerSil, self).__init__() self.yaz = VbagKur() self.setupUi() def setupUi(self): self.setObjectName("BolgeYerSil") self.resize(632, 316) icon = QtGui.QIcon() icon.addPixmap(QtGui.QPixmap(":/rolix/docky.png"), QtGui.QIcon.Normal, QtGui.QIcon.Off) self.setWindowIcon(icon) self.label = QtWidgets.QLabel(self) self.label.setGeometry(QtCore.QRect(10, 10, 91, 61)) self.label.setText("") self.label.setPixmap( QtGui.QPixmap(":/rolix/scalable/package-remove.svg")) self.label.setAlignment(QtCore.Qt.AlignCenter) self.label.setObjectName("label") self.groupBox = QtWidgets.QGroupBox(self) self.groupBox.setGeometry(QtCore.QRect(10, 80, 300, 225)) self.groupBox.setObjectName("groupBox") self.gridLayout_2 = QtWidgets.QGridLayout(self.groupBox) self.gridLayout_2.setObjectName("gridLayout_2") self.listWidget = QtWidgets.QListWidget(self.groupBox) self.listWidget.setObjectName("listWidget") self.gridLayout_2.addWidget(self.listWidget, 0, 0, 1, 1) self.groupBox_2 = QtWidgets.QGroupBox(self) self.groupBox_2.setGeometry(QtCore.QRect(320, 80, 300, 225)) self.groupBox_2.setObjectName("groupBox_2") self.gridLayout = QtWidgets.QGridLayout(self.groupBox_2) self.gridLayout.setObjectName("gridLayout") self.listWidget_2 = QtWidgets.QListWidget(self.groupBox_2) self.listWidget_2.setObjectName("listWidget_2") self.gridLayout.addWidget(self.listWidget_2, 0, 0, 1, 1) self.label_2 = QtWidgets.QLabel(self) self.label_2.setGeometry(QtCore.QRect(100, 10, 511, 51)) self.label_2.setObjectName("label_2") self.bilgi_listele() self.retranslateUi() self.listWidget.itemDoubleClicked.connect(self.silb) self.listWidget_2.itemDoubleClicked.connect(self.sily) QtCore.QMetaObject.connectSlotsByName(self) def bilgi_listele(self): self.listWidget.addItems( self.yaz.coklu_tup_temizle(self.yaz.kolon_oku("ad, kod", "bolge"))) self.listWidget_2.addItems( self.yaz.coklu_tup_temizle(self.yaz.kolon_oku("ad", "yer"))) def silb(self): if mes.yerbolsil(self.listWidget.currentItem().text()) == True: kay_no = self.yaz.komut( "select kod from bolge where ad='{}'".format( self.listWidget.currentItem().text())) self.yaz.isle("delete from yer where kod ='{}'".format(kay_no[0])) self.yaz.kayit_sil("bolge", "ad", self.listWidget.currentItem().text()) self.listWidget.clear() self.listWidget_2.clear() self.bilgi_listele() self.on_changed_value(1) else: pass def sily(self): if mes.yerbolsil(self.listWidget_2.currentItem().text()) == True: self.yaz.kayit_sil("yer", "ad", self.listWidget_2.currentItem().text()) self.listWidget.clear() self.listWidget_2.clear() self.bilgi_listele() self.on_changed_value(2) else: pass def retranslateUi(self): _translate = QtCore.QCoreApplication.translate self.setWindowTitle(_translate("BolgeYerSil", "Bölge Ve Yer Sil")) self.groupBox.setTitle(_translate("BolgeYerSil", "Bölge Listesi")) self.groupBox_2.setTitle(_translate("BolgeYerSil", "Yer Listesi")) self.label_2.setText( _translate( "BolgeYerSil", "Veritabanından silmek istediğiniz Bölge veya Yer bilgisinin üzerine çift tıklayınız." )) def on_changed_value(self, value): self.signal.emit(value)