#pragma once
#include "DBBase.h"
#include "STDItem.h"

namespace OTSSQLITE
{
	using namespace OTSSQLITE;
	using namespace OTSDATA;
	class  __declspec(dllexport) CSTDDataDB : public CDBBase
	{
	public:
		CSTDDataDB(CDBStoreBasePtr a_datastore);
		~CSTDDataDB();

		CSTDItemPtr GetSTDItemById(const long a_nIncAId);
		CSTDItemsList& GetSTDItemList(const BOOL a_bForce = FALSE);
		
		virtual CDBTableBasePtr GetTableInfo() override;


		virtual BOOL Init(const BOOL a_bClean = FALSE) override;


		virtual BOOL CreateTable(const BOOL a_bForce = FALSE) override;


		virtual BOOL DeleteTable() override;


		virtual BOOL RemoveAllRows() override;


		virtual BOOL IsDBExist() override;


		virtual CDBStoreBasePtr GetDatastore() override;


		virtual CDBQueryBasePtr GetTableQuery(LPCTSTR a_sOrderColumnName = nullptr) override;

	protected:
		BOOL ReadSTDItemList();
		CSTDItemsList ReadSTDItemList(CDBQueryBasePtr a_query);
		BOOL ReadSTDItem(CDBQueryBasePtr a_query);
		CDBQueryBasePtr GetQueryById(const long a_nIncAId);

	protected:
		CDBTableBasePtr m_tableInfo;
		CSTDItemPtr m_pSTDItem;
		CSTDItemsList m_listSTDItem;
	private:
		CDBBasePtr myDB;
	};

	typedef std::shared_ptr<CSTDDataDB>  __declspec(dllexport) CSTDDataDBPtr;
}