【迪文串口屏】实战应用

lugl4313820

【迪文串口屏】实战应用 [复制链接]

 

【迪文串口屏】核酸采样登记系统之一 - 国产芯片交流 - 电子工程世界-论坛 (eeworld.com.cn)

【迪文串口屏】核酸采样登记系统之二：准备背景图片 - 国产芯片交流 - 电子工程世界-论坛 (eeworld.com.cn)

【迪文串口屏】核酸采样登记系统之三 连上迪文云 - 国产芯片交流 - 电子工程世界-论坛 (eeworld.com.cn)

【迪文串口屏】核酸采样登记系统之四 查询数据并显示 - 国产芯片交流 - 电子工程世界-论坛 (eeworld.com.cn)

【迪文串口屏】核酸采样登记系统之五 数据保存 - 国产芯片交流 - 电子工程世界-论坛 (eeworld.com.cn)

【迪文串口屏】核酸采样登记系统之六 增加采样工作站 - 国产芯片交流 - 电子工程世界-论坛 (eeworld.com.cn)

       好久没有更新核酸检测系统帖子了，因为上个星期四到单位实用，在保存数方面比较慢，究其原因是读写excel占用了太多的时间，这个星期一直在考虑如何解决这个问题，再加上最近的评测作品比较多，今年花了一天的时间对项目进行的修正，基本达到实用效果，现在跟大家汇报如下：

1、更新了界面，用Pyside设计界面：

2、代码：

濠电姷鏁告慨鐑藉极閸涘﹥鍙忛柣鎴ｆ閺嬩線鏌涘☉姗堟敾闁告瑥绻愰湁闁稿繐鍚嬬紞鎴︽煕閵娿儱鈧潡寮婚敐澶婄鐎规洖娲ら崫娲⒑閸濆嫷鍎愰柣妤侇殘閹广垹鈽夐姀鐘殿吅闂佺粯鍔曢顓炩枔閵堝鈷戞繛鑼额嚙楠炴鏌熼悷鐗堝枠鐎殿喖顭烽幃銏ゆ惞閸︻叏绱查梻渚€娼х换鎺撴叏閻㈠憡鍊堕柛顐犲劜閳锋垿鏌涘┑鍡楊仼妞ゅ繈鍎甸弻娑欐償閿濆棙姣堥悗娈垮枛椤攱淇婇幖浣哥厸闁稿本鐭花浠嬫⒒娴ｅ懙褰掑嫉椤掑倻鐭欓柟杈惧瘜閺佸倿鏌ㄩ悤鍌涘

登录后复制

import sys
import time
from PySide2.QtWidgets import *
from PySide2.QtCore import *
from PySide2.QtGui import *
from PySide2.QtSerialPort import *
from excel import *
from Test_main import Ui_MainWindow
from threading import Thread  # 导入thread
import qtmodern.styles
import qtmodern.windows
import pythoncom
from PySide2.QtCore import Signal,QObject  # 导入信号类
cmd_read_phone = bytes([0x5a, 0xa5, 0x04, 0x83, 0x10, 0x60, 0x13])
cmd_read_ID_number = bytes([0x5a, 0xa5, 0x04, 0x83, 0x10, 0x20, 0x18])
cmd_write_to_enter_page = bytes([0x5a, 0xa5, 0x07, 0x82, 0x00, 0x84, 0x5a, 0x01, 0x00, 0x10])
cmd_write_to_main_page = bytes([0x5a, 0xa5, 0x07, 0x82, 0x00, 0x84, 0x5a, 0x01, 0x00, 0x00])
cmd_write_to_waite_page = bytes([0x5a, 0xa5, 0x07, 0x82, 0x00, 0x84, 0x5a, 0x01, 0x00, 0x12])
send_list = [0x5a, 0xa5, 0x00, 0x00, 0x00, 0x00]
all_range = None
phone_code = None
xls_ID_code = None
dict_in_data = {
    'tube_number': '',
    'name': '',
    'phone': '',
    'ID': '',
    'sex': '',
    'company': '',
    'test_date': ''
}
class MainWindow(Ui_MainWindow, QMainWindow):
    global all_range, my_xls, save_xls, phone_code
    def __init__(self):
        super(MainWindow, self).__init__()
        self.setupUi(self)
        self.setWindowTitle("核酸检测登记管理系统")
        self.comboBaudrate = 115200
        serial_list = QSerialPortInfo.availablePorts()
        for port in serial_list:
            self.comMainPort.addItem(port.portName())
            self.comSlavePort.addItem(port.portName())
        self.serialMain = QSerialPort()
        self.serialSlave = QSerialPort()
        self.bntOpen.clicked.connect(self.open_serial)
        self.serialMain.readyRead.connect(self.MainPortReadData)
        self.serialSlave.readyRead.connect(self.SlavePortReadData)
        self.bntExit.clicked.connect(self.exit_save_data)
        self.reade_excel()

    def reade_excel(self):
        # 循环接收数据，此为死循环，可用线程实现
        global my_xls, save_xls, all_range
        try:
            path = sys.path[0]
            print(path)
            my_xls_path = path + '\核酸数据库.xlsx'
            my_save_xls_path = path + '\送检单.xlsx'
            pythoncom.CoInitialize()
            my_xls = easyExcel(my_xls_path)
            cols = my_xls.getCols('Sheet1')
            print("总列数为：" + str(cols))
            rows = my_xls.getRows('Sheet1') + 1
            print("总行数为：" + str(rows))
            # 获取全部数据到内存
            all_range = my_xls.getRange('Sheet1', 2, 1, rows - 1, cols)
            save_xls = easyExcel(my_save_xls_path)
            pythoncom.CoUninitialize()
        except Exception as e:
            print("打开EXCEL出错啦:" + str(e))

    # 保存基本信息数据
    def save_infor_file(self,data):
        global my_xls
        try:
            rows = my_xls.getRows('Sheet1') + 1
            my_xls.setCell('Sheet1', rows, 1, rows)  # 增加姓名
            my_xls.setCell('Sheet1', rows, 2, data['name'])  # 增加姓名
            my_xls.setCell('Sheet1', rows, 5, data['sex'])  # 增加性别
            my_xls.setCell('Sheet1', rows, 3, data['phone'])  # 增加电话号码
            my_xls.setCell('Sheet1', rows, 4, data['ID'])  # 增加身份证号
            my_xls.setCell('Sheet1', rows, 6, data['company'])  # 增加单位
            my_xls.save()
            return 1
        except Exception as e:
            print("保存基本信息出错：" + str(e))
    # 保存采样信息数据
    def save_test_file(self,data):
        global save_xls
        # 先检查是否有文件，没有新建一个，有测打开
        try:
            max_row = save_xls.getRows('Sheet1')
            if max_row == 1:
                print("当天第一次写数据，初始化一下")
                # 试号管为 1
                data['tube_number'] = 1
                this_row = 1
                tube = 1
            else:
                tube = save_xls.getCell('Sheet1', max_row, 2)
                if ((max_row - 1) % 10) == 0:  # 10混1
                    tube = tube + 1
            # 表行号增加一行
            max_row = max_row + 1
            save_xls.setCell('Sheet1', max_row, 1, max_row - 1)  # 增加序号
            save_xls.setCell('Sheet1', max_row, 2, tube)  # 增加管号
            save_xls.setCell('Sheet1', max_row, 3, data['name'])  # 增加姓名
            save_xls.setCell('Sheet1', max_row, 4, data['sex'])  # 增加性别
            save_xls.setCell('Sheet1', max_row, 5, data['phone'])  # 增加电话号码
            save_xls.setCell('Sheet1', max_row, 6, data['ID'])  # 增加身份证号
            save_xls.setCell('Sheet1', max_row, 7, data['company'])  # 增加单位
            save_xls.setCell('Sheet1', max_row, 8, time.strftime("%Y-%m-%d", time.localtime()))  # 增加检测时间
            save_xls.save()
            print("保存数据成功")
            xh = max_row - 1  # 修正序号
            return tube, xh
        except Exception as e:
            print("保存数据出错：" + str(e))
            return 0


    def open_serial(self):
        self.serialMain.setPortName(self.comMainPort.currentText())
        self.serialSlave.setPortName(self.comSlavePort.currentText())
        if self.bntOpen.text() == "打开":
            self.serialMain.open(QIODevice.ReadWrite)
            self.serialMain.setBaudRate(self.comboBaudrate)
            self.serialSlave.open(QIODevice.ReadWrite)
            self.serialSlave.setBaudRate(self.comboBaudrate)
            self.bntOpen.setText("关闭")
        else:
            self.serialMain.close()
            self.serialSlave.close()
            self.bntOpen.setText("打开")

    # 姓名数据组装
    def creat_gbk_list(self, mydata, my_commad, H_address, L_address):
        # 发送的list
        send_list = [0x5a, 0xa5, 0x00, 0x00, 0x00, 0x00]
        send_len = 1 + 2 + 2 + len(mydata) * 2
        send_list[2] = send_len
        # 添加 命令
        send_list[3] = my_commad
        send_list[4] = H_address
        send_list[5] = L_address
        mysend_list = bytes(send_list) + mydata.encode("gbk") + b'\xFF\xFF'
        print(mysend_list)
        self.MaiNwritePort(mysend_list)

    # 清空数据
    def clear_show_data(self):
        global dict_in_data
        dict_in_data['name'] = ''
        dict_in_data['sex'] = ''
        dict_in_data['company'] = ''
        dict_in_data['phone'] = ''
        dict_in_data['phone'] = ''
        dict_in_data['ID'] = ''
        self.creat_gbk_list(dict_in_data['sex'], 0x82, 0x11, 0x20)
        self.creat_gbk_list(dict_in_data['phone'], 0x82, 0x10, 0x60)
        self.creat_gbk_list(dict_in_data['company'], 0x82, 0x11, 0x40)
        # self.creat_gbk_list(dict_in_data['name'], 0x82, 0x11, 0x60)
        # self.creat_gbk_list(dict_in_data['company'], 0x82, 0x11, 0x40)
        self.creat_gbk_list(dict_in_data['name'], 0x82, 0x11, 0x60)
        self.creat_gbk_list(dict_in_data['ID'], 0x82, 0x10, 0x20)
    # 护士站姓名数据组装
    def creat_gbk_list_nu(self, mydata, my_commad, H_address, L_address):
        # 发送的list
        send_list = [0x5a, 0xa5, 0x00, 0x00, 0x00, 0x00]
        send_len = 1 + 2 + 2 + len(mydata) * 2
        send_list[2] = send_len
        # 添加 命令
        send_list[3] = my_commad
        send_list[4] = H_address
        send_list[5] = L_address
        mysend_list = bytes(send_list) + mydata.encode("gbk") + b'\xFF\xFF\xFF'
        print(mysend_list)
        self.SlaveWritePort(mysend_list)

    # 护士站写数据
    def SlaveWritePort(self, text):
        if self.serialSlave.isOpen():
            self.serialSlave.write(text)

    # 主屏写数据
    def MaiNwritePort(self, text):
        if self.serialMain.isOpen():
            self.serialMain.write(text)

    def MainPortReadData(self):
        global all_range, dict_in_data, phone_code, xls_ID_code
        ba = self.serialMain.readAll()
        main_port_recv = QTextCodec.codecForLocale().toUnicode(ba.data())
        self.textInfor.appendPlainText(main_port_recv)
        STRGLO = ba.data()
        try:
            if STRGLO[0] == 0x5a and STRGLO[1] == 0xa5:
                # 获取地址
                addres = STRGLO[4] << 8 | STRGLO[5]
                commd = STRGLO[3]
                recv_len = STRGLO[2]
                print("地址为：" + hex(addres) + "  长度为：" + str(recv_len) + " 命令为：" + hex(commd))
                try:
                    if recv_len == 0x06 and commd == 0x83:
                        if addres == 0x1080:
                            print("按手机号码查询")
                            # # 读取手机号码数据
                            # print("手机号码为：" + dict_in_data['phone'])
                            my_index = None
                            try:
                                for index, value in enumerate(all_range):
                                    xls_phone_code = str(int(value[2]))
                                    if phone_code == xls_phone_code:
                                        my_index = index
                                        break
                                if xls_phone_code == phone_code and (my_index is not None):
                                    print("查到数据")
                                    dict_in_data['name'] = all_range[my_index][1]
                                    dict_in_data['sex'] = all_range[my_index][4]
                                    dict_in_data['company'] = all_range[my_index][5]
                                    dict_in_data['ID'] = all_range[my_index][3]
                                    self.creat_gbk_list(dict_in_data['sex'], 0x82, 0x11, 0x20)
                                    self.creat_gbk_list(dict_in_data['ID'], 0x82, 0x10, 0x20)
                                    self.creat_gbk_list(dict_in_data['company'], 0x82, 0x11, 0x40)
                                    self.creat_gbk_list(dict_in_data['name'], 0x82, 0x11, 0x60)
                                    # self.creat_gbk_list(dict_in_data['company'], 0x82, 0x11, 0x40)
                                    self.creat_gbk_list(dict_in_data['name'], 0x82, 0x11, 0x60)
                                    # 页面转移到确认页面 为什么要写两遍，BUG——
                                    self.MaiNwritePort(cmd_write_to_enter_page)
                                    self.MaiNwritePort(cmd_write_to_enter_page)
                                else:
                                    print("没有查到信息")
                            except Exception as e:
                                print("按手机号码查询出错啦:" + str(e))
                        elif addres == 0x1090:
                            # print("按身份证查询")
                            # print("身份证号码为：" + dict_in_data['ID'])
                            try:
                                my_index = None
                                for index, value in enumerate(all_range):
                                    xls_ID_code = value[3]
                                    if dict_in_data['ID'] == xls_ID_code:
                                        my_index = index
                                        break
                                dict_in_data['name'] = all_range[my_index][1]
                                dict_in_data['sex'] = all_range[my_index][4]
                                dict_in_data['company'] = all_range[my_index][5]
                                dict_in_data['phone'] = str(int(all_range[my_index][2]))
                                self.creat_gbk_list(dict_in_data['sex'], 0x82, 0x11, 0x20)
                                self.creat_gbk_list(dict_in_data['phone'], 0x82, 0x10, 0x60)
                                self.creat_gbk_list(dict_in_data['company'], 0x82, 0x11, 0x40)
                                self.creat_gbk_list(dict_in_data['name'], 0x82, 0x11, 0x60)
                                self.creat_gbk_list(dict_in_data['company'], 0x82, 0x11, 0x40)
                                self.creat_gbk_list(dict_in_data['name'], 0x82, 0x11, 0x60)
                                # 页面转移到确认页面 为什么要写两遍，BUG——
                                # 页面转移到确认页面 为什么要写两遍，BUG——

                                self.MaiNwritePort(cmd_write_to_enter_page)
                                self.MaiNwritePort(cmd_write_to_enter_page)
                            except Exception as e:
                                print("出错啦:" + str(e))
                            # DWritePort(ser, cmd_read_ID_number)
                        elif addres == 0x1200:
                            # 增加时间，保存数据
                            print("确认登记数据")
                            tub, xh = self.save_test_file(dict_in_data)
                            if tub is not None:
                                self.MaiNwritePort(cmd_write_to_waite_page)
                                self.creat_gbk_list_nu(dict_in_data['name'], 0x82, 0x20, 0x20)
                                self.creat_gbk_list_nu(str(int(tub)), 0x82, 0x20, 0x40)
                                self.creat_gbk_list_nu(str(int(tub)), 0x82, 0x20, 0x40)
                                self.creat_gbk_list_nu(str(xh), 0x82, 0x20, 0x60)
                                self.creat_gbk_list_nu(str(xh), 0x82, 0x20, 0x60)
                            else:
                                # 弹出失败
                                pass
                            # 转到主页面
                        elif addres == 0x1210:
                            print('保存数据')
                            if dict_in_data['name'] == "" or \
                                    dict_in_data['sex'] == "" or\
                                dict_in_data['company'] == "" or\
                                dict_in_data['phone'] == "" or\
                                dict_in_data['ID'] == "":
                                print("data ERROR")
                            else:
                                save_state = self.save_infor_file(dict_in_data)
                                cols = my_xls.getCols('Sheet1')
                                print("总列数为：" + str(cols))
                                rows = my_xls.getRows('Sheet1') + 1
                                print("总行数为：" + str(rows))
                                # 获取全部数据到内存
                                all_range = my_xls.getRange('Sheet1', 2, 1, rows - 1, cols)
                                self.MaiNwritePort(cmd_write_to_enter_page)
                    elif commd == 0x83 and recv_len == 0x12 and addres == 0x1060:
                        print("接收到手机号码")
                        recv_phone_len = STRGLO[6]
                        if recv_phone_len == 0x07:
                            str_ph = STRGLO[7:18]
                            phone_code = str_ph.decode()
                            # 开始查找是否有手机号存在
                            dict_in_data['phone'] = phone_code
                        else:
                            print("接收到的电话号码长度不对 长度为：" + str((recv_phone_len - 8)))
                    elif commd == 0x83 and recv_len == 24 and addres == 0x1020:
                        print("接收到身份证号码")
                        recv_ID_len = STRGLO[6]
                        if recv_ID_len == 10:
                            dict_in_data['ID'] = STRGLO[7:25].decode()
                        else:
                            print("接收到的身份证长度不对 长度为：" + str((recv_ID_len - 8)))
                    elif commd == 0x83 and addres == 0x1160:
                        # 接收到姓名
                        recv_name_len = STRGLO[6] - 1
                        if 0 < recv_name_len < 5:
                            dict_in_data['name'] = (STRGLO[7:(7 + recv_name_len * 2)]).decode("gbk")
                        else:
                            print("姓名的长度不符合")
                        print(dict_in_data['name'])
                    elif commd == 0x83 and addres == 0x1140:
                        # 接收到姓名
                        recv_company_len = STRGLO[6] - 1
                        if 1 < recv_company_len < 6:
                            dict_in_data['company'] = (STRGLO[7:(7 + recv_company_len * 2)]).decode("gbk")
                        else:
                            print("单位的长度不符合")
                        print(dict_in_data['company'])
                    elif commd == 0x83 and addres == 0x1120:
                        # 接收到性别
                        recv_sex_len = STRGLO[6]
                        if recv_sex_len == 2:
                            str_sex = (STRGLO[7:9]).decode("gbk")
                            if str_sex == '男' or str_sex == '女':
                                dict_in_data['sex'] = str_sex
                            else:
                                print("性别必须为男或者女")
                                dict_in_data['sex'] = ''
                        else:
                            print("姓名的长度不符合")
                        print(dict_in_data['sex'])
                except Exception as e:
                    print("解释命令出错" + str(e))
            else:
                print("命令不认识")
        except Exception as e:
            print(str(e))
    def SlavePortReadData(self):
        ba = self.serialSlave.readAll()
        main_port_recv = QTextCodec.codecForLocale().toUnicode(ba.data())
        self.textInfor.appendPlainText(main_port_recv)
        STRGLO = ba.data()
        try:
            if STRGLO[0] == 0x5a and STRGLO[1] == 0xa5:
                # 获取地址
                addres = STRGLO[4] << 8 | STRGLO[5]
                commd = STRGLO[3]
                recv_len = STRGLO[2]
                print("地址为：" + hex(addres) + "  长度为：" + str(recv_len) + " 命令为：" + hex(commd))
                if addres == 0x2004:
                    self.clear_show_data()
                    self.MaiNwritePort(cmd_write_to_main_page)
                    self.creat_gbk_list_nu('', 0x82, 0x11, 0x60)

        except Exception as e:
            print("接收护士站错据出错：" + str(e))

    def save_exec_data(self):
        try:
            my_xls.save()
            save_xls.save()
        except Exception as e:
            print("保存数据出错：" + str(e))

    def exit_save_data(self):
        try:
            my_xls.save()
            my_xls.close()
            save_xls.save()
            save_xls.close()
            sys.exit(1)
        except Exception as e:
            print("保存数据出错:" + str(e))

if __name__ == "__main__":
    app = QApplication(sys.argv)

    qtmodern.styles.dark(app)

    app.setWindowIcon(QIcon("../monkey.ico"))

    mwin = MainWindow()

    win = qtmodern.windows.ModernWindow(mwin)

    win.show()

    sys.exit(app.exec_())

 3、应用的视频：

总结：总的来说基本功能实现了，还有一些需要进一步完善的地方，慢慢来吧。