adduserdlg.cpp

< Visual C+++SQL Server数据库开发与实例>>一书中的实例核心源程序提供了几个案例的编程源代码。

// AddUserDlg.cpp : implementation file
//

#include "stdafx.h"
#include "LibDBS.h"
#include "AddUserDlg.h"
#include "UserSet.h"

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

/////////////////////////////////////////////////////////////////////////////
// CAddUserDlg dialog


CAddUserDlg::CAddUserDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CAddUserDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CAddUserDlg)
	m_strUser = _T("");
	m_strPassword = _T("");
	//}}AFX_DATA_INIT
}


void CAddUserDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CAddUserDlg)
	DDX_Text(pDX, IDC_EDIT_USER, m_strUser);
	DDX_Text(pDX, IDC_EDIT_Password, m_strPassword);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CAddUserDlg, CDialog)
	//{{AFX_MSG_MAP(CAddUserDlg)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CAddUserDlg message handlers

void CAddUserDlg::OnOK() 
{
	// TODO: Add extra validation here
	
//	CDialog::OnOK();
	this->UpdateData(TRUE);
	if(m_strUser.Compare("")==0||m_strPassword.Compare("")==0)
	{
		MessageBox("请正确填写所需数据","增加用户");
		return;
	}

	if(!m_database.IsOpen())
	{
		if(!m_database.Open(_T("Library")))
		{
			MessageBox("数据库打开出错!","图书信息！");
			OnOK();
			return ;
		}
	}
	CString strSQL;
	long num;
	CUserSet *m_pset=new CUserSet(&m_database);

	strSQL.Format("select * from Admin_Info");
	m_pset->Open(AFX_DB_USE_DEFAULT_TYPE,strSQL);
	num = m_pset->GetRecordCount();

	m_pset->AddNew();
	m_pset->SetFieldNull(&(m_pset->m_User_Name),FALSE);
	m_pset->m_User_Name=m_strUser;

	m_pset->SetFieldNull(&(m_pset->m_Password),FALSE);
	m_pset->m_Password=m_strPassword;

	m_pset->SetFieldNull(&(m_pset->m_WorkID),FALSE);
	m_pset->m_WorkID=num+2;

	m_pset->Update();
	m_pset->Requery();
	
	m_pset->Close();
	m_database.Close();
	MessageBox("添加帐号成功!","添加帐号");
	
}