settingdlg.cpp

自定义格式读取mysql数据库记录。用于批量处理mysql数据库。

// SettingDlg.cpp : 实现文件
//

#include "stdafx.h"

extern CIniFile g_IniFile;
bool g_bSave = false;
// CSettingDlg 对话框

IMPLEMENT_DYNAMIC(CSettingDlg, CDialog)
CSettingDlg::CSettingDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CSettingDlg::IDD, pParent)
{
}

CSettingDlg::~CSettingDlg()
{
}

void CSettingDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	DDX_Control(pDX, IDC_CHECK_SAVE, m_chkSave);
	DDX_Control(pDX, IDC_EDIT_ADDR, m_edtAddr);
	DDX_Control(pDX, IDC_EDIT_PORT, m_edtPort);
	DDX_Control(pDX, IDC_EDIT_NAME, m_edtName);
	DDX_Control(pDX, IDC_EDIT_USER, m_edtUser);
	DDX_Control(pDX, IDC_EDIT_PSWD, m_edtPswd);
}


BEGIN_MESSAGE_MAP(CSettingDlg, CDialog)
	ON_BN_CLICKED(IDOK, OnBnClickedOk)
END_MESSAGE_MAP()


// CSettingDlg 消息处理程序

void CSettingDlg::OnBnClickedOk()
{
	// TODO: 在此添加控件通知处理程序代码
	m_edtAddr.GetWindowText(m_sAddr);
	m_edtPort.GetWindowText(m_sPort);
	m_edtName.GetWindowText(m_sName);
	m_edtUser.GetWindowText(m_sUser);
	m_edtPswd.GetWindowText(m_sPswd);

	if (m_sAddr.IsEmpty()) {
		AfxMessageBox("数据库名称/IP地址不能为空！");
		m_edtAddr.SetFocus();
		return;
	} else if (m_sName.IsEmpty()) {
		AfxMessageBox("数据库不能为空！");
		m_edtName.SetFocus();
		return;
	} else if (m_sPort.IsEmpty()) {
		m_sPort = "3306";
	} else if (m_sUser.IsEmpty()) {
		m_sUser = "root";
	}
	if (m_chkSave.GetCheck() != 0) {
		// save to ini
		g_IniFile.IniFile_WriteString("DATABASE", "HOST", m_sAddr);
		g_IniFile.IniFile_WriteString("DATABASE", "PORT", m_sPort);
		g_IniFile.IniFile_WriteString("DATABASE", "BASE", m_sName);
		g_IniFile.IniFile_WriteString("DATABASE", "USER", m_sUser);
		g_IniFile.IniFile_WriteString("DATABASE", "PSWD", m_sPswd);
		g_IniFile.IniFile_WriteInt("SYSTEM", "SAVE", 1);
	}
	OnOK();
}

BOOL CSettingDlg::OnInitDialog()
{
	CDialog::OnInitDialog();

	CString sAddr, sPort, sName, sUser, sPswd;
	g_IniFile.SetFileName(_T("setting.ini"));
	g_IniFile.IniFile_GetString("DATABASE", "HOST", "127.0.0.1", sAddr);
	g_IniFile.IniFile_GetString("DATABASE", "PORT", "3306", sPort);
	g_IniFile.IniFile_GetString("DATABASE", "BASE", "as_world", sName);
	g_IniFile.IniFile_GetString("DATABASE", "USER", "root", sUser);
	g_IniFile.IniFile_GetString("DATABASE", "PSWD", "test", sPswd);
	g_bSave = g_IniFile.IniFile_GetInt("SYSTEM", "SAVE", 0) == 0 ? false : true;

	m_edtAddr.SetWindowText(sAddr);
	m_edtPort.SetWindowText(sPort);
	m_edtName.SetWindowText(sName);
	m_edtUser.SetWindowText(sUser);
	m_edtPswd.SetWindowText(sPswd);
	m_chkSave.SetCheck(g_bSave ? 1 : 0);
	
	return TRUE;  // 除非设置了控件的焦点，否则返回 TRUE
}