adodemodlg.cpp

VC.net 的一些有用的技巧

// ADODemoDlg.cpp : 实现文件
//

#include "stdafx.h"
#include "ADODemo.h"
#include "ADODemoDlg.h"

#ifdef _DEBUG
#define new DEBUG_NEW
#endif


// 用于应用程序“关于”菜单项的 CAboutDlg 对话框

class CAboutDlg : public CDialog
{
public:
	CAboutDlg();

// 对话框数据
	enum { IDD = IDD_ABOUTBOX };

	protected:
	virtual void DoDataExchange(CDataExchange* pDX);    // DDX/DDV 支持

// 实现
protected:
	DECLARE_MESSAGE_MAP()
};

CAboutDlg::CAboutDlg() : CDialog(CAboutDlg::IDD)
{
}

void CAboutDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
}

BEGIN_MESSAGE_MAP(CAboutDlg, CDialog)
END_MESSAGE_MAP()


// CADODemoDlg 对话框



CADODemoDlg::CADODemoDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CADODemoDlg::IDD, pParent)
	, m_bSuccess(false)
	, m_Name(_T(""))
	, m_Address(_T(""))
	, m_PostalCode(_T(""))
	, m_HomePhone(_T(""))
	, m_WorkPhone(_T(""))
{
	m_hIcon = AfxGetApp()->LoadIcon(IDR_MAINFRAME);
}

void CADODemoDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	DDX_Control(pDX, IDC_ADDRESSLIST, m_addresslist);
	DDX_Text(pDX, IDC_NAME, m_Name);
	DDX_Text(pDX, IDC_ADDRESS, m_Address);
	DDX_Text(pDX, IDC_POSTALCODE, m_PostalCode);
	DDX_Text(pDX, IDC_HOMEPHONE, m_HomePhone);
	DDX_Text(pDX, IDC_WORKPHONE, m_WorkPhone);
	DDX_Control(pDX, IDC_DELETEREC, m_DelButton);
	DDX_Control(pDX, IDC_EDITREC, m_EditButton);
}

BEGIN_MESSAGE_MAP(CADODemoDlg, CDialog)
	ON_WM_SYSCOMMAND()
	ON_WM_PAINT()
	ON_WM_QUERYDRAGICON()
	//}}AFX_MSG_MAP
	ON_NOTIFY(LVN_ITEMCHANGED, IDC_ADDRESSLIST, OnLvnItemchangedAddresslist)
	ON_BN_CLICKED(IDC_ADDREC, OnAddrec)
	ON_BN_CLICKED(IDC_DELETEREC, OnDeleterec)
	ON_BN_CLICKED(IDC_EDITREC, OnEditrec)
	ON_BN_CLICKED(IDOK, OnOk)
END_MESSAGE_MAP()


// CADODemoDlg 消息处理程序

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

	// 将\“关于...\”菜单项添加到系统菜单中。

	// IDM_ABOUTBOX 必须在系统命令范围内。
	ASSERT((IDM_ABOUTBOX & 0xFFF0) == IDM_ABOUTBOX);
	ASSERT(IDM_ABOUTBOX < 0xF000);
	
	CMenu* pSysMenu = GetSystemMenu(FALSE);
	if (pSysMenu != NULL)
	{
		CString strAboutMenu;
		strAboutMenu.LoadString(IDS_ABOUTBOX);
		if (!strAboutMenu.IsEmpty())
		{
			pSysMenu->AppendMenu(MF_SEPARATOR);
			pSysMenu->AppendMenu(MF_STRING, IDM_ABOUTBOX, strAboutMenu);
		}
	}

	// 设置此对话框的图标。当应用程序主窗口不是对话框时，框架将自动
	//  执行此操作
	SetIcon(m_hIcon, TRUE);			// 设置大图标
	SetIcon(m_hIcon, FALSE);		// 设置小图标

	// TODO：在此添加额外的初始化代码
	m_DelButton.EnableWindow(false);
	m_EditButton.EnableWindow(false);

	m_addresslist.InsertColumn(0,"姓名",LVCFMT_LEFT,60);
	m_addresslist.InsertColumn(1,"所在",LVCFMT_LEFT,80);
	m_addresslist.InsertColumn(2,"邮编",LVCFMT_LEFT,80);
	m_addresslist.InsertColumn(3,"宅电",LVCFMT_LEFT,80);
	m_addresslist.InsertColumn(4,"工作电话",LVCFMT_LEFT,80);

	int nItem;
	try
	{
		m_pRecordset.CreateInstance(__uuidof( Recordset ));
		m_pRecordset->Open("SELECT * FROM 通讯录",_variant_t((IDispatch*)theApp.m_pConnection,true),adOpenStatic,adLockOptimistic,adCmdText);
		m_bSuccess = TRUE;
		while(!m_pRecordset->adoEOF)
		{
			vName = m_pRecordset->GetCollect("Name");
			vAddress = m_pRecordset->GetCollect("Address");
			vPostalCode = m_pRecordset->GetCollect("Postal Code");
			vHomePhone = m_pRecordset->GetCollect("HomePhone");
			vWorkPhone = m_pRecordset->GetCollect("WorkPhone");

			nItem=m_addresslist.InsertItem(0xffff,(_bstr_t)vName);
			m_addresslist.SetItem(nItem,1,1,(_bstr_t)vAddress,NULL,0,0,0);
			m_addresslist.SetItem(nItem,2,1,(_bstr_t)vPostalCode,NULL,0,0,0);
			m_addresslist.SetItem(nItem,3,1,(_bstr_t)vHomePhone,NULL,0,0,0);
			m_addresslist.SetItem(nItem,4,1,(_bstr_t)vWorkPhone,NULL,0,0,0);

			m_pRecordset->MoveNext();
		}
	}
	catch(_com_error e)///捕捉异常
	{
		AfxMessageBox("读取数据库失败!");///显示错误信息
	}

	return TRUE;  // 除非设置了控件的焦点，否则返回 TRUE
}

void CADODemoDlg::OnSysCommand(UINT nID, LPARAM lParam)
{
	if ((nID & 0xFFF0) == IDM_ABOUTBOX)
	{
		CAboutDlg dlgAbout;
		dlgAbout.DoModal();
	}
	else
	{
		CDialog::OnSysCommand(nID, lParam);
	}
}

// 如果向对话框添加最小化按钮，则需要下面的代码
//  来绘制该图标。对于使用文档/视图模型的 MFC 应用程序，
//  这将由框架自动完成。

void CADODemoDlg::OnPaint() 
{
	if (IsIconic())
	{
		CPaintDC dc(this); // 用于绘制的设备上下文

		SendMessage(WM_ICONERASEBKGND, reinterpret_cast<WPARAM>(dc.GetSafeHdc()), 0);

		// 使图标在工作矩形中居中
		int cxIcon = GetSystemMetrics(SM_CXICON);
		int cyIcon = GetSystemMetrics(SM_CYICON);
		CRect rect;
		GetClientRect(&rect);
		int x = (rect.Width() - cxIcon + 1) / 2;
		int y = (rect.Height() - cyIcon + 1) / 2;

		// 绘制图标
		dc.DrawIcon(x, y, m_hIcon);
	}
	else
	{
		CDialog::OnPaint();
	}
}

//当用户拖动最小化窗口时系统调用此函数取得光标显示。
HCURSOR CADODemoDlg::OnQueryDragIcon()
{
	return static_cast<HCURSOR>(m_hIcon);
}

void CADODemoDlg::OnLvnItemchangedAddresslist(NMHDR *pNMHDR, LRESULT *pResult)
{
	LPNMLISTVIEW pNMLV = reinterpret_cast<LPNMLISTVIEW>(pNMHDR);
	// TODO: 在此添加控件通知处理程序代码
	if(pNMLV->uNewState&LVIS_SELECTED)
	{
		UpdateData();
		SaveData();///保存旧数据
		m_nCurrentSel = pNMLV->iItem;
		LoadData();///加载新数据
		m_DelButton.EnableWindow();
		m_EditButton.EnableWindow();
	}
	*pResult = 0;
}

void CADODemoDlg::OnAddrec()
{
	// TODO: 在此添加控件通知处理程序代码
	m_pRecordset->AddNew();
	UpdateData(true);
	m_nCurrentSel = m_addresslist.InsertItem(0xffff,"");
	SaveData();///保存数据
	m_addresslist.SetItemState(m_nCurrentSel,LVIS_SELECTED|LVIS_FOCUSED,LVIS_SELECTED|LVIS_FOCUSED);
	m_addresslist.SetHotItem(m_nCurrentSel);
	m_addresslist.SetFocus();	
}

void CADODemoDlg::OnEditrec()
{
	// TODO: 在此添加控件通知处理程序代码
	UpdateData(true);
	SaveData();
	m_pRecordset->Update();
}

void CADODemoDlg::OnDeleterec()
{
	// TODO: 在此添加控件通知处理程序代码
	m_addresslist.DeleteItem(m_nCurrentSel);
	int count = m_addresslist.GetItemCount();
	if(count <= m_nCurrentSel)
		m_nCurrentSel = count-1;
	if(m_nCurrentSel < 0)
	{
		m_DelButton.EnableWindow(false);
		m_EditButton.EnableWindow(false);
	}
	m_pRecordset->Delete(adAffectCurrent);
	m_pRecordset->MoveNext();
	LoadData();
	m_addresslist.SetItemState(m_nCurrentSel,LVIS_SELECTED|LVIS_FOCUSED,LVIS_SELECTED|LVIS_FOCUSED);
	m_addresslist.SetFocus();	
}

void CADODemoDlg::LoadData(void)
{
	if(m_nCurrentSel >= 0)
	{
		m_pRecordset->Move(m_nCurrentSel,_variant_t((long)adBookmarkFirst));
		vName = m_pRecordset->GetCollect("Name");
		vAddress = m_pRecordset->GetCollect("Address");
		vPostalCode = m_pRecordset->GetCollect("Postal Code");
		vHomePhone = m_pRecordset->GetCollect("HomePhone");
		vWorkPhone = m_pRecordset->GetCollect("WorkPhone");
		m_Name = vName;
		m_Address = vAddress;
		m_PostalCode = vPostalCode;
		m_HomePhone = vHomePhone;
		m_WorkPhone = vWorkPhone;
		UpdateData(FALSE);
	}
}

void CADODemoDlg::SaveData(void)
{
	if(!m_pRecordset->adoEOF && m_nCurrentSel >= 0)
	{
		vName = m_Name;
		vAddress = m_Address;
		vPostalCode = m_PostalCode;
		vHomePhone = m_HomePhone;
		vWorkPhone = m_WorkPhone;
		m_pRecordset->PutCollect("Name",vName);
		m_pRecordset->PutCollect("Address",vAddress);
		m_pRecordset->PutCollect("Postal Code",vPostalCode);
		m_pRecordset->PutCollect("HomePhone",vHomePhone);
		m_pRecordset->PutCollect("WorkPhone",vWorkPhone);
		m_addresslist.SetItem(m_nCurrentSel,0,LVIF_TEXT,(_bstr_t)vName,NULL,0,0,0);
		m_addresslist.SetItem(m_nCurrentSel,1,LVIF_TEXT,(_bstr_t)vAddress,NULL,0,0,0);
		m_addresslist.SetItem(m_nCurrentSel,2,LVIF_TEXT,(_bstr_t)vPostalCode,NULL,0,0,0);
		m_addresslist.SetItem(m_nCurrentSel,3,LVIF_TEXT,(_bstr_t)vHomePhone,NULL,0,0,0);
		m_addresslist.SetItem(m_nCurrentSel,4,LVIF_TEXT,(_bstr_t)vWorkPhone,NULL,0,0,0);
	}
}

void CADODemoDlg::OnOk()
{
	// TODO: 在此添加控件通知处理程序代码
	if(m_bSuccess)
	{
		m_pRecordset->Close();
	}
	OnOK();
}