visitdata.cpp

这是一个3D彩票统计查询方面的一个软件

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

CVisitData::CVisitData()
{
	m_pdatabase = NULL;
	m_p3ddyj = NULL;
	m_p3dInsureSet = NULL;
	m_pSet = NULL;
	m_p3dotherSet = NULL;
	m_p3dbqSet = NULL;

}

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

	if(m_p3dotherSet != NULL)
		delete m_p3dotherSet;

	if(m_pdatabase != NULL)
		delete m_pdatabase;
	if(m_p3dbqSet != NULL)
		delete m_p3dbqSet;
}

BOOL CVisitData::OnInit3D()
{
	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=3ddb.mdb";
		m_pdatabase = new CDatabase;
		if(!m_pdatabase->Open(NULL,FALSE,FALSE,sDSN,FALSE))
		{   
			AfxMessageBox("找不到3ddb.mdb库!");
			return FALSE;
		}
		
		m_pSet = new C3DSet(m_pdatabase);
		CString strSQL = "select * from lottery3d" ;
		if(m_pSet->Open(CRecordset::dynaset,strSQL))
		{
			return TRUE;
		}
		else
		{
			AfxMessageBox("创建记录集失败!");
			return FALSE;
		}
	////////////////////////////////////////////////
	}
	catch(CDBException* pEx)
	{
		pEx->ReportError();
	}
	return FALSE;
}


BOOL CVisitData::OnInit3DOther()
{
	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=3ddb.mdb";
		m_pdatabase = new CDatabase;
		if(!m_pdatabase->Open(NULL,FALSE,FALSE,sDSN,FALSE))
		{   
			AfxMessageBox("找不到3ddb.mdb库!");
			return FALSE;
		}

		m_p3dotherSet = new C3DOtherSet(m_pdatabase);
		CString strSQL = "select * from 3dother" ;
		if(m_p3dotherSet->Open(CRecordset::dynaset,strSQL))
		{
			return TRUE;
		}
		else
		{
			AfxMessageBox("创建记录集失败!");
			return FALSE;
		}
	  		
		//////////////////////////////////////////////
		////////////////////////////////////////////////
	}
	catch(CDBException* pEx)
	{
		pEx->ReportError();
	}
	return FALSE;
}

BOOL CVisitData::OnInit3DBq()
{
	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=3ddb.mdb";
		m_pdatabase = new CDatabase;
		if(!m_pdatabase->Open(NULL,FALSE,FALSE,sDSN,FALSE))
		{   
			AfxMessageBox("找不到3ddb.mdb库!");
			return FALSE;
		}
		
		m_p3dbqSet = new CBqDataSet(m_pdatabase);
		CString strSQL = "select * from 3dbq" ;
		if(m_p3dbqSet->Open(CRecordset::dynaset,strSQL))
		{
			return TRUE;
		}
		else
		{
			AfxMessageBox("创建记录集失败!");
			return FALSE;
		}
	////////////////////////////////////////////////
	}
	catch(CDBException* pEx)
	{
		pEx->ReportError();
	}
	return FALSE;
}


BOOL CVisitData::OnInit3DInsure()
{
	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=3ddyj.mdb";
		m_p3ddyj = new CDatabase;
		if(!m_p3ddyj->Open(NULL,FALSE,FALSE,sDSN,FALSE))
		{   
			AfxMessageBox("找不到3ddyj.mdb库!");
			return FALSE;
		}
		
		m_p3dInsureSet = new C3DInsure(m_p3ddyj);
		CString strSQL = "select * from Issue_3D" ;
		if(m_p3dInsureSet->Open(CRecordset::dynaset,strSQL))
		{
			return TRUE;
		}
		else
		{
			AfxMessageBox("创建记录集失败!");
			return FALSE;
		}
	////////////////////////////////////////////////
	}
	catch(CDBException* pEx)
	{
		pEx->ReportError();
	}
	return FALSE;
}


//从中奖数据文件向3d数据库写入记录
BOOL CVisitData::Write3DData(CStringArray& m_strarray)
{
	m_pSet->AddNew();
	m_pSet->m_ItemNo = atoi(m_strarray[0]);
	m_pSet->m_BNo = atoi(m_strarray[1]);
	m_pSet->m_SNo = atoi(m_strarray[2]);
	m_pSet->m_GNo = atoi(m_strarray[3]);
	m_pSet->Update( );

	return TRUE;
}
//从中奖数据文件向3dother数据库写入记录
BOOL CVisitData::Write3DOtherData(CStringArray& m_strarray)
{
	m_p3dotherSet->AddNew();
	m_p3dotherSet->m_ItemNo = atoi(m_strarray[0]);
	m_p3dotherSet->m_iSJHAO = m_strarray[2];
	m_p3dotherSet->m_iSCHAO = m_strarray[1];

	UINT  ubsg   = atoi(m_strarray[1]);
	UINT  usjbsg = atoi(m_strarray[2]);

	m_p3dotherSet->m_iBNo = ubsg / 100;
	m_p3dotherSet->m_iSNo = ubsg %100/10;
	m_p3dotherSet->m_iGNo = ubsg %10;

	m_p3dotherSet->m_iSJBNo = usjbsg / 100;
	m_p3dotherSet->m_iSJSNo = usjbsg %100/10;
	m_p3dotherSet->m_iSJGNo = usjbsg %10;

	
	m_p3dotherSet->m_iJiNo = atoi(m_strarray[3]);
	m_p3dotherSet->m_iQiuNo = atoi(m_strarray[4]);

	//也可以不在此处求试机号，实际号和值
	m_p3dotherSet->m_iSJCount = usjbsg/100 + usjbsg%100/10 + usjbsg%10 ;
	m_p3dotherSet->m_iCount   = ubsg/100 + ubsg%100/10 +ubsg%10;

	m_p3dotherSet->Update( );

	return TRUE;
}

//从中奖数据文件向3dbq数据库写入记录
BOOL CVisitData::Write3DBqData(CStringArray& m_strarray)
{
	m_p3dbqSet->AddNew();
	m_p3dbqSet->m_ItemNo = atoi(m_strarray[0]);

	m_p3dbqSet->m_iJiNo = atoi(m_strarray[1]);
	m_p3dbqSet->m_iQiuNo = atoi(m_strarray[2]);

	m_p3dbqSet->m_iSCHAO = m_strarray[3] + m_strarray[4] +m_strarray[5] ;

	m_p3dbqSet->m_iSJHAO = m_strarray[9] + m_strarray[10] +m_strarray[11];


	m_p3dbqSet->m_strsjB = m_strarray[12];
	m_p3dbqSet->m_strsjS = m_strarray[13];
	m_p3dbqSet->m_strsjG = m_strarray[14];
	

	//也可以不在此处求试机号，实际号和值
	m_p3dbqSet->m_iSJCount = 20;
	m_p3dbqSet->m_iCount   = 20;

	m_p3dbqSet->Update( );

	return TRUE;
}


//从3ddyj数据库向3d数据库，3dOther写入新加记录
BOOL CVisitData::WriteData()
{
	//这里处理库打开情况下的数据，初始化工作放在调用函数前完成
	m_pSet->MoveLast();
	UINT  nItem = m_pSet->m_ItemNo;

	while(!m_p3dInsureSet->IsEOF())
	{
		if((m_p3dInsureSet->m_LotteryID == 52) && (atoi(m_p3dInsureSet->m_Issue) == nItem))
			break;
		m_p3dInsureSet->MoveNext();
	}
	


	m_pSet->AddNew();
	m_pSet->m_ItemNo = atoi(m_strarray[0]);
	m_pSet->m_BNo = atoi(m_strarray[1]);
	m_pSet->m_SNo = atoi(m_strarray[2]);
	m_pSet->m_GNo = atoi(m_strarray[3]);
	m_pSet->Update( );

	return TRUE;
}



void CVisitData::OnClose3D()
{

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

void CVisitData::OnClose3DOther()
{
	m_p3dotherSet->Close();
	m_pdatabase->Close();
}

void CVisitData::OnClose3DInsure()
{
	m_p3dInsureSet->Close();
	m_p3ddyj->Close();
}

void CVisitData::OnClose3DBq()
{
//	m_p3dbqSet->Close();
//	m_pdatabase->Close();
}