StaffInfo.cpp 3.6 KB

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