databasedlg.cpp

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

// DatabaseDlg.cpp : implementation file
//

#include "stdafx.h"
#include "售货系统.h"
#include "DatabaseDlg.h"
#include "fstream.h"

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

extern CDatabase m_database;
extern CString getdate();
extern CString getpath();
/////////////////////////////////////////////////////////////////////////////
// CDatabaseDlg dialog


CDatabaseDlg::CDatabaseDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CDatabaseDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CDatabaseDlg)
	m_backupfile = _T("");
	m_restorefile = _T("");
	//}}AFX_DATA_INIT
}


void CDatabaseDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CDatabaseDlg)
	DDX_Text(pDX, IDC_EDIT1, m_backupfile);
	DDX_Text(pDX, IDC_EDIT2, m_restorefile);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CDatabaseDlg, CDialog)
	//{{AFX_MSG_MAP(CDatabaseDlg)
	ON_BN_CLICKED(IDC_OUTDATABASE, OnOutdatabase)
	ON_BN_CLICKED(IDINDATABASE, OnIndatabase)
	ON_BN_CLICKED(IDC_OPENFILE1, OnOpenfile1)
	ON_BN_CLICKED(IDC_OPENFILE2, OnOpenfile2)
	ON_BN_CLICKED(IDDATACANCEL, OnDatacancel)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CDatabaseDlg message handlers

void CDatabaseDlg::OnOutdatabase() 
{
	if(m_backupfile==""){
		MessageBox("请先输入备份路径");
		return;
	}
	DeleteFile(m_backupfile);
	CString sql;
	sql.Format("backup database	售货系统 to disk='%s'",m_backupfile);
	try{
	m_database.ExecuteSQL(sql);
	}
	catch(CDBException e1){
		MessageBox("error");
	}
	catch(CMemoryException e2){
		MessageBox("error");
	}
}

void CDatabaseDlg::OnIndatabase() 
{
	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){}
	
}

void CDatabaseDlg::OnOpenfile1() 
{
	//定义一个CFileDialog对象并设置显示格式
	CFileDialog filedlg(FALSE,NULL,NULL,OFN_HIDEREADONLY | OFN_OVERWRITEPROMPT,"数据库文件(*.bak)|*.bak|所有文件(*.*)|*.*||",NULL);
	if(filedlg.DoModal()==IDCANCEL)
		return;
	//获取文件路径
	m_backupfile=filedlg.GetPathName();
	UpdateData(FALSE);

}

void CDatabaseDlg::OnOpenfile2() 
{
	CFileDialog filedlg(TRUE,NULL,NULL,OFN_HIDEREADONLY | OFN_OVERWRITEPROMPT,"数据库文件(*.bak)|*.bak|所有文件(*.*)|*.*||",NULL);
	if(filedlg.DoModal()==IDCANCEL)
		return;
	m_restorefile=filedlg.GetPathName();
	UpdateData(FALSE);
}

void CDatabaseDlg::OnDatacancel() 
{
	if(MessageBox("确定退出系统1?","提醒",MB_YESNO|MB_DEFBUTTON2|MB_ICONQUESTION)!=IDNO){
		exit(0);
	}
	
}