dlgdatabaselinkconfig.cpp

基础数据管理工具 主要针对政务系统的基础数据管理、分析、应用等功能！ 项目代码

// DlgDataBaseLinkConfig.cpp : implementation file
//

#include "stdafx.h"
#include "BaseFunc.h"
#include "DlgDataBaseLinkConfig.h"

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

/////////////////////////////////////////////////////////////////////////////
// CDlgDataBaseLinkConfig dialog
extern CBaseFuncApp theApp;

CDlgDataBaseLinkConfig::CDlgDataBaseLinkConfig(CWnd* pParent /*=NULL*/)
	: CDialog(CDlgDataBaseLinkConfig::IDD, pParent)
{
	//{{AFX_DATA_INIT(CDlgDataBaseLinkConfig)
	m_edtLinkName = _T("");
	m_edtLinkTNS = _T("(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=)(PORT=1521)))(CONNECT_DATA=(SID=)(SERVER=DEDICATED)))");
	m_edtLinkUserName = _T("");
	m_edtLinkUserPassWord = _T("");
	m_edtLinkHost = _T("");
	m_edtLinkPort = _T("1521");
	m_edtLinkSID = _T("");
	//}}AFX_DATA_INIT
}


void CDlgDataBaseLinkConfig::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CDlgDataBaseLinkConfig)
	DDX_Text(pDX, IDC_EDIT_LINK_NAME, m_edtLinkName);
	DDX_Text(pDX, IDC_EDIT_LINK_TNS, m_edtLinkTNS);
	DDX_Text(pDX, IDC_EDIT_LINK_USER_NAME, m_edtLinkUserName);
	DDX_Text(pDX, IDC_EDIT_LINK_USER_PASSWORD, m_edtLinkUserPassWord);
	DDX_Text(pDX, IDC_EDIT_LINK_HOST, m_edtLinkHost);
	DDX_Text(pDX, IDC_EDIT_LINK_PORT, m_edtLinkPort);
	DDX_Text(pDX, IDC_EDIT_LINK_SID, m_edtLinkSID);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CDlgDataBaseLinkConfig, CDialog)
	//{{AFX_MSG_MAP(CDlgDataBaseLinkConfig)
	ON_BN_CLICKED(IDC_BUTTON_TEST_CONNECT, OnButtonTestConnect)
	ON_EN_CHANGE(IDC_EDIT_LINK_HOST, OnChangeEditLinkHost)
	ON_EN_CHANGE(IDC_EDIT_LINK_PORT, OnChangeEditLinkPort)
	ON_EN_CHANGE(IDC_EDIT_LINK_SID, OnChangeEditLinkSid)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CDlgDataBaseLinkConfig message handlers

int CDlgDataBaseLinkConfig::DoModal() 
{
	HINSTANCE hOld = AfxGetResourceHandle();
	AfxSetResourceHandle(theApp.m_hInstance);
	int res = CDialog::DoModal();
	AfxSetResourceHandle(hOld);
	return res;
}

BOOL CDlgDataBaseLinkConfig::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	UpdateData(FALSE);
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CDlgDataBaseLinkConfig::OnChangeEditLinkHost() 
{
	UpdateData();
	int nPos = m_edtLinkTNS.Find("(HOST=");
	nPos += 6;	//Host字符串的起始位置
	m_edtLinkTNS.Delete(nPos,m_edtLinkTNS.Find(")",nPos)-nPos);
	m_edtLinkTNS.Insert(nPos,m_edtLinkHost);
	UpdateData(FALSE);
}

void CDlgDataBaseLinkConfig::OnChangeEditLinkPort() 
{
	UpdateData();
	int nPos = m_edtLinkTNS.Find("(PORT=");
	nPos += 6;	//Host字符串的起始位置
	m_edtLinkTNS.Delete(nPos,m_edtLinkTNS.Find(")",nPos)-nPos);
	m_edtLinkTNS.Insert(nPos,m_edtLinkPort);
	UpdateData(FALSE);
}

void CDlgDataBaseLinkConfig::OnChangeEditLinkSid() 
{
	UpdateData();
	int nPos = m_edtLinkTNS.Find("(SID=");
	nPos += 5;	//Host字符串的起始位置
	m_edtLinkTNS.Delete(nPos,m_edtLinkTNS.Find(")",nPos)-nPos);
	m_edtLinkTNS.Insert(nPos,m_edtLinkSID);
	UpdateData(FALSE);
}

void CDlgDataBaseLinkConfig::OnButtonTestConnect() 
{
	if(TestDBLinkConnective())
	{
		if(MessageBox("测试通过,是否自动关闭配置窗体并使用该配置？\n选[是]关闭","提示",MB_YESNO)==IDYES)
			CDialog::OnOK();
	}
	else
		MessageBox("测试失败!\n请查询配置信息是否正确","提示");
}

void CDlgDataBaseLinkConfig::OnOK() 
{
	// TODO: Add extra validation here
	if(!TestDBLinkConnective())
	{
		MessageBox("连接失败!\n请查询配置信息是否正确","提示");
		return;
	}
	CDialog::OnOK();
}

bool CDlgDataBaseLinkConfig::TestDBLinkConnective()
{
	UpdateData();
	if(m_edtLinkHost.IsEmpty())
	{
		MessageBox("请输入[主机名]","提示");
		GetDlgItem(IDC_EDIT_LINK_HOST)->SetFocus();
		return false;
	}
	if(m_edtLinkPort.IsEmpty())
	{
		MessageBox("请输入[端口号]","提示");
		GetDlgItem(IDC_EDIT_LINK_PORT)->SetFocus();
		return false;
	}
	if(m_edtLinkSID.IsEmpty())
	{
		MessageBox("请输入[SID]","提示");
		GetDlgItem(IDC_EDIT_LINK_SID)->SetFocus();
		return false;
	}
	if(m_edtLinkUserName.IsEmpty())
	{
		MessageBox("请输入[用户名称]","提示");
		GetDlgItem(IDC_EDIT_LINK_USER_NAME)->SetFocus();
		return false;
	}	
	if(m_edtLinkUserPassWord.IsEmpty())
	{
		MessageBox("请输入[用户密码]","提示");
		GetDlgItem(IDC_EDIT_LINK_USER_PASSWORD)->SetFocus();
		return false;
	}	
	bool bReturn = m_pOraHandler->ResetDataBaseLink(m_edtLinkName,m_edtLinkTNS,m_edtLinkUserName,m_edtLinkUserPassWord);
	return(bReturn);
}