Пример #1
0
//加载类型
void CServerListCenter::LoadGameType(CDataBaseAide & DataBaseAide)
{
	//执行命令
	DataBaseAide.ResetParameter();
	DataBaseAide.ExecuteProcess(TEXT("GSP_LoadGameTypeItem"),true);

	//变量定义
	tagGameType GameTypeRead;
	ZeroMemory(&GameTypeRead,sizeof(GameTypeRead));

	//获取数据
	IDataBase * pIDataBase=(IDataBase *)DataBaseAide.GetDataBase(IID_IDataBase,VER_IDataBase);

	//读取数据
	while (pIDataBase->IsRecordsetEnd()==false)
	{
		//读取信息
		GameTypeRead.wTypeID=DataBaseAide.GetValue_WORD(TEXT("TypeID"));
		GameTypeRead.wSortID=DataBaseAide.GetValue_WORD(TEXT("SortID"));
		DataBaseAide.GetValue_String(TEXT("TypeName"),GameTypeRead.szTypeName,CountArray(GameTypeRead.szTypeName));

		//移动记录
		pIDataBase->MoveToNext();

		//插入信息
		InsertGameType(&GameTypeRead);
	}

	//关闭记录
	pIDataBase->CloseRecordset();

	return;
}
Пример #2
0
//加载类型
void CServerListCenter::LoadGameType(IDataBase * pIDataBase)
{
	//执行命令
	pIDataBase->ClearAllParameters();
	pIDataBase->SetSPName(TEXT("GSP_GP_LoadTypeInfo"));
	pIDataBase->ExecuteCommand(true);

	//读取信息
	tagGameType GameTypeRead;
	memset(&GameTypeRead,0,sizeof(GameTypeRead));
	while (pIDataBase->IsEndRecordset()==false)
	{
		//读取信息
		pIDataBase->GetFieldValue(TEXT("TypeID"),GameTypeRead.wTypeID);
		pIDataBase->GetFieldValue(TEXT("SortID"),GameTypeRead.wSortID);
		pIDataBase->GetFieldValue(TEXT("TypeName"),GameTypeRead.szTypeName,sizeof(GameTypeRead.szTypeName));
		pIDataBase->MoveToNext();

		//插入信息
		InsertGameType(&GameTypeRead);
	}
	pIDataBase->CloseRecordset();

	return;
}
//加载类型
void CServerListCenter::LoadGameType(CDataBaseAide & DataBaseAide)
{
	try
	{
		//执行命令
		DataBaseAide.ResetParameter();
		DataBaseAide.ExecuteProcess(TEXT("GSP_LoadGameTypeItem"),true);
	}
	catch (IDataBaseException * pIException)
	{
		//错误信息
		LPCTSTR pszDescribe=pIException->GetExceptionDescribe();
		CTraceService::TraceString(pszDescribe,TraceLevel_Exception);
	}
	//变量定义
	tagGameType GameTypeRead;
	ZeroMemory(&GameTypeRead,sizeof(GameTypeRead));

	//获取数据
	IDataBase * pIDataBase=(IDataBase *)DataBaseAide.GetDataBase(IID_IDataBase,VER_IDataBase);

	//读取数据
	while (pIDataBase->IsRecordsetEnd()==false)
	{
		//读取信息
		GameTypeRead.wTypeID=DataBaseAide.GetValue_WORD(TEXT("TypeID"));
		GameTypeRead.wSortID=DataBaseAide.GetValue_WORD(TEXT("SortID"));
		DataBaseAide.GetValue_String(TEXT("TypeName"),GameTypeRead.szTypeName,CountArray(GameTypeRead.szTypeName));

		//移动记录
		pIDataBase->MoveToNext();

		//插入信息
		InsertGameType(&GameTypeRead);
	}

	//关闭记录
	pIDataBase->CloseRecordset();

	return;
}