permissionsqry.cpp

来自「Visual C++编程宝典随书光盘里的代码」· C++ 代码 · 共 72 行

// PermissionsQry.cpp : implementation file
//

#include "stdafx.h"
#include "Parameterized.h"
#include "PermissionsQry.h"

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

/////////////////////////////////////////////////////////////////////////////
// CPermissionsQry

IMPLEMENT_DYNAMIC(CPermissionsQry, CRecordset)

CPermissionsQry::CPermissionsQry(CDatabase* pdb)
	: CRecordset(pdb)
{
	//{{AFX_FIELD_INIT(CPermissionsQry)
	m_sCompanyID = _T("");
	m_sCompanyName = _T("");
	m_sSubsystemID = _T("");
	m_sSubsystemName = _T("");
	m_nFields = 4;
	//}}AFX_FIELD_INIT
	m_nDefaultType = snapshot;
	m_sUserIDParam = _T("");
	m_nParams = 1;
}


CString CPermissionsQry::GetDefaultConnect()
{
	return _T("ODBC;DSN=Visual C++ 6 Bible");
}

CString CPermissionsQry::GetDefaultSQL()
{
  return _T("{CALL GetPermissionsByUserID(?)}");
}

void CPermissionsQry::DoFieldExchange(CFieldExchange* pFX)
{
	//{{AFX_FIELD_MAP(CPermissionsQry)
	pFX->SetFieldType(CFieldExchange::outputColumn);
	RFX_Text(pFX, _T("[sCompanyID]"), m_sCompanyID);
	RFX_Text(pFX, _T("[sCompanyName]"), m_sCompanyName);
	RFX_Text(pFX, _T("[sSubsystemID]"), m_sSubsystemID);
	RFX_Text(pFX, _T("[sSubsystemName]"), m_sSubsystemName);
	//}}AFX_FIELD_MAP
	pFX->SetFieldType(CFieldExchange::param);
	RFX_Text(pFX, _T("[sUserID]"), m_sUserIDParam);
}

/////////////////////////////////////////////////////////////////////////////
// CPermissionsQry diagnostics

#ifdef _DEBUG
void CPermissionsQry::AssertValid() const
{
	CRecordset::AssertValid();
}

void CPermissionsQry::Dump(CDumpContext& dc) const
{
	CRecordset::Dump(dc);
}
#endif //_DEBUG