📄 dlgbackup.cpp
字号:
// DlgBackup.cpp : implementation file
//
#include "stdafx.h"
#include "Manage_WH.h"
#include "DlgBackup.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif
/////////////////////////////////////////////////////////////////////////////
// CDlgBackup dialog
CDlgBackup::CDlgBackup(CWnd* pParent /*=NULL*/)
: CDialog(CDlgBackup::IDD, pParent)
{
//{{AFX_DATA_INIT(CDlgBackup)
// NOTE: the ClassWizard will add member initialization here
//}}AFX_DATA_INIT
m_hIcon = AfxGetApp()->LoadIcon(IDI_MYICON);
}
void CDlgBackup::DoDataExchange(CDataExchange* pDX)
{
CDialog::DoDataExchange(pDX);
//{{AFX_DATA_MAP(CDlgBackup)
DDX_Control(pDX, IDC_STATEXT, m_StaText);
DDX_Control(pDX, IDC_STATITLE, m_StaTitle);
//}}AFX_DATA_MAP
}
BEGIN_MESSAGE_MAP(CDlgBackup, CDialog)
//{{AFX_MSG_MAP(CDlgBackup)
ON_BN_CLICKED(IDC_BACKUP, OnBackup)
//}}AFX_MSG_MAP
END_MESSAGE_MAP()
/////////////////////////////////////////////////////////////////////////////
// CDlgBackup message handlers
BOOL CDlgBackup::PreTranslateMessage(MSG* pMsg)
{
if (pMsg->message==WM_KEYDOWN && (pMsg->wParam==13 || pMsg->wParam==27))
return TRUE;
return CDialog::PreTranslateMessage(pMsg);
}
BOOL CDlgBackup::OnInitDialog()
{
CDialog::OnInitDialog();
SetIcon(m_hIcon,TRUE);
this->m_StaTitle.SetFont("Tohamo"); //字体
this->m_StaTitle.SetFontSize(30); //字体大小
this->m_StaTitle.SetFontStyle(false,true,false); //字体风格
this->m_StaTitle.SetTextColor(RGB(255,200,200)); //字体颜色
this->m_StaTitle.SetShadow(true,RGB(32,32,32),2,45); //设置阴影
return TRUE;
}
void CDlgBackup::OnBackup()
{
CString sFileName;
CTime time(CTime::GetCurrentTime());
sFileName.Format("%.4d%.2d%.2d%.2d%.2d%.2d.RDB",time.GetYear(),time.GetMonth(),time.GetDay(),time.GetHour(),time.GetMinute(),time.GetSecond());
this->m_StaText.SetWindowText("正在备份,请稍后...");
//关闭定时器,执行备份操作
gpDoc->m_bTimeDealing = TRUE;
gpDoc->m_bTimeDealing1 = TRUE;
gpDoc->m_bTimeDealing2 = TRUE;
gpDoc->m_bTimeTaskManage = TRUE;
CAdoConnection cn;
if (cn.OpenUDLFile(gstrConSQLSer))
{
cn.Execute("BACKUP DATABASE WuHan TO DISK='D:\\Manage_WH\\管理系统数据库备份文件\\"+sFileName+"'");
cn.Close();
Sleep(3000);
//打开定时器
gpDoc->m_bTimeDealing = FALSE;
gpDoc->m_bTimeDealing1 = FALSE;
gpDoc->m_bTimeDealing2 = FALSE;
gpDoc->m_bTimeTaskManage = FALSE;
this->m_StaText.SetWindowText("");
AddLog("备份数据库数据,备份文件名:"+sFileName+"");
MessageBox("备份完成!","系统提示",MB_OK|MB_ICONEXCLAMATION);
}
else
{
MessageBox("备份失败!","系统提示",MB_OK|MB_ICONEXCLAMATION);
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -