// DBManager.cpp: implementation of the DBManager class.
//
//////////////////////////////////////////////////////////////////////

#include "stdafx.h"
#include "SqlCeExaple.h"
#include "DBManager.h"


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

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

DBManager::DBManager()
{

}

DBManager::~DBManager()
{

}


void DBManager::Add(int num, CString name, int age)
{
	CString sql;
	sql.Format(L"insert into student values(%d,'%s',%d)",num,name,age);
	if(!m_pRecordSet->Open(sql))
	{
		AfxMessageBox(L"add()  failed!",MB_ICONERROR|MB_OK,-1);
	}
}

BOOL DBManager::Mod(int num,CString name,int age)
{
	HRESULT hr = S_OK;
	CString sql;
	sql.Format(L"update student set Num='%d' Name='%s' Age='%d' where(Num=%d)",num,name,age,num);

	if(!m_pRecordSet->IsEOF())
	{
		hr = m_pRecordSet->Open(sql);
	
		if(hr)
		{
			return true;
		}
	}
	return false;
}

BOOL DBManager::Del(int num)
{
	HRESULT hr = S_OK;
	CString sql;

	sql.Format(L"delete from student where(Num=%d)",num);
	if(m_pRecordSet->IsEOF())
	{
		return false;
	}
	m_pRecordSet->MoveFirst();
	if(!m_pRecordSet->IsEOF())
	{
		hr = m_pRecordSet->Open(sql);
		if(hr)
		{
			return true;
		}
	}
	return false;
}

BOOL DBManager::FindItem(int num)
{
	VARIANT vValue;
	VariantInit(&vValue);

	if(!m_pRecordSet->IsEOF())
	{
		m_pRecordSet->MoveFirst();
	}
	while(!m_pRecordSet->IsEOF())
	{				
		vValue = m_pRecordSet->GetFieldValue(0);
		dbnum = vValue.iVal;
		
		if(dbnum == num)
		{
			vValue = m_pRecordSet->GetFieldValue(1);
			dbname = vValue.bstrVal;
			
			vValue = m_pRecordSet->GetFieldValue(2);
			dbage = vValue.iVal;
			return true;
		}	
		m_pRecordSet->MoveNext();
	}
	return false;
}

BOOL DBManager::FindNextItem()
{
	VARIANT vValue;
	VariantInit(&vValue);
	

	if(m_pRecordSet->IsEOF())
	{
		return false;
	}
	m_pRecordSet->MoveNext();
	if(!m_pRecordSet->IsEOF())
	{
		vValue = m_pRecordSet->GetFieldValue(0);
		dbnum = vValue.iVal;
		
		vValue = m_pRecordSet->GetFieldValue(1);
		dbname = vValue.bstrVal;
		
		vValue = m_pRecordSet->GetFieldValue(2);
		dbage = vValue.iVal;
		
		return true;
	}
	return false;

}

BOOL DBManager::FindFirstItem()
{
	VARIANT vValue;
	VariantInit(&vValue);
	

	if(m_pRecordSet->IsEOF())
	{
		return false;
	}
	m_pRecordSet->MoveFirst();

	vValue = m_pRecordSet->GetFieldValue(0);
	dbnum = vValue.iVal;
	
	vValue = m_pRecordSet->GetFieldValue(1);
	dbname = vValue.bstrVal;
	
	vValue = m_pRecordSet->GetFieldValue(2);
	dbage = vValue.iVal;
	
	return true;
}