showallpart.cpp

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

// ShowAllPart.cpp : implementation file
//

#include "stdafx.h"
#include "EmpMan.h"
#include "ShowAllPart.h"

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

/////////////////////////////////////////////////////////////////////////////
// CShowAllPart dialog


CShowAllPart::CShowAllPart(CWnd* pParent /*=NULL*/)
	: CDialog(CShowAllPart::IDD, pParent)
{
	//{{AFX_DATA_INIT(CShowAllPart)
	m_workdate = _T("");
	m_gang = _T("");
	m_hight = _T("");
	m_id = _T("");
	m_idcard = _T("");
	m_lover = _T("");
	m_lovsp = _T("");
	m_marry = _T("");
	m_name = _T("");
	m_part = _T("");
	m_phone = _T("");
	m_position = _T("");
	m_sex = _T("");
	m_age = _T("");
	m_address = _T("");
	m_email = _T("");
	m_mail = _T("");
	//}}AFX_DATA_INIT
}


void CShowAllPart::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CShowAllPart)
	DDX_Control(pDX, IDC_LIST1, m_List);
	DDX_Text(pDX, ID_EDIT_WORDDATE, m_workdate);
	DDX_Text(pDX, IDC_EDIT_GANG, m_gang);
	DDX_Text(pDX, IDC_EDIT_HIGHT, m_hight);
	DDX_Text(pDX, IDC_EDIT_ID, m_id);
	DDX_Text(pDX, IDC_EDIT_IDCARD, m_idcard);
	DDX_Text(pDX, IDC_EDIT_LOVER, m_lover);
	DDX_Text(pDX, IDC_EDIT_LOVSP, m_lovsp);
	DDX_Text(pDX, IDC_EDIT_MARR, m_marry);
	DDX_Text(pDX, IDC_EDIT_NAME, m_name);
	DDX_Text(pDX, IDC_EDIT_PART, m_part);
	DDX_Text(pDX, IDC_EDIT_PHONE, m_phone);
	DDX_Text(pDX, IDC_EDIT_POSITION, m_position);
	DDX_Text(pDX, IDC_EDIT_SEX, m_sex);
	DDX_Text(pDX, IDC_EDIT1_AGE, m_age);
	DDX_Text(pDX, IDC_EDIT_ADDRESS, m_address);
	DDX_Text(pDX, IDC_EDIT_EMAIL, m_email);
	DDX_Text(pDX, IDC_EDIT_MAIL, m_mail);
	//}}AFX_DATA_MAP
}


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

/////////////////////////////////////////////////////////////////////////////
// CShowAllPart message handlers

void CShowAllPart::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);

}

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

void CShowAllPart::SelectSQL()
{
		CRecordset rs(&db);

		UpdateData(true);

		CString sql;
		sql.Format("Select employee.eID,employee.name,employee.IDcard,employee.sex,employee.phone,employee.position,employee.workdata, employee.age,bumen.bumenname,gangwei.gangweiname,employee.highestxueli,employee.marriage From employee,gangwei,bumen Where employee.gangweiID=gangwei.gangweiID and employee.bumenID=bumen.bumenID and employee.eID =%s",m_id);
	
		rs.Open(CRecordset::forwardOnly,sql);

		if (rs.IsEOF())
		{
		MessageBox("查找结果不存在，请验证后从试");
				
		}
	
		if(!rs.IsEOF()) // 非空则获取员工信息
		{
		
		rs.GetFieldValue("eID",m_id); 
		rs.GetFieldValue("name",m_name); 
		rs.GetFieldValue("IDcard",m_idcard); 
		rs.GetFieldValue("sex",m_sex);
		rs.GetFieldValue("phone",m_phone); 
		rs.GetFieldValue("position",m_position); 
		rs.GetFieldValue("workdata",m_workdate);
		rs.GetFieldValue("age",m_age); 
		rs.GetFieldValue("bumenname",m_part);
		rs.GetFieldValue("gangweiname",m_gang);
		rs.GetFieldValue("highestxueli",m_hight);
		rs.GetFieldValue("marriage",m_marry);
		
		}
		rs.Close();
		if(m_marry.GetAt(0)=='Y')
		{
			CRecordset rs(&db);
			CString sql;
			sql.Format("select *  From ewh Where eID= %s",m_id);
	
         	rs.Open(CRecordset::forwardOnly,sql);
         	if (rs.IsEOF())
			{
	        	MessageBox("查找结果不存在，请验证后从试");
		
			}
	
        	if(!rs.IsEOF()) // 非空则获取员工信息
			{
		
	    	rs.GetFieldValue("ewhname",m_lover); 
	    	rs.GetFieldValue("workplace",m_lovsp); 
			}
      	rs.Close();


		

		}

		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();
		sql.Format("Select * from address1 where phone =%s",m_phone);
		rs.Open(CRecordset::forwardOnly,sql);
        if (rs.IsEOF())
		{
		MessageBox("查找结果不存在，请验证后从试");
				
		}
	
		if(!rs.IsEOF()) // 非空则获取员工信息
		{
		
		rs.GetFieldValue("address",m_address); 
		rs.GetFieldValue("email",m_email); 
		rs.GetFieldValue("youbian",m_mail); 
		}
		rs.Close();
		UpdateData(false);
}

void CShowAllPart::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);

}