#pragma once
#include "sqlite3.h"
#include "CPanel.h"
#include <list>

class CGB2860SQLite
{
public:
	CGB2860SQLite();
	~CGB2860SQLite();

public:
	void setDbFilepath(const char* pszFilepath);
	int init(std::string& strError);
	int term();
	int insertPanel(CPanel* pPanel, std::string& strError);
	int getPanelList(const char* pszKeyword, int nSearchFlag,
		int dtFlag, const char* pszStartTime, const char* pszEndTime,
		std::list<CPanel*>& list, std::string& strError);
	int getPanelWithPanelId(const char* pszPanelId, CPanel*& pPanel, std::string& strError);

private:
	std::string m_strDbFilepath;
	sqlite3* m_db;
};