phonenumberdlg.cpp

操作手机内电话簿的工具源代码。对手机开发是个很好的借鉴

// PhoneNumberDlg.cpp : implementation file
//

#include "stdafx.h"
#include "PhoneNumber.h"
#include "PhoneNumberDlg.h"

#include "voconnection.h"
#include "vorecordset.h"
#include "vostring.h"

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

/////////////////////////////////////////////////////////////////////////////
// CPhoneNumberDlg dialog

CPhoneNumberDlg::CPhoneNumberDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CPhoneNumberDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CPhoneNumberDlg)
		// NOTE: the ClassWizard will add member initialization here
	//}}AFX_DATA_INIT
	// Note that LoadIcon does not require a subsequent DestroyIcon in Win32
	m_hIcon = AfxGetApp()->LoadIcon(IDR_MAINFRAME);
}

void CPhoneNumberDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CPhoneNumberDlg)
	DDX_Control(pDX, IDC_LIST_PHONENUMBER, m_ctrlListPhoneNumber);
	//}}AFX_DATA_MAP
}

BEGIN_MESSAGE_MAP(CPhoneNumberDlg, CDialog)
	//{{AFX_MSG_MAP(CPhoneNumberDlg)
	ON_BN_CLICKED(IDC_QUERY, OnQuery)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CPhoneNumberDlg message handlers

BOOL CPhoneNumberDlg::OnInitDialog()
{
	CDialog::OnInitDialog();

	// Set the icon for this dialog.  The framework does this automatically
	//  when the application's main window is not a dialog
	SetIcon(m_hIcon, TRUE);			// Set big icon
	SetIcon(m_hIcon, FALSE);		// Set small icon
	
	CenterWindow(GetDesktopWindow());	// center to the hpc screen

	// TODO: Add extra initialization here
	//1.注册DLL
	CreateProcess(_T("\RegSvrCe"),_T("/s \Windows\\adoce31.dll"),NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
	CreateProcess(_T("\RegSvrCe"),_T("/s \Windows\\Adoxce31.dll"),NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
	CreateProcess(_T("\RegSvrCe"),_T("/s \Windows\\Adocedb31.dll"),NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
	CreateProcess(_T("\RegSvrCe"),_T("/s \Windows\\Adoceoledb31.dll"),NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
	CreateProcess(_T("\RegSvrCe"),_T("/s \Windows\\Msdaer.dll"),NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
	CreateProcess(_T("\RegSvrCe"),_T("/s \Windows\\Msdaeren.dll"),NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
	CreateProcess(_T("\RegSvrCe"),_T("/s \Windows\\msdadc.dll"),NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
	CreateProcess(_T("\RegSvrCe"),_T("/s \Windows\\msdaosp.dll"),NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
	
	//2.初始化表格
	m_ctrlListPhoneNumber.InsertColumn(0,_T("姓 名"),LVCFMT_LEFT,80,-1);
	m_ctrlListPhoneNumber.InsertColumn(1,_T("电 话"),LVCFMT_LEFT,100,-1);

	//3.加载表格
	CString s_Sql;
	s_Sql=_T("SELECT * FROM PhoneNumber");
	LoadTable(s_Sql);

	
	return TRUE;  // return TRUE  unless you set the focus to a control
}

void CPhoneNumberDlg::LoadTable(LPCTSTR s_Sql)
{
	CVOConnection *m_Conn;
	CVORecordset *m_Set;

	CString cdbName;
	cdbName=_T("Phone.cdb");

	m_Conn=new CVOConnection(cdbName);

	//m_Conn->Excute(s_Sql);

	m_Set=new CVORecordset(*m_Conn);
	m_Set->Initialize();
	m_Set->Open(s_Sql,adOpenForwardOnly,adLockPessimistic);	

	//加载表格
	if(m_Set->IsBOF()||m_Set->IsEOF())
	{
		AfxMessageBox(_T("数据库中没有相关记录!"));
		m_Set->Close();
		delete m_Set;
		delete m_Conn;
		return;
	}

	m_Set->MoveFirst();
	int Total=0;
	m_ctrlListPhoneNumber.DeleteAllItems();
	while(!m_Set->IsEOF())
	{
		m_ctrlListPhoneNumber.InsertItem(Total,m_Set->GetFieldValueString(0),-1);
		m_ctrlListPhoneNumber.SetItemText(Total,1,m_Set->GetFieldValueString(1));

		Total++;
		m_Set->MoveNext();
	}

	m_Set->Close();
	delete m_Set;
	delete m_Conn;
	return;

}

void CPhoneNumberDlg::OnQuery() 
{
	CString Name;
	GetDlgItemText(IDC_EDIT_NAME,Name);

	if(Name==_T(""))
	{
		AfxMessageBox(_T("请输入姓名!"));
		return;
	}

	CString s_Sql;
	s_Sql.Format(_T("SELECT * FROM PhoneNumber WHERE Name LIKE '%%%s%%'"),Name);

	LoadTable(s_Sql);
	
}