seldeptdlg.cpp

人事管理系统

// SelDeptDlg.cpp : implementation file
//

#include "stdafx.h"
#include "personelmanage.h"
#include "SelDeptDlg.h"

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

/////////////////////////////////////////////////////////////////////////////
// CSelDeptDlg dialog


CSelDeptDlg::CSelDeptDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CSelDeptDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CSelDeptDlg)
	m_strSelDept = _T("");
	//}}AFX_DATA_INIT
}


void CSelDeptDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CSelDeptDlg)
	DDX_Control(pDX, IDC_COMBO_SELDEPT, m_cmbDept);
	DDX_CBString(pDX, IDC_COMBO_SELDEPT, m_strSelDept);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CSelDeptDlg, CDialog)
	//{{AFX_MSG_MAP(CSelDeptDlg)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CSelDeptDlg message handlers

BOOL CSelDeptDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	FillCMBDept();
	
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CSelDeptDlg::FillCMBDept()
{
	CString strQuery = _T("SELECT [DeptName] FROM [BlueHill].[dbo].[tblDepartment]");
	CString deptValue;

	CADODatabase *pDb = new CADODatabase;
	try
	{
		if(pDb->Open())
		{
			CADORecordset *pRs = new CADORecordset(pDb);
			if(pRs->Open(strQuery, CADORecordset::openQuery))
			{
				while(!pRs->IsEOF())
				{
					pRs->GetFieldValue("DeptName", deptValue);
					m_cmbDept.AddString(deptValue);
					pRs->MoveNext();
				}
				pRs->Close();
			}
			delete pRs;
			pDb->Close();
		}
		delete pDb;
	}
	catch(CADOException)
	{
	}
}