visitdata.cpp

这是我本人闲暇开发的一个双色球彩票软件

#include "stdafx.h"
#include "visitdata.h"

CVisitData::CVisitData()
{
	m_pdatabase = NULL;
	m_pSet = NULL;

}

CVisitData::~CVisitData()
{
	if(m_pSet != NULL)
		delete m_pSet;
	if(m_pdatabase != NULL)
		delete m_pdatabase;
}

BOOL CVisitData::OnInit()
{
	char strPath[MAX_PATH];
	memset(strPath, 0x0, sizeof(strPath));
	::GetModuleFileName(::AfxGetInstanceHandle(), strPath, MAX_PATH);
	CString strRet = strPath;
	int nIndex = strRet.ReverseFind('\\');
	strRet = strRet.Left(nIndex);	
	::SetCurrentDirectory(strRet);

	try
	{
	    CString  sDSN="ODBC;DRIVER=Microsoft Access Driver (*.mdb);DSN='';DBQ=ssq.mdb";
		m_pdatabase = new CDatabase;
		if(!m_pdatabase->Open(NULL,FALSE,FALSE,sDSN,FALSE))
		{   
			AfxMessageBox("找不到ssq.mdb库!");
			return FALSE;
		}
		
		m_pSet = new CSsqHistorySet(m_pdatabase);
		CString strSQL = "select * from ssqhistory" ;
		if(m_pSet->Open(CRecordset::dynaset,strSQL))
		{
			return TRUE;
		}
		else
		{
			AfxMessageBox("创建记录集失败!");
			return FALSE;
		}
	    
		//////////////////////////////////////////////
		////////////////////////////////////////////////
	}
	catch(CDBException* pEx)
	{
		pEx->ReportError();
	}
	return FALSE;
}

BOOL CVisitData::WriteData(CStringArray& m_strarray)
{
	m_pSet->AddNew();
	m_pSet->m_qishu = m_strarray[0];
	m_pSet->m_Red1 = atoi(m_strarray[1]);
	m_pSet->m_Red2 = atoi(m_strarray[2]);
	m_pSet->m_Red3 = atoi(m_strarray[3]);
	m_pSet->m_Red4 = atoi(m_strarray[4]);
	m_pSet->m_Red5 = atoi(m_strarray[5]);
	m_pSet->m_Red6 = atoi(m_strarray[6]);
	m_pSet->m_RCountValue = m_pSet->m_Red1 +m_pSet->m_Red2 +m_pSet->m_Red3+m_pSet->m_Red4+m_pSet->m_Red5+m_pSet->m_Red6;
	m_pSet->m_Blue = atoi(m_strarray[7]);
	m_pSet->Update( );

	return TRUE;
}


void CVisitData::OnClose()
{

	m_pSet->Close();
	m_pdatabase->Close();

}