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)
