querydlg.cpp

通讯录管理系统1.0 可以为您方便地, 安全地管理你的通讯录, 是您的家庭好帮手. 本系统使用Visual C++(MFC)开发, ODBC开放式数据库源

// QueryDlg.cpp : implementation file
//

#include "stdafx.h"
#include "SGAdrLstMS.h"
#include "QueryDlg.h"

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

/////////////////////////////////////////////////////////////////////////////
// CQueryDlg dialog


CQueryDlg::CQueryDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CQueryDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CQueryDlg)
	m_queryname = _T("");
	m_infor = _T("显示查找结果区域");
	//}}AFX_DATA_INIT
}


void CQueryDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CQueryDlg)
	DDX_Text(pDX, IDC_QUERYNAME, m_queryname);
	DDX_Text(pDX, IDC_INFORM, m_infor);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CQueryDlg, CDialog)
	//{{AFX_MSG_MAP(CQueryDlg)
	ON_BN_CLICKED(IDC_QUERY, OnQuery)
	ON_CBN_SELCHANGE(IDC_QUERYITEM, OnSelchangeQueryitem)
	ON_BN_CLICKED(IDC_BUTTON1, OnButton1)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CQueryDlg message handlers

void CQueryDlg::OnQuery() 
{
	this->UpdateData(true);
	if (this->m_queryname == "")
	{
		MessageBox("必须输入姓名","提示",MB_ICONEXCLAMATION);
		this->GetDlgItem(IDC_QUERYNAME)->SetFocus();
		return;
	}
	this->UpdateData(false);

	db.RefreshConnection();
	db.Open();	
	db.MoveFirst();

	while (!db.IsEOF())
	{
		if ( db.m_column2 == this->m_queryname)
		{
			this->UpdateData(true);

			this->GetDlgItem(IDC_QUERYITEM)->EnableWindow(true);
			this->GetDlgItem(IDC_INFORM)->EnableWindow(true);
			this->GetDlgItem(IDC_QUERYNAME)->EnableWindow(false);
			this->GetDlgItem(IDC_QUERY)->EnableWindow(false);
			this->GetDlgItem(IDC_QUERYITEM)->SetWindowText("Email");

			break;
		}
		db.MoveNext();
	}	
		
	if (db.IsEOF())
	{
		MessageBox("无此联系人,操作失败","操作失败",MB_ICONSTOP);
		this->GetDlgItem(IDC_QUERYNAME)->SetFocus();
	}
}

void CQueryDlg::OnSelchangeQueryitem() 
{
	// TODO: Add your control notification handler code here
	CComboBox *a;
	CString  infor;
	
	a = (CComboBox*)GetDlgItem(IDC_QUERYITEM);

	

	int flag = a->GetCurSel();

	switch (flag)
	{
	case 4:

		infor.Format("姓名: %s\n固定电话: %s\n 移动电话: %s\nEmail:  %s\nQQ: %s\n备注:%s",
db.m_column2,
db.m_column3,
db.m_column4,
db.m_column5,
db.m_QQ__,
db.m_column6);
		break;
	case 3:
		infor.Format("姓名: %s\n固定电话: %s\n",
		db.m_column2,
		db.m_column3);
		break;
	case 5:
		infor.Format("姓名: %s\n移动电话: %s\n",
		db.m_column2,
		db.m_column4);
		break;
	case 0:
		infor.Format("姓名: %s\nEmail: %s\n",
		db.m_column2,
		db.m_column5);
		break;
	case 1:
		infor.Format("姓名: %s\nQQ: %s\n",
		db.m_column2,
		db.m_QQ__);
		break;
	case 2:
		infor.Format("姓名: %s\n备注: %s\n",
		db.m_column2,
		db.m_column6);
		break;
	}
	
	//this->GetDlgItem(IDC_INFOR)->SetWindowText(infor);
	this->UpdateData(true);
	this->m_infor = infor;
	this->UpdateData(false);

	db.Close();

}

void CQueryDlg::OnButton1() 
{

	this->OnCancel();
}