// DelAreaDlg.cpp : 實現文件
//

#include "stdafx.h"
#include "House.h"
#include "DelAreaDlg.h"
#include ".\delareadlg.h"


// CDelAreaDlg 對話框

IMPLEMENT_DYNAMIC(CDelAreaDlg, CDialog)
CDelAreaDlg::CDelAreaDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CDelAreaDlg::IDD, pParent)
{
	m_pDB = NULL;
}

CDelAreaDlg::~CDelAreaDlg()
{
}

void CDelAreaDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	DDX_Control(pDX, IDC_COMBO1, m_AreaList);
}


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


// CDelAreaDlg 消息處理程序
void CDelAreaDlg::SetDB( CDaoDatabase *pDB )
{
	m_pDB = pDB;
}

void CDelAreaDlg::OnBnClickedOk()
{
	UpdateData();
	CString temp,name;
	// 得到當前選擇的區域名
	m_AreaList.GetLBText(m_AreaList.GetCurSel(),name );
	temp.Format("您確定要刪除區域 %s 嗎?",name);
	if( MessageBox(temp,"提示",MB_YESNO) == IDNO)
		return;
	name.Replace("'","''");
	temp.Format("DROP TABLE %s",name);
	try
	{
		m_pDB->Execute( temp );
	}
	catch(...)
	{
		MessageBox("表刪除失敗");
		return;
	}
	// 重新打開數據庫，以適應更改
	try
	{
		m_pDB->Close();
		m_pDB->Open("house.mdb");
	}
	catch(...)
	{
		MessageBox("數據庫打開失敗");
	}
	LoadName();
}
// 將所有的區名讀入List框
void CDelAreaDlg::LoadName()
{
	// 刪除所有記錄
	while(m_AreaList.GetCount() > 0 )
		m_AreaList.DeleteString(0);

	CDaoTableDefInfo info;
	for( int i = 0; i < m_pDB->GetTableDefCount(); i++ )
	{
		m_pDB->GetTableDefInfo(i,info);
		if( info.m_lAttributes & dbSystemObject )
			continue;
		m_AreaList.AddString( info.m_strName );
	}
	if( m_AreaList.GetCount() > 0 )
		m_AreaList.SetCurSel( 0 );
}

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

	// TODO:  在此添加額外的初始化
	LoadName();

	return TRUE;  // return TRUE unless you set the focus to a control
	// 異常: OCX 屬性頁應返回 FALSE
}