wordglxtdlg.cpp

一个基于VC的文档管理系统。该程序可以方便地管理文件

			m_richedit.SetWindowText(strWjian);       //RichEdit控件显示数据
			temp = m_tree.GetNextItem(temp,TVGN_NEXT);//将temp的兄弟节点付给temp
		}
	}
	else
	{
		temp = m_tree.GetSelectedItem(); //重新获得当前选定树控件的项目
		for(int i=0;i<xxb.a_WDbh.GetSize();i++)
		{
			if(temp==hitem[i])
			{
				//取出temp对应的文档路径
				strWordpath = xxb.a_WJlj.GetAt(i);
				CFileFind file;
				if(!file.FindFile(strWordpath))
				{//查找文件是否存在，不存在则清除数据库中的记录
					MessageBox("文件不存在！","文档管理系统");
					
					int	wdbh=0;
					wdbh = atoi(xxb.a_WDbh.GetAt(i));
					//删除该文档
					UpdateData(true);
					xxb.sql_delete(wdbh); //删除该文档
					MessageBox("数据库中该文件的记录已删除！","文档管理系统");
					UpdateData(false);
					return ;
				}

			}
		}
		//word应用程序的调用 
		_Application app;
		//初始化连接
		//***解决初始化连接时的进程冲突问题*****************
        LPDISPATCH  pDisp;
		LPUNKNOWN  pUnk;
		CLSID clsid;
		CLSIDFromProgID(L"word.Application",&clsid);
        if(GetActiveObject(clsid,NULL,&pUnk)==S_OK)
		{
			pUnk->QueryInterface(IID_IDispatch,(void**)&pDisp);
			app.AttachDispatch(pDisp);
			
		}
		else
		if(!app.CreateDispatch("word.Application"))   // 启动word
		{ 
			MessageBox("Word启动失败！","文档管理系统"); 
			return ;
		}
		//***解决初始化连接时的进程冲突问题*****************

		Documents doc;
		CComVariant a (_T(strWordpath)),b(false),c(0),d(true),aa(0),bb(1);
		_Document doc1;
	     
		doc.AttachDispatch( app.GetDocuments());
		doc1.AttachDispatch(doc.Add(&a,&b,&c,&d));
		Range range;
		
		//取出文档的所选区域
		range = doc1.GetContent();
		//取出文件内容
		strText = range.GetText();
		m_richedit.SetWindowText(strText);
		//关闭
		app.Quit(&b,&c,&c);	
		//释放环境
		range.ReleaseDispatch();
		doc.ReleaseDispatch();
		doc1.ReleaseDispatch();
		app.ReleaseDispatch();

	}
	*pResult = 0;
}

void CWordGLXTDlg::OnMenuliulwd() //文档管理-〉文档浏览
{
	// TODO: Add your command handler code here
	CString strd,strs;
	xxb.Load_dep();
	for(int i=0;i<xxb.a_WDbh.GetSize();i++)
	{
		strd=xxb.a_WDmc.GetAt(i);
		strs+=strd+"\n";
		m_richedit.SetWindowText(strs);
	}
}

void CWordGLXTDlg::OnMenuyhgl() //用户管理功能
{
	// TODO: Add your command handler code here
	if(user.GetJB()=="1")
	{
		CYHgldlg dlg;
		dlg.DoModal();
	}
	else
	{
		MessageBox("没有权限","文档管理系统");
		return;
	}	
}

void CWordGLXTDlg::OnMenumodpwd() //口令修改功能
{
	// TODO: Add your command handler code here
	CKLxgdlg dlg;
	dlg.DoModal();
}

void CWordGLXTDlg::OnMenuaddwd() //实现添加文档功能
{
	// TODO: Add your command handler code here
	CWDgldlg dlg;
	dlg.str = 0;
	if(dlg.DoModal()==IDOK)
	{
		m_tree.DeleteAllItems();
		dwb.Load_dep();
		mlb.Load_dep();
		xxb.Load_dep();
		m_root=m_tree.InsertItem("基本信息管理",0,0);
		AddtoTree(m_root);
	}
}

void CWordGLXTDlg::OnMenudelwd() //实现删除文档功能
{
	// TODO: Add your command handler code here
	CWDgldlg dlg;
	dlg.tabindex = 1;
	if(dlg.DoModal()==IDOK)
	{
		m_tree.DeleteAllItems();
		dwb.Load_dep();
		mlb.Load_dep();
		xxb.Load_dep();
		m_root=m_tree.InsertItem("基本信息管理",0,0);
		AddtoTree(m_root);
	}
}

void CWordGLXTDlg::OnMenumodwd() //实现修改文档功能
{
	// TODO: Add your command handler code here
	CWDgldlg dlg;
	dlg.str = 1;
	if(dlg.DoModal()==IDOK)
	{
		m_tree.DeleteAllItems();
		dwb.Load_dep();
		mlb.Load_dep();
		xxb.Load_dep();
		m_root=m_tree.InsertItem("基本信息管理",0,0);
		AddtoTree(m_root);
	}
}

void CWordGLXTDlg::OnMenurzgl() //实现日志管理功能
{
	// TODO: Add your command handler code here
	ADOConn m_AdoConn;
    m_AdoConn.OnInitADOConn();
	CString sql,sqlzd="用户名\t登录时间\t动作\n";
	sql.Format("select* from Rizhib");
	m_AdoConn.GetRecordSet((_bstr_t)sql);
	while(m_AdoConn.m_pRecordset->adoEOF==0)
	{
		sqlzd+=(char*)(_bstr_t)m_AdoConn.m_pRecordset->GetCollect("name");
		sqlzd+="  \t";
		sqlzd+=(char*)(_bstr_t)m_AdoConn.m_pRecordset->GetCollect("DLsj");
		sqlzd+="\t";
		sqlzd+=(char*)(_bstr_t)m_AdoConn.m_pRecordset->GetCollect("dz");
		sqlzd+="\n";
		m_AdoConn.m_pRecordset->MoveNext();
		m_richedit.SetWindowText(sqlzd);
	}
	m_AdoConn.ExitConnect();
}

void CWordGLXTDlg::OnExit() 
{
	// TODO: Add your command handler code here
	OnOK();
}



BOOL CWordGLXTDlg::PreTranslateMessage(MSG* pMsg) 
{
	// TODO: Add your specialized code here and/or call the base class
	if(pMsg->message==WM_KEYDOWN && pMsg->wParam==13)
		pMsg->wParam=9;		
	return CDialog::PreTranslateMessage(pMsg);
}

void CWordGLXTDlg::OnMENULookFileAttri() //察看文件属性功能
{
	// TODO: Add your command handler code here
	FileAttri dlg;
	if(strWordpath!="") 
	{
		dlg.pathname = strWordpath;	
		
		if(dlg.DoModal()==IDCANCEL) return ;
	}
	else dlg.DoModal();   
}

//工具栏按钮响应函数
void CWordGLXTDlg::OnButtonDwDA() 
{
	OnMenudwdan();
	// TODO: Add your command handler code here
	
}
void CWordGLXTDlg::OnButtonWDLB() 
{
	// TODO: Add your command handler code here
	OnMenuwdlb();
}

void CWordGLXTDlg::OnButtonAdd() 
{
	// TODO: Add your command handler code here
	OnMenuaddwd();
}

 

void CWordGLXTDlg::OnButtonModify() 
{
	// TODO: Add your command handler code here
	OnMenumodwd();
}

void CWordGLXTDlg::OnButtonDel() 
{
	// TODO: Add your command handler code here
	
	OnMenudelwd();
}

void CWordGLXTDlg::OnButtonScan() 
{
	// TODO: Add your command handler code here
	OnMenuliulwd();
}

void CWordGLXTDlg::OnButtonAttri() 
{
	// TODO: Add your command handler code here
	OnMENULookFileAttri();
}


void CWordGLXTDlg::OnButtonUserManage() 
{
	// TODO: Add your command handler code here
	OnMenuyhgl();
}


void CWordGLXTDlg::OnButtonmimaModify() 
{
	// TODO: Add your command handler code here
	OnMenumodpwd();
	
}

void CWordGLXTDlg::OnButtonLogManage() 
{
	// TODO: Add your command handler code here
	OnMenurzgl();
}



void CWordGLXTDlg::OnButtonExit() 
{
	// TODO: Add your command handler code here
  
	OnOK();
}



void CWordGLXTDlg::OnMenuDBBackUp() 
{
	// TODO: Add your command handler code here
	ADOConn m_AdoConn;

	CString sql,strpath,m_filename;
	strcat(buf,"\\DataBase\\WDGL_Data.DAT");
	strpath.Format("%s",buf);
	m_filename="WDGL_Data";
	sql = "use master exec sp_addumpdevice 'disk','"+m_filename+"','"+strpath+"' backup database WenDGL to "+m_filename+" ";
	if(AfxMessageBox("您确定要备份数据库吗?",MB_OKCANCEL)==IDCANCEL)  	return; 
	   	
	m_AdoConn.ExecuteSQL((_bstr_t)sql);
	m_AdoConn.ExitConnect();
	MessageBox("数据库备份成功！","系统提示",MB_OK|MB_ICONEXCLAMATION);
		
}

void CWordGLXTDlg::OnMenuDBRestore() 
{
	// TODO: Add your command handler code here
	ADOConn m_AdoConn;
	CString sql,m_filename;
	m_filename="WDGL_Data";
	sql = "use master  restore database WenDGL from "+m_filename+" ";
	if(AfxMessageBox("还原数据库将覆盖原来的数据库。您确定要还原吗?",MB_OKCANCEL)==IDCANCEL) 
	return; 
	m_AdoConn.ExecuteSQL((_bstr_t)sql);
	m_AdoConn.ExitConnect();
	MessageBox("数据库恢复完成！","系统提示",MB_OK|MB_ICONEXCLAMATION); 
}

void CWordGLXTDlg::OnButtonBackUp() 
{
	// TODO: Add your command handler code here
	OnMenuDBBackUp();
}

void CWordGLXTDlg::OnButtonRestore() 
{
	// TODO: Add your command handler code here
	OnMenuDBRestore();
}

void CWordGLXTDlg::OnSystemExit() 
{
	// TODO: Add your command handler code here
	OnOK();
}

bool CWordGLXTDlg::OnToolTipNotify(UINT id, NMHDR *pNMHDR, LRESULT *pResult)
{
	

	TOOLTIPTEXT *pTTT=(TOOLTIPTEXT*)pNMHDR;	 
	UINT nID=pNMHDR->idFrom; //获取工具栏按钮ID
	 
	 if(nID)
	 {
		 nID = m_ToolBar.CommandToIndex(nID);//根据ID获取按钮索引
		 if(nID!=-1)
		 {
			 
			 m_ToolBar.GetButtonText(nID,strShow); //获取工具栏文本
		     pTTT->lpszText=strShow.GetBuffer(strShow.GetLength());//设置提示信息文本
             pTTT->hinst = AfxGetResourceHandle();
			 return(true);
		 }
	 }
	 return(false);


}