ARK/usermanagement.cpp at master · FxMain/ARK · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
#include "usermanagement.h"
#include "ui_usermanagement.h"

extern QSqlDatabase db;
extern QSqlQueryModel *model;
extern QSqlQuery query;
usermanagement::usermanagement(QWidget *parent) :
    QDialog(parent),
    ui(new Ui::usermanagement)
{
    setWindowFlags(Qt::FramelessWindowHint);

    setAutoFillBackground(true);//必须有这条语句
    setPalette(QPalette(QColor(145,145,145)));
    ui->setupUi(this);
    ui->comboBox->addItem(tr("管理员"));
    ui->comboBox->addItem(tr("库管员"));
    ui->comboBox->addItem(tr("主管"));
    ui->tableView->setSelectionBehavior(QAbstractItemView::SelectRows);
    ui->lineEdit_3->setEchoMode(QLineEdit::Password);


    dbshow();//显示列表
    dbshow();//隐藏密码


}

usermanagement::~usermanagement()
{
    delete ui;
}
void usermanagement::dbshow()
{


    model = new QSqlQueryModel(this);

    QString Qfind;
    Qfind="SELECT * FROM use";
    model->setQuery(Qfind);
    model->setHeaderData(0,Qt::Horizontal,tr("用户名"));
    model->setHeaderData(1,Qt::Horizontal,tr("密码"));
    model->setHeaderData(2,Qt::Horizontal,tr("角色"));
    model->setHeaderData(3,Qt::Horizontal,tr("身份证"));
    model->setHeaderData(4,Qt::Horizontal,tr("指纹"));
    model->setHeaderData(5,Qt::Horizontal,tr("人脸数据"));
    ui->tableView->setColumnHidden(1,true);
    ui->tableView->setModel(model);

}
void usermanagement::on_pushButton_6_clicked()//新增按钮事件
{

    //   QString yonghu,mima,juese,shengfengzheng,zhiwen,renlianshibie;
    yonghu              =ui->lineEdit_2->text();
    mima                =ui->lineEdit_3->text();
    juese               =ui->comboBox->currentText();
    QSqlQuery query;
    QString insert_buf;
    insert_buf=QObject::tr("insert into use values('%1','%2','%3','%4','%5','%6')").arg(yonghu,mima,juese,shengfengzheng,zhiwen,renlianshibie);
    //qDebug()<<insert_buf;

    if(yonghu.isEmpty() || mima.isEmpty() || juese.isEmpty())
    {
        QMessageBox::warning(this,"Incomplete information","error");
        return;
    }


    if(! query.exec(insert_buf))
    {
          qDebug() << query.lastError();
    }
    else
    {
          qDebug() << "inserted Wang!";

    }

    dbshow();
    //usedb.close();

}

void usermanagement::on_pushButton_5_clicked()//删除
{


    int _row=ui->tableView->currentIndex().row();
    if(_row==-1){
        return;
    }
    QModelIndex index = model->index(_row,0);
    QString nr = model->data(index).toString();
    QSqlQuery query(db);
    qDebug()<<nr;
    //QString insert_buf=QObject::tr("delete from use where yonghu = %1").arg(nr);
    //qDebug()<<insert_buf;


    query.prepare(QString("delete from use where yonghu = ?"));
    query.addBindValue(nr);
    if(! query.exec())
    {
          qDebug() << query.lastError();
    }
    else
    {
          qDebug() << "inserted Wang!";

    }
    dbshow();
}

void usermanagement::on_pushButton_clicked()//查询按钮
{
    model = new QSqlQueryModel(this);


    QString Qfind;
    if(ui->lineEdit->text().isEmpty())
    {
        Qfind="SELECT * FROM use";
    }
    else
    {
        Qfind="SELECT * FROM use WHERE (yonghu   ='"+ui->lineEdit->text()+"')"+
                                   "OR (juese    ='"+ui->lineEdit->text()+"')";
    }
    model->setQuery(Qfind);
    model->setHeaderData(0,Qt::Horizontal,tr("用户名"));
    model->setHeaderData(1,Qt::Horizontal,tr("密码"));
    model->setHeaderData(2,Qt::Horizontal,tr("角色"));
    model->setHeaderData(3,Qt::Horizontal,tr("身份证"));
    model->setHeaderData(4,Qt::Horizontal,tr("指纹"));
    model->setHeaderData(5,Qt::Horizontal,tr("人脸数据"));
    ui->tableView->setColumnHidden(1,true);
    ui->tableView->setModel(model);
}