PackageItemView.cpp 3.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144
  1. // PackageItemView.h : CPackageItemView 类的实现
  2. // CPackageItemView 实现
  3. // 代码生成在 2016年11月11日, 14:28
  4. #include "stdafx.h"
  5. #include "PackageItemView.h"
  6. IMPLEMENT_DYNAMIC(CPackageItemView, CRecordset)
  7. CPackageItemView::CPackageItemView(CDatabase* pdb)
  8. : CRecordset(pdb)
  9. {
  10. m_StudioID = _T("");
  11. m_ItemType = "";
  12. m_ItemSubType = _T("");
  13. m_ItemSN = _T("");
  14. m_ItemName = _T("");
  15. m_ItemCost = 0.0;
  16. m_ItemSales = 0.0;
  17. m_ItemShelves = FALSE;
  18. m_ItemNote = _T("");
  19. m_nFields = 9;
  20. m_nDefaultType = dynaset;
  21. }
  22. //#error 安全问题: 连接字符串可能包含密码。
  23. // 此连接字符串中可能包含明文密码和/或其他重要
  24. // 信息。请在查看完此连接字符串并找到所有与安全
  25. // 有关的问题后移除 #error。可能需要将此密码存
  26. // 储为其他格式或使用其他的用户身份验证。
  27. CString CPackageItemView::GetDefaultConnect()
  28. {
  29. return _T("DSN=EasySelection;UID=sa;PWD=ly1234;APP=Microsoft\x00ae Visual Studio\x00ae 2015;WSID=IT-PC;DATABASE=EasySelection;");
  30. }
  31. CString CPackageItemView::GetDefaultSQL()
  32. {
  33. return _T("[dbo].[PackageItemView]");
  34. }
  35. void CPackageItemView::DoFieldExchange(CFieldExchange* pFX)
  36. {
  37. pFX->SetFieldType(CFieldExchange::outputColumn);
  38. // RFX_Text() 和 RFX_Int() 这类宏依赖的是
  39. // 成员变量的类型,而不是数据库字段的类型。
  40. // ODBC 尝试自动将列值转换为所请求的类型
  41. RFX_Text(pFX, _T("[StudioID]"), m_StudioID);
  42. RFX_Text(pFX, _T("[ItemType]"), m_ItemType);
  43. RFX_Text(pFX, _T("[ItemSubType]"), m_ItemSubType);
  44. RFX_Text(pFX, _T("[ItemSN]"), m_ItemSN);
  45. RFX_Text(pFX, _T("[ItemName]"), m_ItemName);
  46. RFX_Double(pFX, _T("[ItemCost]"), m_ItemCost);
  47. RFX_Double(pFX, _T("[ItemSales]"), m_ItemSales);
  48. RFX_Bool(pFX, _T("[ItemShelves]"), m_ItemShelves);
  49. RFX_Text(pFX, _T("[ItemNote]"), m_ItemNote);
  50. }
  51. /////////////////////////////////////////////////////////////////////////////
  52. // CPackageItemView 诊断
  53. #ifdef _DEBUG
  54. void CPackageItemView::AssertValid() const
  55. {
  56. CRecordset::AssertValid();
  57. }
  58. void CPackageItemView::Dump(CDumpContext& dc) const
  59. {
  60. CRecordset::Dump(dc);
  61. }
  62. #endif //_DEBUG
  63. //////////////////////////////////////////////////////////////////////////
  64. IMPLEMENT_SERIAL(CPackageItemViewObj, CObject, 0)
  65. CPackageItemViewObj::CPackageItemViewObj()
  66. {
  67. m_StudioID = _T("");
  68. m_ItemType = _T("");
  69. m_ItemSubType = _T("");
  70. m_ItemSN = _T("");
  71. m_ItemName = _T("");
  72. m_ItemCost = 0.0;
  73. m_ItemSales = 0.0;
  74. m_ItemShelves = FALSE;
  75. m_ItemNote = _T("");
  76. }
  77. CPackageItemViewObj& CPackageItemViewObj::operator=(const CPackageItemViewObj& member)
  78. {
  79. m_StudioID = member.m_StudioID;
  80. m_ItemType = member.m_ItemType;
  81. m_ItemSubType = member.m_ItemSubType;
  82. m_ItemSN = member.m_ItemSN;
  83. m_ItemName = member.m_ItemName;
  84. m_ItemCost = member.m_ItemCost;
  85. m_ItemSales = member.m_ItemSales;
  86. m_ItemShelves = member.m_ItemShelves;
  87. m_ItemNote = member.m_ItemNote;
  88. return *this;
  89. }
  90. void CPackageItemViewObj::Serialize(CArchive& ar)
  91. {
  92. try
  93. {
  94. CObject::Serialize(ar);
  95. if (ar.IsStoring())
  96. {
  97. ar << m_StudioID;
  98. ar << m_ItemType;
  99. ar << m_ItemSubType;
  100. ar << m_ItemSN;
  101. ar << m_ItemName;
  102. ar << m_ItemCost;
  103. ar << m_ItemSales;
  104. ar << m_ItemShelves;
  105. ar << m_ItemNote;
  106. }
  107. else
  108. {
  109. ar >> m_StudioID;
  110. ar >> m_ItemType;
  111. ar >> m_ItemSubType;
  112. ar >> m_ItemSN;
  113. ar >> m_ItemName;
  114. ar >> m_ItemCost;
  115. ar >> m_ItemSales;
  116. ar >> m_ItemShelves;
  117. ar >> m_ItemNote;
  118. }
  119. }
  120. catch (CMemoryException* e)
  121. {
  122. #if _DEBUG
  123. e->ReportError();
  124. #endif
  125. }
  126. }