selempdlg.cpp

人事管理系统

// SelEmpDlg.cpp : implementation file
//

#include "stdafx.h"
#include "personelmanage.h"
#include "SelEmpDlg.h"

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

/////////////////////////////////////////////////////////////////////////////
// CSelEmpDlg dialog


CSelEmpDlg::CSelEmpDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CSelEmpDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CSelEmpDlg)
		// NOTE: the ClassWizard will add member initialization here
	//}}AFX_DATA_INIT
}


void CSelEmpDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CSelEmpDlg)
	DDX_Control(pDX, IDC_LIST_EMP, m_ctrlEmp);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CSelEmpDlg, CDialog)
	//{{AFX_MSG_MAP(CSelEmpDlg)
	ON_NOTIFY(LVN_ITEMCHANGING, IDC_LIST_EMP, OnItemchangingListEmp)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CSelEmpDlg message handlers

BOOL CSelEmpDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();

	DWORD dwStyle = m_ctrlEmp.GetExtendedStyle();
	dwStyle |= LVS_EX_GRIDLINES | LVS_EX_FULLROWSELECT;
	m_ctrlEmp.SetExtendedStyle(dwStyle);

	m_ctrlEmp.InsertColumn(0, "员工号", LVCFMT_LEFT, 128);
	m_ctrlEmp.InsertColumn(1, "员工姓名", LVCFMT_LEFT, 128);

	GetEmpList();
	
	// TODO: Add extra initialization here
	
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CSelEmpDlg::GetEmpList()
{
	CString strQuery = "SELECT [EmployeeID],[Name] FROM [tblEmployee]";
	CString strEmployeeID;
	CString strName;

	CADODatabase *pDb = new CADODatabase;
	try
	{
		if(pDb->Open())
		{
			CADORecordset *pRs = new CADORecordset(pDb);
			if(pRs->Open(strQuery, CADORecordset::openQuery))
			{
				m_ctrlEmp.DeleteAllItems();
				int cur = 0;
				while(!pRs->IsEOF())
				{
					pRs->GetFieldValue("EmployeeID", strEmployeeID);
					m_ctrlEmp.InsertItem(cur, strEmployeeID);
					pRs->GetFieldValue("Name", strName);
					m_ctrlEmp.SetItemText(cur, 1, strName);

					cur++;
					pRs->MoveNext();
				}
				pRs->Close();
			}
			delete pRs;
			pDb->Close();
		}
		delete pDb;
	}
	catch(CADOException)
	{
	}
}

void CSelEmpDlg::OnItemchangingListEmp(NMHDR* pNMHDR, LRESULT* pResult) 
{
	NM_LISTVIEW* pNMListView = (NM_LISTVIEW*)pNMHDR;
	// TODO: Add your control notification handler code here
	m_strSelEmpID = m_ctrlEmp.GetItemText(pNMListView->iItem, 0);
	
	*pResult = 0;
}