repos_ecs/Client_1.0.0.5/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);
	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;m<m_Comb_Area.GetCount();m++ )
			{
				CString sLBText;
				m_Comb_Area.GetLBText( m,sLBText );
				if( sLBText==pDev->m_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;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, "报警记录"  );
}