adodb.h

电信机房MDF、电源柜监控源码,主要用在通信机房配线设备监控、电源柜监控

// AdoDB.h: interface for the CAdoDB class.
//
//////////////////////////////////////////////////////////////////////

#if !defined(AFX_ADODB_H__8C8C56FD_6ED2_40FA_B0CF_7147CD8ECCFA__INCLUDED_)
#define AFX_ADODB_H__8C8C56FD_6ED2_40FA_B0CF_7147CD8ECCFA__INCLUDED_

#if _MSC_VER > 1000
#pragma once
#endif // _MSC_VER > 1000
#define RS_MAX 20

//##ModelId=44B6F887038A
class CAdoDB  
{
public:
	//##ModelId=44B6F887038B
	BOOL ExecuteDB(CString strNote);
	//##ModelId=44B6F887039A
	BOOL GetConnectState();
	//##ModelId=44B6F887039B
	int GetDoubleVar(_variant_t var,double& dValue,CString strTip);
	
	//##ModelId=44B6F88703A9
	CString m_strIp ;
	//##ModelId=44B6F88703AA
	CString m_strUserId ;
	//##ModelId=44B6F88703AB
	CString m_strPassWord ;
	//##ModelId=44B6F88703B9
	int GetStrVar(_variant_t var,CString& strValue,CString strTip);
	//##ModelId=44B6F88703BD
	int GetIntVar(_variant_t var,int& nValue,CString strTip);
	//##ModelId=44B6F88703C9
	CString m_strError;
	//##ModelId=44B6F88703CA
	int WriteLog(CString strNote);
	//##ModelId=44B6F88703CC
	int WriteCheckData(int nSVMID,CString strSVMPSort, int nSVDID , CString strSpotSort,float fValue);
	//##ModelId=44B6F88703DC
	void ErrorTrans(WORD dwErro) ;
	//##ModelId=44B6F88703DE
	int WriteAlarm(int nSVMID, int nPortType, CString nPortName,CString strEQAddr,CString strEQName,int nSVDID, CString strSpotSort,int nALevel,CString  strAStartTime,CString strAEndTime,CString strANote,int  nAState,float fAValue,CString strAMemo);
	//##ModelId=44B6F8880015
	int WriteCommRd(CString strTime,int nResult,int nType,CString strAddr,CString strNote,CString strData,CString strSource,CString strMemo);
	//##ModelId=44B6F8880025
	int GetRdData(CString Name,_RecordsetPtr& pRsPtr,_variant_t& var,CString strTip);
	//##ModelId=44B6F8880032
	BOOL ExecuteSQL(CString strSQL);
	//##ModelId=44B6F8880034
	int ReadDB(CString strSQL , _RecordsetPtr& pRsPtr,CString strTip);
	//##ModelId=44B6F8880041
	int CloseDB();
	//##ModelId=44B6F8880042
	BOOL InitDB();
	//##ModelId=44B6F888004E
	CAdoDB();
	//##ModelId=44B6F888004F
	virtual ~CAdoDB();
	//##ModelId=44B6F8880052
	_ConnectionPtr m_ConPtr ;
	//##ModelId=44B6F8880056
	BOOL m_bIsConnect;
	//##ModelId=44B6F888005D
	HANDLE hEvent ;
protected:
	//##ModelId=44B6F888005E
	BOOL Connect(CBaseInfo baseinfo);
public:
	// 初始化数据库连接
	//##ModelId=44B6F888006D
	BOOL InitDB(CBaseInfo baseinfo);
	// 存储原始数据包内容
	//##ModelId=44B6F888006F
	int WriteCommRd(CInfoFrame frame);
	// 取得字段的值
	BOOL GetFieldValue(const CString strField, _RecordsetPtr& pRsPtr, int & iValue);
	BOOL GetFieldValue(const CString strField, _RecordsetPtr& pRsPtr, double & iValue);
	BOOL GetFieldValue(const CString strField, _RecordsetPtr& pRsPtr, CString & iValue);
};

#endif // !defined(AFX_ADODB_H__8C8C56FD_6ED2_40FA_B0CF_7147CD8ECCFA__INCLUDED_)