devbox
不正经
这个屌丝很懒，什么也没留下！
关注作者
热门标签
热门文章
当前位置:   article > 正文

项目进度管理系统----Python下Pyside2模块（大一课设）_pip install pyside2

作者：不正经 | 2024-04-06 10:05:08

赞

踩

pip install pyside2

目录

一、安装Pycharm和Anaconda（这里我用的是Pycharm，Vscode也一样适用）

二、在相应的conda环境中下载Pyside2模块

三、在编译器中添加对应的Pyside2外部工具 

四、项目进度管理系统介绍

五、制作过程  

六、主体代码

一、安装Pycharm和Anaconda              

如何搭建Python开发环境_netexsy的博客-CSDN博客

二、在相应的conda环境中下载Pyside2模块

1）先切换到对应的虚拟环境      

“Win+R”打开cmd命令行

输入“conda activate  环境名” 切换环境

2）下载PySide2模块

pip install pyside2 -i https://pypi.douban.com/simple

三、在编译器中添加对应的Pyside2外部工具

1）打开 PyCharm--->文件--->设置--->工具--->外部工具

2）添加外部工具（Program需要使用个人电脑下的模块中的exe文件，复制自己的路径即可，Working Directory和Arguments直接照抄就行）

  1. New QtForm(命名)
  2.     1）Program - D:\Develop\Python\Anaconda3\envs\Qt\Scripts\pyside2-designer.exe  （找到自己电脑目录下的pyside2-designer.exe，此处为示例）
  3.     2）Working Directory - $FileDir$
  1. Edit QtForm(命名)
  2.     1）Program - D:\Develop\Python\Anaconda3\envs\Qt\Scripts\pyside2-designer.exe   （找到自己电脑下的pyside2-designer.exe，此处为示例）
  3.     2）Arguments - $FileDir$\$FileName$
  4.     3）Working Directory - $FileDir$
  1. PyUIC(命名)
  2.     1）Program - D:\Develop\Python\Anaconda3\envs\Qt\Scripts\pyside2-uic.exe    （找到自己电脑下的pyside2-uic.exe ，此处为示例）
  3.     2）Arguments - $FileName$ -o ui_$FileNameWithoutExtension$.py
  4.     3）Working Directory - $FileDir$

四、项目进度管理系统介绍

设计项目进度管理系统界面（个人自主设计）

1）管理员登录/用户登录

2）管理员登录界面

3）用户登录界面

4）管理员选择模块界面

5）管理员主界面----项目管理

 

 6）管理员主界面----用户管理

7）添加界面----项目管理

8） 修改界面----项目管理

9） 搜索界面----项目管理

 10）导入界面----项目管理/用户界面

11） 导出界面----项目管理/用户界面

12）添加界面----用户管理

13）添加界面----用户管理

 

14）搜索界面----用户管理

 6.数据库的使用（MySql）

推荐使用SQLiteStudio或Navicat。  

7.表的使用

表1：my_All_Project表（项目表）

序号

字段名

类型

长度

默认值

说明

1

Id

Varchar

10

NULL

2

Type

Varchar

20

NULL

3

Name

Varchar

50

NULL

4

Start_date

date

1

NULL

5

End_date

date

1

NULL

6

Progress

int

1

NULL 

7

Manager

Varchar

20

NULL

8

Level

char(1)

1

NULL

9

Remark

Varchar

100

NULL

                                     

表2 user表（用户表）

序号

字段名

类型

长度

默认值

说明

1

user_type

Varchar

20

NULL

2

username

Varchar

40

NULL

3

password

Varchar

100

NULL

4

login_times

int

1

NULL

5

last_login

date

Timestamp

NULL

 五、制作过程

1.打开PyCharm，新建一个项目。（注意环境要使用安装了PySide2模块的环境，不然会报错！）

2.在项目中新建一个目录，取名为“ui”（名字自己取）--->鼠标移到目录上--->鼠标右键点击目录--->External Tools--->New QtForm

3. 弹出一个程序“Qt Designer”（第一次可能要等10秒钟，后面就不用了。）

 4.刚开始做窗体界面使用“Main Window”就可以了，子窗体比较推荐用Dialog，我们可以利用Qt Designer设计系统的各种界面。

基础设计教程请看：

利用PySide2模块以及Qt设计师（Qt-Designer）设计简易的系统窗体_netexsy的博客-CSDN博客

利用Qt设计师可以很快设计出上述界面，但是要注意的是，单独一个界面中的每个部件都要取号名字，不能重复，不然写python代码时会有冲突！

5.设计完界面后保存取名字退出并编译（每个界面名字也要不一样，要能够记住！）

右键点击ui文件，选择“External Tool”里面的“pyuic”工具，这个工具能够将我们刚刚设计好的图形化界面转化为后缀为.py的python代码，方便我们调用。（ui文件不能被编译器识别，但是转换成python代码后就可以了！）

下面会有对应的.py文件自动生成，下面的.py文件才能被我们调用。

6.在ui目录以外的地方新建一个.py文件（不能和那些ui文件在一个目录下面，不然可能会报错）

设计了几个界面就要新建几个.py文件，这个.py文件是我们自己新建的，和pyuic工具生成的.py文件不是一个东西。

接下来我们进入最重要的代码部分

六、主体代码

 1）管理员登录/用户登录

ui_untitled_login_select.py(这个是图示界面ui文件通过pyuic转换而来的.py文件)

  1. # -*- coding: utf-8 -*-
  2.  
  3. ################################################################################
  4. ## Form generated from reading UI file 'untitled_login_select.ui'
  5. ##
  6. ## Created by: Qt User Interface Compiler version 5.15.2
  7. ##
  8. ## WARNING! All changes made in this file will be lost when recompiling UI file!
  9. ################################################################################
  10.  
  11. from PySide2.QtCore import *
  12. from PySide2.QtGui import *
  13. from PySide2.QtWidgets import *
  14.  
  15. import picture_rc
  16.  
  17. class Ui_MainWindow(object):
  18.     def setupUi(self, MainWindow):
  19.         if not MainWindow.objectName():
  20.             MainWindow.setObjectName(u"MainWindow")
  21.         MainWindow.resize(800, 600)
  22.         icon = QIcon()
  23.         icon.addFile(u"../\u9009\u62e9.ico", QSize(), QIcon.Normal, QIcon.Off)
  24.         MainWindow.setWindowIcon(icon)
  25.         self.actionTlbExit = QAction(MainWindow)
  26.         self.actionTlbExit.setObjectName(u"actionTlbExit")
  27.         self.centralwidget = QWidget(MainWindow)
  28.         self.centralwidget.setObjectName(u"centralwidget")
  29.         self.layoutWidget = QWidget(self.centralwidget)
  30.         self.layoutWidget.setObjectName(u"layoutWidget")
  31.         self.layoutWidget.setGeometry(QRect(-1, 30, 801, 391))
  32.         self.verticalLayout = QVBoxLayout(self.layoutWidget)
  33.         self.verticalLayout.setObjectName(u"verticalLayout")
  34.         self.verticalLayout.setContentsMargins(0, 0, 0, 0)
  35.         self.horizontalLayout = QHBoxLayout()
  36.         self.horizontalLayout.setObjectName(u"horizontalLayout")
  37.         self.horizontalSpacer = QSpacerItem(40, 20, QSizePolicy.Expanding, QSizePolicy.Minimum)
  38.  
  39.         self.horizontalLayout.addItem(self.horizontalSpacer)
  40.  
  41.         self.label = QLabel(self.layoutWidget)
  42.         self.label.setObjectName(u"label")
  43.         font = QFont()
  44.         font.setFamily(u"Agency FB")
  45.         font.setPointSize(36)
  46.         self.label.setFont(font)
  47.  
  48.         self.horizontalLayout.addWidget(self.label)
  49.  
  50.         self.horizontalSpacer_2 = QSpacerItem(40, 20, QSizePolicy.Expanding, QSizePolicy.Minimum)
  51.  
  52.         self.horizontalLayout.addItem(self.horizontalSpacer_2)
  53.  
  54.  
  55.         self.verticalLayout.addLayout(self.horizontalLayout)
  56.  
  57.         self.verticalSpacer = QSpacerItem(20, 40, QSizePolicy.Minimum, QSizePolicy.Expanding)
  58.  
  59.         self.verticalLayout.addItem(self.verticalSpacer)
  60.  
  61.         self.verticalSpacer_2 = QSpacerItem(20, 40, QSizePolicy.Minimum, QSizePolicy.Expanding)
  62.  
  63.         self.verticalLayout.addItem(self.verticalSpacer_2)
  64.  
  65.         self.horizontalLayout_2 = QHBoxLayout()
  66.         self.horizontalLayout_2.setObjectName(u"horizontalLayout_2")
  67.         self.horizontalSpacer_4 = QSpacerItem(40, 20, QSizePolicy.Expanding, QSizePolicy.Minimum)
  68.  
  69.         self.horizontalLayout_2.addItem(self.horizontalSpacer_4)
  70.  
  71.         self.pButtonadministrator = QPushButton(self.layoutWidget)
  72.         self.pButtonadministrator.setObjectName(u"pButtonadministrator")
  73.         font1 = QFont()
  74.         font1.setFamily(u"Agency FB")
  75.         font1.setPointSize(24)
  76.         self.pButtonadministrator.setFont(font1)
  77.  
  78.         self.horizontalLayout_2.addWidget(self.pButtonadministrator)
  79.  
  80.         self.horizontalSpacer_3 = QSpacerItem(40, 20, QSizePolicy.Expanding, QSizePolicy.Minimum)
  81.  
  82.         self.horizontalLayout_2.addItem(self.horizontalSpacer_3)
  83.  
  84.         self.pButtonuser = QPushButton(self.layoutWidget)
  85.         self.pButtonuser.setObjectName(u"pButtonuser")
  86.         font2 = QFont()
  87.         font2.setFamily(u"Agency FB")
  88.         font2.setPointSize(26)
  89.         self.pButtonuser.setFont(font2)
  90.  
  91.         self.horizontalLayout_2.addWidget(self.pButtonuser)
  92.  
  93.         self.horizontalSpacer_5 = QSpacerItem(40, 20, QSizePolicy.Expanding, QSizePolicy.Minimum)
  94.  
  95.         self.horizontalLayout_2.addItem(self.horizontalSpacer_5)
  96.  
  97.  
  98.         self.verticalLayout.addLayout(self.horizontalLayout_2)
  99.  
  100.         self.label_3 = QLabel(self.centralwidget)
  101.         self.label_3.setObjectName(u"label_3")
  102.         self.label_3.setGeometry(QRect(0, -6, 801, 531))
  103.         self.label_3.setPixmap(QPixmap(u":/\u80cc\u666f\u56fe1.png"))
  104.         self.label_3.setScaledContents(True)
  105.         MainWindow.setCentralWidget(self.centralwidget)
  106.         self.label_3.raise_()
  107.         self.layoutWidget.raise_()
  108.         self.menubar = QMenuBar(MainWindow)
  109.         self.menubar.setObjectName(u"menubar")
  110.         self.menubar.setGeometry(QRect(0, 0, 800, 26))
  111.         MainWindow.setMenuBar(self.menubar)
  112.         self.statusbar = QStatusBar(MainWindow)
  113.         self.statusbar.setObjectName(u"statusbar")
  114.         MainWindow.setStatusBar(self.statusbar)
  115.         self.toolBar = QToolBar(MainWindow)
  116.         self.toolBar.setObjectName(u"toolBar")
  117.         MainWindow.addToolBar(Qt.TopToolBarArea, self.toolBar)
  118.  
  119.         self.toolBar.addAction(self.actionTlbExit)
  120.  
  121.         self.retranslateUi(MainWindow)
  122.  
  123.         QMetaObject.connectSlotsByName(MainWindow)
  124.     # setupUi
  125.  
  126.     def retranslateUi(self, MainWindow):
  127.         MainWindow.setWindowTitle(QCoreApplication.translate("MainWindow", u"\u767b\u5f55\u754c\u9762", None))
  128.         self.actionTlbExit.setText(QCoreApplication.translate("MainWindow", u"\u9000\u51fa\u7cfb\u7edf", None))
  129.         self.label.setText(QCoreApplication.translate("MainWindow", u"\u9879\u76ee\u8fdb\u5ea6\u7ba1\u7406\u7cfb\u7edf", None))
  130.         self.pButtonadministrator.setText(QCoreApplication.translate("MainWindow", u"\u7ba1\u7406\u5458\u767b\u5f55", None))
  131.         self.pButtonuser.setText(QCoreApplication.translate("MainWindow", u"\u7528\u6237\u767b\u5f55", None))
  132.         self.label_3.setText("")
  133.         self.toolBar.setWindowTitle(QCoreApplication.translate("MainWindow", u"toolBar", None))
  134.     # retranslateUi
  135.

dljm.py（这个是我们在ui文件之外的目录新建的.py文件）

  1. from PySide2.QtWidgets import *
  2. from PySide2.QtCore import *
  3. from ui.ui_untitled_login_select import Ui_MainWindow
  4. from gly_login import GlyWindow as Gly
  5. from yh_login import YhWindow as Yh
  6. import os, sys
  7. from PySide2.QtGui import Qt, QIcon # 图标、窗体设置
  8.  
  9.  
  10.  
  11. class LoginWindow(QMainWindow, Ui_MainWindow):
  12.     mainSingnal = Signal(str, dict)
  13.     # 初始化窗体
  14.     def __init__(self):
  15.         # 初始化基类
  16.         super(LoginWindow, self).__init__()
  17.         # 初始化当前窗体及窗体中的所有控件
  18.         self.setupUi(self)
  19.         # 记录当前应用所在路径
  20.         self.cur_dir = os.path.dirname(os.path.abspath(__file__))
  21.  
  22.         # 设置窗体图标
  23.         app_icon = QIcon('选择.ico')
  24.         self.setWindowIcon(app_icon)
  25.  
  26.         # 绑定信号与槽，实现按纽单击调用对应的槽函数(选择登录)
  27.         # 声明子窗体(一个管理员登录，一个普通用户登录)
  28.         self.gly_dl = None
  29.         self.yh_dl = None
  30.         self.pButtonadministrator.clicked.connect(lambda: self.gly())
  31.         self.pButtonuser.clicked.connect(lambda: self.yh())
  32.  
  33.         # 绑定菜单栏(左上角的'退出系统'按钮）
  34.         self.actionTlbExit.triggered.connect(lambda: self.Close())
  35.  
  36.  
  37.     def gly(self):
  38.         # 记录当前动作
  39.         self.stuAction = 'gly_dl'
  40.         # 创建子窗体
  41.         self.gly_dl = Gly()
  42.         # 设置该子窗体的对话框状态为“模态对话框”
  43.         self.gly_dl.setModal(True)
  44.         # 显示子窗体
  45.         self.gly_dl.show()
  46.         # # 信号与槽绑定
  47.         # # 主窗体向子窗体发送数据（不能使用Lambda表达式，仅为窗体名.函数名）
  48.         # self.mainSingnal.connect(self.gly_dl.handle_main_signal)
  49.         # # 主窗体发射信号给子窗体
  50.         # self.mainSignal.emit(self.stuAction)
  51.  
  52.     def yh(self):
  53.         # 记录当前动作
  54.         self.stuAction = 'yh_dl'
  55.         # 创建子窗体()
  56.         self.yh_dl = Yh()
  57.         # 设置该子窗体的对话框状态为“模态对话框”
  58.         self.yh_dl.setModal(True)
  59.         # 显示子窗体
  60.         self.yh_dl.show()
  61.         # # 信号与槽绑定
  62.         # # 主窗体向子窗体发送数据（不能使用Lambda表达式，仅为窗体名.函数名）
  63.         # self.mainSingnal.connect(self.yh_dl.handle_main_signal)
  64.         # # 主窗体发射信号给子窗体
  65.         # self.mainSignal.emit(self.stuAction, None)
  66.  
  67.     def Close(self):
  68.         reply = QMessageBox.question(self, '关闭提示', "是否要退出系统?",
  69.                                      QMessageBox.Yes | QMessageBox.No, QMessageBox.No)
  70.         if reply == QMessageBox.Yes:
  71.             self.close()
  72.         elif reply == QMessageBox.No:
  73.             return
  74.  
  75. if __name__ == '__main__':
  76.     app = QApplication(sys.argv)
  77.     win_main = LoginWindow()
  78.     win_main.show()
  79.     sys.exit(app.exec_())
  80.

2）管理员登录界面

ui_untitled_gly_dl.py
  1. # -*- coding: utf-8 -*-
  2.  
  3. ################################################################################
  4. ## Form generated from reading UI file 'untitled_gly_dl.ui'
  5. ##
  6. ## Created by: Qt User Interface Compiler version 5.15.2
  7. ##
  8. ## WARNING! All changes made in this file will be lost when recompiling UI file!
  9. ################################################################################
  10.  
  11. from PySide2.QtCore import *
  12. from PySide2.QtGui import *
  13. from PySide2.QtWidgets import *
  14.  
  15. import picture_rc
  16.  
  17. class Ui_Dialog(object):
  18.     def setupUi(self, Dialog):
  19.         if not Dialog.objectName():
  20.             Dialog.setObjectName(u"Dialog")
  21.         Dialog.resize(814, 461)
  22.         self.layoutWidget = QWidget(Dialog)
  23.         self.layoutWidget.setObjectName(u"layoutWidget")
  24.         self.layoutWidget.setGeometry(QRect(0, 120, 811, 54))
  25.         self.horizontalLayout_5 = QHBoxLayout(self.layoutWidget)
  26.         self.horizontalLayout_5.setObjectName(u"horizontalLayout_5")
  27.         self.horizontalLayout_5.setContentsMargins(0, 0, 0, 0)
  28.         self.horizontalSpacer_8 = QSpacerItem(40, 20, QSizePolicy.Expanding, QSizePolicy.Minimum)
  29.  
  30.         self.horizontalLayout_5.addItem(self.horizontalSpacer_8)
  31.  
  32.         self.label_Login = QLabel(self.layoutWidget)
  33.         self.label_Login.setObjectName(u"label_Login")
  34.         font = QFont()
  35.         font.setFamily(u"Arial Black")
  36.         font.setPointSize(22)
  37.         font.setBold(True)
  38.         font.setWeight(75)
  39.         self.label_Login.setFont(font)
  40.  
  41.         self.horizontalLayout_5.addWidget(self.label_Login)
  42.  
  43.         self.horizontalSpacer_9 = QSpacerItem(40, 20, QSizePolicy.Expanding, QSizePolicy.Minimum)
  44.  
  45.         self.horizontalLayout_5.addItem(self.horizontalSpacer_9)
  46.  
  47.         self.layoutWidget_2 = QWidget(Dialog)
  48.         self.layoutWidget_2.setObjectName(u"layoutWidget_2")
  49.         self.layoutWidget_2.setGeometry(QRect(0, 420, 811, 33))
  50.         self.horizontalLayout = QHBoxLayout(self.layoutWidget_2)
  51.         self.horizontalLayout.setObjectName(u"horizontalLayout")
  52.         self.horizontalLayout.setContentsMargins(0, 0, 0, 0)
  53.         self.horizontalSpacer = QSpacerItem(40, 20, QSizePolicy.Expanding, QSizePolicy.Minimum)
  54.  
  55.         self.horizontalLayout.addItem(self.horizontalSpacer)
  56.  
  57.         self.pButtonOk = QPushButton(self.layoutWidget_2)
  58.         self.pButtonOk.setObjectName(u"pButtonOk")
  59.         font1 = QFont()
  60.         font1.setFamily(u"Agency FB")
  61.         font1.setPointSize(10)
  62.         self.pButtonOk.setFont(font1)
  63.  
  64.         self.horizontalLayout.addWidget(self.pButtonOk)
  65.  
  66.         self.horizontalSpacer_2 = QSpacerItem(40, 20, QSizePolicy.Expanding, QSizePolicy.Minimum)
  67.  
  68.         self.horizontalLayout.addItem(self.horizontalSpacer_2)
  69.  
  70.         self.pButtonCancel = QPushButton(self.layoutWidget_2)
  71.         self.pButtonCancel.setObjectName(u"pButtonCancel")
  72.         self.pButtonCancel.setFont(font1)
  73.  
  74.         self.horizontalLayout.addWidget(self.pButtonCancel)
  75.  
  76.         self.horizontalSpacer_3 = QSpacerItem(40, 20, QSizePolicy.Expanding, QSizePolicy.Minimum)
  77.  
  78.         self.horizontalLayout.addItem(self.horizontalSpacer_3)
  79.  
  80.         self.layoutWidget_3 = QWidget(Dialog)
  81.         self.layoutWidget_3.setObjectName(u"layoutWidget_3")
  82.         self.layoutWidget_3.setGeometry(QRect(0, 0, 811, 75))
  83.         self.horizontalLayout_4 = QHBoxLayout(self.layoutWidget_3)
  84.         self.horizontalLayout_4.setObjectName(u"horizontalLayout_4")
  85.         self.horizontalLayout_4.setContentsMargins(0, 0, 0, 0)
  86.         self.horizontalSpacer_6 = QSpacerItem(40, 20, QSizePolicy.Expanding, QSizePolicy.Minimum)
  87.  
  88.         self.horizontalLayout_4.addItem(self.horizontalSpacer_6)
  89.  
  90.         self.label = QLabel(self.layoutWidget_3)
  91.         self.label.setObjectName(u"label")
  92.         font2 = QFont()
  93.         font2.setFamily(u"Agency FB")
  94.         font2.setPointSize(36)
  95.         self.label.setFont(font2)
  96.  
  97.         self.horizontalLayout_4.addWidget(self.label)
  98.  
  99.         self.horizontalSpacer_7 = QSpacerItem(40, 20, QSizePolicy.Expanding, QSizePolicy.Minimum)
  100.  
  101.         self.horizontalLayout_4.addItem(self.horizontalSpacer_7)
  102.  
  103.         self.layoutWidget_4 = QWidget(Dialog)
  104.         self.layoutWidget_4.setObjectName(u"layoutWidget_4")
  105.         self.layoutWidget_4.setGeometry(QRect(0, 230, 811, 98))
  106.         self.horizontalLayout_6 = QHBoxLayout(self.layoutWidget_4)
  107.         self.horizontalLayout_6.setObjectName(u"horizontalLayout_6")
  108.         self.horizontalLayout_6.setContentsMargins(0, 0, 0, 0)
  109.         self.horizontalSpacer_10 = QSpacerItem(40, 20, QSizePolicy.Expanding, QSizePolicy.Minimum)
  110.  
  111.         self.horizontalLayout_6.addItem(self.horizontalSpacer_10)
  112.  
  113.         self.verticalLayout = QVBoxLayout()
  114.         self.verticalLayout.setObjectName(u"verticalLayout")
  115.         self.horizontalLayout_2 = QHBoxLayout()
  116.         self.horizontalLayout_2.setObjectName(u"horizontalLayout_2")
  117.         self.label_3 = QLabel(self.layoutWidget_4)
  118.         self.label_3.setObjectName(u"label_3")
  119.         font3 = QFont()
  120.         font3.setFamily(u"Agency FB")
  121.         font3.setPointSize(14)
  122.         self.label_3.setFont(font3)
  123.  
  124.         self.horizontalLayout_2.addWidget(self.label_3)
  125.  
  126.         self.horizontalSpacer_4 = QSpacerItem(40, 20, QSizePolicy.Expanding, QSizePolicy.Minimum)
  127.  
  128.         self.horizontalLayout_2.addItem(self.horizontalSpacer_4)
  129.  
  130.         self.lineEdit_gly_User = QLineEdit(self.layoutWidget_4)
  131.         self.lineEdit_gly_User.setObjectName(u"lineEdit_gly_User")
  132.  
  133.         self.horizontalLayout_2.addWidget(self.lineEdit_gly_User)
  134.  
  135.  
  136.         self.verticalLayout.addLayout(self.horizontalLayout_2)
  137.  
  138.         self.verticalSpacer = QSpacerItem(20, 20, QSizePolicy.Minimum, QSizePolicy.Expanding)
  139.  
  140.         self.verticalLayout.addItem(self.verticalSpacer)
  141.  
  142.         self.horizontalLayout_3 = QHBoxLayout()
  143.         self.horizontalLayout_3.setObjectName(u"horizontalLayout_3")
  144.         self.label_4 = QLabel(self.layoutWidget_4)
  145.         self.label_4.setObjectName(u"label_4")
  146.         self.label_4.setFont(font3)
  147.  
  148.         self.horizontalLayout_3.addWidget(self.label_4)
  149.  
  150.         self.horizontalSpacer_5 = QSpacerItem(40, 20, QSizePolicy.Expanding, QSizePolicy.Minimum)
  151.  
  152.         self.horizontalLayout_3.addItem(self.horizontalSpacer_5)
  153.  
  154.         self.lineEdit_gly_Password = QLineEdit(self.layoutWidget_4)
  155.         self.lineEdit_gly_Password.setObjectName(u"lineEdit_gly_Password")
  156.  
  157.         self.horizontalLayout_3.addWidget(self.lineEdit_gly_Password)
  158.  
  159.  
  160.         self.verticalLayout.addLayout(self.horizontalLayout_3)
  161.  
  162.  
  163.         self.horizontalLayout_6.addLayout(self.verticalLayout)
  164.  
  165.         self.horizontalSpacer_11 = QSpacerItem(40, 20, QSizePolicy.Expanding, QSizePolicy.Minimum)
  166.  
  167.         self.horizontalLayout_6.addItem(self.horizontalSpacer_11)
  168.  
  169.         self.label_5 = QLabel(Dialog)
  170.         self.label_5.setObjectName(u"label_5")
  171.         self.label_5.setGeometry(QRect(1, 4, 811, 461))
  172.         self.label_5.setPixmap(QPixmap(u":/b2.png"))
  173.         self.label_5.setScaledContents(True)
  174.         self.label_5.raise_()
  175.         self.layoutWidget.raise_()
  176.         self.layoutWidget_2.raise_()
  177.         self.layoutWidget_3.raise_()
  178.         self.layoutWidget_4.raise_()
  179.  
  180.         self.retranslateUi(Dialog)
  181.  
  182.         QMetaObject.connectSlotsByName(Dialog)
  183.     # setupUi
  184.  
  185.     def retranslateUi(self, Dialog):
  186.         Dialog.setWindowTitle(QCoreApplication.translate("Dialog", u"\u7ba1\u7406\u5458\u767b\u5f55", None))
  187.         self.label_Login.setText(QCoreApplication.translate("Dialog", u"\u7ba1\u7406\u5458\u767b\u5f55", None))
  188.         self.pButtonOk.setText(QCoreApplication.translate("Dialog", u"\u786e\u5b9a", None))
  189.         self.pButtonCancel.setText(QCoreApplication.translate("Dialog", u"\u53d6\u6d88", None))
  190.         self.label.setText(QCoreApplication.translate("Dialog", u"\u9879\u76ee\u8fdb\u5ea6\u7ba1\u7406\u7cfb\u7edf", None))
  191.         self.label_3.setText(QCoreApplication.translate("Dialog", u"\u7528\u6237\u540d\uff1a", None))
  192.         self.lineEdit_gly_User.setText("")
  193.         self.label_4.setText(QCoreApplication.translate("Dialog", u"\u5bc6\u7801\uff1a", None))
  194.         self.label_5.setText("")
  195.     # retranslateUi
  196.  
gly_login.py
  1. from PySide2.QtWidgets import QApplication, QDialog, QMessageBox
  2. from PySide2.QtCore import Signal # 信号
  3. from PySide2.QtGui import Qt, QIcon # 图标、窗体设置
  4. from PySide2.QtWidgets import QLineEdit, QPushButton
  5. import sqlite3
  6. import sys, os
  7. from ui.ui_untitled_gly_dl import Ui_Dialog
  8. from gly_select import GsWindow
  9.  
  10. class GlyWindow  (QDialog , Ui_Dialog):
  11.     # 定义一个信号，从子窗体向主窗体返回信号
  12.     MainSiganl = Signal(bool)
  13.     # 子窗体初始化、声明信号、设置围标等
  14. #############################################################################
  15.     def __init__(self):
  16.         super(GlyWindow, self).__init__()
  17.         self.setupUi(self)
  18.         # 记录当前应用程序路径
  19.         self.cur_dir = os.path.dirname(os.path.abspath(__file__))
  20.         # 设置窗体图标
  21.         app_icon = QIcon('登录配置.ico')
  22.         self.setWindowIcon(app_icon)
  23.  
  24.         # 默认操作
  25.         self.actionName = None
  26.         # 按纽绑定
  27.         self.pButtonCancel.clicked.connect(lambda: self.close())
  28.         self.pButtonOk.clicked.connect(lambda: self.check_login_info())
  29.  
  30.  
  31.     def check_login_info(self):
  32.         conn = sqlite3.connect(os.path.join(self.cur_dir, './data/user_password.db'))
  33.         c = conn.cursor()
  34.  
  35.         user = self.lineEdit_gly_User.text()
  36.         password = self.lineEdit_gly_Password.text()
  37.  
  38.         sql = f"select * from all_user where user_type='管理员' and  username='{user}' and password='{password}'"
  39.         cursor = c.execute(sql)
  40.         result = cursor.fetchone()
  41.  
  42.         if result is None:
  43.             QMessageBox.warning(self, '警告', '用户名或密码错误或非管理员用户！')
  44.             self.lineEdit_gly_Password.clear()
  45.             self.lineEdit_gly_Password.setFocus()
  46.         else:
  47.             self.MainSiganl.emit(True)
  48.             main_window = GsWindow()
  49.             main_window.show()
  50.             self.accept()
  51.         conn.close()
  52.  
  53.  
  54. if __name__ == '__main__':
  55.     app = QApplication(sys.argv)
  56.     detail_win = GlyWindow()
  57.     detail_win.show()
  58.     sys.exit(app.exec_())
  59.

3）用户登录界面

ui_untitled_yh_dl.py
  1. # -*- coding: utf-8 -*-
  2.  
  3. ################################################################################
  4. ## Form generated from reading UI file 'untitled_yh_dl.ui'
  5. ##
  6. ## Created by: Qt User Interface Compiler version 5.15.2
  7. ##
  8. ## WARNING! All changes made in this file will be lost when recompiling UI file!
  9. ################################################################################
  10.  
  11. from PySide2.QtCore import *
  12. from PySide2.QtGui import *
  13. from PySide2.QtWidgets import *
  14.  
  15. import picture_rc
  16.  
  17. class Ui_Dialog(object):
  18.     def setupUi(self, Dialog):
  19.         if not Dialog.objectName():
  20.             Dialog.setObjectName(u"Dialog")
  21.         Dialog.resize(813, 454)
  22.         self.layoutWidget_3 = QWidget(Dialog)
  23.         self.layoutWidget_3.setObjectName(u"layoutWidget_3")
  24.         self.layoutWidget_3.setGeometry(QRect(0, 0, 811, 75))
  25.         self.horizontalLayout_4 = QHBoxLayout(self.layoutWidget_3)
  26.         self.horizontalLayout_4.setObjectName(u"horizontalLayout_4")
  27.         self.horizontalLayout_4.setContentsMargins(0, 0, 0, 0)
  28.         self.horizontalSpacer_6 = QSpacerItem(40, 20, QSizePolicy.Expanding, QSizePolicy.Minimum)
  29.  
  30.         self.horizontalLayout_4.addItem(self.horizontalSpacer_6)
  31.  
  32.         self.label = QLabel(self.layoutWidget_3)
  33.         self.label.setObjectName(u"label")
  34.         font = QFont()
  35.         font.setFamily(u"Agency FB")
  36.         font.setPointSize(36)
  37.         self.label.setFont(font)
  38.  
  39.         self.horizontalLayout_4.addWidget(self.label)
  40.  
  41.         self.horizontalSpacer_7 = QSpacerItem(40, 20, QSizePolicy.Expanding, QSizePolicy.Minimum)
  42.  
  43.         self.horizontalLayout_4.addItem(self.horizontalSpacer_7)
  44.  
  45.         self.layoutWidget = QWidget(Dialog)
  46.         self.layoutWidget.setObjectName(u"layoutWidget")
  47.         self.layoutWidget.setGeometry(QRect(0, 120, 811, 54))
  48.         self.horizontalLayout_5 = QHBoxLayout(self.layoutWidget)
  49.         self.horizontalLayout_5.setObjectName(u"horizontalLayout_5")
  50.         self.horizontalLayout_5.setContentsMargins(0, 0, 0, 0)
  51.         self.horizontalSpacer_8 = QSpacerItem(40, 20, QSizePolicy.Expanding, QSizePolicy.Minimum)
  52.  
  53.         self.horizontalLayout_5.addItem(self.horizontalSpacer_8)
  54.  
  55.         self.label_Login = QLabel(self.layoutWidget)
  56.         self.label_Login.setObjectName(u"label_Login")
  57.         font1 = QFont()
  58.         font1.setFamily(u"Arial Black")
  59.         font1.setPointSize(22)
  60.         font1.setBold(True)
  61.         font1.setWeight(75)
  62.         self.label_Login.setFont(font1)
  63.  
  64.         self.horizontalLayout_5.addWidget(self.label_Login)
  65.  
  66.         self.horizontalSpacer_9 = QSpacerItem(40, 20, QSizePolicy.Expanding, QSizePolicy.Minimum)
  67.  
  68.         self.horizontalLayout_5.addItem(self.horizontalSpacer_9)
  69.  
  70.         self.layoutWidget_4 = QWidget(Dialog)
  71.         self.layoutWidget_4.setObjectName(u"layoutWidget_4")
  72.         self.layoutWidget_4.setGeometry(QRect(0, 230, 811, 98))
  73.         self.horizontalLayout_6 = QHBoxLayout(self.layoutWidget_4)
  74.         self.horizontalLayout_6.setObjectName(u"horizontalLayout_6")
  75.         self.horizontalLayout_6.setContentsMargins(0, 0, 0, 0)
  76.         self.horizontalSpacer_10 = QSpacerItem(40, 20, QSizePolicy.Expanding, QSizePolicy.Minimum)
  77.  
  78.         self.horizontalLayout_6.addItem(self.horizontalSpacer_10)
  79.  
  80.         self.verticalLayout = QVBoxLayout()
  81.         self.verticalLayout.setObjectName(u"verticalLayout")
  82.         self.horizontalLayout_2 = QHBoxLayout()
  83.         self.horizontalLayout_2.setObjectName(u"horizontalLayout_2")
  84.         self.label_3 = QLabel(self.layoutWidget_4)
  85.         self.label_3.setObjectName(u"label_3")
  86.         font2 = QFont()
  87.         font2.setFamily(u"Agency FB")
  88.         font2.setPointSize(14)
  89.         self.label_3.setFont(font2)
  90.  
  91.         self.horizontalLayout_2.addWidget(self.label_3)
  92.  
  93.         self.horizontalSpacer_4 = QSpacerItem(40, 20, QSizePolicy.Expanding, QSizePolicy.Minimum)
  94.  
  95.         self.horizontalLayout_2.addItem(self.horizontalSpacer_4)
  96.  
  97.         self.lineEdit_yh_User = QLineEdit(self.layoutWidget_4)
  98.         self.lineEdit_yh_User.setObjectName(u"lineEdit_yh_User")
  99.  
  100.         self.horizontalLayout_2.addWidget(self.lineEdit_yh_User)
  101.  
  102.  
  103.         self.verticalLayout.addLayout(self.horizontalLayout_2)
  104.  
  105.         self.verticalSpacer = QSpacerItem(20, 20, QSizePolicy.Minimum, QSizePolicy.Expanding)
  106.  
  107.         self.verticalLayout.addItem(self.verticalSpacer)
  108.  
  109.         self.horizontalLayout_3 = QHBoxLayout()
  110.         self.horizontalLayout_3.setObjectName(u"horizontalLayout_3")
  111.         self.label_4 = QLabel(self.layoutWidget_4)
  112.         self.label_4.setObjectName(u"label_4")
  113.         self.label_4.setFont(font2)
  114.  
  115.         self.horizontalLayout_3.addWidget(self.label_4)
  116.  
  117.         self.horizontalSpacer_5 = QSpacerItem(40, 20, QSizePolicy.Expanding, QSizePolicy.Minimum)
  118.  
  119.         self.horizontalLayout_3.addItem(self.horizontalSpacer_5)
  120.  
  121.         self.lineEdit_yh_Password = QLineEdit(self.layoutWidget_4)
  122.         self.lineEdit_yh_Password.setObjectName(u"lineEdit_yh_Password")
  123.  
  124.         self.horizontalLayout_3.addWidget(self.lineEdit_yh_Password)
  125.  
  126.  
  127.         self.verticalLayout.addLayout(self.horizontalLayout_3)
  128.  
  129.  
  130.         self.horizontalLayout_6.addLayout(self.verticalLayout)
  131.  
  132.         self.horizontalSpacer_11 = QSpacerItem(40, 20, QSizePolicy.Expanding, QSizePolicy.Minimum)
  133.  
  134.         self.horizontalLayout_6.addItem(self.horizontalSpacer_11)
  135.  
  136.         self.layoutWidget_2 = QWidget(Dialog)
  137.         self.layoutWidget_2.setObjectName(u"layoutWidget_2")
  138.         self.layoutWidget_2.setGeometry(QRect(0, 420, 811, 33))
  139.         self.horizontalLayout = QHBoxLayout(self.layoutWidget_2)
  140.         self.horizontalLayout.setObjectName(u"horizontalLayout")
  141.         self.horizontalLayout.setContentsMargins(0, 0, 0, 0)
  142.         self.horizontalSpacer = QSpacerItem(40, 20, QSizePolicy.Expanding, QSizePolicy.Minimum)
  143.  
  144.         self.horizontalLayout.addItem(self.horizontalSpacer)
  145.  
  146.         self.pButtonOk = QPushButton(self.layoutWidget_2)
  147.         self.pButtonOk.setObjectName(u"pButtonOk")
  148.         font3 = QFont()
  149.         font3.setFamily(u"Agency FB")
  150.         font3.setPointSize(10)
  151.         self.pButtonOk.setFont(font3)
  152.  
  153.         self.horizontalLayout.addWidget(self.pButtonOk)
  154.  
  155.         self.horizontalSpacer_2 = QSpacerItem(40, 20, QSizePolicy.Expanding, QSizePolicy.Minimum)
  156.  
  157.         self.horizontalLayout.addItem(self.horizontalSpacer_2)
  158.  
  159.         self.pButtonCancel = QPushButton(self.layoutWidget_2)
  160.         self.pButtonCancel.setObjectName(u"pButtonCancel")
  161.         self.pButtonCancel.setFont(font3)
  162.  
  163.         self.horizontalLayout.addWidget(self.pButtonCancel)
  164.  
  165.         self.horizontalSpacer_3 = QSpacerItem(40, 20, QSizePolicy.Expanding, QSizePolicy.Minimum)
  166.  
  167.         self.horizontalLayout.addItem(self.horizontalSpacer_3)
  168.  
  169.         self.label_5 = QLabel(Dialog)
  170.         self.label_5.setObjectName(u"label_5")
  171.         self.label_5.setGeometry(QRect(1, -6, 811, 461))
  172.         self.label_5.setPixmap(QPixmap(u":/b2.png"))
  173.         self.label_5.setScaledContents(True)
  174.         self.label_5.raise_()
  175.         self.layoutWidget_3.raise_()
  176.         self.layoutWidget.raise_()
  177.         self.layoutWidget_4.raise_()
  178.         self.layoutWidget_2.raise_()
  179.  
  180.         self.retranslateUi(Dialog)
  181.  
  182.         QMetaObject.connectSlotsByName(Dialog)
  183.     # setupUi
  184.  
  185.     def retranslateUi(self, Dialog):
  186.         Dialog.setWindowTitle(QCoreApplication.translate("Dialog", u"Dialog", None))
  187.         self.label.setText(QCoreApplication.translate("Dialog", u"\u9879\u76ee\u8fdb\u5ea6\u7ba1\u7406\u7cfb\u7edf", None))
  188.         self.label_Login.setText(QCoreApplication.translate("Dialog", u"\u7528\u6237\u767b\u5f55", None))
  189.         self.label_3.setText(QCoreApplication.translate("Dialog", u"\u7528\u6237\u540d\uff1a", None))
  190.         self.lineEdit_yh_User.setText("")
  191.         self.label_4.setText(QCoreApplication.translate("Dialog", u"\u5bc6\u7801\uff1a", None))
  192.         self.pButtonOk.setText(QCoreApplication.translate("Dialog", u"\u786e\u5b9a", None))
  193.         self.pButtonCancel.setText(QCoreApplication.translate("Dialog", u"\u53d6\u6d88", None))
  194.         self.label_5.setText("")
  195.     # retranslateUi
  196.  
yh_login.py

  1. from PySide2.QtWidgets import QApplication, QDialog, QMessageBox
  2. from PySide2.QtCore import Signal # 信号
  3. from PySide2.QtGui import Qt, QIcon # 图标、窗体设置
  4. import sqlite3
  5. import sys, os
  6. from ui.ui_untitled_yh_dl import Ui_Dialog
  7. from main import MainWindow
  8.  
  9.  
  10. class YhWindow(QDialog, Ui_Dialog):
  11.     # 定义一个信号，从子窗体向主窗体返回信号
  12.     MainSiganl = Signal(bool)
  13.     UserSignal = Signal(str)
  14.     #################################
  15.     # 子窗体初始化、声明信号、设置围标等
  16.     def __init__(self):
  17.         super(YhWindow, self).__init__()
  18.         self.setupUi(self)
  19.         self.setWindowTitle("用户登录")
  20.         # 记录当前应用程序路径
  21.         self.cur_dir = os.path.dirname(os.path.abspath(__file__))
  22.         # 设置窗体图标
  23.         app_icon = QIcon('登录配置.ico')
  24.         self.setWindowIcon(app_icon)
  25.  
  26.         # 默认操作
  27.         self.actionName = None
  28.         # 按纽绑定
  29.         self.pButtonCancel.clicked.connect(lambda: self.close())
  30.         self.pButtonOk.clicked.connect(lambda: self.check_login_info())
  31.  
  32.         self.stuAction = None
  33.  
  34.         self.main_win = None
  35.  
  36.  
  37.     def check_login_info(self):
  38.         conn = sqlite3.connect(os.path.join(self.cur_dir, './data/user_password.db'))
  39.         c = conn.cursor()
  40.  
  41.         user = self.lineEdit_yh_User.text()
  42.         password = self.lineEdit_yh_Password.text()
  43.  
  44.  
  45.  
  46.         # print(user)
  47.         # print(type(user))
  48.         sql = f"select * from all_user where user_type='普通用户' and  username='{user}' and password='{password}'"
  49.         cursor = c.execute(sql)
  50.         result = cursor.fetchone()
  51.  
  52.         if result is None:
  53.             QMessageBox.warning(self, '警告', '用户名或密码错误或为管理员用户！')
  54.             self.lineEdit_yh_Password.clear()
  55.             self.lineEdit_yh_Password.setFocus()
  56.         else:
  57.             self.MainSiganl.emit(True)
  58.             self.main_win = MainWindow()
  59.             self.main_win.show()
  60.             self.accept()
  61.  
  62.             self.stuAction = user
  63.             self.UserSignal.connect(self.main_win.yh_login_Signal)
  64.             self.UserSignal.emit(self.stuAction)
  65.  
  66.         conn.close()
  67.  
  68.  
  69. if __name__ == '__main__':
  70.     app = QApplication(sys.argv)
  71.     detail_win = YhWindow()
  72.     detail_win.show()
  73.     sys.exit(app.exec_())

4）管理员选择模块界面

ui_gly_select.py
  1. # -*- coding: utf-8 -*-
  2.  
  3. ################################################################################
  4. ## Form generated from reading UI file 'gly_select.ui'
  5. ##
  6. ## Created by: Qt User Interface Compiler version 5.15.2
  7. ##
  8. ## WARNING! All changes made in this file will be lost when recompiling UI file!
  9. ################################################################################
  10.  
  11. from PySide2.QtCore import *
  12. from PySide2.QtGui import *
  13. from PySide2.QtWidgets import *
  14.  
  15. import picture_rc
  16.  
  17. class Ui_Dialog(object):
  18.     def setupUi(self, Dialog):
  19.         if not Dialog.objectName():
  20.             Dialog.setObjectName(u"Dialog")
  21.         Dialog.resize(940, 564)
  22.         self.layoutWidget = QWidget(Dialog)
  23.         self.layoutWidget.setObjectName(u"layoutWidget")
  24.         self.layoutWidget.setGeometry(QRect(0, 60, 941, 461))
  25.         self.verticalLayout_2 = QVBoxLayout(self.layoutWidget)
  26.         self.verticalLayout_2.setObjectName(u"verticalLayout_2")
  27.         self.verticalLayout_2.setContentsMargins(0, 0, 0, 0)
  28.         self.horizontalLayout = QHBoxLayout()
  29.         self.horizontalLayout.setObjectName(u"horizontalLayout")
  30.         self.horizontalSpacer = QSpacerItem(40, 20, QSizePolicy.Expanding, QSizePolicy.Minimum)
  31.  
  32.         self.horizontalLayout.addItem(self.horizontalSpacer)
  33.  
  34.         self.label = QLabel(self.layoutWidget)
  35.         self.label.setObjectName(u"label")
  36.         font = QFont()
  37.         font.setFamily(u"Agency FB")
  38.         font.setPointSize(24)
  39.         font.setBold(True)
  40.         font.setWeight(75)
  41.         self.label.setFont(font)
  42.  
  43.         self.horizontalLayout.addWidget(self.label)
  44.  
  45.         self.horizontalSpacer_2 = QSpacerItem(40, 20, QSizePolicy.Expanding, QSizePolicy.Minimum)
  46.  
  47.         self.horizontalLayout.addItem(self.horizontalSpacer_2)
  48.  
  49.  
  50.         self.verticalLayout_2.addLayout(self.horizontalLayout)
  51.  
  52.         self.verticalSpacer_2 = QSpacerItem(20, 40, QSizePolicy.Minimum, QSizePolicy.Fixed)
  53.  
  54.         self.verticalLayout_2.addItem(self.verticalSpacer_2)
  55.  
  56.         self.horizontalLayout_3 = QHBoxLayout()
  57.         self.horizontalLayout_3.setObjectName(u"horizontalLayout_3")
  58.         self.horizontalSpacer_4 = QSpacerItem(40, 20, QSizePolicy.Expanding, QSizePolicy.Minimum)
  59.  
  60.         self.horizontalLayout_3.addItem(self.horizontalSpacer_4)
  61.  
  62.         self.horizontalLayout_2 = QHBoxLayout()
  63.         self.horizontalLayout_2.setObjectName(u"horizontalLayout_2")
  64.         self.label_2 = QLabel(self.layoutWidget)
  65.         self.label_2.setObjectName(u"label_2")
  66.         font1 = QFont()
  67.         font1.setFamily(u"Agency FB")
  68.         font1.setPointSize(22)
  69.         font1.setBold(True)
  70.         font1.setWeight(75)
  71.         self.label_2.setFont(font1)
  72.  
  73.         self.horizontalLayout_2.addWidget(self.label_2)
  74.  
  75.         self.horizontalSpacer_3 = QSpacerItem(40, 20, QSizePolicy.Fixed, QSizePolicy.Minimum)
  76.  
  77.         self.horizontalLayout_2.addItem(self.horizontalSpacer_3)
  78.  
  79.         self.verticalLayout = QVBoxLayout()
  80.         self.verticalLayout.setObjectName(u"verticalLayout")
  81.         self.pButtonuser = QPushButton(self.layoutWidget)
  82.         self.pButtonuser.setObjectName(u"pButtonuser")
  83.         font2 = QFont()
  84.         font2.setFamily(u"Bahnschrift SemiBold Condensed")
  85.         font2.setPointSize(22)
  86.         font2.setBold(True)
  87.         font2.setWeight(75)
  88.         self.pButtonuser.setFont(font2)
  89.  
  90.         self.verticalLayout.addWidget(self.pButtonuser)
  91.  
  92.         self.verticalSpacer = QSpacerItem(20, 40, QSizePolicy.Minimum, QSizePolicy.Expanding)
  93.  
  94.         self.verticalLayout.addItem(self.verticalSpacer)
  95.  
  96.         self.pButtonproject = QPushButton(self.layoutWidget)
  97.         self.pButtonproject.setObjectName(u"pButtonproject")
  98.         font3 = QFont()
  99.         font3.setFamily(u"Bahnschrift Condensed")
  100.         font3.setPointSize(24)
  101.         font3.setBold(True)
  102.         font3.setWeight(75)
  103.         self.pButtonproject.setFont(font3)
  104.  
  105.         self.verticalLayout.addWidget(self.pButtonproject)
  106.  
  107.  
  108.         self.horizontalLayout_2.addLayout(self.verticalLayout)
  109.  
  110.  
  111.         self.horizontalLayout_3.addLayout(self.horizontalLayout_2)
  112.  
  113.         self.horizontalSpacer_5 = QSpacerItem(40, 20, QSizePolicy.Expanding, QSizePolicy.Minimum)
  114.  
  115.         self.horizontalLayout_3.addItem(self.horizontalSpacer_5)
  116.  
  117.  
  118.         self.verticalLayout_2.addLayout(self.horizontalLayout_3)
  119.  
  120.         self.tableWidget = QTableWidget(Dialog)
  121.         self.tableWidget.setObjectName(u"tableWidget")
  122.         self.tableWidget.setGeometry(QRect(0, 0, 941, 561))
  123.         self.tableWidget.setStyleSheet(u"background-image: url(:/b1.png);\n"
  124. " background-size: cover;")
  125.         self.tableWidget.raise_()
  126.         self.layoutWidget.raise_()
  127.  
  128.         self.retranslateUi(Dialog)
  129.  
  130.         QMetaObject.connectSlotsByName(Dialog)
  131.     # setupUi
  132.  
  133.     def retranslateUi(self, Dialog):
  134.         Dialog.setWindowTitle(QCoreApplication.translate("Dialog", u"\u7ba1\u7406\u5458\u64cd\u4f5c", None))
  135.         self.label.setText(QCoreApplication.translate("Dialog", u"\u7ba1\u7406\u5458\u64cd\u4f5c", None))
  136.         self.label_2.setText(QCoreApplication.translate("Dialog", u"\u8bf7\u9009\u62e9\uff1a", None))
  137.         self.pButtonuser.setText(QCoreApplication.translate("Dialog", u"\u7528\u6237\u7ba1\u7406", None))
  138.         self.pButtonproject.setText(QCoreApplication.translate("Dialog", u"\u9879\u76ee\u7ba1\u7406", None))
  139.     # retranslateUi
  140.  
ui_gly_select.py
  1. from PySide2.QtWidgets import QApplication, QDialog, QMessageBox
  2. from PySide2.QtCore import Signal # 信号
  3. from PySide2.QtGui import Qt, QIcon # 图标、窗体设置
  4. from PySide2.QtWidgets import QLineEdit, QPushButton
  5. import sqlite3
  6. import sys, os
  7. from main_body.ui_gly_select import Ui_Dialog
  8. from main import MainWindow as projectwindow
  9. from control_user import MainWindow as userwindow
  10.  
  11. from PyQt5.QtWidgets import QApplication, QWidget
  12.  
  13. class GsWindow(QDialog , Ui_Dialog):
  14.     MainSiganl = Signal(bool)
  15.  
  16.     def __init__(self):
  17.         super(GsWindow, self).__init__()
  18.         self.setupUi(self)
  19.         # 记录当前应用程序路径
  20.         self.cur_dir = os.path.dirname(os.path.abspath(__file__))
  21.         # 设置窗体图标
  22.         app_icon = QIcon('登录配置.ico')
  23.         self.setWindowIcon(app_icon)
  24.  
  25.         self.pButtonuser.clicked.connect(lambda: self.User())
  26.         self.pButtonproject.clicked.connect(lambda: self.Project())
  27.  
  28.         self.setStyleSheet("background-image: url(b1.jpg);")
  29.  
  30.     def User(self):
  31.         self.user_win = userwindow()
  32.         self.user_win.show()
  33.  
  34.     def Project(self):
  35.         self.pro_win = projectwindow()
  36.         self.pro_win.show()
  37.  
  38.  
  39.  
  40.  
  41.  
  42. if __name__ == '__main__':
  43.     app = QApplication(sys.argv)
  44.     detail_win = GsWindow()
  45.     detail_win.show()
  46.     sys.exit(app.exec_())

5）管理员主界面----项目管理

ui_main.py

  1. # -*- coding: utf-8 -*-
  2.  
  3. ################################################################################
  4. ## Form generated from reading UI file 'main.ui'
  5. ##
  6. ## Created by: Qt User Interface Compiler version 5.15.2
  7. ##
  8. ## WARNING! All changes made in this file will be lost when recompiling UI file!
  9. ################################################################################
  10.  
  11. from PySide2.QtCore import *
  12. from PySide2.QtGui import *
  13. from PySide2.QtWidgets import *
  14.  
  15. import picture_rc
  16.  
  17. class Ui_MainWindow(object):
  18.     def setupUi(self, MainWindow):
  19.         if not MainWindow.objectName():
  20.             MainWindow.setObjectName(u"MainWindow")
  21.         MainWindow.resize(1253, 840)
  22.         icon = QIcon()
  23.         icon.addFile(u":/\u767b\u5f55.png", QSize(), QIcon.Normal, QIcon.Off)
  24.         MainWindow.setWindowIcon(icon)
  25.         self.actionMenuOpen = QAction(MainWindow)
  26.         self.actionMenuOpen.setObjectName(u"actionMenuOpen")
  27.         self.actionMenuExit = QAction(MainWindow)
  28.         self.actionMenuExit.setObjectName(u"actionMenuExit")
  29.         self.actionTlbExit = QAction(MainWindow)
  30.         self.actionTlbExit.setObjectName(u"actionTlbExit")
  31.         self.actionTlbAdd = QAction(MainWindow)
  32.         self.actionTlbAdd.setObjectName(u"actionTlbAdd")
  33.         self.actionTlbChange = QAction(MainWindow)
  34.         self.actionTlbChange.setObjectName(u"actionTlbChange")
  35.         self.actionMenuAdd = QAction(MainWindow)
  36.         self.actionMenuAdd.setObjectName(u"actionMenuAdd")
  37.         self.actionMenuChange = QAction(MainWindow)
  38.         self.actionMenuChange.setObjectName(u"actionMenuChange")
  39.         self.actionTlbExport = QAction(MainWindow)
  40.         self.actionTlbExport.setObjectName(u"actionTlbExport")
  41.         self.actionTlbSelect = QAction(MainWindow)
  42.         self.actionTlbSelect.setObjectName(u"actionTlbSelect")
  43.         self.actionquestion = QAction(MainWindow)
  44.         self.actionquestion.setObjectName(u"actionquestion")
  45.         self.centralwidget = QWidget(MainWindow)
  46.         self.centralwidget.setObjectName(u"centralwidget")
  47.         self.layoutWidget = QWidget(self.centralwidget)
  48.         self.layoutWidget.setObjectName(u"layoutWidget")
  49.         self.layoutWidget.setGeometry(QRect(0, 10, 1251, 51))
  50.         self.verticalLayout = QVBoxLayout(self.layoutWidget)
  51.         self.verticalLayout.setObjectName(u"verticalLayout")
  52.         self.verticalLayout.setContentsMargins(0, 0, 0, 0)
  53.         self.verticalSpacer = QSpacerItem(20, 40, QSizePolicy.Minimum, QSizePolicy.Expanding)
  54.  
  55.         self.verticalLayout.addItem(self.verticalSpacer)
  56.  
  57.         self.horizontalLayout = QHBoxLayout()
  58.         self.horizontalLayout.setObjectName(u"horizontalLayout")
  59.         self.horizontalSpacer = QSpacerItem(40, 20, QSizePolicy.Expanding, QSizePolicy.Minimum)
  60.  
  61.         self.horizontalLayout.addItem(self.horizontalSpacer)
  62.  
  63.         self.label = QLabel(self.layoutWidget)
  64.         self.label.setObjectName(u"label")
  65.         font = QFont()
  66.         font.setFamily(u"Agency FB")
  67.         font.setPointSize(20)
  68.         font.setBold(True)
  69.         font.setUnderline(True)
  70.         font.setWeight(75)
  71.         self.label.setFont(font)
  72.  
  73.         self.horizontalLayout.addWidget(self.label)
  74.  
  75.         self.horizontalSpacer_2 = QSpacerItem(40, 20, QSizePolicy.Expanding, QSizePolicy.Minimum)
  76.  
  77.         self.horizontalLayout.addItem(self.horizontalSpacer_2)
  78.  
  79.         self.lineEditUser_Id = QLineEdit(self.layoutWidget)
  80.         self.lineEditUser_Id.setObjectName(u"lineEditUser_Id")
  81.         font1 = QFont()
  82.         font1.setFamily(u"Agency FB")
  83.         font1.setPointSize(12)
  84.         font1.setBold(True)
  85.         font1.setWeight(75)
  86.         self.lineEditUser_Id.setFont(font1)
  87.  
  88.         self.horizontalLayout.addWidget(self.lineEditUser_Id)
  89.  
  90.  
  91.         self.verticalLayout.addLayout(self.horizontalLayout)
  92.  
  93.         self.layoutWidget1 = QWidget(self.centralwidget)
  94.         self.layoutWidget1.setObjectName(u"layoutWidget1")
  95.         self.layoutWidget1.setGeometry(QRect(0, 60, 1251, 701))
  96.         self.horizontalLayout_2 = QHBoxLayout(self.layoutWidget1)
  97.         self.horizontalLayout_2.setObjectName(u"horizontalLayout_2")
  98.         self.horizontalLayout_2.setContentsMargins(0, 0, 0, 0)
  99.         self.tableWidget = QTableWidget(self.layoutWidget1)
  100.         if (self.tableWidget.columnCount() < 9):
  101.             self.tableWidget.setColumnCount(9)
  102.         __qtablewidgetitem = QTableWidgetItem()
  103.         self.tableWidget.setHorizontalHeaderItem(0, __qtablewidgetitem)
  104.         __qtablewidgetitem1 = QTableWidgetItem()
  105.         self.tableWidget.setHorizontalHeaderItem(1, __qtablewidgetitem1)
  106.         __qtablewidgetitem2 = QTableWidgetItem()
  107.         self.tableWidget.setHorizontalHeaderItem(2, __qtablewidgetitem2)
  108.         __qtablewidgetitem3 = QTableWidgetItem()
  109.         self.tableWidget.setHorizontalHeaderItem(3, __qtablewidgetitem3)
  110.         __qtablewidgetitem4 = QTableWidgetItem()
  111.         self.tableWidget.setHorizontalHeaderItem(4, __qtablewidgetitem4)
  112.         __qtablewidgetitem5 = QTableWidgetItem()
  113.         self.tableWidget.setHorizontalHeaderItem(5, __qtablewidgetitem5)
  114.         __qtablewidgetitem6 = QTableWidgetItem()
  115.         self.tableWidget.setHorizontalHeaderItem(6, __qtablewidgetitem6)
  116.         __qtablewidgetitem7 = QTableWidgetItem()
  117.         self.tableWidget.setHorizontalHeaderItem(7, __qtablewidgetitem7)
  118.         __qtablewidgetitem8 = QTableWidgetItem()
  119.         self.tableWidget.setHorizontalHeaderItem(8, __qtablewidgetitem8)
  120.         self.tableWidget.setObjectName(u"tableWidget")
  121.  
  122.         self.horizontalLayout_2.addWidget(self.tableWidget)
  123.  
  124.         self.verticalLayout_3 = QVBoxLayout()
  125.         self.verticalLayout_3.setObjectName(u"verticalLayout_3")
  126.         self.verticalSpacer_5 = QSpacerItem(20, 40, QSizePolicy.Minimum, QSizePolicy.Expanding)
  127.  
  128.         self.verticalLayout_3.addItem(self.verticalSpacer_5)
  129.  
  130.         self.pButtonSelect = QPushButton(self.layoutWidget1)
  131.         self.pButtonSelect.setObjectName(u"pButtonSelect")
  132.  
  133.         self.verticalLayout_3.addWidget(self.pButtonSelect)
  134.  
  135.         self.verticalSpacer_8 = QSpacerItem(20, 20, QSizePolicy.Minimum, QSizePolicy.Fixed)
  136.  
  137.         self.verticalLayout_3.addItem(self.verticalSpacer_8)
  138.  
  139.         self.verticalLayout_2 = QVBoxLayout()
  140.         self.verticalLayout_2.setObjectName(u"verticalLayout_2")
  141.         self.pButtonAdd = QPushButton(self.layoutWidget1)
  142.         self.pButtonAdd.setObjectName(u"pButtonAdd")
  143.  
  144.         self.verticalLayout_2.addWidget(self.pButtonAdd)
  145.  
  146.         self.verticalSpacer_4 = QSpacerItem(20, 20, QSizePolicy.Minimum, QSizePolicy.Fixed)
  147.  
  148.         self.verticalLayout_2.addItem(self.verticalSpacer_4)
  149.  
  150.         self.pButtonchange = QPushButton(self.layoutWidget1)
  151.         self.pButtonchange.setObjectName(u"pButtonchange")
  152.  
  153.         self.verticalLayout_2.addWidget(self.pButtonchange)
  154.  
  155.         self.verticalSpacer_7 = QSpacerItem(20, 20, QSizePolicy.Minimum, QSizePolicy.Fixed)
  156.  
  157.         self.verticalLayout_2.addItem(self.verticalSpacer_7)
  158.  
  159.         self.pButtonExport = QPushButton(self.layoutWidget1)
  160.         self.pButtonExport.setObjectName(u"pButtonExport")
  161.  
  162.         self.verticalLayout_2.addWidget(self.pButtonExport)
  163.  
  164.         self.verticalSpacer_6 = QSpacerItem(20, 20, QSizePolicy.Minimum, QSizePolicy.Fixed)
  165.  
  166.         self.verticalLayout_2.addItem(self.verticalSpacer_6)
  167.  
  168.         self.pButtonImport = QPushButton(self.layoutWidget1)
  169.         self.pButtonImport.setObjectName(u"pButtonImport")
  170.  
  171.         self.verticalLayout_2.addWidget(self.pButtonImport)
  172.  
  173.         self.verticalSpacer_3 = QSpacerItem(20, 20, QSizePolicy.Minimum, QSizePolicy.Fixed)
  174.  
  175.         self.verticalLayout_2.addItem(self.verticalSpacer_3)
  176.  
  177.         self.pButtonshow = QPushButton(self.layoutWidget1)
  178.         self.pButtonshow.setObjectName(u"pButtonshow")
  179.  
  180.         self.verticalLayout_2.addWidget(self.pButtonshow)
  181.  
  182.         self.verticalSpacer_2 = QSpacerItem(20, 20, QSizePolicy.Minimum, QSizePolicy.Fixed)
  183.  
  184.         self.verticalLayout_2.addItem(self.verticalSpacer_2)
  185.  
  186.         self.pButtonExit = QPushButton(self.layoutWidget1)
  187.         self.pButtonExit.setObjectName(u"pButtonExit")
  188.  
  189.         self.verticalLayout_2.addWidget(self.pButtonExit)
  190.  
  191.  
  192.         self.verticalLayout_3.addLayout(self.verticalLayout_2)
  193.  
  194.  
  195.         self.horizontalLayout_2.addLayout(self.verticalLayout_3)
  196.  
  197.         MainWindow.setCentralWidget(self.centralwidget)
  198.         self.menubar = QMenuBar(MainWindow)
  199.         self.menubar.setObjectName(u"menubar")
  200.         self.menubar.setGeometry(QRect(0, 0, 1253, 26))
  201.         self.menuFile = QMenu(self.menubar)
  202.         self.menuFile.setObjectName(u"menuFile")
  203.         self.menuAdd = QMenu(self.menubar)
  204.         self.menuAdd.setObjectName(u"menuAdd")
  205.         self.menuEdit = QMenu(self.menubar)
  206.         self.menuEdit.setObjectName(u"menuEdit")
  207.         self.menuHelp = QMenu(self.menubar)
  208.         self.menuHelp.setObjectName(u"menuHelp")
  209.         MainWindow.setMenuBar(self.menubar)
  210.         self.statusbar = QStatusBar(MainWindow)
  211.         self.statusbar.setObjectName(u"statusbar")
  212.         MainWindow.setStatusBar(self.statusbar)
  213.         self.toolBar = QToolBar(MainWindow)
  214.         self.toolBar.setObjectName(u"toolBar")
  215.         MainWindow.addToolBar(Qt.TopToolBarArea, self.toolBar)
  216.  
  217.         self.menubar.addAction(self.menuFile.menuAction())
  218.         self.menubar.addAction(self.menuAdd.menuAction())
  219.         self.menubar.addAction(self.menuEdit.menuAction())
  220.         self.menubar.addAction(self.menuHelp.menuAction())
  221.         self.menuFile.addAction(self.actionMenuOpen)
  222.         self.menuFile.addAction(self.actionMenuExit)
  223.         self.menuEdit.addAction(self.actionMenuAdd)
  224.         self.menuEdit.addAction(self.actionMenuChange)
  225.         self.menuHelp.addAction(self.actionquestion)
  226.         self.toolBar.addAction(self.actionTlbExit)
  227.         self.toolBar.addAction(self.actionTlbAdd)
  228.         self.toolBar.addAction(self.actionTlbChange)
  229.         self.toolBar.addAction(self.actionTlbExport)
  230.         self.toolBar.addAction(self.actionTlbSelect)
  231.  
  232.         self.retranslateUi(MainWindow)
  233.  
  234.         QMetaObject.connectSlotsByName(MainWindow)
  235.     # setupUi
  236.  
  237.     def retranslateUi(self, MainWindow):
  238.         MainWindow.setWindowTitle(QCoreApplication.translate("MainWindow", u"\u9879\u76ee\u4e00\u89c8", None))
  239.         self.actionMenuOpen.setText(QCoreApplication.translate("MainWindow", u"\u6253\u5f00", None))
  240.         self.actionMenuExit.setText(QCoreApplication.translate("MainWindow", u"\u9000\u51fa", None))
  241.         self.actionTlbExit.setText(QCoreApplication.translate("MainWindow", u"\u9000\u51fa\u7cfb\u7edf", None))
  242.         self.actionTlbAdd.setText(QCoreApplication.translate("MainWindow", u"\u6dfb\u52a0\u9879\u76ee", None))
  243.         self.actionTlbChange.setText(QCoreApplication.translate("MainWindow", u"\u4fee\u6539\u9879\u76ee", None))
  244.         self.actionMenuAdd.setText(QCoreApplication.translate("MainWindow", u"\u6dfb\u52a0\u9879\u76ee", None))
  245.         self.actionMenuChange.setText(QCoreApplication.translate("MainWindow", u"\u4fee\u6539\u9879\u76ee", None))
  246.         self.actionTlbExport.setText(QCoreApplication.translate("MainWindow", u"\u5bfc\u51fa\u9879\u76ee", None))
  247.         self.actionTlbSelect.setText(QCoreApplication.translate("MainWindow", u"\u641c\u7d22\u9879\u76ee", None))
  248.         self.actionquestion.setText(QCoreApplication.translate("MainWindow", u"\u51fa\u73b0\u9519\u8bef\uff1f", None))
  249.         self.label.setText(QCoreApplication.translate("MainWindow", u"\u9879\u76ee\u8fdb\u5ea6\u7ba1\u7406", None))
  250.         ___qtablewidgetitem = self.tableWidget.horizontalHeaderItem(0)
  251.         ___qtablewidgetitem.setText(QCoreApplication.translate("MainWindow", u"\u9879\u76ee\u7f16\u53f7", None));
  252.         ___qtablewidgetitem1 = self.tableWidget.horizontalHeaderItem(1)
  253.         ___qtablewidgetitem1.setText(QCoreApplication.translate("MainWindow", u"\u9879\u76ee\u7c7b\u578b", None));
  254.         ___qtablewidgetitem2 = self.tableWidget.horizontalHeaderItem(2)
  255.         ___qtablewidgetitem2.setText(QCoreApplication.translate("MainWindow", u"\u9879\u76ee\u540d\u79f0", None));
  256.         ___qtablewidgetitem3 = self.tableWidget.horizontalHeaderItem(3)
  257.         ___qtablewidgetitem3.setText(QCoreApplication.translate("MainWindow", u"\u5f00\u59cb\u65e5\u671f", None));
  258.         ___qtablewidgetitem4 = self.tableWidget.horizontalHeaderItem(4)
  259.         ___qtablewidgetitem4.setText(QCoreApplication.translate("MainWindow", u"\u7ed3\u675f\u65e5\u671f", None));
  260.         ___qtablewidgetitem5 = self.tableWidget.horizontalHeaderItem(5)
  261.         ___qtablewidgetitem5.setText(QCoreApplication.translate("MainWindow", u"\u5b8c\u6210\u8fdb\u5ea6", None));
  262.         ___qtablewidgetitem6 = self.tableWidget.horizontalHeaderItem(6)
  263.         ___qtablewidgetitem6.setText(QCoreApplication.translate("MainWindow", u"\u8d1f\u8d23\u4eba", None));
  264.         ___qtablewidgetitem7 = self.tableWidget.horizontalHeaderItem(7)
  265.         ___qtablewidgetitem7.setText(QCoreApplication.translate("MainWindow", u"\u9879\u76ee\u7ea7\u522b", None));
  266.         ___qtablewidgetitem8 = self.tableWidget.horizontalHeaderItem(8)
  267.         ___qtablewidgetitem8.setText(QCoreApplication.translate("MainWindow", u"\u5907\u6ce8", None));
  268.         self.pButtonSelect.setText(QCoreApplication.translate("MainWindow", u"\u641c\u7d22\u9879\u76ee", None))
  269.         self.pButtonAdd.setText(QCoreApplication.translate("MainWindow", u"\u6dfb\u52a0\u9879\u76ee", None))
  270.         self.pButtonchange.setText(QCoreApplication.translate("MainWindow", u"\u4fee\u6539\u9879\u76ee", None))
  271.         self.pButtonExport.setText(QCoreApplication.translate("MainWindow", u"\u5bfc\u51fa\u9879\u76ee", None))
  272.         self.pButtonImport.setText(QCoreApplication.translate("MainWindow", u"\u5bfc\u5165\u9879\u76ee", None))
  273.         self.pButtonshow.setText(QCoreApplication.translate("MainWindow", u"\u663e\u793a\u9879\u76ee\u53ca\u6570\u636e", None))
  274.         self.pButtonExit.setText(QCoreApplication.translate("MainWindow", u"\u9000\u51fa\u7cfb\u7edf", None))
  275.         self.menuFile.setTitle(QCoreApplication.translate("MainWindow", u"\u6587\u4ef6", None))
  276.         self.menuAdd.setTitle("")
  277.         self.menuEdit.setTitle(QCoreApplication.translate("MainWindow", u"\u7f16\u8f91", None))
  278.         self.menuHelp.setTitle(QCoreApplication.translate("MainWindow", u"\u5e2e\u52a9", None))
  279.         self.toolBar.setWindowTitle(QCoreApplication.translate("MainWindow", u"toolBar", None))
  280.     # retranslateUi
  281.

main.py

  1. from PySide2.QtWidgets import QApplication
  2. from PySide2.QtWidgets import QMainWindow
  3. from PySide2.QtWidgets import QTableWidget, QTableWidgetItem
  4. from PySide2.QtWidgets import QAbstractItemView, QLineEdit, QPushButton
  5. import sys, os
  6. from main_body.ui_main import Ui_MainWindow as MainWin
  7.  
  8. from PySide2.QtWidgets import QHeaderView
  9. import sqlite3
  10.  
  11. from PySide2.QtWidgets import QFileDialog, QMessageBox, QMenu
  12. import chardet, csv
  13.  
  14. from PySide2.QtCore import Signal, Qt
  15. from gl import DetailWindow as DetailWind
  16.  
  17. from search import DetailWindow as Searchwind
  18.  
  19. from tkinter import *
  20. from tkinter import messagebox
  21.  
  22. from question import DetailWindow  as qwind
  23.  
  24. from control_user import MainWindow as conwind
  25.  
  26. from PySide2.QtGui import Qt, QIcon # 图标、窗体设置
  27.  
  28.  
  29. class MainWindow(QMainWindow, MainWin):
  30.     mainSignal = Signal(str, dict)
  31.     def __init__(self):
  32.         super(MainWindow, self).__init__()
  33.         self.setupUi(self)
  34.  
  35.         self.cur_dir = os.path.dirname(os.path.abspath(__file__))
  36.  
  37.         # 设置窗体图标
  38.         app_icon = QIcon('项目新.ico')
  39.         self.setWindowIcon(app_icon)
  40.  
  41.         self.pButtonExit.clicked.connect(lambda: self.Close())
  42.         self.pButtonshow.clicked.connect(lambda: self.Show())
  43.         self.pButtonImport.clicked.connect(lambda: self.Import())
  44.  
  45.         self.tableWidget.setSelectionBehavior(QAbstractItemView.SelectRows)
  46.         self.tableWidget.setSelectionMode(QAbstractItemView.SingleSelection)
  47.  
  48.         self.gl_win = None
  49.         self.pButtonAdd.clicked.connect(lambda: self.Project_Add())
  50.         self.pButtonchange.clicked.connect(lambda: self.Project_Change())
  51.         self.pButtonExport.clicked.connect(lambda: self.Export())
  52.         self.pButtonSelect.clicked.connect(lambda: self.Select())
  53.  
  54.         self.stuAction = None
  55.         self.YhName = None
  56.  
  57.         self.actionTlbExit.triggered.connect(lambda: self.Close())
  58.         self.actionTlbAdd.triggered.connect(lambda: self.Project_Add())
  59.         self.actionTlbChange.triggered.connect(lambda: self.Project_Change())
  60.         self.actionTlbExport.triggered.connect(lambda: self.Export())
  61.         self.actionTlbSelect.triggered.connect(lambda: self.Select())
  62.         # self.tableWidget.setSelectionBehavior(
  63.         #     QAbstractItemView.SelectRows  # 行选
  64.         # )
  65.         # self.tableWidget.setSelectionMode(
  66.         #     QAbstractItemView.SingleSelection  # 单选
  67.         # )
  68.  
  69.  
  70.         self.actionMenuExit.triggered.connect(lambda: self.Close())
  71.         self.actionMenuOpen.triggered.connect(lambda: self.Import())
  72.         self.actionMenuAdd.triggered.connect(lambda: self.Project_Add())
  73.         self.actionMenuChange.triggered.connect(lambda: self.Project_Change())
  74.         self.actionquestion.triggered.connect(lambda: self.question())
  75.  
  76.         # self.Show()
  77.         # self.pButtonshow.setVisible(False)
  78.  
  79.         self.tableWidget.setContextMenuPolicy(Qt.CustomContextMenu)
  80.         self.tableWidget.customContextMenuRequested.connect(self.menu_pop)
  81.  
  82. ########################################################################################################################
  83. # 显示all_projects的数据
  84.     def Show(self, actionGl=False):
  85.         db_file = os.path.join(self.cur_dir, './data/my_All_Projects.db')
  86.         try:
  87.             if actionGl == True:
  88.                 while self.tableWidget.rowCount() > 0:
  89.                     self.tableWidget.removeRow(0)
  90.                 self.tableWidget.setRowCount(0)
  91.             conn = sqlite3.connect(db_file)
  92.             cur = conn.cursor()
  93.             sql = '''
  94.                    select  Id, Type, Name, Start_date, End_date, Progress, Manager, Level, Remark
  95.                    from project
  96.                   '''
  97.             cur.execute(sql)
  98.             stu = cur.fetchone()
  99.             row_index = 0
  100.             while stu:
  101.                 self.tableWidget.insertRow(row_index)
  102.                 for colIdx, data in enumerate(stu):
  103.                     TblItem = QTableWidgetItem(str(data))
  104.                     self.tableWidget.setItem(row_index, colIdx, TblItem)
  105.                 stu = cur.fetchone()
  106.                 row_index = row_index + 1
  107.             self.tableWidget.horizontalHeader().setSectionResizeMode(QHeaderView.Stretch)
  108.         except Exception as e:
  109.             print(e)
  110.         finally:
  111.             cur.close()
  112.             conn.close()
  113.             cur = None
  114.             conn = None
  115. ########################################################################################################################
  116. # 导入all_Projects的数据
  117.     def Import(self):
  118.         # 选择要导入的CSV文件
  119.         csv_file, _ = QFileDialog.getOpenFileName(None, '选择 CSV 文件', '', 'CSV 文件(*.csv)')
  120.  
  121.         if not csv_file:
  122.             return
  123.  
  124.         # 获取导入数据库路径
  125.         # db_file, _ = QFileDialog.getOpenFileName(None, '选择数据库文件', '', 'SQLite 数据库(*.db *.sqlite)')
  126.         db_file = os.path.join(self.cur_dir, './data/my_All_Projects.db')
  127.  
  128.         if not db_file:
  129.             return
  130.  
  131.         try:
  132.             # 连接数据库并创建表格
  133.             conn = sqlite3.connect(db_file)
  134.             cur = conn.cursor()
  135.             # cur.execute(
  136.             #     'CREATE TABLE IF NOT EXISTS my_table (id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT, age INTEGER)')
  137.  
  138.             # 读取CSV文件并插入数据
  139.             with open(csv_file, 'r') as f:
  140.                 reader = csv.reader(f)
  141.                 for row in reader:
  142.                     cur.execute(
  143.                         'INSERT INTO project (Id, Type, Name, Start_date, End_date, Progress, Manager, Level, Remark) SELECT ?, ?, ?, ?, ?, ?, ?, ?, ? WHERE NOT EXISTS (SELECT 1 FROM project WHERE Id = ?)',
  144.                         (row[0], row[1], row[2], row[3], row[4], row[5], row[6], row[7], row[8], row[0]))
  145.  
  146.             conn.commit()
  147.             QMessageBox.information(None, '导入成功', '数据已成功导入到SQLite数据库中！')
  148.         except Exception as e:
  149.             conn.rollback()
  150.             QMessageBox.warning(None, '导入失败', '导入过程中发生错误：{}'.format(str(e)))
  151.         finally:
  152.             cur.close()
  153.             conn.close()
  154.  
  155.             # opened_file = QFileDialog().getOpenFileName(
  156.         #     parent=self,
  157.         #     caption='选择要导入的文件',
  158.         #     dir=self.cur_dir,
  159.         #     filter='CSV文件(*.csv);;文本文件(*.txt)'
  160.         # )
  161.         # if len(opened_file[0]) > 0:
  162.         #     db_file = os.path.join(self.cur_dir, './data/all_projects.db')
  163.         #     try:
  164.         #         conn = sqlite3.connect(db_file)
  165.         #         cur = conn.cursor()
  166.         #         sql = '''
  167.         #               INSERT INTO project (Id, Type, Name, Start_date, End_date, Progress, Manager, Level, Remark)
  168.         #               VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
  169.         #               '''
  170.         #         data = open(opened_file[0], mode='rb').read()
  171.         #         encoding = chardet.detect(data).get('encoding')
  172.         #         with open(opened_file[0], mode='r', encoding=encoding) as f:
  173.         #             csv_reader = csv.DictReader(f)
  174.         #             rows = []
  175.         #             for row in csv_reader:
  176.         #                 rows.append((row['项目编号'], row['项目类型'], row['项目名称'],
  177.         #                 row['开始日期'], row['结束日期'], row['完成进度'], row['负责人'],
  178.         #                 row['项目级别'], row['备注']))
  179.         #             cur.executemany(sql, rows)
  180.         #         conn.commit()
  181.         #         QMessageBox.information(self, '消息', '导入成功！')
  182.  
  183.                 #self.db2screen()
  184.  
  185.             # except Exception as e:
  186.             #     conn.rollback()
  187.             #     QMessageBox.critical(self, '错误', '导入失败！' + str(e))
  188.             # finally:
  189.             #     cur.close()
  190.             #     conn.close()
  191.             #     cur = None
  192.             #     conn = None
  193. ########################################################################################################################
  194. # 添加项目
  195.     def Project_Add(self):
  196.         self.stuAction = 'Add'
  197.         self.gl_win = DetailWind()
  198.         self.gl_win.setModal(True)
  199.         self.gl_win.show()
  200.         self.mainSignal.connect(self.gl_win.handle_main_signal)
  201.         self.mainSignal.emit(self.stuAction, None)
  202.         self.gl_win.detailSiganl.connect(self.Show)
  203. ########################################################################################################################
  204. # 修改项目
  205.     def Project_Change(self):
  206.         self.stuAction = 'Change'
  207.         selected_ranges = self.tableWidget.selectedRanges()
  208.  
  209.         if len(selected_ranges) > 1 or len(selected_ranges) == 0:
  210.             QMessageBox.warning(self, '警告', '请选择一行')
  211.             return
  212.  
  213.         self.gl_win = DetailWind()
  214.         self.gl_win.setModal(True)
  215.         self.gl_win.show()
  216.         self.mainSignal.connect(self.gl_win.handle_main_signal)
  217.  
  218.         stu = {}
  219.         current_row = self.tableWidget.currentRow()
  220.         for c in range(self.tableWidget.columnCount()):
  221.             item_data = self.tableWidget.item(current_row, c).text()
  222.             item_name = self.tableWidget.horizontalHeaderItem(c).text()
  223.             stu[item_name] = item_data
  224.  
  225.         self.mainSignal.emit(self.stuAction, stu)
  226.         self.gl_win.detailSiganl.connect(self.Show)
  227. ########################################################################################################################
  228. # 右键菜单
  229.     def menu_pop(self, pos):
  230.         row = self.tableWidget.currentRow()
  231.         stu = {}
  232.         for col in range(self.tableWidget.columnCount()):
  233.             col_name = self.tableWidget.horizontalHeaderItem(col).text()
  234.             col_value = self.tableWidget.item(row, col).text()
  235.             stu[col_name] = col_value
  236.  
  237.         menu = QMenu()
  238.         actionAdd = menu.addAction(u'添加')
  239.         actionEdit = menu.addAction(u'编辑')
  240.         actionDel = menu.addAction(u'删除')
  241.  
  242.         actionName = menu.exec_(self.tableWidget.mapToGlobal(pos))
  243.         if actionName == actionAdd:
  244.             self.Project_Add()
  245.         elif actionName == actionEdit:
  246.             self.Project_Change()
  247.         elif actionName == actionDel:
  248.             stu_People = stu['负责人']
  249.             stu_No = stu['项目编号']
  250.             answer = QMessageBox.question(
  251.                 self,
  252.                 '确认删除',
  253.                 '是否删除{}行的项目'.format(row+1, stu_People),
  254.                 QMessageBox.Yes | QMessageBox.No
  255.             )
  256.             if answer == QMessageBox.No:
  257.                 return
  258.             self.tableWidget.removeRow(row)
  259.             self.del_from_db(stu_No)
  260. ########################################################################################################################
  261. # 右键菜单中的删除键所使用的功能
  262.     def del_from_db(self, stu_No):
  263.         conn, cur = None, None
  264.         try:
  265.             db_file = os.path.join(self.cur_dir, './data/my_All_Projects.db')
  266.             conn = sqlite3.connect(db_file)
  267.             cur = conn.cursor()
  268.             sql = '''
  269.                     delete from project where Id = '{}'
  270.                   '''.format(stu_No)
  271.             cur.execute(sql)
  272.             conn.commit()
  273.             QMessageBox.information(
  274.                 self,
  275.                 '删除成功',
  276.                 '成功删除项目:{}!'.format(stu_No),
  277.                 QMessageBox.Ok
  278.             )
  279.         except Exception as e:
  280.             conn.rollback()
  281.             QMessageBox.critical(
  282.                 self,
  283.                 '删除失败！',
  284.                 str(e),
  285.                 QMessageBox.Ok
  286.             )
  287.         finally:
  288.             cur.close()
  289.             conn.close()
  290.             cur = None
  291.             conn = None
  292. ########################################################################################################################
  293. # 退出系统
  294.     def Close(self):
  295.         reply = QMessageBox.question(self,'关闭提示',"是否要退出界面?",
  296.                                      QMessageBox.Yes | QMessageBox.No, QMessageBox.No)
  297.         if reply == QMessageBox.Yes:
  298.             self.close()
  299.         elif reply == QMessageBox.No:
  300.             return
  301. ########################################################################################################################
  302. # 导出项目
  303.     def Export(self):
  304.         # 选择要导出的数据库文件
  305.         # db_file, _ = QFileDialog.getOpenFileName(None, '选择数据库文件', '', 'SQLite 数据库(*.db *.sqlite)')
  306.         db_file = os.path.join(self.cur_dir, './data/my_All_Projects.db')
  307.  
  308.         if not db_file:
  309.             return
  310.  
  311.         # 获取导出路径
  312.         csv_file, _ = QFileDialog.getSaveFileName(None, '保存 CSV 文件', '', 'CSV 文件(*.csv)')
  313.  
  314.         if not csv_file:
  315.             return
  316.  
  317.         try:
  318.             # 连接数据库并查询数据
  319.             conn = sqlite3.connect(db_file)
  320.             cur = conn.cursor()
  321.             cur.execute('SELECT * FROM project')
  322.             data = cur.fetchall()
  323.  
  324.             # 将数据写入CSV文件
  325.             with open(csv_file, 'w', newline='') as f:
  326.                 writer = csv.writer(f)
  327.                 writer.writerow([i[0] for i in cur.description])  # 写入表头
  328.                 for row in data:
  329.                     writer.writerow(row)
  330.  
  331.             QMessageBox.information(None, '导出成功', '数据已成功导出到CSV文件中！')
  332.         except Exception as e:
  333.             QMessageBox.warning(None, '导出失败', '导出过程中发生错误：{}'.format(str(e)))
  334.         finally:
  335.             cur.close()
  336.             conn.close()
  337. ########################################################################################################################
  338. # 搜索项目
  339.     def Select(self):
  340.         self.se_win = Searchwind()
  341.         self.se_win.setModal(True)
  342.         self.se_win.show()
  343. #     def Select(self):
  344. #         e = 0
  345. #         root = Tk()
  346. #         root.title("查询项目")
  347. #         Label(root, text='输入项目编号:').grid(row=0, column=0)
  348. #         e1 = Entry(root)
  349. #         e1.grid(row=0, column=1, padx=10, pady=5)
  350. #
  351. #         def showData(e):
  352. #             dept = str(e1.get())
  353. #             db_file = os.path.join(self.cur_dir, './data/my_All_Projects.db')
  354. #             conn = sqlite3.connect(db_file)
  355. #             cur = conn.cursor()
  356. #             sql = '''
  357. #                     select  Id, Type, Name, Start_date, End_date, Progress, Manager, Level, Remark
  358. #                     from project
  359. #                     where Id = ?
  360. #                   '''
  361. #             cur.execute(sql, (dept,))
  362. #             data = cur.fetchone()
  363. #             if data:
  364. #                 messagebox.showinfo("查询结果", "{}".format(data))
  365. #             else:
  366. #                 messagebox.showwarning("查询结果", "未查询到相关信息")
  367. #
  368. #             cur.close()
  369. #             conn.close()
  370. #
  371. #         bTnOk = Button(text='查询')
  372. #         bTnOk.grid(row=3, column=1)
  373. #         bTnOk.bind("<Button-1>", showData)
  374. #         mainloop()
  375. ########################################################################################################################
  376.     def question(self):
  377.         self.que_win = qwind()
  378.         self.que_win.setModal(True)
  379.         self.que_win.show()
  380. ########################################################################################################################
  381.     def yh_login_Signal(self, yhActionName:str):
  382.         self.YhName = yhActionName
  383.         self.lineEditUser_Id.setText('欢迎！'+ self.YhName)
  384.         # print(self.YhName)
  385.         # print(type(self.YhName))
  386.         conn = sqlite3.connect(os.path.join(self.cur_dir, './data/user_password.db'))
  387.         c = conn.cursor()
  388.  
  389.         sql_add = f"select add_right from all_user where username='{self.YhName}'"
  390.         sql_change = f"select change_right from all_user where username='{self.YhName}'"
  391.         sql_import = f"select import_right from all_user where username='{self.YhName}'"
  392.         sql_export = f"select export_right from all_user where username='{self.YhName}'"
  393.         cursor_add = c.execute(sql_add)
  394.         result_add = cursor_add.fetchone()                 # 返回元组，取第一个值
  395.         # print(result_add[0])
  396.         # print(type(result_add[0]))
  397.  
  398.         cursor_change = c.execute(sql_change)
  399.         result_change = cursor_change.fetchone()
  400.  
  401.         cursor_import = c.execute(sql_import)
  402.         result_import = cursor_import.fetchone()
  403.  
  404.         cursor_export = c.execute(sql_export)
  405.         result_export = cursor_export.fetchone()
  406.  
  407.         if result_add[0] == 'F':
  408.             self.pButtonAdd.setVisible(False)
  409.         else:
  410.             self.pButtonAdd.setVisible(True)
  411.  
  412.         if result_change[0] == 'F':
  413.             self.pButtonchange.setVisible(False)
  414.         else:
  415.             self.pButtonchange.setVisible(True)
  416.  
  417.         if result_import[0] == 'F':
  418.             self.pButtonImport.setVisible(False)
  419.         else:
  420.             self.pButtonImport.setVisible(True)
  421.  
  422.         if result_export[0] == 'F':
  423.             self.pButtonAdd.setVisible(False)
  424.         else:
  425.             self.pButtonAdd.setVisible(True)
  426.  
  427.  
  428.  
  429.  
  430.  
  431.  
  432.  
  433. if __name__ == '__main__':
  434.     app = QApplication(sys.argv)
  435.     win_main = MainWindow()
  436.     win_main.show()
  437.     sys.exit(app.exec_())

 6）管理员主界面----用户管理

ui_control_user.py
  1. # -*- coding: utf-8 -*-
  2.  
  3. ################################################################################
  4. ## Form generated from reading UI file 'control_user.ui'
  5. ##
  6. ## Created by: Qt User Interface Compiler version 5.15.2
  7. ##
  8. ## WARNING! All changes made in this file will be lost when recompiling UI file!
  9. ################################################################################
  10.  
  11. from PySide2.QtCore import *
  12. from PySide2.QtGui import *
  13. from PySide2.QtWidgets import *
  14.  
  15.  
  16. class Ui_MainWindow(object):
  17.     def setupUi(self, MainWindow):
  18.         if not MainWindow.objectName():
  19.             MainWindow.setObjectName(u"MainWindow")
  20.         MainWindow.resize(1242, 687)
  21.         self.actionTlbAdd = QAction(MainWindow)
  22.         self.actionTlbAdd.setObjectName(u"actionTlbAdd")
  23.         self.actionTlbChange = QAction(MainWindow)
  24.         self.actionTlbChange.setObjectName(u"actionTlbChange")
  25.         self.actionTlbSearch = QAction(MainWindow)
  26.         self.actionTlbSearch.setObjectName(u"actionTlbSearch")
  27.         self.actionMenuopen = QAction(MainWindow)
  28.         self.actionMenuopen.setObjectName(u"actionMenuopen")
  29.         self.actionMenuexport = QAction(MainWindow)
  30.         self.actionMenuexport.setObjectName(u"actionMenuexport")
  31.         self.actionMenuExport = QAction(MainWindow)
  32.         self.actionMenuExport.setObjectName(u"actionMenuExport")
  33.         self.centralwidget = QWidget(MainWindow)
  34.         self.centralwidget.setObjectName(u"centralwidget")
  35.         self.layoutWidget = QWidget(self.centralwidget)
  36.         self.layoutWidget.setObjectName(u"layoutWidget")
  37.         self.layoutWidget.setGeometry(QRect(0, 0, 1241, 611))
  38.         self.verticalLayout_4 = QVBoxLayout(self.layoutWidget)
  39.         self.verticalLayout_4.setObjectName(u"verticalLayout_4")
  40.         self.verticalLayout_4.setContentsMargins(0, 0, 0, 0)
  41.         self.horizontalLayout = QHBoxLayout()
  42.         self.horizontalLayout.setObjectName(u"horizontalLayout")
  43.         self.horizontalSpacer = QSpacerItem(40, 20, QSizePolicy.Expanding, QSizePolicy.Minimum)
  44.  
  45.         self.horizontalLayout.addItem(self.horizontalSpacer)
  46.  
  47.         self.label = QLabel(self.layoutWidget)
  48.         self.label.setObjectName(u"label")
  49.         font = QFont()
  50.         font.setFamily(u"Agency FB")
  51.         font.setPointSize(26)
  52.         font.setBold(True)
  53.         font.setWeight(75)
  54.         self.label.setFont(font)
  55.  
  56.         self.horizontalLayout.addWidget(self.label)
  57.  
  58.         self.horizontalSpacer_2 = QSpacerItem(40, 20, QSizePolicy.Expanding, QSizePolicy.Minimum)
  59.  
  60.         self.horizontalLayout.addItem(self.horizontalSpacer_2)
  61.  
  62.  
  63.         self.verticalLayout_4.addLayout(self.horizontalLayout)
  64.  
  65.         self.verticalSpacer_5 = QSpacerItem(20, 20, QSizePolicy.Minimum, QSizePolicy.Fixed)
  66.  
  67.         self.verticalLayout_4.addItem(self.verticalSpacer_5)
  68.  
  69.         self.horizontalLayout_2 = QHBoxLayout()
  70.         self.horizontalLayout_2.setObjectName(u"horizontalLayout_2")
  71.         self.tableWidget = QTableWidget(self.layoutWidget)
  72.         if (self.tableWidget.columnCount() < 9):
  73.             self.tableWidget.setColumnCount(9)
  74.         __qtablewidgetitem = QTableWidgetItem()
  75.         self.tableWidget.setHorizontalHeaderItem(0, __qtablewidgetitem)
  76.         __qtablewidgetitem1 = QTableWidgetItem()
  77.         self.tableWidget.setHorizontalHeaderItem(1, __qtablewidgetitem1)
  78.         __qtablewidgetitem2 = QTableWidgetItem()
  79.         self.tableWidget.setHorizontalHeaderItem(2, __qtablewidgetitem2)
  80.         __qtablewidgetitem3 = QTableWidgetItem()
  81.         self.tableWidget.setHorizontalHeaderItem(3, __qtablewidgetitem3)
  82.         __qtablewidgetitem4 = QTableWidgetItem()
  83.         self.tableWidget.setHorizontalHeaderItem(4, __qtablewidgetitem4)
  84.         __qtablewidgetitem5 = QTableWidgetItem()
  85.         self.tableWidget.setHorizontalHeaderItem(5, __qtablewidgetitem5)
  86.         __qtablewidgetitem6 = QTableWidgetItem()
  87.         self.tableWidget.setHorizontalHeaderItem(6, __qtablewidgetitem6)
  88.         __qtablewidgetitem7 = QTableWidgetItem()
  89.         self.tableWidget.setHorizontalHeaderItem(7, __qtablewidgetitem7)
  90.         __qtablewidgetitem8 = QTableWidgetItem()
  91.         self.tableWidget.setHorizontalHeaderItem(8, __qtablewidgetitem8)
  92.         self.tableWidget.setObjectName(u"tableWidget")
  93.  
  94.         self.horizontalLayout_2.addWidget(self.tableWidget)
  95.  
  96.         self.verticalLayout_3 = QVBoxLayout()
  97.         self.verticalLayout_3.setObjectName(u"verticalLayout_3")
  98.         self.verticalSpacer_4 = QSpacerItem(20, 40, QSizePolicy.Minimum, QSizePolicy.Expanding)
  99.  
  100.         self.verticalLayout_3.addItem(self.verticalSpacer_4)
  101.  
  102.         self.pButtonSelect = QPushButton(self.layoutWidget)
  103.         self.pButtonSelect.setObjectName(u"pButtonSelect")
  104.  
  105.         self.verticalLayout_3.addWidget(self.pButtonSelect)
  106.  
  107.         self.verticalSpacer_6 = QSpacerItem(20, 20, QSizePolicy.Minimum, QSizePolicy.Fixed)
  108.  
  109.         self.verticalLayout_3.addItem(self.verticalSpacer_6)
  110.  
  111.         self.verticalLayout_2 = QVBoxLayout()
  112.         self.verticalLayout_2.setObjectName(u"verticalLayout_2")
  113.         self.verticalLayout = QVBoxLayout()
  114.         self.verticalLayout.setObjectName(u"verticalLayout")
  115.         self.pButtonDisplay = QPushButton(self.layoutWidget)
  116.         self.pButtonDisplay.setObjectName(u"pButtonDisplay")
  117.  
  118.         self.verticalLayout.addWidget(self.pButtonDisplay)
  119.  
  120.         self.verticalSpacer = QSpacerItem(20, 20, QSizePolicy.Minimum, QSizePolicy.Fixed)
  121.  
  122.         self.verticalLayout.addItem(self.verticalSpacer)
  123.  
  124.         self.pButtonChange = QPushButton(self.layoutWidget)
  125.         self.pButtonChange.setObjectName(u"pButtonChange")
  126.  
  127.         self.verticalLayout.addWidget(self.pButtonChange)
  128.  
  129.  
  130.         self.verticalLayout_2.addLayout(self.verticalLayout)
  131.  
  132.         self.verticalSpacer_2 = QSpacerItem(20, 20, QSizePolicy.Minimum, QSizePolicy.Fixed)
  133.  
  134.         self.verticalLayout_2.addItem(self.verticalSpacer_2)
  135.  
  136.         self.pButtonAdd = QPushButton(self.layoutWidget)
  137.         self.pButtonAdd.setObjectName(u"pButtonAdd")
  138.  
  139.         self.verticalLayout_2.addWidget(self.pButtonAdd)
  140.  
  141.         self.verticalSpacer_7 = QSpacerItem(20, 20, QSizePolicy.Minimum, QSizePolicy.Fixed)
  142.  
  143.         self.verticalLayout_2.addItem(self.verticalSpacer_7)
  144.  
  145.         self.pButtonImport = QPushButton(self.layoutWidget)
  146.         self.pButtonImport.setObjectName(u"pButtonImport")
  147.  
  148.         self.verticalLayout_2.addWidget(self.pButtonImport)
  149.  
  150.         self.verticalSpacer_8 = QSpacerItem(20, 20, QSizePolicy.Minimum, QSizePolicy.Fixed)
  151.  
  152.         self.verticalLayout_2.addItem(self.verticalSpacer_8)
  153.  
  154.         self.pButtonExit = QPushButton(self.layoutWidget)
  155.         self.pButtonExit.setObjectName(u"pButtonExit")
  156.  
  157.         self.verticalLayout_2.addWidget(self.pButtonExit)
  158.  
  159.  
  160.         self.verticalLayout_3.addLayout(self.verticalLayout_2)
  161.  
  162.  
  163.         self.horizontalLayout_2.addLayout(self.verticalLayout_3)
  164.  
  165.  
  166.         self.verticalLayout_4.addLayout(self.horizontalLayout_2)
  167.  
  168.         MainWindow.setCentralWidget(self.centralwidget)
  169.         self.menubar = QMenuBar(MainWindow)
  170.         self.menubar.setObjectName(u"menubar")
  171.         self.menubar.setGeometry(QRect(0, 0, 1242, 26))
  172.         self.menufile = QMenu(self.menubar)
  173.         self.menufile.setObjectName(u"menufile")
  174.         self.menuhelp = QMenu(self.menubar)
  175.         self.menuhelp.setObjectName(u"menuhelp")
  176.         MainWindow.setMenuBar(self.menubar)
  177.         self.statusbar = QStatusBar(MainWindow)
  178.         self.statusbar.setObjectName(u"statusbar")
  179.         MainWindow.setStatusBar(self.statusbar)
  180.         self.toolBar = QToolBar(MainWindow)
  181.         self.toolBar.setObjectName(u"toolBar")
  182.         MainWindow.addToolBar(Qt.TopToolBarArea, self.toolBar)
  183.  
  184.         self.menubar.addAction(self.menufile.menuAction())
  185.         self.menubar.addAction(self.menuhelp.menuAction())
  186.         self.menufile.addAction(self.actionMenuopen)
  187.         self.menufile.addAction(self.actionMenuExport)
  188.         self.toolBar.addAction(self.actionTlbAdd)
  189.         self.toolBar.addAction(self.actionTlbChange)
  190.         self.toolBar.addAction(self.actionTlbSearch)
  191.  
  192.         self.retranslateUi(MainWindow)
  193.  
  194.         QMetaObject.connectSlotsByName(MainWindow)
  195.     # setupUi
  196.  
  197.     def retranslateUi(self, MainWindow):
  198.         MainWindow.setWindowTitle(QCoreApplication.translate("MainWindow", u"\u7528\u6237\u7ba1\u7406", None))
  199.         self.actionTlbAdd.setText(QCoreApplication.translate("MainWindow", u"\u6dfb\u52a0", None))
  200.         self.actionTlbChange.setText(QCoreApplication.translate("MainWindow", u"\u4fee\u6539", None))
  201.         self.actionTlbSearch.setText(QCoreApplication.translate("MainWindow", u"\u641c\u7d22", None))
  202.         self.actionMenuopen.setText(QCoreApplication.translate("MainWindow", u"\u6253\u5f00", None))
  203.         self.actionMenuexport.setText(QCoreApplication.translate("MainWindow", u"\u5bfc\u51fa", None))
  204.         self.actionMenuExport.setText(QCoreApplication.translate("MainWindow", u"\u5bfc\u51fa", None))
  205.         self.label.setText(QCoreApplication.translate("MainWindow", u"\u7528\u6237\u7ba1\u7406", None))
  206.         ___qtablewidgetitem = self.tableWidget.horizontalHeaderItem(0)
  207.         ___qtablewidgetitem.setText(QCoreApplication.translate("MainWindow", u"\u7528\u6237\u7c7b\u578b", None));
  208.         ___qtablewidgetitem1 = self.tableWidget.horizontalHeaderItem(1)
  209.         ___qtablewidgetitem1.setText(QCoreApplication.translate("MainWindow", u"\u7528\u6237\u540d", None));
  210.         ___qtablewidgetitem2 = self.tableWidget.horizontalHeaderItem(2)
  211.         ___qtablewidgetitem2.setText(QCoreApplication.translate("MainWindow", u"\u7528\u6237\u5bc6\u7801", None));
  212.         ___qtablewidgetitem3 = self.tableWidget.horizontalHeaderItem(3)
  213.         ___qtablewidgetitem3.setText(QCoreApplication.translate("MainWindow", u"\u767b\u5f55\u6b21\u6570", None));
  214.         ___qtablewidgetitem4 = self.tableWidget.horizontalHeaderItem(4)
  215.         ___qtablewidgetitem4.setText(QCoreApplication.translate("MainWindow", u"\u4e0a\u4e00\u6b21\u767b\u5f55\u65f6\u95f4", None));
  216.         ___qtablewidgetitem5 = self.tableWidget.horizontalHeaderItem(5)
  217.         ___qtablewidgetitem5.setText(QCoreApplication.translate("MainWindow", u"\u6dfb\u52a0", None));
  218.         ___qtablewidgetitem6 = self.tableWidget.horizontalHeaderItem(6)
  219.         ___qtablewidgetitem6.setText(QCoreApplication.translate("MainWindow", u"\u4fee\u6539", None));
  220.         ___qtablewidgetitem7 = self.tableWidget.horizontalHeaderItem(7)
  221.         ___qtablewidgetitem7.setText(QCoreApplication.translate("MainWindow", u"\u5bfc\u5165", None));
  222.         ___qtablewidgetitem8 = self.tableWidget.horizontalHeaderItem(8)
  223.         ___qtablewidgetitem8.setText(QCoreApplication.translate("MainWindow", u"\u5bfc\u51fa", None));
  224.         self.pButtonSelect.setText(QCoreApplication.translate("MainWindow", u"\u641c\u7d22\u7528\u6237", None))
  225.         self.pButtonDisplay.setText(QCoreApplication.translate("MainWindow", u"\u663e\u793a\u7528\u6237", None))
  226.         self.pButtonChange.setText(QCoreApplication.translate("MainWindow", u"\u4fee\u6539\u7528\u6237", None))
  227.         self.pButtonAdd.setText(QCoreApplication.translate("MainWindow", u"\u6dfb\u52a0\u7528\u6237", None))
  228.         self.pButtonImport.setText(QCoreApplication.translate("MainWindow", u"\u5bfc\u5165\u7528\u6237", None))
  229.         self.pButtonExit.setText(QCoreApplication.translate("MainWindow", u"\u9000\u51fa\u7cfb\u7edf", None))
  230.         self.menufile.setTitle(QCoreApplication.translate("MainWindow", u"\u6587\u4ef6", None))
  231.         self.menuhelp.setTitle(QCoreApplication.translate("MainWindow", u"\u5e2e\u52a9", None))
  232.         self.toolBar.setWindowTitle(QCoreApplication.translate("MainWindow", u"toolBar", None))
  233.     # retranslateUi
  234.  
control_user.py
  1. from PySide2.QtWidgets import QApplication
  2. from PySide2.QtWidgets import QMainWindow
  3. from PySide2.QtWidgets import QTableWidget, QTableWidgetItem
  4. from PySide2.QtWidgets import QAbstractItemView, QLineEdit, QPushButton
  5. import sys, os
  6. from PySide2.QtWidgets import QHeaderView
  7. import sqlite3
  8. from PySide2.QtWidgets import QFileDialog, QMessageBox, QMenu
  9. import chardet, csv
  10. from PySide2.QtCore import Signal, Qt
  11. from tkinter import *
  12. from tkinter import messagebox
  13. from PySide2.QtGui import Qt, QIcon # 图标、窗体设置
  14. from main_body.ui_control_user import Ui_MainWindow
  15. from control_gl import DetailWindow as DetailWind
  16.  
  17. class MainWindow(QMainWindow, Ui_MainWindow):
  18.     mainSignal = Signal(str, dict)
  19.     def __init__(self):
  20.         super(MainWindow, self).__init__()
  21.         self.setupUi(self)
  22.  
  23.         self.cur_dir = os.path.dirname(os.path.abspath(__file__))
  24.  
  25.         # 设置窗体图标
  26.         app_icon = QIcon('项目新.ico')
  27.         self.setWindowIcon(app_icon)
  28.  
  29.         self.pButtonExit.clicked.connect(lambda: self.Close())
  30.         self.pButtonDisplay.clicked.connect(lambda: self.Show())
  31.  
  32.         self.user_win = None
  33.         self.pButtonAdd.clicked.connect(lambda: self.User_Add())
  34.         self.pButtonChange.clicked.connect(lambda: self.User_Change())
  35.         self.pButtonSelect.clicked.connect(lambda: self.Select())
  36.         self.pButtonImport.clicked.connect(lambda: self.Import())
  37.  
  38.         self.stuAction = None
  39.  
  40.         self.tableWidget.setSelectionBehavior(QAbstractItemView.SelectRows)
  41.         self.tableWidget.setSelectionMode(QAbstractItemView.SingleSelection)
  42.  
  43.         self.actionTlbSearch.triggered.connect(lambda: self.Select())
  44.         self.actionMenuopen.triggered.connect(lambda: self.Import())
  45.         self.actionMenuExport.triggered.connect(lambda: self.Export())
  46.         self.actionTlbAdd.triggered.connect(lambda: self.User_Add())
  47.         self.actionTlbChange.triggered.connect(lambda: self.User_Change())
  48.         # 右键菜单
  49.         self.tableWidget.setContextMenuPolicy(Qt.CustomContextMenu)
  50.         self.tableWidget.customContextMenuRequested.connect(self.menu_pop)
  51.  
  52.     def Show(self, actionGl=False):
  53.         db_file = os.path.join(self.cur_dir, './data/user_password.db')
  54.         try:
  55.             if actionGl == True:
  56.                 while self.tableWidget.rowCount() > 0:
  57.                     self.tableWidget.removeRow(0)
  58.                 self.tableWidget.setRowCount(0)
  59.             conn = sqlite3.connect(db_file)
  60.             cur = conn.cursor()
  61.             sql = '''
  62.                    select  *
  63.                    from all_user
  64.                   '''
  65.             cur.execute(sql)
  66.             stu = cur.fetchone()
  67.             row_index = 0
  68.             while stu:
  69.                 self.tableWidget.insertRow(row_index)
  70.                 for colIdx, data in enumerate(stu):
  71.                     TblItem = QTableWidgetItem(str(data))
  72.                     self.tableWidget.setItem(row_index, colIdx, TblItem)
  73.                 stu = cur.fetchone()
  74.                 row_index = row_index + 1
  75.             self.tableWidget.horizontalHeader().setSectionResizeMode(QHeaderView.Stretch)
  76.         except Exception as e:
  77.             print(e)
  78.         finally:
  79.             cur.close()
  80.             conn.close()
  81.             cur = None
  82.             conn = None
  83.  
  84. # 添加用户
  85.     def User_Add(self):
  86.         self.stuAction = 'Add'
  87.         self.gl_win = DetailWind()
  88.         self.gl_win.setModal(True)
  89.         self.gl_win.show()
  90.         self.mainSignal.connect(self.gl_win.handle_main_signal)
  91.         self.mainSignal.emit(self.stuAction, None)
  92.         self.gl_win.detailSiganl.connect(self.Show)
  93.  
  94.  
  95. # 修改用户
  96.     def User_Change(self):
  97.         self.stuAction = 'Change'
  98.         selected_ranges = self.tableWidget.selectedRanges()
  99.  
  100.         if len(selected_ranges) > 1 or len(selected_ranges) == 0:
  101.             QMessageBox.warning(self, '警告', '请选择一行')
  102.             return
  103.  
  104.         self.gl_win = DetailWind()
  105.         self.gl_win.setModal(True)
  106.         self.gl_win.show()
  107.         self.mainSignal.connect(self.gl_win.handle_main_signal)
  108.  
  109.         stu = {}
  110.         current_row = self.tableWidget.currentRow()
  111.         for c in range(self.tableWidget.columnCount()):
  112.             item_data = self.tableWidget.item(current_row, c).text()
  113.             item_name = self.tableWidget.horizontalHeaderItem(c).text()
  114.             stu[item_name] = item_data
  115.  
  116.         self.mainSignal.emit(self.stuAction, stu)
  117.         self.gl_win.detailSiganl.connect(self.Show)
  118.  
  119.  
  120. # 退出系统
  121.     def Close(self):
  122.         reply = QMessageBox.question(self,'关闭提示',"是否要退出界面?",
  123.                                      QMessageBox.Yes | QMessageBox.No, QMessageBox.No)
  124.         if reply == QMessageBox.Yes:
  125.             self.close()
  126.         elif reply == QMessageBox.No:
  127.             return
  128.  
  129.     def Select(self):
  130.         e = 0
  131.         root = Tk()
  132.         root.title("查询项目")
  133.         Label(root, text='输入项目编号:').grid(row=0, column=0)
  134.         e1 = Entry(root)
  135.         e1.grid(row=0, column=1, padx=10, pady=5)
  136.  
  137.         def showData(e):
  138.             dept = str(e1.get())
  139.             db_file = os.path.join(self.cur_dir, './data/user_password.db')
  140.             conn = sqlite3.connect(db_file)
  141.             cur = conn.cursor()
  142.             sql = '''
  143.                     select  user_type,username,password,login_times,last_login,add_right,change_right,
  144.                     import_right,export_right
  145.                     from all_user
  146.                     where username = ?
  147.                   '''
  148.             cur.execute(sql, (dept,))
  149.             data = cur.fetchone()
  150.             if data:
  151.                 messagebox.showinfo("查询结果", "用户类型{},用户名{},用户密码{}\n登录次数{},上一次登录时间{}\n添加权限{},修改权限{},导入权限{},导出权限{}".format(data[0],data[1],data[2],data[3],data[4],data[5],data[6],data[7],data[8]))
  152.             else:
  153.                 messagebox.showwarning("查询结果", "未查询到相关信息")
  154.  
  155.             cur.close()
  156.             conn.close()
  157.  
  158.         bTnOk = Button(text='查询')
  159.         bTnOk.grid(row=3, column=1)
  160.         bTnOk.bind("<Button-1>", showData)
  161.         mainloop()
  162.  
  163.  
  164.     def Import(self):
  165.         # 选择要导入的CSV文件
  166.         csv_file, _ = QFileDialog.getOpenFileName(None, '选择 CSV 文件', '', 'CSV 文件(*.csv)')
  167.  
  168.         if not csv_file:
  169.             return
  170.  
  171.         # 获取导入数据库路径
  172.         # db_file, _ = QFileDialog.getOpenFileName(None, '选择数据库文件', '', 'SQLite 数据库(*.db *.sqlite)')
  173.         db_file = os.path.join(self.cur_dir, './data/user_password.db')
  174.  
  175.         if not db_file:
  176.             return
  177.  
  178.         try:
  179.             # 连接数据库并创建表格
  180.             conn = sqlite3.connect(db_file)
  181.             cur = conn.cursor()
  182.             # cur.execute(
  183.             #     'CREATE TABLE IF NOT EXISTS my_table (id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT, age INTEGER)')
  184.  
  185.             # 读取CSV文件并插入数据
  186.             with open(csv_file, 'r') as f:
  187.                 reader = csv.reader(f)
  188.                 for row in reader:
  189.                     cur.execute(
  190.                         'INSERT INTO all_user (user_type,username,password,login_times,last_login) SELECT ?, ?, ?, ?, ? WHERE NOT EXISTS (SELECT 1 FROM all_user WHERE username = ?)',
  191.                         (row[0], row[1], row[2], row[3], row[4], row[0]))
  192.  
  193.             conn.commit()
  194.             QMessageBox.information(None, '导入成功', '数据已成功导入到SQLite数据库中！')
  195.         except Exception as e:
  196.             conn.rollback()
  197.             QMessageBox.warning(None, '导入失败', '导入过程中发生错误：{}'.format(str(e)))
  198.         finally:
  199.             cur.close()
  200.             conn.close()
  201.  
  202.     def Export(self):
  203.         # 选择要导出的数据库文件
  204.         # db_file, _ = QFileDialog.getOpenFileName(None, '选择数据库文件', '', 'SQLite 数据库(*.db *.sqlite)')
  205.         db_file = os.path.join(self.cur_dir, './data/user_password.db')
  206.  
  207.         if not db_file:
  208.             return
  209.  
  210.         # 获取导出路径
  211.         csv_file, _ = QFileDialog.getSaveFileName(None, '保存 CSV 文件', '', 'CSV 文件(*.csv)')
  212.  
  213.         if not csv_file:
  214.             return
  215.  
  216.         try:
  217.             # 连接数据库并查询数据
  218.             conn = sqlite3.connect(db_file)
  219.             cur = conn.cursor()
  220.             cur.execute('SELECT * FROM all_user')
  221.             data = cur.fetchall()
  222.  
  223.             # 将数据写入CSV文件
  224.             with open(csv_file, 'w', newline='') as f:
  225.                 writer = csv.writer(f)
  226.                 writer.writerow([i[0] for i in cur.description])  # 写入表头
  227.                 for row in data:
  228.                     writer.writerow(row)
  229.  
  230.             QMessageBox.information(None, '导出成功', '数据已成功导出到CSV文件中！')
  231.         except Exception as e:
  232.             QMessageBox.warning(None, '导出失败', '导出过程中发生错误：{}'.format(str(e)))
  233.         finally:
  234.             cur.close()
  235.             conn.close()
  236.  
  237.  
  238.     def menu_pop(self, pos):
  239.         row = self.tableWidget.currentRow()
  240.         stu = {}
  241.         for col in range(self.tableWidget.columnCount()):
  242.             col_name = self.tableWidget.horizontalHeaderItem(col).text()
  243.             col_value = self.tableWidget.item(row, col).text()
  244.             stu[col_name] = col_value
  245.  
  246.         menu = QMenu()
  247.         actionAdd = menu.addAction(u'添加')
  248.         actionEdit = menu.addAction(u'编辑')
  249.         actionDel = menu.addAction(u'删除')
  250.  
  251.         actionName = menu.exec_(self.tableWidget.mapToGlobal(pos))
  252.         if actionName == actionAdd:
  253.             self.User_Add()
  254.         elif actionName == actionEdit:
  255.             self.User_Change()
  256.         elif actionName == actionDel:
  257.             stu_People = stu['用户名']
  258.             stu_No = stu['用户密码']
  259.             answer = QMessageBox.question(
  260.                 self,
  261.                 '确认删除',
  262.                 '是否删除{}行的项目'.format(row+1, stu_People),
  263.                 QMessageBox.Yes | QMessageBox.No
  264.             )
  265.             if answer == QMessageBox.No:
  266.                 return
  267.             self.tableWidget.removeRow(row)
  268.             self.del_from_db(stu_No)
  269.  
  270.  
  271.     def del_from_db(self, stu_No):
  272.         conn, cur = None, None
  273.         try:
  274.             db_file = os.path.join(self.cur_dir, './data/user_password.db')
  275.             conn = sqlite3.connect(db_file)
  276.             cur = conn.cursor()
  277.             sql = '''
  278.                     delete from all_user where password = '{}'
  279.                   '''.format(stu_No)
  280.             cur.execute(sql)
  281.             conn.commit()
  282.             QMessageBox.information(
  283.                 self,
  284.                 '删除成功',
  285.                 '成功删除项目:{}!'.format(stu_No),
  286.                 QMessageBox.Ok
  287.             )
  288.         except Exception as e:
  289.             conn.rollback()
  290.             QMessageBox.critical(
  291.                 self,
  292.                 '删除失败！',
  293.                 str(e),
  294.                 QMessageBox.Ok
  295.             )
  296.         finally:
  297.             cur.close()
  298.             conn.close()
  299.             cur = None
  300.             conn = None
  301.  
  302.  
  303. if __name__ == '__main__':
  304.     app = QApplication(sys.argv)
  305.     win_main = MainWindow()
  306.     win_main.show()
  307.     sys.exit(app.exec_())

7）添加界面----项目管理

ui_gl.py
  1. # -*- coding: utf-8 -*-
  2.  
  3. ################################################################################
  4. ## Form generated from reading UI file 'gl.ui'
  5. ##
  6. ## Created by: Qt User Interface Compiler version 5.15.2
  7. ##
  8. ## WARNING! All changes made in this file will be lost when recompiling UI file!
  9. ################################################################################
  10.  
  11. from PySide2.QtCore import *
  12. from PySide2.QtGui import *
  13. from PySide2.QtWidgets import *
  14.  
  15. import picture_rc
  16.  
  17. class Ui_Dialog(object):
  18.     def setupUi(self, Dialog):
  19.         if not Dialog.objectName():
  20.             Dialog.setObjectName(u"Dialog")
  21.         Dialog.resize(892, 787)
  22.         icon = QIcon()
  23.         icon.addFile(u"C:/Users/17844/Desktop/Python\u5927\u4f5c\u4e1a/\u9879\u76ee.ico", QSize(), QIcon.Normal, QIcon.Off)
  24.         Dialog.setWindowIcon(icon)
  25.         self.layoutWidget = QWidget(Dialog)
  26.         self.layoutWidget.setObjectName(u"layoutWidget")
  27.         self.layoutWidget.setGeometry(QRect(1, 1, 891, 785))
  28.         self.verticalLayout_10 = QVBoxLayout(self.layoutWidget)
  29.         self.verticalLayout_10.setObjectName(u"verticalLayout_10")
  30.         self.verticalLayout_10.setContentsMargins(0, 0, 0, 0)
  31.         self.verticalLayout_9 = QVBoxLayout()
  32.         self.verticalLayout_9.setObjectName(u"verticalLayout_9")
  33.         self.horizontalLayout_13 = QHBoxLayout()
  34.         self.horizontalLayout_13.setObjectName(u"horizontalLayout_13")
  35.         self.horizontalSpacer_16 = QSpacerItem(40, 20, QSizePolicy.Expanding, QSizePolicy.Minimum)
  36.  
  37.         self.horizontalLayout_13.addItem(self.horizontalSpacer_16)
  38.  
  39.         self.label_Big_Title = QLabel(self.layoutWidget)
  40.         self.label_Big_Title.setObjectName(u"label_Big_Title")
  41.         font = QFont()
  42.         font.setFamily(u"Agency FB")
  43.         font.setPointSize(14)
  44.         font.setBold(True)
  45.         font.setWeight(75)
  46.         self.label_Big_Title.setFont(font)
  47.  
  48.         self.horizontalLayout_13.addWidget(self.label_Big_Title)
  49.  
  50.         self.horizontalSpacer_17 = QSpacerItem(40, 20, QSizePolicy.Expanding, QSizePolicy.Minimum)
  51.  
  52.         self.horizontalLayout_13.addItem(self.horizontalSpacer_17)
  53.  
  54.  
  55.         self.verticalLayout_9.addLayout(self.horizontalLayout_13)
  56.  
  57.         self.verticalSpacer_9 = QSpacerItem(20, 20, QSizePolicy.Minimum, QSizePolicy.Minimum)
  58.  
  59.         self.verticalLayout_9.addItem(self.verticalSpacer_9)
  60.  
  61.         self.horizontalLayout_14 = QHBoxLayout()
  62.         self.horizontalLayout_14.setObjectName(u"horizontalLayout_14")
  63.         self.horizontalSpacer_18 = QSpacerItem(40, 20, QSizePolicy.Expanding, QSizePolicy.Minimum)
  64.  
  65.         self.horizontalLayout_14.addItem(self.horizontalSpacer_18)
  66.  
  67.         self.verticalLayout_8 = QVBoxLayout()
  68.         self.verticalLayout_8.setObjectName(u"verticalLayout_8")
  69.         self.verticalLayout_7 = QVBoxLayout()
  70.         self.verticalLayout_7.setObjectName(u"verticalLayout_7")
  71.         self.verticalLayout = QVBoxLayout()
  72.         self.verticalLayout.setObjectName(u"verticalLayout")
  73.         self.horizontalLayout_3 = QHBoxLayout()
  74.         self.horizontalLayout_3.setObjectName(u"horizontalLayout_3")
  75.         self.horizontalSpacer_5 = QSpacerItem(40, 20, QSizePolicy.Expanding, QSizePolicy.Minimum)
  76.  
  77.         self.horizontalLayout_3.addItem(self.horizontalSpacer_5)
  78.  
  79.         self.horizontalLayout = QHBoxLayout()
  80.         self.horizontalLayout.setObjectName(u"horizontalLayout")
  81.         self.label_2 = QLabel(self.layoutWidget)
  82.         self.label_2.setObjectName(u"label_2")
  83.         font1 = QFont()
  84.         font1.setFamily(u"Agency FB")
  85.         font1.setPointSize(10)
  86.         self.label_2.setFont(font1)
  87.  
  88.         self.horizontalLayout.addWidget(self.label_2)
  89.  
  90.         self.horizontalSpacer = QSpacerItem(5, 20, QSizePolicy.Expanding, QSizePolicy.Minimum)
  91.  
  92.         self.horizontalLayout.addItem(self.horizontalSpacer)
  93.  
  94.         self.lineEdit_No = QLineEdit(self.layoutWidget)
  95.         self.lineEdit_No.setObjectName(u"lineEdit_No")
  96.  
  97.         self.horizontalLayout.addWidget(self.lineEdit_No)
  98.  
  99.  
  100.         self.horizontalLayout_3.addLayout(self.horizontalLayout)
  101.  
  102.         self.horizontalSpacer_3 = QSpacerItem(40, 20, QSizePolicy.Expanding, QSizePolicy.Minimum)
  103.  
  104.         self.horizontalLayout_3.addItem(self.horizontalSpacer_3)
  105.  
  106.         self.horizontalLayout_2 = QHBoxLayout()
  107.         self.horizontalLayout_2.setObjectName(u"horizontalLayout_2")
  108.         self.label_3 = QLabel(self.layoutWidget)
  109.         self.label_3.setObjectName(u"label_3")
  110.         self.label_3.setFont(font1)
  111.  
  112.         self.horizontalLayout_2.addWidget(self.label_3)
  113.  
  114.         self.horizontalSpacer_2 = QSpacerItem(5, 20, QSizePolicy.Expanding, QSizePolicy.Minimum)
  115.  
  116.         self.horizontalLayout_2.addItem(self.horizontalSpacer_2)
  117.  
  118.         self.lineEdit_Type = QLineEdit(self.layoutWidget)
  119.         self.lineEdit_Type.setObjectName(u"lineEdit_Type")
  120.  
  121.         self.horizontalLayout_2.addWidget(self.lineEdit_Type)
  122.  
  123.  
  124.         self.horizontalLayout_3.addLayout(self.horizontalLayout_2)
  125.  
  126.         self.horizontalSpacer_4 = QSpacerItem(40, 20, QSizePolicy.Expanding, QSizePolicy.Minimum)
  127.  
  128.         self.horizontalLayout_3.addItem(self.horizontalSpacer_4)
  129.  
  130.  
  131.         self.verticalLayout.addLayout(self.horizontalLayout_3)
  132.  
  133.         self.verticalSpacer = QSpacerItem(20, 20, QSizePolicy.Minimum, QSizePolicy.Expanding)
  134.  
  135.         self.verticalLayout.addItem(self.verticalSpacer)
  136.  
  137.         self.horizontalLayout_4 = QHBoxLayout()
  138.         self.horizontalLayout_4.setObjectName(u"horizontalLayout_4")
  139.         self.label_4 = QLabel(self.layoutWidget)
  140.         self.label_4.setObjectName(u"label_4")
  141.  
  142.         self.horizontalLayout_4.addWidget(self.label_4)
  143.  
  144.         self.horizontalSpacer_6 = QSpacerItem(5, 20, QSizePolicy.Minimum, QSizePolicy.Minimum)
  145.  
  146.         self.horizontalLayout_4.addItem(self.horizontalSpacer_6)
  147.  
  148.         self.lineEdit_Name = QLineEdit(self.layoutWidget)
  149.         self.lineEdit_Name.setObjectName(u"lineEdit_Name")
  150.         self.lineEdit_Name.setEnabled(True)
  151.  
  152.         self.horizontalLayout_4.addWidget(self.lineEdit_Name)
  153.  
  154.  
  155.         self.verticalLayout.addLayout(self.horizontalLayout_4)
  156.  
  157.  
  158.         self.verticalLayout_7.addLayout(self.verticalLayout)
  159.  
  160.         self.verticalSpacer_7 = QSpacerItem(20, 40, QSizePolicy.Minimum, QSizePolicy.Expanding)
  161.  
  162.         self.verticalLayout_7.addItem(self.verticalSpacer_7)
  163.  
  164.         self.horizontalLayout_12 = QHBoxLayout()
  165.         self.horizontalLayout_12.setObjectName(u"horizontalLayout_12")
  166.         self.verticalLayout_5 = QVBoxLayout()
  167.         self.verticalLayout_5.setObjectName(u"verticalLayout_5")
  168.         self.verticalLayout_3 = QVBoxLayout()
  169.         self.verticalLayout_3.setObjectName(u"verticalLayout_3")
  170.         self.verticalLayout_2 = QVBoxLayout()
  171.         self.verticalLayout_2.setObjectName(u"verticalLayout_2")
  172.         self.horizontalLayout_11 = QHBoxLayout()
  173.         self.horizontalLayout_11.setObjectName(u"horizontalLayout_11")
  174.         self.label_5 = QLabel(self.layoutWidget)
  175.         self.label_5.setObjectName(u"label_5")
  176.  
  177.         self.horizontalLayout_11.addWidget(self.label_5)
  178.  
  179.         self.horizontalSpacer_13 = QSpacerItem(5, 20, QSizePolicy.Expanding, QSizePolicy.Minimum)
  180.  
  181.         self.horizontalLayout_11.addItem(self.horizontalSpacer_13)
  182.  
  183.         self.lineEdit_Start = QLineEdit(self.layoutWidget)
  184.         self.lineEdit_Start.setObjectName(u"lineEdit_Start")
  185.  
  186.         self.horizontalLayout_11.addWidget(self.lineEdit_Start)
  187.  
  188.  
  189.         self.verticalLayout_2.addLayout(self.horizontalLayout_11)
  190.  
  191.         self.verticalSpacer_2 = QSpacerItem(20, 20, QSizePolicy.Minimum, QSizePolicy.Expanding)
  192.  
  193.         self.verticalLayout_2.addItem(self.verticalSpacer_2)
  194.  
  195.         self.horizontalLayout_10 = QHBoxLayout()
  196.         self.horizontalLayout_10.setObjectName(u"horizontalLayout_10")
  197.         self.label_6 = QLabel(self.layoutWidget)
  198.         self.label_6.setObjectName(u"label_6")
  199.  
  200.         self.horizontalLayout_10.addWidget(self.label_6)
  201.  
  202.         self.horizontalSpacer_12 = QSpacerItem(5, 20, QSizePolicy.Expanding, QSizePolicy.Minimum)
  203.  
  204.         self.horizontalLayout_10.addItem(self.horizontalSpacer_12)
  205.  
  206.         self.lineEdit_End = QLineEdit(self.layoutWidget)
  207.         self.lineEdit_End.setObjectName(u"lineEdit_End")
  208.  
  209.         self.horizontalLayout_10.addWidget(self.lineEdit_End)
  210.  
  211.  
  212.         self.verticalLayout_2.addLayout(self.horizontalLayout_10)
  213.  
  214.  
  215.         self.verticalLayout_3.addLayout(self.verticalLayout_2)
  216.  
  217.         self.verticalSpacer_3 = QSpacerItem(20, 20, QSizePolicy.Minimum, QSizePolicy.Expanding)
  218.  
  219.         self.verticalLayout_3.addItem(self.verticalSpacer_3)
  220.  
  221.         self.horizontalLayout_5 = QHBoxLayout()
  222.         self.horizontalLayout_5.setObjectName(u"horizontalLayout_5")
  223.         self.label_13 = QLabel(self.layoutWidget)
  224.         self.label_13.setObjectName(u"label_13")
  225.  
  226.         self.horizontalLayout_5.addWidget(self.label_13)
  227.  
  228.         self.horizontalSpacer_11 = QSpacerItem(13, 20, QSizePolicy.Expanding, QSizePolicy.Minimum)
  229.  
  230.         self.horizontalLayout_5.addItem(self.horizontalSpacer_11)
  231.  
  232.         self.lineEdit_Completion_Progress = QLineEdit(self.layoutWidget)
  233.         self.lineEdit_Completion_Progress.setObjectName(u"lineEdit_Completion_Progress")
  234.  
  235.         self.horizontalLayout_5.addWidget(self.lineEdit_Completion_Progress)
  236.  
  237.  
  238.         self.verticalLayout_3.addLayout(self.horizontalLayout_5)
  239.  
  240.  
  241.         self.verticalLayout_5.addLayout(self.verticalLayout_3)
  242.  
  243.         self.verticalSpacer_5 = QSpacerItem(20, 20, QSizePolicy.Minimum, QSizePolicy.Expanding)
  244.  
  245.         self.verticalLayout_5.addItem(self.verticalSpacer_5)
  246.  
  247.         self.verticalLayout_4 = QVBoxLayout()
  248.         self.verticalLayout_4.setObjectName(u"verticalLayout_4")
  249.         self.horizontalLayout_8 = QHBoxLayout()
  250.         self.horizontalLayout_8.setObjectName(u"horizontalLayout_8")
  251.         self.label_9 = QLabel(self.layoutWidget)
  252.         self.label_9.setObjectName(u"label_9")
  253.  
  254.         self.horizontalLayout_8.addWidget(self.label_9)
  255.  
  256.         self.horizontalSpacer_10 = QSpacerItem(5, 20, QSizePolicy.Expanding, QSizePolicy.Minimum)
  257.  
  258.         self.horizontalLayout_8.addItem(self.horizontalSpacer_10)
  259.  
  260.         self.lineEdit_People = QLineEdit(self.layoutWidget)
  261.         self.lineEdit_People.setObjectName(u"lineEdit_People")
  262.  
  263.         self.horizontalLayout_8.addWidget(self.lineEdit_People)
  264.  
  265.  
  266.         self.verticalLayout_4.addLayout(self.horizontalLayout_8)
  267.  
  268.         self.verticalSpacer_4 = QSpacerItem(20, 20, QSizePolicy.Minimum, QSizePolicy.Expanding)
  269.  
  270.         self.verticalLayout_4.addItem(self.verticalSpacer_4)
  271.  
  272.         self.horizontalLayout_7 = QHBoxLayout()
  273.         self.horizontalLayout_7.setObjectName(u"horizontalLayout_7")
  274.         self.label_10 = QLabel(self.layoutWidget)
  275.         self.label_10.setObjectName(u"label_10")
  276.  
  277.         self.horizontalLayout_7.addWidget(self.label_10)
  278.  
  279.         self.horizontalSpacer_9 = QSpacerItem(5, 20, QSizePolicy.Expanding, QSizePolicy.Minimum)
  280.  
  281.         self.horizontalLayout_7.addItem(self.horizontalSpacer_9)
  282.  
  283.         self.lineEdit_Money = QLineEdit(self.layoutWidget)
  284.         self.lineEdit_Money.setObjectName(u"lineEdit_Money")
  285.  
  286.         self.horizontalLayout_7.addWidget(self.lineEdit_Money)
  287.  
  288.  
  289.         self.verticalLayout_4.addLayout(self.horizontalLayout_7)
  290.  
  291.  
  292.         self.verticalLayout_5.addLayout(self.verticalLayout_4)
  293.  
  294.  
  295.         self.horizontalLayout_12.addLayout(self.verticalLayout_5)
  296.  
  297.         self.horizontalSpacer_15 = QSpacerItem(40, 20, QSizePolicy.Expanding, QSizePolicy.Minimum)
  298.  
  299.         self.horizontalLayout_12.addItem(self.horizontalSpacer_15)
  300.  
  301.         self.verticalLayout_6 = QVBoxLayout()
  302.         self.verticalLayout_6.setObjectName(u"verticalLayout_6")
  303.         self.horizontalLayout_9 = QHBoxLayout()
  304.         self.horizontalLayout_9.setObjectName(u"horizontalLayout_9")
  305.         self.label_12 = QLabel(self.layoutWidget)
  306.         self.label_12.setObjectName(u"label_12")
  307.  
  308.         self.horizontalLayout_9.addWidget(self.label_12)
  309.  
  310.         self.horizontalSpacer_7 = QSpacerItem(13, 20, QSizePolicy.Expanding, QSizePolicy.Minimum)
  311.  
  312.         self.horizontalLayout_9.addItem(self.horizontalSpacer_7)
  313.  
  314.         self.textEdit_Label = QTextEdit(self.layoutWidget)
  315.         self.textEdit_Label.setObjectName(u"textEdit_Label")
  316.  
  317.         self.horizontalLayout_9.addWidget(self.textEdit_Label)
  318.  
  319.  
  320.         self.verticalLayout_6.addLayout(self.horizontalLayout_9)
  321.  
  322.         self.verticalSpacer_6 = QSpacerItem(20, 40, QSizePolicy.Minimum, QSizePolicy.Expanding)
  323.  
  324.         self.verticalLayout_6.addItem(self.verticalSpacer_6)
  325.  
  326.         self.horizontalLayout_6 = QHBoxLayout()
  327.         self.horizontalLayout_6.setObjectName(u"horizontalLayout_6")
  328.         self.label_8 = QLabel(self.layoutWidget)
  329.         self.label_8.setObjectName(u"label_8")
  330.  
  331.         self.horizontalLayout_6.addWidget(self.label_8)
  332.  
  333.         self.horizontalSpacer_8 = QSpacerItem(5, 20, QSizePolicy.Expanding, QSizePolicy.Minimum)
  334.  
  335.         self.horizontalLayout_6.addItem(self.horizontalSpacer_8)
  336.  
  337.         self.lineEdit_level = QLineEdit(self.layoutWidget)
  338.         self.lineEdit_level.setObjectName(u"lineEdit_level")
  339.  
  340.         self.horizontalLayout_6.addWidget(self.lineEdit_level)
  341.  
  342.  
  343.         self.verticalLayout_6.addLayout(self.horizontalLayout_6)
  344.  
  345.  
  346.         self.horizontalLayout_12.addLayout(self.verticalLayout_6)
  347.  
  348.  
  349.         self.verticalLayout_7.addLayout(self.horizontalLayout_12)
  350.  
  351.  
  352.         self.verticalLayout_8.addLayout(self.verticalLayout_7)
  353.  
  354.         self.verticalSpacer_8 = QSpacerItem(20, 20, QSizePolicy.Minimum, QSizePolicy.Expanding)
  355.  
  356.         self.verticalLayout_8.addItem(self.verticalSpacer_8)
  357.  
  358.         self.gridLayout = QGridLayout()
  359.         self.gridLayout.setObjectName(u"gridLayout")
  360.         self.label_11 = QLabel(self.layoutWidget)
  361.         self.label_11.setObjectName(u"label_11")
  362.  
  363.         self.gridLayout.addWidget(self.label_11, 0, 0, 1, 1)
  364.  
  365.         self.horizontalSpacer_14 = QSpacerItem(40, 20, QSizePolicy.Minimum, QSizePolicy.Minimum)
  366.  
  367.         self.gridLayout.addItem(self.horizontalSpacer_14, 1, 0, 1, 1)
  368.  
  369.         self.textEdit_Notes = QTextEdit(self.layoutWidget)
  370.         self.textEdit_Notes.setObjectName(u"textEdit_Notes")
  371.  
  372.         self.gridLayout.addWidget(self.textEdit_Notes, 1, 1, 1, 1)
  373.  
  374.  
  375.         self.verticalLayout_8.addLayout(self.gridLayout)
  376.  
  377.  
  378.         self.horizontalLayout_14.addLayout(self.verticalLayout_8)
  379.  
  380.         self.horizontalSpacer_19 = QSpacerItem(40, 20, QSizePolicy.Expanding, QSizePolicy.Minimum)
  381.  
  382.         self.horizontalLayout_14.addItem(self.horizontalSpacer_19)
  383.  
  384.  
  385.         self.verticalLayout_9.addLayout(self.horizontalLayout_14)
  386.  
  387.  
  388.         self.verticalLayout_10.addLayout(self.verticalLayout_9)
  389.  
  390.         self.verticalSpacer_10 = QSpacerItem(20, 5, QSizePolicy.Minimum, QSizePolicy.Expanding)
  391.  
  392.         self.verticalLayout_10.addItem(self.verticalSpacer_10)
  393.  
  394.         self.horizontalLayout_15 = QHBoxLayout()
  395.         self.horizontalLayout_15.setObjectName(u"horizontalLayout_15")
  396.         self.horizontalSpacer_20 = QSpacerItem(40, 20, QSizePolicy.Expanding, QSizePolicy.Minimum)
  397.  
  398.         self.horizontalLayout_15.addItem(self.horizontalSpacer_20)
  399.  
  400.         self.pButtonOk = QPushButton(self.layoutWidget)
  401.         self.pButtonOk.setObjectName(u"pButtonOk")
  402.         font2 = QFont()
  403.         font2.setFamily(u"Agency FB")
  404.         font2.setPointSize(12)
  405.         font2.setBold(False)
  406.         font2.setWeight(50)
  407.         self.pButtonOk.setFont(font2)
  408.  
  409.         self.horizontalLayout_15.addWidget(self.pButtonOk)
  410.  
  411.         self.horizontalSpacer_21 = QSpacerItem(40, 20, QSizePolicy.Expanding, QSizePolicy.Minimum)
  412.  
  413.         self.horizontalLayout_15.addItem(self.horizontalSpacer_21)
  414.  
  415.         self.pButtonCancel = QPushButton(self.layoutWidget)
  416.         self.pButtonCancel.setObjectName(u"pButtonCancel")
  417.         font3 = QFont()
  418.         font3.setFamily(u"Agency FB")
  419.         font3.setPointSize(12)
  420.         self.pButtonCancel.setFont(font3)
  421.  
  422.         self.horizontalLayout_15.addWidget(self.pButtonCancel)
  423.  
  424.         self.horizontalSpacer_22 = QSpacerItem(40, 20, QSizePolicy.Expanding, QSizePolicy.Minimum)
  425.  
  426.         self.horizontalLayout_15.addItem(self.horizontalSpacer_22)
  427.  
  428.  
  429.         self.verticalLayout_10.addLayout(self.horizontalLayout_15)
  430.  
  431.         self.label = QLabel(Dialog)
  432.         self.label.setObjectName(u"label")
  433.         self.label.setGeometry(QRect(1, 4, 891, 781))
  434.         self.label.setPixmap(QPixmap(u":/\u80cc\u666f\u56fe1.png"))
  435.         self.label.raise_()
  436.         self.layoutWidget.raise_()
  437.  
  438.         self.retranslateUi(Dialog)
  439.  
  440.         QMetaObject.connectSlotsByName(Dialog)
  441.     # setupUi
  442.  
  443.     def retranslateUi(self, Dialog):
  444.         Dialog.setWindowTitle(QCoreApplication.translate("Dialog", u"\u9879\u76ee\u7ba1\u7406", None))
  445.         self.label_Big_Title.setText(QCoreApplication.translate("Dialog", u"\u9879\u76ee\u7ba1\u7406", None))
  446.         self.label_2.setText(QCoreApplication.translate("Dialog", u"\u9879\u76ee\u7f16\u53f7\uff1a", None))
  447.         self.label_3.setText(QCoreApplication.translate("Dialog", u"\u9879\u76ee\u7c7b\u578b\uff1a", None))
  448.         self.label_4.setText(QCoreApplication.translate("Dialog", u"\u9879\u76ee\u540d\u79f0\uff1a", None))
  449.         self.label_5.setText(QCoreApplication.translate("Dialog", u"\u5f00\u59cb\u65e5\u671f\uff1a", None))
  450.         self.label_6.setText(QCoreApplication.translate("Dialog", u"\u7ed3\u675f\u65e5\u671f\uff1a", None))
  451.         self.label_13.setText(QCoreApplication.translate("Dialog", u"\u5b8c\u6210\u8fdb\u5ea6\uff1a", None))
  452.         self.label_9.setText(QCoreApplication.translate("Dialog", u"\u8d1f\u8d23\u4eba\uff1a", None))
  453.         self.label_10.setText(QCoreApplication.translate("Dialog", u"\u9884\u7b97\u91d1\u989d\uff1a", None))
  454.         self.label_12.setText(QCoreApplication.translate("Dialog", u"\u6807\u7b7e\uff1a", None))
  455.         self.label_8.setText(QCoreApplication.translate("Dialog", u"\u9879\u76ee\u7ea7\u522b\uff1a", None))
  456.         self.label_11.setText(QCoreApplication.translate("Dialog", u"\u5907\u6ce8\uff1a", None))
  457.         self.pButtonOk.setText(QCoreApplication.translate("Dialog", u"\u786e\u5b9a", None))
  458.         self.pButtonCancel.setText(QCoreApplication.translate("Dialog", u"\u53d6\u6d88", None))
  459.         self.label.setText("")
  460.     # retranslateUi
  461.  
gl.py
  1. from PySide2.QtWidgets import QApplication, QDialog, QMessageBox
  2. from PySide2.QtCore import Signal # 信号
  3. from PySide2.QtGui import Qt, QIcon # 图标、窗体设置
  4. import sys, os, sqlite3
  5. from main_body.ui_gl import Ui_Dialog
  6. from PySide2.QtGui import QIcon
  7.  
  8. class DetailWindow(QDialog, Ui_Dialog):
  9.     detailSiganl = Signal(bool)
  10.  
  11.     def __init__(self):
  12.         super(DetailWindow, self).__init__()
  13.         self.setupUi(self)
  14.         self.cur_dir = os.path.dirname(os.path.abspath(__file__))
  15.  
  16.         # self.setWindowFlags(
  17.         #     Qt.WindowMinMaxButtonsHint |
  18.         #     Qt.MSWindowsFixedSizeDialogHint
  19.         # )
  20.  
  21.         self.actionName = None
  22.  
  23.         self.pButtonOk.clicked.connect(lambda: self.save2db())
  24.         self.pButtonCancel.clicked.connect(lambda: self.close())
  25.  
  26.         # 设置窗体图标
  27.         app_icon = QIcon('修改.ico')
  28.         self.setWindowIcon(app_icon)
  29.  
  30.  
  31.     def handle_main_signal(self, mainActionName:str, stu:dict):
  32.         self.actionName = mainActionName
  33.         if self.actionName == 'Add':
  34.             self.label_Big_Title.setText('项目添加')
  35.             self.pButtonOk.setText('添加')
  36.             self.lineEdit_No.setText('')
  37.             self.lineEdit_Type.setText('')
  38.             self.lineEdit_Name.setText('')
  39.             self.lineEdit_Start.setText('')
  40.             self.lineEdit_End.setText('')
  41.             self.lineEdit_Completion_Progress.setText('')
  42.             self.lineEdit_People.setText('')
  43.             self.lineEdit_level.setText('')
  44.             self.textEdit_Notes.setText('')
  45.  
  46.         elif self.actionName == 'Change' and stu is not None:
  47.             self.label_Big_Title.setText('项目修改')
  48.             self.pButtonOk.setText('修改')
  49.             self.lineEdit_No.setText(stu['项目编号'])
  50.             self.lineEdit_Type.setText(stu['项目类型'])
  51.             self.lineEdit_Name.setText(stu['项目名称'])
  52.             self.lineEdit_Start.setText(stu['开始日期'])
  53.             self.lineEdit_End.setText(stu['结束日期'])
  54.             self.lineEdit_Completion_Progress.setText(str(stu['完成进度']))
  55.             self.lineEdit_People.setText(stu['负责人'])
  56.             self.lineEdit_level.setText(stu['项目级别'])
  57.             self.textEdit_Notes.setText(stu['备注'])
  58.  
  59.  
  60.  
  61.  
  62.  
  63.  
  64.     def save2db(self):
  65.         _Id = self.lineEdit_No.text().strip()
  66.         _Type = self.lineEdit_Type.text().strip()
  67.         _Name = self.lineEdit_Name.text().strip()
  68.         _Start = self.lineEdit_Start.text().strip()
  69.         _End = self.lineEdit_End.text().strip()
  70.         _Progress = self.lineEdit_Completion_Progress.text().strip()
  71.         _People = self.lineEdit_People.text().strip()
  72.         _Level = self.lineEdit_level.text().strip()
  73.         _Note = self.textEdit_Notes.toPlainText().strip()
  74.  
  75.         if self.actionName == 'Add':
  76.             try:
  77.                 db_file = os.path.join(self.cur_dir, './data/my_All_Projects.db')
  78.                 conn = sqlite3.connect(db_file)
  79.                 cur = conn.cursor()
  80.                 sql = """
  81.                       INSERT INTO project (Id, Type, Name, Start_date, End_date, Progress, Manager, Level, Remark) 
  82.                       VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
  83.                       """
  84.                 stu = (_Id, _Type, _Name, _Start, _End, _Progress, _People, _Level, _Note)
  85.                 cur.execute(sql, stu)
  86.                 conn.commit()
  87.                 QMessageBox.information(self, '添加', '添加成功！')
  88.                 self.detailSiganl.emit(True)
  89.             except Exception as e:
  90.                 conn.rollback()
  91.                 QMessageBox.critical(self, '错误', '添加失败！' + str(e))
  92.                 self.detailSiganl.emit(False)
  93.             finally:
  94.                 self.close()
  95.                 cur.close()
  96.                 conn.close()
  97.                 cur = None
  98.                 conn = None
  99.  
  100.         elif self.actionName == 'Change':
  101.             try:
  102.                 db_file = os.path.join(self.cur_dir, './data/my_All_Projects.db')
  103.                 conn = sqlite3.connect(db_file)
  104.                 cur = conn.cursor()
  105.                 sql = """
  106.                       update project set Type='{0}',Name='{1}',Start_date='{2}',End_date='{3}',
  107.                       Progress={4},Manager='{5}',Level='{6}',Remark='{7}' where Id='{8}'
  108.                       """.format(_Type, _Name, _Start, _End, _Progress, _People, _Level, _Note, _Id)
  109.                 cur.execute(sql)
  110.                 conn.commit()
  111.                 QMessageBox.information(self, '修改', '修改成功！')
  112.                 self.detailSiganl.emit(True)
  113.             except Exception as e:
  114.                 conn.rollback()
  115.                 QMessageBox.critical(self, '错误', '修改失败！' + str(e))
  116.                 self.detailSiganl.emit(False)
  117.             finally:
  118.                 self.close()
  119.                 cur.close()
  120.                 conn.close()
  121.                 cur = None
  122.                 conn = None
  123.  
  124.  
  125.  
  126.  
  127.  
  128. if __name__ == '__main__':
  129.     app = QApplication(sys.argv)
  130.     win_main = DetailWindow()
  131.     win_main.show()
  132.     sys.exit(app.exec_())

8） 修改界面----项目管理

代码同上一个界面

9） 搜索界面----项目管理

ui_search.py
  1. # -*- coding: utf-8 -*-
  2.  
  3. ################################################################################
  4. ## Form generated from reading UI file 'search.ui'
  5. ##
  6. ## Created by: Qt User Interface Compiler version 5.15.2
  7. ##
  8. ## WARNING! All changes made in this file will be lost when recompiling UI file!
  9. ################################################################################
  10.  
  11. from PySide2.QtCore import *
  12. from PySide2.QtGui import *
  13. from PySide2.QtWidgets import *
  14.  
  15.  
  16. class Ui_Dialog(object):
  17.     def setupUi(self, Dialog):
  18.         if not Dialog.objectName():
  19.             Dialog.setObjectName(u"Dialog")
  20.         Dialog.resize(1172, 733)
  21.         self.layoutWidget = QWidget(Dialog)
  22.         self.layoutWidget.setObjectName(u"layoutWidget")
  23.         self.layoutWidget.setGeometry(QRect(1, 1, 1171, 731))
  24.         self.verticalLayout = QVBoxLayout(self.layoutWidget)
  25.         self.verticalLayout.setObjectName(u"verticalLayout")
  26.         self.verticalLayout.setContentsMargins(0, 0, 0, 0)
  27.         self.horizontalLayout = QHBoxLayout()
  28.         self.horizontalLayout.setObjectName(u"horizontalLayout")
  29.         self.pButtonShow = QPushButton(self.layoutWidget)
  30.         self.pButtonShow.setObjectName(u"pButtonShow")
  31.  
  32.         self.horizontalLayout.addWidget(self.pButtonShow)
  33.  
  34.         self.horizontalSpacer = QSpacerItem(40, 20, QSizePolicy.Expanding, QSizePolicy.Minimum)
  35.  
  36.         self.horizontalLayout.addItem(self.horizontalSpacer)
  37.  
  38.         self.label = QLabel(self.layoutWidget)
  39.         self.label.setObjectName(u"label")
  40.         font = QFont()
  41.         font.setFamily(u"Agency FB")
  42.         font.setPointSize(22)
  43.         font.setBold(True)
  44.         font.setWeight(75)
  45.         self.label.setFont(font)
  46.  
  47.         self.horizontalLayout.addWidget(self.label)
  48.  
  49.         self.horizontalSpacer_2 = QSpacerItem(40, 20, QSizePolicy.Expanding, QSizePolicy.Minimum)
  50.  
  51.         self.horizontalLayout.addItem(self.horizontalSpacer_2)
  52.  
  53.  
  54.         self.verticalLayout.addLayout(self.horizontalLayout)
  55.  
  56.         self.verticalSpacer = QSpacerItem(20, 13, QSizePolicy.Minimum, QSizePolicy.Fixed)
  57.  
  58.         self.verticalLayout.addItem(self.verticalSpacer)
  59.  
  60.         self.horizontalLayout_4 = QHBoxLayout()
  61.         self.horizontalLayout_4.setObjectName(u"horizontalLayout_4")
  62.         self.label_2 = QLabel(self.layoutWidget)
  63.         self.label_2.setObjectName(u"label_2")
  64.         font1 = QFont()
  65.         font1.setFamily(u"Agency FB")
  66.         font1.setPointSize(10)
  67.         font1.setBold(True)
  68.         font1.setWeight(75)
  69.         self.label_2.setFont(font1)
  70.  
  71.         self.horizontalLayout_4.addWidget(self.label_2)
  72.  
  73.         self.horizontalSpacer_3 = QSpacerItem(13, 20, QSizePolicy.Fixed, QSizePolicy.Minimum)
  74.  
  75.         self.horizontalLayout_4.addItem(self.horizontalSpacer_3)
  76.  
  77.         self.lineEditsearch = QLineEdit(self.layoutWidget)
  78.         self.lineEditsearch.setObjectName(u"lineEditsearch")
  79.  
  80.         self.horizontalLayout_4.addWidget(self.lineEditsearch)
  81.  
  82.         self.horizontalSpacer_4 = QSpacerItem(20, 20, QSizePolicy.Fixed, QSizePolicy.Minimum)
  83.  
  84.         self.horizontalLayout_4.addItem(self.horizontalSpacer_4)
  85.  
  86.         self.pButtonSearch = QPushButton(self.layoutWidget)
  87.         self.pButtonSearch.setObjectName(u"pButtonSearch")
  88.  
  89.         self.horizontalLayout_4.addWidget(self.pButtonSearch)
  90.  
  91.         self.horizontalSpacer_8 = QSpacerItem(20, 20, QSizePolicy.Fixed, QSizePolicy.Minimum)
  92.  
  93.         self.horizontalLayout_4.addItem(self.horizontalSpacer_8)
  94.  
  95.         self.horizontalLayout_2 = QHBoxLayout()
  96.         self.horizontalLayout_2.setObjectName(u"horizontalLayout_2")
  97.         self.label_3 = QLabel(self.layoutWidget)
  98.         self.label_3.setObjectName(u"label_3")
  99.  
  100.         self.horizontalLayout_2.addWidget(self.label_3)
  101.  
  102.         self.horizontalSpacer_5 = QSpacerItem(20, 20, QSizePolicy.Fixed, QSizePolicy.Minimum)
  103.  
  104.         self.horizontalLayout_2.addItem(self.horizontalSpacer_5)
  105.  
  106.         self.comboBox_Type = QComboBox(self.layoutWidget)
  107.         self.comboBox_Type.addItem("")
  108.         self.comboBox_Type.addItem("")
  109.         self.comboBox_Type.addItem("")
  110.         self.comboBox_Type.addItem("")
  111.         self.comboBox_Type.addItem("")
  112.         self.comboBox_Type.addItem("")
  113.         self.comboBox_Type.addItem("")
  114.         self.comboBox_Type.addItem("")
  115.         self.comboBox_Type.addItem("")
  116.         self.comboBox_Type.addItem("")
  117.         self.comboBox_Type.addItem("")
  118.         self.comboBox_Type.addItem("")
  119.         self.comboBox_Type.addItem("")
  120.         self.comboBox_Type.addItem("")
  121.         self.comboBox_Type.addItem("")
  122.         self.comboBox_Type.setObjectName(u"comboBox_Type")
  123.  
  124.         self.horizontalLayout_2.addWidget(self.comboBox_Type)
  125.  
  126.  
  127.         self.horizontalLayout_4.addLayout(self.horizontalLayout_2)
  128.  
  129.         self.horizontalSpacer_7 = QSpacerItem(20, 20, QSizePolicy.Fixed, QSizePolicy.Minimum)
  130.  
  131.         self.horizontalLayout_4.addItem(self.horizontalSpacer_7)
  132.  
  133.         self.horizontalLayout_3 = QHBoxLayout()
  134.         self.horizontalLayout_3.setObjectName(u"horizontalLayout_3")
  135.         self.label_4 = QLabel(self.layoutWidget)
  136.         self.label_4.setObjectName(u"label_4")
  137.  
  138.         self.horizontalLayout_3.addWidget(self.label_4)
  139.  
  140.         self.horizontalSpacer_6 = QSpacerItem(20, 20, QSizePolicy.Fixed, QSizePolicy.Minimum)
  141.  
  142.         self.horizontalLayout_3.addItem(self.horizontalSpacer_6)
  143.  
  144.         self.comboBox_Level = QComboBox(self.layoutWidget)
  145.         self.comboBox_Level.addItem("")
  146.         self.comboBox_Level.addItem("")
  147.         self.comboBox_Level.addItem("")
  148.         self.comboBox_Level.addItem("")
  149.         self.comboBox_Level.addItem("")
  150.         self.comboBox_Level.setObjectName(u"comboBox_Level")
  151.  
  152.         self.horizontalLayout_3.addWidget(self.comboBox_Level)
  153.  
  154.  
  155.         self.horizontalLayout_4.addLayout(self.horizontalLayout_3)
  156.  
  157.  
  158.         self.verticalLayout.addLayout(self.horizontalLayout_4)
  159.  
  160.         self.verticalSpacer_2 = QSpacerItem(20, 13, QSizePolicy.Minimum, QSizePolicy.Fixed)
  161.  
  162.         self.verticalLayout.addItem(self.verticalSpacer_2)
  163.  
  164.         self.tableWidget = QTableWidget(self.layoutWidget)
  165.         if (self.tableWidget.columnCount() < 9):
  166.             self.tableWidget.setColumnCount(9)
  167.         __qtablewidgetitem = QTableWidgetItem()
  168.         self.tableWidget.setHorizontalHeaderItem(0, __qtablewidgetitem)
  169.         __qtablewidgetitem1 = QTableWidgetItem()
  170.         self.tableWidget.setHorizontalHeaderItem(1, __qtablewidgetitem1)
  171.         __qtablewidgetitem2 = QTableWidgetItem()
  172.         self.tableWidget.setHorizontalHeaderItem(2, __qtablewidgetitem2)
  173.         __qtablewidgetitem3 = QTableWidgetItem()
  174.         self.tableWidget.setHorizontalHeaderItem(3, __qtablewidgetitem3)
  175.         __qtablewidgetitem4 = QTableWidgetItem()
  176.         self.tableWidget.setHorizontalHeaderItem(4, __qtablewidgetitem4)
  177.         __qtablewidgetitem5 = QTableWidgetItem()
  178.         self.tableWidget.setHorizontalHeaderItem(5, __qtablewidgetitem5)
  179.         __qtablewidgetitem6 = QTableWidgetItem()
  180.         self.tableWidget.setHorizontalHeaderItem(6, __qtablewidgetitem6)
  181.         __qtablewidgetitem7 = QTableWidgetItem()
  182.         self.tableWidget.setHorizontalHeaderItem(7, __qtablewidgetitem7)
  183.         __qtablewidgetitem8 = QTableWidgetItem()
  184.         self.tableWidget.setHorizontalHeaderItem(8, __qtablewidgetitem8)
  185.         self.tableWidget.setObjectName(u"tableWidget")
  186.  
  187.         self.verticalLayout.addWidget(self.tableWidget)
  188.  
  189.  
  190.         self.retranslateUi(Dialog)
  191.  
  192.         QMetaObject.connectSlotsByName(Dialog)
  193.     # setupUi
  194.  
  195.     def retranslateUi(self, Dialog):
  196.         Dialog.setWindowTitle(QCoreApplication.translate("Dialog", u"\u67e5\u8be2", None))
  197.         self.pButtonShow.setText(QCoreApplication.translate("Dialog", u"\u663e\u793a\u9879\u76ee", None))
  198.         self.label.setText(QCoreApplication.translate("Dialog", u"\u9879\u76ee\u67e5\u8be2", None))
  199.         self.label_2.setText(QCoreApplication.translate("Dialog", u"\u8bf7\u8f93\u5165\u5173\u952e\u5b57\uff1a", None))
  200.         self.pButtonSearch.setText(QCoreApplication.translate("Dialog", u"\u641c\u7d22", None))
  201. #if QT_CONFIG(shortcut)
  202.         self.pButtonSearch.setShortcut(QCoreApplication.translate("Dialog", u"Return", None))
  203. #endif // QT_CONFIG(shortcut)
  204.         self.label_3.setText(QCoreApplication.translate("Dialog", u"\u7c7b\u578b", None))
  205.         self.comboBox_Type.setItemText(0, QCoreApplication.translate("Dialog", u"\u6280\u672f\u7814\u53d1", None))
  206.         self.comboBox_Type.setItemText(1, QCoreApplication.translate("Dialog", u"\u5e02\u573a\u8425\u9500", None))
  207.         self.comboBox_Type.setItemText(2, QCoreApplication.translate("Dialog", u"\u751f\u4ea7\u5236\u9020", None))
  208.         self.comboBox_Type.setItemText(3, QCoreApplication.translate("Dialog", u"\u4eba\u529b\u8d44\u6e90", None))
  209.         self.comboBox_Type.setItemText(4, QCoreApplication.translate("Dialog", u"\u8d22\u52a1\u7ba1\u7406", None))
  210.         self.comboBox_Type.setItemText(5, QCoreApplication.translate("Dialog", u"\u8f6f\u4ef6\u5f00\u53d1", None))
  211.         self.comboBox_Type.setItemText(6, QCoreApplication.translate("Dialog", u"\u7f51\u7edc\u8fd0\u7ef4", None))
  212.         self.comboBox_Type.setItemText(7, QCoreApplication.translate("Dialog", u"\u54a8\u8be2\u670d\u52a1", None))
  213.         self.comboBox_Type.setItemText(8, QCoreApplication.translate("Dialog", u"\u5e02\u573a\u8c03\u7814", None))
  214.         self.comboBox_Type.setItemText(9, QCoreApplication.translate("Dialog", u"\u57f9\u8bad\u670d\u52a1", None))
  215.         self.comboBox_Type.setItemText(10, QCoreApplication.translate("Dialog", u"\u6d3b\u52a8\u7b56\u5212", None))
  216.         self.comboBox_Type.setItemText(11, QCoreApplication.translate("Dialog", u"\u7269\u6d41\u914d\u9001", None))
  217.         self.comboBox_Type.setItemText(12, QCoreApplication.translate("Dialog", u"\u8d22\u52a1\u5ba1\u8ba1", None))
  218.         self.comboBox_Type.setItemText(13, QCoreApplication.translate("Dialog", u"\u73af\u5883\u76d1\u6d4b", None))
  219.         self.comboBox_Type.setItemText(14, QCoreApplication.translate("Dialog", u"\u6cd5\u5f8b\u54a8\u8be2", None))
  220.  
  221.         self.comboBox_Type.setCurrentText(QCoreApplication.translate("Dialog", u"\u6280\u672f\u7814\u53d1", None))
  222.         self.label_4.setText(QCoreApplication.translate("Dialog", u"\u7ea7\u522b", None))
  223.         self.comboBox_Level.setItemText(0, QCoreApplication.translate("Dialog", u"A", None))
  224.         self.comboBox_Level.setItemText(1, QCoreApplication.translate("Dialog", u"B", None))
  225.         self.comboBox_Level.setItemText(2, QCoreApplication.translate("Dialog", u"C", None))
  226.         self.comboBox_Level.setItemText(3, QCoreApplication.translate("Dialog", u"D", None))
  227.         self.comboBox_Level.setItemText(4, QCoreApplication.translate("Dialog", u"E", None))
  228.  
  229.         ___qtablewidgetitem = self.tableWidget.horizontalHeaderItem(0)
  230.         ___qtablewidgetitem.setText(QCoreApplication.translate("Dialog", u"\u9879\u76ee\u7f16\u53f7", None));
  231.         ___qtablewidgetitem1 = self.tableWidget.horizontalHeaderItem(1)
  232.         ___qtablewidgetitem1.setText(QCoreApplication.translate("Dialog", u"\u9879\u76ee\u7c7b\u578b", None));
  233.         ___qtablewidgetitem2 = self.tableWidget.horizontalHeaderItem(2)
  234.         ___qtablewidgetitem2.setText(QCoreApplication.translate("Dialog", u"\u9879\u76ee\u540d\u79f0", None));
  235.         ___qtablewidgetitem3 = self.tableWidget.horizontalHeaderItem(3)
  236.         ___qtablewidgetitem3.setText(QCoreApplication.translate("Dialog", u"\u5f00\u59cb\u65e5\u671f", None));
  237.         ___qtablewidgetitem4 = self.tableWidget.horizontalHeaderItem(4)
  238.         ___qtablewidgetitem4.setText(QCoreApplication.translate("Dialog", u"\u7ed3\u675f\u65e5\u671f", None));
  239.         ___qtablewidgetitem5 = self.tableWidget.horizontalHeaderItem(5)
  240.         ___qtablewidgetitem5.setText(QCoreApplication.translate("Dialog", u"\u5b8c\u6210\u8fdb\u5ea6", None));
  241.         ___qtablewidgetitem6 = self.tableWidget.horizontalHeaderItem(6)
  242.         ___qtablewidgetitem6.setText(QCoreApplication.translate("Dialog", u"\u8d1f\u8d23\u4eba", None));
  243.         ___qtablewidgetitem7 = self.tableWidget.horizontalHeaderItem(7)
  244.         ___qtablewidgetitem7.setText(QCoreApplication.translate("Dialog", u"\u9879\u76ee\u7ea7\u522b", None));
  245.         ___qtablewidgetitem8 = self.tableWidget.horizontalHeaderItem(8)
  246.         ___qtablewidgetitem8.setText(QCoreApplication.translate("Dialog", u"\u5907\u6ce8", None));
  247.     # retranslateUi
  248.  
search.py
  1. from PySide2.QtWidgets import QApplication, QDialog, QMessageBox
  2. from PySide2.QtCore import Signal # 信号
  3. from PySide2.QtGui import Qt, QIcon # 图标、窗体设置
  4. from PySide2.QtWidgets import QTableWidget, QTableWidgetItem
  5. from PySide2.QtWidgets import QHeaderView
  6. import sys, os, sqlite3
  7. from PySide2.QtGui import QIcon
  8. from main_body.ui_search import Ui_Dialog
  9.  
  10. class DetailWindow(QDialog, Ui_Dialog):
  11.     detailSiganl = Signal(bool)
  12.  
  13.     def __init__(self):
  14.         super(DetailWindow, self).__init__()
  15.         self.setupUi(self)
  16.         self.cur_dir = os.path.dirname(os.path.abspath(__file__))
  17.  
  18.         # 设置窗体图标
  19.         app_icon = QIcon('选择.ico')
  20.         self.setWindowIcon(app_icon)
  21.         # self.setWindowFlags(
  22.         #     Qt.WindowMinMaxButtonsHint |
  23.         #     Qt.MSWindowsFixedSizeDialogHint
  24.         # )
  25.  
  26.         self.actionName = None
  27.         self.pButtonShow.clicked.connect(lambda: self.Show())
  28.         self.pButtonSearch.clicked.connect(lambda: self.Search())
  29.         self.comboBox_Type.currentIndexChanged.connect(lambda: self.Select())
  30.         self.comboBox_Level.currentIndexChanged.connect(lambda: self.Select())
  31.  
  32.         self.lineEditsearch.setText('')           # 初始化搜索框
  33.         # self.Show()
  34. ########################################################################################################################
  35. # 关键字搜索
  36.     def Search(self):
  37.         _info = self.lineEditsearch.text().strip()
  38.         try:
  39.             db_file = os.path.join(self.cur_dir, './data/my_All_Projects.db')
  40.             conn = sqlite3.connect(db_file)
  41.             cur = conn.cursor()
  42.             sql = '''
  43.                   select  Id, Type, Name, Start_date, End_date, Progress, Manager, Level, Remark 
  44.                   from project 
  45.                  WHERE Id || Type || Name || Start_date || End_date || Progress || Manager || Level || Remark
  46.                     LIKE ? ;
  47.                   '''
  48.             stu = ('%' + _info + '%',)
  49.             cur.execute(sql, stu)
  50.             conn.commit()
  51.  
  52.             self.tableWidget.clearContents()  # 清空表格内容
  53.             self.tableWidget.setRowCount(0)  # 清空表格行数
  54.  
  55.             row_index = 0
  56.             while True:  # 使用True代替stu，因为查询结果为None时stu值为False，不能作为循环条件
  57.                 stu = cur.fetchone()
  58.                 if stu is None:  # 如果查询结果为None，退出循环
  59.                     break
  60.                 self.tableWidget.insertRow(row_index)
  61.                 for col_index, data in enumerate(stu):
  62.                     TblItem = QTableWidgetItem(str(data))
  63.                     self.tableWidget.setItem(row_index, col_index, TblItem)
  64.                 row_index += 1
  65.             self.tableWidget.horizontalHeader().setSectionResizeMode(QHeaderView.Stretch)
  66.         except Exception as e:
  67.             conn.rollback()
  68.         finally:
  69.             cur.close()
  70.             conn.close()
  71.             cur = None
  72.             conn = None
  73. ########################################################################################################################
  74. # 下拉框搜索
  75.     def Select(self):
  76.         current_type = self.comboBox_Type.currentText()
  77.         current_level = self.comboBox_Level.currentText()
  78.         try:
  79.             db_file = os.path.join(self.cur_dir, './data/my_All_Projects.db')
  80.             conn = sqlite3.connect(db_file)
  81.             cur = conn.cursor()
  82.  
  83.             sql = '''
  84.                   select  Id, Type, Name, Start_date, End_date, Progress, Manager, Level, Remark 
  85.                     from project 
  86.                   WHERE Type = ?  AND Level = ?
  87.                   '''
  88.             stu = (current_type, current_level)
  89.             cur.execute(sql, stu)
  90.             conn.commit()
  91.  
  92.             self.tableWidget.clearContents()  # 清空表格内容
  93.             self.tableWidget.setRowCount(0)  # 清空表格行数
  94.  
  95.             row_index = 0
  96.             while True:  # 使用True代替stu，因为查询结果为None时stu值为False，不能作为循环条件
  97.                 stu = cur.fetchone()
  98.                 if stu is None:  # 如果查询结果为None，退出循环
  99.                     break
  100.                 self.tableWidget.insertRow(row_index)
  101.                 for col_index, data in enumerate(stu):
  102.                     TblItem = QTableWidgetItem(str(data))
  103.                     self.tableWidget.setItem(row_index, col_index, TblItem)
  104.                 row_index += 1
  105.             self.tableWidget.horizontalHeader().setSectionResizeMode(QHeaderView.Stretch)
  106.         except Exception as e:
  107.             conn.rollback()
  108.  
  109.         finally:
  110.             cur.close()
  111.             conn.close()
  112.             cur = None
  113.             conn = None
  114. ########################################################################################################################
  115. # 显示项目
  116.     def Show(self, actionGl=False):
  117.         db_file = os.path.join(self.cur_dir, './data/my_All_Projects.db')
  118.         try:
  119.             if actionGl == True:
  120.                 while self.tableWidget.rowCount() > 0:
  121.                     self.tableWidget.removeRow(0)
  122.                 self.tableWidget.setRowCount(0)
  123.             conn = sqlite3.connect(db_file)
  124.             cur = conn.cursor()
  125.             sql = '''
  126.                    select  Id, Type, Name, Start_date, End_date, Progress, Manager, Level, Remark
  127.                    from project
  128.                   '''
  129.             cur.execute(sql)
  130.             stu = cur.fetchone()
  131.             row_index = 0
  132.             while stu:
  133.                 self.tableWidget.insertRow(row_index)
  134.                 for colIdx, data in enumerate(stu):
  135.                     TblItem = QTableWidgetItem(str(data))
  136.                     self.tableWidget.setItem(row_index, colIdx, TblItem)
  137.                 stu = cur.fetchone()
  138.                 row_index = row_index + 1
  139.             self.tableWidget.horizontalHeader().setSectionResizeMode(QHeaderView.Stretch)
  140.         except Exception as e:
  141.             print(e)
  142.         finally:
  143.             cur.close()
  144.             conn.close()
  145.             cur = None
  146.             conn = None
  147. ########################################################################################################################
  148. if __name__ == '__main__':
  149.     app = QApplication(sys.argv)
  150.     win_main = DetailWindow()
  151.     win_main.show()
  152.     sys.exit(app.exec_())

 10）导入界面----项目管理/用户界面

导入界面为代码书写，添加到对应的类里面

  1.  def Import(self):
  2.         # 选择要导入的CSV文件
  3.         csv_file, _ = QFileDialog.getOpenFileName(None, '选择 CSV 文件', '', 'CSV 文件(*.csv)')
  4.  
  5.         if not csv_file:
  6.             return
  7.  
  8.         # 获取导入数据库路径
  9.         # db_file, _ = QFileDialog.getOpenFileName(None, '选择数据库文件', '', 'SQLite 数据库(*.db *.sqlite)')
  10.         db_file = os.path.join(self.cur_dir, './data/my_All_Projects.db')
  11.  
  12.         if not db_file:
  13.             return
  14.  
  15.         try:
  16.             # 连接数据库并创建表格
  17.             conn = sqlite3.connect(db_file)
  18.             cur = conn.cursor()
  19.             # cur.execute(
  20.             #     'CREATE TABLE IF NOT EXISTS my_table (id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT, age INTEGER)')
  21.  
  22.             # 读取CSV文件并插入数据
  23.             with open(csv_file, 'r') as f:
  24.                 reader = csv.reader(f)
  25.                 for row in reader:
  26.                     cur.execute(
  27.                         'INSERT INTO project (Id, Type, Name, Start_date, End_date, Progress, Manager, Level, Remark) SELECT ?, ?, ?, ?, ?, ?, ?, ?, ? WHERE NOT EXISTS (SELECT 1 FROM project WHERE Id = ?)',
  28.                         (row[0], row[1], row[2], row[3], row[4], row[5], row[6], row[7], row[8], row[0]))
  29.  
  30.             conn.commit()
  31.             QMessageBox.information(None, '导入成功', '数据已成功导入到SQLite数据库中！')
  32.         except Exception as e:
  33.             conn.rollback()
  34.             QMessageBox.warning(None, '导入失败', '导入过程中发生错误：{}'.format(str(e)))
  35.         finally:
  36.             cur.close()
  37.             conn.close()
  38.  
  39.             # opened_file = QFileDialog().getOpenFileName(
  40.         #     parent=self,
  41.         #     caption='选择要导入的文件',
  42.         #     dir=self.cur_dir,
  43.         #     filter='CSV文件(*.csv);;文本文件(*.txt)'
  44.         # )
  45.         # if len(opened_file[0]) > 0:
  46.         #     db_file = os.path.join(self.cur_dir, './data/all_projects.db')
  47.         #     try:
  48.         #         conn = sqlite3.connect(db_file)
  49.         #         cur = conn.cursor()
  50.         #         sql = '''
  51.         #               INSERT INTO project (Id, Type, Name, Start_date, End_date, Progress, Manager, Level, Remark)
  52.         #               VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
  53.         #               '''
  54.         #         data = open(opened_file[0], mode='rb').read()
  55.         #         encoding = chardet.detect(data).get('encoding')
  56.         #         with open(opened_file[0], mode='r', encoding=encoding) as f:
  57.         #             csv_reader = csv.DictReader(f)
  58.         #             rows = []
  59.         #             for row in csv_reader:
  60.         #                 rows.append((row['项目编号'], row['项目类型'], row['项目名称'],
  61.         #                 row['开始日期'], row['结束日期'], row['完成进度'], row['负责人'],
  62.         #                 row['项目级别'], row['备注']))
  63.         #             cur.executemany(sql, rows)
  64.         #         conn.commit()
  65.         #         QMessageBox.information(self, '消息', '导入成功！')
  66.  
  67.                 #self.db2screen()
  68.  
  69.             # except Exception as e:
  70.             #     conn.rollback()
  71.             #     QMessageBox.critical(self, '错误', '导入失败！' + str(e))
  72.             # finally:
  73.             #     cur.close()
  74.             #     conn.close()
  75.             #     cur = None
  76.             #     conn = None

导出界面为代码书写，添加到对应的类里面

11） 导出界面----项目管理/用户界面

导出界面为代码书写，添加到对应的类里面

  1.     def Export(self):
  2.         # 选择要导出的数据库文件
  3.         # db_file, _ = QFileDialog.getOpenFileName(None, '选择数据库文件', '', 'SQLite 数据库(*.db *.sqlite)')
  4.         db_file = os.path.join(self.cur_dir, './data/my_All_Projects.db')
  5.  
  6.         if not db_file:
  7.             return
  8.  
  9.         # 获取导出路径
  10.         csv_file, _ = QFileDialog.getSaveFileName(None, '保存 CSV 文件', '', 'CSV 文件(*.csv)')
  11.  
  12.         if not csv_file:
  13.             return
  14.  
  15.         try:
  16.             # 连接数据库并查询数据
  17.             conn = sqlite3.connect(db_file)
  18.             cur = conn.cursor()
  19.             cur.execute('SELECT * FROM project')
  20.             data = cur.fetchall()
  21.  
  22.             # 将数据写入CSV文件
  23.             with open(csv_file, 'w', newline='') as f:
  24.                 writer = csv.writer(f)
  25.                 writer.writerow([i[0] for i in cur.description])  # 写入表头
  26.                 for row in data:
  27.                     writer.writerow(row)
  28.  
  29.             QMessageBox.information(None, '导出成功', '数据已成功导出到CSV文件中！')
  30.         except Exception as e:
  31.             QMessageBox.warning(None, '导出失败', '导出过程中发生错误：{}'.format(str(e)))
  32.         finally:
  33.             cur.close()
  34.             conn.close()

12）添加界面----用户管理

ui_control_gl.py
  1. # -*- coding: utf-8 -*-
  2.  
  3. ################################################################################
  4. ## Form generated from reading UI file 'control_gl.ui'
  5. ##
  6. ## Created by: Qt User Interface Compiler version 5.15.2
  7. ##
  8. ## WARNING! All changes made in this file will be lost when recompiling UI file!
  9. ################################################################################
  10.  
  11. from PySide2.QtCore import *
  12. from PySide2.QtGui import *
  13. from PySide2.QtWidgets import *
  14.  
  15.  
  16. class Ui_Dialog(object):
  17.     def setupUi(self, Dialog):
  18.         if not Dialog.objectName():
  19.             Dialog.setObjectName(u"Dialog")
  20.         Dialog.resize(928, 602)
  21.         self.layoutWidget = QWidget(Dialog)
  22.         self.layoutWidget.setObjectName(u"layoutWidget")
  23.         self.layoutWidget.setGeometry(QRect(30, 40, 831, 341))
  24.         self.verticalLayout_3 = QVBoxLayout(self.layoutWidget)
  25.         self.verticalLayout_3.setObjectName(u"verticalLayout_3")
  26.         self.verticalLayout_3.setContentsMargins(0, 0, 0, 0)
  27.         self.horizontalLayout = QHBoxLayout()
  28.         self.horizontalLayout.setObjectName(u"horizontalLayout")
  29.         self.horizontalSpacer = QSpacerItem(40, 20, QSizePolicy.Expanding, QSizePolicy.Minimum)
  30.  
  31.         self.horizontalLayout.addItem(self.horizontalSpacer)
  32.  
  33.         self.label_big_title = QLabel(self.layoutWidget)
  34.         self.label_big_title.setObjectName(u"label_big_title")
  35.         font = QFont()
  36.         font.setFamily(u"Agency FB")
  37.         font.setPointSize(24)
  38.         font.setBold(True)
  39.         font.setWeight(75)
  40.         self.label_big_title.setFont(font)
  41.  
  42.         self.horizontalLayout.addWidget(self.label_big_title)
  43.  
  44.         self.horizontalSpacer_2 = QSpacerItem(40, 20, QSizePolicy.Expanding, QSizePolicy.Minimum)
  45.  
  46.         self.horizontalLayout.addItem(self.horizontalSpacer_2)
  47.  
  48.  
  49.         self.verticalLayout_3.addLayout(self.horizontalLayout)
  50.  
  51.         self.verticalSpacer_3 = QSpacerItem(20, 40, QSizePolicy.Minimum, QSizePolicy.Fixed)
  52.  
  53.         self.verticalLayout_3.addItem(self.verticalSpacer_3)
  54.  
  55.         self.verticalLayout_2 = QVBoxLayout()
  56.         self.verticalLayout_2.setObjectName(u"verticalLayout_2")
  57.         self.horizontalLayout_9 = QHBoxLayout()
  58.         self.horizontalLayout_9.setObjectName(u"horizontalLayout_9")
  59.         self.horizontalSpacer_10 = QSpacerItem(40, 20, QSizePolicy.Expanding, QSizePolicy.Minimum)
  60.  
  61.         self.horizontalLayout_9.addItem(self.horizontalSpacer_10)
  62.  
  63.         self.horizontalLayout_2 = QHBoxLayout()
  64.         self.horizontalLayout_2.setObjectName(u"horizontalLayout_2")
  65.         self.label_2 = QLabel(self.layoutWidget)
  66.         self.label_2.setObjectName(u"label_2")
  67.  
  68.         self.horizontalLayout_2.addWidget(self.label_2)
  69.  
  70.         self.horizontalSpacer_3 = QSpacerItem(40, 20, QSizePolicy.Expanding, QSizePolicy.Minimum)
  71.  
  72.         self.horizontalLayout_2.addItem(self.horizontalSpacer_3)
  73.  
  74.         self.user_type = QLineEdit(self.layoutWidget)
  75.         self.user_type.setObjectName(u"user_type")
  76.  
  77.         self.horizontalLayout_2.addWidget(self.user_type)
  78.  
  79.  
  80.         self.horizontalLayout_9.addLayout(self.horizontalLayout_2)
  81.  
  82.         self.horizontalSpacer_11 = QSpacerItem(40, 20, QSizePolicy.Expanding, QSizePolicy.Minimum)
  83.  
  84.         self.horizontalLayout_9.addItem(self.horizontalSpacer_11)
  85.  
  86.  
  87.         self.verticalLayout_2.addLayout(self.horizontalLayout_9)
  88.  
  89.         self.verticalSpacer_2 = QSpacerItem(20, 40, QSizePolicy.Minimum, QSizePolicy.Fixed)
  90.  
  91.         self.verticalLayout_2.addItem(self.verticalSpacer_2)
  92.  
  93.         self.verticalLayout = QVBoxLayout()
  94.         self.verticalLayout.setObjectName(u"verticalLayout")
  95.         self.horizontalLayout_8 = QHBoxLayout()
  96.         self.horizontalLayout_8.setObjectName(u"horizontalLayout_8")
  97.         self.horizontalLayout_3 = QHBoxLayout()
  98.         self.horizontalLayout_3.setObjectName(u"horizontalLayout_3")
  99.         self.label_3 = QLabel(self.layoutWidget)
  100.         self.label_3.setObjectName(u"label_3")
  101.  
  102.         self.horizontalLayout_3.addWidget(self.label_3)
  103.  
  104.         self.horizontalSpacer_4 = QSpacerItem(40, 20, QSizePolicy.Fixed, QSizePolicy.Minimum)
  105.  
  106.         self.horizontalLayout_3.addItem(self.horizontalSpacer_4)
  107.  
  108.         self.user_name = QLineEdit(self.layoutWidget)
  109.         self.user_name.setObjectName(u"user_name")
  110.  
  111.         self.horizontalLayout_3.addWidget(self.user_name)
  112.  
  113.  
  114.         self.horizontalLayout_8.addLayout(self.horizontalLayout_3)
  115.  
  116.         self.horizontalSpacer_9 = QSpacerItem(40, 20, QSizePolicy.Fixed, QSizePolicy.Minimum)
  117.  
  118.         self.horizontalLayout_8.addItem(self.horizontalSpacer_9)
  119.  
  120.         self.horizontalLayout_4 = QHBoxLayout()
  121.         self.horizontalLayout_4.setObjectName(u"horizontalLayout_4")
  122.         self.label_4 = QLabel(self.layoutWidget)
  123.         self.label_4.setObjectName(u"label_4")
  124.  
  125.         self.horizontalLayout_4.addWidget(self.label_4)
  126.  
  127.         self.horizontalSpacer_5 = QSpacerItem(40, 20, QSizePolicy.Fixed, QSizePolicy.Minimum)
  128.  
  129.         self.horizontalLayout_4.addItem(self.horizontalSpacer_5)
  130.  
  131.         self.user_password = QLineEdit(self.layoutWidget)
  132.         self.user_password.setObjectName(u"user_password")
  133.  
  134.         self.horizontalLayout_4.addWidget(self.user_password)
  135.  
  136.  
  137.         self.horizontalLayout_8.addLayout(self.horizontalLayout_4)
  138.  
  139.  
  140.         self.verticalLayout.addLayout(self.horizontalLayout_8)
  141.  
  142.         self.verticalSpacer = QSpacerItem(20, 40, QSizePolicy.Minimum, QSizePolicy.Fixed)
  143.  
  144.         self.verticalLayout.addItem(self.verticalSpacer)
  145.  
  146.         self.horizontalLayout_7 = QHBoxLayout()
  147.         self.horizontalLayout_7.setObjectName(u"horizontalLayout_7")
  148.         self.horizontalLayout_5 = QHBoxLayout()
  149.         self.horizontalLayout_5.setObjectName(u"horizontalLayout_5")
  150.         self.label_5 = QLabel(self.layoutWidget)
  151.         self.label_5.setObjectName(u"label_5")
  152.  
  153.         self.horizontalLayout_5.addWidget(self.label_5)
  154.  
  155.         self.horizontalSpacer_6 = QSpacerItem(40, 20, QSizePolicy.Fixed, QSizePolicy.Minimum)
  156.  
  157.         self.horizontalLayout_5.addItem(self.horizontalSpacer_6)
  158.  
  159.         self.user_times = QLineEdit(self.layoutWidget)
  160.         self.user_times.setObjectName(u"user_times")
  161.  
  162.         self.horizontalLayout_5.addWidget(self.user_times)
  163.  
  164.  
  165.         self.horizontalLayout_7.addLayout(self.horizontalLayout_5)
  166.  
  167.         self.horizontalSpacer_8 = QSpacerItem(40, 20, QSizePolicy.Fixed, QSizePolicy.Minimum)
  168.  
  169.         self.horizontalLayout_7.addItem(self.horizontalSpacer_8)
  170.  
  171.         self.horizontalLayout_6 = QHBoxLayout()
  172.         self.horizontalLayout_6.setObjectName(u"horizontalLayout_6")
  173.         self.label_6 = QLabel(self.layoutWidget)
  174.         self.label_6.setObjectName(u"label_6")
  175.  
  176.         self.horizontalLayout_6.addWidget(self.label_6)
  177.  
  178.         self.horizontalSpacer_7 = QSpacerItem(40, 20, QSizePolicy.Fixed, QSizePolicy.Minimum)
  179.  
  180.         self.horizontalLayout_6.addItem(self.horizontalSpacer_7)
  181.  
  182.         self.user_last_time = QLineEdit(self.layoutWidget)
  183.         self.user_last_time.setObjectName(u"user_last_time")
  184.  
  185.         self.horizontalLayout_6.addWidget(self.user_last_time)
  186.  
  187.  
  188.         self.horizontalLayout_7.addLayout(self.horizontalLayout_6)
  189.  
  190.  
  191.         self.verticalLayout.addLayout(self.horizontalLayout_7)
  192.  
  193.  
  194.         self.verticalLayout_2.addLayout(self.verticalLayout)
  195.  
  196.  
  197.         self.verticalLayout_3.addLayout(self.verticalLayout_2)
  198.  
  199.         self.layoutWidget1 = QWidget(Dialog)
  200.         self.layoutWidget1.setObjectName(u"layoutWidget1")
  201.         self.layoutWidget1.setGeometry(QRect(150, 500, 601, 30))
  202.         self.horizontalLayout_10 = QHBoxLayout(self.layoutWidget1)
  203.         self.horizontalLayout_10.setObjectName(u"horizontalLayout_10")
  204.         self.horizontalLayout_10.setContentsMargins(0, 0, 0, 0)
  205.         self.horizontalSpacer_13 = QSpacerItem(40, 20, QSizePolicy.Expanding, QSizePolicy.Minimum)
  206.  
  207.         self.horizontalLayout_10.addItem(self.horizontalSpacer_13)
  208.  
  209.         self.pButtonOk = QPushButton(self.layoutWidget1)
  210.         self.pButtonOk.setObjectName(u"pButtonOk")
  211.  
  212.         self.horizontalLayout_10.addWidget(self.pButtonOk)
  213.  
  214.         self.horizontalSpacer_12 = QSpacerItem(40, 20, QSizePolicy.Expanding, QSizePolicy.Minimum)
  215.  
  216.         self.horizontalLayout_10.addItem(self.horizontalSpacer_12)
  217.  
  218.         self.pButtonCancel = QPushButton(self.layoutWidget1)
  219.         self.pButtonCancel.setObjectName(u"pButtonCancel")
  220.  
  221.         self.horizontalLayout_10.addWidget(self.pButtonCancel)
  222.  
  223.         self.horizontalSpacer_14 = QSpacerItem(40, 20, QSizePolicy.Expanding, QSizePolicy.Minimum)
  224.  
  225.         self.horizontalLayout_10.addItem(self.horizontalSpacer_14)
  226.  
  227.         self.widget = QWidget(Dialog)
  228.         self.widget.setObjectName(u"widget")
  229.         self.widget.setGeometry(QRect(170, 430, 671, 22))
  230.         self.horizontalLayout_11 = QHBoxLayout(self.widget)
  231.         self.horizontalLayout_11.setObjectName(u"horizontalLayout_11")
  232.         self.horizontalLayout_11.setContentsMargins(0, 0, 0, 0)
  233.         self.checkBoxAdd = QCheckBox(self.widget)
  234.         self.checkBoxAdd.setObjectName(u"checkBoxAdd")
  235.  
  236.         self.horizontalLayout_11.addWidget(self.checkBoxAdd)
  237.  
  238.         self.horizontalSpacer_15 = QSpacerItem(20, 20, QSizePolicy.Fixed, QSizePolicy.Minimum)
  239.  
  240.         self.horizontalLayout_11.addItem(self.horizontalSpacer_15)
  241.  
  242.         self.checkBoxChange = QCheckBox(self.widget)
  243.         self.checkBoxChange.setObjectName(u"checkBoxChange")
  244.  
  245.         self.horizontalLayout_11.addWidget(self.checkBoxChange)
  246.  
  247.         self.horizontalSpacer_16 = QSpacerItem(20, 20, QSizePolicy.Fixed, QSizePolicy.Minimum)
  248.  
  249.         self.horizontalLayout_11.addItem(self.horizontalSpacer_16)
  250.  
  251.         self.checkBoxDelete = QCheckBox(self.widget)
  252.         self.checkBoxDelete.setObjectName(u"checkBoxDelete")
  253.  
  254.         self.horizontalLayout_11.addWidget(self.checkBoxDelete)
  255.  
  256.         self.horizontalSpacer_17 = QSpacerItem(20, 20, QSizePolicy.Fixed, QSizePolicy.Minimum)
  257.  
  258.         self.horizontalLayout_11.addItem(self.horizontalSpacer_17)
  259.  
  260.         self.checkBoxImport = QCheckBox(self.widget)
  261.         self.checkBoxImport.setObjectName(u"checkBoxImport")
  262.  
  263.         self.horizontalLayout_11.addWidget(self.checkBoxImport)
  264.  
  265.  
  266.         self.retranslateUi(Dialog)
  267.  
  268.         QMetaObject.connectSlotsByName(Dialog)
  269.     # setupUi
  270.  
  271.     def retranslateUi(self, Dialog):
  272.         Dialog.setWindowTitle(QCoreApplication.translate("Dialog", u"\u7528\u6237\u7ba1\u7406", None))
  273.         self.label_big_title.setText(QCoreApplication.translate("Dialog", u"\u7528\u6237\u7ba1\u7406", None))
  274.         self.label_2.setText(QCoreApplication.translate("Dialog", u"\u7528\u6237\u7c7b\u578b", None))
  275.         self.label_3.setText(QCoreApplication.translate("Dialog", u"\u7528\u6237\u540d", None))
  276.         self.label_4.setText(QCoreApplication.translate("Dialog", u"\u7528\u6237\u5bc6\u7801", None))
  277.         self.label_5.setText(QCoreApplication.translate("Dialog", u"\u767b\u5f55\u6b21\u6570", None))
  278.         self.label_6.setText(QCoreApplication.translate("Dialog", u"\u4e0a\u6b21\u767b\u5f55\u65f6\u95f4", None))
  279.         self.pButtonOk.setText(QCoreApplication.translate("Dialog", u"\u786e\u5b9a", None))
  280.         self.pButtonCancel.setText(QCoreApplication.translate("Dialog", u"\u53d6\u6d88", None))
  281.         self.checkBoxAdd.setText(QCoreApplication.translate("Dialog", u"\u6dfb\u52a0", None))
  282.         self.checkBoxChange.setText(QCoreApplication.translate("Dialog", u"\u4fee\u6539", None))
  283.         self.checkBoxDelete.setText(QCoreApplication.translate("Dialog", u"\u5220\u9664", None))
  284.         self.checkBoxImport.setText(QCoreApplication.translate("Dialog", u"\u5bfc\u5165", None))
  285.     # retranslateUi
  286.  
control_gl.py
  1. from PySide2.QtWidgets import QApplication, QDialog, QMessageBox
  2. from PySide2.QtCore import Signal # 信号
  3. from PySide2.QtGui import Qt, QIcon # 图标、窗体设置
  4. import sys, os, sqlite3
  5. from main_body.ui_control_gl import Ui_Dialog
  6. from PySide2.QtGui import QIcon
  7.  
  8. class DetailWindow(QDialog, Ui_Dialog):
  9.     detailSiganl = Signal(bool)
  10.  
  11.     def __init__(self):
  12.         super(DetailWindow, self).__init__()
  13.         self.setupUi(self)
  14.         self.cur_dir = os.path.dirname(os.path.abspath(__file__))
  15.  
  16.         # self.setWindowFlags(
  17.         #     Qt.WindowMinMaxButtonsHint |
  18.         #     Qt.MSWindowsFixedSizeDialogHint
  19.         # )
  20.  
  21.         self.actionName = None
  22.  
  23.         self.pButtonOk.clicked.connect(lambda: self.save2db())
  24.         self.pButtonCancel.clicked.connect(lambda: self.close())
  25.  
  26.  
  27.         # 设置窗体图标
  28.         app_icon = QIcon('修改.ico')
  29.         self.setWindowIcon(app_icon)
  30.  
  31.     def handle_main_signal(self, mainActionName: str, stu: dict):
  32.         self.actionName = mainActionName
  33.         if self.actionName == 'Add':
  34.             self.label_big_title.setText("用户添加")
  35.             self.pButtonOk.setText('添加')
  36.             self.user_type.setText('')
  37.             self.user_name.setText('')
  38.             self.user_password.setText('')
  39.             self.user_times.setText('')
  40.             self.user_last_time.setText('')
  41.             self.checkBoxAdd.setChecked(True)
  42.             self.checkBoxChange.setChecked(True)
  43.             self.checkBoxDelete.setChecked(True)
  44.             self.checkBoxImport.setChecked(True)
  45.  
  46.  
  47.         elif self.actionName == 'Change' and stu is not None:
  48.             self.label_big_title.setText('用户修改')
  49.             self.pButtonOk.setText('修改')
  50.             self.user_type.setText(stu['用户类型'])
  51.             self.user_name.setText(stu['用户名'])
  52.             self.user_password.setText(stu['用户密码'])
  53.             self.user_times.setText(stu['登录次数'])
  54.             self.user_last_time.setText(stu['上一次登录时间'])
  55.             if stu['添加'] == 'T':
  56.                 self.checkBoxAdd.setChecked(True)
  57.             else:
  58.                 self.checkBoxAdd.setChecked(True)
  59.             if stu['添加'] == 'T':
  60.                 self.checkBoxChange.setChecked(True)
  61.             else:
  62.                 self.checkBoxChange.setChecked(True)
  63.             if stu['添加'] == 'T':
  64.                 self.checkBoxDelete.setChecked(True)
  65.             else:
  66.                 self.checkBoxDelete.setChecked(True)
  67.             if stu['添加'] == 'T':
  68.                 self.checkBoxImport.setChecked(True)
  69.             else:
  70.                 self.checkBoxImport.setChecked(True)
  71.  
  72.  
  73.     def save2db(self):
  74.         _type = self.user_type.text().strip()
  75.         _name = self.user_name.text().strip()
  76.         _password = self.user_password.text().strip()
  77.         _times = self.user_times.text().strip()
  78.         _last = self.user_last_time.text().strip()
  79.         if self.checkBoxAdd.isChecked():
  80.             _add = 'T'
  81.         else:
  82.             _add = 'F'
  83.         if self.checkBoxChange.isChecked():
  84.             _change = 'T'
  85.         else:
  86.             _change = 'F'
  87.         if self.checkBoxDelete.isChecked():
  88.             _delete = 'T'
  89.         else:
  90.             _delete = 'F'
  91.         if self.checkBoxImport.isChecked():
  92.             _import = 'T'
  93.         else:
  94.             _import = 'F'
  95.  
  96.         if self.actionName == 'Add':
  97.             try:
  98.                 db_file = os.path.join(self.cur_dir, './data/user_password.db')
  99.                 conn = sqlite3.connect(db_file)
  100.                 cur = conn.cursor()
  101.                 sql = """
  102.                       INSERT INTO all_user (user_type,username,password,login_times,last_login,add_right,change_right,
  103.                     import_right,export_right) 
  104.                       VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
  105.                       """
  106.                 stu = (_type, _name, _password, _times, _last, _add, _change, _import,_delete )
  107.                 cur.execute(sql, stu)
  108.                 conn.commit()
  109.                 QMessageBox.information(self, '添加', '添加成功！')
  110.                 self.detailSiganl.emit(True)
  111.             except Exception as e:
  112.                 conn.rollback()
  113.                 QMessageBox.critical(self, '错误', '添加失败！' + str(e))
  114.                 print(e)
  115.                 self.detailSiganl.emit(False)
  116.             finally:
  117.                 self.close()
  118.                 cur.close()
  119.                 conn.close()
  120.                 cur = None
  121.                 conn = None
  122.  
  123.         elif self.actionName == 'Change':
  124.             try:
  125.                 db_file = os.path.join(self.cur_dir, './data/user_password.db')
  126.                 conn = sqlite3.connect(db_file)
  127.                 cur = conn.cursor()
  128.                 sql = """
  129.                       update all_user set user_type='{0}',password='{1}',login_times='{2}', last_login='{3}',add_right='{4}',
  130.                       change_right='{5}',import_right='{6}',export_right='{7}'
  131.                      where username='{8}'
  132.                       """.format(_type, _password, _times, _last, _add, _change, _import,_delete, _name)
  133.                 cur.execute(sql)
  134.                 conn.commit()
  135.                 QMessageBox.information(self, '修改', '修改成功！')
  136.                 self.detailSiganl.emit(True)
  137.             except Exception as e:
  138.                 conn.rollback()
  139.                 QMessageBox.critical(self, '错误', '修改失败！' + str(e))
  140.                 print(e)
  141.                 self.detailSiganl.emit(False)
  142.             finally:
  143.                 self.close()
  144.                 cur.close()
  145.                 conn.close()
  146.                 cur = None
  147.                 conn = None
  148.  
  149.  
  150. if __name__ == '__main__':
  151.     app = QApplication(sys.argv)
  152.     win_main = DetailWindow()
  153.     win_main.show()
  154.     sys.exit(app.exec_())

13）修改界面----用户管理

 

同上一界面代码

14）搜索界面----用户管理

该部分代码使用了tkinter模块，可以不用的！

声明：本文内容由网友自发贡献，不代表【wpsshop博客】立场，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：https://www.wpsshop.cn/w/不正经/article/detail/371287
推荐阅读
相关标签

Copyright © 2003-2013 www.wpsshop.cn 版权所有，并保留所有权利。

  

闽ICP备14008679号