dsetup.cpp

1.数据库文件名：spxxglxt(位置：商品销售管理系统商品销售管理系统dataspxxglxt_Data.MDF文件 和 商品销售管理系统商品销售管理系统dataspxxglxt_Log.LDF

// DSetup.cpp : implementation file
//

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

#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif
extern CMyApp theApp;
/////////////////////////////////////////////////////////////////////////////
// CDSetup dialog


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


void CDSetup::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CDSetup)
	DDX_Control(pDX, IDC_BUTPACH, m_ButPach);
	DDX_Control(pDX, IDC_EDTPCTCH, m_EdtPatch);
	DDX_Control(pDX, IDC_SAVE, m_ButSave);
	DDX_Control(pDX, IDC_CHANGE, m_ButChange);
	DDX_Control(pDX, IDC_EXIT, m_ButExit);
	DDX_Control(pDX, IDC_EDTWEB, m_EdtWeb);
	DDX_Control(pDX, IDC_EDTTEL, m_EdtTel);
	DDX_Control(pDX, IDC_EDTName, m_EdtName);
	DDX_Control(pDX, IDC_EDTLINKMAN, m_EdtLinkMan);
	DDX_Control(pDX, IDC_EDTFAX, m_EdtFax);
	DDX_Control(pDX, IDC_EDTADDR, m_EdtAddr);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CDSetup, CDialog)
	//{{AFX_MSG_MAP(CDSetup)
	ON_BN_CLICKED(IDC_CHANGE, OnChange)
	ON_BN_CLICKED(IDC_SAVE, OnSave)
	ON_BN_CLICKED(IDC_BUTPACH, OnButpach)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CDSetup message handlers

void CDSetup::OnOK() 
{
	// TODO: Add extra validation here
	
	//CDialog::OnOK();
}

void CDSetup::OnChange() 
{
	this->Enabled(true);
	this->m_EdtName.SetFocus();
}

void CDSetup::Enabled(bool bEnabled)
{
	this->m_EdtAddr.EnableWindow(bEnabled);
	this->m_EdtFax.EnableWindow(bEnabled);
	this->m_EdtLinkMan.EnableWindow(bEnabled);
	this->m_EdtName.EnableWindow(bEnabled);
	this->m_EdtTel.EnableWindow(bEnabled);
	this->m_EdtWeb.EnableWindow(bEnabled);
	this->m_ButChange.EnableWindow(!bEnabled);
	this->m_ButExit.EnableWindow(!bEnabled);
	this->m_ButSave.EnableWindow(bEnabled);
	this->m_EdtPatch.EnableWindow(bEnabled);
	this->m_ButPach.EnableWindow(bEnabled);
}

void CDSetup::Display()
{
	CString sEdtAddr,sEdtFax,sEdtLinkMan,sEdtName,sEdtTel,sEdtWeb,sEdtPatch;

	RxRecordset disRst;
	disRst.Open("系统设置表");
	disRst.MoveFirst();

	sEdtAddr=disRst.GetFieldValue("地址");
	sEdtFax=disRst.GetFieldValue("传真");
	sEdtLinkMan=disRst.GetFieldValue("联系人");
	sEdtName=disRst.GetFieldValue("公司名称");
	sEdtTel=disRst.GetFieldValue("电话");
	sEdtWeb=disRst.GetFieldValue("网址");
	sEdtPatch=disRst.GetFieldValue("备份路径");

	m_EdtAddr.SetWindowText(sEdtAddr);
	m_EdtFax.SetWindowText(sEdtFax);
	m_EdtLinkMan.SetWindowText(sEdtLinkMan);
	m_EdtName.SetWindowText(sEdtName);
	m_EdtTel.SetWindowText(sEdtTel);
	m_EdtWeb.SetWindowText(sEdtWeb);
	m_EdtPatch.SetWindowText(sEdtPatch);

	disRst.Close();

}

BOOL CDSetup::OnInitDialog() 
{
	CDialog::OnInitDialog();
	this->Display();	
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CDSetup::OnSave() 
{
	if(MessageBox("确定要保存记录吗？","系统提示",MB_OKCANCEL|MB_ICONQUESTION)==1)	
	{
		CString sSQL,sEdtAddr,sEdtFax,sEdtLinkMan,sEdtName,sEdtTel,sEdtWeb,sEdtPatch;
		m_EdtAddr.GetWindowText(sEdtAddr);
		m_EdtFax.GetWindowText(sEdtFax);
		m_EdtLinkMan.GetWindowText(sEdtLinkMan);
		m_EdtName.GetWindowText(sEdtName);
		m_EdtTel.GetWindowText(sEdtTel);
		m_EdtWeb.GetWindowText(sEdtWeb);
		m_EdtPatch.GetWindowText(sEdtPatch);
		sSQL.Format("UPDATE 系统设置表 SET 公司名称='%s',地址='%s',电话='%s',传真='%s',联系人='%s',网址='%s',备份路径='%s'",sEdtName,sEdtAddr,sEdtTel,sEdtFax,sEdtLinkMan,sEdtWeb,sEdtPatch);
		RxRecordset rst;
		rst.Open(sSQL,adCmdText);
		HKEY key;
		CString kpatch;
		LPSTR pstr;
		pstr=sEdtPatch.GetBuffer(sEdtPatch.GetLength());

		kpatch="Software\\Microsoft\\MSSQLServer\\MSSQLServer";
		
		::RegOpenKey(HKEY_LOCAL_MACHINE,kpatch,&key);
		::RegSetValueEx(key,"BackupDirectory",0,REG_SZ,(const unsigned char*)pstr,sEdtPatch.GetLength());
		::RegCloseKey(key);

		this->Enabled(false);
	}		
}



void CDSetup::OnButpach() 
{
	CString sPath=theApp.ShowPath();
	if(sPath.IsEmpty())
		return;
	m_EdtPatch.SetWindowText(sPath);
}