UserDetail.cpp 5.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211
  1. // UserDetail.h : CUserDetail 类的实现
  2. // CUserDetail 实现
  3. // 代码生成在 2016年9月21日, 9:55
  4. #include "stdafx.h"
  5. #include "UserDetail.h"
  6. IMPLEMENT_DYNAMIC(CUserDetail, CRecordset)
  7. CUserDetail::CUserDetail(CDatabase* pdb): CRecordset(pdb)
  8. {
  9. m_StudioID = _T("");
  10. m_UserAccount = _T("");
  11. m_UserPassword = _T("");
  12. m_UserNickName = _T("");
  13. m_UserLevel = 0;
  14. m_UserRights = _T("");
  15. m_UserOnelineStatus = 0;
  16. m_UserEnable = FALSE;
  17. m_StaffSN = _T("");
  18. m_StaffName = _T("");
  19. m_StaffGender = FALSE;
  20. m_StaffAddress = _T("");
  21. m_StaffOffice = _T("");
  22. m_StaffBirthday = _T("");
  23. m_StaffPhone = _T("");
  24. m_StaffStatus = 0;
  25. m_StaffNote = _T("");
  26. m_nFields = 17;
  27. m_nDefaultType = dynaset;
  28. }
  29. //#error 安全问题:连接字符串可能包含密码。
  30. // 此连接字符串中可能包含明文密码和/或其他重要
  31. // 信息。请在查看完此连接字符串并找到所有与安全
  32. // 有关的问题后移除 #error。可能需要将此密码存
  33. // 储为其他格式或使用其他的用户身份验证。
  34. CString CUserDetail::GetDefaultConnect()
  35. {
  36. return _T("DSN=EasySelection;Description=EasySelection;UID=sa;PWD=ly1234;APP=Microsoft\x00ae Visual Studio\x00ae 2010;WSID=IT-PC;DATABASE=EasySelection;");
  37. }
  38. CString CUserDetail::GetDefaultSQL()
  39. {
  40. return _T("[dbo].[UserDetail]");
  41. }
  42. void CUserDetail::DoFieldExchange(CFieldExchange* pFX)
  43. {
  44. pFX->SetFieldType(CFieldExchange::outputColumn);
  45. // RFX_Text() 和 RFX_Int() 这类宏依赖的是
  46. // 成员变量的类型,而不是数据库字段的类型。
  47. // ODBC 尝试自动将列值转换为所请求的类型
  48. RFX_Text(pFX, _T("[StudioID]"), m_StudioID);
  49. RFX_Text(pFX, _T("[UserAccount]"), m_UserAccount);
  50. RFX_Text(pFX, _T("[UserPassword]"), m_UserPassword);
  51. RFX_Text(pFX, _T("[UserNickName]"), m_UserNickName);
  52. RFX_Byte(pFX, _T("[UserLevel]"), m_UserLevel);
  53. RFX_Text(pFX, _T("[UserRights]"), m_UserRights);
  54. RFX_Byte(pFX, _T("[UserOnelineStatus]"), m_UserOnelineStatus);
  55. RFX_Bool(pFX, _T("[UserEnable]"), m_UserEnable);
  56. RFX_Text(pFX, _T("[StaffSN]"), m_StaffSN);
  57. RFX_Text(pFX, _T("[StaffName]"), m_StaffName);
  58. RFX_Bool(pFX, _T("[StaffGender]"), m_StaffGender);
  59. RFX_Text(pFX, _T("[StaffAddress]"), m_StaffAddress);
  60. RFX_Text(pFX, _T("[StaffOffice]"), m_StaffOffice);
  61. RFX_Text(pFX, _T("[StaffBirthday]"), m_StaffBirthday);
  62. RFX_Text(pFX, _T("[StaffPhone]"), m_StaffPhone);
  63. RFX_Byte(pFX, _T("[StaffStatus]"), m_StaffStatus);
  64. RFX_Text(pFX, _T("[StaffNote]"), m_StaffNote);
  65. }
  66. /////////////////////////////////////////////////////////////////////////////
  67. // CUserDetail 诊断
  68. #ifdef _DEBUG
  69. void CUserDetail::AssertValid() const
  70. {
  71. CRecordset::AssertValid();
  72. }
  73. void CUserDetail::Dump(CDumpContext& dc) const
  74. {
  75. CRecordset::Dump(dc);
  76. }
  77. #endif //_DEBUG
  78. CUserDetail& CUserDetail::operator=(const CUserDetail& member)
  79. {
  80. m_StudioID = member.m_StudioID;
  81. m_UserAccount = member.m_UserAccount;
  82. m_UserPassword = member.m_UserPassword;
  83. m_UserNickName = member.m_UserNickName;
  84. m_UserLevel = member.m_UserLevel;
  85. m_UserRights = member.m_UserRights;
  86. m_UserOnelineStatus = member.m_UserOnelineStatus;
  87. m_UserEnable = member.m_UserEnable;
  88. m_StaffSN = member.m_StaffSN;
  89. m_StaffName = member.m_StaffName;
  90. m_StaffGender = member.m_StaffGender;
  91. m_StaffAddress = member.m_StaffAddress;
  92. m_StaffOffice = member.m_StaffOffice;
  93. m_StaffBirthday = member.m_StaffBirthday;
  94. m_StaffPhone = member.m_StaffPhone;
  95. m_StaffStatus = member.m_StaffStatus;
  96. m_StaffNote = member.m_StaffNote;
  97. return *this;
  98. }
  99. //////////////////////////////////////////////////////////////////////////
  100. IMPLEMENT_SERIAL(CUserDetailObj, CObject, 0)
  101. CUserDetailObj::CUserDetailObj()
  102. {
  103. m_StudioID = _T("");
  104. m_UserAccount = _T("");
  105. m_UserPassword = _T("");
  106. m_UserNickName = _T("");
  107. m_UserLevel = 0;
  108. m_UserRights = _T("");
  109. m_UserOnelineStatus = 0;
  110. m_UserEnable = FALSE;
  111. m_StaffSN = _T("");
  112. m_StaffName = _T("");
  113. m_StaffGender = FALSE;
  114. m_StaffAddress = _T("");
  115. m_StaffOffice = _T("");
  116. m_StaffBirthday = _T("");
  117. m_StaffPhone = _T("");
  118. m_StaffStatus = 0;
  119. m_StaffNote = _T("");
  120. }
  121. CUserDetailObj& CUserDetailObj::operator=(const CUserDetailObj& member)
  122. {
  123. m_StudioID = member.m_StudioID;
  124. m_UserAccount = member.m_UserAccount;
  125. m_UserPassword = member.m_UserPassword;
  126. m_UserNickName = member.m_UserNickName;
  127. m_UserLevel = member.m_UserLevel;
  128. m_UserRights = member.m_UserRights;
  129. m_UserOnelineStatus = member.m_UserOnelineStatus;
  130. m_UserEnable = member.m_UserEnable;
  131. m_StaffSN = member.m_StaffSN;
  132. m_StaffName = member.m_StaffName;
  133. m_StaffGender = member.m_StaffGender;
  134. m_StaffAddress = member.m_StaffAddress;
  135. m_StaffOffice = member.m_StaffOffice;
  136. m_StaffBirthday = member.m_StaffBirthday;
  137. m_StaffPhone = member.m_StaffPhone;
  138. m_StaffStatus = member.m_StaffStatus;
  139. m_StaffNote = member.m_StaffNote;
  140. return *this;
  141. }
  142. void CUserDetailObj::Serialize(CArchive& ar)
  143. {
  144. try
  145. {
  146. CObject::Serialize(ar);
  147. if (ar.IsStoring())
  148. {
  149. ar << m_StudioID;
  150. ar << m_UserAccount;
  151. ar << m_UserPassword;
  152. ar << m_UserNickName;
  153. ar << m_UserLevel;
  154. ar << m_UserRights;
  155. ar << m_UserOnelineStatus;
  156. ar << m_UserEnable;
  157. ar << m_StaffSN;
  158. ar << m_StaffName;
  159. ar << m_StaffGender;
  160. ar << m_StaffAddress;
  161. ar << m_StaffOffice;
  162. ar << m_StaffBirthday;
  163. ar << m_StaffPhone;
  164. ar << m_StaffStatus;
  165. ar << m_StaffNote;
  166. }
  167. else
  168. {
  169. ar >> m_StudioID;
  170. ar >> m_UserAccount;
  171. ar >> m_UserPassword;
  172. ar >> m_UserNickName;
  173. ar >> m_UserLevel;
  174. ar >> m_UserRights;
  175. ar >> m_UserOnelineStatus;
  176. ar >> m_UserEnable;
  177. ar >> m_StaffSN;
  178. ar >> m_StaffName;
  179. ar >> m_StaffGender;
  180. ar >> m_StaffAddress;
  181. ar >> m_StaffOffice;
  182. ar >> m_StaffBirthday;
  183. ar >> m_StaffPhone;
  184. ar >> m_StaffStatus;
  185. ar >> m_StaffNote;
  186. }
  187. }
  188. catch (CMemoryException* e)
  189. {
  190. #if _DEBUG
  191. e->ReportError();
  192. #endif
  193. }
  194. }