// MyDatabaseView.cpp : implementation of the CMyDatabaseView class
//

#include "stdafx.h"
#include "MyDatabase.h"

#include "MyDatabaseSet.h"
#include "MyDatabaseDoc.h"
#include "MyDatabaseView.h"

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

/////////////////////////////////////////////////////////////////////////////
// CMyDatabaseView

IMPLEMENT_DYNCREATE(CMyDatabaseView, CRecordView)

BEGIN_MESSAGE_MAP(CMyDatabaseView, CRecordView)
	//{{AFX_MSG_MAP(CMyDatabaseView)
	ON_COMMAND(ID_SORT, OnSort)
	ON_COMMAND(ID_MODIFY, OnModify)
	ON_COMMAND(ID_DELETE, OnDelete)
	ON_COMMAND(ID_ADDNEW, OnAddnew)
	ON_BN_CLICKED(IDC_BUTTON1, OnButton1)
	ON_COMMAND(ID_RECORD_FIRST, OnRecordFirst)
	//}}AFX_MSG_MAP
	// Standard printing commands
	ON_COMMAND(ID_FILE_PRINT, CRecordView::OnFilePrint)
	ON_COMMAND(ID_FILE_PRINT_DIRECT, CRecordView::OnFilePrint)
	ON_COMMAND(ID_FILE_PRINT_PREVIEW, CRecordView::OnFilePrintPreview)
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CMyDatabaseView construction/destruction

CMyDatabaseView::CMyDatabaseView()
	: CRecordView(CMyDatabaseView::IDD)
{
	//{{AFX_DATA_INIT(CMyDatabaseView)
	m_pSet = NULL;
	//}}AFX_DATA_INIT
	// TODO: add construction code here
	m_nNum = 0;
	m_bAddMode = false;

}

CMyDatabaseView::~CMyDatabaseView()
{
}

void CMyDatabaseView::DoDataExchange(CDataExchange* pDX)
{
	CRecordView::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CMyDatabaseView)
	DDX_FieldText(pDX, IDC_EDIT1, m_pSet->m_column1, m_pSet);
	DDX_FieldText(pDX, IDC_EDIT2, m_pSet->m_column2, m_pSet);
	DDX_FieldText(pDX, IDC_EDIT3, m_pSet->m_column3, m_pSet);
	DDX_FieldText(pDX, IDC_EDIT4, m_pSet->m_column4, m_pSet);
	DDX_FieldText(pDX, IDC_EDIT5, m_pSet->m_column5, m_pSet);
	//}}AFX_DATA_MAP
}

BOOL CMyDatabaseView::PreCreateWindow(CREATESTRUCT& cs)
{
	// TODO: Modify the Window class or styles here by modifying
	//  the CREATESTRUCT cs

	return CRecordView::PreCreateWindow(cs);
}

void CMyDatabaseView::OnInitialUpdate()
{
	m_pSet = &GetDocument()->m_myDatabaseSet;
	CRecordView::OnInitialUpdate();
	GetParentFrame()->RecalcLayout();
	ResizeParentToFit();

}

/////////////////////////////////////////////////////////////////////////////
// CMyDatabaseView printing

BOOL CMyDatabaseView::OnPreparePrinting(CPrintInfo* pInfo)
{
	// default preparation
	return DoPreparePrinting(pInfo);
}

void CMyDatabaseView::OnBeginPrinting(CDC* /*pDC*/, CPrintInfo* /*pInfo*/)
{
	// TODO: add extra initialization before printing
}

void CMyDatabaseView::OnEndPrinting(CDC* /*pDC*/, CPrintInfo* /*pInfo*/)
{
	// TODO: add cleanup after printing
}

/////////////////////////////////////////////////////////////////////////////
// CMyDatabaseView diagnostics

#ifdef _DEBUG
void CMyDatabaseView::AssertValid() const
{
	CRecordView::AssertValid();
}

void CMyDatabaseView::Dump(CDumpContext& dc) const
{
	CRecordView::Dump(dc);
}

CMyDatabaseDoc* CMyDatabaseView::GetDocument() // non-debug version is inline
{
	ASSERT(m_pDocument->IsKindOf(RUNTIME_CLASS(CMyDatabaseDoc)));
	return (CMyDatabaseDoc*)m_pDocument;
}
#endif //_DEBUG

/////////////////////////////////////////////////////////////////////////////
// CMyDatabaseView database support
CRecordset* CMyDatabaseView::OnGetRecordset()
{
	return m_pSet;
}


/////////////////////////////////////////////////////////////////////////////
// CMyDatabaseView message handlers

void CMyDatabaseView::OnSort() 
{
	// TODO: Add your command handler code here
	m_pSet->m_strSort = "語文成績";
//	m_pSet->m_column1 = 1;
	m_pSet->Requery();
	UpdateData(FALSE);
	int a = m_pSet->m_column5;
}

void CMyDatabaseView::OnUndo() 
{
	// TODO: Add your command handler code here
	m_pSet->Move(AFX_MOVE_REFRESH);
}

void CMyDatabaseView::OnModify() 
{
	// TODO: Add your command handler code here
}

void CMyDatabaseView::OnDelete() 
{
	// TODO: Add your command handler code here
	if(m_pSet->CanUpdate())
	{
		m_pSet->Delete();
		if(m_pSet->IsEOF())
			m_pSet->MoveLast();
		if(m_pSet->IsBOF())
			m_pSet->SetFieldNull(NULL);
		m_pSet->Requery();
		UpdateData(false);
	}
}

void CMyDatabaseView::OnAddnew() 
{
	// TODO: Add your command handler code here
	if(m_bAddMode)
		OnMove(ID_RECORD_FIRST);
	if(m_pSet->CanAppend())
	{
		m_pSet->AddNew();
		UpdateData(false);	
		m_bAddMode = true;
	}
}

void CMyDatabaseView::OnButton1() 
{
	// TODO: Add your control notification handler code here
//	UpdateData(TRUE);
	//m_pSet->Update();
}

void CMyDatabaseView::OnRecordFirst() 
{
	// TODO: Add your command handler code here
	
}

BOOL CMyDatabaseView::OnMove(UINT nIDMoveCommand) 
{
	// TODO: Add your specialized code here and/or call the base class
	if(m_bAddMode)
	{
		if(!UpdateData())
			return false;
		m_pSet->Update();
		m_pSet->Requery();
		UpdateData(false);
		m_bAddMode = false;
		return true;
	}
	return CRecordView::OnMove(nIDMoveCommand);
}