.py
#!/usr/bin/env python# -*- coding: utf-8 -*-# @Date: 2018-12-05 21:28:34# @Author: Jimy_Fengqi (jmps515@163.com)# @Link: https://blog.csdn.net/qiqiyingse/import sysfrom PyQt5.QtWidgets import *from PyQt5.QtGui import *from PyQt5.QtCore import *import qdarkstyle#from PyQt5.QtSql import *from db.userInfoManager import BookDbManagerfrom db.userInfoManager import AddOrDropManagerimport timeimport imagesclass dropBookDialog(QDialog):drop_book_successful_signal=pyqtSignal()def __init__(self, parent=None):super(dropBookDialog, self).__init__(parent)self.setUpUI()self.setWindowModality(Qt.WindowModal)self.setWindowTitle("删除书籍")self.bookdb=BookDbManager()self.addordropdb=AddOrDropManager()def setUpUI(self):# 书名 ， 书号 ， 作者 ， 分类 ， 添加数量.出版社,出版日期# 书籍分类：哲学类、社会科学类、政治类、法律类、军事类、经济类、文化类、教育类、体育类、语言文字类、艺术类、历史类、地理类、天文学类、生物学类、医学卫生类、农业类BookCategory = ["哲学", "社会科学", "政治", "法律", "军事", "经济", "文化", "教育", "体育", "语言文字", "艺术", "历史", "地理", "天文学", "生物学", "医学卫生", "农业"]self.resize(300, 400)self.layout = QFormLayout()self.setLayout(self.layout)# Label控件self.titlelabel = QLabel("淘汰书籍")self.bookNameLabel = QLabel("书名:")self.bookIdLabel = QLabel("书号:")self.authNameLabel = QLabel("作者:")self.categoryLabel = QLabel("分类:")self.publisherLabel = QLabel("出 版 社:")self.publishDateLabel = QLabel("出版日期:")self.dropNumLabel = QLabel("数量:")# button控件self.dropBookButton = QPushButton("淘 汰")# lineEdit控件self.bookNameEdit = QLineEdit()self.bookIdEdit = QLineEdit()self.authNameEdit = QLineEdit()self.categoryComboBox = QComboBox()self.categoryComboBox.addItems(BookCategory)self.publisherEdit = QLineEdit()self.publishTime = QLineEdit()# self.publishDateEdit = QLineEdit()self.dropNumEdit = QLineEdit()self.bookNameEdit.setMaxLength(10)self.bookIdEdit.setMaxLength(6)self.authNameEdit.setMaxLength(10)self.publisherEdit.setMaxLength(10)self.dropNumEdit.setMaxLength(12)self.dropNumEdit.setValidator(QIntValidator())#设置限制输入类型为整型 ， 这里没有限制大小# 添加进formlayoutself.layout.addRow("", self.titlelabel)self.layout.addRow(self.bookNameLabel, self.bookNameEdit)self.layout.addRow(self.bookIdLabel, self.bookIdEdit)self.layout.addRow(self.authNameLabel, self.authNameEdit)self.layout.addRow(self.categoryLabel, self.categoryComboBox)self.layout.addRow(self.publisherLabel, self.publisherEdit)self.layout.addRow(self.publishDateLabel, self.publishTime)self.layout.addRow(self.dropNumLabel, self.dropNumEdit)self.layout.addRow("", self.dropBookButton)# 设置字体font = QFont()font.setPixelSize(20)self.titlelabel.setFont(font)font.setPixelSize(14)self.bookNameLabel.setFont(font)self.bookIdLabel.setFont(font)self.authNameLabel.setFont(font)self.categoryLabel.setFont(font)self.publisherLabel.setFont(font)self.publishDateLabel.setFont(font)self.dropNumLabel.setFont(font)self.bookNameEdit.setFont(font)self.bookNameEdit.setReadOnly(True)self.bookNameEdit.setStyleSheet("background-color:#363636")self.bookIdEdit.setFont(font)self.authNameEdit.setFont(font)self.authNameEdit.setReadOnly(True)self.authNameEdit.setStyleSheet("background-color:#363636")self.publisherEdit.setFont(font)self.publisherEdit.setReadOnly(True)self.publisherEdit.setStyleSheet("background-color:#363636")self.publishTime.setFont(font)self.publishTime.setStyleSheet("background-color:#363636")self.categoryComboBox.setFont(font)self.categoryComboBox.setStyleSheet("background-color:#363636")self.dropNumEdit.setFont(font)# button设置font.setPixelSize(16)self.dropBookButton.setFont(font)self.dropBookButton.setFixedHeight(32)self.dropBookButton.setFixedWidth(140)# 设置间距self.titlelabel.setMargin(8)self.layout.setVerticalSpacing(10)self.dropBookButton.clicked.connect(self.dropBookButtonClicked)self.bookIdEdit.textChanged.connect(self.bookIdEditChanged)def bookIdEditChanged(self):bookId = self.bookIdEdit.text()if (bookId == ""):self.bookNameEdit.clear()self.publisherEdit.clear()self.authNameEdit.clear()self.dropNumEdit.clear()self.publishTime.clear()bookinfo=self.bookdb.querybyBookID(bookId)# 查询对应书号 ， 如果存在就更新formif (bookinfo):self.bookNameEdit.setText(bookinfo[0][0])self.authNameEdit.setText(bookinfo[0][2])self.categoryComboBox.setCurrentText(bookinfo[0][3])self.publisherEdit.setText(bookinfo[0][4])self.publishTime.setText(bookinfo[0][5])returndef dropBookButtonClicked(self):bookId = self.bookIdEdit.text()dropNum = 0if (self.dropNumEdit.text() == ""):print(QMessageBox.warning(self, "警告", "淘汰数目为空 ， 请检查输入 ， 操作失败"), QMessageBox.Yes, QMessageBox.Yes)returndropNum = int(self.dropNumEdit.text())bookinfo=self.bookdb.querybyBookID(bookId)if (bookinfo):if (dropNum > bookinfo[0][7] anddropNum