//加载类型 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; }
//加载类型 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; }