StringTable.h

#pragma once
#include "ic/ParaDatabase.h"
#include "DataProviderManager.h"

namespace ParaEngine
{
    struct stStringTableDbRecord
    {
        __int64 ID;
        string StringEnglish;
        string StringSimplifiedChinese;

        string Reserved1;
        string Reserved2;
        string Reserved3;
        string Reserved4;
        string Reserved5;
    };

    // Class Description: CStringTableDB contains all functions to access the string table database. 
    //      This is a singleton class. Call GetInstance() to use this class.
    class CStringTableDB
    {
    public:
        CStringTableDB(void);
        CStringTableDB(ParaInfoCenter::DBEntity* pDb);
        ~CStringTableDB(void);
    protected:
    private:

        ParaInfoCenter::DBEntity* m_pDataBase;

        CDBRecordSet* m_pProcSelectByID_EN;
        CDBRecordSet* m_pProcSelectByID_CN;

    public:
        bool GetStringbyID(string& sString, const __int64& ID);

        bool InsertString(stStringTableDbRecord& record);

        bool UpdateStringTable(const stStringTableDbRecord& record);

        bool DeleteEntryByID(const __int64& ID);

        void Cleanup();
    public:     
        static CStringTableDB & GetInstance();
        ParaInfoCenter::DBEntity* GetDBEntity();
        void SetDBEntity(ParaInfoCenter::DBEntity* pDb);

    public:
        // TODO: only for test
        void TestDB();
    };
}