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

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

		/*PartSTDItemPtr GetSTDItemById(const long a_nIncAId);
		PartSTDItemList& 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;

		

		ParticleSTDPtr GetPartSTDLib(ParticleSTDPtr partStd, BOOL bForce/* = FALSE*/);
	protected:
		
		PartSTDItemList ReadParticleSTDList(CDBQueryBasePtr a_query);
		BOOL ReadParticleSTDItem(CDBQueryBasePtr a_query);

		/*BOOL ReadSTDItemList();
		CDBQueryBasePtr GetQueryById(const long a_nIncAId);*/

	protected:
		CDBTableBasePtr m_tableInfo;
		PartSTDItemPtr m_pSTDItem;
		PartSTDItemList m_listSTDItem;
	private:
		CDBBasePtr myDB;
	};

	typedef std::shared_ptr<CParticleSTDDB>  __declspec(dllexport) CParticleSTDDBPtr;
}