empseldlg.cpp

一个功能很强的人事管理系统,具有数据库,用户登陆,部门管理,员工信息管理,考勤管理等等.

// EmpSelDlg.cpp : implementation file
//

#include "stdafx.h"
#include "HrSys.h"
#include "EmpSelDlg.h"
#include "Departments.h"

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

/////////////////////////////////////////////////////////////////////////////
// CEmpSelDlg dialog


CEmpSelDlg::CEmpSelDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CEmpSelDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CEmpSelDlg)
	//}}AFX_DATA_INIT
}


void CEmpSelDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CEmpSelDlg)
	DDX_Control(pDX, IDC_TYPE_COMBO, m_Combo);
	DDX_Control(pDX, IDC_TREE1, m_tree);
	DDX_Control(pDX, IDC_ADODC1, m_Adodc);
	DDX_Control(pDX, IDC_DATALIST1, m_datalist);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CEmpSelDlg, CDialog)
	//{{AFX_MSG_MAP(CEmpSelDlg)
	ON_NOTIFY(NM_CLICK, IDC_TREE1, OnClickTree1)
	ON_CBN_SELCHANGE(IDC_TYPE_COMBO, OnSelchangeTypeCombo)
	ON_NOTIFY(TVN_SELCHANGED, IDC_TREE1, OnSelchangedTree1)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CEmpSelDlg message handlers

BOOL CEmpSelDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	//装入部门信息
	dep.Load_dep();
	
	//添加根节点
	m_treeImageList.Create(16,16,FALSE,1,0);  //创建CImageList控件
	//装入ICON资源
	HICON hIcon = ::LoadIcon(AfxGetResourceHandle(), MAKEINTRESOURCE(IDI_ICON1));
	m_treeImageList.Add(hIcon);  //将ICON资源添加到CImageList控件中
	//将CImageList控件与Tree控件相关联	
	m_tree.SetImageList(&m_treeImageList, LVSIL_NORMAL);
	m_root = m_tree.InsertItem("部门信息");  //添加根节点
	//调用AddtoTree() 函数，将所有部门信息添加到Tree控件中	
	AddtoTree(m_root, 0);
	m_tree.Expand(m_root, TVE_EXPAND); //展开根节点
	//选中根节点
	m_tree.SelectItem(m_root);

	//设置员工类型
	m_Combo.SetCurSel(0);

	UpdateData(FALSE);
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CEmpSelDlg::AddtoTree(HTREEITEM m_node, int UpperId)
{
	//使用递归方法将部门添加到TreeView控件中
	int i;
	HTREEITEM m_child;
	//依次访问dep对象中的部门数组，查找满足条件的记录添加到Tree控件中
	for(i=0; i<dep.a_UpperId.GetSize(); i++)
	{
		//@@@@ 打开a_UpperId数组中等于UpperId的元素
		//@@@@ 表明此元素为当前根节点的子节点，因此将其添加到Tree控件中，新节点为m_child
		//@@@@ 使用SetItemData()函数将部门编号值也保存在新节点中
		//@@@@ 以新节点为根节点，再次递归调用AddtoTree()函数，将其子节点添加到Tree控件中
		if (UpperId == atoi(dep.a_UpperId.GetAt(i)))
		{
			m_child = m_tree.InsertItem(dep.a_DepName.GetAt(i), m_node);
			m_tree.SetItemData(m_child, atol(dep.a_DepId.GetAt(i)));
			AddtoTree(m_child, atoi(dep.a_DepId.GetAt(i)));
		}
	}
}

void CEmpSelDlg::Refresh_List()
{
	UpdateData(TRUE);

	int iDepId;
	HTREEITEM node;
	node = m_tree.GetSelectedItem();
	iDepId = m_tree.GetItemData(node);
	//设置SQL语句
	CString cDepId;
	cDepId.Format("%d", iDepId);
	CString cSource = "SELECT * FROM Employees WHERE Dep_Id=" + cDepId;
	//得到类型
	int iType = m_Combo.GetCurSel();
	CString cType;
	cType.Format("%d", iType);
	if (iType > 0)
		cSource += " AND State=" + cType;
	//设置ADO Data的RecordSource
	m_Adodc.SetRecordSource(cSource);
	m_Adodc.Refresh();
}

void CEmpSelDlg::OnClickTree1(NMHDR* pNMHDR, LRESULT* pResult) 
{
	// TODO: Add your control notification handler code here


	*pResult = 0;
}

void CEmpSelDlg::OnSelchangeTypeCombo() 
{
	// TODO: Add your control notification handler code here
	Refresh_List();	
}

void CEmpSelDlg::OnSelchangedTree1(NMHDR* pNMHDR, LRESULT* pResult) 
{
	NM_TREEVIEW* pNMTreeView = (NM_TREEVIEW*)pNMHDR;
	// TODO: Add your control notification handler code here
	Refresh_List();	
	*pResult = 0;
}

void CEmpSelDlg::OnOK() 
{
	// TODO: Add extra validation here
	if (atoi(m_datalist.GetBoundText()) == 0)
	{
		MessageBox("请选择员工");
		return;
	}
	//设置Emp_Id和Emp_name变量，在其他模块中可以通过这两个变量获取选择的员工信息
	Emp_Id = atoi(m_datalist.GetBoundText());
	Emp_name = m_datalist.GetText();

	CDialog::OnOK();
}