irecset.h

EVC环境

///////////////////////////////////////////////////////////////////////////////
//// Copyright(c) HangZhou Macrosoft Computer Communication Technology Co.,Ltd.
//// File Name	: IRecset.h
//// Create		: YunGui-Zhang
//// CreateDate :
//// Modify		:	
//// ModifyDate :
//// Description: Expend from CVORecodset class,retrieve several data types 
////              
//// Version    : 
////
///////////////////////////////////////////////////////////////////////////////

#if !defined(AFX_IRECSET_H__4DE95B40_0ED3_11D6_818F_0050BA6D003F__INCLUDED_)
#define AFX_IRECSET_H__4DE95B40_0ED3_11D6_818F_0050BA6D003F__INCLUDED_

#if _MSC_VER > 1000
#pragma once
#endif // _MSC_VER > 1000

#include "VORecordset.h"

class CIRecordset  
{
public:
	CIRecordset(LPCTSTR lpszTableName=NULL);
	virtual ~CIRecordset();

	virtual BOOL Open(LPCTSTR pcszSource = NULL, enum CursorTypeEnum CursorType = adOpenForwardOnly, enum LockTypeEnum LockType = adLockReadOnly);
	virtual BOOL InsertRecord(LPCTSTR lpszValues);
	virtual void Close();

	BYTE	GetFieldValueBit (int iField,BOOL* pResult=NULL);
	int 	GetFieldValueSmallInt (int iField,BOOL* pResult=NULL);
	long	GetFieldValueInt (int iField,BOOL* pResult=NULL);
	double	GetFieldValueFloat (int iField,BOOL* pResult=NULL);
	CString	GetFieldValueText (int iField,BOOL* pResult=NULL);
	CTime	GetFieldValueDate (int iField,BOOL* pResult=NULL);
	COleDateTime	GetFieldValueDate2 (int iField,BOOL* pResult=NULL);

	static CString DateToStr(CTime& time);
	static CString DateToStr(COleDateTime& Date);

public:
	CString	m_szTable;
	CString	m_szFilter;
	CString m_szSort;
	CString	m_szFields;
	CString	m_szSQL;
	CVORecordset*	m_pRecord;
};

#endif // !defined(AFX_IRECSET_H__4DE95B40_0ED3_11D6_818F_0050BA6D003F__INCLUDED_)