changedalog.cpp

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

// ChangeDalog.cpp : implementation file
//

#include "stdafx.h"
#include "EmpMan.h"
#include "ChangeDalog.h"
#include "MarriDialog.h"
#include "NewXueLi.h"

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

/////////////////////////////////////////////////////////////////////////////
// CChangeDalog dialog


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


void CChangeDalog::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CChangeDalog)
	DDX_Control(pDX, IDC_COMBOP, m_C_part);
	DDX_Control(pDX, IDC_COMBOM, m_C_merr);
	DDX_Control(pDX, IDC_COMBOG, m_C_gangwei);
	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_NAME, m_name);
	DDX_Text(pDX, IDC_EDIT_PHONE, m_phone);
	DDX_Text(pDX, IDC_EDIT_POSITION, m_position);
	DDX_Text(pDX, IDC_EDIT1_AGE, m_age);
	DDX_CBString(pDX, IDC_COMBOG, m_gangwei);
	DDX_CBString(pDX, IDC_COMBOM, m_marriage);
	DDX_CBString(pDX, IDC_COMBOP, m_part);
	DDX_Text(pDX, ID_EDIT_WORDDATE, m_workdata);
	DDX_Text(pDX, IDC_EDIT_SEX, m_sex);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CChangeDalog, CDialog)
	//{{AFX_MSG_MAP(CChangeDalog)
	ON_EN_CHANGE(IDC_EDIT_PHONE, OnChangeEditPhone)
	ON_CBN_SELCHANGE(IDC_COMBOM, OnSelchangeCombom)
	ON_BN_CLICKED(IDC_BUTTON1, OnButton1)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CChangeDalog message handlers

void CChangeDalog::OnChangeEditPhone() 
{
	// TODO: If this is a RICHEDIT control, the control will not
	// send this notification unless you override the CDialog::OnInitDialog()
	// function and call CRichEditCtrl().SetEventMask()
	// with the ENM_CHANGE flag ORed into the mask.

	// TODO: Add your control notification handler code here
	CPhotoSetDialog dlg;
	dlg.m_photonum=m_phone;
	dlg.DoModal();
	m_phone=dlg.m_photonum;
	UpdateData(false);
}

 

 

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

void CChangeDalog::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_workdata);
		rs.GetFieldValue("age",m_age); 
		rs.GetFieldValue("bumenname",m_part);
		rs.GetFieldValue("gangweiname",m_gangwei);
		rs.GetFieldValue("highestxueli",m_hight);
		rs.GetFieldValue("marriage",m_marriage);
		
		
		
	}
	rs.Close();
	UpdateData(false);
   
}

 

 

void CChangeDalog::OnSelchangeCombom() 
{
	// TODO: Add your control notification handler code here
	UpdateData(true);
	
	
	CMarriDialog dlg;
	dlg.id=m_id;
	dlg.DoModal();
	
	
}

 

void CChangeDalog::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_marriage.GetAt(0)=='N')
	{
		 sql.Format("Delete from ewh where eID =%s",m_id);
		 db.ExecuteSQL(sql);

	}
    sql.Format("Update employee Set name='%s',IDcard=%s,sex='%s',phone=%s,position='%s',workdata=%s,age=%s,bumenID=%s,gangweiID=%s,highestxueli='%s',marriage='%s' where eId=%s",m_name,m_idcard,m_sex,m_phone,m_position,m_workdata,m_age,bumenID,gangweiID,m_hight,m_marriage,m_id);
	db.ExecuteSQL(sql);
	CDialog::OnOK();
}

void CChangeDalog::OnButton1() 
{
	// TODO: Add your control notification handler code here
	CNewXueLi dlg;
	dlg.m_id=m_id;
	dlg.DoModal();

}

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


}