jianbin/drug_sensitivity_reaction
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
drug_sensitivity_reaction/micjishu.cpp

3097 lines
105 KiB
C++
Raw Permalink Normal View History

厂家提供原始代码
2025-07-17 08:39:15 +08:00
#include <Python.h>
#include "micjishu.h"
#include "ui_micjishu.h"
#include<QMessageBox>
#include<QScrollBar>
#include<QGraphicsDropShadowEffect>
#include <QtConcurrent/QtConcurrent>
QString id6;
// extern QString xiangcheng;
// extern QString shenghao;
// int x;
// int y;
QString savelujing2;
QSqlDatabase dbmic;
micjishu::micjishu(QWidget *parent) :
QWidget(parent),
ui(new Ui::micjishu)
{
ui->setupUi(this);
getshui();
m_michistoricalrecords=new michistoricalrecords;
m_ziwai=new ziwai;
connect( m_michistoricalrecords, &michistoricalrecords::fanhui, this, [=](){this->showMaximized();m_michistoricalrecords->hide();});
ui->tableWidget->setRowCount(10);
ui->tableWidget->setColumnCount(10);
for (int i=0;i<=ui->tableWidget->rowCount() ;i++ ) {
ui->tableWidget->setRowHeight(i,35);
}
ui->tableWidget->setColumnWidth(0,45);
ui->tableWidget->setColumnWidth(1,127);
ui->tableWidget->setColumnWidth(2,127);
ui->tableWidget->setColumnWidth(3,127);
ui->tableWidget->setColumnWidth(4,48);
ui->tableWidget->setColumnWidth(5,43);
ui->tableWidget->setColumnWidth(6,68);
ui->tableWidget->setColumnWidth(7,43);
ui->tableWidget->setColumnWidth(8,43);
ui->tableWidget->setColumnWidth(9,73);
ui->tableWidget_2->setRowCount(10);
ui->tableWidget_2->setColumnCount(10);
for (int i=0;i<=ui->tableWidget_2->rowCount() ;i++ ) {
ui->tableWidget_2->setRowHeight(i,35);
}
ui->tableWidget_2->setColumnWidth(0,45);
ui->tableWidget_2->setColumnWidth(1,127);
ui->tableWidget_2->setColumnWidth(2,127);
ui->tableWidget_2->setColumnWidth(3,127);
ui->tableWidget_2->setColumnWidth(4,53);
ui->tableWidget_2->setColumnWidth(5,48);
ui->tableWidget_2->setColumnWidth(6,48);
ui->tableWidget_2->setColumnWidth(7,48);
ui->tableWidget_2->setColumnWidth(8,48);
ui->tableWidget_2->setColumnWidth(9,73);
ui->tableWidget->setHorizontalHeaderLabels(headers);
for (int row = 0; row < 10; ++row) { QTableWidgetItem *item = new QTableWidgetItem(xuhao.at(row));
ui->tableWidget->setItem(row, 0, item);}
ui->tableWidget_2->setHorizontalHeaderLabels(headers);
for (int row = 0; row < 10; ++row) { QTableWidgetItem *item = new QTableWidgetItem(xuhao.at(row));
ui->tableWidget_2->setItem(row, 0, item);}
for (int row = 5; row < ui->tableWidget->rowCount(); ++row) {
ui-> tableWidget->setRowHidden(row, true);
}
for (int row = 0; row <5; ++row) {
ui-> tableWidget_2->setRowHidden(row, true);
}
m_zidingyi=new zidingyi;
ui->pushButton_5->setHidden(true);
ui->widget->setFixedSize(745,520);
ui->label_5->setFixedSize(745,520);
ui->label_6->setFixedSize(745,520);
ui->tableWidget_3->setFixedSize(170,800);
ui->tableWidget_2->setFixedSize(745,210);
ui->tableWidget->setFixedSize(745,210);
ui->pushButton->setFixedSize(120,35);
ui->pushButton_2->setFixedSize(92,35);
ui->pushButton_5->setFixedSize(92,35);
ui->pushButton_9->setFixedSize(92,35);
ui->pushButton_10->setFixedSize(92,35);
ui->tableWidget_2->horizontalHeader()->setFixedHeight(40);
ui->tableWidget->horizontalHeader()->setFixedHeight(40);
ui->widget->setHidden(false);
ui->lineEdit->setFixedSize(170,30);
ui->comboBox->setFixedSize(170,30);
ui->comboBox_2->setFixedSize(170,30);
ui->tableWidget->verticalHeader()->setVisible(false);
ui->tableWidget_2->verticalHeader()->setVisible(false);
m_maxtu=new maxtu;
connect(this, SIGNAL(yuan(QPixmap)),m_maxtu, SLOT(getyuan(QPixmap)));
connect(m_zidingyi, SIGNAL(ming(QString)),this, SLOT(getming(QString)));
connect(this, SIGNAL(shuaxin()),m_michistoricalrecords, SLOT(getshuaxin()));
connect(this,&micjishu::shuaxin,m_michistoricalrecords,&michistoricalrecords::getshuaxin);
ui->label_8->setHidden(true);
ui->label_9->setHidden(true);
ui->label_10->setHidden(true);
ui->label_11->setHidden(true);
ui->label_12->setHidden(true);
ui->pushButton_7->setHidden(true);
ui->label_7->setHidden(true);
setMouseTracking(true);
connect(m_michistoricalrecords, SIGNAL(guan2()), this, SLOT(getguan()));
ui->tableWidget->setShowGrid(false);
ui->tableWidget->setVerticalScrollBarPolicy(Qt::ScrollBarAlwaysOff);
ui->tableWidget_2->setShowGrid(false);
ui->tableWidget->setVerticalScrollBarPolicy(Qt::ScrollBarAlwaysOff);
ui->tableWidget_2->setVerticalScrollBarPolicy(Qt::ScrollBarAlwaysOff);
ui->tableWidget_3->setVerticalScrollBarPolicy(Qt::ScrollBarAlwaysOff);
ui->tableWidget_3->setHorizontalScrollBarPolicy(Qt::ScrollBarAlwaysOff);
ui->tableWidget->setHorizontalScrollBarPolicy(Qt::ScrollBarAlwaysOff);
ui->tableWidget_2->setHorizontalScrollBarPolicy(Qt::ScrollBarAlwaysOff);
ui->tableWidget->setSelectionMode(QAbstractItemView::NoSelection);
// 设置鼠标点击行为为不选中任何项
ui->tableWidget->setSelectionBehavior(QAbstractItemView::SelectItems);
ui->tableWidget_2->setSelectionMode(QAbstractItemView::NoSelection);
// 设置鼠标点击行为为不选中任何项
ui->tableWidget_2->setSelectionBehavior(QAbstractItemView::SelectItems);
ui->pushButton_3->setHidden(true);
ui->label_7->setHidden(true);
connect(m_michistoricalrecords, &michistoricalrecords::tuichu2, this, [=](){emit tuichu();});
ui->tableWidget_3->setColumnCount(2);
ui->tableWidget_3->setColumnWidth(0, 170); // 设置第一列宽度，示例为100像素
ui->tableWidget_3->setColumnWidth(1, 0); // 将第二列（列索引为1）的宽度设置为0，实现隐藏效果
ui->tableWidget_3->horizontalHeader()->setVisible(false);
ui->tableWidget_3->verticalHeader()->setVisible(false);
connect(ui->tableWidget_3, &QTableWidget::itemClicked, this, &micjishu::on_tableWidget_3_itemClicked);
QGraphicsDropShadowEffect *shadow = new QGraphicsDropShadowEffect(this);
//设置阴影距离
shadow->setOffset(0, 0);
//设置阴影颜色
shadow->setColor(QColor(214, 214, 214));
//设置阴影圆角
shadow->setBlurRadius(30);
//给嵌套QWidget设置阴影
ui->frame->setFixedSize(1570,907);
ui->frame->setGraphicsEffect(shadow);
QGraphicsDropShadowEffect *shadow2 = new QGraphicsDropShadowEffect(this);
//设置阴影距离
shadow2->setOffset(0, 0);
//设置阴影颜色
shadow2->setColor(QColor(214, 214, 214));
//设置阴影圆角
shadow2->setBlurRadius(30);
ui->frame_2->setFixedSize(175,907);
ui->frame_2->setGraphicsEffect(shadow2);
ui->pushButton_4->setFixedSize(170,30);
ui->pushButton_11->setFixedSize(170,30);
// ui->frame_2->setFixedWidth(1720);
ui->checkBox->setHidden(true);
ui->checkBox_2->setHidden(true);
//ui->lineEdit->setHidden(true);
ui->label_3->setHidden(true);
ui->label_4->setHidden(true);
ui->label_15->setHidden(true);
ui->pushButton_6->setHidden(true);
ui->pushButton_8->setHidden(true);
//ui->pushButton_4->setHidden(true);
ui->label_5->setHidden(false);
ui->label_6->setHidden(true);
m_msgBox=new msgBox;
ui->widget_5->setFixedHeight(50);
timer = new QTimer(this);
connect(m_zidingyi,&zidingyi::quxiao,this,[=](){jixu=false;});
ui->comboBox->setCurrentIndex(-1);
ui->comboBox_2->setCurrentIndex(-1);
connect(this, &micjishu::print, m_pp, &printpage::getprint);
}
micjishu::~micjishu()
{
delete ui;
}
void micjishu::setbiaoge()
{
}
void micjishu::getming(QString s)
{
jixu=true;
ui->label_15->clear();
ui->label_15->setText(s);
m_msgBox->show();
}
void micjishu::on_tableWidget_3_itemClicked(QTableWidgetItem *item)
{
// 获取点击的单元格所在的行索引
int row = item->row();
// 获取该行第一列对应的QTableWidgetItem，假设第一列存放图片路径相关信息
QTableWidgetItem *pixmapItem = ui->tableWidget_3->item(row, 1);
if (pixmapItem) {
// 获取之前设置的图片路径
QString filePath = pixmapItem->text();
qDebug()<<filePath;
QPixmap pixmap(filePath);
if (!pixmap.isNull()) {
ui->label_6->setPixmap(pixmap);
ui->label_6->setScaledContents(true); // 设置图片自动缩放以适应QLabel大小
}
}
}
void micjishu::MICzhi(){
//ECV值
if(zhong=="新型隐球菌（VNⅠ）"){
qDebug()<<"新型隐球菌（VNⅠ）";
ECVList.append("8");
ECVList.append("0.25");
ECVList.append("0.25");
ECVList.append("0.25");
ECVList.append(" ");
ECVList.append(" ");
ECVList.append(" ");
ECVList.append("8");
ECVList.append(" ");
ECVList.append("0.5");
kongzhi();
}else if(zhong=="格特隐球菌（VGⅠ）"){
ECVList.append("16");
ECVList.append("0.5");
ECVList.append("0.5");
ECVList.append(" ");
ECVList.append(" ");
ECVList.append(" ");
ECVList.append(" ");
ECVList.append("4");
ECVList.append(" ");
ECVList.append("0.5");
kongzhi();
}else if(zhong=="格特隐球菌（VGⅡ）"){
ECVList.append("32");
ECVList.append("1");
ECVList.append("0.5");
ECVList.append(" ");
ECVList.append(" ");
ECVList.append(" ");
ECVList.append(" ");
ECVList.append("32");
ECVList.append(" ");
ECVList.append("1");
kongzhi();
}
else if(zhong=="白念珠菌"){
ECVList.append(" ");
ECVList.append(" ");
ECVList.append(" ");
ECVList.append("0.06");
ECVList.append(" ");
ECVList.append(" ");
ECVList.append(" ");
ECVList.append(" ");
ECVList.append(" ");
ECVList.append("2");
SList.append("≤2");
SList.append(" ");
SList.append("≤0.12");
SList.append(" ");
SList.append(" ");
SList.append("≤0.25");
SList.append("≤0.25");
SList.append(" ");
SList.append("≤0.25");
SList.append(" ");
IList.append(" ");
IList.append(" ");
IList.append("0.25-0.5");
IList.append(" ");
IList.append(" ");
IList.append("0.5");
IList.append("0.5");
IList.append(" ");
IList.append("0.5");
IList.append(" ");
SDDList.append("4");
SDDList.append(" ");
SDDList.append(" ");
SDDList.append(" ");
SDDList.append(" ");
SDDList.append(" ");
SDDList.append(" ");
SDDList.append(" ");
SDDList.append(" ");
SDDList.append(" ");
RList.append("≥8");
RList.append(" ");
RList.append("≥1");
RList.append(" ");
RList.append(" ");
RList.append("≥1");
RList.append("≥1");
RList.append(" ");
RList.append("≥1");
RList.append(" ");
} else if(zhong=="光滑念珠菌"){
qDebug() << "光滑念珠菌";
ECVList.append(" ");
ECVList.append("4");
ECVList.append("0.25");
ECVList.append("1");
ECVList.append(" ");
ECVList.append(" ");
ECVList.append(" ");
ECVList.append(" ");
ECVList.append(" ");
ECVList.append("2");
SList.append(" ");
SList.append(" ");
SList.append(" ");
SList.append(" ");
SList.append(" ");
SList.append("≤0.12");
SList.append("≤0.06");
SList.append(" ");
SList.append("≤0.12");
SList.append(" ");
IList.append(" ");
IList.append(" ");
IList.append(" ");
IList.append(" ");
IList.append(" ");
IList.append("0.25");
IList.append("0.12");
IList.append(" ");
IList.append("0.25");
IList.append(" ");
SDDList.append("≤32");
SDDList.append(" ");
SDDList.append(" ");
SDDList.append(" ");
SDDList.append(" ");
SDDList.append(" ");
SDDList.append(" ");
SDDList.append(" ");
SDDList.append(" ");
SDDList.append(" ");
RList.append("≥64");
RList.append(" ");
RList.append(" ");
RList.append(" ");
RList.append(" ");
RList.append("≥0.5");
RList.append("≥0.25");
RList.append(" ");
RList.append("≥0.5");
RList.append(" ");
} else if(zhong=="热带念珠菌"){
qDebug() << "热带念珠菌";
ECVList.append(" ");
ECVList.append("0.5");
ECVList.append(" ");
ECVList.append("0.12");
ECVList.append(" ");
ECVList.append(" ");
ECVList.append(" ");
ECVList.append(" ");
ECVList.append(" ");
ECVList.append("2");
SList.append("≤2");
SList.append(" ");
SList.append("0.12");
SList.append(" ");
SList.append(" ");
SList.append("≤0.25");
SList.append("≤0.25");
SList.append(" ");
SList.append("≤0.25");
SList.append(" ");
IList.append(" ");
IList.append(" ");
IList.append("0.25-0.5");
IList.append(" ");
IList.append(" ");
IList.append("0.5");
IList.append("0.5");
IList.append(" ");
IList.append("0.5");
IList.append(" ");
SDDList.append("4");
SDDList.append(" ");
SDDList.append(" ");
SDDList.append(" ");
SDDList.append(" ");
SDDList.append(" ");
SDDList.append(" ");
SDDList.append(" ");
SDDList.append(" ");
SDDList.append(" ");
RList.append("≥8");
RList.append(" ");
RList.append("≥1");
RList.append(" ");
RList.append(" ");
RList.append("≥1");
RList.append("≥1");
RList.append(" ");
RList.append("≥1");
RList.append(" ");
}else if(zhong=="近平滑念珠菌"){
ECVList.append(" ");
ECVList.append("0.5");
ECVList.append(" ");
ECVList.append("0.25");
ECVList.append(" ");
ECVList.append(" ");
ECVList.append(" ");
ECVList.append(" ");
ECVList.append(" ");
ECVList.append("1");
SList.append("≤2");
SList.append(" ");
SList.append("0.12");
SList.append(" ");
SList.append(" ");
SList.append("≤2");
SList.append("≤2");
SList.append(" ");
SList.append("≤2");
SList.append(" ");
IList.append(" ");
IList.append(" ");
IList.append("0.25-0.5");
IList.append(" ");
IList.append(" ");
IList.append("4");
IList.append("4");
IList.append(" ");
IList.append("4");
IList.append(" ");
SDDList.append("4");
SDDList.append(" ");
SDDList.append(" ");
SDDList.append(" ");
SDDList.append(" ");
SDDList.append(" ");
SDDList.append(" ");
SDDList.append(" ");
SDDList.append(" ");
SDDList.append(" ");
RList.append("≥8");
RList.append(" ");
RList.append("≥1");
RList.append(" ");
RList.append(" ");
RList.append("≥8");
RList.append("≥8");
RList.append(" ");
RList.append("≥8");
RList.append(" ");
}else if(zhong=="克柔念珠菌"){
ECVList.append(" ");
ECVList.append("1");
ECVList.append(" ");
ECVList.append("0.5");
ECVList.append(" ");
ECVList.append(" ");
ECVList.append(" ");
ECVList.append(" ");
ECVList.append(" ");
ECVList.append("2");
SList.append(" ");
SList.append(" ");
SList.append("≤0.5");
SList.append(" ");
SList.append(" ");
SList.append("≤0.25");
SList.append("≤0.25");
SList.append(" ");
SList.append("≤0.25");
SList.append(" ");
IList.append(" ");
IList.append(" ");
IList.append("1");
IList.append(" ");
IList.append(" ");
IList.append("0.5");
IList.append("0.5");
IList.append(" ");
IList.append("0.5");
IList.append(" ");
SDDList.append(" ");
SDDList.append(" ");
SDDList.append(" ");
SDDList.append(" ");
SDDList.append(" ");
SDDList.append(" ");
SDDList.append(" ");
SDDList.append(" ");
SDDList.append(" ");
SDDList.append(" ");
RList.append("≥1");
RList.append(" ");
RList.append("≥2");
RList.append(" ");
RList.append(" ");
RList.append("≥1");
RList.append("≥1");
RList.append(" ");
RList.append("≥1");
RList.append(" ");
}else if(zhong=="季也蒙念珠菌"){
ECVList.append("8");
ECVList.append("2");
ECVList.append(" ");
ECVList.append("0.5");
ECVList.append(" ");
ECVList.append(" ");
ECVList.append(" ");
ECVList.append(" ");
ECVList.append(" ");
ECVList.append("2");
SList.append(" ");
SList.append(" ");
SList.append(" ");
SList.append(" ");
SList.append(" ");
SList.append("≤2");
SList.append("≤2");
SList.append(" ");
SList.append("≤2");
SList.append(" ");
IList.append(" ");
IList.append(" ");
IList.append(" ");
IList.append(" ");
IList.append(" ");
IList.append("4");
IList.append("4");
IList.append(" ");
IList.append("4");
IList.append(" ");
SDDList.append(" ");
SDDList.append(" ");
SDDList.append(" ");
SDDList.append(" ");
SDDList.append(" ");
SDDList.append(" ");
SDDList.append(" ");
SDDList.append(" ");
SDDList.append(" ");
SDDList.append(" ");
RList.append(" ");
RList.append(" ");
RList.append(" ");
RList.append(" ");
RList.append(" ");
RList.append("≥8");
RList.append("≥8");
RList.append(" ");
RList.append("≥8");
RList.append(" ");
}else if(zhong=="都柏林念珠菌"){
ECVList.append("0.5");
ECVList.append("0.25");
ECVList.append(" ");
ECVList.append("0.12");
ECVList.append(" ");
ECVList.append(" ");
ECVList.append("0.12");
ECVList.append(" ");
ECVList.append("0.12");
ECVList.append("0.5");
SList.append(" ");
SList.append(" ");
SList.append(" ");
SList.append(" ");
SList.append(" ");
SList.append(" ");
SList.append(" ");
SList.append(" ");
SList.append(" ");
SList.append(" ");
IList.append(" ");
IList.append(" ");
IList.append(" ");
IList.append(" ");
IList.append(" ");
IList.append(" ");
IList.append(" ");
IList.append(" ");
IList.append(" ");
IList.append(" ");
SDDList.append(" ");
SDDList.append(" ");
SDDList.append(" ");
SDDList.append(" ");
SDDList.append(" ");
SDDList.append(" ");
SDDList.append(" ");
SDDList.append(" ");
SDDList.append(" ");
SDDList.append(" ");
RList.append(" ");
RList.append(" ");
RList.append(" ");
RList.append(" ");
RList.append(" ");
RList.append(" ");
RList.append(" ");
RList.append(" ");
RList.append(" ");
RList.append(" ");
}else if(zhong=="烟曲霉"){
ECVList.append(" ");
ECVList.append("1");
ECVList.append(" ");
ECVList.append(" ");
ECVList.append("1");
ECVList.append("0.5");
ECVList.append(" ");
ECVList.append(" ");
ECVList.append(" ");
ECVList.append("2");
SList.append(" ");
SList.append(" ");
SList.append("≤0.5");
SList.append(" ");
SList.append(" ");
SList.append(" ");
SList.append(" ");
SList.append(" ");
SList.append(" ");
SList.append(" ");
SDDList.append(" ");
SDDList.append(" ");
SDDList.append(" ");
SDDList.append(" ");
SDDList.append(" ");
SDDList.append(" ");
SDDList.append(" ");
SDDList.append(" ");
SDDList.append(" ");
SDDList.append(" ");
IList.append(" ");
IList.append(" ");
IList.append("1");
IList.append(" ");
IList.append(" ");
IList.append(" ");
IList.append(" ");
IList.append(" ");
IList.append(" ");
IList.append(" ");
RList.append(" ");
RList.append(" ");
RList.append("≥2");
RList.append(" ");
RList.append(" ");
RList.append(" ");
RList.append(" ");
RList.append(" ");
RList.append(" ");
RList.append(" ");
}
else if(zhong=="黄曲霉"){
ECVList.append(" ");
ECVList.append("1");
ECVList.append("2");
ECVList.append("0.5");
ECVList.append("1");
ECVList.append("0.5");
ECVList.append(" ");
ECVList.append(" ");
ECVList.append(" ");
ECVList.append("4");
kongzhi();
}else if(zhong=="黑曲霉"){
ECVList.append(" ");
ECVList.append("4");
ECVList.append("2");
ECVList.append("2");
ECVList.append("4");
ECVList.append("0.25");
ECVList.append(" ");
ECVList.append(" ");
ECVList.append(" ");
ECVList.append("2");
kongzhi();
}else if(zhong=="土曲霉"){
ECVList.append(" ");
ECVList.append("2");
ECVList.append("2");
ECVList.append("1");
ECVList.append("1");
ECVList.append("0.12");
ECVList.append(" ");
ECVList.append(" ");
ECVList.append(" ");
ECVList.append("4");
kongzhi();
}else{
ECVList.append(" ");
ECVList.append(" ");
ECVList.append(" ");
ECVList.append(" ");
ECVList.append(" ");
ECVList.append(" ");
ECVList.append(" ");
ECVList.append(" ");
ECVList.append(" ");
ECVList.append(" ");
kongzhi();
}
for (int row = 0; row < 10; ++row)
{
QTableWidgetItem *item4 = new QTableWidgetItem(ECVList.at(row));
ui->tableWidget->setItem(row, 4, item4);
}
for (int row = 0; row < 10; ++row)
{
QTableWidgetItem *item4 = new QTableWidgetItem(SList.at(row));
ui->tableWidget->setItem(row, 5, item4);
}
for (int row = 0; row < 10; ++row)
{
QTableWidgetItem *item4 = new QTableWidgetItem(IList.at(row));
ui->tableWidget->setItem(row, 6, item4);
}
for (int row = 0; row < 10; ++row)
{
QTableWidgetItem *item4 = new QTableWidgetItem(SDDList.at(row));
ui->tableWidget->setItem(row, 7, item4);
}
for (int row = 0; row < 10; ++row)
{
QTableWidgetItem *item4 = new QTableWidgetItem(RList.at(row));
ui->tableWidget->setItem(row, 8, item4);
}
qDebug() << "SList:" << SList;
qDebug() << "IList:" << IList;
qDebug() << "SDDList:" << SDDList;
qDebug() << "RList:" << RList;
};
void micjishu::kongzhi(){
SList.append(" ");
SList.append(" ");
SList.append(" ");
SList.append(" ");
SList.append(" ");
SList.append(" ");
SList.append(" ");
SList.append(" ");
SList.append(" ");
SList.append(" ");
SDDList.append(" ");
SDDList.append(" ");
SDDList.append(" ");
SDDList.append(" ");
SDDList.append(" ");
SDDList.append(" ");
SDDList.append(" ");
SDDList.append(" ");
SDDList.append(" ");
SDDList.append(" ");
IList.append(" ");
IList.append(" ");
IList.append(" ");
IList.append(" ");
IList.append(" ");
IList.append(" ");
IList.append(" ");
IList.append(" ");
IList.append(" ");
IList.append(" ");
RList.append(" ");
RList.append(" ");
RList.append(" ");
RList.append(" ");
RList.append(" ");
RList.append(" ");
RList.append(" ");
RList.append(" ");
RList.append(" ");
RList.append(" ");
};
void micjishu::usepython()
{
// Py_SetPythonHome(L"C:/ProgramData/Anaconda3");
Py_SetPythonHome(L"D:/python");
Py_Initialize();
PyRun_SimpleString("import sys");
PyRun_SimpleString("sys.argv = ['python.py']");
PyRun_SimpleString("sys.path.append('./')");
PyObject* pModule = PyImport_ImportModule("MIC_main");
if (!pModule)
{
PyErr_Print();
qDebug()<<"Cant open python file!\n";
QMessageBox::information(NULL, "提示", "图片识别有误，请重试");
m_msgBox->close();
return; // 提前返回避免继续执行
}
else{
qDebug()<<"file of python ac been opened";}
PyObject* pFunhello= PyObject_GetAttrString(pModule,"main_function");
if(!pFunhello){
qDebug()<<"Get function hello failed";
QMessageBox::information(NULL, "提示", "图片识别有误，请重试");
m_msgBox->close();
return; // 提前返回避免继续执行
}
else
{
PyObject* args = PyTuple_New(7); // 创建一个包含2个元素的元组用于存放参数
// 设置第一个参数，这里假设是整数类型，设置为10，可根据实际需求替换数值
PyObject* arg1 = PyUnicode_FromString("use/MIC/MIC/药敏板药物信息示例/药敏板药物信息示例.xlsx");
PyTuple_SetItem(args, 0, arg1);
PyObject* arg2 = PyUnicode_FromString("use/MIC/MIC/药敏板药物信息示例/药敏板药品判读规则表格.xlsx");
PyTuple_SetItem(args, 1, arg2);
PyObject* arg3 = PyUnicode_FromString("use/MIC/MIC/药敏板药物信息示例/MIC解释标准及ECV值.xlsx");
PyTuple_SetItem(args, 2, arg3);
PyObject* arg4 = PyUnicode_FromString(savelujing2.toUtf8().constData());
PyTuple_SetItem(args, 3, arg4);
PyObject* arg5 = PyUnicode_FromString("use/4.png");
PyTuple_SetItem(args, 4, arg5);
shu= ui->comboBox->currentText();
QByteArray byteArray = shu.toUtf8();
PyObject* arg6 = PyUnicode_FromString(byteArray.constData());
PyTuple_SetItem(args, 5, arg6);
zhong= ui->comboBox_2->currentText();
QByteArray byteArray2 = zhong.toUtf8();
PyObject* arg7 = PyUnicode_FromString(byteArray2.constData());
PyTuple_SetItem(args, 6, arg7);
PyObject* result = PyObject_CallObject(pFunhello, args);
if (!result)
{ PyErr_Print();
qDebug() << "Call function failed";
QMessageBox::information(NULL, "提示", "图片识别有误，请重试");
m_msgBox->close();
return; // 提前返回避免继续执行
}
else
{//配1
//这里是如果能接受返回值
if (PyTuple_Check(result))
{//配2
// 获取元组中的元素个数
Py_ssize_t tupleSize = PyTuple_Size(result);
if (tupleSize == 5)
{
// 获取第一个列表并处理
PyObject* list1 = PyTuple_GetItem(result, 0);
if (PyList_Check(list1))
{
Py_ssize_t list1Size = PyList_Size(list1);
if (list1Size == 10)
{
for (Py_ssize_t i = 0; i < list1Size; ++i) {
PyObject* element = PyList_GetItem(list1, i);
if (PyUnicode_Check(element)) {
const char* str = PyUnicode_AsUTF8(element);
chineseNames.append(QString::fromUtf8(str));
}
}
for (int row = 0; row < 10; ++row)
{
QTableWidgetItem *item1 = new QTableWidgetItem(chineseNames.at(row));
ui->tableWidget->setItem(row, 1, item1);
}
}
else
{
qDebug() << "The first returned list does not have 3 elements as expected";
}
}
else
{
qDebug() << "The first element in the returned tuple is not a list as expected";
}
// 获取第二个列表并处理
PyObject* list2 = PyTuple_GetItem(result, 1);
if (PyList_Check(list2))
{
Py_ssize_t list2Size = PyList_Size(list2);
if (list2Size == 10)
{
for (Py_ssize_t i = 0; i < list2Size; ++i) {
PyObject* element = PyList_GetItem(list2, i);
if (PyUnicode_Check(element)) {
const char* str = PyUnicode_AsUTF8(element);
englishNames.append(QString::fromUtf8(str));
}
}
for (int row = 0; row < 10; ++row)
{
QTableWidgetItem *item2 = new QTableWidgetItem(englishNames.at(row));
ui->tableWidget->setItem(row, 2, item2);
}
}
else
{
qDebug() << "The second returned list does not have 3 elements as expected";
}
}
else
{
qDebug() << "The second element in the returned tuple is not a list as expected";
}
// 获取第三个列表并处理
PyObject* list3 = PyTuple_GetItem(result, 2);
if (PyList_Check(list3))
{
Py_ssize_t list13Size = PyList_Size(list3);
if (list13Size == 10)
{
for (Py_ssize_t i = 0; i < list13Size; ++i) {
PyObject* element = PyList_GetItem(list3, i);
if (PyUnicode_Check(element)) {
const char* str = PyUnicode_AsUTF8(element);
if(shu=="曲霉属"&&(i==5||i==6||i==8)){
micValues.append(" ");
}else{
micValues.append(QString::fromUtf8(str));
}
}
}
for (int row = 0; row < 10; ++row)
{
QTableWidgetItem *item3 = new QTableWidgetItem(micValues.at(row));
ui->tableWidget->setItem(row, 3, item3);
}
}
else
{
qDebug() << "The first returned list does not have 3 elements as expected";
}
}
else
{
qDebug() << "The first element in the returned tuple is not a list as expected";
}
// 获取第四个列表并处理
PyObject* list4 = PyTuple_GetItem(result, 3);
if (PyList_Check(list4))
{
Py_ssize_t list41Size = PyList_Size(list4);
if (list41Size == 10)
{
MICzhi();
for (Py_ssize_t i = 0; i < list41Size; ++i) {
PyObject* element = PyList_GetItem(list4, i);
if (!element || !PyUnicode_Check(element)) {
explanations.append("无效的Python对象");
continue;
}
const char* str = PyUnicode_AsUTF8(element);
if (!str) {
explanations.append("Python字符串转换失败");
continue;
}
// 检查 micValues 和 ECVList 是否越界
if (i >= micValues.size() || i >= ECVList.size()) {
explanations.append("数据不足");
continue;
}
qDebug()<<zhong;
if (zhong == "新型隐球菌（VNⅠ）"&&(i == 0 || i == 1 || i == 2 || i == 3 || i == 7|| i == 9)) {
bool ok1, ok2;
double micValue = micValues[i].toDouble(&ok1);
double ecvValue = ECVList[i].toDouble(&ok2);
if (!ok1 || !ok2) {
explanations.append("数值转换失败");
} else if (micValue <= ecvValue) {
explanations.append("野生型");
} else {
explanations.append("非野生型");
}
} else if (zhong == "新型隐球菌（VNⅠ）"&&(i == 5 || i == 6 || i == 8)) {
explanations.append("天然耐药");
}else if (zhong == "格特隐球菌（VGⅠ）"&&(i == 0 || i == 1 || i == 2 || i == 7|| i == 9)) {
qDebug()<<"格特隐球菌（VNⅠ）";
bool ok1, ok2;
double micValue = micValues[i].toDouble(&ok1);
double ecvValue = ECVList[i].toDouble(&ok2);
if (!ok1 || !ok2) {
explanations.append("数值转换失败");
} else if (micValue <= ecvValue) {
explanations.append("野生型");
} else {
explanations.append("非野生型");
}
} else if (zhong == "格特隐球菌（VGⅠ）"&&(i == 5 || i == 6 || i == 8) ){
explanations.append("天然耐药");
}else if (zhong == "格特隐球菌（VGⅡ）"&&(i == 0 || i == 1 || i == 2 || i == 7|| i == 9)) {
qDebug()<<"格特隐球菌（VGⅡ）";
bool ok1, ok2;
double micValue = micValues[i].toDouble(&ok1);
double ecvValue = ECVList[i].toDouble(&ok2);
if (!ok1 || !ok2) {
explanations.append("数值转换失败");
} else if (micValue <= ecvValue) {
explanations.append("野生型");
} else {
explanations.append("非野生型");
}
} else if (zhong == "格特隐球菌（VGⅡ）"&&(i == 5 || i == 6 || i == 8) ){
explanations.append("天然耐药");
}
else if(shu=="曲霉属"&&i==0){
explanations.append("天然耐药");
}else if(shu=="曲霉属"&&(i==5||i==6||i==8)){
explanations.append("");
//另外需要都ECV值？？
}else if (zhong == "克柔念珠菌" && i == 0) {
explanations.append("天然耐药");
}
else {
QString utf8Str = QString::fromUtf8(str);
if(utf8Str=="S"){
utf8Str="敏感";
}else if(utf8Str=="I"){
utf8Str="中介";
}else if(utf8Str=="SDD"){
utf8Str="剂量依赖性敏感";
}else if(utf8Str=="R"){
utf8Str="耐药";
}
explanations.append(utf8Str);
qDebug() << "Element at index" << i << ": " << utf8Str;
}
}
qDebug()<<"mic值"<<micValues;
qDebug()<<"ecv值"<<ECVList;
for (int row = 0; row < 10; ++row)
{
QTableWidgetItem *item4 = new QTableWidgetItem(explanations.at(row));
ui->tableWidget->setItem(row, 9, item4);
}
}
else
{
qDebug() << "The first returned list does not have 3 elements as expected";
}
}
else
{
qDebug() << "The first element in the returned tuple is not a list as expected";
}
// 获取第五个列表并处理
PyObject* MIC_position_list = PyTuple_GetItem(result, 4);
if (PyList_Check(MIC_position_list)) {
Py_ssize_t positionListSize = PyList_Size(MIC_position_list);
for (Py_ssize_t i = 0; i < positionListSize; ++i) {
PyObject* element = PyList_GetItem(MIC_position_list, i);
if (PyTuple_Check(element)) {
Py_ssize_t tupleElementSize = PyTuple_Size(element);
if (tupleElementSize == 2) {
PyObject* xObj = PyTuple_GetItem(element, 0);
PyObject* yObj = PyTuple_GetItem(element, 1);
if (PyLong_Check(xObj) && PyLong_Check(yObj)) {
long x = PyLong_AsLong(xObj);
long y = PyLong_AsLong(yObj);
//qDebug() << "MIC Position: (" << x << ", " << y << ")";
QString positionStr = QString("(%1, %2)").arg(x).arg(y);
positionStrList.append(positionStr);
}
}
}
}
}
chineseNames.clear();
englishNames.clear();
micValues.clear();
explanations.clear();
positionStrList.clear();
ECVList.clear();
SList.clear();
IList.clear();
SDDList.clear();
RList.clear();
//为表格增加序号1-10
for (int row = 0; row < 10; ++row) { QTableWidgetItem *item = new QTableWidgetItem(xuhao.at(row));
ui->tableWidget->setItem(row, 0, item);}
for (int row = 0; row < 10; ++row) { QTableWidgetItem *item = new QTableWidgetItem(xuhao.at(row));
ui->tableWidget_2->setItem(row, 0, item);}
//文字居中
for (int i = 0; i < ui->tableWidget->rowCount(); ++i) {
for (int j = 0; j < ui->tableWidget->columnCount(); ++j) {
QTableWidgetItem *item = ui->tableWidget->item(i, j);
if (item) {
item->setTextAlignment(Qt::AlignHCenter | Qt::AlignVCenter);
}
}
}
for (int i = 0; i < ui->tableWidget_2->rowCount(); ++i) {
for (int j = 0; j < ui->tableWidget_2->columnCount(); ++j) {
QTableWidgetItem *item = ui->tableWidget_2->item(i, j);
if (item) {
item->setTextAlignment(Qt::AlignHCenter | Qt::AlignVCenter);
}
}
}
//显示图片
QString aFile = QString("use/4.png");
ui->label_5->setHidden(true);
ui->label_6->setHidden(false);
ui->label_6->setPixmap(aFile);
ui->label_6->setScaledContents(true);
fenge();
QPalette palette = ui->tableWidget->palette();
QColor color2= Qt::white;
QColor color1 = QColor(229,247,255);
for (int i = 0; i < ui->tableWidget->rowCount(); ++i) {
for (int col = 0; col < ui->tableWidget->columnCount(); ++col) {
QTableWidgetItem *item = ui->tableWidget->item(i, col);
if (!item) {
item = new QTableWidgetItem();
ui->tableWidget->setItem(i, col, item);
}
if (i % 2 == 0) {
item->setBackground(QBrush(color1));
} else {
item->setBackground(QBrush(color2));
}
}
}
for (int i = 0; i < ui->tableWidget->rowCount(); ++i) {
for (int col = 0; col < ui->tableWidget->columnCount(); ++col) {
QTableWidgetItem *item = ui->tableWidget_2->item(i, col);
if (!item) {
item = new QTableWidgetItem();
ui->tableWidget->setItem(i, col, item);
}
if (i % 2 == 0) {
item->setBackground(QBrush(color2));
} else {
item->setBackground(QBrush(color1));
}
}
}
get();
QString timeStamp = QDate::currentDate().toString("yyyy-MM-dd");
QString folderName = "use/micpandu/" + timeStamp;
QString timeStampFull = QTime::currentTime().toString("hh-mm-ss");
//如果没有自命名
if(ui->label_15->text().isEmpty()){
savePath3 = folderName + "/" + timeStampFull + "_Y" + ".png";
savePath4 = folderName + "/" + timeStampFull + "_J" + ".png";
savePath5 = folderName + "/" + timeStampFull + ".csv";
QPixmap pixmap = ui->label_5->pixmap();
QPixmap pixmap2 = ui->label_6->pixmap();
// 开启事务，确保操作的原子性
dbmic.transaction();
// 第一步：更新现有行的 xuhao，使其序号依次加 1
// 从最大的 xuhao 开始递减更新，避免 xuhao 冲突
QSqlQuery updateQuery(dbmic);
updateQuery.prepare("SELECT MAX(xuhao) FROM micjishu");
if (updateQuery.exec() && updateQuery.next()) {
int maxXuhao = updateQuery.value(0).toInt();
for (int i = maxXuhao; i >= 1; --i) {
QSqlQuery updateXuhaoQuery(dbmic);
updateXuhaoQuery.prepare("UPDATE micjishu SET xuhao = :newXuhao WHERE xuhao = :oldXuhao");
updateXuhaoQuery.bindValue(":newXuhao", i + 1);
updateXuhaoQuery.bindValue(":oldXuhao", i);
if (!updateXuhaoQuery.exec()) {
qDebug() << "更新 xuhao 失败:" << updateXuhaoQuery.lastError().text();
// 回滚事务
dbmic.rollback();
return;
}
}
} else {
qDebug() << "获取最大 xuhao 失败:" << updateQuery.lastError().text();
// 回滚事务
dbmic.rollback();
return;
}
// 新增：插入多列数据
QSqlQuery query(dbmic);
query.prepare("INSERT INTO micjishu (xuhao, time, yuanshi, jieguo, xiangcheng,junshu,junzhong,weihao,shenghao,caozuo) VALUES ( :xuhao,:time, :yuanshi, :jieguo, :xiangcheng, :junshu, :junzhong, :weihao, :shenghao,:caozuo)");
query.bindValue(":xuhao", 1);
query.bindValue(":time", gettime());
query.bindValue(":yuanshi", savePath3);
query.bindValue(":jieguo", savePath4);
query.bindValue(":xiangcheng", "真菌药敏试剂盒");
query.bindValue(":junshu", ui->comboBox->currentText());
query.bindValue(":junzhong", ui->comboBox_2->currentText());
query.bindValue(":weihao", ui->label_9->text());
query.bindValue(":shenghao", ui->label_10->text());
query.bindValue(":caozuo", savePath5);
if (!query.exec()) {
qDebug() << "插入多列数据失败:" << query.lastError().text();
// 回滚事务
dbmic.rollback();
return;
}
// 提交事务
if (dbmic.commit()) {
qDebug() << "数据插入并重新排序成功";
emit shuaxin();
} else {
qDebug() << "事务提交失败:" << dbmic.lastError().text();
}
QTableWidgetItem *filePathItem = new QTableWidgetItem();
filePathItem->setText(savePath4);
QTableWidgetItem *pixmapItem = new QTableWidgetItem();
if (pixmap2.isNull()) {
qDebug() << "图片加载失败，请检查文件路径和图片格式是否正确";
return;
}
// 对图片进行缩放，保持长宽比使其适应指定大小（这里设置为100x100）
pixmap2 = pixmap2.scaled(170, 120, Qt::KeepAspectRatio, Qt::SmoothTransformation);
pixmapItem->setIcon(QIcon(pixmap2));
ui->tableWidget_3->setIconSize(QSize(170,120));
// 插入新行
ui->tableWidget_3->insertRow(row);
// 将Pixmap对应的Item添加到第一列
ui->tableWidget_3->setItem(row, 0, pixmapItem);
// 将文件路径对应的Item添加到第二列
ui->tableWidget_3->setItem(row, 1, filePathItem);
ui->tableWidget_3->setRowHeight(row,130);
row++;
m_msgBox->close();
}
else{
QString zidingyi=ui->label_15->text();
savePath = folderName + "/" + zidingyi + "_Y" + ".png";
savePath2 = folderName + "/" + zidingyi + "_J" + ".png";
savePath6 = folderName + "/" + zidingyi + ".csv";
QPixmap pixmap = ui->label_5->pixmap();
QPixmap pixmap2 = ui->label_6->pixmap();
// 开启事务，确保操作的原子性
dbmic.transaction();
// 第一步：更新现有行的 xuhao，使其序号依次加 1
// 从最大的 xuhao 开始递减更新，避免 xuhao 冲突
QSqlQuery updateQuery(dbmic);
updateQuery.prepare("SELECT MAX(xuhao) FROM micjishu");
if (updateQuery.exec() && updateQuery.next()) {
int maxXuhao = updateQuery.value(0).toInt();
for (int i = maxXuhao; i >= 1; --i) {
QSqlQuery updateXuhaoQuery(dbmic);
updateXuhaoQuery.prepare("UPDATE micjishu SET xuhao = :newXuhao WHERE xuhao = :oldXuhao");
updateXuhaoQuery.bindValue(":newXuhao", i + 1);
updateXuhaoQuery.bindValue(":oldXuhao", i);
if (!updateXuhaoQuery.exec()) {
qDebug() << "更新 xuhao 失败:" << updateXuhaoQuery.lastError().text();
// 回滚事务
dbmic.rollback();
return;
}
}
} else {
qDebug() << "获取最大 xuhao 失败:" << updateQuery.lastError().text();
// 回滚事务
dbmic.rollback();
return;
}
// 新增：插入多列数据
QSqlQuery query(dbmic);
query.prepare("INSERT INTO micjishu (xuhao, time, yuanshi, jieguo, xiangcheng,junshu,junzhong,weihao,shenghao,caozuo) VALUES ( :xuhao,:time, :yuanshi, :jieguo, :xiangcheng, :junshu, :junzhong, :weihao, :shenghao,:caozuo)");
query.bindValue(":xuhao", 1);
query.bindValue(":time", gettime());
query.bindValue(":yuanshi", savePath);
query.bindValue(":jieguo", savePath2);
query.bindValue(":xiangcheng", "真菌药敏试剂盒");
query.bindValue(":junshu", ui->comboBox->currentText());
query.bindValue(":junzhong", ui->comboBox_2->currentText());
query.bindValue(":weihao", ui->label_9->text());
query.bindValue(":shenghao", ui->label_10->text());
query.bindValue(":caozuo", savePath5);
if (!query.exec()) {
qDebug() << "插入多列数据失败:" << query.lastError().text();
// 回滚事务
dbmic.rollback();
return;
}
// 提交事务
if (dbmic.commit()) {
qDebug() << "数据插入并重新排序成功";
emit shuaxin();
} else {
qDebug() << "事务提交失败:" << dbmic.lastError().text();
}
QTableWidgetItem *filePathItem = new QTableWidgetItem();
filePathItem->setText(savePath2);
QTableWidgetItem *pixmapItem = new QTableWidgetItem();
if (pixmap2.isNull()) {
qDebug() << "图片加载失败，请检查文件路径和图片格式是否正确";
return;
}
// 对图片进行缩放，保持长宽比使其适应指定大小（这里设置为100x100）
pixmap2 = pixmap2.scaled(170, 120, Qt::KeepAspectRatio, Qt::SmoothTransformation);
pixmapItem->setIcon(QIcon(pixmap2));
ui->tableWidget_3->setIconSize(QSize(170,120));
// 插入新行
ui->tableWidget_3->insertRow(row);
// 将Pixmap对应的Item添加到第一列
ui->tableWidget_3->setItem(row, 0, pixmapItem);
// 将文件路径对应的Item添加到第二列
ui->tableWidget_3->setItem(row, 1, filePathItem);
ui->tableWidget_3->setRowHeight(row,130);
row++;
m_msgBox->close();
}
QtConcurrent::run(&micjishu::savezhao, this);
//第五个结束
}
else
{
qDebug() << "Returned tuple does not have 2 elements as expected";
}
}
else
{
qDebug() << "Function did not return a tuple as expected";
}
}//配1
// 释放资源，遵循引用计数规则
}
}
void micjishu::usepython2()
{
PyObject* pModule = PyImport_ImportModule("MIC_main");
if (!pModule)
{
PyErr_Print();
qDebug()<<"Cant open python file!\n";
QMessageBox::information(NULL, "提示", "图片识别有误，请重试");
m_msgBox->close();
return; // 提前返回避免继续执行
}
else{
qDebug()<<"file of python ac been opened";}
PyObject* pFunhello= PyObject_GetAttrString(pModule,"add_position");
if(!pFunhello){
PyErr_Print();
qDebug()<<"Get function hello failed";
QMessageBox::information(NULL, "提示", "图片识别有误，请重试");
m_msgBox->close();
return; // 提前返回避免继续执行
}
else
{
PyObject* args = PyTuple_New(9); // 创建一个包含2个元素的元组用于存放参数
// 设置第一个参数，这里假设是整数类型，设置为10，可根据实际需求替换数值
// 设置第一个参数，这里假设是整数类型，设置为10，可根据实际需求替换数值
PyObject* arg1 = PyUnicode_FromString("use/MIC/MIC/药敏板药物信息示例/药敏板药物信息示例.xlsx");
PyTuple_SetItem(args, 0, arg1);
PyObject* arg2 = PyUnicode_FromString("use/MIC/MIC/药敏板药物信息示例/药敏板药品判读规则表格.xlsx");
PyTuple_SetItem(args, 1, arg2);
PyObject* arg3 = PyUnicode_FromString("use/MIC/MIC/药敏板药物信息示例/MIC解释标准及ECV值.xlsx");
PyTuple_SetItem(args, 2, arg3);
PyObject* arg4 = PyUnicode_FromString("use/MIC/MIC/data/res/img_copy.png");
PyTuple_SetItem(args, 3, arg4);
PyObject* arg5 = PyUnicode_FromString("use/3.png");
PyTuple_SetItem(args, 4, arg5);
float a=x*5.498 ;
float b=y*5.2154;
int xx=a;
int yy=b;
qDebug()<<x;
qDebug()<<y;
qDebug()<<xx;
qDebug()<<yy;
PyObject* arg6 = PyLong_FromLong(xx);
PyTuple_SetItem(args, 5, arg6);
PyObject* arg7 = PyLong_FromLong(yy);
PyTuple_SetItem(args, 6, arg7);
QString shu= ui->comboBox->currentText();
QByteArray byteArray = shu.toUtf8();
PyObject* arg8 = PyUnicode_FromString(byteArray.constData());
PyTuple_SetItem(args, 7, arg8);
QString zhong= ui->comboBox_2->currentText();
QByteArray byteArray2 = zhong.toUtf8();
PyObject* arg9 = PyUnicode_FromString(byteArray2.constData());
PyTuple_SetItem(args, 8, arg9);
PyObject* result = PyObject_CallObject(pFunhello, args);
if (!result)
{ PyErr_Print();
qDebug() << "Call function failed";
QMessageBox::information(NULL, "提示", "图片识别有误，请重试");
m_msgBox->close();
return; // 提前返回避免继续执行
}
else
{
//配1
//这里是如果能接受返回值
if (PyTuple_Check(result))
{//配2
// 获取元组中的元素个数
Py_ssize_t tupleSize = PyTuple_Size(result);
if (tupleSize == 5)
{
// 获取第一个列表并处理
PyObject* list1 = PyTuple_GetItem(result, 0);
if (PyList_Check(list1))
{
Py_ssize_t list1Size = PyList_Size(list1);
if (list1Size == 10)
{
for (Py_ssize_t i = 0; i < list1Size; ++i) {
PyObject* element = PyList_GetItem(list1, i);
if (PyUnicode_Check(element)) {
const char* str = PyUnicode_AsUTF8(element);
chineseNames.append(QString::fromUtf8(str));
}
}
for (int row = 0; row < 10; ++row)
{
QTableWidgetItem *item1 = new QTableWidgetItem(chineseNames.at(row));
ui->tableWidget->setItem(row, 1, item1);
}
}
else
{
qDebug() << "The first returned list does not have 3 elements as expected";
}
}
else
{
qDebug() << "The first element in the returned tuple is not a list as expected";
}
// 获取第二个列表并处理
PyObject* list2 = PyTuple_GetItem(result, 1);
if (PyList_Check(list2))
{
Py_ssize_t list2Size = PyList_Size(list2);
if (list2Size == 10)
{
for (Py_ssize_t i = 0; i < list2Size; ++i) {
PyObject* element = PyList_GetItem(list2, i);
if (PyUnicode_Check(element)) {
const char* str = PyUnicode_AsUTF8(element);
englishNames.append(QString::fromUtf8(str));
}
}
for (int row = 0; row < 10; ++row)
{
QTableWidgetItem *item2 = new QTableWidgetItem(englishNames.at(row));
ui->tableWidget->setItem(row, 2, item2);
}
}
else
{
qDebug() << "The second returned list does not have 3 elements as expected";
}
}
else
{
qDebug() << "The second element in the returned tuple is not a list as expected";
}
// 获取第三个列表并处理
PyObject* list3 = PyTuple_GetItem(result, 2);
if (PyList_Check(list3))
{
Py_ssize_t list13Size = PyList_Size(list3);
if (list13Size == 10)
{
for (Py_ssize_t i = 0; i < list13Size; ++i) {
PyObject* element = PyList_GetItem(list3, i);
if (PyUnicode_Check(element)) {
const char* str = PyUnicode_AsUTF8(element);
if(shu=="曲霉属"&&(i==5||i==6||i==8)){
micValues.append(" ");
}else{
micValues.append(QString::fromUtf8(str));
}
}
}
for (int row = 0; row < 10; ++row)
{
QTableWidgetItem *item3 = new QTableWidgetItem(micValues.at(row));
ui->tableWidget->setItem(row, 3, item3);
}
}
else
{
qDebug() << "The first returned list does not have 3 elements as expected";
}
}
else
{
qDebug() << "The first element in the returned tuple is not a list as expected";
}
// 获取第四个列表并处理
PyObject* list4 = PyTuple_GetItem(result, 3);
if (PyList_Check(list4))
{
Py_ssize_t list41Size = PyList_Size(list4);
if (list41Size == 10)
{
MICzhi();
for (Py_ssize_t i = 0; i < list41Size; ++i) {
PyObject* element = PyList_GetItem(list4, i);
if (!element || !PyUnicode_Check(element)) {
explanations.append("无效的Python对象");
continue;
}
const char* str = PyUnicode_AsUTF8(element);
if (!str) {
explanations.append("Python字符串转换失败");
continue;
}
// 检查 micValues 和 ECVList 是否越界
if (i >= micValues.size() || i >= ECVList.size()) {
explanations.append("数据不足");
continue;
}
qDebug()<<zhong;
if (zhong == "新型隐球菌（VNⅠ）"&&(i == 0 || i == 1 || i == 2 || i == 3 || i == 7|| i == 9)) {
bool ok1, ok2;
double micValue = micValues[i].toDouble(&ok1);
double ecvValue = ECVList[i].toDouble(&ok2);
if (!ok1 || !ok2) {
explanations.append("数值转换失败");
} else if (micValue <= ecvValue) {
explanations.append("野生型");
} else {
explanations.append("非野生型");
}
} else if (zhong == "新型隐球菌（VNⅠ）"&&(i == 5 || i == 6 || i == 8)) {
explanations.append("天然耐药");
}else if (zhong == "格特隐球菌（VGⅠ）"&&(i == 0 || i == 1 || i == 2 || i == 7|| i == 9)) {
qDebug()<<"格特隐球菌（VNⅠ）";
bool ok1, ok2;
double micValue = micValues[i].toDouble(&ok1);
double ecvValue = ECVList[i].toDouble(&ok2);
if (!ok1 || !ok2) {
explanations.append("数值转换失败");
} else if (micValue <= ecvValue) {
explanations.append("野生型");
} else {
explanations.append("非野生型");
}
} else if (zhong == "格特隐球菌（VGⅠ）"&&(i == 5 || i == 6 || i == 8) ){
explanations.append("天然耐药");
}else if (zhong == "格特隐球菌（VGⅡ）"&&(i == 0 || i == 1 || i == 2 || i == 7|| i == 9)) {
qDebug()<<"格特隐球菌（VGⅡ）";
bool ok1, ok2;
double micValue = micValues[i].toDouble(&ok1);
double ecvValue = ECVList[i].toDouble(&ok2);
if (!ok1 || !ok2) {
explanations.append("数值转换失败");
} else if (micValue <= ecvValue) {
explanations.append("野生型");
} else {
explanations.append("非野生型");
}
} else if (zhong == "格特隐球菌（VGⅡ）"&&(i == 5 || i == 6 || i == 8) ){
explanations.append("天然耐药");
}
else if(shu=="曲霉属"&&i==0){
explanations.append("天然耐药");
}else if(shu=="曲霉属"&&(i==5||i==6||i==8)){
explanations.append("");
//另外需要都ECV值？？
}else if (zhong == "克柔念珠菌" && i == 0) {
explanations.append("天然耐药");
}
else {
QString utf8Str = QString::fromUtf8(str);
if(utf8Str=="S"){
utf8Str="敏感";
}else if(utf8Str=="I"){
utf8Str="中介";
}else if(utf8Str=="SDD"){
utf8Str="剂量依赖性敏感";
}else if(utf8Str=="R"){
utf8Str="耐药";
}
explanations.append(utf8Str);
qDebug() << "Element at index" << i << ": " << utf8Str;
}
}
qDebug()<<"mic值"<<micValues;
qDebug()<<"ecv值"<<ECVList;
for (int row = 0; row < 10; ++row)
{
QTableWidgetItem *item4 = new QTableWidgetItem(explanations.at(row));
ui->tableWidget->setItem(row, 9, item4);
}
}
else
{
qDebug() << "The first returned list does not have 3 elements as expected";
}
}
else
{
qDebug() << "The first element in the returned tuple is not a list as expected";
}
// 获取第五个列表并处理
PyObject* MIC_position_list = PyTuple_GetItem(result, 4);
if (PyList_Check(MIC_position_list)) {
Py_ssize_t positionListSize = PyList_Size(MIC_position_list);
for (Py_ssize_t i = 0; i < positionListSize; ++i) {
PyObject* element = PyList_GetItem(MIC_position_list, i);
if (PyTuple_Check(element)) {
Py_ssize_t tupleElementSize = PyTuple_Size(element);
if (tupleElementSize == 2) {
PyObject* xObj = PyTuple_GetItem(element, 0);
PyObject* yObj = PyTuple_GetItem(element, 1);
if (PyLong_Check(xObj) && PyLong_Check(yObj)) {
long x = PyLong_AsLong(xObj);
long y = PyLong_AsLong(yObj);
//qDebug() << "MIC Position: (" << x << ", " << y << ")";
QString positionStr = QString("(%1, %2)").arg(x).arg(y);
positionStrList.append(positionStr);
}
}
}
}
}
}
}
ui->label_5->setHidden(true);
ui->label_6->setHidden(false);
QString aFile = QString("use/3.png");
ui->label_6->setPixmap(aFile);
ui->label_6->setScaledContents(true);
get();
QString folderName;
QString timeStamp = QDate::currentDate().toString("yyyy-MM-dd");
folderName = "use/micpandu/" + timeStamp;
QString timeStampFull = QTime::currentTime().toString("hh-mm-ss");
if(ui->label_15->text().isEmpty()){
savePath5 = folderName + "/" + timeStampFull + ".csv";
savePath44 = folderName + "/" + timeStampFull + "_C" + ".png";
savePath33 = folderName + "/" + timeStampFull + "_Y" + ".png";
QPixmap pixmap = ui->label_5->pixmap();
QPixmap pixmap2 = ui->label_6->pixmap();
// 开启事务，确保操作的原子性
dbmic.transaction();
// 第一步：更新现有行的 xuhao，使其序号依次加 1
// 从最大的 xuhao 开始递减更新，避免 xuhao 冲突
QSqlQuery updateQuery(dbmic);
updateQuery.prepare("SELECT MAX(xuhao) FROM micjishu");
if (updateQuery.exec() && updateQuery.next()) {
int maxXuhao = updateQuery.value(0).toInt();
for (int i = maxXuhao; i >= 1; --i) {
QSqlQuery updateXuhaoQuery(dbmic);
updateXuhaoQuery.prepare("UPDATE micjishu SET xuhao = :newXuhao WHERE xuhao = :oldXuhao");
updateXuhaoQuery.bindValue(":newXuhao", i + 1);
updateXuhaoQuery.bindValue(":oldXuhao", i);
if (!updateXuhaoQuery.exec()) {
qDebug() << "更新 xuhao 失败:" << updateXuhaoQuery.lastError().text();
// 回滚事务
dbmic.rollback();
return;
}
}
} else {
qDebug() << "获取最大 xuhao 失败:" << updateQuery.lastError().text();
// 回滚事务
dbmic.rollback();
return;
}
// 新增：插入多列数据
QSqlQuery query(dbmic);
query.prepare("INSERT INTO micjishu (xuhao, time, yuanshi, jieguo, xiangcheng,junshu,junzhong,weihao,shenghao,caozuo) VALUES ( :xuhao,:time, :yuanshi, :jieguo, :xiangcheng, :junshu, :junzhong, :weihao, :shenghao,:caozuo)");
query.bindValue(":xuhao", 1);
query.bindValue(":time", gettime());
query.bindValue(":yuanshi", savePath33);
query.bindValue(":jieguo", savePath44);
query.bindValue(":xiangcheng", "真菌药敏试剂盒");
query.bindValue(":junshu", ui->comboBox->currentText());
query.bindValue(":junzhong", ui->comboBox_2->currentText());
query.bindValue(":weihao", ui->label_9->text());
query.bindValue(":shenghao", ui->label_10->text());
query.bindValue(":caozuo", savePath5);
if (!query.exec()) {
qDebug() << "插入多列数据失败:" << query.lastError().text();
// 回滚事务
dbmic.rollback();
return;
}
// 提交事务
if (dbmic.commit()) {
qDebug() << "数据插入并重新排序成功";
emit shuaxin();
} else {
qDebug() << "事务提交失败:" << dbmic.lastError().text();
}
QTableWidgetItem *filePathItem = new QTableWidgetItem();
filePathItem->setText(savePath44);
QTableWidgetItem *pixmapItem = new QTableWidgetItem();
if (pixmap2.isNull()) {
qDebug() << "图片加载失败，请检查文件路径和图片格式是否正确";
return;
}
// 对图片进行缩放，保持长宽比使其适应指定大小（这里设置为100x100）
pixmap2 = pixmap2.scaled(170, 120, Qt::KeepAspectRatio, Qt::SmoothTransformation);
pixmapItem->setIcon(QIcon(pixmap2));
ui->tableWidget_3->setIconSize(QSize(170,120));
// 插入新行
ui->tableWidget_3->insertRow(row);
// 将Pixmap对应的Item添加到第一列
ui->tableWidget_3->setItem(row, 0, pixmapItem);
// 将文件路径对应的Item添加到第二列
ui->tableWidget_3->setItem(row, 1, filePathItem);
ui->tableWidget_3->setRowHeight(row,130);
row++;
m_msgBox->close();
}
else{
QString zidingyi=ui->label_15->text();
savePath6 = folderName + "/" + zidingyi + ".csv";
savePath11 = folderName + "/" + zidingyi + "_Y" + ".png";
savePath22 = folderName + "/" + zidingyi + "_C" + ".png";
QPixmap pixmap = ui->label_5->pixmap();
QPixmap pixmap2 = ui->label_6->pixmap();
// 开启事务，确保操作的原子性
dbmic.transaction();
// 第一步：更新现有行的 xuhao，使其序号依次加 1
// 从最大的 xuhao 开始递减更新，避免 xuhao 冲突
QSqlQuery updateQuery(dbmic);
updateQuery.prepare("SELECT MAX(xuhao) FROM micjishu");
if (updateQuery.exec() && updateQuery.next()) {
int maxXuhao = updateQuery.value(0).toInt();
for (int i = maxXuhao; i >= 1; --i) {
QSqlQuery updateXuhaoQuery(dbmic);
updateXuhaoQuery.prepare("UPDATE micjishu SET xuhao = :newXuhao WHERE xuhao = :oldXuhao");
updateXuhaoQuery.bindValue(":newXuhao", i + 1);
updateXuhaoQuery.bindValue(":oldXuhao", i);
if (!updateXuhaoQuery.exec()) {
qDebug() << "更新 xuhao 失败:" << updateXuhaoQuery.lastError().text();
// 回滚事务
dbmic.rollback();
return;
}
}
} else {
qDebug() << "获取最大 xuhao 失败:" << updateQuery.lastError().text();
// 回滚事务
dbmic.rollback();
return;
}
// 新增：插入多列数据
QSqlQuery query(dbmic);
query.prepare("INSERT INTO micjishu (xuhao, time, yuanshi, jieguo, xiangcheng,junshu,junzhong,weihao,shenghao,caozuo) VALUES ( :xuhao,:time, :yuanshi, :jieguo, :xiangcheng, :junshu, :junzhong, :weihao, :shenghao,:caozuo)");
query.bindValue(":xuhao", 1);
query.bindValue(":time", gettime());
query.bindValue(":yuanshi", savePath11);
query.bindValue(":jieguo", savePath22);
query.bindValue(":xiangcheng", "真菌药敏试剂盒");
query.bindValue(":junshu", ui->comboBox->currentText());
query.bindValue(":junzhong", ui->comboBox_2->currentText());
query.bindValue(":weihao", ui->label_9->text());
query.bindValue(":shenghao", ui->label_10->text());
query.bindValue(":caozuo", savePath6);
if (!query.exec()) {
qDebug() << "插入多列数据失败:" << query.lastError().text();
// 回滚事务
dbmic.rollback();
return;
}
// 提交事务
if (dbmic.commit()) {
qDebug() << "数据插入并重新排序成功";
emit shuaxin();
} else {
qDebug() << "事务提交失败:" << dbmic.lastError().text();
}
QTableWidgetItem *filePathItem = new QTableWidgetItem();
filePathItem->setText(savePath22);
QTableWidgetItem *pixmapItem = new QTableWidgetItem();
if (pixmap2.isNull()) {
qDebug() << "图片加载失败，请检查文件路径和图片格式是否正确";
return;
}
// 对图片进行缩放，保持长宽比使其适应指定大小（这里设置为100x100）
pixmap2 = pixmap2.scaled(170, 120, Qt::KeepAspectRatio, Qt::SmoothTransformation);
pixmapItem->setIcon(QIcon(pixmap2));
ui->tableWidget_3->setIconSize(QSize(170,120));
// 插入新行
ui->tableWidget_3->insertRow(row);
// 将Pixmap对应的Item添加到第一列
ui->tableWidget_3->setItem(row, 0, pixmapItem);
// 将文件路径对应的Item添加到第二列
ui->tableWidget_3->setItem(row, 1, filePathItem);
ui->tableWidget_3->setRowHeight(row,130);
row++;
m_msgBox->close();
}
fenge();
QPalette palette = ui->tableWidget->palette();
QColor color2= Qt::white;
QColor color1 = QColor(229,247,255);
for (int i = 0; i < ui->tableWidget->rowCount(); ++i) {
for (int col = 0; col < ui->tableWidget->columnCount(); ++col) {
QTableWidgetItem *item = ui->tableWidget->item(i, col);
if (!item) {
item = new QTableWidgetItem();
ui->tableWidget->setItem(i, col, item);
}
if (i % 2 == 0) {
item->setBackground(QBrush(color1));
} else {
item->setBackground(QBrush(color2));
}
}
}
for (int i = 0; i < ui->tableWidget->rowCount(); ++i) {
for (int col = 0; col < ui->tableWidget->columnCount(); ++col) {
QTableWidgetItem *item = ui->tableWidget_2->item(i, col);
if (!item) {
item = new QTableWidgetItem();
ui->tableWidget->setItem(i, col, item);
}
if (i % 2 == 0) {
item->setBackground(QBrush(color2));
} else {
item->setBackground(QBrush(color1));
}
}
}
for (int i = 0; i < ui->tableWidget->rowCount(); ++i) {
for (int j = 0; j < ui->tableWidget->columnCount(); ++j) {
QTableWidgetItem *item = ui->tableWidget->item(i, j);
if (item) {
item->setTextAlignment(Qt::AlignHCenter | Qt::AlignVCenter);
}
}
}
for (int i = 0; i < ui->tableWidget_2->rowCount(); ++i) {
for (int j = 0; j < ui->tableWidget_2->columnCount(); ++j) {
QTableWidgetItem *item = ui->tableWidget_2->item(i, j);
if (item) {
item->setTextAlignment(Qt::AlignHCenter | Qt::AlignVCenter);
}
}
}
QtConcurrent::run(&micjishu::savezhao2, this);
}
}
}
void micjishu::mouseDoubleClickEvent(QMouseEvent *event)
{
if (ui->label_6->geometry().contains(event->pos())) {
// 判断是否是左键点击
if (event->button() == Qt::LeftButton) {
QPoint posInLabel = event->pos() - ui->label_6->pos();
x = posInLabel.x();
y = posInLabel.y();
m_msgBox->show();
QTimer::singleShot(100,this,[=](){
chineseNames.clear();
englishNames.clear();
micValues.clear();
explanations.clear();
positionStrList.clear();
ECVList.clear();
SList.clear();
IList.clear();
SDDList.clear();
RList.clear();
usepython2();});
// 获取鼠标在全局屏幕上的坐标
QPoint globalPos = event->globalPos();
qDebug() << "在全局屏幕上的左键点击坐标: " << globalPos;
}
}
QWidget::mouseDoubleClickEvent(event);
}
void micjishu::getshui()
{
ui->comboBox->clear();
ui->comboBox_2->clear();
QString queryString = QString("SELECT name FROM junshu");
QSqlQuery mquery;
if (!mquery.exec(queryString)) {
}
while (mquery.next()) {
QVariant value = mquery.value(0);
ui->comboBox->addItem(value.toString());
}
}
void micjishu::on_comboBox_currentIndexChanged(const QString &arg1)
{
}
void micjishu::on_pushButton_4_clicked()
{
// m_michistoricalrecords->showFullScreen();
// m_michistoricalrecords->getshui();
QScrollBar *scrollBar = ui->tableWidget_3->verticalScrollBar();
// 获取当前滚动条的位置
int currentValue = scrollBar->value();
// 向下滑动的偏移量，可以根据需要调整
int offset = 100;
// 设置新的滚动条位置
scrollBar->setValue(currentValue - offset);
}
//拍照
void micjishu::on_pushButton_2_clicked()
{
if(ui->pushButton->text()=="已连接")
{
if(!ui->comboBox->currentText().isEmpty()){
m_zidingyi->exec();
m_zidingyi->focus();
timer->stop();
if(jixu==true){
ui->label_5->setHidden(false);
ui->label_5->clear();
ui->label_6->setHidden(true);
QTimer::singleShot(1,this,[=](){ m_cammer.zhuapai();});
QTimer::singleShot(500,this,[=](){
QPixmap p;
p.load(savelujing2);
// p.load("use/3_Y.png");
ui->label_5->setScaledContents(true);
ui->label_5->setPixmap(p);
QTimer::singleShot(100,this,[=](){
qDebug()<<"开始调用mic算法";
chineseNames.clear();
englishNames.clear();
micValues.clear();
explanations.clear();
positionStrList.clear();
ECVList.clear();
SList.clear();
IList.clear();
SDDList.clear();
RList.clear();
usepython();
});
});
}
}else{
QMessageBox::information(NULL, "提示", "请先选择菌属和菌种" );
}
}else{
QMessageBox::information(NULL, "提示", "请先连接相机" );
}
}
void micjishu::savezhao()
{
QString folderName;
QString timeStamp = QDate::currentDate().toString("yyyy-MM-dd");
folderName = "use/micpandu/" + timeStamp;
QDir dir(folderName);
if (!dir.exists()) {
if (!dir.mkpath(folderName)) {
qDebug() << "Failed to create directory: " << folderName;
return;
}
}
if (ui->label_15->text().isEmpty()) {
QString timeStampFull = QTime::currentTime().toString("hh-mm-ss");
QPixmap pixmap = ui->label_5->pixmap();
QPixmap pixmap2 = ui->label_6->pixmap();
if (pixmap.save(savePath3)) {
qDebug() << "Saved pixmap to: " << savePath3;
} else {
qDebug() << "Failed to save pixmap to: " << savePath3;
}
if (pixmap2.save(savePath4)) {
qDebug() << "Saved pixmap2 to: " << savePath4;
} else {
qDebug() << "Failed to save pixmap2 to: " << savePath4;
}
if (!savePath5.isEmpty()) {
exportTableWidgetToCsv(ui->tableWidget,savePath5);
};
ui->label_7->setText(savePath5);
} else {
QPixmap pixmap = ui->label_5->pixmap();
QPixmap pixmap2 = ui->label_6->pixmap();
if (pixmap.save(savePath)) {
qDebug() << "Saved pixmap to: " << savePath;
} else {
qDebug() << "Failed to save pixmap to: " << savePath;
}
if (pixmap2.save(savePath2)) {
qDebug() << "Saved pixmap2 to: " << savePath2;
} else {
qDebug() << "Failed to save pixmap2 to: " << savePath2;
}
if (!savePath6.isEmpty()) {
exportTableWidgetToCsv(ui->tableWidget,savePath6);
};
ui->label_7->setText(savePath6);
}
}
//重新拍照
void micjishu::on_pushButton_5_clicked()
{
}
void micjishu::on_comboBox_currentTextChanged(const QString &arg1)
{
ui->comboBox_2->clear();
QString sql=QString("select name from junzhong where shuname='%1'").arg(arg1);
qDebug()<<sql;
QSqlQuery mquery;
if (!mquery.exec(sql)) {
}
while (mquery.next()) {
QVariant value = mquery.value(0);
ui->comboBox_2->addItem(value.toString());
}
}
QString micjishu::getname()
{
QString sql=QString("select usersname from users where id='%1'").arg(id6);
qDebug()<<sql;
QSqlQuery query;
if(query.exec(sql))
{
if(query.first()){
QString str1=query.value(0).toString();
qDebug()<<str1;
return str1;
}
}
else
{
qDebug()<<"没查到名字";
}
}
QString micjishu::gettime()
{
QDateTime dateTime= QDateTime::currentDateTime();//获取系统当前的时间
QString str = dateTime .toString("yyyy-MM-dd hh:mm:ss");//格式化时间
return str;
}
//保存
void micjishu::savezhao2()
{
QString folderName;
QString timeStamp = QDate::currentDate().toString("yyyy-MM-dd");
folderName = "use/micpandu/" + timeStamp;
QDir dir(folderName);
if (!dir.exists()) {
if (!dir.mkpath(folderName)) {
qDebug() << "Failed to create directory: " << folderName;
return;
}
}
if (ui->label_15->text().isEmpty()) {
QString timeStampFull = QTime::currentTime().toString("hh-mm-ss");
QPixmap pixmap = ui->label_5->pixmap();
QPixmap pixmap2 = ui->label_6->pixmap();
if (pixmap.save(savePath33)) {
qDebug() << "Saved pixmap to: " << savePath33;
} else {
qDebug() << "Failed to save pixmap to: " << savePath33;
QMessageBox::information(NULL, "提示", "原图保存失败");
}
if (pixmap2.save(savePath44)) {
qDebug() << "Saved pixmap2 to: " << savePath44;
} else {
qDebug() << "Failed to save pixmap2 to: " << savePath44;
QMessageBox::information(NULL, "提示", "结果图保存失败");
}
if (!savePath5.isEmpty()) {
exportTableWidgetToCsv(ui->tableWidget,savePath5);
};
ui->label_7->setText(savePath5);
} else {
QPixmap pixmap = ui->label_5->pixmap();
QPixmap pixmap2 = ui->label_6->pixmap();
if (pixmap.save(savePath11)) {
qDebug() << "Saved pixmap to: " << savePath11;
} else {
qDebug() << "Failed to save pixmap to: " << savePath11;
QMessageBox::information(NULL, "提示", "原图保存失败");
}
if (pixmap2.save(savePath22)) {
qDebug() << "Saved pixmap2 to: " << savePath22;
} else {
QMessageBox::information(NULL, "提示", "结果图保存失败");
qDebug() << "Failed to save pixmap2 to: " << savePath22;
}
if (!savePath6.isEmpty()) {
exportTableWidgetToCsv(ui->tableWidget,savePath6);
};
ui->label_7->setText(savePath6);
}
}
void micjishu::on_pushButton_3_clicked()
{
}
//连接相机
void micjishu::on_pushButton_clicked()
{
ui->widget->setmic();
QTimer::singleShot(100,this,[=](){
if (!ui->widget->CameraOpen())
{
qDebug()<<"shibai";
QMessageBox::information(NULL, "提示", "连接相机失败" );
}
else{qDebug()<<"chenggog";
ui->widget->CameraStart();
ui->widget->resetStatistic();
/* ui->widget->SetExpose()*/;
// m_staticTimer.start(100);
//ui->pushButton_2->setEnabled(true);
ui->pushButton->setText("已连接");
}
SerialPort.setPortName("COM3");
// 打开串口
if(SerialPort.open(QIODevice::ReadWrite))
{
SerialPort.setBaudRate(QSerialPort::Baud9600);
SerialPort.setDataBits(QSerialPort::Data8);
SerialPort.setStopBits(QSerialPort::OneStop);
SerialPort.setParity(QSerialPort::NoParity);
SerialPort.setFlowControl(QSerialPort::NoFlowControl);
qDebug()<<"成功打开串口COM3";
QTimer::singleShot(10,this,[=](){
SerialPort.write("$1101E60");});
QTimer::singleShot(10,this,[=](){
SerialPort.write("$2204C63");});
}
else {
qDebug() << "打开 COM3 失败，原因: " << SerialPort.errorString();
}
});
}
void micjishu::on_radioButton_clicked()
{
}
void micjishu::getkai()
{
qDebug()<<"getkaimic";
ui->pushButton_2->setHidden(false);
// ui->pushButton_2->setEnabled(false);
ui->pushButton_5->setHidden(true);
ui->pushButton->setText("连接相机");
ui->pushButton->setEnabled(true);
ui->label_5->clear();
ui->label_6->clear();
// ui->tableWidget_3->clear();
ui->tableWidget_2->clear();
ui->tableWidget->clear();
// ui->widget->setHidden(true);
//ui->label_5->setHidden(false);
ui->lineEdit->clear();
ui->label_4->setText("条码信息:");
QStringList headers;
headers << "序号"<<"抗菌药物(中文名)" << "抗菌药物(英文名)" << "MIC值(μg/ml)" <<"ECV"<<"S"<<"I"<<"SDD"<<"R"<<"结果";
ui->tableWidget->setHorizontalHeaderLabels(headers);
ui->tableWidget_2->setHorizontalHeaderLabels(headers);
QPalette palette = ui->tableWidget->palette();
QColor color2 = Qt::white;
QColor color1 = QColor(229,247,255);
for (int i = 0; i < ui->tableWidget->rowCount(); ++i) {
for (int col = 0; col < ui->tableWidget->columnCount(); ++col) {
QTableWidgetItem *item = ui->tableWidget->item(i, col);
if (!item) {
item = new QTableWidgetItem();
ui->tableWidget->setItem(i, col, item);
}
if (i % 2 == 0) {
item->setBackground(QBrush(color1));
} else {
item->setBackground(QBrush(color2));
}
}
}
for (int i = 0; i < ui->tableWidget_2->rowCount(); ++i) {
for (int col = 0; col < ui->tableWidget_2->columnCount(); ++col) {
QTableWidgetItem *item = ui->tableWidget_2->item(i, col);
if (!item) {
item = new QTableWidgetItem();
ui->tableWidget_2->setItem(i, col, item);
}
if (i % 2 == 0) {
item->setBackground(QBrush(color2));
} else {
item->setBackground(QBrush(color1));
}
}
}
}
void micjishu::getguan()
{
if( ui->widget->CameraStop()){
qDebug()<<"MICget关1";
}
if(ui->widget->CameraClose())
{
qDebug()<<"MICget关2";
}
SerialPort.write("$2101E63");
QTimer::singleShot(100,this,[=](){
SerialPort.write("$2204C63");
}
);
QTimer::singleShot(500,this,[=](){
SerialPort.close();
SerialPort4.close();
timer->stop();
}
);
}
void micjishu::on_checkBox_clicked()
{ /* if(ui->checkBox->isChecked()){SerialPort.write("$210381C");}
else{SerialPort.write("$220381F");}*/
if(ui->checkBox->isChecked()){
SerialPort.write("$110381F");
}
else {
SerialPort.write("$210381C");
}
}
void micjishu::on_checkBox_2_clicked()
{
if(ui->checkBox_2->isChecked()){SerialPort.write("$1200A66");}
else{SerialPort.write("$2201E60");}
}
//查看
void micjishu::on_pushButton_6_clicked()
{
get();
QTimer::singleShot(100,this,[=](){ QSqlQuery query;
QString targetId = ui->label_8->text();
QString str=QString("SELECT tu FROM yaominban WHERE id = '%1'").arg(targetId);
qDebug()<<str;
query.prepare(str);
query.exec(str);
if (query.next()) {
QByteArray tuData = query.value(0).toByteArray();
// qDebug()<<tuData;
QPixmap pixmap;
if (pixmap.loadFromData(tuData)) {
//ui->label_6->setPixmap(pixmap);
emit yuan(pixmap);
m_maxtu->setWindowModality(Qt::ApplicationModal);
m_maxtu->show();
// ui->label->show();
} else {
qDebug() << "无法从数据加载图片";
}
} else {
qDebug() << "未找到对应id的记录";
}});
// emit yuan(aFile);
// m_maxtu->setWindowModality(Qt::ApplicationModal);
// m_maxtu->show();
}
QString micjishu::getLabelSubstring(QLabel *label, int start, int end)
{
QString text = label->text(); // 获取QLabel中的文本
return text.mid(start, end - start + 1); // 返回从start到end的子字符串
}
void micjishu::get()
{
QString fullText = ui->lineEdit->text();
QStringList parts = fullText.split(" "); // 按空格分割文本为字符串列表
if (parts.size() >= 5) {
// 将分割后的五个部分依次设置到对应的QLabel上
ui->label_8->setText(parts[0]);
//xiangcheng=ui->label_8->text();
ui->label_9->setText(parts[1]);
// 这里假设还有ui->label_10、ui->label_11、ui->label_12等用来显示其他部分
ui->label_10->setText(parts[2]);
// shenghao=ui->label_10->text();
ui->label_11->setText(parts[3]);
ui->label_12->setText(parts[4]);
}
}
void micjishu::on_pushButton_7_clicked()
{
}
#include <QTableWidget>
#include <QFile>
#include <QTextStream>
#include <QDebug>
// 函数用于将QTableWidget的数据导出为CSV格式的文本文件
void micjishu::exportTableWidgetToCsv(QTableWidget* tableWidget, const QString& filePath)
{
QFile file(filePath);
if (file.open(QIODevice::WriteOnly | QIODevice::Text)) {
QTextStream out(&file);
out.setEncoding(QStringConverter::Utf8);
// 写入UTF-8 BOM头（如果需要确保文件以UTF-8编码被正确识别，可根据实际情况选择是否添加）
out << "\xEF\xBB\xBF";
// 获取表头数据并写入文件
QStringList headers;
int columnCount = tableWidget->columnCount();
for (int col = 0; col < columnCount; ++col) {
QTableWidgetItem* headerItem = tableWidget->horizontalHeaderItem(col);
if (headerItem) {
headers.append(headerItem->text());
}
}
for (int col = 0; col < headers.size(); ++col) {
out << headers[col];
if (col < headers.size() - 1) {
out << ",";
}
}
out << "\n";
int rowCount = tableWidget->rowCount();
for (int row = 0; row < rowCount; ++row) {
for (int column = 0; column < columnCount; ++column) {
QTableWidgetItem* item = tableWidget->item(row, column);
if (item) {
out << item->text();
}
if (column < columnCount - 1) {
out << ",";
}
}
out << "\n";
}
file.close();
qDebug() << "TableWidget data exported to CSV file successfully.";
} else {
qDebug() << "Error opening file for writing: " << file.errorString();
}
}
void micjishu::loadCsvToTableWidget(const QString& filePath, QTableWidget* tableWidget)
{
QFile file(filePath);
if (file.open(QIODevice::ReadOnly | QIODevice::Text)) {
QTextStream in(&file);
QString line = in.readLine();
QStringList headers = line.split(",");
tableWidget->setColumnCount(headers.size());
tableWidget->setHorizontalHeaderLabels(headers);
int row = 0;
while (!in.atEnd()) {
line = in.readLine();
QStringList fields = line.split(",");
tableWidget->insertRow(row);
for (int col = 0; col < fields.size(); ++col) {
QTableWidgetItem* item = new QTableWidgetItem(fields[col]);
tableWidget->setItem(row, col, item);
}
row++;
}
file.close();
} else {
// 文件打开失败的处理
qDebug() << "Error opening file: "<< file.errorString();
}
}
void micjishu::fenge()
{
int rows = ui->tableWidget->rowCount();
int cols = ui->tableWidget->columnCount();
for (int row = 0; row < rows; ++row) {
for (int col = 0; col < cols; ++col) {
// 获取源表格中的单元格
QTableWidgetItem* sourceItem = ui->tableWidget->item(row, col);
if (sourceItem) {
// 获取单元格的数据
QVariant data = sourceItem->data(Qt::DisplayRole);
// 创建新的表格单元格用于目标表格
QTableWidgetItem* targetItem = new QTableWidgetItem(data.toString());
// 复制文本对齐方式
targetItem->setTextAlignment(sourceItem->textAlignment());
// 复制背景颜色（如果有设置）
QBrush brush = sourceItem->background();
targetItem->setBackground(brush);
// 在目标表格中设置新的单元格
ui->tableWidget_2->setItem(row, col, targetItem);
}
}
}
}
void micjishu::on_lineEdit_editingFinished()
{/*
ui->lineEdit->clear();
*/
}
void micjishu::on_pushButton_8_clicked()
{
get();
QTimer::singleShot(100,this,[=](){ QSqlQuery query;
QString targetId = ui->label_8->text();
QString str=QString("SELECT name FROM yaominban WHERE id = '%1'").arg(targetId);
qDebug()<<str;
query.prepare(str);
query.exec(str);
if (query.next()) {
QString name=query.value(0).toString();
name=name.simplified();
qDebug()<<name;
ui->lineEdit->setText(name);
ui->label_4->setText("项目名称:");
}
});
}
void micjishu::on_pushButton_9_clicked()
{
// 获取应用程序目录的父目录
QString appDir = QCoreApplication::applicationDirPath();
QDir dir(appDir);
// if (dir.cdUp()) { // 尝试返回上一级目录
// appDir = dir.absolutePath();
// } else {
// qDebug() << "无法返回上一级目录，使用原始目录";
// }
// 构建完整路径
QString initialDir = QDir::toNativeSeparators(appDir + "/use/micpandu");
qDebug() << initialDir;
// 检查目录是否存在
QDir targetDir(initialDir);
if (!targetDir.exists()) {
qDebug() << "目录不存在，使用文档目录作为替代";
initialDir = QStandardPaths::writableLocation(QStandardPaths::DocumentsLocation);
}
// 创建文件对话框对象
QFileDialog fileDialog;
// 设置文件对话框的标题
fileDialog.setWindowTitle("打开文件");
// 设置文件对话框的文件模式为只允许选择文件
fileDialog.setFileMode(QFileDialog::ExistingFile);
// 设置文件对话框的初始目录
fileDialog.setDirectory(initialDir);
if (fileDialog.exec() == QDialog::Accepted) {
QStringList fileNames = fileDialog.selectedFiles();
// 输出用户选择的文件路径
qDebug() << "选择的文件路径: " << fileNames.at(0);
ui->label_6->setHidden(true);
ui->label_5->setHidden(false);
ui->label_5->setPixmap(fileNames.at(0));
ui->label_5->setScaledContents(true);
int result = QMessageBox::information(NULL, "提示", "是否要将此照片进行重新判读", QMessageBox::Ok | QMessageBox::Cancel);
if (result == QMessageBox::Ok) {
if(!ui->comboBox->currentText().isEmpty()){
m_zidingyi->exec();
timer->stop();
QTimer::singleShot(100,this,[=](){
qDebug()<<"开始调用mic算法";
chineseNames.clear();
englishNames.clear();
micValues.clear();
explanations.clear();
positionStrList.clear();
savelujing2=fileNames.at(0);
usepython();
});
}else{
QMessageBox::information(NULL, "提示", "请先选择菌属和菌种" );
}
}
} else {
// 用户取消了文件选择
qDebug() << "用户取消了文件选择";
}
}
void micjishu::on_radioButton_2_clicked()
{
// ui->stackedWidget->setCurrentIndex(1);
// m_michistoricalrecords->showFullScreen();
// m_michistoricalrecords->getshui();
}
//点击扫码
void micjishu::on_pushButton_10_clicked()
{
// foreach (const QSerialPortInfo &info,QSerialPortInfo::availablePorts())
// {
// QSerialPort serial;
// serial.setPort(info);
// if(serial.open(QIODevice::ReadWrite))
// {
// SerialPort.setPortName("COM4");
// qDebug()<<info.portName();
// }
// }
SerialPort4.setPortName("COM4");
// 打开串口
if(SerialPort4.open(QIODevice::ReadWrite))
{
SerialPort4.setBaudRate(QSerialPort::Baud9600);
SerialPort4.setDataBits(QSerialPort::Data8);
SerialPort4.setStopBits(QSerialPort::OneStop);
SerialPort4.setParity(QSerialPort::NoParity);
SerialPort4.setFlowControl(QSerialPort::NoFlowControl);
qDebug()<<"成功打开COM4";
QTimer::singleShot(100,this,[=](){
QByteArray hexData = QByteArray::fromHex("16 54 0D");
SerialPort4.write(hexData);
// QTimer::singleShot(100,this,[=](){
// QByteArray receivedHexData = SerialPort.readAll();
// ui->lineEdit->setText(receivedHexData);
// qDebug()<<receivedHexData;});
// SerialPort.write("16 54 0D");
// QTimer::singleShot(100,this,[=](){
// QString str=SerialPort.readAll();
// ui->lineEdit->setText(str);
// qDebug()<<str;});
// });
// 将定时器的 timeout 信号连接到自定义的槽函数 timeoutHandler
connect(timer, &QTimer::timeout, this, [=](){
QByteArray receivedHexData = SerialPort4.readAll();
qDebug()<<receivedHexData;
if(receivedHexData!="")
{
ui->lineEdit->setText(receivedHexData);
timer->stop();
receivedHexData="";
}
});
// 启动定时器，设置超时时间为 1000 毫秒（即 1 秒）
timer->start(1000);
});
}
else {
qDebug() << "打开 COM4 失败，原因: " << SerialPort4.errorString();
}
}
void micjishu::on_pushButton_11_clicked()
{
QScrollBar *scrollBar = ui->tableWidget_3->verticalScrollBar();
// 获取当前滚动条的位置
int currentValue = scrollBar->value();
// 向下滑动的偏移量，可以根据需要调整
int offset = 100;
// 设置新的滚动条位置
scrollBar->setValue(currentValue + offset);
}
void micjishu::on_pushButton_12_clicked()
{
m_pp->show();
if(ui->label_15->text().isEmpty()){
emit print(savePath5);
}else{
emit print(savePath6);
}
}
Reference in New Issue Copy Permalink