103 lines
2.3 KiB
C++
103 lines
2.3 KiB
C++
#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();
|
|
}
|
|
|