mainctrl.cpp

一个简单的公司员工管理系统

// Mainctrl.cpp : implementation file
//

#include "stdafx.h"
#include "SQL.h"
#include "Mainctrl.h"
#include "Boss.h"
#include "Main.h"

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

/////////////////////////////////////////////////////////////////////////////
// CMainctrl dialog


CMainctrl::CMainctrl(CWnd* pParent /*=NULL*/)
	: CDialog(CMainctrl::IDD, pParent)
{
	//{{AFX_DATA_INIT(CMainctrl)
	m_manager = _T("");
	m_name = _T("");
	m_eno = _T("");
	m_note = _T("");
	m_supper = _T("");
	//}}AFX_DATA_INIT
}


void CMainctrl::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CMainctrl)
//	DDX_Control(pDX, IDCANCEL, m_mainctrl);
	DDX_Text(pDX, IDC_EMANAGER, m_manager);
	DDX_Text(pDX, IDC_ENAME, m_name);
	DDX_Text(pDX, IDC_ENO, m_eno);
	DDX_Text(pDX, IDC_ENOTE, m_note);
	DDX_Text(pDX, IDC_ESUPPER, m_supper);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CMainctrl, CDialog)
	//{{AFX_MSG_MAP(CMainctrl)
	ON_BN_CLICKED(IDC_ADD, OnAdd)
	ON_BN_CLICKED(IDC_DELETE, OnDelete)
	ON_BN_CLICKED(IDC_CHANGE, OnChange)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CMainctrl message handlers

void CMainctrl::OnAdd() 
{
	// TODO: Add your control notification handler code here
	UpdateData(true);
	CMain m_main(&m_db);
	CString str;
	str = "select * from Main";
	if (!m_main.Open(CRecordset::dynaset,str)) {
		AfxMessageBox("");
		return;
	}
    m_main.AddNew();
	m_main.m_Pno = m_eno;
	m_main.m_Pname = m_name;
	m_main.m_Eno = m_manager;
	m_main.m_Csno = m_supper;
	m_main.m_Nno = m_note;

	m_main.Update();
	AfxMessageBox("修改成功！请退出！");
}

void CMainctrl::OnDelete() 
{
	// TODO: Add your control notification handler code here
   UpdateData(true);
	CMain m_main(&m_db);
	CString str;
	str.Format("select * from Main where Pno = '%s'",m_eno);
	if (!m_main.Open(CRecordset::dynaset,str)) {
		AfxMessageBox("");
		return;
	}
	m_main.Delete();
	m_main.Close();
    AfxMessageBox("修改成功！请退出！");
}

void CMainctrl::OnChange() 
{
	// TODO: Add your control notification handler code here
	UpdateData(true);
	CMain m_main(&m_db);
	CString str;
    str.Format("select * from Main where Pno = '%s'",m_eno);
	if (!m_main.Open(CRecordset::dynaset,str)) {
		AfxMessageBox("");
		return;
	}
	m_main.Edit();
   	m_main.m_Pno = m_eno;
	if (!m_name.IsEmpty()) {
		m_main.m_Pname = m_name;
	}
	if (!m_manager.IsEmpty()) {
		m_main.m_Eno = m_manager;
	}
    if (!m_supper.IsEmpty()) {
		m_main.m_Csno = m_supper;
    }
    if (!m_note.IsEmpty()) {	
		m_main.m_Nno = m_note;
    }	


	m_main.Update();
	AfxMessageBox("修改成功！请退出！");
}