userquerydlg.cpp

手机话费程序

// UserQueryDlg.cpp : implementation file
//

#include "stdafx.h"
#include "mphonequery.h"
#include "UserQueryDlg.h"
#include "MPhoneQueryView.h"
#include "MainFrm.h"

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

/////////////////////////////////////////////////////////////////////////////
// CUserQueryDlg dialog


CUserQueryDlg::CUserQueryDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CUserQueryDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CUserQueryDlg)
	m_strUserPhoneNo = _T("");
	m_strUserPhonePswd = _T("");
	//}}AFX_DATA_INIT
}


void CUserQueryDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CUserQueryDlg)
	DDX_Text(pDX, IDC_USER_PHONENO, m_strUserPhoneNo);
	DDX_Text(pDX, IDC_USER_PHONEPSWD, m_strUserPhonePswd);
	//}}AFX_DATA_MAP
}


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

/////////////////////////////////////////////////////////////////////////////
// CUserQueryDlg message handlers

void CUserQueryDlg::OnOK() 
{
	// TODO: Add extra validation here
	UpdateData(true);
	
	m_strUserPhoneNo.TrimRight(" ");

	if ( "" == m_strUserPhoneNo )
	{
		AfxMessageBox(_T("请填写手机号码"), MB_ICONEXCLAMATION);
        return;
	}
		
	_variant_t Holder, strQuery;
    strQuery = "select password from phone where phone_no ='"+m_strUserPhoneNo+"'";
	
	theApp.ADOExecute(theApp.m_pADOSet, strQuery);

	int iCount = theApp.m_pADOSet->GetRecordCount();
	if ( 0 == iCount ) 
	{
		theApp.m_iLoginCount++;
		if ( theApp.m_iLoginCount > 2 ) 
		{
			AfxMessageBox("没有这个号码\n三次输入均不正确，请核对后再来", MB_ICONEXCLAMATION);	
			CDialog::OnCancel();
		    return;
		}
		AfxMessageBox("没有这个号码，请重新输入名称", MB_ICONEXCLAMATION);	
	    return;
	}
	
	// 取出该管理员的密码
	CString strPSWD;
	theApp.m_pADOSet ->MoveFirst();
	Holder = theApp.m_pADOSet ->GetCollect("password");
	if (Holder.vt == VT_NULL)
	{
		strPSWD = "";
	}
	else
	{
		strPSWD = (char*)(_bstr_t)Holder;
	}

	if ( strPSWD.Compare(m_strUserPhonePswd) != 0 )
	{
		theApp.m_iLoginCount++;
		if ( theApp.m_iLoginCount>2 ) 
		{
			AfxMessageBox("输入密码不正确\n三次输入均不正确，请核对后再来", MB_ICONEXCLAMATION);	
			CDialog::OnCancel();
		    return;
		}
		AfxMessageBox("输入密码不正确，请重新输入", MB_ICONEXCLAMATION);	
	    return;
	}
	
	strQuery = "select phone.cus_id from phone, customer where phone.cus_id = customer.cus_id and \
		phone.phone_no = '"+m_strUserPhoneNo+"'";
	theApp.ADOExecute(theApp.m_pADOSet, strQuery);
	iCount = theApp.m_pADOSet->GetRecordCount();
	
	CString  strUserId;
	if (iCount == 0)
	{
		strQuery = "select * from phone where phone_no = '"+m_strUserPhoneNo+"'";
		strUserId = "%";
	}
	else
	{	
		theApp.m_pADOSet ->MoveFirst();
		Holder = theApp.m_pADOSet ->GetCollect("cus_id");
		strUserId = (char*)(_bstr_t)Holder;

		strQuery = "select * from phone, customer where phone.cus_id = customer.cus_id and \
			phone.phone_no = '"+m_strUserPhoneNo+"'";
	}
	
	// Refresh RoomType List
	CMPhoneQueryView* p = (CMPhoneQueryView*)(((CMainFrame*)AfxGetMainWnd())->GetActiveView());
	p->RefreshUser(strQuery, strUserId);
		
	CDialog::OnOK();
}

BOOL CUserQueryDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	((CEdit*)GetDlgItem(IDC_USER_PHONENO))->SetLimitText(50);
    ((CEdit*)GetDlgItem(IDC_USER_PHONEPSWD))->SetLimitText(50);

	UpdateData(FALSE);	

	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}