ParticleSTDTable.cpp 3.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119
  1. #include "stdafx.h"
  2. #include "ParticleSTDTable.h"
  3. #include "../myDBConst.h"
  4. namespace OTSClassifyEngine
  5. {
  6. using namespace OTSSQLITE;
  7. void CParticleSTDTable::AddColumn(ColumnDefine col)
  8. {
  9. return myTable->AddColumn(col);
  10. }
  11. int CParticleSTDTable::GetColumnCount()
  12. {
  13. return myTable->GetColumnCount();
  14. }
  15. CString CParticleSTDTable::GetTableName()
  16. {
  17. return myTable->GetTableName();
  18. }
  19. void CParticleSTDTable::SetTableName(LPCTSTR a_sTableName)
  20. {
  21. return myTable->SetTableName(a_sTableName);
  22. }
  23. CString CParticleSTDTable::GetColumnName(const int a_nColId)
  24. {
  25. return myTable->GetColumnName(a_nColId);
  26. }
  27. CString CParticleSTDTable::GetColumnFullName(const int a_nColId)
  28. {
  29. return myTable->GetColumnFullName(a_nColId);
  30. }
  31. CString CParticleSTDTable::GetColumnNames(const BOOL a_bWithPrimary /*= TRUE*/)
  32. {
  33. return myTable->GetColumnNames(a_bWithPrimary);
  34. }
  35. CString CParticleSTDTable::GetColumnFullNames(const BOOL a_bWithPrimary /*= TRUE*/)
  36. {
  37. return myTable->GetColumnFullNames(a_bWithPrimary);
  38. }
  39. OTSSQLITE::ColumnType CParticleSTDTable::GetColumnType(const int a_nColId)
  40. {
  41. return myTable->GetColumnType(a_nColId);
  42. }
  43. CString CParticleSTDTable::GetCreateTableCommandString()
  44. {
  45. return myTable->GetCreateTableCommandString();
  46. }
  47. CString CParticleSTDTable::GetDeleteTableCommandString()
  48. {
  49. return myTable->GetDeleteTableCommandString();
  50. }
  51. CString CParticleSTDTable::GetRemoveAllRowsCommandString()
  52. {
  53. return myTable->GetRemoveAllRowsCommandString();
  54. }
  55. CString CParticleSTDTable::GetInsertCommandFormatString(const BOOL a_bWithPrimary /*= FALSE*/)
  56. {
  57. return myTable->GetInsertCommandFormatString(a_bWithPrimary);
  58. }
  59. CString CParticleSTDTable::GetInsertCommandFormatString(std::vector<int>& a_colIndexes)
  60. {
  61. return myTable->GetInsertCommandFormatString(a_colIndexes);
  62. }
  63. CString CParticleSTDTable::GetUpdateCommandFormatString(std::vector<int>& a_updateColIndexes, const int a_nConditionColIndex)
  64. {
  65. return myTable->GetUpdateCommandFormatString(a_updateColIndexes, a_nConditionColIndex);
  66. }
  67. CParticleSTDTable::CParticleSTDTable()
  68. {
  69. myTable = CreateNewSQLiteTable();
  70. //m_listcolumnDefines.clear();
  71. myTable->AddColumn(std::make_pair(_T("STDId"), ColumnType(ColumnType::ID::INT, TRUE)));
  72. myTable->AddColumn(std::make_pair(_T("StrName"), ColumnType(ColumnType::ID::STRING)));
  73. myTable->AddColumn(std::make_pair(_T("Color"), ColumnType::ID::STRING));
  74. myTable->AddColumn(std::make_pair(_T("KeyElementList"), ColumnType::ID::STRING));
  75. myTable->AddColumn(std::make_pair(_T("SubElementList"), ColumnType::ID::STRING));
  76. myTable->AddColumn(std::make_pair(_T("UsingImgPropertyList"), ColumnType::ID::STRING));
  77. myTable->AddColumn(std::make_pair(_T("UsingOtherPropertyList"), ColumnType::ID::STRING));
  78. myTable->AddColumn(std::make_pair(_T("Expression"), ColumnType(ColumnType::ID::STRING)));
  79. myTable->AddColumn(std::make_pair(_T("Hardness"), ColumnType(ColumnType::ID::FLOAT)));
  80. myTable->AddColumn(std::make_pair(_T("Density"), ColumnType::ID::FLOAT));
  81. myTable->AddColumn(std::make_pair(_T("Electrical_conductivity"), ColumnType::ID::FLOAT));
  82. myTable->AddColumn(std::make_pair(_T("BSE"), ColumnType::ID::INT));
  83. myTable->AddColumn(std::make_pair(_T("Formula"), ColumnType::ID::STRING));
  84. myTable->AddColumn(std::make_pair(_T("Element"), ColumnType::ID::STRING));
  85. myTable->AddColumn(std::make_pair(_T("IfElementAnalysis"), ColumnType::ID::INT));
  86. myTable->AddColumn(std::make_pair(_T("ListNum"), ColumnType::ID::INT));
  87. myTable->AddColumn(std::make_pair(_T("GroupId"), ColumnType::ID::INT));
  88. ASSERT(myTable->GetColumnCount() == ((int)ColumnID::MAX - (int)ColumnID::MIN) + 1);
  89. SetTableName(g_sParticleSTDLib);
  90. }
  91. CParticleSTDTable::~CParticleSTDTable()
  92. {
  93. }
  94. }