// SearchCheckOutDLG.cpp : implementation file
//

#include "stdafx.h"
#include "hotel_mis.h"
#include "SearchCheckOutDLG.h"
#include "Hotel_MISView.h"

#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

/////////////////////////////////////////////////////////////////////////////
// CSearchCheckOutDLG dialog


CSearchCheckOutDLG::CSearchCheckOutDLG(CWnd* pParent /*=NULL*/)
	: CDialog(CSearchCheckOutDLG::IDD, pParent)
{
	//{{AFX_DATA_INIT(CSearchCheckOutDLG)
	m_tInDate = COleDateTime::GetCurrentTime();
	m_bInDate = FALSE;
	m_sName = _T("");
	m_bName = true;
	m_sRoomNo = _T("");
	m_bRoomNo = FALSE;
	//}}AFX_DATA_INIT
}


void CSearchCheckOutDLG::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CSearchCheckOutDLG)
	DDX_DateTimeCtrl(pDX, IDD_SEARCHCHECKOUT_INDATE, m_tInDate);
	DDX_Check(pDX, IDD_SEARCHCHECKOUT_INDATECHECK, m_bInDate);
	DDX_Text(pDX, IDD_SEARCHCHECKOUT_NAME, m_sName);
	DDX_Check(pDX, IDD_SEARCHCHECKOUT_NAMECHECK, m_bName);
	DDX_Text(pDX, IDD_SEARCHCHECKOUT_NO, m_sRoomNo);
	DDX_Check(pDX, IDD_SEARCHCHECKOUT_NOCHECK, m_bRoomNo);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CSearchCheckOutDLG, CDialog)
	//{{AFX_MSG_MAP(CSearchCheckOutDLG)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CSearchCheckOutDLG message handlers

void CSearchCheckOutDLG::OnOK() 
{
	// TODO: Add extra validation here
	UpdateData(true);
	
	m_sName.TrimRight(" ");
	m_sRoomNo.TrimRight(" ");
    
	if ( !(m_bName||m_bRoomNo||m_bInDate) )
	{
		AfxMessageBox(_T("請選擇查詢條件！"), MB_ICONEXCLAMATION);
		return;
	}
	
	if ( m_bName && ""==m_sName  )
	{
		AfxMessageBox(_T("顧客姓名不能為空"), MB_ICONEXCLAMATION);
	    return;
	}
    if ( m_bRoomNo && ""==m_sRoomNo  )
	{
		AfxMessageBox(_T("客房編號不能為空"), MB_ICONEXCLAMATION);
	    return;
	}
	
	CString sTime = m_tInDate.Format("%Y-%m-%d");
	if ( !m_bName ) m_sName = "%";
	if ( !m_bRoomNo ) m_sRoomNo = "%";
    
	_variant_t strQuery;
	if ( !m_bInDate ) strQuery = "select * from bookin where customname like '"+m_sName+"' and roomno like '"+m_sRoomNo+"' and checkdate is not NULL";
    else strQuery = "select * from bookin where customname like '"+m_sName+"' and roomno like '"+m_sRoomNo+"' and indate='"+sTime+"' and checkdate is not NULL";
	
	CHotel_MISView* p = (CHotel_MISView*)(((CMainFrame*)AfxGetMainWnd())->GetActiveView());
	p->RefreshCheckOut(strQuery);
	
	//CDialog::OnOK();
}