querydlg.cpp

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

// QueryDlg.cpp : implementation file
//

#include "stdafx.h"
#include "IMS.h"
#include "QueryDlg.h"

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

/////////////////////////////////////////////////////////////////////////////
// QueryDlg dialog


QueryDlg::QueryDlg(CWnd* pParent /*=NULL*/)
	: CDialog(QueryDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(QueryDlg)
	m_IsVIP = FALSE;
	m_nuid = 0;
	//}}AFX_DATA_INIT
}


void QueryDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(QueryDlg)
	DDX_Check(pDX, IDC_CHECK, m_IsVIP);
	DDX_Text(pDX, IDC_EDIT1, m_nuid);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(QueryDlg, CDialog)
	//{{AFX_MSG_MAP(QueryDlg)
	ON_BN_CLICKED(IDC_BTN_QUERY, OnBtnQuery)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// QueryDlg message handlers

void QueryDlg::OnBtnQuery() 
{
	// TODO: Add your control notification handler code 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; 
	BOOL VIP;
	str.Format("select * from UserTbl where UserID='%d'",m_nuid);
	pRst=pConn->Execute((_bstr_t)str,NULL,adCmdText);
	if(pRst->rsEOF)
		MessageBox("您所输用户不存在！");
	else
	{
		vstr= pRst->GetCollect("VIP");
		VIP= vstr.iVal;
		if(m_IsVIP)
		{
			str.Format("update UserTbl SET VIP=1 where UserID='%d'",m_nuid);
			pRst=pConn->Execute((_bstr_t)str,NULL,adCmdText);	
		}
		else
		{
			pRst->Close();
			if(VIP)
				MessageBox("您所输用户是VIP！");
			else
				MessageBox("您所输用户不是会员！");
		}
	}
	pConn->Close();
	//pCmd.Release();
	pRst.Release();
	pConn.Release();
	CoUninitialize();
}