python pyqt5画面实现

# -*- coding: utf-8 -*-

# Form implementation generated from reading ui file 'e:\NDC借調処理\python\src\StyleLayout.ui'

#

# Created by: PyQt5 UI code generator 5.13.0

#

# WARNING! All changes made in this file will be lost!

import sys

import os

import images_rc

import xlrd

import win32com.client

import time

from PyQt5 import QtCore, QtGui, QtWidgets

from PyQt5.QtCore import *

from PyQt5.QtGui import *

from PyQt5.QtWidgets import *

from CalculateSalary import CalculateSalary

class Ui_Management(object):

    def setupUi(self, Management):

        icon = QtGui.QIcon()

        icon.addPixmap(QtGui.QPixmap(":/img/logo.jpg"), QtGui.QIcon.Normal, QtGui.QIcon.Off)

        Management.setObjectName("Management")

        Management.resize(579, 593)

        Management.setStyleSheet("background-image: url(:/img/img.jpg);")

        Management.setWindowIcon(icon)

        # 窗口垂直设计，画面控件随窗口变化而变化（自适应）

        self.verticalLayout_3 = QtWidgets.QVBoxLayout(Management)

        self.verticalLayout_3.setObjectName("verticalLayout_3")

        # 文件处理层

        self.groupBox1 = QtWidgets.QGroupBox(Management)

        font = QtGui.QFont()

        font.setPointSize(16)

        font.setBold(True)

        font.setItalic(True)

        font.setWeight(75)

        self.groupBox1.setFont(font)

        self.groupBox1.setStyleSheet("color: rgb(85, 170, 255);")

        self.groupBox1.setObjectName("groupBox1")

        self.verticalLayout = QtWidgets.QVBoxLayout(self.groupBox1)

        self.verticalLayout.setContentsMargins(-1, -1, -1, 9)

        self.verticalLayout.setSpacing(6)

        self.verticalLayout.setObjectName("verticalLayout")

        self.horizontalLayout_3 = QtWidgets.QHBoxLayout()

        self.horizontalLayout_3.setObjectName("horizontalLayout_3")

        # 选择目标文件路径

        self.folderSourceLabel = QtWidgets.QLabel(self.groupBox1)

        font = QtGui.QFont()

        font.setPointSize(12)

        self.folderSourceLabel.setFont(font)

        self.folderSourceLabel.setStyleSheet("color: rgb(0, 0, 0);")

        self.folderSourceLabel.setObjectName("folderSourceLabel")

        self.horizontalLayout_3.addWidget(self.folderSourceLabel)

        # 在文本框显示文件夹路径内容

        self.pathEdit = QtWidgets.QLineEdit(self.groupBox1)

        font = QtGui.QFont()

        font.setPointSize(12)

        self.pathEdit.setFont(font)

        self.pathEdit.setStyleSheet("background-color: rgb(255, 255, 255);""color: rgb(0, 0, 0);")

        self.pathEdit.setObjectName("pathEdit")

        self.horizontalLayout_3.addWidget(self.pathEdit)

        # 浏览按钮

        self.searchButton = QtWidgets.QPushButton(self.groupBox1)

        font = QtGui.QFont()

        font.setPointSize(12)

        self.searchButton.setFont(font)

        self.searchButton.setStyleSheet("color: rgb(200, 97, 84);")

        self.searchButton.setCheckable(False)

        self.searchButton.setAutoRepeat(False)

        self.searchButton.setAutoExclusive(False)

        self.searchButton.setFlat(False)

        self.searchButton.setObjectName("searchButton")

        self.horizontalLayout_3.addWidget(self.searchButton)

        self.horizontalLayout_3.setStretch(0, 1)

        self.horizontalLayout_3.setStretch(1, 5)

        self.horizontalLayout_3.setStretch(2, 1)

        self.verticalLayout.addLayout(self.horizontalLayout_3)

        self.horizontalLayout_2 = QtWidgets.QHBoxLayout()

        self.horizontalLayout_2.setObjectName("horizontalLayout_2")

        # 按下浏览按钮

        self.searchButton.clicked.connect(self.searchButtonClick)

        # 选择年月label

        self.selectYearMonthLabel = QtWidgets.QLabel(self.groupBox1)

        font = QtGui.QFont()

        font.setPointSize(12)

        self.selectYearMonthLabel.setFont(font)

        self.selectYearMonthLabel.setStyleSheet("color: rgb(0, 0, 0);")

        self.selectYearMonthLabel.setObjectName("selectYearMonthLabel")

        self.horizontalLayout_2.addWidget(self.selectYearMonthLabel)

        # 显示日期edit

        self.yearMonthEdit = QtWidgets.QDateEdit(self.groupBox1)

        font = QtGui.QFont()

        font.setPointSize(12)

        self.yearMonthEdit.setFont(font)

        self.yearMonthEdit.setStyleSheet("color: rgb(0, 0, 0);")

        self.yearMonthEdit.setCalendarPopup(True)

        self.yearMonthEdit.setObjectName("yearMonthEdit")

        self.yearMonthEdit.setDateTime(QDateTime.currentDateTime())

        self.horizontalLayout_2.addWidget(self.yearMonthEdit)

        self.horizontalLayout_2.setStretch(0, 1)

        self.horizontalLayout_2.setStretch(1, 6)

        self.verticalLayout.addLayout(self.horizontalLayout_2)

        self.horizontalLayout = QtWidgets.QHBoxLayout()

        self.horizontalLayout.setObjectName("horizontalLayout")

        # 处理类别label

        self.dealWithKindLabel = QtWidgets.QLabel(self.groupBox1)

        font = QtGui.QFont()

        font.setPointSize(12)

        self.dealWithKindLabel.setFont(font)

        self.dealWithKindLabel.setStyleSheet("color: rgb(0, 0, 0);")

        self.dealWithKindLabel.setObjectName("dealWithKindLabel")

        self.horizontalLayout.addWidget(self.dealWithKindLabel)

        # 施策费前CheckBox

        self.shiCeBefore = QtWidgets.QCheckBox(self.groupBox1)

        font = QtGui.QFont()

        font.setPointSize(12)

        self.shiCeBefore.setFont(font)

        self.shiCeBefore.setStyleSheet("color: rgb(0, 0, 0);")

        self.shiCeBefore.setObjectName("shiCeBefore")

        self.horizontalLayout.addWidget(self.shiCeBefore)

        # 施策费后CheckBox

        self.shiCeLater = QtWidgets.QCheckBox(self.groupBox1)

        font = QtGui.QFont()

        font.setPointSize(12)

        self.shiCeLater.setFont(font)

        self.shiCeLater.setStyleSheet("color: rgb(0, 0, 0);")

        self.shiCeLater.setObjectName("shiCeLater")

        self.horizontalLayout.addWidget(self.shiCeLater)

        # 其它情况CheckBox

        self.other = QtWidgets.QCheckBox(self.groupBox1)

        font = QtGui.QFont()

        font.setPointSize(12)

        self.other.setFont(font)

        self.other.setStyleSheet("color: rgb(0, 0, 0);")

        self.other.setObjectName("other")

        self.horizontalLayout.addWidget(self.other)

        self.horizontalLayout.setStretch(0, 1)

        self.horizontalLayout.setStretch(1, 2)

        self.horizontalLayout.setStretch(2, 2)

        self.horizontalLayout.setStretch(3, 2)

        self.verticalLayout.addLayout(self.horizontalLayout)

        # 开始处理按钮

        self.startButton = QtWidgets.QPushButton(self.groupBox1)

        font = QtGui.QFont()

        font.setPointSize(12)

        self.startButton.setFont(font)

        # "background-color: rgb(67, 211, 255);\n""border:3px solid #5f92b2;\n""border-radius:5px;\n"

        self.startButton.setStyleSheet("color: rgb(200, 97, 84);")

        self.startButton.setCheckable(False)

        self.startButton.setAutoRepeat(False)

        self.startButton.setAutoExclusive(False)

        self.startButton.setFlat(False)

        self.startButton.setObjectName("startButton")

        self.verticalLayout.addWidget(self.startButton)

        self.verticalLayout_3.addWidget(self.groupBox1)

        # 按下开始处理按钮

        self.startButton.clicked.connect(self.startButtonClick)

        # 处理结果层

        self.groupBox2 = QtWidgets.QGroupBox(Management)

        font = QtGui.QFont()

        font.setPointSize(16)

        font.setBold(True)

        font.setItalic(True)

        font.setUnderline(False)

        font.setWeight(75)

        font.setStrikeOut(False)

        self.groupBox2.setFont(font)

        self.groupBox2.setStyleSheet("color: rgb(85, 170, 255);")

        self.groupBox2.setObjectName("groupBox2")

        self.verticalLayout_2 = QtWidgets.QVBoxLayout(self.groupBox2)

        self.verticalLayout_2.setObjectName("verticalLayout_2")

        # 显示具体处理后的详细信息tablewidget

        self.resultMessage = QtWidgets.QTableWidget(self.groupBox2)

        font = QtGui.QFont()

        font.setPointSize(12)

        font.setBold(False)

        font.setItalic(False)

        font.setWeight(50)

        self.resultMessage.setFont(font)

        self.resultMessage.setTabletTracking(False)

        self.resultMessage.setAcceptDrops(False)

        self.resultMessage.setToolTip("")

        self.resultMessage.setStatusTip("")

        self.resultMessage.setAutoFillBackground(False)

        self.resultMessage.setStyleSheet("color: rgb(112, 189, 255);")

        self.resultMessage.setInputMethodHints(QtCore.Qt.ImhNone)

        self.resultMessage.setLineWidth(1)

        self.resultMessage.setAutoScroll(True)

        self.resultMessage.setProperty("showDropIndicator", True)

        self.resultMessage.setDragEnabled(False)

        self.resultMessage.setAlternatingRowColors(True)

        self.resultMessage.setShowGrid(True)

        self.resultMessage.setWordWrap(True)

        self.resultMessage.setCornerButtonEnabled(True)

        self.resultMessage.setRowCount(2)

        self.resultMessage.setColumnCount(2)

        self.resultMessage.setObjectName("resultMessage")

        self.resultMessage.horizontalHeader().setVisible(True)

        self.resultMessage.horizontalHeader().setCascadingSectionResizes(False)

        self.resultMessage.horizontalHeader().setDefaultSectionSize(100)

        self.resultMessage.horizontalHeader().setHighlightSections(True)

        self.resultMessage.horizontalHeader().setMinimumSectionSize(34)

        self.resultMessage.horizontalHeader().setSortIndicatorShown(False)

        self.resultMessage.horizontalHeader().setStretchLastSection(True)

        self.resultMessage.verticalHeader().setVisible(True)

        self.resultMessage.verticalHeader().setCascadingSectionResizes(False)

        self.resultMessage.verticalHeader().setDefaultSectionSize(30)

        self.resultMessage.verticalHeader().setHighlightSections(False)

        self.resultMessage.verticalHeader().setSortIndicatorShown(False)

        self.resultMessage.verticalHeader().setStretchLastSection(False)

        # 不可编辑

        self.resultMessage.setEditTriggers(QTableView.NoEditTriggers)

        self.verticalLayout_2.addWidget(self.resultMessage)

        self.verticalLayout_3.addWidget(self.groupBox2)

        # 开始处理加载label

        self.label = QtWidgets.QLabel(Management)

        # self.label.setScaledContents(True)

        self.label.setGeometry(QtCore.QRect(250,150,40,40))

        self.label.setObjectName("label")

        self.label.hide()

        self.retranslateUi(Management)

        QtCore.QMetaObject.connectSlotsByName(Management)

    def retranslateUi(self, Management):

        _translate = QtCore.QCoreApplication.translate

        Management.setWindowTitle(_translate("Management", "NCIT人事管理工具"))

        self.groupBox1.setTitle(_translate("Management", "文件处理"))

        self.folderSourceLabel.setText(_translate("Management", "请选择目标路径"))

        self.searchButton.setText(_translate("Management", "浏览"))

        self.selectYearMonthLabel.setText(_translate("Management", "请选择年月"))

        self.yearMonthEdit.setDisplayFormat(_translate("Management", "yyyy/MM"))

        self.dealWithKindLabel.setText(_translate("Management", "处理类别"))

        self.shiCeBefore.setText(_translate("Management", "施策费前"))

        self.shiCeLater.setText(_translate("Management", "施策费后"))

        self.other.setText(_translate("Management", "其它"))

        self.startButton.setText(_translate("Management", "开始处理"))

        self.groupBox2.setTitle(_translate("Management", "处理结果"))

        self.resultMessage.setSortingEnabled(False)

        # self.frame1 = QFrame(self)

        # self.verticalLayout = QVBoxLayout(self.frame1)

        # self.pushButton_quit = QPushButton()

        # self.pushButton_quit.setText("回到主页面")

        # self.verticalLayout.addWidget(self.pushButton_quit)

        # self.frame1.setVisible(False)

        # self.startButton.clicked.connect(self.on_pushButton_enter_clicked)

        # self.pushButton_quit.clicked.connect(self.on_pushButton_enter_clicked_1)

        # self.tipwin  = None

    # 按下浏览按钮事件

    def searchButtonClick(self):

        folderPath = QFileDialog.getExistingDirectory(None, "选择文件夹路径", "C:\\")

        self.pathEdit.setText(folderPath)

    # 处理文件按钮事件

    def startButtonClick(self):

        # 获取时间并转换成string型

        dateTime = self.yearMonthEdit.date().toString(Qt.ISODate)

        # 获取路经并转换成string型

        pathString = self.pathEdit.displayText()

        # checkbox的选择状态，并转换成bool(布尔)型

        # 施策费前

        checkFlg_Before = bool(self.shiCeBefore.checkState())

        # 施策费后

        checkFlg_Later = bool(self.shiCeLater.checkState())

        # 其它

        checkFlg_other = bool(self.other.checkState())

        self.label.show()

        self.gif = QMovie(":/img/down2.gif")

        # self.label.setScaledContents(True)

        self.label.setMovie(self.gif)

        self.label.setStyleSheet("background-color:white;")

        self.gif.start()

        # 创建文件处理(计算薪资)实例化

        makeSalary = CalculateSalary(pathString,dateTime)

        # 为用户提供处理过程中的提示信息

        # splash = QtWidgets.QSplashScreen(QtGui.QPixmap(":/img/downloadprocess.png"))

        if(checkFlg_Before == True and checkFlg_Later == False and checkFlg_other== False):

            # 为用户提供处理过程中的提示信息并显示

            # splash.show()

            # splash.showMessage("文件正在处理中...", QtCore.Qt.AlignLeft | QtCore.Qt.AlignBottom, QtCore.Qt.white)

            # time.sleep(5)

            # 调用计算薪资类的makeSalaryInfo()方法

            makeSalary.makeSalaryInfo()

            # 处理结束信息提示

            # QtWidgets.QMessageBox.information(None, "提示", "文件处理成功")

            QtWidgets.QMessageBox.information(None, "提示", makeSalary.result_message)

            # 横向标题排列，如果使用setVerticalHeaderLabels则是纵向排列标题

            self.resultMessage.setHorizontalHeaderLabels(['文件名','操作']) 

            x = r"E:\NDC借調処理\10月\01_input\BJ_工资分配201910_借调.xlsx"

            y = r"D:\备份\Book2.xlsx"

            # items=[[x, ""], [y, ""]]

            items=[[x, ""]]

            items.append([y, ""])

            # 注意上面列表中数字加单引号，否则下面不显示(或者下面str方法转化一下即可)

            for i in range(len(items)):

                item=items[i]

                for j in range(len(item)):

                    # 添加按钮

                    if  j!=1:

                        item = QTableWidgetItem(str(items[i][j]))

                        self.resultMessage.setItem(i, j, item)

                    #最后一列添加控件

                    else: 

                        btn = QPushButton("查看文件")

                        btn.setDown(True)

                        # btn.setStyleSheet("QPushButton{margin:3px};")

                        btn.setStyleSheet("border:3px solid #5f92b2;""color: rgb(200, 97, 84);")

                        self.resultMessage.setCellWidget(i, j, btn)

                        btn.clicked.connect(self.showFileContentBtnClick)

            # QTableWidget读取数据写死

            # self.model = QStandardItemModel()

            # self.model.setHorizontalHeaderLabels(["文件名","操作"])

            # for row in range(100):

            #     for column in range(2):

            #         item = QStandardItem("row %s ,column %s"%(row, column))

            #         self.model.setItem(row, column, item)

            # self.DetailContent.setModel(self.model)

        elif(checkFlg_Later == True and checkFlg_Before == False and checkFlg_other == False ):

            QtWidgets.QMessageBox.information(None, "提示", "施策费后" + makeSalary.result_message)

        elif(checkFlg_other == True and checkFlg_Before == False and checkFlg_Later == False):

            QtWidgets.QMessageBox.information(None, "提示", "其它情况" + makeSalary.result_message)

        elif((checkFlg_Before == True and checkFlg_Later == True) or 

        (checkFlg_Before == True and checkFlg_other == True) or 

        (checkFlg_Later == True and checkFlg_other == True) or 

        (checkFlg_Before == True and checkFlg_Later == True and checkFlg_other == True)):

            QtWidgets.QMessageBox.information(None, "提示", "全选")

        else:

            QtWidgets.QMessageBox.warning(None, "警告", "请选择处理类别")

        self.label.hide()

    # 打开文件，查看文件内容

    def showFileContentBtnClick(self):

        # filename = QFileDialog.getOpenFileName(None, "open", r"D:\备份\Book2.xlsx")

        # print (filename[0])

        # os.startfile(filename[0])

        try:

            # 打开没有密码的excel文件

            path = r"D:\备份\Book2.xlsx"

            os.startfile(path)

        except:

            # 打开带有密码的Excel文件

            xlApp = win32com.client.Dispatch("Excel.Application")

            path = r"E:\NDC借調処理\10月\01_input\BJ_工资分配201910_借调.xlsx"

            password = "FP201910"

            xlwb = xlApp.Workbooks.Open(path, 2, True, None, None, password)

            xlwb = xlApp.Workbooks.Open(path)

if __name__ == "__main__":

    app = QtWidgets.QApplication(sys.argv)

    widget = QtWidgets.QWidget()

    ui = Ui_Management()

    ui.setupUi(widget)

    widget.show()

    sys.exit(app.exec_())