projectctrl.cpp

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

// Projectctrl.cpp : implementation file
//

#include "stdafx.h"
#include "SQL.h"
#include "Projectctrl.h"
#include "Boss.h"
#include "PojectSet.h"

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

/////////////////////////////////////////////////////////////////////////////
// CProjectctrl dialog


CProjectctrl::CProjectctrl(CWnd* pParent /*=NULL*/)
	: CDialog(CProjectctrl::IDD, pParent)
{
	//{{AFX_DATA_INIT(CProjectctrl)
	m_eno = _T("");
	m_pcost = _T("");
	m_pdaty = _T("");
	m_pfinish = _T("");
	m_pkind = _T("");
	m_pname = _T("");
	m_pno = _T("");
	m_psfinish = _T("");
	m_pother = _T("");
	//}}AFX_DATA_INIT
}


void CProjectctrl::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CProjectctrl)
	//DDX_Control(pDX, IDCANCEL, m_projectctrl);
	DDX_Text(pDX, IDC_ENO, m_eno);
	DDX_Text(pDX, IDC_PCOST, m_pcost);
	DDX_Text(pDX, IDC_PDATY, m_pdaty);
	DDX_Text(pDX, IDC_PFINISH, m_pfinish);
	DDX_Text(pDX, IDC_PKIND, m_pkind);
	DDX_Text(pDX, IDC_PNAME, m_pname);
	DDX_Text(pDX, IDC_PNO, m_pno);
	DDX_Text(pDX, IDC_PSFINISH, m_psfinish);
	DDX_Text(pDX, POTHER, m_pother);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CProjectctrl, CDialog)
	//{{AFX_MSG_MAP(CProjectctrl)
	ON_BN_CLICKED(IDC_BUTTON1, OnADD)
	ON_BN_CLICKED(IDC_BUTTON2, OnDELETE)
	ON_BN_CLICKED(IDC_BUTTON3, OnCHANGE)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CProjectctrl message handlers

void CProjectctrl::OnADD() 
{
	// TODO: Add your control notification handler code here
	UpdateData(true);
    CPojectSet m_project(&m_db);
	CString str;
	str = "select * from Project";
	if (!m_project.Open(CRecordset::dynaset,str)) {
		AfxMessageBox("数据库打开失败！");
		return;
	}
	m_project.AddNew();
	m_project.m_Eno = m_eno;
	m_project.m_Pcost = m_pcost;
	m_project.m_Pdaty = m_pdaty;
	m_project.m_Pfinish = m_pfinish;
	m_project.m_Pkind = m_pkind;
	m_project.m_Pname = m_pname;
	m_project.m_Pno = m_pno;
	m_project.m_Pother = m_pother;
	m_project.m_Psfinish = m_psfinish;
	 m_project.Update();
	 AfxMessageBox("修改成功！请退出！");

}

void CProjectctrl::OnDELETE() 
{
	// TODO: Add your control notification handler code here
	UpdateData(true);
	CPojectSet m_project(&m_db);
	CString str;
	str.Format("select * from Project where Pno = '%s'",m_pno);
	if (!m_project.Open(CRecordset::dynaset,str)) {
		AfxMessageBox("数据库代开失败!");
		return;
	}
	m_project.Delete();
	m_project.Close();	
	AfxMessageBox("修改成功！请退出！");
}

void CProjectctrl::OnCHANGE() 
{
	// TODO: Add your control notification handler code here
	UpdateData(true);
	CPojectSet m_project(&m_db);
	CString str;
	str.Format("select * from Project where Pno = '%s'",m_pno);
	if (!m_project.Open(CRecordset::dynaset,str)) {
		AfxMessageBox("数据库打开失败！");
		return;
	}
	m_project.Edit();
	m_project.m_Pno = m_pno;
	if (!m_eno.IsEmpty()) {
		m_project.m_Eno = m_eno;
	}
    if (!m_pcost.IsEmpty()) {
		m_project.m_Pcost = m_pcost;
    }
    if (!m_pdaty.IsEmpty()) {
		m_project.m_Pdaty = m_pdaty;
    }
	if (!m_pfinish.IsEmpty()) {
		m_project.m_Pfinish = m_pfinish;
	}
	if (!m_pkind.IsEmpty()) {
		m_project.m_Pkind = m_pkind;
	}
    if (!m_pname.IsEmpty()) {
		m_project.m_Pname = m_pname;
    }
    if (!m_pother.IsEmpty()) {
		m_project.m_Pother = m_pother;

    }
    if (!m_psfinish.IsEmpty()) {
		m_project.m_Psfinish = m_psfinish;
    }

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