adduser.cpp

这是本人的课程设计

// AddUser.cpp : implementation file
//

#include "stdafx.h"
#include "Electric.h"
#include "AddUser.h"

#include "afxdb.h"

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

/////////////////////////////////////////////////////////////////////////////
// CAddUser dialog


CAddUser::CAddUser(CWnd* pParent /*=NULL*/)
	: CDialog(CAddUser::IDD, pParent)
{
	//{{AFX_DATA_INIT(CAddUser)
	m_addUserID = _T("");
	m_addUserName = _T("");
	m_addUserNO = _T("");
	m_addUserPW = _T("");
	//}}AFX_DATA_INIT
}


void CAddUser::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CAddUser)
	DDX_Text(pDX, IDC_ADD_USER_ID, m_addUserID);
	DDX_Text(pDX, IDC_ADD_USER_NAME, m_addUserName);
	DDX_Text(pDX, IDC_ADD_USER_NO, m_addUserNO);
	DDX_Text(pDX, IDC_ADD_USER_PW, m_addUserPW);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CAddUser, CDialog)
	//{{AFX_MSG_MAP(CAddUser)
	ON_BN_CLICKED(IDC_ADD_USER_DETAIL, OnAddUserDetail)
//	ON_BN_CLICKED(IDC_BUTTON1, OnButton1)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CAddUser message handlers

void CAddUser::OnAddUserDetail() 
{
	// TODO: Add your control notification handler code here	 
	/*get field from database*/
	CDatabase db;
	CString userName,userPW,userNO,userID,sql;

	this->GetDlgItemText(IDC_ADD_USER_PW,userPW);
	this->GetDlgItemText(IDC_ADD_USER_ID,userID);
	this->GetDlgItemText(IDC_ADD_USER_NAME,userName);
	this->GetDlgItemText(IDC_ADD_USER_NO,userNO);
	sql.Format("insert into user(userName,phoneNo,phonePassword,userIDCard) values('%s','%s','%s','%s')",userName,userNO,userPW,userID);
	db.OpenEx("Driver={Microsoft Access Driver (*.mdb)};DBQ=ephone.mdb;");

	db.ExecuteSQL(sql);
	MessageBox("添加成功~");
	
	
	
}


void CAddUser::setContent(CString name, CString no, CString pw, CString id)
{
	this->SetDlgItemText(IDC_ADD_USER_NO,no.GetBuffer(20));
	this->SetDlgItemText(IDC_ADD_USER_NAME,name.GetBuffer(20));
	this->SetDlgItemText(IDC_ADD_USER_PW,pw.GetBuffer(20));
	this->SetDlgItemText(IDC_ADD_USER_ID,id.GetBuffer(20));
}