def setupUi(self, Dialog):
Dialog.setObjectName("Dialog")
Dialog.resize(1009, 696)
font = QtGui.QFont()
font.setFamily("微软雅黑 Light")
font.setPointSize(10)
Dialog.setFont(font)
self.verticalLayout = QtWidgets.QVBoxLayout(Dialog)
self.verticalLayout.setObjectName("verticalLayout")
self.label = QtWidgets.QLabel(Dialog)
font = QtGui.QFont()
font.setFamily("Agency FB")
font.setPointSize(16)
self.label.setFont(font)
self.label.setAlignment(QtCore.Qt.AlignCenter)
self.label.setObjectName("label")
self.verticalLayout.addWidget(self.label)
self.horizontalLayout = QtWidgets.QHBoxLayout()
self.horizontalLayout.setObjectName("horizontalLayout")
spacerItem = QtWidgets.QSpacerItem(188, 20,
QtWidgets.QSizePolicy.Expanding,
QtWidgets.QSizePolicy.Minimum)
self.horizontalLayout.addItem(spacerItem)
self.label_4 = QtWidgets.QLabel(Dialog)
self.label_4.setObjectName("label_4")
self.horizontalLayout.addWidget(self.label_4)
self.searchEdit = QtWidgets.QLineEdit(Dialog)
self.searchEdit.setMaximumSize(QtCore.QSize(400, 16777215))
self.searchEdit.setObjectName("lineEdit_2")
self.horizontalLayout.addWidget(self.searchEdit)
self.pushButton_2 = QtWidgets.QPushButton(Dialog)
self.pushButton_2.setObjectName("pushButton_2")
self.horizontalLayout.addWidget(self.pushButton_2)
self.verticalLayout.addLayout(self.horizontalLayout)
# 中间手动代码部分 表格UI构建
self.db = openDB()
self.tableView = QTableView()
# hsj 自动义的tableModel
slt = "ProductNO,ProductName,T_Out_Detail.ProductID,OutDate,UsedID"
headerRow = ["产品代号", "产品名称", "产品编号", "出库时间", "使用人"]
self.queryModel = MySearchTableModelPIM(
"T_Out_Base,T_Out_Detail,T_Product_New", headerRow, slt)
self.tableView.setModel(self.queryModel)
self.header = CheckBoxHeader()
self.tableView.setHorizontalHeader(self.header)
self.header.clicked.connect(self.queryModel.headerClick)
self.tableView.horizontalHeader().setStretchLastSection(True)
self.tableView.horizontalHeader().setSectionResizeMode(
QHeaderView.Stretch)
self.tableView.setModel(self.queryModel)
self.verticalLayout.addWidget(self.tableView)
self.verticalLayout.addWidget(self.tableView)
self.horizontalLayout_4 = QtWidgets.QHBoxLayout()
self.horizontalLayout_4.setObjectName("horizontalLayout_4")
spacerItem1 = QtWidgets.QSpacerItem(40, 20,
QtWidgets.QSizePolicy.Expanding,
QtWidgets.QSizePolicy.Minimum)
self.horizontalLayout_4.addItem(spacerItem1)
self.horizontalLayout_2 = QtWidgets.QHBoxLayout()
self.horizontalLayout_2.setObjectName("horizontalLayout_2")
self.label_2 = QtWidgets.QLabel(Dialog)
self.label_2.setObjectName("label_2")
self.horizontalLayout_2.addWidget(self.label_2)
self.jumpEdit = QtWidgets.QLineEdit(Dialog)
self.jumpEdit.setMaximumSize(QtCore.QSize(50, 50))
self.jumpEdit.setMaxLength(9999)
self.jumpEdit.setAlignment(QtCore.Qt.AlignCenter)
self.jumpEdit.setObjectName("jumpEdit")
self.horizontalLayout_2.addWidget(self.jumpEdit)
self.totalPageLabel = QtWidgets.QLabel(Dialog)
self.totalPageLabel.setObjectName("totalPageLabel")
self.horizontalLayout_2.addWidget(self.totalPageLabel)
self.jumpButton = QtWidgets.QPushButton(Dialog)
self.jumpButton.setObjectName("jumpButton")
self.horizontalLayout_2.addWidget(self.jumpButton)
self.previousButton = QtWidgets.QPushButton(Dialog)
self.previousButton.setObjectName("previousButton")
self.horizontalLayout_2.addWidget(self.previousButton)
self.nextButton = QtWidgets.QPushButton(Dialog)
self.nextButton.setObjectName("nextButton")
self.horizontalLayout_2.addWidget(self.nextButton)
self.horizontalLayout_4.addLayout(self.horizontalLayout_2)
spacerItem2 = QtWidgets.QSpacerItem(40, 20,
QtWidgets.QSizePolicy.Expanding,
QtWidgets.QSizePolicy.Minimum)
self.horizontalLayout_4.addItem(spacerItem2)
self.verticalLayout.addLayout(self.horizontalLayout_4)
self.retranslateUi(Dialog)
self.bindButton()
QtCore.QMetaObject.connectSlotsByName(Dialog)
def setupUi(self, Form):
Form.setObjectName("Form")
Form.resize(958, 696)
font = QtGui.QFont()
font.setFamily("微软雅黑 Light")
font.setPointSize(10)
Form.setFont(font)
self.verticalLayout = QtWidgets.QVBoxLayout(Form)
self.verticalLayout.setObjectName("verticalLayout")
self.label = QtWidgets.QLabel(Form)
font = QtGui.QFont()
font.setFamily("Agency FB")
font.setPointSize(16)
self.label.setFont(font)
self.label.setAlignment(QtCore.Qt.AlignCenter)
self.label.setObjectName("label")
self.verticalLayout.addWidget(self.label)
self.horizontalLayout = QtWidgets.QHBoxLayout()
self.horizontalLayout.setObjectName("horizontalLayout")
self.label_3 = QtWidgets.QLabel(Form)
self.label_3.setObjectName("label_3")
self.horizontalLayout.addWidget(self.label_3)
self.dateEdit = QtWidgets.QDateEdit(Form)
self.dateEdit.setDisplayFormat("yyyy-MM-dd")
self.dateEdit.setMinimumWidth(120)
self.dateEdit.setMinimumDate(QDate(2015, 1, 1))
self.dateEdit.setDate(
QDate.fromString(time.strftime("%Y-%m-%d", time.localtime()),
'yyyy-MM-dd'))
self.dateEdit.setMaximumDate(QDate(2199, 1, 1))
self.dateEdit.setCalendarPopup(True)
self.dateEdit.setObjectName("dateEdit")
self.horizontalLayout.addWidget(self.dateEdit)
self.label_4 = QtWidgets.QLabel(Form)
self.label_4.setObjectName("label_4")
self.horizontalLayout.addWidget(self.label_4)
self.dateEdit_2 = QtWidgets.QDateEdit(Form)
self.dateEdit_2.setDisplayFormat("yyyy-MM-dd")
self.dateEdit_2.setMinimumWidth(120)
self.dateEdit_2.setMinimumDate(QDate(2015, 1, 1))
self.dateEdit_2.setDate(
QDate.fromString(time.strftime("%Y-%m-%d", time.localtime()),
'yyyy-MM-dd'))
self.dateEdit_2.setMaximumDate(QDate(2199, 1, 1))
self.dateEdit_2.setCalendarPopup(True)
self.dateEdit_2.setObjectName("dateEdit_2")
self.horizontalLayout.addWidget(self.dateEdit_2)
spacerItem = QtWidgets.QSpacerItem(68, 29,
QtWidgets.QSizePolicy.Expanding,
QtWidgets.QSizePolicy.Minimum)
self.horizontalLayout.addItem(spacerItem)
self.label_5 = QtWidgets.QLabel(Form)
self.label_5.setObjectName("label_5")
self.horizontalLayout.addWidget(self.label_5)
self.searchEdit = QtWidgets.QLineEdit(Form)
self.searchEdit.setMaximumSize(QtCore.QSize(400, 16777215))
self.searchEdit.setObjectName("lineEdit_2")
self.horizontalLayout.addWidget(self.searchEdit)
self.pushButton_2 = QtWidgets.QPushButton(Form)
self.pushButton_2.setObjectName("pushButton_2")
self.horizontalLayout.addWidget(self.pushButton_2)
self.verticalLayout.addLayout(self.horizontalLayout)
# 中间手动代码部分 表格UI构建
self.db = openDB()
self.tableView = QTableView()
slt = "ProductID,ProductNO,ProductName,InitCount"
headerRow = ["产品编号", "产品代号", "产品名称", "交付数量", "合计(同一产品代号)"]
self.queryModel = MySearchTableModelPIM("T_Product_New", headerRow,
slt)
self.tableView.setModel(self.queryModel)
self.header = CheckBoxHeader()
self.tableView.setHorizontalHeader(self.header)
self.header.clicked.connect(self.queryModel.headerClick)
self.tableView.horizontalHeader().setStretchLastSection(True)
self.tableView.horizontalHeader().setSectionResizeMode(
QHeaderView.Stretch)
self.tableView.setModel(self.queryModel)
self.verticalLayout.addWidget(self.tableView)
self.verticalLayout.addWidget(self.tableView)
self.horizontalLayout_4 = QtWidgets.QHBoxLayout()
self.horizontalLayout_4.setObjectName("horizontalLayout_4")
spacerItem1 = QtWidgets.QSpacerItem(40, 20,
QtWidgets.QSizePolicy.Expanding,
QtWidgets.QSizePolicy.Minimum)
self.horizontalLayout_4.addItem(spacerItem1)
self.horizontalLayout_2 = QtWidgets.QHBoxLayout()
self.horizontalLayout_2.setObjectName("horizontalLayout_2")
self.label_2 = QtWidgets.QLabel(Form)
self.label_2.setObjectName("label_2")
self.horizontalLayout_2.addWidget(self.label_2)
self.jumpEdit = QtWidgets.QLineEdit(Form)
self.jumpEdit.setMaximumSize(QtCore.QSize(50, 50))
self.jumpEdit.setMaxLength(9999)
self.jumpEdit.setAlignment(QtCore.Qt.AlignCenter)
self.jumpEdit.setObjectName("jumpEdit")
self.horizontalLayout_2.addWidget(self.jumpEdit)
self.totalPageLabel = QtWidgets.QLabel(Form)
self.totalPageLabel.setObjectName("totalPageLabel")
self.horizontalLayout_2.addWidget(self.totalPageLabel)
self.jumpButton = QtWidgets.QPushButton(Form)
self.jumpButton.setObjectName("jumpButton")
self.horizontalLayout_2.addWidget(self.jumpButton)
self.previousButton = QtWidgets.QPushButton(Form)
self.previousButton.setObjectName("previousButton")
self.horizontalLayout_2.addWidget(self.previousButton)
self.nextButton = QtWidgets.QPushButton(Form)
self.nextButton.setObjectName("nextButton")
self.horizontalLayout_2.addWidget(self.nextButton)
self.horizontalLayout_4.addLayout(self.horizontalLayout_2)
spacerItem2 = QtWidgets.QSpacerItem(40, 20,
QtWidgets.QSizePolicy.Expanding,
QtWidgets.QSizePolicy.Minimum)
self.horizontalLayout_4.addItem(spacerItem2)
self.verticalLayout.addLayout(self.horizontalLayout_4)
self.retranslateUi(Form)
self.bindButton()
QtCore.QMetaObject.connectSlotsByName(Form)
def setupUi(self, Form):
Form.setObjectName("Form")
Form.resize(1009, 696)
font = QtGui.QFont()
font.setFamily("微软雅黑 Light")
font.setPointSize(10)
Form.setFont(font)
self.verticalLayout = QtWidgets.QVBoxLayout(Form)
self.verticalLayout.setObjectName("verticalLayout")
self.label = QtWidgets.QLabel(Form)
font = QtGui.QFont()
font.setFamily("Agency FB")
font.setPointSize(16)
self.label.setFont(font)
self.label.setAlignment(QtCore.Qt.AlignCenter)
self.label.setObjectName("label")
self.verticalLayout.addWidget(self.label)
self.horizontalLayout = QtWidgets.QHBoxLayout()
self.horizontalLayout.setObjectName("horizontalLayout")
self.label_4 = QtWidgets.QLabel(Form)
self.label_4.setObjectName("label_4")
spacerItem = QtWidgets.QSpacerItem(188, 20,
QtWidgets.QSizePolicy.Expanding,
QtWidgets.QSizePolicy.Minimum)
self.horizontalLayout.addItem(spacerItem)
self.label_4 = QtWidgets.QLabel(Form)
self.label_4.setObjectName("label_4")
self.horizontalLayout.addWidget(self.label_4)
self.searchEdit = QtWidgets.QLineEdit(Form)
self.searchEdit.setMaximumSize(QtCore.QSize(400, 16777215))
self.searchEdit.setObjectName("lineEdit_2")
self.horizontalLayout.addWidget(self.searchEdit)
self.pushButton_4 = QtWidgets.QPushButton(Form)
self.pushButton_4.setObjectName("pushButton_4")
self.horizontalLayout.addWidget(self.pushButton_4)
self.verticalLayout.addLayout(self.horizontalLayout)
# 中间手动代码部分 表格UI构建
self.db = openDB()
self.tableView = QTableView()
# hsj 自动义的tableModel
slt = "ProductNO,ProductName,ProductID,RecentTime,Interva,AlterRule,MaintenanceWayID,MaintenanceWayName"
headerRow = [
"产品代号", "产品名称", "产品编号", "维保到期时间", "维保周期", "据到期提醒", "维保方式ID",
"维保方式名称"
]
self.queryModel = MySearchTableModelPIM("MaintenanceWay", headerRow,
slt)
self.tableView.setModel(self.queryModel)
self.header = CheckBoxHeader()
self.tableView.setHorizontalHeader(self.header)
self.header.clicked.connect(self.queryModel.headerClick)
self.tableView.horizontalHeader().setStretchLastSection(True)
self.tableView.horizontalHeader().setSectionResizeMode(
QHeaderView.Stretch)
self.tableView.setModel(self.queryModel)
self.verticalLayout.addWidget(self.tableView)
self.verticalLayout.addWidget(self.tableView)
self.horizontalLayout_4 = QtWidgets.QHBoxLayout()
self.horizontalLayout_4.setObjectName("horizontalLayout_4")
spacerItem1 = QtWidgets.QSpacerItem(40, 20,
QtWidgets.QSizePolicy.Expanding,
QtWidgets.QSizePolicy.Minimum)
self.horizontalLayout_4.addItem(spacerItem1)
self.horizontalLayout_2 = QtWidgets.QHBoxLayout()
self.horizontalLayout_2.setObjectName("horizontalLayout_2")
self.label_2 = QtWidgets.QLabel(Form)
self.label_2.setObjectName("label_2")
self.horizontalLayout_2.addWidget(self.label_2)
self.jumpEdit = QtWidgets.QLineEdit(Form)
self.jumpEdit.setMaximumSize(QtCore.QSize(50, 50))
self.jumpEdit.setMaxLength(9999)
self.jumpEdit.setAlignment(QtCore.Qt.AlignCenter)
self.jumpEdit.setObjectName("jumpEdit")
self.horizontalLayout_2.addWidget(self.jumpEdit)
self.totalPageLabel = QtWidgets.QLabel(Form)
self.totalPageLabel.setObjectName("totalPageLabel")
self.horizontalLayout_2.addWidget(self.totalPageLabel)
self.jumpButton = QtWidgets.QPushButton(Form)
self.jumpButton.setObjectName("jumpButton")
self.horizontalLayout_2.addWidget(self.jumpButton)
self.previousButton = QtWidgets.QPushButton(Form)
self.previousButton.setObjectName("previousButton")
self.horizontalLayout_2.addWidget(self.previousButton)
self.nextButton = QtWidgets.QPushButton(Form)
self.nextButton.setObjectName("nextButton")
self.horizontalLayout_2.addWidget(self.nextButton)
self.horizontalLayout_4.addLayout(self.horizontalLayout_2)
spacerItem2 = QtWidgets.QSpacerItem(40, 20,
QtWidgets.QSizePolicy.Expanding,
QtWidgets.QSizePolicy.Minimum)
self.horizontalLayout_4.addItem(spacerItem2)
self.verticalLayout.addLayout(self.horizontalLayout_4)
self.retranslateUi(Form)
self.bindButton()
QtCore.QMetaObject.connectSlotsByName(Form)