blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
ccy
2026-05-18 3f6556ed37139142988bb8b697d8ff090de3df5f 
 mainwindow.cpp


@@ -5,21 +5,66 @@


#include <QClipboard>


#include <QDateTime>


#include <QDebug>


#include <QDesktopServices>


#include <QFileDialog>


#include <QMessageBox>


#include <QProcess>




#include <qbytearray.h>


#include "QtXlsx/xlsxdocument.h"


#include "QtXlsx/xlsxworksheet.h"


#include "QtXlsx/xlsxformat.h"


using namespace QXlsx;


MainWindow::MainWindow(QWidget *parent)


    : QMainWindow(parent)


    , ui(new Ui::MainWindow)


{


    ui->setupUi(this);


    setFixedSize(680, 600);


    initUI();


}




MainWindow::~MainWindow()


{


    delete ui;


}




void MainWindow::initUI()


{


    //将旧版本的按钮隐藏


    ui->pushButton_accreditall->setVisible(false);


    ui->pushButton_accreditcell->setVisible(false);


    ui->pushButton_accreditaquifer->setVisible(false);


    ui->pushButton_deaccreditall->setVisible(false);


    ui->pushButton_accreditpipe->setVisible(false);


    ui->pushButton_accreditnetwork->setVisible(false);


    ui->pushButton_dateset->setVisible(false);


    ui->pushButton_adddate->setVisible(false);


    ui->pushButton_reducedate->setVisible(false);


    ui->lineEdit_basenum->setVisible(false);


    ui->lineEdit_biosnum->setVisible(false);


    ui->lineEdit_basenum_2->setVisible(false);


    ui->lineEdit_biosnum_2->setVisible(false);


    ui->label_basenum->setVisible(false);


    ui->label_biosnum->setVisible(false);


    ui->label_basenum_2->setVisible(false);


    ui->label_biosnum_2->setVisible(false);


    //前七条是简化加密数据必用的,在这里设定好方便对应


    m_numToInfo.insert("1","Baseboard_Uuid");


    m_numToInfo.insert("2","CPU_Processorid");


    m_numToInfo.insert("3","Username");


    m_numToInfo.insert("4","LicensedDuration_start");


    m_numToInfo.insert("5","LicensedDuration_end");


    m_numToInfo.insert("6","Productid");


    m_numToInfo.insert("7","Versionid");


    m_numToInfo.insert("8","ActiveState");


    //后边的是排除后不参与加密的数据信息


    m_numToInfo.insert("9","Bios_Serialnumber");


    m_numToInfo.insert("10","IsEnabled_cell");


    m_numToInfo.insert("11","IsEnabled_aquifer");


    m_numToInfo.insert("12","IsEnabled_pipe");


    m_numToInfo.insert("13","IsEnabled_network");


    m_numToInfo.insert("14","Baseboard_Serialnumber");


    changeUIstate();


}




QString MainWindow::toUpperAndLower(QString src)


@@ -81,6 +126,14 @@


    return QString::fromLatin1(QAESEncryption::RemovePadding(deBA, QAESEncryption::PKCS7));


}




QByteArray MainWindow::AES_decryption_byte(const QString &data, const QString &key)


{


    QAESEncryption encryption(QAESEncryption::AES_256, QAESEncryption::ECB, QAESEncryption::PKCS7);


    QByteArray  enBA = QByteArray::fromBase64(data.toUtf8());


    QByteArray deBA = encryption.decode(enBA, key.toUtf8());


    return deBA;


}




QString MainWindow::getEncrypt(const QString &data, QString key)


{


    QString str_encode_text;


@@ -100,6 +153,11 @@


    QString hashkey32 = EncryptData(hashkey64,QCryptographicHash::Md5);


    QString AESresult = AES_decryption(b64result,hashkey32);


    decodedText = DecodebyBase64(AESresult);


    //添加解压缩的操作


    QByteArray text = decodedText.toLocal8Bit();


    QByteArray jsonData = qUncompress(text.fromBase64(text));


//    decodedText = DecodebyBase64(QString::fromLocal8Bit(jsonData));


    decodedText = QString(jsonData);


    return decodedText;


}




@@ -119,6 +177,9 @@


        ui->pushButton_setproid->setEnabled(false);


        ui->lineEdit_setversion->setEnabled(false);


        ui->lineEdit_setproid->setEnabled(false);


        ui->pushButton_normal->setEnabled(false);


        ui->pushButton_education->setEnabled(false);


        ui->pushButton_profession->setEnabled(false);




        ui->lineEdit_basenum->setText("");


        ui->lineEdit_baseuuid->setText("");


@@ -148,6 +209,9 @@


        ui->pushButton_setproid->setEnabled(true);


        ui->lineEdit_setversion->setEnabled(true);


        ui->lineEdit_setproid->setEnabled(true);


        ui->pushButton_normal->setEnabled(true);


        ui->pushButton_education->setEnabled(true);


        ui->pushButton_profession->setEnabled(true);




        ui->lineEdit_basenum->setText(localinfo.Baseboard_Serialnumber);


        ui->lineEdit_baseuuid->setText(localinfo.Baseboard_Uuid);


@@ -157,10 +221,15 @@


        ui->lineEdit_date->setText(localinfo.LicensedDuration_end);


        ui->lineEdit_version->setText(localinfo.Versionid);


        ui->lineEdit_proid->setText(localinfo.Productid);


        ui->label_iscell->setText(localinfo.IsEnabled_cell==0?QStringLiteral("未激活"):QStringLiteral("已激活"));


        ui->label_isaquifer->setText(localinfo.IsEnabled_aquifer==0?QStringLiteral("未激活"):QStringLiteral("已激活"));


        ui->label_ispipe->setText(localinfo.IsEnabled_pipe==0?QStringLiteral("未激活"):QStringLiteral("已激活"));


        ui->label_isnetwork->setText(localinfo.IsEnabled_network==0?QStringLiteral("未激活"):QStringLiteral("已激活"));


//        ui->label_iscell->setText(localinfo.IsEnabled_cell==0?QStringLiteral("未激活"):QStringLiteral("已激活"));


//        ui->label_isaquifer->setText(localinfo.IsEnabled_aquifer==0?QStringLiteral("未激活"):QStringLiteral("已激活"));


//        ui->label_ispipe->setText(localinfo.IsEnabled_pipe==0?QStringLiteral("未激活"):QStringLiteral("已激活"));


//        ui->label_isnetwork->setText(localinfo.IsEnabled_network==0?QStringLiteral("未激活"):QStringLiteral("已激活"));


        //当前授权是统一的，只需要判断一个是否激活的参数就行


        ui->label_iscell->setText(localinfo.ActiveState==0?QStringLiteral("未激活"):QStringLiteral("已激活"));


        ui->label_isaquifer->setText(localinfo.ActiveState==0?QStringLiteral("未激活"):QStringLiteral("已激活"));


        ui->label_ispipe->setText(localinfo.ActiveState==0?QStringLiteral("未激活"):QStringLiteral("已激活"));


        ui->label_isnetwork->setText(localinfo.ActiveState==0?QStringLiteral("未激活"):QStringLiteral("已激活"));


    }


    if(licenseinfo.Username==""){


        ui->lineEdit_basenum_2->setText("");


@@ -186,10 +255,14 @@


        ui->lineEdit_setversion->setText(licenseinfo.Versionid);


        ui->lineEdit_proid_2->setText(licenseinfo.Productid);


        ui->lineEdit_setproid->setText(licenseinfo.Productid);


        ui->label_iscell_2->setText(licenseinfo.IsEnabled_cell==0?QStringLiteral("未激活"):QStringLiteral("已激活"));


        ui->label_isaquifer_2->setText(licenseinfo.IsEnabled_aquifer==0?QStringLiteral("未激活"):QStringLiteral("已激活"));


        ui->label_ispipe_2->setText(licenseinfo.IsEnabled_pipe==0?QStringLiteral("未激活"):QStringLiteral("已激活"));


        ui->label_isnetwork_2->setText(licenseinfo.IsEnabled_network==0?QStringLiteral("未激活"):QStringLiteral("已激活"));


//        ui->label_iscell_2->setText(licenseinfo.IsEnabled_cell==0?QStringLiteral("未激活"):QStringLiteral("已激活"));


//        ui->label_isaquifer_2->setText(licenseinfo.IsEnabled_aquifer==0?QStringLiteral("未激活"):QStringLiteral("已激活"));


//        ui->label_ispipe_2->setText(licenseinfo.IsEnabled_pipe==0?QStringLiteral("未激活"):QStringLiteral("已激活"));


//        ui->label_isnetwork_2->setText(licenseinfo.IsEnabled_network==0?QStringLiteral("未激活"):QStringLiteral("已激活"));


        ui->label_iscell_2->setText(licenseinfo.ActiveState==0?QStringLiteral("未激活"):QStringLiteral("已激活"));


        ui->label_isaquifer_2->setText(licenseinfo.ActiveState==0?QStringLiteral("未激活"):QStringLiteral("已激活"));


        ui->label_ispipe_2->setText(licenseinfo.ActiveState==0?QStringLiteral("未激活"):QStringLiteral("已激活"));


        ui->label_isnetwork_2->setText(licenseinfo.ActiveState==0?QStringLiteral("未激活"):QStringLiteral("已激活"));


    }


}




@@ -199,7 +272,7 @@


    QString localid = getDecrypt(encryptlocalid,key);


    QByteArray localidbyte = localid.toLocal8Bit();


    QJsonParseError err_rpt;


    QJsonDocument localidjsondoc(QJsonDocument::fromJson(localidbyte, &err_rpt));//字符串格式化为JSON


    QJsonDocument localidjsondoc(QJsonDocument::fromJson(localid.toUtf8(), &err_rpt));//字符串格式化为JSON


    if(err_rpt.error != QJsonParseError::NoError)


    {


        localinfo = LicenseInfo();


@@ -221,20 +294,29 @@


        workingjsondoc = QJsonDocument(QJsonDocument::fromJson(localidbyte));




        QJsonObject localid_Obj = localidjsondoc.object();


        localinfo.Baseboard_Serialnumber = localid_Obj.value("Baseboard_Serialnumber").toString();


        localinfo.Baseboard_Uuid = localid_Obj.value("Baseboard_Uuid").toString();


        localinfo.Bios_Serialnumber = localid_Obj.value("Bios_Serialnumber").toString();


        localinfo.CPU_Processorid = localid_Obj.value("CPU_Processorid").toString();


        localinfo.Username = localid_Obj.value("Username").toString();


        localinfo.IsEnabled_cell = localid_Obj.value("IsEnabled_cell").toInt();


        localinfo.IsEnabled_aquifer = localid_Obj.value("IsEnabled_aquifer").toInt();


        localinfo.IsEnabled_pipe = localid_Obj.value("IsEnabled_pipe").toInt();


        localinfo.IsEnabled_network = localid_Obj.value("IsEnabled_network").toInt();


        localinfo.LicensedDuration_end = localid_Obj.value("LicensedDuration_end").toString();


        localinfo.LicensedDuration_start = localid_Obj.value("LicensedDuration_start").toString();


        localinfo.Productid = localid_Obj.value("Productid").toString();


        localinfo.Versionid = localid_Obj.value("Versionid").toString();


//        localinfo.Baseboard_Serialnumber = localid_Obj.value("Baseboard_Serialnumber").toString();


//        localinfo.Baseboard_Uuid = localid_Obj.value("Baseboard_Uuid").toString();


//        localinfo.Bios_Serialnumber = localid_Obj.value("Bios_Serialnumber").toString();


//        localinfo.CPU_Processorid = localid_Obj.value("CPU_Processorid").toString();


//        localinfo.Username = localid_Obj.value("Username").toString();


//        localinfo.IsEnabled_cell = localid_Obj.value("IsEnabled_cell").toInt();


//        localinfo.IsEnabled_aquifer = localid_Obj.value("IsEnabled_aquifer").toInt();


//        localinfo.IsEnabled_pipe = localid_Obj.value("IsEnabled_pipe").toInt();


//        localinfo.IsEnabled_network = localid_Obj.value("IsEnabled_network").toInt();


//        localinfo.LicensedDuration_end = localid_Obj.value("LicensedDuration_end").toString();


//        localinfo.LicensedDuration_start = localid_Obj.value("LicensedDuration_start").toString();


//        localinfo.Productid = localid_Obj.value("Productid").toString();


//        localinfo.Versionid = localid_Obj.value("Versionid").toString();




        //与之前的加密对应,且去掉冗余信息


        localinfo.Baseboard_Uuid = localid_Obj.value(m_numToInfo.key("Baseboard_Uuid")).toString();


        localinfo.CPU_Processorid = localid_Obj.value(m_numToInfo.key("CPU_Processorid")).toString();


        localinfo.Username = localid_Obj.value(m_numToInfo.key("Username")).toString();


        localinfo.LicensedDuration_end = localid_Obj.value(m_numToInfo.key("LicensedDuration_end")).toString();


        localinfo.LicensedDuration_start = localid_Obj.value(m_numToInfo.key("LicensedDuration_start")).toString();


        localinfo.Productid = localid_Obj.value(m_numToInfo.key("Productid")).toString();


        localinfo.Versionid = localid_Obj.value(m_numToInfo.key("Versionid")).toString();


        localinfo.ActiveState = localid_Obj.value(m_numToInfo.key("ActiveState")).toInt();


        licenseinfo = LicenseInfo(localinfo);


        changeUIstate();


    }


@@ -278,7 +360,8 @@


void MainWindow::on_pushButton_accreditpipe_clicked()


{


    QJsonObject licensekey_Obj = workingjsondoc.object();


    licensekey_Obj["IsEnabled_pipe"] = 1;


//    licensekey_Obj["IsEnabled_pipe"] = 1;


    licensekey_Obj["8"] = 1;


    workingjsondoc.setObject(licensekey_Obj);


    QByteArray jsonbytearray = workingjsondoc.toJson();


    ui->textEdit_licensekey->setPlainText("");


@@ -333,19 +416,20 @@




void MainWindow::setLicenseinfo(const QJsonObject licensekey_Obj)


{


    licenseinfo.Baseboard_Serialnumber = licensekey_Obj.value("Baseboard_Serialnumber").toString();


    licenseinfo.Baseboard_Uuid = licensekey_Obj.value("Baseboard_Uuid").toString();


    licenseinfo.Bios_Serialnumber = licensekey_Obj.value("Bios_Serialnumber").toString();


    licenseinfo.CPU_Processorid = licensekey_Obj.value("CPU_Processorid").toString();


    licenseinfo.Username = licensekey_Obj.value("Username").toString();


    licenseinfo.IsEnabled_cell = licensekey_Obj.value("IsEnabled_cell").toInt();


    licenseinfo.IsEnabled_aquifer = licensekey_Obj.value("IsEnabled_aquifer").toInt();


    licenseinfo.IsEnabled_pipe = licensekey_Obj.value("IsEnabled_pipe").toInt();


    licenseinfo.IsEnabled_network = licensekey_Obj.value("IsEnabled_network").toInt();


    licenseinfo.LicensedDuration_end = licensekey_Obj.value("LicensedDuration_end").toString();


    licenseinfo.LicensedDuration_start = licensekey_Obj.value("LicensedDuration_start").toString();


    licenseinfo.Productid = licensekey_Obj.value("Productid").toString();


    licenseinfo.Versionid = licensekey_Obj.value("Versionid").toString();


    licenseinfo.Baseboard_Serialnumber = licensekey_Obj.value(m_numToInfo.key("Baseboard_Serialnumber")).toString();


    licenseinfo.Baseboard_Uuid = licensekey_Obj.value(m_numToInfo.key("Baseboard_Uuid")).toString();


    licenseinfo.Bios_Serialnumber = licensekey_Obj.value(m_numToInfo.key("Bios_Serialnumber")).toString();


    licenseinfo.CPU_Processorid = licensekey_Obj.value(m_numToInfo.key("CPU_Processorid")).toString();


    licenseinfo.Username = licensekey_Obj.value(m_numToInfo.key("Username")).toString();


    licenseinfo.IsEnabled_cell = licensekey_Obj.value(m_numToInfo.key("IsEnabled_cell")).toInt();


    licenseinfo.IsEnabled_aquifer = licensekey_Obj.value(m_numToInfo.key("IsEnabled_aquifer")).toInt();


    licenseinfo.IsEnabled_pipe = licensekey_Obj.value(m_numToInfo.key("IsEnabled_pipe")).toInt();


    licenseinfo.IsEnabled_network = licensekey_Obj.value(m_numToInfo.key("IsEnabled_network")).toInt();


    licenseinfo.LicensedDuration_end = licensekey_Obj.value(m_numToInfo.key("LicensedDuration_end")).toString();


    licenseinfo.LicensedDuration_start = licensekey_Obj.value(m_numToInfo.key("LicensedDuration_start")).toString();


    licenseinfo.Productid = licensekey_Obj.value(m_numToInfo.key("Productid")).toString();


    licenseinfo.Versionid = licensekey_Obj.value(m_numToInfo.key("Versionid")).toString();


    licenseinfo.ActiveState = licensekey_Obj.value(m_numToInfo.key("ActiveState")).toInt();


    changeUIstate();


}




@@ -368,22 +452,38 @@




    QJsonDocument json_doc;//创建json文件


    QJsonObject json_obj;//创建json对象


    json_obj.insert("Username",localinfo.Username);


    json_obj.insert("CPU_Processorid",localinfo.CPU_Processorid);


    json_obj.insert("Bios_Serialnumber",localinfo.Bios_Serialnumber);


    json_obj.insert("Baseboard_Serialnumber",localinfo.Baseboard_Serialnumber);


    json_obj.insert("Baseboard_Uuid",localinfo.Baseboard_Uuid);


    json_obj.insert("IsEnabled_cell",localinfo.IsEnabled_cell);


    json_obj.insert("IsEnabled_aquifer",localinfo.IsEnabled_aquifer);


    json_obj.insert("IsEnabled_pipe",localinfo.IsEnabled_pipe);


    json_obj.insert("IsEnabled_network",localinfo.IsEnabled_network);


    json_obj.insert("LicensedDuration_start",localinfo.LicensedDuration_start);


    json_obj.insert("LicensedDuration_end",localinfo.LicensedDuration_end);


    json_obj.insert("Productid",localinfo.Productid);


    json_obj.insert("Versionid",localinfo.Versionid);


    json_doc.setObject(json_obj);//将json对象转为json文件


    QByteArray jsonbytearray = json_doc.toJson();


    localid = QString(jsonbytearray);


//    json_obj.insert("Username",localinfo.Username);


//    json_obj.insert("CPU_Processorid",localinfo.CPU_Processorid);


//    json_obj.insert("Bios_Serialnumber",localinfo.Bios_Serialnumber);


//    json_obj.insert("Baseboard_Serialnumber",localinfo.Baseboard_Serialnumber);


//    json_obj.insert("Baseboard_Uuid",localinfo.Baseboard_Uuid);


//    json_obj.insert("IsEnabled_cell",localinfo.IsEnabled_cell);


//    json_obj.insert("IsEnabled_aquifer",localinfo.IsEnabled_aquifer);


//    json_obj.insert("IsEnabled_pipe",localinfo.IsEnabled_pipe);


//    json_obj.insert("IsEnabled_network",localinfo.IsEnabled_network);


//    json_obj.insert("LicensedDuration_start",localinfo.LicensedDuration_start);


//    json_obj.insert("LicensedDuration_end",localinfo.LicensedDuration_end);


//    json_obj.insert("Productid",localinfo.Productid);


//    json_obj.insert("Versionid",localinfo.Versionid);


//    json_doc.setObject(json_obj);//将json对象转为json文件


//    QByteArray jsonbytearray = json_doc.toJson();


//    localid = QString(jsonbytearray);




    //其实主要加密的数据是value(电脑的具体参数信息），前边的描述是可以简写的，按照设定好的规则，只存储简单的key值


    //这里只获取我们优化后要选择加密的数据


    json_obj.insert(m_numToInfo.key("Username"),localinfo.Username);


    json_obj.insert(m_numToInfo.key("CPU_Processorid"),localinfo.CPU_Processorid);


    json_obj.insert(m_numToInfo.key("Baseboard_Uuid"),localinfo.Baseboard_Uuid);


    json_obj.insert(m_numToInfo.key("LicensedDuration_start"),localinfo.LicensedDuration_start);


    json_obj.insert(m_numToInfo.key("LicensedDuration_end"),localinfo.LicensedDuration_end);


    json_obj.insert(m_numToInfo.key("Productid"),localinfo.Productid);


    json_obj.insert(m_numToInfo.key("Versionid"),localinfo.Versionid);


    json_obj.insert(m_numToInfo.key("ActiveState"),localinfo.ActiveState);




    QByteArray compressedArray = QJsonDocument(json_obj).toJson(QJsonDocument::Compact);


    QByteArray jsonbytearray = qCompress(compressedArray,9);


    localid = jsonbytearray.toBase64();




    return localid;


}




@@ -401,6 +501,110 @@


    result = result.simplified();


    p.close();


    return result;


}




void MainWindow::giveLicense(int time)


{


    QJsonObject licensekey_Obj = workingjsondoc.object();


//    licensekey_Obj[m_numToInfo.key("IsEnabled_cell")] = 1;


//    licensekey_Obj[m_numToInfo.key("IsEnabled_aquifer")] = 1;


//    licensekey_Obj[m_numToInfo.key("IsEnabled_pipe")] = 1;


//    licensekey_Obj[m_numToInfo.key("IsEnabled_network")] = 1;


    licensekey_Obj[m_numToInfo.key("ActiveState")] = 1;


//    QDateTime licensedate = QDateTime::fromString(licensekey_Obj[m_numToInfo.key("LicensedDuration_end")].toString(),"yyyy-MM-dd hh:mm:ss");


//    if(licensedate.isNull()){


//        qDebug()<<"licenseTime is Null";


//        licensedate = QDateTime::currentDateTime();


//    }


    //现在点击授权是从当前的时间加授权时间


    QDateTime licensedate = QDateTime::currentDateTime();


    QDateTime newlicensedate = licensedate.addMonths(time);


    QString licensedatestr = newlicensedate.toString("yyyy-MM-dd hh:mm:ss");


    licensekey_Obj[m_numToInfo.key("LicensedDuration_start")] = licensedate.toString("yyyy-MM-dd hh:mm:ss");


    licensekey_Obj[m_numToInfo.key("LicensedDuration_end")] = licensedatestr;


    workingjsondoc.setObject(licensekey_Obj);


    //数据压缩，去空格换行等多余无用信息


    QByteArray compressedArray = QJsonDocument(licensekey_Obj).toJson(QJsonDocument::Compact);


    QByteArray jsonbytearray = qCompress(compressedArray,9);


    QString testid = jsonbytearray.toBase64();


    ui->textEdit_licensekey->setPlainText("");


    ui->textEdit_licensekey->setPlainText(getEncrypt(QString(testid),key));


    setLicenseinfo(licensekey_Obj);


    //将授权信息记录到excel表中


    QString edition ="";


    if(time == 3){


        edition = QStringLiteral("普通版");


    }else if(time == 6){


        edition = QStringLiteral("教育版");


    }else if(time == 12){


        edition = QStringLiteral("专业版");


    }


    ActiveRecord(licensekey_Obj,edition,ui->textEdit_licensekey->toPlainText());


}




void MainWindow::ActiveRecord(QJsonObject jsonObj,QString edition, QString licenseKey)


{


    QString Baseboard_Uuid = jsonObj[m_numToInfo.key("Baseboard_Uuid")].toString();


    QString src = QApplication::applicationDirPath();


    QDir dir(src);


    QString file_name(QStringLiteral("安全评价软件授权人数统计表.xlsx"));


    QString filepath=dir.path()+"/"+file_name;


    if(!dir.exists(file_name)){


        Document xlsx;


        // 设置列标题


        QStringList headers = {


            "id",


            QStringLiteral("主板唯一标识"),


            QStringLiteral("版本"),


            QStringLiteral("许可起始时间"),


            QStringLiteral("许可截止时间"),


            QStringLiteral("产品号"),


            QStringLiteral("版本号"),


            QStringLiteral("许可密钥")


        };


        // 写入标题行


        for (int col = 1; col <= headers.size(); ++col) {


            xlsx.write(1, col, headers[col - 1]);


        }


        xlsx.saveAs(filepath);


    }




    QXlsx::Document xlsx(filepath);


    int uuidColumn = -1;


    //先查找是否已经存在该项记录


    for(int i = 2; i <= xlsx.dimension().rowCount(); i++){


        QXlsx::Cell* headerCell = xlsx.cellAt(i, 2);


        if (headerCell) {


            QString headerValue = headerCell->value().toString();


            if (headerValue.compare(Baseboard_Uuid, Qt::CaseInsensitive) == 0) {


                uuidColumn = i;


                break;


            }


        }


    }


    if(uuidColumn == -1){


        //如果没有这条记录就写入新的


        int rowCount = xlsx.dimension().rowCount()+1;


        int id = xlsx.read(rowCount-1,1).toInt();


        xlsx.write(rowCount, 1, id+1);


        xlsx.write(rowCount, 2, jsonObj[m_numToInfo.key("Baseboard_Uuid")].toString());


        xlsx.write(rowCount, 3, edition);


        xlsx.write(rowCount, 4, jsonObj[m_numToInfo.key("LicensedDuration_start")].toString());


        xlsx.write(rowCount, 5, jsonObj[m_numToInfo.key("LicensedDuration_end")].toString());


        xlsx.write(rowCount, 6, jsonObj[m_numToInfo.key("Productid")].toString());


        xlsx.write(rowCount, 7, jsonObj[m_numToInfo.key("Versionid")].toString());


        xlsx.write(rowCount, 8, licenseKey);


    }else{


        //如果存在这条记录就更新数据信息


        xlsx.write(uuidColumn, 2, jsonObj[m_numToInfo.key("Baseboard_Uuid")].toString());


        xlsx.write(uuidColumn, 3, edition);


        xlsx.write(uuidColumn, 4, jsonObj[m_numToInfo.key("LicensedDuration_start")].toString());


        xlsx.write(uuidColumn, 5, jsonObj[m_numToInfo.key("LicensedDuration_end")].toString());


        xlsx.write(uuidColumn, 6, jsonObj[m_numToInfo.key("Productid")].toString());


        xlsx.write(uuidColumn, 7, jsonObj[m_numToInfo.key("Versionid")].toString());


        xlsx.write(uuidColumn, 8, licenseKey);


    }


    xlsx.save();


}






@@ -522,21 +726,61 @@


void MainWindow::on_pushButton_setproid_clicked()


{


    QJsonObject licensekey_Obj = workingjsondoc.object();


    licensekey_Obj["Productid"] = ui->lineEdit_setproid->text();


    licensekey_Obj[m_numToInfo.key("Productid")] = ui->lineEdit_setproid->text();


    workingjsondoc.setObject(licensekey_Obj);


    QByteArray jsonbytearray = workingjsondoc.toJson();




    QByteArray compressedArray = QJsonDocument(licensekey_Obj).toJson(QJsonDocument::Compact);


    QByteArray jsonbytearray = qCompress(compressedArray,9);


    QString testid = jsonbytearray.toBase64();


    ui->textEdit_licensekey->setPlainText("");


    ui->textEdit_licensekey->setPlainText(getEncrypt(QString(jsonbytearray),key));


    ui->textEdit_licensekey->setPlainText(getEncrypt(QString(testid),key));




//    QByteArray jsonbytearray = workingjsondoc.toJson();


//    ui->textEdit_licensekey->setPlainText("");


//    ui->textEdit_licensekey->setPlainText(getEncrypt(QString(jsonbytearray),key));


    setLicenseinfo(licensekey_Obj);


}




void MainWindow::on_pushButton_setversion_clicked()


{


    QJsonObject licensekey_Obj = workingjsondoc.object();


    licensekey_Obj["Versionid"] = ui->lineEdit_setversion->text();


    licensekey_Obj[m_numToInfo.key("Versionid")] = ui->lineEdit_setversion->text();


    workingjsondoc.setObject(licensekey_Obj);


    QByteArray jsonbytearray = workingjsondoc.toJson();




    QByteArray compressedArray = QJsonDocument(licensekey_Obj).toJson(QJsonDocument::Compact);


    QByteArray jsonbytearray = qCompress(compressedArray,9);


    QString testid = jsonbytearray.toBase64();


    ui->textEdit_licensekey->setPlainText("");


    ui->textEdit_licensekey->setPlainText(getEncrypt(QString(jsonbytearray),key));


    ui->textEdit_licensekey->setPlainText(getEncrypt(QString(testid),key));




//    QByteArray jsonbytearray = workingjsondoc.toJson();


//    ui->textEdit_licensekey->setPlainText("");


//    ui->textEdit_licensekey->setPlainText(getEncrypt(QString(jsonbytearray),key));


    setLicenseinfo(licensekey_Obj);


}




void MainWindow::on_pushButton_normal_clicked()


{


    giveLicense(3);




}




void MainWindow::on_pushButton_education_clicked()


{


    giveLicense(6);


}




void MainWindow::on_pushButton_profession_clicked()


{


    giveLicense(12);


}




void MainWindow::on_pushButton_viewUsers_clicked()


{


    QString excelPath = QApplication::applicationDirPath()+QStringLiteral("/安全评价软件授权人数统计表.xlsx");




    QUrl fileUrl = QUrl::fromLocalFile(excelPath);




    // 2. 调用系统服务打开文件管理器并选中文件


    QDesktopServices::openUrl(fileUrl);


}