addguangli.cpp

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

// AddGuangli.cpp : implementation file
//

#include "stdafx.h"
#include "EmpMan.h"
#include "AddGuangli.h"

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

/////////////////////////////////////////////////////////////////////////////
// CAddGuangli dialog


CAddGuangli::CAddGuangli(CWnd* pParent /*=NULL*/)
	: CDialog(CAddGuangli::IDD, pParent)
{
	//{{AFX_DATA_INIT(CAddGuangli)
	m_gid = _T("");
	m_id = _T("");
	m_name = _T("");
	//}}AFX_DATA_INIT
}


void CAddGuangli::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CAddGuangli)
	DDX_Text(pDX, IDC_GID, m_gid);
	DDX_Text(pDX, IDC_ID, m_id);
	DDX_Text(pDX, IDC_NAME, m_name);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CAddGuangli, CDialog)
	//{{AFX_MSG_MAP(CAddGuangli)
	ON_BN_CLICKED(IDC_DELETE, OnDelete)
	ON_BN_CLICKED(ID_CHANGE, OnChange)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CAddGuangli message handlers

void CAddGuangli::OnOK() 
{
	// TODO: Add extra validation here
	UpdateData(true);
	CString sql;
	sql.Format("insert into bumen Values (%s,'%s',%s)",m_id,m_name,m_gid);
	db.ExecuteSQL(sql);
	CDialog::OnOK();
}

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

void CAddGuangli::SetLook()
{
	CWnd *pWnd;

	if(m_badd)
	{
		pWnd=GetDlgItem(IDC_DELETE);
	   //pWnd->EnableWindow(b);
	    pWnd->ShowWindow(0);
	    pWnd=NULL;
		pWnd=GetDlgItem(ID_CHANGE);
	   //pWnd->EnableWindow(b);
	    pWnd->ShowWindow(0);
	    pWnd=NULL;

	}
	else
	{
     pWnd=GetDlgItem(IDC_ID);
	 pWnd->EnableWindow(0);
	 pWnd=NULL;
	 pWnd=GetDlgItem(IDOK);
	 pWnd->EnableWindow(0);
		 CRecordset rs(&db);
	     CString sql;
		sql.Format("Select * From bumen where bumenID =%s",m_id) ;
	
		rs.Open(CRecordset::forwardOnly,sql);

		if (rs.IsEOF())
		{
		MessageBox("没有任何部门,请设置部门");
		
		}
	
	 if(!rs.IsEOF()) // 非空则获取员工信息
	 {
		CString name;
		rs.GetFieldValue("bumenID",m_id); 
		rs.GetFieldValue("bumenname",m_name);
		rs.GetFieldValue("eID",m_gid);
	}
	rs.Close();	
	  
	}
	UpdateData(false);

}

 

void CAddGuangli::OnDelete() 
{
	// TODO: Add your control notification handler code here
	CString sql;
	sql.Format("delete from bumen where bumenID=%s",m_id);
	
	CString ask;
	ask.Format("是否真的要删除证件号为%s的记录",m_id);
	int index=MessageBox(ask,"注销",MB_ICONQUESTION|MB_YESNO);	
	if (index==IDYES) 
	{
		db.ExecuteSQL(sql);
		
		
	}
    CDialog::OnOK();
}

void CAddGuangli::OnChange() 
{
	// TODO: Add your control notification handler code here
	UpdateData(true);
	CString sql;
	sql.Format("update bumen Set bumenname='%s',eID=%s where bumenID=%s" ,m_name,m_gid,m_id);
	db.ExecuteSQL(sql);
	CDialog::OnOK();
}