sqldatebase.h

用vc编写的视频采集端口编成

// SQLDatebase.h: interface for the CSQLDatebase class.
//
//////////////////////////////////////////////////////////////////////

#if !defined(AFX_SQLDATEBASE_H__5AC44895_C30A_11D5_BA01_52544CC01EF9__INCLUDED_)
#define AFX_SQLDATEBASE_H__5AC44895_C30A_11D5_BA01_52544CC01EF9__INCLUDED_

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

#include "interface.h"

class CChimneyInfo
{
	// the nChimneyID is relevant to certain camera, 
	// i.e. Camera 1 -> Chimney 1  doesn't means Camera 2 -> Chimney 1
public:
	int nChimneyID;
	int nCameraID;
	char lpszEnterpriseName[100];
	char lpszTelephoneNum[20];
};

class CTemplateInDatebase
{
public:
	int nChimneyID;
	int nCameraID;
	bool bSimple;
	CTemplateInfo TemplateInfo;
};

class CSQLDatebase  
{
private:
	char lpszServerName[30];
	char lpszHostName[30];
	char lpszUserName[30];
	char lpszPassword[30];
	char lpszDataBaseManagerPath[30];
	DWORD dwTimeLimit;
	char lpszTimeLimit[10];
public:
	CSQLDatebase();

	char* DBGetServerName(){return lpszServerName;}
	char* DBGetHostName(){return lpszHostName;}
	char* DBGetUserName(){return lpszUserName;}
	char* DBGetPassword(){return lpszPassword;}
	char* DBGetTimeLimit(){itoa(dwTimeLimit, lpszTimeLimit, 10);
			return lpszTimeLimit;}
	char* DBGetDBManager(){return lpszDataBaseManagerPath;}

	bool DBSetServerName(LPSTR lpstrServerName);
	bool DBSetHostName(LPSTR lpstrHostName);
	bool DBSetUserName(LPSTR lpstrUserName);
	bool DBSetPassword(LPSTR lpstrPassword);
	bool DBSetTimeLimit(LPSTR lpstrTimeLimit);
	bool DBSetDBManager(LPSTR lpstrDBManager);

	bool QueryDate(DBDATETIME* pDateTime);
	bool ReadResult(DBREAL* pdbrBlackness, char* lpstrImage, DWORD *dwImageSize);
	bool WriteResult(DBREAL db_rBlackness, char* lpstrImage, DWORD dwImageSize, int iObjectID, int nCameraID);
	bool SaveTemplateInfo(CTemplateInDatebase* tid);
	bool GetTemplateInfo(CTemplateInDatebase* tid);
	bool GetCmnInfoByID(CChimneyInfo* cmninfo);
	virtual ~CSQLDatebase();

};

#endif // !defined(AFX_SQLDATEBASE_H__5AC44895_C30A_11D5_BA01_52544CC01EF9__INCLUDED_)