deluser.cpp

来自「本系统所完成功能如下： &#61548 即时消息：用户之间发送即时消息。 」· C++ 代码 · 共 80 行

// DelUser.cpp : implementation file
//

#include "stdafx.h"
#include "IMS.h"
#include "DelUser.h"

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

/////////////////////////////////////////////////////////////////////////////
// DelUser dialog


DelUser::DelUser(CWnd* pParent /*=NULL*/)
	: CDialog(DelUser::IDD, pParent)
{
	//{{AFX_DATA_INIT(DelUser)
	m_nDeluid = 0;
	//}}AFX_DATA_INIT
}


void DelUser::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(DelUser)
	DDX_Text(pDX, IDC_EDIT1, m_nDeluid);
	//}}AFX_DATA_MAP
}


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

/////////////////////////////////////////////////////////////////////////////
// DelUser message handlers

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

	CoInitialize(NULL);
	_ConnectionPtr pConn(__uuidof(Connection));
	_RecordsetPtr pRst(__uuidof(Recordset));
	//_CommandPtr pCmd(__uuidof(Command));

	pConn->ConnectionString="Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;User ID=TL;Initial Catalog=IM;Data Source=TLFZN";
	pConn->Open("","","",adConnectUnspecified);

	CString str;
	_variant_t vstr; 
	str.Format("select * from UserTbl where UserID=%d",m_nDeluid);
	pRst=pConn->Execute((_bstr_t)str,NULL,adCmdText);
	if(pRst->rsEOF)
		MessageBox("您所输用户不存在！");
	else
	{
		str.Format("delete from UserTbl where UserID=%d",m_nDeluid);
		pRst=pConn->Execute((_bstr_t)str,NULL,adCmdText);	
			
		str.Format("delete from FriendTbl where UID2=%d",m_nDeluid);
		pRst=pConn->Execute((_bstr_t)str,NULL,adCmdText);
		str.Format("delete from FriendTbl where UID1=%d",m_nDeluid);
		pRst=pConn->Execute((_bstr_t)str,NULL,adCmdText);
	}
	pConn->Close();
	//pCmd.Release();
	pRst.Release();
	pConn.Release();
	CoUninitialize();
	CDialog::OnOK();
}