?? connectdatabase.cpp
字號(hào):
// ConnectDatabase.cpp : 實(shí)現(xiàn)文件
//
#include "stdafx.h"
#include "NongCheManage.h"
#include "ConnectDatabase.h"
#include ".\connectdatabase.h"
// CConnectDatabase 對(duì)話框
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("連接數(shù)據(jù)庫(kù)服務(wù)器失敗!");
exit(0);
}
if((theApp.AttachSqlDB("NJ2007",file1,file2)))
{
AfxMessageBox("成功連接數(shù)據(jù)庫(kù),請(qǐng)退出后重新登錄!");
CDialog::OnOK();
}
else
{
AfxMessageBox("連接數(shù)據(jù)庫(kù)失敗!");
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("數(shù)據(jù)庫(kù)文件 (*.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("當(dāng)前正執(zhí)行文件拒絕任何操作!","警告",MB_ICONEXCLAMATION);
return;
}
else
SetDlgItemText(IDC_MDFFILEPATH,dlg.GetPathName());
}
else
MessageBox("未選擇數(shù)據(jù)庫(kù)文件!","警告",MB_ICONEXCLAMATION);
}
void CConnectDatabase::OnBnClickedBrowseldffile()
{
CString filename=_T("數(shù)據(jù)庫(kù)文件 (*.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("當(dāng)前正執(zhí)行文件拒絕任何操作!","警告",MB_ICONEXCLAMATION);
return;
}
else
SetDlgItemText(IDC_LDFFILEPATH,dlg.GetPathName());
}
else
MessageBox("未選擇數(shù)據(jù)庫(kù)文件!","警告",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;
}
?? 快捷鍵說(shuō)明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -