dlgparams.cpp

Visual C++ 实践与提高--数据库篇的源代码。很好的东西。欢迎下载。

// DlgParams.cpp : implementation file
//

#include "stdafx.h"
#include "DAOQry.h"
#include "DlgParams.h"
#include "crack.h"

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

/////////////////////////////////////////////////////////////////////////////
// CDlgParams dialog


CDlgParams::CDlgParams(CWnd* pParent /*=NULL*/)
	: CDialog(CDlgParams::IDD, pParent)
{
	//{{AFX_DATA_INIT(CDlgParams)
		// NOTE: the ClassWizard will add member initialization here
	//}}AFX_DATA_INIT
}


void CDlgParams::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CDlgParams)
	DDX_Control(pDX, IDC_LISTVIEW1, m_ctlList);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CDlgParams, CDialog)
	//{{AFX_MSG_MAP(CDlgParams)
	ON_NOTIFY(LVN_ENDLABELEDIT, IDC_LISTVIEW1, OnEndlabeleditListview1)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CDlgParams message handlers

void CDlgParams::SetInfo(CDaoDatabase *pDB, LPCTSTR lpszQueryDef)
{
	m_pDB = pDB;
	m_strQueryDef = lpszQueryDef;
}

BOOL CDlgParams::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	m_ctlList.AddColumn(_T("Value    "),0);
	m_ctlList.AddColumn(_T("Parameter Name"),1);

	CDaoQueryDef qd(m_pDB);
	CDaoParameterInfo paramInfo;
	int nParams;
	try{
		qd.Open(m_strQueryDef);
		nParams = qd.GetParameterCount();
		for (int i=0;i < nParams;i++)
		{
			qd.GetParameterInfo(i,paramInfo);
			COleVariant var = qd.GetParamValue(i);
			m_ctlList.AddItem(i,0,CCrack::strVARIANT(var));
			m_ctlList.AddItem(i,1,paramInfo.m_strName);
		}
	}
	catch(CDaoException* e)
	{
		AfxMessageBox("Dao 异常!");
		e->Delete();
	}
	qd.Close();
	
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CDlgParams::OnEndlabeleditListview1(NMHDR* pNMHDR, LRESULT* pResult) 
{
	LV_DISPINFO* pDispInfo = (LV_DISPINFO*)pNMHDR;

	m_ctlList.SetItemText( pDispInfo->item.iItem,pDispInfo->item.iSubItem,
						   pDispInfo->item.pszText);
	CDaoQueryDef qd(m_pDB);
	try{
		qd.Open(m_strQueryDef);
		qd.SetParamValue( pDispInfo->item.iItem,
						  COleVariant(pDispInfo->item.pszText, VT_BSTRT));
	}
	catch(CDaoException* e)
	{
		AfxMessageBox("Dao 异常!");
		e->Delete();
	}
	qd.Close();	
	*pResult = 0;
}