#include "addzhong.h"
#include "ui_addzhong.h"
//QString id4;
addzhong::addzhong(QWidget *parent) :
    QWidget(parent),
    ui(new Ui::addzhong)
{
    ui->setupUi(this);
    setWindowTitle("新增菌种");
   getshui();
    ui->widget->setFixedHeight(55);
    ui->lineEdit->setFixedSize(200,30);
    ui->lineEdit_2->setFixedSize(200,30);
    ui->pushButton->setFixedSize(76,37);
    ui->pushButton_2->setFixedSize(76,37);
    ui->comboBox->setFixedSize(200,30);
    this->setWindowFlags(Qt::FramelessWindowHint); // 隐藏标题栏
 this->setFixedSize(437,292);
this->setWindowFlags(Qt::FramelessWindowHint);//去除窗口边框
  setAttribute(Qt::WA_TranslucentBackground);
}


addzhong::~addzhong()
{
    delete ui;
}
void addzhong::getshui()
{
    ui->comboBox->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 addzhong::on_pushButton_clicked()
{
    QString sql=QString("INSERT INTO junzhong  (id,name,time,ren,shuname) VALUES ('%1','%2','%3','%4','%5')")
    .arg(ui->lineEdit->text()).arg(ui->lineEdit_2->text()).arg(gettime()).arg("1").arg(ui->comboBox->currentText());
    qDebug()<<sql;
    QSqlQuery query;

    if(query.exec(sql))
    {

        qDebug()<<"插入成功";
        ui->lineEdit_2->clear();

    }


    emit xinzeng();
    this->close();
}
QString addzhong::getname()
{
    // QString sql=QString("select usersname from users where id='%1'").arg(id4);
    // qDebug()<<sql;
    // QSqlQuery query;

    // if(query.exec(sql))
    // {
    //     if(query.first()){

    // QString  str1=query.value(0).toString();
    //   qDebug()<<str1;
    //   return  str1;
    //     }
    // }
    // else
    // {
    // qDebug()<<"没查到名字";
    // }
}
QString addzhong::gettime()
{
    QDateTime dateTime= QDateTime::currentDateTime();//获取系统当前的时间
    QString str = dateTime .toString("yyyy-MM-dd hh:mm:ss");//格式化时间

    return  str;
}

void addzhong::on_pushButton_3_clicked()
{
    this->close();
}


void addzhong::on_pushButton_2_clicked()
{
    emit xinzeng();
    this->close();
}