dlglogin.cpp

web

// Dlglogin.cpp : implementation file
//

#include "stdafx.h"
#include "jiasg.h"
#include "Dlglogin.h"
#include "myadoclass.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_password = _T("");
	m_user = _T("");
	//}}AFX_DATA_INIT
}


void CDlglogin::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CDlglogin)
	DDX_Control(pDX, IDC_EDIT_password, m_ctr_password);
	DDX_Control(pDX, IDC_COMBO1, m_ctrl_user);
	DDX_Text(pDX, IDC_EDIT_password, m_password);
	DDX_CBString(pDX, IDC_COMBO1, m_user);
	//}}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();
	::PostMessage(m_ctr_password.GetSafeHwnd(),WM_ACTIVATE ,WA_CLICKACTIVE,0);
	// TODO: Add extra initialization here
	CString sql;
	
	LRunSql m_runsql;

	sql.Format("select * from pwd");
	if(!m_runsql.CheckSQLResult(sql)) return false;

	_variant_t value;

	while(!m_runsql.m_recordset->adoEOF)
	{
		value=m_runsql.m_recordset->GetCollect("opname");
    	if(value.vt!=VT_NULL)
		this->m_ctrl_user.AddString((char*)(_bstr_t)value);
		m_runsql.m_recordset->MoveNext();
	}
//	this->m_ctr_mima.SetFocus();
	this->m_ctrl_user.SetCurSel(0);
	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
	
//	CDialog::OnOK();
	BOOL bLogOn=FALSE;

	LRunSql m_runsql;

	CString sUserPassWord, sGrade,sInputUserName,sInputPassWord;
    CString sql, sError;
	_variant_t vpassword,vgrade;
   
 
	// 更新数据变量
	this->m_ctr_password.GetWindowText(sInputPassWord);
	this->m_ctrl_user.GetWindowText(sInputUserName);

	
     CJiasgApp *app=(CJiasgApp*)AfxGetApp();
  

     sql.Format("select oppassword,opgrade from pwd where opname='%s'",sInputUserName);

      
     if(m_runsql.CheckSQLResult(sql))
	 { 

	    vpassword = m_runsql.m_recordset->GetCollect("oppassword");

	    if(vpassword.vt!=VT_NULL)
  		   sUserPassWord=(char*)(_bstr_t)vpassword;

        vgrade=m_runsql.m_recordset->GetCollect("opgrade");
	
		if(vgrade.vt!=VT_NULL)
			sGrade=(char*)(_bstr_t)vgrade;

		if(sUserPassWord==sInputPassWord)
		{
			bLogOn=TRUE;
	    	app->m_sUserName=sInputUserName;
	    	app->m_sGrade=sGrade;
            
		}else{
			sError="\n\n请重新输入密码。\n\n\n\注意大小写!!!!!!","密码错误";
		}
	 }else{
		sError="请确认用户名大小写是否正确!","无此用户";
		this->m_ctrl_user.SetFocus();
	 }
	
     if(bLogOn) 
		EndDialog(IDOK);
     else 
	 {	
	
	    this->SetDlgItemText(IDC_EDIT_password,"");
	    this->GetDlgItem(IDC_EDIT_password)->SetFocus();	 
		m_iLogOnCount++;
		if(m_iLogOnCount>=3)
			this->EndDialog(0);
		else
			AfxMessageBox(sError);
     }
}