dlglogin.cpp

用户管理系统

// DlgLogin.cpp : implementation file
//

#include "stdafx.h"
#include "Kvip.h"
#include "DlgLogin.h"

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

/////////////////////////////////////////////////////////////////////////////
// CDlgLogin dialog


CDlgLogin::CDlgLogin(CWnd* pParent /*=NULL*/)
	: CDialog(CDlgLogin::IDD, pParent)
{
	//{{AFX_DATA_INIT(CDlgLogin)
	m_strPassword = _T("");
	m_strUser = _T("");
	//}}AFX_DATA_INIT
	m_nRetry = 0;
	m_pApp = NULL;
}


void CDlgLogin::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CDlgLogin)
	DDX_Text(pDX, IDC_PASSWORD, m_strPassword);
	DDX_Text(pDX, IDC_USER, m_strUser);
	//}}AFX_DATA_MAP
}


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

/////////////////////////////////////////////////////////////////////////////
// CDlgLogin message handlers

BOOL CDlgLogin::OnInitDialog() 
{
	CDialog::OnInitDialog();
#ifdef _DEBUG  //调试模式免与输入用户和密码
    m_strPassword = "ADM";
	m_strUser = "ADM";
	UpdateData(false);
#endif
	// TODO: Add extra initialization here
	m_pApp = (CKvipApp *)AfxGetApp();
    m_RecordSet.SetAdoConnection(m_pApp->m_pConnection); //连结数据库
	ModifyStyleEx(0,WS_EX_TOPMOST);
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CDlgLogin::OnOK() 
{
	// TODO: Add extra validation here
	UpdateData();
	CString strSQL, strMsg;
	long nFunction;
	//整理输入数据
	m_strUser.MakeUpper();
	m_strUser.TrimLeft();
	m_strUser.TrimRight();
	m_strPassword.MakeUpper();
	m_strPassword.TrimLeft();
	m_strPassword.TrimRight();

	strSQL.Format("Select * From kv_user Where us_code = '%s' AND us_password = '%s' AND us_enabled = true",
				   m_strUser, m_strPassword);
	//检测用户
	//m_RecordSet.SetCursorLocation();          //作者例程，不知有什么用 
    if (!m_RecordSet.Open(strSQL,adCmdText,     //SQL为TXT
		                  adOpenStatic,         //静态游标
			              adLockReadOnly) ||    //只读
        m_RecordSet.IsBOF() ||
		m_RecordSet.IsEOF())
	{
		//错误提示	
err01:
		m_nRetry++;
		if (m_nRetry < 3)
		{
		 strMsg.Format("错误：第%d次密码错误，请确认后重新输入!", m_nRetry);
		 MessageBox(strMsg, "系统提示", MB_OK|MB_ICONEXCLAMATION);
		 return ;
		}
		else
		{
		 strMsg.Format("错误：输入密码错误!请联系统管理员!", m_nRetry);
		 MessageBox(strMsg, "系统提示", MB_OK|MB_ICONSTOP);
		 CDialog::OnCancel();
		 return ;
		}
	}
	//导入用户功能
	//m_RecordSet.MoveFirst();
	m_RecordSet.GetCollect("us_name", m_pApp->m_strUser);
	m_RecordSet.GetCollect("us_code", m_pApp->m_strCode);
	m_RecordSet.GetCollect("us_manager", m_pApp->m_bManager);
	m_pApp->m_caFunction.RemoveAll();
	if (m_pApp->m_bManager) CDialog::OnOK();

	strSQL.Format("Select * From kv_user_tx Where ut_code = '%s'",
		 m_pApp->m_strCode);
	if (!m_RecordSet.Open(strSQL,adCmdText,    //SQL为TXT
			  adOpenStatic,                    //静态游标
			  adLockReadOnly))                 //只读
	goto err01;
	//m_RecordSet.MoveFirst();
	while(m_RecordSet.IsEOF() == FALSE)
	{
		m_RecordSet.GetCollect("ut_function", nFunction);
		m_pApp->m_caFunction.Add((UINT)nFunction);
		m_RecordSet.MoveNext();
	}
    m_pApp->m_strPassword=m_strPassword;

    CDialog::OnOK();
}

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

BOOL CDlgLogin::DestroyWindow() 
{
	// TODO: Add your specialized code here and/or call the base class
    m_RecordSet.Close();	
	return CDialog::DestroyWindow();
}