repos_ecs/源数据/PC环境监控/tryto v1.0.0.3/只运行 IDE/IDE/DlgQueryWarningRec.cpp

// 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);
}


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();
	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 + "'";

	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;nRow<nCount;nRow++ )
	{
		sID = m_ctrlGridRec.GetCell( nRow, 0 )->GetText();
		CDBInterface::GetInstancePtr()->DelTableData( "t_waring_record","id",(char *)(LPCTSTR)sID,2 );
	}
	m_ctrlGridRec.DeleteAllItems();
	Requery();
}
void CDlgQueryWarningRec::OnBnClickedBtnExport()
{
	ExportListToExcel( (CDataGrid*)&m_ctrlGridRec, "报警记录"  );
}