【VC开源代码栏目提醒】:网学会员,鉴于大家对VC开源代码十分关注,论文会员在此为大家搜集整理了“LogonDlg.cpp”一文,供大家参考学习!
// 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
}
上一篇:
LogOffDlg.cpp
下一篇:
经济民主一种关于劳动的政治经济学