Â¥Ö÷

[ÇóÖú]ÄÇλ¸ßÊÖ°ïÎÒ·ÖÎöÒ»ÏÂÕâ¶Î´úÂ루ÿһ¾ä¸øÎÒ¼Ó¸ö×¢ÊÍ£©Ð»Ð»£¡ int DFS(MSXML2::IXMLDOMNodePtr& pNode, long treeid, char* tablename ) {  //±éÀúËã·¨º¯Êý£¨Éî¶ÈÓÅÏÈËÑË÷£©  CString sql, sql_name, sql_value;  HRESULT hr;  int nCount =0;  MSXML2::IXMLDOMNodeListPtr pNodelist;  if( pNode->hasChildNodes() )  {   hr = pNode->get_childNodes( &pNodelist );   if( !SUCCEEDED( hr ) )   return 0;   long length = 0;   hr = pNodelist->get_length( &length );   for( long i = 0; i < length; i++ )   {    pNodelist->get_item( i, &pNode );    CString nodename = (char*)pNode->nodeName;    MSXML2::DOMNodeType nodeType;    pNode->get_nodeType(&nodeType);    if( nodename == tablename && nodeType == MSXML2::NODE_ELEMENT )    {     //½ÚµãÖµ     CString tmpValue;     //½ÚµãÊôÐÔ,·ÅÔÚÁ´±íÖÐ     MSXML2::IXMLDOMNamedNodeMapPtr pIXMLDOMNamedNodeMap = NULL;     MSXML2::IXMLDOMNodePtr pAttrItem;     hr = pNode->get_attributes(&pIXMLDOMNamedNodeMap);     if( pIXMLDOMNamedNodeMap )     {      long nColCount ;      pIXMLDOMNamedNodeMap->get_length(&nColCount);      CString strName;      CString strValue;      sql_name = _T(""), sql_value = _T("");      for( int i=0; i< nColCount; i++ )      {       pIXMLDOMNamedNodeMap->get_item(i,&pAttrItem);       strName   = (char*)(_bstr_t)pAttrItem->nodeName;           strValue  = (char*)(_bstr_t)pAttrItem->nodeTypedValue;               AnalyzeSQL( strName, strValue, sql_name,sql_value);      }      sql_name.TrimRight( ',');      sql_value.TrimRight(',');      char buf[]  ="insert into b_jlNumber(ClassID, TreeID, %s ) values (%d, %d, %s )";      sql.Format( buf, sql_name, 1022, treeid,  sql_value );      CTableRow::m_pManager->GetDB()->ExecuteSQL( sql );      nCount++;     }    }    else     nCount += DFS( pNode, treeid, tablename );   }//end for  }//end if  return nCount; } bool CR_jlNumber::DoExpandCmd( int cmd, long tree,CTableDefined* pTableCtrl ) {  CString strPath;  strPath.Format( "%s\\work\\*.xml", CTableRow::m_pManager->GetCurDirection()  );  CFileDialog dlg( true, "xml", strPath, OFN_HIDEREADONLY | OFN_OVERWRITEPROMPT, "Éϱ¨ÈËÔ±ÐÅÏ¢ (*.XML)|*.xml|Éϱ¨ÈËÔ±ÐÅÏ¢(*.xml)|*.xml|" );  if( IDOK != dlg.DoModal() )   return false;  CString strFilepath = dlg.GetPathName();    CoInitialize(NULL);  //³õʼ»¯COM »·¾³  HRESULT hr;  CString str;  MSXML2::IXMLDOMDocumentPtr pDoc;  hr =pDoc.CreateInstance( "Msxml2.DOMDocument.4.0" );  if( !SUCCEEDED( hr ) )  {   AfxMessageBox("ÎÞ·¨´´½¨DOMDocument¶ÔÏó£¬Çë¼ì²éÊÇ·ñ°²×°ÁËMS XML Parser ÔËÐпâ!");   return false;  }  pDoc->Putasync( false );  BOOL bResult;  bResult = pDoc->load( strFilepath.GetBuffer(200) );//  if( bResult == FALSE )  {   AfxMessageBox("¼ÓÔØxmlÎļþʧ°Ü!");   return false;  }  int ncount = DFS( (MSXML2::IXMLDOMNodePtr&)pDoc, tree, "b_Employee" );//±éÀú  CString strBuff;  strBuff.Format( "¹²µ¼ÈëÊý¾Ý %d Ìõ", ncount );  AfxMessageBox( strBuff );  return true; };    Êղؠ  ·ÖÏí   ¶¥(0)