// Ex_ODBCView.cpp : implementation of the CEx_ODBCView class
//

#include "stdafx.h"
#include "Ex_ODBC.h"

#include "Ex_ODBCSet.h"
#include "Ex_ODBCDoc.h"
#include "Ex_ODBCView.h"
#include "ScoreDlg.h"

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

/////////////////////////////////////////////////////////////////////////////
// CEx_ODBCView

IMPLEMENT_DYNCREATE(CEx_ODBCView, CRecordView)

BEGIN_MESSAGE_MAP(CEx_ODBCView, CRecordView)
	//{{AFX_MSG_MAP(CEx_ODBCView)
	ON_BN_CLICKED(IDC_BUTTON_QUERY, OnButtonQuery)
	ON_BN_CLICKED(IDC_REC_ADD, OnRecAdd)
	ON_BN_CLICKED(IDC_REC_EDIT, OnRecEdit)
	ON_BN_CLICKED(IDC_REC_DEL, OnRecDel)
	ON_BN_DOUBLECLICKED(IDC_REC_ADD, OnDoubleclickedRecAdd)
	//}}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()

/////////////////////////////////////////////////////////////////////////////
// CEx_ODBCView construction/destruction

CEx_ODBCView::CEx_ODBCView()
	: CRecordView(CEx_ODBCView::IDD)
{
	//{{AFX_DATA_INIT(CEx_ODBCView)
	m_pSet = NULL;
	m_strQuery = _T("");
	//}}AFX_DATA_INIT
	// TODO: add construction code here

}

CEx_ODBCView::~CEx_ODBCView()
{
}

void CEx_ODBCView::DoDataExchange(CDataExchange* pDX)
{
	CRecordView::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CEx_ODBCView)
	DDX_FieldText(pDX, IDC_COURSENO, m_pSet->m_course, m_pSet);
	DDV_MaxChars(pDX, m_pSet->m_course, 7);
	DDX_FieldText(pDX, IDC_CREDIT, m_pSet->m_credit, m_pSet);
	DDV_MinMaxFloat(pDX, m_pSet->m_credit, 1.f, 20.f);
	DDX_FieldText(pDX, IDC_SCORE, m_pSet->m_score, m_pSet);
	DDV_MinMaxFloat(pDX, m_pSet->m_score, 0.f, 100.f);
	DDX_FieldText(pDX, IDC_STUNO, m_pSet->m_studentno, m_pSet);
	DDV_MaxChars(pDX, m_pSet->m_studentno, 8);
	DDX_Text(pDX, IDC_EDIT_QUERY, m_strQuery);
	//}}AFX_DATA_MAP
}

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

	return CRecordView::PreCreateWindow(cs);
}

void CEx_ODBCView::OnInitialUpdate()
{
	m_pSet = &GetDocument()->m_ex_ODBCSet;
	CRecordView::OnInitialUpdate();
	GetParentFrame()->RecalcLayout();
	ResizeParentToFit();
   
}

/////////////////////////////////////////////////////////////////////////////
// CEx_ODBCView printing

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

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

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

/////////////////////////////////////////////////////////////////////////////
// CEx_ODBCView diagnostics

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

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

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

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


/////////////////////////////////////////////////////////////////////////////
// CEx_ODBCView message handlers

void CEx_ODBCView::OnButtonQuery() 
{
UpdateData();
m_strQuery.TrimLeft();
if (m_strQuery.IsEmpty())
{
MessageBox("要查詢的學號不能為空！");
return;
}
if(m_pSet->IsOpen())
 m_pSet->Close();
 m_pSet->m_strFilter.Format("studentno='%s'",m_strQuery);
 m_pSet->m_strSort="course";
 m_pSet->Open();
 if(!m_pSet->IsEOF())
	 UpdateData(FALSE);
 else
	 MessageBox("沒有查到你要找的學號紀錄!");
	
}




void CEx_ODBCView::OnRecAdd() 
{
CScoreDlg dlg;
if(dlg.DoModal()==IDOK){
m_pSet->AddNew();
m_pSet->m_course          =dlg.m_strCourseNO;
m_pSet->m_studentno       =dlg.m_strStudentNO;
m_pSet->m_score           =dlg.m_fScore;
m_pSet->m_credit           =dlg.m_fCredit;
m_pSet->Update();
m_pSet->Requery();
}
	
}

void CEx_ODBCView::OnRecEdit() 
{
CScoreDlg dlg;
dlg.m_strCourseNO                   =m_pSet->m_course;
dlg.m_strStudentNO                   =m_pSet->m_studentno;
dlg.m_fScore                        =m_pSet->m_score;
dlg.m_fCredit                        =m_pSet->m_credit;
if(dlg.DoModal()==IDOK){
     m_pSet->Edit();
     m_pSet->m_course               = dlg.m_strCourseNO;
     m_pSet->m_studentno            = dlg.m_strStudentNO;
     m_pSet->m_score                = dlg.m_fScore; 
     m_pSet->m_credit                = dlg.m_fCredit;
     m_pSet->Update();
     UpdateData(FALSE);
}
	
}

void CEx_ODBCView::OnRecDel() 
{
CRecordsetStatus status;
m_pSet->GetStatus(status);
m_pSet->Delete();
if(status.m_lCurrentRecord==0)
   m_pSet->MoveNext();
else 
   m_pSet->MoveFirst();
UpdateData(FALSE);

	
}

void CEx_ODBCView::OnDoubleclickedRecAdd() 
{
	// TODO: Add your control notification handler code here
	
}