user.cpp

陕西理工学院计算机系教师信息管理系统的设计与实现

// User.cpp: implementation of the CUser class.
//
//////////////////////////////////////////////////////////////////////

#include "stdafx.h"
#include "TeacherMIS.h"
#include "User.h"

#ifdef _DEBUG
#undef THIS_FILE
static char THIS_FILE[]=__FILE__;
#define new DEBUG_NEW
#endif

//////////////////////////////////////////////////////////////////////
// Construction/Destruction
//////////////////////////////////////////////////////////////////////

CUser::CUser()
{
	m_userName = "";
	m_Pwd = "";
	m_type = 0;
}

CUser::~CUser()
{

}
void CUser::GetData(CString cUserName)
{
	CADORecordset* pRs=new CADORecordset(((CTeacherMISApp*)AfxGetApp())->pDB);
	CString strSQL;
	strSQL.Format("select * from tbUser where UserName='%s'",cUserName);
	pRs->Open(strSQL,CADORecordset::openQuery);
	if(pRs->GetRecordCount()==1)
	{
		pRs->GetFieldValue("UserName",m_userName);
		pRs->GetFieldValue("Password",m_Pwd);
		pRs->GetFieldValue("TypeID",m_type);
	}
	pRs->Close();
	delete pRs;
}
int CUser::HaveName(CString cUserName)
{
	CADORecordset* pRs=new CADORecordset(((CTeacherMISApp*)AfxGetApp())->pDB);
	CString strSQL;
	int m;
	strSQL.Format("select * from tbUser where UserName='%s'",cUserName);
	pRs->Open(strSQL,CADORecordset::openQuery);
	if(pRs->GetRecordCount()==1)
		m=1;
	else m=-1;

	pRs->Close();
	delete pRs;
	return m;
}

void CUser::UpdatePwd(CString cUserName)
{
	CString strSQL;
	strSQL = "UPDATE tbUser SET Password='" + m_Pwd + "' WHERE UserName='" + cUserName + "'";
//	strSQL = "DELETE FROM tbUser WHERE UserName='" + cName + "'";
	((CTeacherMISApp*)AfxGetApp())->pDB->Execute(strSQL);
}
void CUser::AddUser()
{
	CADORecordset* pRs=new CADORecordset(((CTeacherMISApp*)AfxGetApp())->pDB);
	CString strSQL;
	strSQL.Format("select * from tbUser");
	pRs->Open(strSQL,CADORecordset::openQuery);
	pRs->AddNew();
	pRs->SetFieldValue("UserName",m_userName);
	pRs->SetFieldValue("Password",m_Pwd);
	pRs->SetFieldValue("TypeID",m_type);
	pRs->Update();
	pRs->Close();
	delete pRs;
}

void CUser::DeleteUser(CString cName)
{

	CString strSQL;
	strSQL = "DELETE FROM tbUser WHERE UserName='" + cName + "'";
//	strSQL = "DELETE FROM Users WHERE UserName='" + cName +"'";
	((CTeacherMISApp*)AfxGetApp())->pDB->Execute(strSQL);


}