From 1e2d48848ae8fbf7c11948bc38d99a045c78637b Mon Sep 17 00:00:00 2001
From: LAPTOP-T815PCOQ\25526 <mr.liuyang@126.com>
Date: 星期二, 24 十二月 2024 11:50:49 +0800
Subject: [PATCH] 1. 完善报警页面的查询功能
---
SourceCode/Bond/BondEq/CPageAlarm.cpp | 182 +++++++++++++++++++++++++++++++++++++++------
1 files changed, 158 insertions(+), 24 deletions(-)
diff --git a/SourceCode/Bond/BondEq/CPageAlarm.cpp b/SourceCode/Bond/BondEq/CPageAlarm.cpp
index f414c24..31a91ac 100644
--- a/SourceCode/Bond/BondEq/CPageAlarm.cpp
+++ b/SourceCode/Bond/BondEq/CPageAlarm.cpp
@@ -20,9 +20,16 @@
m_crBkgnd = PAGE_BACKGROUND_COLOR;
m_hbrBkgnd = nullptr;
m_pObserver = nullptr;
+
+ m_strKeyword = "";
m_nCurPage = 0;
m_nTotalPages = 0;
m_nDateTimeFlag = 0;
+
+ memset(m_szTimeStart, 0, sizeof(m_szTimeStart));
+ memset(m_szTimeEnd, 0, sizeof(m_szTimeEnd));
+ m_szTimeStart[0] = '\0';
+ m_szTimeEnd[0] = '\0';
}
CPageAlarm::~CPageAlarm()
@@ -41,6 +48,9 @@
ON_WM_CTLCOLOR()
ON_WM_DESTROY()
ON_WM_SIZE()
+ ON_CBN_SELCHANGE(IDC_COMBO_DATETIME, &CPageAlarm::OnCbnSelchangeComboDatetime)
+ ON_BN_CLICKED(IDC_BUTTON_SEARCH, &CPageAlarm::OnBnClickedButtonSearch)
+ ON_BN_CLICKED(IDC_BUTTON_EXPORT, &CPageAlarm::OnBnClickedButtonExport)
ON_BN_CLICKED(IDC_BUTTON_PREV_PAGE, &CPageAlarm::OnBnClickedButtonPrevPage)
ON_BN_CLICKED(IDC_BUTTON_NEXT_PAGE, &CPageAlarm::OnBnClickedButtonNextPage)
END_MESSAGE_MAP()
@@ -90,6 +100,19 @@
CDialogEx::OnInitDialog();
InitRxWindow();
+ // 下拉框控件
+ CComboBox* pComboBox = (CComboBox*)GetDlgItem(IDC_COMBO_DATETIME);
+ pComboBox->AddString(_T("不限"));
+ pComboBox->AddString(_T("今天"));
+ pComboBox->AddString(_T("七天内"));
+ pComboBox->AddString(_T("本月"));
+ pComboBox->AddString(_T("今年"));
+ pComboBox->AddString(_T("自定义"));
+ pComboBox->SetCurSel(0);
+
+ // 日期控件
+ m_dateTimeStart.EnableWindow(FALSE);
+ m_dateTimeEnd.EnableWindow(FALSE);
// 报表控件
CListCtrl* pListCtrl = (CListCtrl*)GetDlgItem(IDC_LIST_ALARM);
@@ -106,6 +129,10 @@
pListCtrl->InsertColumn(4, _T("发生时间"), LVCFMT_LEFT, 180);
pListCtrl->InsertColumn(5, _T("解除时间"), LVCFMT_LEFT, 180);
+ // 计算总页数
+ int totalRecords = AlarmManager::getInstance().getTotalAlarmCount(m_strKeyword, m_szTimeStart, m_szTimeEnd);
+ m_nTotalPages = (totalRecords + PAGE_SIZE - 1) / PAGE_SIZE;
+ m_nCurPage = 1;
Resize();
LoadAlarms();
@@ -212,30 +239,8 @@
void CPageAlarm::UpdatePageData()
{
- // 计算总页数
- int totalRecords = AlarmManager::getInstance().getTotalAlarmCount("", "", "");
- m_nTotalPages = (totalRecords + PAGE_SIZE - 1) / PAGE_SIZE;
-
- std::vector<std::vector<std::string>> vecData;
-
- // 根据时间过滤条件加载数据
- if (m_nDateTimeFlag == 0) {
- vecData = AlarmManager::getInstance().getAlarms((m_nCurPage - 1) * PAGE_SIZE, PAGE_SIZE);
- }
- else {
- COleDateTime startTime, endTime;
- m_dateTimeStart.GetTime(startTime);
- m_dateTimeEnd.GetTime(endTime);
- CString strStartTime = startTime.Format(_T("%Y-%m-%d %H:%M:%S"));
- CString strEndTime = endTime.Format(_T("%Y-%m-%d %H:%M:%S"));
-
- std::string start = CT2A(strStartTime);
- std::string end = CT2A(strEndTime);
-
- vecData = AlarmManager::getInstance().getFilteredAlarms("", start, end, m_nCurPage, PAGE_SIZE);
- }
-
- if (vecData.empty()) return;
+ // 根据过滤条件加载数据
+ auto vecData = AlarmManager::getInstance().getFilteredAlarms(m_strKeyword, m_szTimeStart, m_szTimeEnd, m_nCurPage, PAGE_SIZE);
// 填充数据到控件
CListCtrl* pListCtrl = (CListCtrl*)GetDlgItem(IDC_LIST_ALARM);
@@ -291,6 +296,135 @@
return CDialogEx::DestroyWindow();
}
+void CPageAlarm::OnCbnSelchangeComboDatetime()
+{
+ CComboBox* pComboBox = (CComboBox*)GetDlgItem(IDC_COMBO_DATETIME);
+ int nIndex = pComboBox->GetCurSel();
+ int nCount = pComboBox->GetCount();
+ m_dateTimeStart.EnableWindow(nIndex == nCount - 1);
+ m_dateTimeEnd.EnableWindow(nIndex == nCount - 1);
+}
+
+void CPageAlarm::OnBnClickedButtonSearch()
+{
+ // 获取关键字
+ CString cstrKeyword;
+ GetDlgItemText(IDC_EDIT_KEYWORD, cstrKeyword);
+ m_strKeyword = CT2A(cstrKeyword);
+
+ // 获取日期
+ CComboBox* pComboBox = (CComboBox*)GetDlgItem(IDC_COMBO_DATETIME);
+ m_nDateTimeFlag = pComboBox->GetCurSel();
+ if (m_nDateTimeFlag == 0) {
+ memset(m_szTimeStart, 0, sizeof(m_szTimeStart));
+ memset(m_szTimeEnd, 0, sizeof(m_szTimeEnd));
+ m_szTimeStart[0] = '\0';
+ m_szTimeEnd[0] = '\0';
+ }
+ else {
+ CTime time = CTime::GetCurrentTime();
+ if (m_nDateTimeFlag == 1) {
+ // 今天
+ sprintf_s(m_szTimeStart, 64, "%d-%02d-%02d 00:00:00", time.GetYear(), time.GetMonth(), time.GetDay());
+ sprintf_s(m_szTimeEnd, 64, "%d-%02d-%02d 23:59:59", time.GetYear(), time.GetMonth(), time.GetDay());
+ }
+ else if (m_nDateTimeFlag == 2) {
+ // 7天内
+ CTime time2 = time - CTimeSpan(7, 0, 0, 0);
+ sprintf_s(m_szTimeStart, 64, "%d-%02d-%02d 00:00:00", time2.GetYear(), time2.GetMonth(), time2.GetDay());
+ sprintf_s(m_szTimeEnd, 64, "%d-%02d-%02d 23:59:59", time.GetYear(), time.GetMonth(), time.GetDay());
+ }
+ else if (m_nDateTimeFlag == 3) {
+ // 本月
+ sprintf_s(m_szTimeStart, 64, "%d-%02d-01 00:00:00", time.GetYear(), time.GetMonth());
+ sprintf_s(m_szTimeEnd, 64, "%d-%02d-%02d 23:59:59", time.GetYear(), time.GetMonth(), time.GetDay());
+ }
+ else if (m_nDateTimeFlag == 4) {
+ // 今年
+ sprintf_s(m_szTimeStart, 64, "%d-01-01 00:00:00", time.GetYear());
+ sprintf_s(m_szTimeEnd, 64, "%d-12-31 23:59:59", time.GetYear());
+ }
+ else if (m_nDateTimeFlag == 5) {
+ // 自定义
+ SYSTEMTIME t1, t2;
+ m_dateTimeStart.GetTime(&t1);
+ m_dateTimeEnd.GetTime(&t2);
+
+ sprintf_s(m_szTimeStart, 64, "%d-%02d-%02d %02d:%02d:%02d",
+ t1.wYear, t1.wMonth, t1.wDay, t1.wHour, t1.wMinute, t1.wSecond);
+ sprintf_s(m_szTimeEnd, 64, "%d-%02d-%02d %02d:%02d:%02d",
+ t2.wYear, t2.wMonth, t2.wDay, t2.wHour, t2.wMinute, t2.wSecond);
+ }
+ }
+
+ // 计算总页数
+ int totalRecords = AlarmManager::getInstance().getTotalAlarmCount(m_strKeyword, m_szTimeStart, m_szTimeEnd);
+ m_nTotalPages = (totalRecords + PAGE_SIZE - 1) / PAGE_SIZE;
+ m_nCurPage = 1;
+
+ UpdatePageData(); // 调用分页更新函数
+}
+
+void CPageAlarm::OnBnClickedButtonExport()
+{
+ CFileDialog fileDialog(FALSE, "csv", "", OFN_HIDEREADONLY, "csv.files(*.csv)|*.csv||");
+ if (fileDialog.DoModal() != IDOK) {
+ return;
+ }
+
+ CStdioFile file;
+ if (!file.Open(fileDialog.GetPathName(), CFile::modeCreate | CFile::modeWrite)) {
+ AfxMessageBox("创建文件失败！");
+ }
+
+ int nSubItemCount = 0;
+ CString strSubItem, strHeader, strRow;
+ char szItem[256];
+ HDITEM hdItem[35];
+ for (int i = 0; i < 35; i++) {
+ hdItem[i].pszText = szItem;
+ hdItem[i].cchTextMax = 256;
+ hdItem[i].mask = HDI_TEXT | HDI_WIDTH;
+ }
+
+ // 先读表头
+ CListCtrl* pListCtrl = (CListCtrl*)GetDlgItem(IDC_LIST_ALARM);
+ CHeaderCtrl* pHeader = pListCtrl->GetHeaderCtrl();
+ nSubItemCount = pHeader->GetItemCount();
+ ASSERT(nSubItemCount <= 35);
+ for (int i = 0; i < pHeader->GetItemCount(); i++) {
+ pHeader->GetItem(i, &hdItem[i]);
+ if (hdItem[i].cxy > 0) {
+ if (!strHeader.IsEmpty()) {
+ strHeader.Append(",");
+ }
+ strHeader.Append(CString(hdItem[i].pszText));
+ }
+ }
+ strHeader.Append("\n");
+ file.WriteString(strHeader);
+
+ // 写表格内容
+ int count = pListCtrl->GetItemCount();
+ for (int i = 0; i < count; i++) {
+ strRow.Empty();
+ for (int j = 0; j < nSubItemCount; j++) {
+ if (hdItem[j].cxy > 0) {
+ if (!strRow.IsEmpty()) {
+ strRow.Append(",");
+ }
+ CString strTemp = pListCtrl->GetItemText(i, j);
+ strTemp.Replace("* ", "");
+ strRow.Append(strTemp);
+ }
+ }
+ strRow.Append("\n");
+ file.WriteString(strRow);
+ }
+
+ file.Close();
+}
+
void CPageAlarm::OnBnClickedButtonPrevPage()
{
// 点击上一页
--
Gitblit v1.9.3