class Ui_Firmaguncelle(VbagKur): def __init__(self): self.yaz = VbagKur() self.change_no = 0 def setupUi(self, Firmaguncelle): Firmaguncelle.setObjectName("Firmaguncelle") Firmaguncelle.resize(398, 300) self.label_2 = QtWidgets.QLabel(Firmaguncelle) self.label_2.setGeometry(QtCore.QRect(10, 40, 68, 20)) self.label_2.setObjectName("label_2") self.label_4 = QtWidgets.QLabel(Firmaguncelle) self.label_4.setGeometry(QtCore.QRect(10, 100, 68, 20)) self.label_4.setObjectName("label_4") self.label = QtWidgets.QLabel(Firmaguncelle) self.label.setGeometry(QtCore.QRect(10, 10, 68, 20)) self.label.setObjectName("label") self.label_3 = QtWidgets.QLabel(Firmaguncelle) self.label_3.setGeometry(QtCore.QRect(10, 70, 68, 20)) self.label_3.setObjectName("label_3") self.label_5 = QtWidgets.QLabel(Firmaguncelle) self.label_5.setGeometry(QtCore.QRect(10, 160, 68, 20)) self.label_5.setObjectName("label_5") self.lineEdit = QtWidgets.QLineEdit(Firmaguncelle) self.lineEdit.setGeometry(QtCore.QRect(90, 10, 291, 21)) self.lineEdit.setObjectName("lineEdit") self.lineEdit_2 = QtWidgets.QLineEdit(Firmaguncelle) self.lineEdit_2.setGeometry(QtCore.QRect(90, 40, 291, 21)) self.lineEdit_2.setObjectName("lineEdit_2") self.lineEdit_3 = QtWidgets.QLineEdit(Firmaguncelle) self.lineEdit_3.setGeometry(QtCore.QRect(90, 70, 291, 21)) self.lineEdit_3.setObjectName("lineEdit_3") self.lineEdit_4 = QtWidgets.QLineEdit(Firmaguncelle) self.lineEdit_4.setGeometry(QtCore.QRect(90, 100, 291, 21)) self.lineEdit_4.setObjectName("lineEdit_4") self.lineEdit_5 = QtWidgets.QLineEdit(Firmaguncelle) self.lineEdit_5.setGeometry(QtCore.QRect(90, 130, 291, 21)) self.lineEdit_5.setObjectName("lineEdit_5") self.label_6 = QtWidgets.QLabel(Firmaguncelle) self.label_6.setGeometry(QtCore.QRect(10, 130, 68, 20)) self.label_6.setObjectName("label_6") self.textEdit = QtWidgets.QTextEdit(Firmaguncelle) self.textEdit.setGeometry(QtCore.QRect(90, 160, 291, 101)) self.textEdit.setObjectName("textEdit") self.pushButton = QtWidgets.QPushButton(Firmaguncelle) self.pushButton.setGeometry(QtCore.QRect(310, 270, 75, 23)) self.pushButton.setFocusPolicy(QtCore.Qt.NoFocus) self.pushButton.setObjectName("pushButton") self.retranslateUi(Firmaguncelle) self.lineEdit.returnPressed.connect(self.bilgibul) self.pushButton.clicked.connect(self.guncelle) QtCore.QMetaObject.connectSlotsByName(Firmaguncelle) def guncelle(self): kod = self.lineEdit.text() ad = self.lineEdit_2.text() vergidairesi = self.lineEdit_3.text() vergino = self.lineEdit_4.text() telefon = self.lineEdit_5.text() adres = self.textEdit.toPlainText() self.yaz.firma_guncelle(kod, ad, vergidairesi, vergino, telefon, adres, self.change_no) mesaj = ad + " Firmasının veritabanı kaydı başarıyla güncellendi" mes.uyari(mesaj, "Bilgilendirme") self.lineEdit.clear() self.lineEdit_2.clear() self.lineEdit_3.clear() self.lineEdit_4.clear() self.lineEdit_5.clear() self.textEdit.clear() self.yaz.veritabanini_kapat() def bilgibul(self): if self.lineEdit.text() == "": pass else: veri = self.yaz.tek_oku("firmalar", "kod", self.lineEdit.text()) self.lineEdit_2.setText(veri[0][2]) self.lineEdit_3.setText(veri[0][3]) self.lineEdit_4.setText(veri[0][4]) self.lineEdit_5.setText(veri[0][5]) self.textEdit.setPlainText(veri[0][6]) self.change_no = veri[0][0] def retranslateUi(self, Firmaguncelle): _translate = QtCore.QCoreApplication.translate Firmaguncelle.setWindowTitle( _translate("Firmaguncelle", "Müşteri Bilgisi Güncelle")) self.label_2.setText(_translate("Firmaguncelle", "Müşteri Adı")) self.label_4.setText(_translate("Firmaguncelle", "Vergi No")) self.label.setText(_translate("Firmaguncelle", "Müşteri Kodu")) self.label_3.setText(_translate("Firmaguncelle", "Vergi Dairesi")) self.label_5.setText(_translate("Firmaguncelle", "Adres")) self.label_6.setText(_translate("Firmaguncelle", "Telefon")) self.pushButton.setText(_translate("Firmaguncelle", "GÜNCELLE"))
class Ui_Firmaolustur(VbagKur): def __init__(self): self.yaz = VbagKur() def setupUi(self, Firmaolustur): Firmaolustur.setObjectName("Firmaolustur") Firmaolustur.resize(400, 318) self.label = QtWidgets.QLabel(Firmaolustur) self.label.setGeometry(QtCore.QRect(16, 10, 68, 20)) self.label.setObjectName("label") self.lineEdit = QtWidgets.QLineEdit(Firmaolustur) self.lineEdit.setGeometry(QtCore.QRect(90, 10, 281, 20)) self.lineEdit.setObjectName("lineEdit") self.lineEdit_2 = QtWidgets.QLineEdit(Firmaolustur) self.lineEdit_2.setGeometry(QtCore.QRect(90, 40, 281, 20)) self.lineEdit_2.setObjectName("lineEdit_2") self.label_2 = QtWidgets.QLabel(Firmaolustur) self.label_2.setGeometry(QtCore.QRect(16, 40, 68, 20)) self.label_2.setObjectName("label_2") self.label_3 = QtWidgets.QLabel(Firmaolustur) self.label_3.setGeometry(QtCore.QRect(16, 70, 68, 20)) self.label_3.setObjectName("label_3") self.lineEdit_3 = QtWidgets.QLineEdit(Firmaolustur) self.lineEdit_3.setGeometry(QtCore.QRect(90, 70, 281, 20)) self.lineEdit_3.setObjectName("lineEdit_3") self.lineEdit_4 = QtWidgets.QLineEdit(Firmaolustur) self.lineEdit_4.setGeometry(QtCore.QRect(90, 100, 281, 20)) self.lineEdit_4.setObjectName("lineEdit_4") self.label_4 = QtWidgets.QLabel(Firmaolustur) self.label_4.setGeometry(QtCore.QRect(16, 100, 68, 20)) self.label_4.setObjectName("label_4") self.label_5 = QtWidgets.QLabel(Firmaolustur) self.label_5.setGeometry(QtCore.QRect(16, 160, 68, 20)) self.label_5.setObjectName("label_5") self.label_6 = QtWidgets.QLabel(Firmaolustur) self.label_6.setGeometry(QtCore.QRect(16, 130, 68, 20)) self.label_6.setObjectName("label_6") self.lineEdit_5 = QtWidgets.QLineEdit(Firmaolustur) self.lineEdit_5.setGeometry(QtCore.QRect(90, 130, 281, 20)) self.lineEdit_5.setText("") self.lineEdit_5.setObjectName("lineEdit_5") self.textEdit = QtWidgets.QTextEdit(Firmaolustur) self.textEdit.setGeometry(QtCore.QRect(90, 160, 281, 111)) self.textEdit.setObjectName("textEdit") self.pushButton = QtWidgets.QPushButton(Firmaolustur) self.pushButton.setGeometry(QtCore.QRect(300, 280, 75, 23)) self.pushButton.setObjectName("pushButton") self.retranslateUi(Firmaolustur) self.pushButton.clicked.connect(self.firmabilgisiyaz) QtCore.QMetaObject.connectSlotsByName(Firmaolustur) def firmabilgisiyaz(self): kod = self.lineEdit.text() ad = self.lineEdit_2.text() vergidairesi = self.lineEdit_3.text() vergino = self.lineEdit_4.text() telefon = self.lineEdit_5.text() adres = self.textEdit.toPlainText() self.yaz.firma_ekle(kod, ad, vergidairesi, vergino, telefon, adres) mesaj = ad + " Firmasının veritabanı kaydı başarıyla yapıldı" mes.uyari(mesaj, "Bilgilendirme") self.lineEdit.clear() self.lineEdit_2.clear() self.lineEdit_3.clear() self.lineEdit_4.clear() self.lineEdit_5.clear() self.textEdit.clear() self.yaz.veritabanini_kapat() def retranslateUi(self, Firmaolustur): _translate = QtCore.QCoreApplication.translate Firmaolustur.setWindowTitle(_translate("Firmaolustur", "Firma Oluştur")) self.label.setText(_translate("Firmaolustur", "Müşteri Kodu")) self.label_2.setText(_translate("Firmaolustur", "Müşteri Adı")) self.label_3.setText(_translate("Firmaolustur", "Vergi Dairesi")) self.label_4.setText(_translate("Firmaolustur", "Vergi No")) self.label_5.setText(_translate("Firmaolustur", "Adres")) self.label_6.setText(_translate("Firmaolustur", "Telefon")) self.pushButton.setText(_translate("Firmaolustur", "OLUŞTUR"))