land.cpp

基于VC+SQL SERVER环境开发的企业商品销售系统.完整的数据库和原代码

// Land.cpp : implementation file
//

#include "stdafx.h"
#include "Sale.h"
#include "Land.h"

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

/////////////////////////////////////////////////////////////////////////////
// CLand dialog


CLand::CLand(CWnd* pParent /*=NULL*/)
	: CDialog(CLand::IDD, pParent)
{
	//{{AFX_DATA_INIT(CLand)
	m_userID = _T("");
	m_password = _T("");
	//}}AFX_DATA_INIT
}


void CLand::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CLand)
	DDX_Text(pDX, IDC_userName, m_userID);
	DDX_Text(pDX, IDC_password, m_password);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CLand, CDialog)
	//{{AFX_MSG_MAP(CLand)
	ON_BN_CLICKED(IDC_land, OnLand)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CLand message handlers

void CLand::OnLand() 
{
	UpdateData(true);
	_RecordsetPtr m_pUsersRecordset;    //用于创建一个查询记录集
	CString strSQL;
	//-----------------------------------------------
	strSQL="SELECT * FROM users where userID='";
	strSQL=strSQL+m_userID+"' and password='";
	strSQL=strSQL+m_password+"'";
		try
		{
			HRESULT hTRes;
			hTRes = m_pUsersRecordset.CreateInstance(_T("ADODB.Recordset"));
			if (SUCCEEDED(hTRes))
			{
				hTRes = m_pUsersRecordset->Open((LPTSTR)strSQL.GetBuffer(130),
					((CSaleApp*)AfxGetApp())->m_pConn.GetInterfacePtr(),
					adOpenDynamic,adLockPessimistic,adCmdText);
				if(SUCCEEDED(hTRes))
				{
					if (!(m_pUsersRecordset->adoEOF))
					{
						this->OnCancel();						
					}
					else
					{
						AfxMessageBox("密码不正确，请重新输入！");
					}
				}
			}
		}
		catch(_com_error e)
		{
			CString errormessage;
			MessageBox("创建记录集失败!","错误");
		}
		UpdateData(false);	
}