TableVersion.cpp 5.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166
  1. // TableVersion.h : CTableVersion 类的实现
  2. // CTableVersion 实现
  3. // 代码生成在 2014年9月24日, 17:54
  4. #include "stdafx.h"
  5. #include "TableVersion.h"
  6. IMPLEMENT_DYNAMIC(CTableVersion, CRecordset)
  7. CTableVersion::CTableVersion(CDatabase* pdb): CRecordset(pdb)
  8. {
  9. m_version = L"";
  10. m_msgaccount = L"";
  11. m_msgpsw = L"";
  12. m_msgused = L"";
  13. m_msgbalance = L"";
  14. m_msgcheck1 = L"";
  15. m_msgcheck2 = L"";
  16. m_msgdays1 = L"";
  17. m_msgdays2 = L"";
  18. m_msgcontent1 = L"";
  19. m_msgcontent2 = L"";
  20. m_msgcheck3 = L"";
  21. m_msgcontent3 = L"";
  22. m_msgcheck4 = L"";
  23. m_msgtime = L"";
  24. m_msgphones = L"";
  25. m_msgcompanyname = L"";
  26. m_msgphones2 = L"";
  27. m_msgsendtype = L"";
  28. m_msgcontent5 = L"";
  29. m_msgcheck5 = L"";
  30. m_msgcontent6 = L"";
  31. m_msgcheck6 = L"";
  32. m_msgcheck7 = L"";
  33. m_msgcheck8 = L"";
  34. m_msgcheck9 = L"";
  35. m_msgcheck10 = L"";
  36. m_msgcontent8 = L"";
  37. m_msgcontent9 = L"";
  38. m_msgcontent10 = L"";
  39. m_msgcheck11 = L"";
  40. m_msgcheck12 = L"";
  41. m_msgcheck13 = L"";
  42. m_msgcheck14 = L"";
  43. m_msgcontent11 = L"";
  44. m_msgcontent12 = L"";
  45. m_msgcontent13 = L"";
  46. m_msgcontent14 = L"";
  47. m_msgcheck15 = L"";
  48. m_msgcontent15 = L"";
  49. m_msgcheck16 = L"";
  50. m_hospitalmsgcheck1 = L"";
  51. m_hospitalmsgcheck2 = L"";
  52. m_msgcheck17 = L"";
  53. m_msgcontent17 = L"";
  54. m_nFields = 45;
  55. //m_nDefaultType = dynaset;
  56. m_bBindType = 0;
  57. m_nDefaultType = forwardOnly;
  58. }
  59. //#error 安全问题:连接字符串可能包含密码。
  60. // 此连接字符串中可能包含明文密码和/或其他重要
  61. // 信息。请在查看完此连接字符串并找到所有与安全
  62. // 有关的问题后移除 #error。可能需要将此密码存
  63. // 储为其他格式或使用其他的用户身份验证。
  64. CString CTableVersion::GetDefaultConnect()
  65. {
  66. return _T("ODBC;DSN");
  67. }
  68. CString CTableVersion::GetDefaultSQL()
  69. {
  70. return _T("[dbo].[version]");
  71. }
  72. void CTableVersion::DoFieldExchange(CFieldExchange* pFX)
  73. {
  74. pFX->SetFieldType(CFieldExchange::outputColumn);
  75. // RFX_Text() 和 RFX_Int() 这类宏依赖的是
  76. // 成员变量的类型,而不是数据库字段的类型。
  77. // ODBC 尝试自动将列值转换为所请求的类型
  78. if (m_bBindType)
  79. {
  80. m_nFields = m_listName.GetCount();
  81. for (POSITION psNameIndex = m_listName.GetHeadPosition(), psValueIndex = m_listValue.GetHeadPosition(); NULL != psNameIndex, NULL != psValueIndex;)
  82. {
  83. RFX_Text(pFX, m_listName.GetNext(psNameIndex), m_listValue.GetNext(psValueIndex));
  84. }
  85. }
  86. else
  87. {
  88. RFX_Text(pFX, _T("[version]"), m_version);
  89. RFX_Text(pFX, _T("[msgaccount]"), m_msgaccount);
  90. RFX_Text(pFX, _T("[msgpsw]"), m_msgpsw);
  91. RFX_Text(pFX, _T("[msgused]"), m_msgused);
  92. RFX_Text(pFX, _T("[msgbalance]"), m_msgbalance);
  93. RFX_Text(pFX, _T("[msgcheck1]"), m_msgcheck1);
  94. RFX_Text(pFX, _T("[msgcheck2]"), m_msgcheck2);
  95. RFX_Text(pFX, _T("[msgdays1]"), m_msgdays1);
  96. RFX_Text(pFX, _T("[msgdays2]"), m_msgdays2);
  97. RFX_Text(pFX, _T("[msgcontent1]"), m_msgcontent1, 4096);
  98. RFX_Text(pFX, _T("[msgcontent2]"), m_msgcontent2, 4096);
  99. RFX_Text(pFX, _T("[msgcheck3]"), m_msgcheck3);
  100. RFX_Text(pFX, _T("[msgcontent3]"), m_msgcontent3, 4096);
  101. RFX_Text(pFX, _T("[msgcheck4]"), m_msgcheck4);
  102. RFX_Text(pFX, _T("[msgtime]"), m_msgtime);
  103. RFX_Text(pFX, _T("[msgphones]"), m_msgphones, 4096);
  104. RFX_Text(pFX, _T("[msgcompanyname]"), m_msgcompanyname);
  105. RFX_Text(pFX, _T("[msgphones2]"), m_msgphones2, 4096);
  106. RFX_Text(pFX, _T("[msgsendtype]"), m_msgsendtype);
  107. RFX_Text(pFX, _T("[msgcontent5]"), m_msgcontent5, 4096);
  108. RFX_Text(pFX, _T("[msgcheck5]"), m_msgcheck5);
  109. RFX_Text(pFX, _T("[msgcontent6]"), m_msgcontent6, 4096);
  110. RFX_Text(pFX, _T("[msgcheck6]"), m_msgcheck6);
  111. RFX_Text(pFX, _T("[msgcheck7]"), m_msgcheck7);
  112. RFX_Text(pFX, _T("[msgcheck8]"), m_msgcheck8);
  113. RFX_Text(pFX, _T("[msgcheck9]"), m_msgcheck9);
  114. RFX_Text(pFX, _T("[msgcheck10]"), m_msgcheck10);
  115. RFX_Text(pFX, _T("[msgcontent8]"), m_msgcontent8, 4096);
  116. RFX_Text(pFX, _T("[msgcontent9]"), m_msgcontent9, 4096);
  117. RFX_Text(pFX, _T("[msgcontent10]"), m_msgcontent10, 4096);
  118. RFX_Text(pFX, _T("[msgcheck11]"), m_msgcheck11);
  119. RFX_Text(pFX, _T("[msgcheck12]"), m_msgcheck12);
  120. RFX_Text(pFX, _T("[msgcheck13]"), m_msgcheck13);
  121. RFX_Text(pFX, _T("[msgcheck14]"), m_msgcheck14);
  122. RFX_Text(pFX, _T("[msgcontent11]"), m_msgcontent11, 4096);
  123. RFX_Text(pFX, _T("[msgcontent12]"), m_msgcontent12, 4096);
  124. RFX_Text(pFX, _T("[msgcontent13]"), m_msgcontent13, 4096);
  125. RFX_Text(pFX, _T("[msgcontent14]"), m_msgcontent14, 4096);
  126. RFX_Text(pFX, _T("[msgcheck15]"), m_msgcheck15);
  127. RFX_Text(pFX, _T("[msgcontent15]"), m_msgcontent15, 4096);
  128. RFX_Text(pFX, _T("[msgcheck16]"), m_msgcheck16);
  129. RFX_Text(pFX, _T("[hospitalmsgcheck1]"), m_hospitalmsgcheck1);
  130. RFX_Text(pFX, _T("[hospitalmsgcheck2]"), m_hospitalmsgcheck2);
  131. RFX_Text(pFX, _T("[msgcheck17]"), m_msgcheck17);
  132. RFX_Text(pFX, _T("[msgcontent17]"), m_msgcontent17);
  133. }
  134. }
  135. /////////////////////////////////////////////////////////////////////////////
  136. // CTableVersion 诊断
  137. #ifdef _DEBUG
  138. void CTableVersion::AssertValid() const
  139. {
  140. CRecordset::AssertValid();
  141. }
  142. void CTableVersion::Dump(CDumpContext& dc) const
  143. {
  144. CRecordset::Dump(dc);
  145. }
  146. #endif //_DEBUG
  147. void CTableVersion::AddElement(LPCTSTR lpFieldName, LPCTSTR lpFieldValue)
  148. {
  149. m_bBindType = TRUE;
  150. m_listName.AddTail(lpFieldName);
  151. m_listValue.AddTail(lpFieldValue);
  152. }