// NameQuryDlg.cpp : implementation file
//

#include "stdafx.h"
#include "NameGis.h"
#include "NameQuryDlg.h"
#include "MainFrm.h"
#include "NameGisView.h"
#include "MapControlView.h"
#include "AppApi.h"
#include "Crack.h"

// CNameQuryDlg dialog

IMPLEMENT_DYNAMIC(CNameQuryDlg, CDialog)
CNameQuryDlg::CNameQuryDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CNameQuryDlg::IDD, pParent)
	, m_BothCondt(FALSE)
	, m_NameCondt(FALSE)
	, m_PhoneCondt(FALSE)
{
}

CNameQuryDlg::~CNameQuryDlg()
{
}

void CNameQuryDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	DDX_Control(pDX, IDC_NAMEQUERY_NAMEEDIT, m_NameEdt);
	DDX_Control(pDX, IDC_NAMEQUERY_PHONEEDIT, m_PhoneEdt);
	DDX_Control(pDX, IDC_NAMEQUERY_MAINCLASS, m_MainFilter);
	DDX_Control(pDX, IDC_NAMEQUERY_CHILDCLASS, m_ChildFilter);
	DDX_Check(pDX, IDC_NAMEQUERY_BOTHCONDT, m_BothCondt);
	DDX_Check(pDX, IDC_NAMEQUERY_NAMECONDT, m_NameCondt);
	DDX_Check(pDX, IDC_NAMEQUERY_PHONECONDT, m_PhoneCondt);
}


BEGIN_MESSAGE_MAP(CNameQuryDlg, CDialog)
	ON_CBN_SELCHANGE(IDC_NAMEQUERY_MAINCLASS, OnCbnSelchangeNamequeryMainclass)
	ON_BN_CLICKED(IDC_NAMEQUERY_EXECUTEBTN, OnBnClickedNamequeryExecutebtn)
END_MESSAGE_MAP()


// CNameQuryDlg message handlers
//----------------------------------------------------------------------------------------------
BOOL CNameQuryDlg::OnInitDialog()
{
	CDialog::OnInitDialog();

	CMainFrame* pMainWnd = (CMainFrame*)AfxGetMainWnd();
	CNameGisView* pMapView = (CNameGisView*)(pMainWnd->m_wndSplitter.GetPane(0,0));
	//初始化大類過濾器	
	pMapView->LoadFilter(&m_MainFilter);
	//初始化中類過濾器
	pMapView->LoadFilter2(&m_ChildFilter, "(全部類型)", false);

	return TRUE;
}
//----------------------------------------------------------------------------------------------
void CNameQuryDlg::OnCbnSelchangeNamequeryMainclass()
{
	CMainFrame* pMainWnd = (CMainFrame*)AfxGetMainWnd();
	CNameGisView* pMapView = (CNameGisView*)(pMainWnd->m_wndSplitter.GetPane(0,0));

	CString szType;
	m_MainFilter.GetLBText(m_MainFilter.GetCurSel(), szType);
	pMapView->LoadFilter2(&m_ChildFilter, szType, false);
	m_ChildFilter.SetCurSel(0);
}
//----------------------------------------------------------------------------------------------
void CNameQuryDlg::OnBnClickedNamequeryExecutebtn()
{
	// 刷新對話框
	UpdateData(TRUE);

	CString szSQL = "";
	CString szSQL2 = "";
	CString szFilter = "";

	CString szType;
	// 得到大類類型
	m_MainFilter.GetLBText(m_MainFilter.GetCurSel(), szType);
	CString szSubType;
	// 得到中類類型
	m_ChildFilter.GetLBText(m_ChildFilter.GetCurSel(), szSubType);  
	
	if ((szSubType == "(全部子類型)") || ("" == szSubType))
	{
		if((szType != "") && (szType != "(全部類型)"))
		{
			szFilter = "類型='" + szType + "' ";
		}
	}
	else
	{
		szFilter = "中類型='" + szSubType + "' ";
	}
		
	CString strName;
	// 得到用戶輸入的地名
	m_NameEdt.GetWindowText(strName);
	if ( strName != "")  
	{
		if (m_NameCondt)  
			szSQL = "(名稱 like '" + strName + "%')";
		else
			szSQL = "(名稱 like '" + strName + "')";
	}

	CString strPhone;
	// 得到用戶輸入的電話
	m_PhoneEdt.GetWindowText(strPhone);
	if (strPhone != "" )
	{
		if (m_PhoneCondt)  
			szSQL2 = "(電話 like '" + strPhone + "%')";
		else
			szSQL2 = "(電話 like '" + strPhone + "')";
	}

	// 設置查詢語句
	if (szSQL == "" )
	{
		szSQL = szSQL2;
	}
	else
	{
		if (szSQL2 != "")
			if (m_BothCondt)  
				szSQL = szSQL + " And " + szSQL2;
			else
				szSQL = szSQL + " Or " + szSQL2;
	}

	if (szFilter != "")
	{
		if (szSQL == "")
			szSQL = szFilter;
		else
			szSQL = szSQL + " AND (" + szFilter + ")"; 
	}

	Query(szSQL);
}
//----------------------------------------------------------------------------------------------
//功能：查詢結果顯示在“查詢結果”面板上
BOOL CNameQuryDlg::Query(CString szFilter)
{
	CMainFrame* pMainWnd = (CMainFrame*)AfxGetMainWnd();
	CMapControlView* pCtrlView = (CMapControlView*)(pMainWnd->
		                      m_wndSplitter2.GetPane(0,0));
	CDaoDatabase* tmpDB = new CDaoDatabase;
	try
	{
		tmpDB->Open(pMainWnd->m_environment.m_szDBName);
	}
	catch (CDaoException* e)
	{
		DisplayDaoException(e);
		delete tmpDB;
		e->Delete();
		return FALSE;
	}

	CDaoRecordset rs(tmpDB);
	try
	{
		CString szSQL;
		if (szFilter == "")
			szSQL = "Select * From 地名索引 Order By 名稱";
		else
			szSQL = "Select * From 地名索引 Where " + szFilter +" Order By 名稱";		
		rs.Open(dbOpenDynaset, szSQL);
		int nCount = rs.GetRecordCount();

		CListBox* pResultListBox = &(pCtrlView->m_ResultListBox);
		pResultListBox->ResetContent();
		COleVariant var;
		while(!rs.IsEOF())
		{			
			var = rs.GetFieldValue("名稱");
			pResultListBox->AddString(CCrack::strVARIANT(var));

			rs.MoveNext();
		}
		pResultListBox->AddString("北師大出版社");
		pResultListBox->AddString("北師大出版社讀者服務部");
	}
	catch (CDaoException* e)
	{
		DisplayDaoException(e);
		tmpDB->Close();
		delete tmpDB;
		e->Delete();
		return FALSE;
	}

	if(tmpDB)
	{
		if(tmpDB->IsOpen())
		{
			tmpDB->Close();
		}

		delete tmpDB;
		tmpDB = NULL;
	}

	pCtrlView->m_OperaTab.SetCurSel(2);
	pCtrlView->m_MapIndexTreeView.ModifyStyle(WS_VISIBLE, 0, 0);
	pCtrlView->m_LayerTreeView.ModifyStyle(WS_VISIBLE, 0, 0);
	pCtrlView->m_ResultListBox.ModifyStyle(0, WS_VISIBLE, 0);
	pCtrlView->m_ContentBtn.ModifyStyle(0, WS_VISIBLE, 0);
	pCtrlView->m_PositingBtn.ModifyStyle(0, WS_VISIBLE, 0);
	pCtrlView->Invalidate(TRUE);

	return TRUE;
}
//----------------------------------------------------------------------------------------------