www.pudn.com > sqlcommand.zip > SQLCommandView.cpp

// SQLCommandView.cpp : implementation of the CSQLCommandView class 
// 
 
#include "stdafx.h" 
#include "SQLCommand.h" 
 
#include "SQLCommandDoc.h" 
#include "SQLCommandView.h" 
 
#include "VORecordset.h" 
 
#ifdef _DEBUG 
#define new DEBUG_NEW 
#undef THIS_FILE 
static char THIS_FILE[] = __FILE__; 
#endif 
 
///////////////////////////////////////////////////////////////////////////// 
// CSQLCommandView 
 
IMPLEMENT_DYNCREATE(CSQLCommandView, CFormView) 
 
BEGIN_MESSAGE_MAP(CSQLCommandView, CFormView) 
	//{{AFX_MSG_MAP(CSQLCommandView) 
	ON_COMMAND(ID_SQL_EXIT, OnSqlExit) 
	ON_BN_CLICKED(IDC_GO_BUTTON, OnGoButton) 
	ON_CBN_SELCHANGE(IDC_COMMAND, OnSelchangeCommand) 
	//}}AFX_MSG_MAP 
END_MESSAGE_MAP() 
 
extern CSQLCommandApp theApp; 
 
///////////////////////////////////////////////////////////////////////////// 
// CSQLCommandView construction/destruction 
 
CSQLCommandView::CSQLCommandView() 
	: CFormView(CSQLCommandView::IDD) 
{ 
	//{{AFX_DATA_INIT(CSQLCommandView) 
	m_strSQL = _T(""); 
	//}}AFX_DATA_INIT 
	// TODO: add construction code here 
 
} 
 
CSQLCommandView::~CSQLCommandView() 
{ 
} 
 
void CSQLCommandView::DoDataExchange(CDataExchange* pDX) 
{ 
	CFormView::DoDataExchange(pDX); 
	//{{AFX_DATA_MAP(CSQLCommandView) 
	DDX_Control(pDX, IDC_COMMAND, m_CommandCombo); 
	DDX_Control(pDX, IDC_GO_BUTTON, m_GoButton); 
	DDX_Control(pDX, IDC_RESULTS, m_Results); 
	DDX_Text(pDX, IDC_SQL, m_strSQL); 
	//}}AFX_DATA_MAP 
} 
 
BOOL CSQLCommandView::PreCreateWindow(CREATESTRUCT& cs) 
{ 
	// TODO: Modify the Window class or styles here by modifying 
	//  the CREATESTRUCT cs 
 
	return CFormView::PreCreateWindow(cs); 
} 
 
///////////////////////////////////////////////////////////////////////////// 
// CSQLCommandView diagnostics 
 
#ifdef _DEBUG 
void CSQLCommandView::AssertValid() const 
{ 
	CFormView::AssertValid(); 
} 
 
void CSQLCommandView::Dump(CDumpContext& dc) const 
{ 
	CFormView::Dump(dc); 
} 
 
CSQLCommandDoc* CSQLCommandView::GetDocument() // non-debug version is inline 
{ 
	ASSERT(m_pDocument->IsKindOf(RUNTIME_CLASS(CSQLCommandDoc))); 
	return (CSQLCommandDoc*)m_pDocument; 
} 
#endif //_DEBUG 
 
///////////////////////////////////////////////////////////////////////////// 
// CSQLCommandView message handlers 
 
void CSQLCommandView::OnSqlExit()  
{ 
	PostQuitMessage(0);	 
} 
 
void CSQLCommandView::OnGoButton()  
{ 
	UpdateData(TRUE); 
	m_GoButton.EnableWindow(FALSE); 
	 
	CVORecordset rs(theApp.m_Conn); 
 
	rs.Open(m_strSQL, adOpenForwardOnly, adLockReadOnly); 
	m_Results.DeleteAllItems(); 
	while(m_Results.DeleteColumn(0)); 
 
	if(!rs.IsOpen() ) 
		AfxMessageBox(TEXT("Unable to execute command")); 
	else 
	{ 
		rs.MoveFirst(); 
 
		if(!rs.IsEOF() )	// If NOT at end of file 
		{ 
			int		iNew; 
			CString strFieldName; 
			CString strFieldValue; 
 
			for(int i = 0; i < rs.GetFieldCount(); i++) 
			{ 
				strFieldName = rs.GetFieldName(i); 
 
				m_Results.InsertColumn(-1, strFieldName); 
			} 
 
			while(!rs.IsEOF()) 
			{ 
				if(rs.GetFieldCount() < 1) 
					break; 
 
				for(int i = 0; i < rs.GetFieldCount(); i++) 
				{ 
					strFieldValue = rs.GetFieldValueString(i); 
					if(i == 0) 
						iNew = m_Results.InsertItem(-1, strFieldValue); 
					else 
						m_Results.SetItemText(iNew, i, strFieldValue); 
				} 
 
				rs.MoveNext(); 
			} 
 
			TRACE(TEXT("Field Count: %ld\n"), rs.GetFieldCount() ); 
		} 
	} 
 
	m_GoButton.EnableWindow(TRUE); 
} 
 
void CSQLCommandView::OnSelchangeCommand()  
{ 
	int iSel = m_CommandCombo.GetCurSel(); 
	 
	if(iSel != -1) 
	{ 
		m_CommandCombo.GetLBText(iSel, m_strSQL); 
		UpdateData(FALSE); 
	} 
} 
 
void CSQLCommandView::OnInitialUpdate()  
{ 
	CFormView::OnInitialUpdate(); 
	 
	m_CommandCombo.SetWindowText(TEXT("SQL Command")); 
}