connectdatabase.cpp

一个农用车辆管理系统的雏形

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

#include "stdafx.h"
#include "NongCheManage.h"
#include "ConnectDatabase.h"
#include ".\connectdatabase.h"


// CConnectDatabase 对话框

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

CConnectDatabase::~CConnectDatabase()
{
}

void CConnectDatabase::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	DDX_Control(pDX, IDC_MDFFILEPATH, m_mdffilepath);
	DDX_Control(pDX, IDC_LDFFILEPATH, m_ldffilepath);
}


BEGIN_MESSAGE_MAP(CConnectDatabase, CDialog)
	ON_BN_CLICKED(IDCANCEL, OnBnClickedCancel)
	ON_BN_CLICKED(IDOK, OnBnClickedOk)
	ON_BN_CLICKED(IDC_BROWSEMDFFILE, OnBnClickedBrowsemdffile)
	ON_BN_CLICKED(IDC_BROWSELDFFILE, OnBnClickedBrowseldffile)
	ON_BN_CLICKED(IDC_OPENSQLRUN, OnBnClickedOpensqlrun)
END_MESSAGE_MAP()


// CConnectDatabase 消息处理程序

void CConnectDatabase::OnBnClickedCancel()
{
	// TODO: 在此添加控件通知处理程序代码
	OnCancel();
}

void CConnectDatabase::OnBnClickedOk()
{
	CString file1(_T(""));
	CString file2(_T(""));
	GetDlgItemText(IDC_MDFFILEPATH,file1);
	GetDlgItemText(IDC_LDFFILEPATH,file2);
	if(!(file1.IsEmpty() && file2.IsEmpty()))
	{
		if(!(theApp.ConSqlDB()))
		{
			AfxMessageBox("连接数据库服务器失败!");
			exit(0);
		}
		if((theApp.AttachSqlDB("NJ2007",file1,file2)))
		{
			AfxMessageBox("成功连接数据库,请退出后重新登录!");
			CDialog::OnOK();
		}
		else
		{
			AfxMessageBox("连接数据库失败!");
			exit(0);
		}
	}
	else
	{
		if(file1.IsEmpty())
		{
			AfxMessageBox("必须指定MDF文件!");
			GotoDlgCtrl(GetDlgItem(IDC_MDFFILEPATH));
			return;
		}
		if(file2.IsEmpty())
		{
			AfxMessageBox("必须指定LDF文件!");
			GotoDlgCtrl(GetDlgItem(IDC_LDFFILEPATH));
			return;
		}
	}
	OnOK();
}

void CConnectDatabase::OnBnClickedBrowsemdffile()
{
	CString filename=_T("数据库文件 (*.mdf)|*.mdf||");
	CFileDialog dlg(TRUE,NULL,"NJ2007_Data.mdf",OFN_HIDEREADONLY|OFN_OVERWRITEPROMPT,filename);
	if(dlg.DoModal()==IDOK)
	{
		char exeFullPath[MAX_PATH];
		GetModuleFileName(NULL,exeFullPath,MAX_PATH);
		CString str(exeFullPath);
		if(dlg.GetPathName().MakeUpper()==str.MakeUpper())
		{
			MessageBox("当前正执行文件拒绝任何操作！","警告",MB_ICONEXCLAMATION);
			return;
		}
		else
			SetDlgItemText(IDC_MDFFILEPATH,dlg.GetPathName());
	}
	else
		MessageBox("未选择数据库文件！","警告",MB_ICONEXCLAMATION);
}

void CConnectDatabase::OnBnClickedBrowseldffile()
{
	CString filename=_T("数据库文件 (*.ldf)|*.ldf||");
	CFileDialog dlg(TRUE,NULL,"NJ2007_Log.ldf",OFN_HIDEREADONLY|OFN_OVERWRITEPROMPT,filename);
	if(dlg.DoModal()==IDOK)
	{
		char exeFullPath[MAX_PATH];
		GetModuleFileName(NULL,exeFullPath,MAX_PATH);
		CString str(exeFullPath);
		if(dlg.GetPathName().MakeUpper()==str.MakeUpper())
		{
			MessageBox("当前正执行文件拒绝任何操作！","警告",MB_ICONEXCLAMATION);
			return;
		}
		else
			SetDlgItemText(IDC_LDFFILEPATH,dlg.GetPathName());
	}
	else
		MessageBox("未选择数据库文件！","警告",MB_ICONEXCLAMATION);
}

void CConnectDatabase::OnBnClickedOpensqlrun()
{
	ShellExecute(this->m_hWnd,"open","sqlmangr.exe","","", SW_HIDE );
}

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

	m_mdffilepath.setFont(14);
	m_ldffilepath.setFont(14);
	m_mdffilepath.textColor(RGB(0,0,128));
	m_ldffilepath.textColor(RGB(0,0,128));

	return TRUE;
}