markdlg.cpp

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

// MarkDlg.cpp : implementation file
//

#include "stdafx.h"
#include "EmpMan.h"
#include "MarkDlg.h"

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

/////////////////////////////////////////////////////////////////////////////
// CMarkDlg dialog


CMarkDlg::CMarkDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CMarkDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CMarkDlg)
	m_hn = _T("");
	m_mn = _T("");
	m_pn = _T("");
	m_tn = _T("");
	m_wn = _T("");
	m_part = _T("");
	//}}AFX_DATA_INIT
}


void CMarkDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CMarkDlg)
	DDX_Control(pDX, IDC_COMBOB, m_C_part);
	DDX_Text(pDX, IDC_HN, m_hn);
	DDX_Text(pDX, IDC_MN, m_mn);
	DDX_Text(pDX, IDC_PN, m_pn);
	DDX_Text(pDX, IDC_TN, m_tn);
	DDX_Text(pDX, IDC_WN, m_wn);
	DDX_CBString(pDX, IDC_COMBOB, m_part);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CMarkDlg, CDialog)
	//{{AFX_MSG_MAP(CMarkDlg)
	ON_CBN_SELENDCANCEL(IDC_COMBOB, OnSelendcancelCombob)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CMarkDlg message handlers

void CMarkDlg::AddPart()
{
	  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();

}

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

void CMarkDlg::SQL()
{
    CRecordset rs(&db);


	int all,man,have;
	all=man=have=0;
	CString sql;
	sql="Select * From employee";
	rs.Open(CRecordset::forwardOnly,sql);

	if (rs.IsEOF())
	{
		MessageBox("查找结果不存在，请验证后重试");
		CDialog::OnOK();
	}
	
	while(!rs.IsEOF()) // 非空则获取员工信息
	{
		
		CString sex,marriage;
		rs.GetFieldValue("sex",sex);
	    rs.GetFieldValue("marriage",marriage);
		all++;
		if(sex=="男")
			man++;
		if(marriage =="Yes")
		    have++;
		rs.MoveNext();
	}
	rs.Close();
	m_mn.Format("%d",man);
	m_tn.Format("%d",all);
	m_wn.Format("%d",all-man);
	m_hn.Format("%d",have);
    UpdateData(false);

}

 

void CMarkDlg::SQLPart()
{
	CRecordset rs(&db);
	UpdateData(true);
	CString sql,bumenID;
	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();
		
	int num=0;
    sql.Format("Select * From employee where bumenID=%s",bumenID);
	rs.Open(CRecordset::forwardOnly,sql);

	if (rs.IsEOF())
	{
		
	 num=0;
	}
	
	while(!rs.IsEOF()) // 非空则获取员工信息
	{
		num++;
		rs.MoveNext();
	}
	rs.Close();
	m_pn.Format("%d",num);
	UpdateData(false);



}

void CMarkDlg::OnSelendcancelCombob() 
{
	// TODO: Add your control notification handler code here
	SQLPart();
	CDialog::SetFocus();
}