fixdlg.cpp

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

// FixDlg.cpp : implementation file
//

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

/////////////////////////////////////////////////////////////////////////////
// CFixDlg dialog


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


void CFixDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CFixDlg)
	DDX_Control(pDX, IDC_COMBOP, m_C_part);
	DDX_Control(pDX, IDC_COMBOM, m_C_marri);
	DDX_Control(pDX, IDC_COMBOG, m_C_gangwei);
	DDX_Text(pDX, ID_EDIT_WORDDATE, m_worddate);
	DDX_CBString(pDX, IDC_COMBOG, m_gangwei);
	DDX_CBString(pDX, IDC_COMBOM, m_marri);
	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_EDIT_SEX, m_sex);
	DDX_Text(pDX, IDC_EDIT1_AGE, m_age);
	DDX_CBString(pDX, IDC_COMBOP, m_part);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CFixDlg, CDialog)
	//{{AFX_MSG_MAP(CFixDlg)
	ON_BN_CLICKED(IDC_FINDADC, OnFindadc)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CFixDlg message handlers

void CFixDlg::OnOK() 
{
	// TODO: Add extra validation here
	
	CDialog::OnOK();
	CShowDialog dlg;
	dlg.m_status=0;
	dlg.sql=SQL();;
	dlg.DoModal();
	
}

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

}

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

CString CFixDlg::SQL()
{
	UpdateData(true);
	
	CString sql,Select;
	Select="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 ";
	CString out[12];
	if(m_id.GetLength()!=0)
	{
		out[0].Format("and employee.eID=%s",m_id);
		
	}
	if(m_name.GetLength()!=0)
	{
		out[1].Format("and employee.name='%s'",m_name);
		
	}
	if(m_idcard.GetLength()!=0)
	{
		out[2].Format("and employee.IDcard=%s",m_idcard);
		
	}
	if(m_sex.GetLength()!=0)
	{
		out[3].Format("and employee.sex='%s'",m_sex);
		
	}
	if(m_phone.GetLength()!=0)
	{
		out[4].Format("and employee.phone=%s",m_phone);
		
	}
	if(m_position.GetLength()!=0)
	{
		out[5].Format("and position='%s'",m_position);
		
	}
	if(m_worddate.GetLength()!=0)
	{
		out[6].Format("and employee.workdata=%s",m_worddate);
		
	}
	if(m_age.GetLength()!=0)
	{
		out[7].Format("and employee.age=%s",m_age);
		
	}
	if(m_part.GetLength()!=0)
	{
		out[8].Format("and bumen.bumenname='%s'",m_part);
		
	}
	
	if(m_gangwei.GetLength()!=0)
	{
		out[9].Format("and gangwei.gangweiname='%s'",m_gangwei);
		
	}
	if(m_hight.GetLength()!=0)
	{
		out[10].Format("and employee.highestxueli='%s'",m_hight);
		
	}
	if(m_marri.GetLength()!=0)
	{
		out[11].Format("and employee.marriage='%s'",m_marri);
		
	}
	sql=Select+out[0]+out[1]+out[2]+out[3]+out[4]+out[5]+out[6]+out[7]+out[8]+out[9]
		+out[10]+out[11];
	return sql;

	

         

}

void CFixDlg::OnFindadc() 
{
	// TODO: Add your control notification handler code here
	CDialog::OnOK();
	CShowDialog dlg;
	dlg.m_status=1;
	dlg.sql=SQL();;
	dlg.DoModal();
}