From 97e9c6896ffaedcc2c00fb4ea1bee6a5cdbc4a5d Mon Sep 17 00:00:00 2001
From: darker <mr.darker@163.com>
Date: 星期五, 21 二月 2025 15:55:55 +0800
Subject: [PATCH] 1. 报警记录界面加载数据库的数据，并且实现过滤查找

---
 SourceCode/Bond/Servo/AlarmDlg.cpp |  387 +++++++++++++++++++++++++++++++++++++++++++++++++++++++
 1 files changed, 386 insertions(+), 1 deletions(-)

diff --git a/SourceCode/Bond/Servo/AlarmDlg.cpp b/SourceCode/Bond/Servo/AlarmDlg.cpp
index ac31cf9..4da1912 100644
--- a/SourceCode/Bond/Servo/AlarmDlg.cpp
+++ b/SourceCode/Bond/Servo/AlarmDlg.cpp
@@ -5,8 +5,9 @@
 #include "Servo.h"
 #include "afxdialogex.h"
 #include "AlarmDlg.h"
+#include "AlarmManager.h"
 
-#define PAGE_SIZE						20
+#define PAGE_SIZE						10
 #define PAGE_BACKGROUND_COLOR			RGB(252, 252, 255)
 
 // CAlarmDlg 瀵硅瘽妗�
@@ -20,6 +21,7 @@
 	m_hbrBkgnd = nullptr;
 	m_pObserver = nullptr;
 
+	m_strEqName = "";
 	m_strKeyword = "";
 	m_nCurPage = 0;
 	m_nTotalPages = 0;
@@ -35,6 +37,143 @@
 {
 }
 
+void CAlarmDlg::InitRxWindow()
+{
+	/* code */
+	// 璁㈤槄鏁版嵁
+	IRxWindows* pRxWindows = RX_GetRxWindows();
+	pRxWindows->enableLog(5);
+	if (m_pObserver == NULL) {
+		m_pObserver = pRxWindows->allocObserver([&](IAny* pAny) -> void {
+			// onNext
+			pAny->addRef();
+			int code = pAny->getCode();
+			//if (RX_CODE_ALARM_ON == code) {
+			//	CAlarm* pAlarm;
+			//	if (pAny->getObject("obj", (IRxObject*&)pAlarm)) {
+			//		AddAlarm(nullptr, pAlarm);
+			//	}
+			//}
+			//else if (RX_CODE_ALARM_OFF == code) {
+			//	CAlarm* pAlarm;
+			//	if (pAny->getObject("obj", (IRxObject*&)pAlarm)) {
+			//		UpdateAlarm(nullptr, pAlarm);
+			//	}
+			//}
+
+		pAny->release();
+		}, [&]() -> void {
+			// onComplete
+		}, [&](IThrowable* pThrowable) -> void {
+			// onErrorm
+			pThrowable->printf();
+		});
+
+		//theApp.m_model.getObservable()->observeOn(pRxWindows->mainThread())
+		//	->subscribe(m_pObserver);
+	}
+}
+
+void CAlarmDlg::Resize()
+{
+	CWnd* pItem;
+	CRect rcClient;
+	GetClientRect(&rcClient);
+
+	pItem = GetDlgItem(IDC_LIST_ALARM);
+	pItem->MoveWindow(12, 52, rcClient.Width() - 24, rcClient.Height() - 64);
+}
+
+void CAlarmDlg::LoadAlarms()
+{
+	//CAlarmMonitor* pMonitor = (CAlarmMonitor*)theApp.m_model.getBonder().GetComponent(ALARM_MONITOR);
+
+	// 褰撳墠姝ｅ湪鍙戠敓鐨勬姤璀�
+	//pMonitor->Lock();
+	//std::map<int, CAlarm*>& alarmings = pMonitor->getAlarmingMap();
+	//for (auto item : alarmings) {
+	//	AddAlarm(pMonitor, item.second);
+	//}
+	//pMonitor->Unlock();
+
+	// 鍒锋柊鍘嗗彶鎶ヨ鏁版嵁
+	m_nCurPage = 1;
+	UpdatePageData();
+}
+
+//void CAlarmDlg::AddAlarm(CAlarmMonitor* pMonitor, CAlarm* pAlarm)
+//{
+//	if (pMonitor == nullptr) {
+//		pMonitor = (CAlarmMonitor*)theApp.m_model.getBonder().GetComponent(ALARM_MONITOR);
+//	}
+//	CListCtrl* pListCtrl = (CListCtrl*)GetDlgItem(IDC_LIST_ALARM);
+//	pListCtrl->InsertItem(0, _T(""));
+//	pListCtrl->SetItemData(0, (DWORD_PTR)pAlarm);
+//	pAlarm->addRef();
+//	pListCtrl->SetItemText(0, 1, std::to_string(pAlarm->getId()).c_str());
+//	pListCtrl->SetItemText(0, 2, pMonitor->getAlarmText(pAlarm->getId()));
+//	pListCtrl->SetItemText(0, 3, CToolUnits::timeToString2(pAlarm->getOnTime()).c_str());
+//	if (pAlarm->getOffTime() > 0) {
+//		pListCtrl->SetItemText(0, 4, CToolUnits::timeToString2(pAlarm->getOffTime()).c_str());
+//	}
+//}
+
+//void CAlarmDlg::UpdateAlarm(CAlarmMonitor* pMonitor, CAlarm* pAlarm)
+//{
+//	if (pMonitor == nullptr) {
+//		pMonitor = (CAlarmMonitor*)theApp.m_model.getBonder().GetComponent(ALARM_MONITOR);
+//	}
+//	CListCtrl* pListCtrl = (CListCtrl*)GetDlgItem(IDC_LIST_ALARM);
+//	for (int i = 0; i < pListCtrl->GetItemCount(); i++) {
+//		if (pListCtrl->GetItemData(i) == (DWORD_PTR)pAlarm) {
+//			if (pAlarm->getOffTime() > 0) {
+//				pListCtrl->SetItemText(i, 4, CToolUnits::timeToString2(pAlarm->getOffTime()).c_str());
+//			}
+//		}
+//	}
+//}
+
+void CAlarmDlg::UpdatePageData()
+{
+	// 鏍规嵁杩囨护鏉′欢鍔犺浇鏁版嵁锛屾彁渚涙弿杩板拰鏃堕棿鑼冨洿鏌ヨ
+	auto vecData = AlarmManager::getInstance().getFilteredAlarms("", m_strEqName, m_strKeyword, m_szTimeStart, m_szTimeEnd, m_nCurPage, PAGE_SIZE);
+
+	// 濉厖鏁版嵁鍒版帶浠�
+	CListCtrl* pListCtrl = (CListCtrl*)GetDlgItem(IDC_LIST_ALARM);
+	FillDataToListCtrl(pListCtrl, vecData);
+
+	// 鏇存柊鍒嗛〉鎺т欢锛堥〉鏁板拰鎸夐挳锛�
+	UpdatePageControls();
+}
+
+void CAlarmDlg::UpdatePageControls()
+{
+	// 鏇存柊鍒嗛〉淇℃伅
+	CString strPage;
+	strPage.Format(_T("绗� %d 椤�"), m_nCurPage);
+	SetDlgItemText(IDC_LABEL_PAGE_NUMBER, strPage);
+
+	// 鍚敤/绂佺敤缈婚〉鎸夐挳
+	GetDlgItem(IDC_BUTTON_PREV_PAGE)->EnableWindow(m_nCurPage > 1);
+	GetDlgItem(IDC_BUTTON_NEXT_PAGE)->EnableWindow(m_nCurPage < m_nTotalPages);
+}
+
+void CAlarmDlg::FillDataToListCtrl(CListCtrl* pListCtrl, const std::vector<std::vector<std::string>>& vecData)
+{
+	// 娓呯┖褰撳墠CListCtrl涓殑鎵�鏈夐」
+	pListCtrl->DeleteAllItems();
+
+	// 閬嶅巻鏁版嵁骞舵彃鍏ュ埌CListCtrl涓�
+	for (const auto& item : vecData) {
+		int nItem = pListCtrl->InsertItem(pListCtrl->GetItemCount(), _T(""));	// 鎻掑叆鏂拌
+		pListCtrl->SetItemText(nItem, 1, item[0].c_str());						// 璁剧疆绗竴鍒楃殑鏂囨湰锛圛D锛�
+		pListCtrl->SetItemText(nItem, 2, item[1].c_str());						// 璁剧疆绗簩鍒楃殑鏂囨湰锛堣澶囧悕绉帮級
+		pListCtrl->SetItemText(nItem, 3, item[2].c_str());						// 璁剧疆绗笁鍒楃殑鏂囨湰锛堟弿杩帮級
+		pListCtrl->SetItemText(nItem, 4, item[3].c_str());						// 璁剧疆绗洓鍒楃殑鏂囨湰锛堝紑濮嬫椂闂达級
+		pListCtrl->SetItemText(nItem, 5, item[4].c_str());						// 璁剧疆绗洓鍒楃殑鏂囨湰锛堣В闄ゆ椂闂达級
+	}
+}
+
 void CAlarmDlg::DoDataExchange(CDataExchange* pDX)
 {
 	DDX_Control(pDX, IDC_DATETIMEPICKER_START, m_dateTimeStart);
@@ -44,7 +183,253 @@
 
 
 BEGIN_MESSAGE_MAP(CAlarmDlg, CDialogEx)
+	ON_WM_CTLCOLOR()
+	ON_WM_DESTROY()
+	ON_WM_SIZE()
+	ON_CBN_SELCHANGE(IDC_COMBO_DATETIME, &CAlarmDlg::OnCbnSelchangeComboDatetime)
+	ON_BN_CLICKED(IDC_BUTTON_SEARCH, &CAlarmDlg::OnBnClickedButtonSearch)
+	ON_BN_CLICKED(IDC_BUTTON_EXPORT, &CAlarmDlg::OnBnClickedButtonExport)
+	ON_BN_CLICKED(IDC_BUTTON_PREV_PAGE, &CAlarmDlg::OnBnClickedButtonPrevPage)
+	ON_BN_CLICKED(IDC_BUTTON_NEXT_PAGE, &CAlarmDlg::OnBnClickedButtonNextPage)
 END_MESSAGE_MAP()
 
 
 // CAlarmDlg 娑堟伅澶勭悊绋嬪簭
+BOOL CAlarmDlg::OnInitDialog()
+{
+	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);
+	DWORD dwStyle = pListCtrl->GetExtendedStyle();
+	dwStyle |= LVS_EX_FULLROWSELECT;
+	dwStyle |= LVS_EX_GRIDLINES;
+	pListCtrl->SetExtendedStyle(dwStyle);
+
+	HIMAGELIST imageList = ImageList_Create(24, 24, ILC_COLOR24, 1, 1);
+	ListView_SetImageList(pListCtrl->GetSafeHwnd(), imageList, LVSIL_SMALL);
+	pListCtrl->InsertColumn(0, _T(""), LVCFMT_RIGHT, 0);
+	pListCtrl->InsertColumn(1, _T("璀﹀憡ID"), LVCFMT_LEFT, 50);
+	pListCtrl->InsertColumn(2, _T("璁惧鍚嶇О"), LVCFMT_LEFT, 120);
+	pListCtrl->InsertColumn(3, _T("鎻忚堪"), LVCFMT_LEFT, 280);
+	pListCtrl->InsertColumn(4, _T("鍙戠敓鏃堕棿"), LVCFMT_LEFT, 180);
+	pListCtrl->InsertColumn(5, _T("瑙ｉ櫎鏃堕棿"), LVCFMT_LEFT, 180);
+
+	// 璁＄畻鎬婚〉鏁�
+	int totalRecords = AlarmManager::getInstance().getTotalAlarmCount("", m_strEqName, m_strKeyword, m_szTimeStart, m_szTimeEnd);
+	m_nTotalPages = (totalRecords + PAGE_SIZE - 1) / PAGE_SIZE;
+	m_nCurPage = 1;
+
+	Resize();
+	LoadAlarms();
+
+	return TRUE;  // return TRUE unless you set the focus to a control
+	// 寮傚父: OCX 灞炴�ч〉搴旇繑鍥� FALSE
+}
+
+BOOL CAlarmDlg::DestroyWindow()
+{
+	//CListCtrl* pListCtrl = (CListCtrl*)GetDlgItem(IDC_LIST_ALARM);
+	//for (int i = 0; i < pListCtrl->GetItemCount(); i++) {
+	//	CAlarm* pAlarm = (CAlarm*)pListCtrl->GetItemData(i);
+	//	if (pAlarm != nullptr) {
+	//		pAlarm->release();
+	//	}
+	//}
+
+	return CDialogEx::DestroyWindow();
+}
+
+HBRUSH CAlarmDlg::OnCtlColor(CDC* pDC, CWnd* pWnd, UINT nCtlColor)
+{
+	HBRUSH hbr = CDialogEx::OnCtlColor(pDC, pWnd, nCtlColor);
+
+	if (nCtlColor == CTLCOLOR_STATIC) {
+		pDC->SetBkColor(m_crBkgnd);
+	}
+
+	if (m_hbrBkgnd == nullptr) {
+		m_hbrBkgnd = CreateSolidBrush(m_crBkgnd);
+	}
+
+	return m_hbrBkgnd;
+}
+
+void CAlarmDlg::OnDestroy()
+{
+	CDialogEx::OnDestroy();
+
+	if (m_hbrBkgnd != nullptr) {
+		::DeleteObject(m_hbrBkgnd);
+	}
+
+	if (m_pObserver != NULL) {
+		m_pObserver->unsubscribe();
+		m_pObserver = NULL;
+	}
+}
+
+void CAlarmDlg::OnSize(UINT nType, int cx, int cy)
+{
+	CDialogEx::OnSize(nType, cx, cy);
+	if (GetDlgItem(IDC_LIST_ALARM) == nullptr) return;
+	Resize();
+}
+
+void CAlarmDlg::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 CAlarmDlg::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_strEqName, m_strKeyword, m_szTimeStart, m_szTimeEnd);
+	m_nTotalPages = (totalRecords + PAGE_SIZE - 1) / PAGE_SIZE;
+	m_nCurPage = 1;
+
+	UpdatePageData();  // 璋冪敤鍒嗛〉鏇存柊鍑芥暟
+}
+
+void CAlarmDlg::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 CAlarmDlg::OnBnClickedButtonPrevPage()
+{
+	// 鐐瑰嚮涓婁竴椤�
+	m_nCurPage--;
+	UpdatePageData();  // 璋冪敤鍒嗛〉鏇存柊鍑芥暟
+}
+
+void CAlarmDlg::OnBnClickedButtonNextPage()
+{
+	// 鐐瑰嚮涓嬩竴椤�
+	m_nCurPage++;
+	UpdatePageData();  // 璋冪敤鍒嗛〉鏇存柊鍑芥暟
+}

--
Gitblit v1.9.3