usertable.cpp

VC＋＋开发的一个电话录音程序

// UserTable.cpp: implementation of the CUserTable class.
//
//////////////////////////////////////////////////////////////////////

#include "stdafx.h"
#include "PhoneRec.h"
#include "UserTable.h"

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

extern CDatabase g_dbCust;	


//////////////////////////////////////////////////////////////////////
// Construction/Destruction
//////////////////////////////////////////////////////////////////////
CUserTable::CUserTable()
{
}

CUserTable::~CUserTable()
{
}

//增加用户
void CUserTable::AddUser(UserInfo user)
{
	//
	if(JudgeUserBIsExistByID(user.strName))
	{
		AfxMessageBox("  用户名重名 !   添加失败。");
		return;
	}
	//
	CString strSQLSave = "Insert into Users( Name, Psw, AddUser, DelUser, BrosweUser,ModifyPopedom,StartExit,SetSys,DelReData, EableRecord ) values('" +user.strName+ "','" + user.strPsw + "','" + CovertIntToCString( user.bAddUser ) + "','" + CovertIntToCString( user.bDelRecord ) + "','" + CovertIntToCString( user.bBrowseUser )+ "','" + CovertIntToCString( user.bModifyPopedom ) + "','" + CovertIntToCString( user.bStartExit ) + "','" + CovertIntToCString( user.bSetSys ) + "','" + CovertIntToCString( user.bDelRecord )+ "','" + CovertIntToCString( user.bEableRecord ) + "')";
	g_dbCust.ExecuteSQL( strSQLSave );			
}
//修改用户
void CUserTable::UpdateUser(UserInfo user)
{
	CString  strSQLModify = "UPDATE Users SET AddUser = '"+ CovertIntToCString( user.bAddUser ) +"', DelUser = '"+ CovertIntToCString( user.bDelUser ) + "', BrosweUser = '"+ CovertIntToCString( user.bBrowseUser ) +"',ModifyPopedom = '"+ CovertIntToCString( user.bModifyPopedom ) +"',StartExit = '"+ CovertIntToCString( user.bStartExit ) +"',SetSys = '"+ CovertIntToCString( user.bSetSys ) +"',DelReData = '"+ CovertIntToCString( user.bDelRecord ) +"',EableRecord = '"+ CovertIntToCString( user.bEableRecord ) +"'where Name = '"+ user.strName +"'";
	g_dbCust.ExecuteSQL( strSQLModify );
}

CString CUserTable::CovertIntToCString(int bIs)
{
	CString str;
	if( bIs == 0 )
	{
		str = "0";
	}
	else
	{
		str = "1";
	}
	return str;
}

BOOL CUserTable::GetUserInfoByIDandPsw(CString strName, CString strPsw)
{
	CString strbAddser;
	CString strbDelUse;
	CString strbBrowse;
	CString strbModifyUser;
	CString strbStartExit;
	CString strbSetSys;
	CString strbDelRe;
	CString strbEabRe; 
	
	CRecordset rs( &g_dbCust );
	CString strSQL = "Select * from Users where Name = '" +strName+ "' And Psw ='" +strPsw+ "'";
    rs.Open( CRecordset::dynaset, _T( strSQL ) );
	
	if ( !rs.IsEOF( ) )
	{
		m_strName = strName;
		m_strPsw = strPsw;
		
		rs.GetFieldValue( "AddUser", strbAddser );
		rs.GetFieldValue( "DelUser", strbDelUse );
		rs.GetFieldValue( "BrosweUser", strbBrowse );
		rs.GetFieldValue( "ModifyPopedom",strbModifyUser );
		rs.GetFieldValue( "StartExit", strbStartExit );
		rs.GetFieldValue( "SetSys", strbSetSys );
		rs.GetFieldValue( "DelReData", strbDelRe );
		rs.GetFieldValue( "EableRecord", strbEabRe );
		
		m_ibAddUser = atol( strbAddser );
		m_ibDelUser = atol( strbDelUse );
		m_ibBrowse = atol( strbBrowse );
		m_ibModifyPom = atol( strbModifyUser );
		m_ibStartExit = atol( strbStartExit );
		m_bSetSys = atol( strbSetSys );
		m_ibDelRe = atol( strbDelRe );
		m_ibEabRe = atol( strbEabRe );
	
		rs.Close();	
		
		return TRUE;
	}
	else
	{
		return FALSE;
	}
}

void CUserTable::UpdateUserPsw(CString strUserName, CString strNewPsw)
{
	CString  strSQLModify = "UPDATE Users SET Psw = '"+ strNewPsw +"' where Name = '"+ strUserName +"'";
	g_dbCust.ExecuteSQL( strSQLModify );
}


BOOL CUserTable::JudgeUserBIsExistByID(CString strName )
{
	CRecordset rs( &g_dbCust );
	CString strSQL = "Select * from Users where Name = '" + strName +"'" ;
    rs.Open( CRecordset::dynaset, _T( strSQL) );
	while( !rs.IsEOF( ) )
	{
		rs.Close();	
		return TRUE;
	}
	rs.Close();	
	return FALSE;
}