updateuserdlg.cpp

该源码的前台用C++编写

// UpdateUserDlg.cpp : implementation file
//

#include "stdafx.h"
#include "MenuManage.h"
#include "UpdateUserDlg.h"

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

extern CMenuManageApp theApp;
/////////////////////////////////////////////////////////////////////////////
// CUpdateUserDlg dialog


CUpdateUserDlg::CUpdateUserDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CUpdateUserDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CUpdateUserDlg)
	m_nUpdateLevel = -1;
	m_nUpdateNumber = 0;
	m_strUpdateName = _T("");
	//}}AFX_DATA_INIT
}


void CUpdateUserDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CUpdateUserDlg)
	DDX_Radio(pDX, IDC_RADIO_EMPLOYEE, m_nUpdateLevel);
	DDX_Text(pDX, IDC_UPDATE_NUMBER, m_nUpdateNumber);
	DDX_Text(pDX, IDC_UPDATE_NAME, m_strUpdateName);
	//}}AFX_DATA_MAP
}


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

/////////////////////////////////////////////////////////////////////////////
// CUpdateUserDlg message handlers

BOOL CUpdateUserDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	// TODO: Add extra initialization here
	
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CUpdateUserDlg::OnOK() 
{
	// TODO: Add extra validation here
	UpdateData(TRUE);

	CString str;
	str.Format("%d",m_nUpdateNumber);

	CString sql;
	sql =  "SELECT * FROM UserInfo WHERE UserNum = "+str+" ";
	m_pRecordset.CreateInstance("ADODB.Recordset");
    m_pRecordset->Open((_variant_t)sql,_variant_t((IDispatch *)theApp.m_pConnection,true),adOpenDynamic,adLockPessimistic,adCmdText);
	
	str.Format("%d",m_nUpdateLevel);
	m_pRecordset->PutCollect("UserLevel",_variant_t(str));

	m_pRecordset->Update();
	m_pRecordset->Close();
	
	CDialog::OnOK();
}