addem.cpp

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

// AddEm.cpp : implementation file
//

#include "stdafx.h"
#include "EmpMan.h"
#include "AddEm.h"
#include "AddXueli.h"

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

/////////////////////////////////////////////////////////////////////////////
// CAddEm dialog


CAddEm::CAddEm(CWnd* pParent /*=NULL*/)
	: CDialog(CAddEm::IDD, pParent)
{
	//{{AFX_DATA_INIT(CAddEm)
	m_worddate = _T("");
	m_gangwei = _T("");
	m_part = _T("");
	m_hight = _T("");
	m_id = _T("");
	m_idcard = _T("");
	m_lover = _T("");
	m_name = _T("");
	m_lovsp = _T("");
	m_phone = _T("");
	m_position = _T("");
	m_sex = _T("");
	m_age = _T("");
	//}}AFX_DATA_INIT
}


void CAddEm::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CAddEm)
	DDX_Control(pDX, IDC_COMBOP2, m_C_part);
	DDX_Control(pDX, IDC_COMBOG2, m_C_gangwei);
	DDX_Control(pDX, IDC_LIST1, m_List);
	DDX_Text(pDX, ID_EDIT_WORDDATE, m_worddate);
	DDX_CBString(pDX, IDC_COMBOG2, m_gangwei);
	DDX_CBString(pDX, IDC_COMBOP2, m_part);
	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_NAME, m_name);
	DDX_Text(pDX, IDC_EDIT_LOVSP, m_lovsp);
	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);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CAddEm, CDialog)
	//{{AFX_MSG_MAP(CAddEm)
	ON_BN_CLICKED(IDC_MEI, OnMei)
	ON_BN_CLICKED(ID_ADD, OnAdd)
	ON_BN_CLICKED(IDC_YI, OnYi)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CAddEm message handlers

void CAddEm::OnMei() 
{
	// TODO: Add your control notification handler code here
	m_agrriage="No";
	pWnd=GetDlgItem(IDC_EDIT_LOVER);
	pWnd->EnableWindow(false);
	pWnd=NULL;
	pWnd=GetDlgItem(IDC_EDIT_LOVSP);
	pWnd->EnableWindow(false);
	pWnd=NULL;
	m_lover="";
	m_lovsp="";

}

void CAddEm::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 CAddEm::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 CAddEm::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 CAddEm::OnOK() 
{
	// TODO: Add extra validation here
    CRecordset rs(&db);
	UpdateData(true);
	CString sql,bumenID,gangweiID;
	sql.Format("Select * From bumen Where bumenname = '%s'",m_part);
	rs.Open(CRecordset::forwardOnly,sql);
    
	if (rs.IsEOF())
	{
		MessageBox("查找结果不存在，请验证后从试");
		
	}
	
	if(!rs.IsEOF()) 
	{
		
		rs.GetFieldValue("bumenID",bumenID); 
	
	}
	rs.Close();
	sql.Format("Select * From gangwei Where gangweiname = '%s'",m_gangwei);
    rs.Open(CRecordset::forwardOnly,sql);
    
	if (rs.IsEOF())
	{
		MessageBox("查找结果不存在，请验证后从试");
		
	}
	
	if(!rs.IsEOF()) 
	{
		
		rs.GetFieldValue("gangweiID",gangweiID); 
	
	}
	rs.Close();
    if(m_agrriage.GetAt(0)=='Y')
	{
		 sql.Format("insert into ewh Values (%s,'%s','%s')",m_id,m_lover,m_lovsp);
		 db.ExecuteSQL(sql);

	}
    sql.Format("insert into employee Values (%s,'%s',%s,'%s',%s,'%s',%s,%s,%s,%s,'%s','%s')", m_id,m_name,m_idcard,m_sex,m_phone,m_position,m_worddate,m_age,bumenID,gangweiID,m_hight,m_agrriage);
	db.ExecuteSQL(sql);
	CDialog::OnOK();
}

BOOL CAddEm::OnInitDialog() 
{
	CDialog::OnInitDialog();
	AddBumen();
	AddGangwei();
	m_agrriage="No";
	InsertColumn();
	// 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 CAddEm::OnAdd() 
{
	// TODO: Add your control notification handler code here
	UpdateData(true);

	CAddXueli dlg;
	dlg.m_id=m_id;
	dlg.DoModal();
	pWnd=GetDlgItem(IDC_EDIT_ID);
	pWnd->EnableWindow(false);
	pWnd=NULL;
	SelectSQL();
}

void CAddEm::OnYi() 
{
	// TODO: Add your control notification handler code here
	m_agrriage ="Yes";
	pWnd=GetDlgItem(IDC_EDIT_LOVER);
	pWnd->EnableWindow(true);
	pWnd=NULL;
	pWnd=GetDlgItem(IDC_EDIT_LOVSP);
	pWnd->EnableWindow(true);
	pWnd=NULL;

}

void CAddEm::AddBumen()
{
	
     CRecordset rs(&db);
   
	 	CString sql;
	sql.Format("Select * From bumen") ;
	
	rs.Open(CRecordset::forwardOnly,sql);

	if (rs.IsEOF())
	{
		MessageBox("没有任何部门,请设置部门");
		
	}
	
	while(!rs.IsEOF()) // 非空则获取员工信息
	{
		CString name;
		rs.GetFieldValue("bumenname",name); 
		m_C_part.AddString(name);
		
		rs.MoveNext();
		
		
	}
	rs.Close();

}

void CAddEm::AddGangwei()
{
	CRecordset rs(&db);
   
	 	CString sql;
	sql.Format("Select * From gangwei") ;
	
	rs.Open(CRecordset::forwardOnly,sql);

	if (rs.IsEOF())
	{
		MessageBox("没有任何岗位,请设置岗位");
		
	}
	
	while(!rs.IsEOF()) // 
	{
		CString name;
		rs.GetFieldValue("gangweiname",name); 
		m_C_gangwei.AddString(name);
		
		rs.MoveNext();
		
		
	}
	rs.Close();
}