adomanager.h

自动从数据库上移动数据,,,采用ORACAL数据库.

#if !defined(AFX_ADOMANAGER_H__3A604471_FB9D_4C6A_99A3_31DB05E1AF60__INCLUDED_)
#define AFX_ADOMANAGER_H__3A604471_FB9D_4C6A_99A3_31DB05E1AF60__INCLUDED_

#if _MSC_VER > 1000
#pragma once
#endif // _MSC_VER > 1000
// AdoManager.h : header file
//

#import "c:\Program Files\Common Files\System\ADO\msado15.dll"  rename("EOF", "EndOfFile") \
	rename("LockTypeEnum","adoLockTypeEnum") \
	rename("DataTypeEnum","adoDataTypeEnum") \
	rename("FieldAttributeEnum","adoFieldAttributeEnum") \
	rename("EditModeEnum","adoEditModeEnum") \
	rename("RecordStatusEnum","adoRecordStatusEnum") \
	rename("ParameterDirectionEnum","adoParameterDirectionEnum") 

#import "c:\Program Files\Common Files\System\ado\msadox.dll" \
	rename( "EOF", "adoEOF" ) no_namespace rename("DataTypeEnum", "adoDataTypeEnum")

/////////////////////////////////////////////////////////////////////////////
// CAdoManager command target
void dump_com_error(_com_error &e);

class  CRecordSet
{
public:
	CRecordSet() {};
	CRecordSet(ADODB::_ConnectionPtr gconnection,char *SqlStr);
	~CRecordSet();

public:
	BOOL GetColValBYtype(void *pValue,short Index, short vt_type);
	void Release();
	BOOL GetColVar(WORD *pvalue, int index);
	BOOL GetColVarSQL(int &pvalue, int index);
	BOOL GetColVar(int *pvalue, int index);
	BOOL GetColVar(DATE &pDate, int index);
	BOOL GetColVar(CString *pStr, int index);
	BOOL GetColVarAll(CString *pStr, int index);
	void Delete(enum AffectEnum AffectRecords);
	BOOL GetColVar(DATE* pdata,char* colName);
	BOOL GetColVar(CString* pStr,char* colName);
	BOOL GetColVar(DWORD pvalue,char* colName);
	BOOL GetColVar(int& pvalue,char* colName);
	BOOL GetColVar(DWORD& pvalue, int index);
	BOOL Open(ADODB::_ConnectionPtr gconnection,char* filterstr);
	BOOL GetColVar(char *pStr, char *colName);
	BOOL GetColVar(char *pStr, int index);
//	BOOL GetColVar(BYTE& pdata,int index);
//	BOOL GetColVar(float& pdata,int index);
	BOOL Close();
	UINT GetCount();

	long  GetCol();  //-1 = error
	
	BOOL MoveFirst();
	BOOL MoveNext();
	BOOL MoveLast();
	BOOL Move(long nNumber);
	BOOL IsEOF();
//	int  GetRow();//get current row  index

//	BOOL GetFields(ADODB::Fields &pFields);
	BOOL GetFields(VARIANT v[],int fieldnum);//get current row values
	BOOL GetColValue(VARIANT* v,int Col);//get specified col value
	BOOL GetColValue(VARIANT* v,char* ColName);//get specified col value

//private:
public:
	ADODB::_RecordsetPtr	m_pRecordSet;
	
};

//1) com connection manage
//2) recorderset_s manage | connection between recoderset and com

class  CAdoManager
{
// Attributes
public:
	CAdoManager();           // protected constructor used by dynamic creation
	~CAdoManager();

	ADODB::_CommandPtr		m_pCommand;
	_CatalogPtr			    m_catalog;
// Operations
public:
	//Dbopen
	BOOL OpenDb(char* ConnectionString = "DSN=sm;uid=sm;pwd=smpwd");
	BOOL OpenDbd(char* ConnectionString = "DSN=sm;uid=sm;pwd=smpwd");
	//DbClose
	void CloseDb();
	BOOL IsOpen();

	//insert,update db
	BOOL Execute(char* query);

	BOOL BeginTrans();
	BOOL CommitTrans();
	BOOL RollBackTrans();
    //
    CRecordSet* CreateRecordSet(char* query);
	//
	void DestroyRecordSet(CRecordSet* );

private:
	ADODB::_ConnectionPtr	gconnection; //com interface


};

/////////////////////////////////////////////////////////////////////////////

//{{AFX_INSERT_LOCATION}}
// Microsoft Visual C++ will insert additional declarations immediately before the previous line.

#endif // !defined(AFX_ADOMANAGER_H__3A604471_FB9D_4C6A_99A3_31DB05E1AF60__INCLUDED_)