addperson.cpp

管理类软件,入门咯.公司管理系统MFC开发设计,轻松学会

// ADDPERSON.cpp : implementation file
//

#include "stdafx.h"
#include "B05050727.h"
#include "ADDPERSON.h"

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

/////////////////////////////////////////////////////////////////////////////
// CADDPERSON dialog


CADDPERSON::CADDPERSON(CWnd* pParent /*=NULL*/)
	: CDialog(CADDPERSON::IDD, pParent)
{
	//{{AFX_DATA_INIT(CADDPERSON)
		// NOTE: the ClassWizard will add member initialization here
	//}}AFX_DATA_INIT
}


void CADDPERSON::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CADDPERSON)
		// NOTE: the ClassWizard will add DDX and DDV calls here
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CADDPERSON, CDialog)
	//{{AFX_MSG_MAP(CADDPERSON)
	ON_BN_CLICKED(IDOK, OnADD)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CADDPERSON message handlers

void CADDPERSON::OnADD() 
{
	// TODO: Add your control notification handler code here
	CString str1,str2,str3,str4,str5,str6;
	GetDlgItemText(IDC_1,str1);
	GetDlgItemText(IDC_2,str2);
	GetDlgItemText(IDC_3,str3);
	GetDlgItemText(IDC_4,str4);
	GetDlgItemText(IDC_5,str5);
	GetDlgItemText(IDC_6,str6);
	
	CoInitialize(NULL);
	_ConnectionPtr pconnect(__uuidof(Connection));
	_CommandPtr comd(__uuidof(Command));
	pconnect->ConnectionString="Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=人事";
	pconnect->Open("","","",NULL);
	comd->put_ActiveConnection(_variant_t((IDispatch *)pconnect));
	CString cmd="INSERT INTO 职工 values('";
	cmd+=str1;   cmd+="','";    cmd+=str2;    cmd+="','";   cmd+=str3;cmd+="','";
	cmd+=str4;   cmd+="','";    cmd+=str5;    cmd+="','";   cmd+=str6;cmd+="')";
	comd->CommandText=_bstr_t(cmd);
	comd->Execute(NULL,NULL,adCmdText);
	
	pconnect->Close();
	comd.Release();
	pconnect.Release();
	CoUninitialize();
	AfxMessageBox("添加成功");
	CDialog::OnOK();
}