// HouseDlg.cpp : 實(shí)現(xiàn)文件
//

#include "stdafx.h"
#include "House.h"
#include "HouseDlg.h"
#include ".\housedlg.h"
#include "AddAreaDlg.h"
#include "DelAreaDlg.h"
#include "EditDataDlg.h"

#ifdef _DEBUG
#define new DEBUG_NEW
#endif


// 用于應(yīng)用程序“關(guān)于”菜單項(xiàng)的 CAboutDlg 對(duì)話框

class CAboutDlg : public CDialog
{
public:
	CAboutDlg();

// 對(duì)話框數(shù)據(jù)
	enum { IDD = IDD_ABOUTBOX };

	protected:
	virtual void DoDataExchange(CDataExchange* pDX);    // DDX/DDV 支持

// 實(shí)現(xiàn)
protected:
	DECLARE_MESSAGE_MAP()
};

CAboutDlg::CAboutDlg() : CDialog(CAboutDlg::IDD)
{
}

void CAboutDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
}

BEGIN_MESSAGE_MAP(CAboutDlg, CDialog)
END_MESSAGE_MAP()


// CHouseDlg 對(duì)話框



CHouseDlg::CHouseDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CHouseDlg::IDD, pParent)
{
	m_hIcon = AfxGetApp()->LoadIcon(IDR_MAINFRAME);
	m_pImageList = NULL;
	m_pDB = NULL;
	m_pRecordSet = NULL;
}

void CHouseDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	DDX_Control(pDX, IDC_COMBO1, m_Area);
	DDX_Control(pDX, IDC_HOUSELIST, m_List);
}

BEGIN_MESSAGE_MAP(CHouseDlg, CDialog)
	ON_WM_SYSCOMMAND()
	ON_WM_PAINT()
	ON_WM_QUERYDRAGICON()
	//}}AFX_MSG_MAP
	ON_BN_CLICKED(IDCANCEL, OnBnClickedCancel)
	ON_BN_CLICKED(IDC_BTADD, OnBnClickedBtadd)
	ON_BN_CLICKED(IDC_BTDEL, OnBnClickedBtdel)
	ON_BN_CLICKED(IDC_EDITCUR, OnBnClickedEditcur)
	ON_CBN_SELCHANGE(IDC_COMBO1, OnCbnSelchangeCombo1)
END_MESSAGE_MAP()


// CHouseDlg 消息處理程序
BOOL CHouseDlg::OnInitDialog()
{
	CDialog::OnInitDialog();

	// 將\“關(guān)于...\”菜單項(xiàng)添加到系統(tǒng)菜單中。

	// IDM_ABOUTBOX 必須在系統(tǒng)命令范圍內(nèi)。
	ASSERT((IDM_ABOUTBOX & 0xFFF0) == IDM_ABOUTBOX);
	ASSERT(IDM_ABOUTBOX < 0xF000);

	CMenu* pSysMenu = GetSystemMenu(FALSE);
	if (pSysMenu != NULL)
	{
		CString strAboutMenu;
		strAboutMenu.LoadString(IDS_ABOUTBOX);
		if (!strAboutMenu.IsEmpty())
		{
			pSysMenu->AppendMenu(MF_SEPARATOR);
			pSysMenu->AppendMenu(MF_STRING, IDM_ABOUTBOX, strAboutMenu);
		}
	}

	// 設(shè)置此對(duì)話框的圖標(biāo)。當(dāng)應(yīng)用程序主窗口不是對(duì)話框時(shí)，框架將自動(dòng)
	//  執(zhí)行此操作
	SetIcon(m_hIcon, TRUE);			// 設(shè)置大圖標(biāo)
	SetIcon(m_hIcon, FALSE);		// 設(shè)置小圖標(biāo)

	// TODO: 在此添加額外的初始化代碼
	m_pImageList = new CImageList();
	m_pImageList->Create(IDB_BITMAP1, 16, 1, RGB(255,0,0));
	m_List.SetImageList(m_pImageList, LVSIL_SMALL);	/* set extended stlyes*/

	m_List.SetExtendedStyle(LVS_EX_FULLROWSELECT|LVS_EX_GRIDLINES);
	m_List.InsertColumn(0,"小區(qū)名",LVCFMT_CENTER,80);
	m_List.InsertColumn(1,"面積",LVCFMT_LEFT,80);
	m_List.InsertColumn(2,"樓層",LVCFMT_LEFT,50);
	m_List.InsertColumn(3,"價(jià)格",LVCFMT_LEFT,50);
	m_List.InsertColumn(4,"數(shù)量",LVCFMT_LEFT,50);
	m_List.InsertColumn(5,"開(kāi)發(fā)商",LVCFMT_LEFT,70);

	// 初始化數(shù)據(jù)庫(kù)
	try
	{
		m_pDB = new CDaoDatabase();
		m_pDB->Open( "house.mdb" );
	}
	catch(CDaoException* e)
	{
		MessageBox( e->m_pErrorInfo->m_strDescription );
		return false;
	}

	m_pRecordSet=new CDaoRecordset(m_pDB);

	// 讀入地區(qū)名，寫(xiě)入Combo_box控件
	LoadAreaName();

	LoadAllData();

	return TRUE;  // 除非設(shè)置了控件的焦點(diǎn)，否則返回 TRUE
}

void CHouseDlg::OnSysCommand(UINT nID, LPARAM lParam)
{
	if ((nID & 0xFFF0) == IDM_ABOUTBOX)
	{
		CAboutDlg dlgAbout;
		dlgAbout.DoModal();
	}
	else
	{
		CDialog::OnSysCommand(nID, lParam);
	}
}

// 如果向?qū)υ捒蛱砑幼钚』粹o，則需要下面的代碼
//  來(lái)繪制該圖標(biāo)。對(duì)于使用文檔/視圖模型的 MFC 應(yīng)用程序，
//  這將由框架自動(dòng)完成。

void CHouseDlg::OnPaint() 
{
	if (IsIconic())
	{
		CPaintDC dc(this); // 用于繪制的設(shè)備上下文

		SendMessage(WM_ICONERASEBKGND, reinterpret_cast<WPARAM>(dc.GetSafeHdc()), 0);

		// 使圖標(biāo)在工作矩形中居中
		int cxIcon = GetSystemMetrics(SM_CXICON);
		int cyIcon = GetSystemMetrics(SM_CYICON);
		CRect rect;
		GetClientRect(&rect);
		int x = (rect.Width() - cxIcon + 1) / 2;
		int y = (rect.Height() - cyIcon + 1) / 2;

		// 繪制圖標(biāo)
		dc.DrawIcon(x, y, m_hIcon);
	}
	else
	{
		CDialog::OnPaint();
	}
}

//當(dāng)用戶拖動(dòng)最小化窗口時(shí)系統(tǒng)調(diào)用此函數(shù)取得光標(biāo)顯示。
HCURSOR CHouseDlg::OnQueryDragIcon()
{
	return static_cast<HCURSOR>(m_hIcon);
}
// 釋放所有資源
void CHouseDlg::ReleaseAll()
{
	if( m_pImageList != NULL )
	{
		m_pImageList->DeleteImageList();
		delete m_pImageList;
		m_pImageList = NULL;
	}
	if( m_pRecordSet != NULL )
	{
		m_pRecordSet->Close();
		delete m_pRecordSet;
		m_pRecordSet = NULL;
	}
	if( m_pDB != NULL )
	{
		m_pDB->Close();
		delete m_pDB;
		m_pDB = NULL;
	}
}

void CHouseDlg::OnBnClickedCancel()
{
	ReleaseAll();
	OnCancel();
}
// 讀入地區(qū)名，寫(xiě)入Combo_box控件
void CHouseDlg::LoadAreaName()
{
	while( m_Area.GetCount() > 0 )
		m_Area.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_Area.AddString( info.m_strName );
	}
	if( m_Area.GetCount() > 0 )
		m_Area.SetCurSel(0);
}
// 添加區(qū)域
void CHouseDlg::OnBnClickedBtadd()
{
	CADDAreaDlg dlg;
	dlg.SetDB( m_pDB );
	dlg.DoModal();
	// 重新讀入?yún)^(qū)域
	LoadAreaName();
}

void CHouseDlg::OnBnClickedBtdel()
{
	CDelAreaDlg dlg;
	dlg.SetDB( m_pDB );
	dlg.DoModal();
	// 重新讀入?yún)^(qū)域
	LoadAreaName();
}
// 讀入表的所有記錄
void CHouseDlg::LoadAllData( )
{
	CString table;
	m_Area.GetLBText( m_Area.GetCurSel(), table );
	if( table == "" )
		return;
	if(m_pRecordSet->IsOpen())
	    m_pRecordSet->Close();

	m_List.DeleteAllItems();

	CString sql;
	sql.Format("SELECT * FROM %s",table );
	try
	{
		m_pRecordSet->Open(::dbOpenDynaset,sql );
	}
	catch(...)
	{
		MessageBox("打開(kāi)表失敗");
		return;
	}

	if( m_pRecordSet != NULL )
	{
		for( int i = 0; i < m_pRecordSet->GetRecordCount(); i++ )
		{
			ReSetValue( i, m_pRecordSet );
			m_pRecordSet->MoveNext();
		}
	}
    m_pRecordSet->Close();
}
// 更新第 n 條記錄的顯示
void CHouseDlg::ReSetValue( int n, CDaoRecordset * pSet )
{
	COleVariant value;
	CString name, dev,area,floor,price,num;

	try
	{
		pSet->GetFieldValue("NAME",value);
		if( value.vt == VT_NULL )
			name = "空";
		else
			name.Format("%s", value.bstrVal);
		name.Trim();
		// 面積
		pSet->GetFieldValue("AREA",value);
		if( value.vt == VT_NULL )
			area = "0";
		else
			area.Format("%.2f",value.dblVal);
		// 樓層
		pSet->GetFieldValue("FLOOR",value);
		if( value.vt == VT_NULL )
			floor = "0";
		else
			floor.Format("%.0f",value.dblVal);
		// 價(jià)格
		pSet->GetFieldValue("PRICE",value);
		if( value.vt == VT_NULL )
			price = "0";
		else
			price.Format("%.2f",value.dblVal);
		// 數(shù)量
		pSet->GetFieldValue("NUM",value);
		if( value.vt == VT_NULL )
			num = "0";
		else
			num.Format("%.0f",value.dblVal );
		// 開(kāi)發(fā)商
		pSet->GetFieldValue("DEVELOPER",value );
		if( value.vt == VT_NULL )
			dev = "";
		else
			dev.Format("%s",value.bstrVal);
		dev.Trim();

		m_List.InsertItem(n,name,0);
		m_List.SetItemText(n,1,area);
		m_List.SetItemText(n,2,floor);
		m_List.SetItemText(n,3,price);
		m_List.SetItemText(n,4,num);
		m_List.SetItemText(n,5,dev);
	}
	catch(CDaoException* e)
	{
		MessageBox(e->m_pErrorInfo->m_strDescription);
	}
}

void CHouseDlg::OnCbnSelchangeCombo1()
{
	LoadAllData( );
}

void CHouseDlg::OnBnClickedEditcur()
{
	CString table;
	m_Area.GetLBText( m_Area.GetCurSel(), table );
	if( table == "" )
		return;
	if(m_pRecordSet->IsOpen())
	    m_pRecordSet->Close();

	CString sql;
	sql.Format("SELECT * FROM %s",table );
	try
	{
		m_pRecordSet->Open(::dbOpenDynaset,sql );
	}
	catch(...)
	{
		MessageBox("打開(kāi)表失敗");
		return;
	}

	int k = GetCurSltCount();

	CEditDataDlg dlg;
	dlg.SetCurDate(m_pRecordSet, k);
	dlg.DoModal();

    m_pRecordSet->Close();

	LoadAllData();
}
// 得到當(dāng)前選擇項(xiàng)
int CHouseDlg::GetCurSltCount()
{
	// 是否有選中項(xiàng)
	if(m_List.GetSelectedCount() <= 0)
		return -1;

	for(int i =0;i<m_List.GetItemCount();i++ )
	{
		if(m_List.GetItemState(i,LVIS_SELECTED)==LVIS_SELECTED)//選中狀態(tài)。。
		{
			return i;
		}
	}

	return -1;  // 沒(méi)有找到選中項(xiàng)
}