user.cpp

来自「C++课程设计 C++开放的高校职工管理软件 附带源代码及报告」· C++ 代码 · 共 113 行

// 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="";
}

CUser::~CUser()
{

}

void CUser::DeleteUser(CString cName)
{
	CString strSQL;
	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->Update();
	pRs->Close();
	delete pRs;
}

CString CUser::GetUserName()
{
	return m_userName;
}

void CUser::SetUserName(CString cUserName)
{
	m_userName=cUserName;
}

CString CUser::GetPwd()
{
	return m_Pwd;
}

void CUser::SetPwd(CString cPwd)
{
	m_Pwd=cPwd;
}

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::sql_delete(CString cUserName)
{

}

void CUser::UpdatePwd(CString cUserName)
{
	CString strSQL;
	strSQL = "UPDATE tbuser SET Password='" + m_Pwd + "' WHERE UserName='" + cUserName + "'";
	((CTeacherMISApp*)AfxGetApp())->pDB->Execute(strSQL);
}

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->Close();
	delete pRs;
}