addgongzhi.cpp

员工管理系统,基本的数据库操作,数据库类的设计,基本的查询等

// Addgongzhi.cpp : implementation file
//

#include "stdafx.h"
#include "数据库.h"
#include "Addgongzhi.h"
#include "ADOConn.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

/////////////////////////////////////////////////////////////////////////////
// CAddgongzhi dialog


CAddgongzhi::CAddgongzhi(CWnd* pParent /*=NULL*/)
	: CDialog(CAddgongzhi::IDD, pParent)
{
	//{{AFX_DATA_INIT(CAddgongzhi)
	m_name = _T("");
	m_month = 0;
	m_jiben = 0;
	m_jiang = 0;
	m_fa = 0;
	//}}AFX_DATA_INIT
}


void CAddgongzhi::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CAddgongzhi)
	DDX_Text(pDX, IDC_EDIT1, m_name);
	DDX_Text(pDX, IDC_EDIT2, m_month);
	DDX_Text(pDX, IDC_EDIT3, m_jiben);
	DDX_Text(pDX, IDC_EDIT7, m_jiang);
	DDX_Text(pDX, IDC_EDIT4, m_fa);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CAddgongzhi, CDialog)
	//{{AFX_MSG_MAP(CAddgongzhi)
	ON_BN_CLICKED(IDC_BUTTON2, OnButton2)
	ON_BN_CLICKED(IDC_BUTTON3, OnButton3)
	ON_BN_CLICKED(IDC_BUTTON4, OnButton4)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CAddgongzhi message handlers

void CAddgongzhi::OnButton2() 
{
	// TODO: Add your control notification handler code here
	ADOConn m_Adoconn;
	m_Adoconn.OnInitADOConn();
	

    CString sql;
	UpdateData(true);
	    sql.Format("insert into 工资表(姓名,月份,基本工资,奖金,罚金) values (\'%s'\, \
			%d, %d, %d,%d)", m_name,m_month,m_jiben,m_jiang,m_fa);
		_bstr_t vsql;
	vsql=(_bstr_t)sql;
	
	m_Adoconn.ExecuteSQL(vsql);
	m_Adoconn.ExitConnect();
	
		
	CDialog::OnOK();
}

void CAddgongzhi::OnButton3() 
{
	// TODO: Add your control notification handler code here
	CDialog::OnCancel();
}

void CAddgongzhi::OnButton4() 
{
	// TODO: Add your control notification handler code here
	CDialog::OnCancel();
}