dbinterface.h

视频播放控制器程序

// DBInterface.h: interface for the CDBInterface class.
//
//////////////////////////////////////////////////////////////////////

#if !defined(AFX_DBINTERFACE_H__FB400EB8_3FAD_44D7_A643_A290C8F9E9E2__INCLUDED_)
#define AFX_DBINTERFACE_H__FB400EB8_3FAD_44D7_A643_A290C8F9E9E2__INCLUDED_

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

#include "Mysqls/mysqlplus.h"
#include "Schedule.h"
#include "ListItem.h"

class CDBInterface  
{
public:
	CDBInterface();
	virtual ~CDBInterface();

	BOOL InitDatabase( LPCTSTR szName, LPCTSTR szHost, LPCTSTR szUser, LPCTSTR szPswd );
	BOOL GetAllSchedules( CMap<DWORD, DWORD, CSchedule*, CSchedule*> *pScheMap );
	CPlayItem* GetVidSrcs();
	CChannel* GetChannels();
	CChannel* GetChannelList();
	ExpertListItem* GetExpertList();
	VideoListItem * GetVideoList();
	WordListShowItem * GetScheWord(int n);
	NameListShowItem * GetScheName(int n);
	BOOL AddSchedule( CSchedule *pSche );
	BOOL RemoveSchedule( int nScheID );
	BOOL AddExpert( ExpertListItem *pItem );
	BOOL AddVidsrc(VideoListItem *pItem);
	BOOL RemoveVidsrc(int vID);
	BOOL RemoveExpertItem(CString nID);
	BOOL AddChannel(CChannel *pChannel);
	BOOL RemoveChannelItem(int cID);

	sql_connection_c* m_pConn;
	sql_query_c* m_pQuery;
	BOOL m_bConnected;
	CString m_strDBname;
	CString m_strDBhost;
	CString m_strDBuser;
	CString m_strDBpswd;
	int Str2Int( LPCTSTR szStr );
	CTime GetTimeFromString( LPCTSTR szTime );
};

#endif // !defined(AFX_DBINTERFACE_H__FB400EB8_3FAD_44D7_A643_A290C8F9E9E2__INCLUDED_)