datarestore.cpp

< SQL SERVER 2000 案例教程>>,冶金工业出版社,这本书的代码

// DataRestore.cpp : implementation file
//

#include "stdafx.h"
#include "仓库管理系统.h"
#include "DataRestore.h"

#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

extern CDatabase m_database;
/////////////////////////////////////////////////////////////////////////////
// CDataRestore dialog


CDataRestore::CDataRestore(CWnd* pParent /*=NULL*/)
	: CDialog(CDataRestore::IDD, pParent)
{
	//{{AFX_DATA_INIT(CDataRestore)
		// NOTE: the ClassWizard will add member initialization here
	//}}AFX_DATA_INIT
}


void CDataRestore::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CDataRestore)
		// NOTE: the ClassWizard will add DDX and DDV calls here
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CDataRestore, CDialog)
	//{{AFX_MSG_MAP(CDataRestore)
	ON_BN_CLICKED(IDC_BUTTON1, OnRestore)
	ON_BN_CLICKED(IDC_BUTTON2, OnButton2)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CDataRestore message handlers

void CDataRestore::OnRestore() 
{
	CString filepath;
	CFileDialog filedlg(FALSE,NULL,NULL,OFN_HIDEREADONLY | OFN_OVERWRITEPROMPT,"数据库文件(*.bak)|*.bak|所有文件(*.*)|*.*||",NULL);
	if(filedlg.DoModal()==IDCANCEL)
		return;
	//获取文件路径
	filepath=filedlg.GetPathName();
	CString sql;
	//书写恢复数据库的SQL语句
	sql.Format("backup database	仓库管理系统 to disk='%s'",filepath);
	try{
		
	m_database.ExecuteSQL(sql);
	}
	catch(CDBException e1){
		MessageBox("error");
	}
	catch(CMemoryException e2){
		MessageBox("error");
	}
	
}

void CDataRestore::OnButton2() 
{
CString filepath;
	CFileDialog filedlg(FALSE,NULL,NULL,OFN_HIDEREADONLY | OFN_OVERWRITEPROMPT,"数据库文件(*.bak)|*.bak|所有文件(*.*)|*.*||",NULL);
	if(filedlg.DoModal()==IDCANCEL)
		return;
	//获取文件路径
	filepath=filedlg.GetPathName();
	CString sql;
	//书写恢复数据库的SQL语句
	sql.Format("restore database 售货系统 from disk='%s'",filepath);
	
	try{
	//	sqlexec(sql);
//	m_database.ExecuteSQL(sql);
	}
	catch(CDBException e1){
		MessageBox("error");
	}
	catch(CMemoryException e2){}	
}