// AnalogDlg.cpp : implementation file // #include "stdafx.h" #include "IDE.h" #include "DlgQueryWarningRec.h" #include ".\dlgquerywarningrec.h" #include "Syslib.h" #ifdef _DEBUG #define new DEBUG_NEW #undef THIS_FILE static char THIS_FILE[] = __FILE__; #endif ///////////////////////////////////////////////////////////////////////////// // CDlgQueryWarningRec dialog CDlgQueryWarningRec::CDlgQueryWarningRec(CWnd* pParent /*=NULL*/) : CDialog(CDlgQueryWarningRec::IDD, pParent) { //{{AFX_DATA_INIT(CDlgQueryWarningRec) // NOTE: the ClassWizard will add member initialization here //}}AFX_DATA_INIT m_ctrlGridRec.RegisterWindowClass(g_hLangDLL); } void CDlgQueryWarningRec::DoDataExchange(CDataExchange* pDX) { CDialog::DoDataExchange(pDX); //{{AFX_DATA_MAP(CDlgQueryWarningRec) DDX_Control(pDX, IDC_GRID_REC, m_ctrlGridRec); //}}AFX_DATA_MAP DDX_Control(pDX, IDC_DT_START_DATE, m_ctrlStartDate); DDX_Control(pDX, IDC_DT_END_DATE, m_ctrlEndDate); DDX_Control(pDX, IDC_COMBO_DEVICE, m_Comb_Device); DDX_Control(pDX, IDC_COMBO_AREA, m_Comb_Area); } BEGIN_MESSAGE_MAP(CDlgQueryWarningRec, CDialog) //{{AFX_MSG_MAP(CDlgQueryWarningRec) //}}AFX_MSG_MAP ON_BN_CLICKED(IDC_BTN_CLOSE, OnBnClickedBtnClose) ON_BN_CLICKED(IDC_BTN_QUERY, OnBnClickedBtnQuery) ON_BN_CLICKED(IDC_BTN_DEL, OnBnClickedBtnDel) ON_BN_CLICKED(IDC_BTN_EXPORT, OnBnClickedBtnExport) END_MESSAGE_MAP() ///////////////////////////////////////////////////////////////////////////// // CDlgQueryWarningRec message handlers void CDlgQueryWarningRec::OnOK() { // TODO: Add extra validation here CDialog::OnOK(); } void CDlgQueryWarningRec::OnCancel() { // TODO: Add extra cleanup here CDialog::OnCancel(); } BOOL CDlgQueryWarningRec::OnInitDialog() { CDialog::OnInitDialog(); m_btnQuery.SubclassDlgItem(IDC_BTN_QUERY, this); m_btnQuery.SetBitmaps(IDB_FRESH, RGB(255, 0, 255)); m_btnQuery.SetFlat(FALSE); m_btnQuery.SetAlign(CButtonST::ST_ALIGN_HORIZ); m_btnExit.SubclassDlgItem(IDC_BTN_CLOSE, this); m_btnExit.SetBitmaps(IDB_EXIT , RGB(192, 192, 192)); m_btnExit.SetFlat(FALSE); m_btnExit.SetAlign(CButtonST::ST_ALIGN_HORIZ); m_btnDel.SubclassDlgItem(IDC_BTN_DEL, this); m_btnDel.SetBitmaps(IDB_DEL , RGB(255,0 , 255)); m_btnDel.SetFlat(FALSE); m_btnDel.SetAlign(CButtonST::ST_ALIGN_HORIZ); m_btnExport.SubclassDlgItem(IDC_BTN_EXPORT, this); m_btnExport.SetBitmaps(IDB_INTO, RGB(255, 0, 255)); m_btnExport.SetFlat(FALSE); m_btnExport.SetAlign(CButtonST::ST_ALIGN_HORIZ); CTime tmToday; //今天的日期 CTime tmPreTwoDay; //前两天的日期 CTimeSpan tmspanTwoDay(1,0,0,0); //两天的时间距离 tmToday=CTime::GetCurrentTime();//获得当前日期 tmPreTwoDay=tmToday-tmspanTwoDay; UpdateData(TRUE);//时间更新为当前时间 m_ctrlStartDate.SetFormat("yyyy-M-d HH:mm:ss"); m_ctrlStartDate.SetTime( &tmPreTwoDay ); m_ctrlEndDate.SetFormat("yyyy-M-d HH:mm:ss"); m_ctrlEndDate.SetTime( &tmToday ); SetFields(); int nIndex = 1; m_Comb_Device.InsertString( 0,"全部" ); int nComportSize = pDevicesManager->m_channels.GetSize(); for (int i = 0; i < nComportSize; i++) { CChannel* pComport = pDevicesManager->m_channels[i]; int nDeviceSize = pComport->m_Devices.GetSize(); for (int j = 0; j < nDeviceSize; j++) { CDevice* pDev = pComport->m_Devices[j]; m_Comb_Device.InsertString( nIndex++,pDev->m_strName ); } } m_Comb_Device.SetCurSel( 0 ); nIndex = 1; m_Comb_Area.InsertString( 0,"全部" ); for (int i = 0; i < nComportSize; i++) { CChannel* pComport = pDevicesManager->m_channels[i]; int nDeviceSize = pComport->m_Devices.GetSize(); for (int j = 0; j < nDeviceSize; j++) { CDevice* pDev = pComport->m_Devices[j]; bool bExist=false; for( int m=0;mm_strReserved1 ) { bExist = true; break; } } if( !bExist && pDev->m_strReserved1!="" ) m_Comb_Area.InsertString( nIndex++,pDev->m_strReserved1 ); } } m_Comb_Area.SetCurSel( 0 ); return TRUE; // return TRUE unless you set the focus to a control // EXCEPTION: OCX Property Pages should return FALSE } void CDlgQueryWarningRec::SetFields() { int i; m_ctrlGridRec.m_field.SetSize(4); i=0; m_ctrlGridRec.m_field[i].Field=_T("id"); m_ctrlGridRec.m_field[i].Caption=_T("ID"); m_ctrlGridRec.m_field[i].With = 50; m_ctrlGridRec.m_field[i].Find=true; i=1; m_ctrlGridRec.m_field[i].Field=_T("type_desc"); m_ctrlGridRec.m_field[i].Caption=g_strDes; m_ctrlGridRec.m_field[i].With=150; m_ctrlGridRec.m_field[i].Find=true; i=2; m_ctrlGridRec.m_field[i].Field=_T("happen_time"); m_ctrlGridRec.m_field[i].Caption=g_strHappenTime2; m_ctrlGridRec.m_field[i].With=120; m_ctrlGridRec.m_field[i].Find=true; i=3; m_ctrlGridRec.m_field[i].Field=_T("warncontent"); m_ctrlGridRec.m_field[i].Caption=g_strWarnContent; m_ctrlGridRec.m_field[i].With=455; m_ctrlGridRec.m_field[i].Find=true; Requery(); } void CDlgQueryWarningRec::Requery() { CString strWhere; //strWhere.Format(" uid <> \'%s\'", "admin"); CString strStartTime, strEndTime, strStartDate, strEndDate; CString strTelNum, strContent; CTime tmToday; CTime tmPreTwoDay; m_ctrlStartDate.GetTime( tmPreTwoDay ); m_ctrlEndDate.GetTime( tmToday ); strStartDate.Format( "%d-%d-%d %d:%d:%d", tmPreTwoDay.GetYear(), tmPreTwoDay.GetMonth(), tmPreTwoDay.GetDay(), tmPreTwoDay.GetHour(), tmPreTwoDay.GetMinute(), tmPreTwoDay.GetSecond() ); strEndDate.Format( "%d-%d-%d %d:%d:%d", tmToday.GetYear(), tmToday.GetMonth(), tmToday.GetDay(), tmToday.GetHour(), tmToday.GetMinute(), tmToday.GetSecond() ); strWhere = "happen_time >= '" + strStartDate + "' and happen_time <= '" + strEndDate + "'"; UpdateData(); int n = m_Comb_Device.GetCurSel(); if( n>0 ) { CString sLBText; m_Comb_Device.GetLBText( n,sLBText ); CString sAdd; sAdd = " and equip_desc = '" + sLBText + "'" ; strWhere += sAdd; } n = m_Comb_Area.GetCurSel(); if( n>0 ) { CString sLBText; m_Comb_Area.GetLBText( n,sLBText ); CString sAdd; sAdd = " and memos = '" + sLBText + "'" ; strWhere += sAdd; } m_ctrlGridRec.Execute(_T("id")/*Primary key field */ ,_T("*")//fields in SELECT statment ,_T("t_waring_record") //from ,strWhere // where ,0,0); // order by N of the Grid column // } BOOL CDlgQueryWarningRec::OnNotify(WPARAM wParam, LPARAM lParam, LRESULT* pResult) { LPNMHDR pNmhdr = (LPNMHDR)lParam; // TODO: 在此添加专用代码和/或调用基类 if (wParam == (WPARAM)m_ctrlGridRec.GetDlgCtrlID()) { *pResult = 1; GV_DISPINFO *pDispInfo = (GV_DISPINFO*)lParam; m_ctrlGridRec.SetValue(pDispInfo); } return CDialog::OnNotify(wParam, lParam, pResult); } BEGIN_EVENTSINK_MAP(CDlgQueryWarningRec, CDialog) //{{AFX_EVENTSINK_MAP(CDlgQueryWarningRec) //}}AFX_EVENTSINK_MAP END_EVENTSINK_MAP() void CDlgQueryWarningRec::OnBnClickedBtnClose() { // TODO: 在此添加控件通知处理程序代码 OnCancel(); } void CDlgQueryWarningRec::OnBnClickedBtnQuery() { // TODO: 在此添加控件通知处理程序代码 Requery(); } void CDlgQueryWarningRec::OnBnClickedBtnDel() { int nCount = m_ctrlGridRec.GetRowCount(); CString sID; if( nCount>0 ) if (MessageBox (g_strMsgConfirmDelRecord, g_strMsgPrompt, MB_YESNO|MB_DEFBUTTON2 | MB_ICONQUESTION) != IDYES) return; for( int nRow=0;nRowGetText(); CDBInterface::GetInstancePtr()->DelTableData( "t_waring_record","id",(char *)(LPCTSTR)sID,2 ); } m_ctrlGridRec.DeleteAllItems(); Requery(); } void CDlgQueryWarningRec::OnBnClickedBtnExport() { ExportListToExcel( (CDataGrid*)&m_ctrlGridRec, "报警记录" ); }