#pragma once
#include "DBTableBase.h"
namespace OTSClassifyEngine
{
	using namespace OTSSQLITE;
	class CParticleSTDTable : public CDBTableBase
	{
	public:
		enum class ColumnID
		{
			INVALID = -1,
			MIN = 0,
			N_STDId = 0,
			S_StrName = 1,
			S_COLOR = 2,
			S_KeyElementList = 3,
			S_SubElementList = 4,
			S_UsingImgPropertyList = 5,
			S_UsingOtherPropertyList = 6,
			S_Expression = 7,
			S_Hardness = 8,
			S_Density = 9,
			S_Electrical_conductivity = 10,
			N_BSE = 11,
			S_Formula = 12,
			S_Element = 13,
			B_IsElementAnalysis=14,
			N_ListNum = 15,
	        N_GroupId=16,
			MAX = 16
		};

		virtual void AddColumn(ColumnDefine col) override;


		virtual int GetColumnCount() override;


		virtual CString GetTableName() override;


		virtual void SetTableName(LPCTSTR a_sTableName) override;


		virtual CString GetColumnName(const int a_nColId) override;


		virtual CString GetColumnFullName(const int a_nColId) override;


		virtual CString GetColumnNames(const BOOL a_bWithPrimary = TRUE) override;


		virtual CString GetColumnFullNames(const BOOL a_bWithPrimary = TRUE) override;


		virtual ColumnType GetColumnType(const int a_nColId) override;


		virtual CString GetCreateTableCommandString() override;


		virtual CString GetDeleteTableCommandString() override;


		virtual CString GetRemoveAllRowsCommandString() override;


		virtual CString GetInsertCommandFormatString(const BOOL a_bWithPrimary = FALSE) override;


		virtual CString GetInsertCommandFormatString(std::vector<int>& a_colIndexes) override;


		virtual CString GetUpdateCommandFormatString(std::vector<int>& a_updateColIndexes, const int a_nConditionColIndex) override;

	public:
		CParticleSTDTable();
		~CParticleSTDTable();
	private:
		CDBTableBasePtr myTable;
	};
}