STDGroupTable.cpp 2.5 KB

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