logondlg.cpp

一个POS管理系统VC++6.0 + SQL2

// LogonDlg.cpp : implementation file
//

#include "stdafx.h"
#include "MyPos.h"
#include "LogonDlg.h"

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

/////////////////////////////////////////////////////////////////////////////
// CLogonDlg dialog
extern CMyPosApp theApp;


CLogonDlg::CLogonDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CLogonDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CLogonDlg)
	m_pwd = _T("");
	m_logid = _T("");
	//}}AFX_DATA_INIT
}


void CLogonDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CLogonDlg)
	DDX_Control(pDX, IDC_COMBO_LOGON, m_oLogon);
	DDX_Text(pDX, IDC_EDIT_LOGPWD, m_pwd);
	DDX_CBString(pDX, IDC_COMBO_LOGON, m_logid);
	//}}AFX_DATA_MAP
}


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

/////////////////////////////////////////////////////////////////////////////
// CLogonDlg message handlers

void CLogonDlg::OnOK() 
{  
	// TODO: Add extra validation here
	UpdateData();
	if(m_logid.IsEmpty()||m_pwd.IsEmpty())
	{	
		AfxMessageBox("请输入用户名和密码！");	
		return;
	}
	else
		//if user enter name and password.
	{
		//成生sql语句
		CString sql="SELECT * FROM USERS where LOGINID='"+m_logid+"' and PSD='"+m_pwd+"'";
		try
		{
			m_pRecordset.CreateInstance("ADODB.Recordset");
			m_pRecordset->Open((_variant_t)sql,_variant_t((IDispatch*)theApp.m_pConnection,true),adOpenStatic,adLockOptimistic,adCmdText);
			if(m_pRecordset->adoEOF)

						AfxMessageBox("用户名或密码错误！");

			else
			{
//				theApp.name=m_logid;
				theApp.name=(LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("NAME");
				theApp.pwd=m_pwd;
				CDialog::OnOK();
				return;
			}
			m_pRecordset->Close();
		}
		catch(_com_error e)///捕捉异常
		{
			CString temp;
			temp.Format("读取用户名和密码错误:%s",e.ErrorMessage());
			AfxMessageBox(temp);
			return;
		}
	}
}

void CLogonDlg::OnCancel() 
{
	// TODO: Add extra cleanup here
	CDialog::OnCancel();
}

BOOL CLogonDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();

  	//读出数据库中的用户名，显示在控件中。
	int i,recordcount;
	CString sql="select LOGINID from USERS ";

	try
	{
		m_pRecordset.CreateInstance("ADODB.Recordset");
		m_pRecordset->Open((_variant_t)sql,_variant_t((IDispatch*)theApp.m_pConnection,true),adOpenStatic,adLockOptimistic,adCmdText);
		recordcount=m_pRecordset->GetRecordCount();//Get records total.	
		if(!m_pRecordset->adoEOF)
		{
			for(i=0;i<recordcount;i++)
			{
			m_oLogon.AddString((LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("LOGINID"));
			sql=(LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("LOGINID");
			m_pRecordset->MoveNext();
			}
		}

		m_pRecordset->Close();
	}
	catch(_com_error e)///捕捉异常
	{
		CString temp;
		temp.Format("读取用户名错误:%s",e.ErrorMessage());
		AfxMessageBox(temp);
		return false;
	}	
	return TRUE;  // return TRUE unless you set the focus to a control
}