Category

Development Platform
Home > SourceCode/Document > Applications > ERP-EIP-OA-Portal > View Code
Users.cpp
Package: final.rar　[view]
Upload User: fangwenmm
Upload Date: 2014-06-18
Package Size: 6955k
Code Size: 3k
Category:

ERP-EIP-OA-Portal

Development Platform:

Visual C++

Users.cpp：Code Content
  1. // Users.cpp: implementation of the CUsers class.
  2. //
  3. //////////////////////////////////////////////////////////////////////
  5. #include "stdafx.h"
  6. #include "Stock.h"
  7. #include "Users.h"
  8. #include "ADOConn.h"
  10. #ifdef _DEBUG
  11. #undef THIS_FILE
  12. static char THIS_FILE[]=__FILE__;
  13. #define new DEBUG_NEW
  14. #endif
  16. //////////////////////////////////////////////////////////////////////
  17. // Construction/Destruction
  18. //////////////////////////////////////////////////////////////////////
  20. CUsers::CUsers()
  21. {
  22. UserName = "";
  23. Pwd = "";
  24. User_type = 0;
  25. }
  27. CUsers::~CUsers()
  28. {
  30. }
  32. CString CUsers::GetUserName()
  33. {
  34. return UserName;
  35. }
  37. void CUsers::SetUserName(CString cUserName)
  38. {
  39. UserName = cUserName;
  40. }
  42. CString CUsers::GetPwd()
  43. {
  44. return Pwd;
  45. }
  47. void CUsers::SetPwd(CString cPwd)
  48. {
  49. Pwd = cPwd;
  50. }
  52. int CUsers::GetUser_type()
  53. {
  54. return User_type;
  55. }
  57. void CUsers::SetUser_type(int iUser_type)
  58. {
  59. User_type = iUser_type;
  60. }
  62. //数据库操作
  63. int CUsers::HaveName(CString cUserName)
  64. {
  65. //连接数据库
  66. ADOConn m_AdoConn;
  67. m_AdoConn.OnInitADOConn();
  68. //设置SELECT语句
  69. _bstr_t vSQL;
  70. vSQL = "SELECT * FROM Users WHERE UserName='" + cUserName + "'";
  72. //执行SELECT语句
  73. _RecordsetPtr m_pRecordset;
  74. m_pRecordset = m_AdoConn.GetRecordSet(vSQL);
  75. if (m_pRecordset->adoEOF)
  76. return -1;
  77. else
  78. return 1;
  80. //断开与数据库的连接
  81. m_AdoConn.ExitConnect();
  82. }
  85. void CUsers::sql_insert()
  86. {
  87. //连接数据库
  88. ADOConn m_AdoConn;
  89. m_AdoConn.OnInitADOConn();
  90. //设置INSERT语句
  91. CString strType;
  92. strType.Format("%d", User_type);
  94. _bstr_t vSQL;
  95. vSQL = "INSERT INTO Users VALUES('" + UserName + "','" + Pwd + "'," 
  96. + strType + ")";
  97. //执行INSERT语句
  98. m_AdoConn.ExecuteSQL(vSQL);
  99. //断开与数据库的连接
  100. m_AdoConn.ExitConnect();
  101. }
  103. void CUsers::sql_updatePwd(CString cUserName)
  104. {
  105. //连接数据库
  106. ADOConn m_AdoConn;
  107. m_AdoConn.OnInitADOConn();
  108. //设置UPDATE语句
  109. CString strType;
  110. strType.Format("%d", User_type);
  112. _bstr_t vSQL;
  113. vSQL = "UPDATE Users SET Pwd='" + Pwd + "' WHERE UserName='" + cUserName + "'";
  114. //执行UPDATE语句
  115. m_AdoConn.ExecuteSQL(vSQL);
  116. //断开与数据库的连接
  117. m_AdoConn.ExitConnect();
  118. }
  120. void CUsers::sql_delete(CString cUserName)
  121. {
  122. //连接数据库
  123. ADOConn m_AdoConn;
  124. m_AdoConn.OnInitADOConn();
  125. //设置DELETE语句
  126. _bstr_t vSQL;
  127. vSQL = "DELETE FROM Users WHERE UserName='" + cUserName + "'";
  128. //执行DELETE语句
  129. m_AdoConn.ExecuteSQL(vSQL);
  130. //断开与数据库的连接
  131. m_AdoConn.ExitConnect();
  132. }
  134. //根据员工编号读取所有字段值
  135. void CUsers::GetData(CString cUserName)
  136. {
  137. //连接数据库
  138. ADOConn m_AdoConn;
  139. m_AdoConn.OnInitADOConn();
  140. //设置SELECT语句
  141. _bstr_t vSQL;
  142. vSQL = "SELECT * FROM Users WHERE UserName='" + cUserName + "'";
  143. //执行SELETE语句
  144. _RecordsetPtr m_pRecordset;
  145. m_pRecordset = m_AdoConn.GetRecordSet(vSQL);
  147. //返回各列的值
  148. if (m_pRecordset->adoEOF)
  149. CUsers();
  150. else
  151. {
  152. UserName = cUserName;
  153. Pwd = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Pwd");
  154. User_type = atoi((LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("User_type"));
  155. }
  156. //断开与数据库的连接
  157. m_AdoConn.ExitConnect();
  158. }