mineralgroupTable.cpp 2.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103
  1. #pragma once
  2. #include "stdafx.h"
  3. #include "mineralgroupTable.h"
  4. #include "../myDBConst.h"
  5. //#include "DBTable.h"
  6. using namespace OTSSQLITE;
  7. namespace OTSClassifyEngine
  8. {
  9. void CMineralGroupTable::AddColumn(ColumnDefine col)
  10. {
  11. return myTable->AddColumn(col);
  12. }
  13. int CMineralGroupTable::GetColumnCount()
  14. {
  15. return myTable->GetColumnCount();
  16. }
  17. CString CMineralGroupTable::GetTableName()
  18. {
  19. return myTable->GetTableName();
  20. }
  21. void CMineralGroupTable::SetTableName(LPCTSTR a_sTableName)
  22. {
  23. return myTable->SetTableName(a_sTableName);
  24. }
  25. CString CMineralGroupTable::GetColumnName(const int a_nColId)
  26. {
  27. return myTable->GetColumnName(a_nColId);
  28. }
  29. CString CMineralGroupTable::GetColumnFullName(const int a_nColId)
  30. {
  31. return myTable->GetColumnFullName(a_nColId);
  32. }
  33. CString CMineralGroupTable::GetColumnNames(const BOOL a_bWithPrimary /*= TRUE*/)
  34. {
  35. return myTable->GetColumnNames(a_bWithPrimary);
  36. }
  37. CString CMineralGroupTable::GetColumnFullNames(const BOOL a_bWithPrimary /*= TRUE*/)
  38. {
  39. return myTable->GetColumnFullNames(a_bWithPrimary);
  40. }
  41. OTSSQLITE::ColumnType CMineralGroupTable::GetColumnType(const int a_nColId)
  42. {
  43. return myTable->GetColumnType(a_nColId);
  44. }
  45. CString CMineralGroupTable::GetCreateTableCommandString()
  46. {
  47. return myTable->GetCreateTableCommandString();
  48. }
  49. CString CMineralGroupTable::GetDeleteTableCommandString()
  50. {
  51. return myTable->GetDeleteTableCommandString();
  52. }
  53. CString CMineralGroupTable::GetRemoveAllRowsCommandString()
  54. {
  55. return myTable->GetRemoveAllRowsCommandString();
  56. }
  57. CString CMineralGroupTable::GetInsertCommandFormatString(const BOOL a_bWithPrimary /*= FALSE*/)
  58. {
  59. return myTable->GetInsertCommandFormatString(a_bWithPrimary);
  60. }
  61. CString CMineralGroupTable::GetInsertCommandFormatString(std::vector<int>& a_colIndexes)
  62. {
  63. return myTable->GetInsertCommandFormatString(a_colIndexes);
  64. }
  65. CString CMineralGroupTable::GetUpdateCommandFormatString(std::vector<int>& a_updateColIndexes, const int a_nConditionColIndex)
  66. {
  67. return myTable->GetUpdateCommandFormatString(a_updateColIndexes, a_nConditionColIndex);
  68. }
  69. CMineralGroupTable::CMineralGroupTable()
  70. {
  71. /*m_listcolumnDefines.clear();*/
  72. myTable = CreateNewSQLiteTable();
  73. myTable->AddColumn(std::make_pair(_T("id"), ColumnType(ColumnType::ID::INT)));
  74. myTable->AddColumn(std::make_pair(_T("name"), ColumnType(ColumnType::ID::STRING)));
  75. myTable->AddColumn(std::make_pair(_T("color"), ColumnType(ColumnType::ID::INT)));
  76. myTable->AddColumn(std::make_pair(_T("iorder"), ColumnType(ColumnType::ID::INT)));
  77. ASSERT(myTable->GetColumnCount() == ((int)ColumnID::MAX - (int)ColumnID::MIN) + 1);
  78. SetTableName(g_sMineralGroupTableName);
  79. }
  80. CMineralGroupTable::~CMineralGroupTable()
  81. {
  82. }
  83. }