登录

void WelcomeWidget::on_loginBtn_clicked()//点击登录按钮登录时，核对用户名及密码
{
    /*if(ui->adminCheckBox->isChecked())
    {
        m_pAdmin->showMaximized();
    }
    else
    {
        m_pUser->showMaximized();
    }*/
    QSqlTableModel model;
    model.setTable("User");
    model.select();
    int userCnt = 0;
    for(int i=0;i<model.rowCount();++i)
    {
        QSqlRecord record=model.record(i);
        QString ID= record.value("ID").toString();
        QString Password=record.value("Password").toString();
        int GroupID=record.value("GroupID").toInt();

        if(ui->userNameLineEt->text()==ID)
        {
            userCnt++;
            if(ui->adminCheckBox->isChecked())
            {
                if(GroupID==1)
                {
                    if(ui->passwordLineEt->text()==Password)
                    {
                        data::userID=ID.toInt();
                        data::userType=GroupID;
                        m_pAdmin=new adminWindow;
                        m_pAdmin->setWindowTitle("管理员后台");
                        m_pAdmin->showMaximized();
                        this->close();
                    }
                    else
                    {
                        QMessageBox::information(this,"提示","密码错误！");
                    }
                }
                else
                {
                    QMessageBox::information(this,"提示","您不具有管理员权限！");
                }
            }
            else
            {
                if(ui->passwordLineEt->text()==Password)
                {
                    data::userID=ID.toInt();
                    data::userType=GroupID;
                    m_pUser=new userWindow;
                    m_pUser->setWindowTitle("读者中心");
                    m_pUser->showMaximized();
                    this->close();
                }
                else
                {
                    QMessageBox::information(this,"提示","密码错误！");
                }
            }
        }
    }
    if(!userCnt)
    {
        QMessageBox::information(this,"提示","用户不存在！");
    }
}