newxueli.cpp

这是一个企业人力资源管理系统设计实例！比较实用！

// NewXueLi.cpp : implementation file
//

#include "stdafx.h"
#include "EmpMan.h"
#include "NewXueLi.h"
#include "AddXueli.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

/////////////////////////////////////////////////////////////////////////////
// CNewXueLi dialog


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


void CNewXueLi::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CNewXueLi)
	DDX_Control(pDX, IDC_LIST1, m_List);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CNewXueLi, CDialog)
	//{{AFX_MSG_MAP(CNewXueLi)
	ON_BN_CLICKED(ID_ADD, OnAdd)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CNewXueLi message handlers

void CNewXueLi::InsertColumn()
{
		LVCOLUMN column;
	column.mask=LVCF_FMT|LVCF_WIDTH|LVCF_TEXT|LVCF_SUBITEM;
	column.fmt=LVCFMT_LEFT;
	column.cx=80;
	column.iSubItem=0;
	column.pszText="学历";
	m_List.InsertColumn(0,&column);
	
	column.iSubItem=1;
	column.pszText="自何年月日";
	column.cx=120;
	m_List.InsertColumn(1,&column);
	
	column.iSubItem=2;
	column.pszText="到何年月日";
	column.cx=120;
	m_List.InsertColumn(2,&column);

	column.iSubItem=3;
	column.pszText="所在学校";
	column.cx=120;
	m_List.InsertColumn(3,&column);

	column.iSubItem=4;
	column.pszText="英语等级";
	column.cx=100;
	m_List.InsertColumn(4,&column);

}

void CNewXueLi::AddItemToList()
{
	LVITEM item;
	item.mask=LVIF_TEXT;
	item.iItem=0;
	item.iSubItem=0;
	char x[50];					//加入标题(CString->Char)
	strcpy(x,infor[0]);
	item.pszText=x;
	m_List.InsertItem(&item);
	for(int i=1;i<5;i++)
		m_List.SetItemText(0,i,infor[i]);
	m_List.SetExtendedStyle(LVS_EX_FULLROWSELECT);

}

void CNewXueLi::SelectSQL()
{
	CRecordset rs(&db);
		CString sql;
    	sql.Format("Select * From xueli Where eID= %s",m_id);

		m_List.DeleteAllItems();
		
		rs.Open(CRecordset::forwardOnly,sql);

		if (rs.IsEOF())
		{
			MessageBox("查找结果不存在，请验证后从试");
		
		}
	
		while(!rs.IsEOF()) // 非空则获取员工信息
		{
			
			rs.GetFieldValue("xueli",infor[0]); 
			rs.GetFieldValue("learning",infor[1]); 
			rs.GetFieldValue("graduate",infor[2]); 
			rs.GetFieldValue("schoolandzhuanye",infor[3]);
			rs.GetFieldValue("english",infor[4]); 
		 	AddItemToList();
			rs.MoveNext();
		}
		rs.Close();
		UpdateData(false);

}

void CNewXueLi::OnAdd() 
{
	// TODO: Add your control notification handler code here
	CAddXueli dlg;
	dlg.m_id=m_id;
    dlg.DoModal();
	SelectSQL();
}

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