dbak.cpp

商品销售管理系统：随着信息技术的快速进步

// DBAK.cpp : implementation file
//

#include "stdafx.h"
#include "商品销售管理系统.h"
#include "DBAK.h"

#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif
#include "ExternDllHeader.h"
extern CMyApp theApp;
/////////////////////////////////////////////////////////////////////////////
// CDBAK dialog


CDBAK::CDBAK(CWnd* pParent /*=NULL*/)
	: CDialog(CDBAK::IDD, pParent)
{
	//{{AFX_DATA_INIT(CDBAK)
	//}}AFX_DATA_INIT
}


void CDBAK::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CDBAK)
	DDX_Control(pDX, IDC_BUTTON, m_Button);
	DDX_Control(pDX, IDC_EDTPACH, m_EdtPach);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CDBAK, CDialog)
	//{{AFX_MSG_MAP(CDBAK)
	ON_BN_CLICKED(IDC_BUTTON2, OnButton2)
	ON_BN_CLICKED(IDC_BUTTON, OnButton)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CDBAK message handlers

void CDBAK::OnOK() 
{
	// TODO: Add extra validation here
	
	//CDialog::OnOK();
}
BOOL CDBAK::OnInitDialog() 
{
	CDialog::OnInitDialog();
	CString sPach;
	rst.Open("系统设置表");
	sPach=rst.GetFieldValue("备份路径");

	CTime tdate;
	tdate=tdate.GetCurrentTime();
	int nhour,nMinute,nSecond;
	nhour=tdate.GetHour();
	nMinute=tdate.GetMinute();
	nSecond=tdate.GetSecond();
	CString sTime;
	sTime.Format("%d-%d-%d",nhour,nMinute,nSecond);
	sDate=CTimeToCString(tdate);
	sFileName="备份"+sDate+"-"+sTime;
	sPach=sPach+"\\"+sFileName+".RBK";
	m_EdtPach.SetWindowText(sPach);
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CDBAK::OnButton2() 
{
	CString sPach;
	sPach=theApp.ShowPath();
	if(sPach=="")
		return;
	sPach=sPach+"\\"+sFileName+".RBK";
	m_EdtPach.SetWindowText(sPach);
	m_Button.EnableWindow(true);

}

void CDBAK::OnButton() 
{
	CString sPach,sSQL,sName;
	m_EdtPach.GetWindowText(sPach);
	if(sPach.IsEmpty())
	{
		MessageBox("请输入备份文件的路径和名称！","系统提示",MB_OK|MB_ICONSTOP);
		m_EdtPach.SetFocus();
	}
	
	sSQL.Format("BACKUP DATABASE spxxglxt TO DISK='%s'",sPach);	
	if(rst.Open(sSQL,adCmdText)==false)
		MessageBox("您输入路径不完整或文件夹不存在！请输入完整的路径及文件名！","系统提示",MB_OK|MB_ICONSTOP);		
	else
	{
		sSQL.Format("INSERT INTO 备份信息表 VALUES('%s','%s')",sDate,sPach);
		rst.Open(sSQL,adCmdText);
		m_Button.EnableWindow(false);
		MessageBox("备份成功！","系统提示",MB_OK|MB_ICONINFORMATION);		
	}
	
}