#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();

}