#include "blastrecord.h" #include "ui_blastrecord.h" BlastRecord::BlastRecord(QWidget *parent) : QWidget(parent), ui(new Ui::BlastRecord), dao(DatabaseManager::getInstance().getDatabase()) { ui->setupUi(this); m_pPageWidget = new PageWidget; connect(m_pPageWidget, &PageWidget::currentPageChanged, this, &BlastRecord::PageChanged); connect(m_pPageWidget->getComboBox(), QOverload::of(&QComboBox::currentIndexChanged), this, &BlastRecord::onComboBoxIndexChanged); m_httpClient = new HttpClient(this); pageSize = 10; currentPage = 1; ui->verticalLayout_4->addWidget(m_pPageWidget); loadAndRefreshData(); } void BlastRecord::loadAndRefreshData() { loadDataFromSource(currentPage,pageSize); } void BlastRecord::loadDataFromSource(int currentPage,int pageSize) { PaginatedHBlastRecordResult result =dao.getAllHRecords(currentPage,pageSize); QList> blastRecordsList = result.BlastRecords; totalCount = result.totalCount; m_pPageWidget->setMaxPage(ceil(static_cast(totalCount)/pageSize)); QStandardItemModel *model; model = new QStandardItemModel(this); // 定义表头信息 QList headers = { {"工程名称", "projectName"}, {"app版本", "appVersion"}, {"起爆器编号", "equipmentSn"}, {"注册雷管", "regDetCount"}, {"起爆时间", "blastAt"}, {"上报时间", "updatedAt"}, }; QStringList headerLabels; QMap propMap; for (int i = 0; i < headers.size(); ++i) { headerLabels << headers[i].label; propMap[i] = headers[i].prop; } model->setHorizontalHeaderLabels(headerLabels); for (int row = 0; row < blastRecordsList.size(); ++row) { HBlastRecord& HBlastRecord = *blastRecordsList.at(row).data(); for (int col = 0; col < headers.size(); ++col) { QString prop = propMap[col]; QStandardItem* item = nullptr; if (!prop.isEmpty()) { QMetaProperty metaProp = HBlastRecord.metaObject()->property(HBlastRecord.metaObject()->indexOfProperty(prop.toUtf8())); QVariant value = metaProp.read(&HBlastRecord); if (value.type() == QVariant::DateTime) { QDateTime dateTime = value.toDateTime(); item = new QStandardItem(dateTime.toString("yyyy-MM-dd HH:mm:ss")); } else { item = new QStandardItem(value.toString()); } } else { item = new QStandardItem("操作"); } if (item) { item->setTextAlignment(Qt::AlignCenter); model->setItem(row, col, item); } } } ui->tableView->setModel(model); ui->tableView->horizontalHeader()->setSectionResizeMode(QHeaderView::Stretch); ui->tableView->setAlternatingRowColors(true); // 启用交替行颜色 ui->tableView->setEditTriggers(QAbstractItemView::NoEditTriggers); } void BlastRecord::PageChanged(int page) { currentPage = page; loadDataFromSource(currentPage,pageSize); } void BlastRecord::onComboBoxIndexChanged(int index) { QVariant variant = m_pPageWidget->getComboBox()->itemData(index); int value = variant.toInt(); pageSize = value; loadDataFromSource(currentPage,pageSize); } void BlastRecord::dataTable(const QJsonDocument &jsonDoc) { parseJsonString(jsonDoc); model = new QStandardItemModel(this); model->setHorizontalHeaderLabels({"工程名称", "app版本", "起爆器编号","注册雷管","起爆时间","上报时间"}); for (const QJsonValue& jsonValue : dataArray) { QJsonObject jsonObj = jsonValue.toObject(); QList items = jsonToItem(jsonObj); model->appendRow(items); } ui->tableView->setModel(model); ui->tableView->horizontalHeader()->setSectionResizeMode(QHeaderView::Stretch); ui->tableView->setAlternatingRowColors(true); } QList BlastRecord::jsonToItem(const QJsonObject &jsonObj) { QStandardItem* nameItem = new QStandardItem(jsonObj["name"].toString()); nameItem->setTextAlignment(Qt::AlignCenter); QStandardItem* equipItem = new QStandardItem(jsonObj["equipmentSn"].toString()); QStandardItem* typeItem = new QStandardItem(jsonObj["equipmentTypeName"].toString()); QStandardItem* statusItem = new QStandardItem(jsonObj["statusName"].toString()); QStandardItem* onlineItem = new QStandardItem(jsonObj["onlineName"].toString()); QString createdAtStr = jsonObj["createdAt"].toString(); QDateTime createdAt = QDateTime::fromString(createdAtStr, Qt::ISODateWithMs); QString formattedCreatedAt = createdAt.toString("yyyy-MM-dd HH:mm:ss"); QStandardItem* createdItem = new QStandardItem(formattedCreatedAt); return QList() << nameItem << equipItem << typeItem<setMaxPage(ceil(static_cast(totalCount)/pageSize)); } BlastRecord::~BlastRecord() { delete ui; }