database.h

SMAL是short message abstract library的缩写,是由风起水流软件工作室（www.zealware.com）开发的一个支持短信网关系统开发的C++底层抽象接口库

/**
*	database.h
*	
*	Short Message Abstractive Library.(SMAL)
*
*	Copyright 2003-2006	北京风起水流软件工作室
*	
*	http://www.zealware.com
*	
*	[e-mail]
*
*/

#ifndef _SMAL_DATABASE_ADO_H
#define _SMAL_DATABASE_ADO_H

#include <smal.h>
#include <math.h>

#import "c:\Program Files\Common Files\System\ADO\msado26.tlb" \
	no_namespace rename("EOF", "EndOfFile")

void IntToStr(int nVal, char* strVal, unsigned size);
void LongToStr(long lVal, char* strVal, unsigned size);
void ULongToStr(unsigned long ulVal, char* strVal, unsigned size);
void DblToStr(double dblVal, int ndigits, char* strVal, unsigned size);
void DblToStr(float fltVal, char* strVal, unsigned size);

CString IntToStr(int nVal);

CString LongToStr(long lVal);

CString ULongToStr(unsigned long ulVal);

CString DblToStr(double dblVal, int ndigits = 20);

CString DblToStr(float fltVal);


//inline void TESTHR(HRESULT x) {if FAILED(x) _com_issue_error(x);};
//void PrintProviderError(_ConnectionPtr pConnection);
//void PrintComError(_com_error &e);

BOOL GetFieldValue(_RecordsetPtr pRs, const char* lpFieldName, int& nValue);
BOOL GetFieldValue(_RecordsetPtr pRs, const char* lpFieldName, long& lValue);
BOOL GetFieldValue(_RecordsetPtr pRs, const char* lpFieldName, unsigned long& ulValue);
BOOL GetFieldValue(_RecordsetPtr pRs, const char* lpFieldName, double& dbValue);
BOOL GetFieldValue(_RecordsetPtr pRs, const char* lpFieldName, char* strValue, int size, bool autoTrim = true);
//BOOL GetFieldValue(_RecordsetPtr pRs, const char* lpFieldName, COleDateTime& time);
BOOL GetFieldValue(_RecordsetPtr pRs, const char* lpFieldName, bool& bValue);
//BOOL GetFieldValue(_RecordsetPtr pRs, const char* lpFieldName, COleCurrency& cyValue);
BOOL GetFieldValue(_RecordsetPtr pRs, const char* lpFieldName, _variant_t& vtValue);
BOOL IsFieldNull(_RecordsetPtr pRs, const char* lpFieldName);
BOOL IsFieldEmpty(_RecordsetPtr pRs, const char* lpFieldName);


BOOL GetFieldValue(LPCTSTR lpFieldName, int& nValue);
BOOL GetFieldValue(int nIndex, int& nValue);
BOOL GetFieldValue(LPCTSTR lpFieldName, long& lValue);
BOOL GetFieldValue(int nIndex, long& lValue);
BOOL GetFieldValue(LPCTSTR lpFieldName, unsigned long& ulValue);
BOOL GetFieldValue(int nIndex, unsigned long& ulValue);
BOOL GetFieldValue(LPCTSTR lpFieldName, double& dbValue);
BOOL GetFieldValue(int nIndex, double& dbValue);
BOOL GetFieldValue(LPCTSTR lpFieldName, CString& strValue, CString strDateFormat = _T(""));
BOOL GetFieldValue(int nIndex, CString& strValue, CString strDateFormat = _T(""));
BOOL GetFieldValue(LPCTSTR lpFieldName, COleDateTime& time);
BOOL GetFieldValue(int nIndex, COleDateTime& time);
BOOL GetFieldValue(int nIndex, bool& bValue);
BOOL GetFieldValue(LPCTSTR lpFieldName, bool& bValue);
BOOL GetFieldValue(int nIndex, COleCurrency& cyValue);
BOOL GetFieldValue(LPCTSTR lpFieldName, COleCurrency& cyValue);
BOOL GetFieldValue(int nIndex, _variant_t& vtValue);
BOOL GetFieldValue(LPCTSTR lpFieldName, _variant_t& vtValue);

BOOL IsFieldNull(LPCTSTR lpFieldName);
BOOL IsFieldNull(int nIndex);
BOOL IsFieldEmpty(LPCTSTR lpFieldName);
BOOL IsFieldEmpty(int nIndex);	
BOOL IsEof()
{return m_pRecordset->EndOfFile == VARIANT_TRUE;};
BOOL IsEOF()
{return m_pRecordset->EndOfFile == VARIANT_TRUE;};

#endif