133 lines
3.2 KiB
C++
133 lines
3.2 KiB
C++
#include "addyaomin.h"
|
|
#include "ui_addyaomin.h"
|
|
#include<QFileDialog>
|
|
QString id5;
|
|
addyaomin::addyaomin(QWidget *parent) :
|
|
QWidget(parent),
|
|
ui(new Ui::addyaomin)
|
|
{
|
|
ui->setupUi(this);
|
|
setWindowTitle("新增药敏板");
|
|
ui->widget->setFixedHeight(55);
|
|
ui->lineEdit->setFixedSize(301,32);
|
|
ui->lineEdit_2->setFixedSize(301,32);
|
|
ui->lineEdit_8->setFixedSize(301,32);
|
|
ui->pushButton->setFixedSize(76,37);
|
|
ui->pushButton_2->setFixedSize(76,37);
|
|
|
|
this->setWindowFlags(Qt::FramelessWindowHint); // 隐藏标题栏
|
|
this->setFixedSize(500,447);
|
|
ui->label_8->setFixedSize(173,130);
|
|
ui->label_8->setScaledContents(true);
|
|
this->setWindowFlags(Qt::FramelessWindowHint);//去除窗口边框
|
|
setAttribute(Qt::WA_TranslucentBackground);
|
|
}
|
|
|
|
addyaomin::~addyaomin()
|
|
{
|
|
delete ui;
|
|
}
|
|
|
|
void addyaomin::on_pushButton_clicked()
|
|
{
|
|
|
|
QSqlQuery query;
|
|
|
|
query.prepare("INSERT INTO yaominban (id, name, time, ren, peijian,tu) "
|
|
"VALUES (:id, :name, :time, :ren, :peijian, :tu)");
|
|
|
|
query.bindValue(":id", ui->lineEdit->text());
|
|
query.bindValue(":name", ui->lineEdit_2->text());
|
|
query.bindValue(":time", gettime());
|
|
query.bindValue(":ren", id5);
|
|
query.bindValue(":peijian", ui->lineEdit_8->text());
|
|
query.bindValue(":tu", data);
|
|
|
|
|
|
if(query.exec())
|
|
{
|
|
|
|
qDebug()<<"插入成功";
|
|
ui->lineEdit->clear();
|
|
ui->lineEdit_2->clear();
|
|
ui->lineEdit_8->clear();
|
|
ui->label_8->clear();
|
|
|
|
}
|
|
|
|
else{
|
|
qDebug() << "SQL error:" << query.lastError().text();}
|
|
|
|
emit xinzeng();
|
|
this->close();
|
|
}
|
|
QString addyaomin::getname()
|
|
{
|
|
QString sql=QString("select usersname from users where id='%1'").arg(id5);
|
|
qDebug()<<sql;
|
|
QSqlQuery query;
|
|
|
|
if(query.exec(sql))
|
|
{
|
|
if(query.first()){
|
|
|
|
QString str1=query.value(0).toString();
|
|
qDebug()<<str1;
|
|
return str1;
|
|
}
|
|
}
|
|
else
|
|
{
|
|
qDebug()<<"没查到名字";
|
|
}
|
|
}
|
|
QString addyaomin::gettime()
|
|
{
|
|
QDateTime dateTime= QDateTime::currentDateTime();//获取系统当前的时间
|
|
QString str = dateTime .toString("yyyy-MM-dd hh:mm:ss");//格式化时间
|
|
|
|
return str;
|
|
}
|
|
//导入配方文件
|
|
void addyaomin::on_pushButton_3_clicked()
|
|
{
|
|
QString filePath = QFileDialog::getOpenFileName(this, "导入配方文件");
|
|
qDebug()<<filePath;
|
|
ui->lineEdit_8->setText(filePath);
|
|
|
|
}
|
|
//导入配方图片
|
|
void addyaomin::on_pushButton_4_clicked()
|
|
{
|
|
ui->label->setGeometry(10, 10, 400, 300); // 设置位置和大小
|
|
ui->label->setAlignment(Qt::AlignCenter); // 设置对齐方式
|
|
QString aFile=QFileDialog::getOpenFileName(this,"选择图片文件");
|
|
qDebug()<<aFile;
|
|
|
|
QFile* file=new QFile(aFile); //fileName为二进制数据文件名
|
|
file->open(QIODevice::ReadOnly);
|
|
data = file->readAll();
|
|
// 加载图片
|
|
QPixmap pixmap(aFile); // 如果图片在资源文件中
|
|
if (!pixmap.isNull()) {
|
|
ui->label_8->setPixmap(pixmap.scaled(ui->label->size(), Qt::KeepAspectRatio));
|
|
} else {
|
|
ui->label_8->setText("Failed to load image");
|
|
}
|
|
}
|
|
|
|
void addyaomin::on_pushButton_5_clicked()
|
|
{
|
|
this->close();
|
|
emit xinzeng();
|
|
}
|
|
|
|
|
|
void addyaomin::on_pushButton_2_clicked()
|
|
{
|
|
this->close();
|
|
emit xinzeng();
|
|
|
|
}
|
|
|