adodb.h

MDF监控源码2

// 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_
#include <comutil.h>
#if _MSC_VER > 1000
#pragma once
#endif // _MSC_VER > 1000
#define RS_MAX 20



//##ModelId=465286A5029F
class  _declspec(dllimport) CAdoDB  
{
public:
	//##ModelId=465286A502AF
	BOOL ExecuteDB(CString strNote);
	//##ModelId=465286A502BF
	BOOL GetConnectState();
	//##ModelId=465286A502C0
	int GetDoubleVar(_variant_t var,double& dValue,CString strTip);
	
	//##ModelId=465286A502CF
	CString m_strIp ;
	//##ModelId=465286A502D0
	CString m_strUserId ;
	//##ModelId=465286A502D1
	CString m_strPassWord ;
	//##ModelId=465286A502DE
	int GetStrVar(_variant_t var,CString& strValue,CString strTip);
	//##ModelId=465286A502EE
	int GetIntVar(_variant_t var,int& nValue,CString strTip);
	//##ModelId=465286A502FE
	CString m_strError;
	//##ModelId=465286A502FF
	int WriteLog(CString strNote);
	//##ModelId=465286A5030E
	int WriteCheckData(int nSVMID,CString strSVMPSort, int nSVDID , CString strSpotSort,float fValue);
	//##ModelId=465286A5032C
	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=465286A5035D
	int WriteCommRd(CString strTime,int nResult,int nType,CString strAddr,CString strNote,CString strData,CString strSource,CString strMemo);
	//##ModelId=465286A5037D
	int GetRdData(CString Name,_RecordsetPtr& pRsPtr,_variant_t& var,CString strTip);
	//##ModelId=465286A5038D
	BOOL ExecuteSQL(CString strSQL);
	//##ModelId=465286A5039A
	int ReadDB(CString strSQL , _RecordsetPtr& pRsPtr,CString strTip);
	//##ModelId=465286A503A9
	int CloseDB();
	//##ModelId=465286A503AA
	BOOL InitDB(LPCTSTR m_servername,LPCTSTR m_dbname,LPCTSTR m_username,LPCTSTR m_password );
	//##ModelId=465286A503B9
	CAdoDB();
	//##ModelId=465286A503BA
	virtual ~CAdoDB();
	//##ModelId=465286A503C9
	_ConnectionPtr m_ConPtr ;
	//##ModelId=465286A503CD
	BOOL m_bIsConnect;
	//##ModelId=465286A503D8
	HANDLE hEvent ;
protected:
	//##ModelId=465286A503D9
	BOOL Connect(CBaseInfo baseinfo);
public:
	// 初始化数据库连接
	//##ModelId=465286A60000
	BOOL InitDB(CBaseInfo baseinfo);
	// 存储原始数据包内容
	//##ModelId=465286A60002
	int WriteCommRd(CInfoFrame frame);
	// 取得字段的值
	BOOL GetFieldValue(const CString strField, _RecordsetPtr& pRsPtr,long & iValue);
	//##ModelId=465286A60010
	BOOL GetFieldValue(const CString strField, _RecordsetPtr& pRsPtr, int & iValue);
	//##ModelId=465286A60020
	BOOL GetFieldValue(const CString strField, _RecordsetPtr& pRsPtr, double & iValue);
	//##ModelId=465286A60024
	BOOL GetFieldValue(const CString strField, _RecordsetPtr& pRsPtr, CString & iValue);
	// 获得设备类别编码的ID
	long GetDeviceIDByCode(char* chCode);
	// 保存工频环告警数据
	//int WriteCircleAlarmInfo(long lDevID,CTime tmStart,CTime tmUpdate,long lSeconds,float fVoltage,float fCarrent,float fRate,int iLevel,CString strInfo);
};

#endif // !defined(AFX_ADODB_H__8C8C56FD_6ED2_40FA_B0CF_7147CD8ECCFA__INCLUDED_)