#include "addusers.h"
#include "ui_addusers.h"
#include<QDateTime>
#include<QMessageBox>
#include<QGraphicsDropShadowEffect>

addusers::addusers(QWidget *parent) :
    QWidget(parent),
    ui(new Ui::addusers)
{
    ui->setupUi(this);

    ui->lineEdit_3->setFixedSize(301,32);
    ui->lineEdit_2->setFixedSize(301,32);
    ui->pushButton->setFixedSize(76,37);
    ui->pushButton_2->setFixedSize(76,37);
    ui->comboBox_2->setFixedSize(301,32);
    this->setWindowFlags(Qt::FramelessWindowHint); // 闅愯棌鏍囬鏍?
     this->setFixedSize(437,292);
    ui->widget->setFixedHeight(55);
     QGraphicsDropShadowEffect *shadow2 = new QGraphicsDropShadowEffect(this);
     //设置阴影距离
     shadow2->setOffset(0, 0);
     //设置阴影颜色
     shadow2->setColor(QColor(214, 214, 214));
     //设置阴影圆角
     shadow2->setBlurRadius(30);
     //给嵌套QWidget设置阴影
     ui->frame->setGraphicsEffect(shadow2);
     this->setWindowFlags(Qt::FramelessWindowHint);//去除窗口边框
         setAttribute(Qt::WA_TranslucentBackground);
}

addusers::~addusers()
{
    delete ui;
}

void addusers::on_pushButton_clicked()

{
    QDateTime dateTime= QDateTime::currentDateTime();//鑾峰彇绯荤粺褰撳墠鐨勬椂闂?
    QString str = dateTime .toString("yyyy-MM-dd hh:mm:ss");//鏍煎紡鍖栨椂闂?
    if(!ui->lineEdit_2->text().isEmpty()&&!ui->lineEdit_3->text().isEmpty()){
    QString sql=QString("INSERT INTO users  (time,id,password,juese) VALUES ('%1','%2','%3','%4')")
    .arg(str).arg(ui->lineEdit_2->text()).arg(ui->lineEdit_3->text()).arg(ui->comboBox_2->currentText());
    qDebug()<<sql;
    QSqlQuery query;

    if(query.exec(sql))
    {

        qDebug()<<"鎻掑叆鎴愬姛";

        ui->lineEdit_2->clear();
        ui->lineEdit_3->clear();

    }
    else{
         QMessageBox::warning(nullptr, "新增人员", "添加失败");

    }
    }
    else{
          QMessageBox::warning(nullptr, "新增人员", "用户名或秘密不能为空");
    }

    emit xinzeng();
    this->close();
}

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