dlgdevicefault.cpp

用VC编写的立体仓库的管理软件源程序和设计说明书。

// DlgDeviceFault.cpp : implementation file
//

#include "stdafx.h"
#include "Manage_WH.h"
#include "DlgDeviceFault.h"

#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

/////////////////////////////////////////////////////////////////////////////
// CDlgDeviceFault dialog


CDlgDeviceFault::CDlgDeviceFault(CWnd* pParent /*=NULL*/)
	: CDialog(CDlgDeviceFault::IDD, pParent)
{
	//{{AFX_DATA_INIT(CDlgDeviceFault)
		// NOTE: the ClassWizard will add member initialization here
	//}}AFX_DATA_INIT
	m_hIcon = AfxGetApp()->LoadIcon(IDI_MYICON);
}


void CDlgDeviceFault::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CDlgDeviceFault)
	DDX_Control(pDX, IDC_LIST, m_list);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CDlgDeviceFault, CDialog)
	//{{AFX_MSG_MAP(CDlgDeviceFault)
	ON_BN_CLICKED(IDC_REFRESH, OnRefresh)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CDlgDeviceFault message handlers

BOOL CDlgDeviceFault::PreTranslateMessage(MSG* pMsg) 
{
	if (pMsg->message==WM_KEYDOWN && (pMsg->wParam==13 || pMsg->wParam==27))
		return TRUE;
	return CDialog::PreTranslateMessage(pMsg);
}

BOOL CDlgDeviceFault::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	SetIcon(m_hIcon,TRUE);
	m_list.InsertColumn(0,"故障",LVCFMT_LEFT,180,-1);
	m_list.InsertColumn(1,"时间",LVCFMT_LEFT,180,-1);
	m_list.SetExtendedStyle( LVS_EX_GRIDLINES|LVS_EX_FULLROWSELECT );
	Refresh();
	return TRUE;
}

void CDlgDeviceFault::Refresh()
{
	CAdoConnection cn;
	CAdoRecordSet  rs;
	cn.OpenUDLFile(gstrConSQLSer);
	rs.SetAdoConnection(&cn);
	rs.Open("select F_Remark,F_Time from V_DeviceFault",adCmdText);
	if (rs.GetRecordCount() > 0)
	{
		int row = 0;
		CString sVal;
		rs.MoveFirst();
		m_list.DeleteAllItems();
		m_list.SetRedraw(FALSE);
		while (!rs.IsEOF())
		{
			row = m_list.InsertItem(row,"");
			for (int i=0;i<2;i++)
			{
				rs.GetCollect(i,sVal);
				m_list.SetItemText(row,i,sVal);
			}
			row++;
			rs.MoveNext();
		}
		m_list.SetRedraw(TRUE);
	}
	rs.Close();
	cn.Close();
}

void CDlgDeviceFault::OnRefresh() 
{
	Refresh();	
}