ex27view.cpp

ODBC管理学生档案

// ex27View.cpp : implementation of the CEx27View class
//

#include "stdafx.h"
#include "ex27.h"

#include "ex27Set.h"
#include "ex27Doc.h"
#include "ex27View.h"

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

/////////////////////////////////////////////////////////////////////////////
// CEx27View

IMPLEMENT_DYNCREATE(CEx27View, CRecordView)

BEGIN_MESSAGE_MAP(CEx27View, CRecordView)
	//{{AFX_MSG_MAP(CEx27View)
	ON_COMMAND(IDC_RECORD_ADD, OnRecordAdd)
	ON_COMMAND(IDC_RECORD_DELETE, OnRecordDelete)
	ON_COMMAND(IDC_RECORD_UPDATE, OnRecordUpdate)
	ON_UPDATE_COMMAND_UI(IDC_RECORD_DELETE, OnUpdateRecordDelete)
	ON_UPDATE_COMMAND_UI(IDC_RECORD_UPDATE, OnUpdateRecordUpdate)
	//}}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()

/////////////////////////////////////////////////////////////////////////////
// CEx27View construction/destruction

CEx27View::CEx27View()
	: CRecordView(CEx27View::IDD)
{
	//{{AFX_DATA_INIT(CEx27View)
	m_pSet = NULL;
	//}}AFX_DATA_INIT
	// TODO: add construction code here
//使界面出于非添加状态
	m_AddRecord=FALSE;

}

CEx27View::~CEx27View()
{
}

void CEx27View::DoDataExchange(CDataExchange* pDX)
{
	CRecordView::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CEx27View)
	DDX_FieldText(pDX, IDC_EDIT1, m_pSet->m_StudentID, m_pSet);
	DDX_FieldText(pDX, IDC_EDIT2, m_pSet->m_Name, m_pSet);
	DDX_FieldText(pDX, IDC_EDIT3, m_pSet->m_GradYear, m_pSet);
	//}}AFX_DATA_MAP
}

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

	return CRecordView::PreCreateWindow(cs);
}

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

}

/////////////////////////////////////////////////////////////////////////////
// CEx27View printing

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

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

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

/////////////////////////////////////////////////////////////////////////////
// CEx27View diagnostics

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

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

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

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


/////////////////////////////////////////////////////////////////////////////
// CEx27View message handlers

void CEx27View::OnRecordAdd() 
{
	// TODO: Add your command handler code here
	int result;
	m_pSet->AddNew();//开始增加新的记录
	m_AddRecord=TRUE;//将添加记录的标记置为真
	
	CEdit *pAddEdit=(CEdit *)GetDlgItem(IDC_EDIT1);//将文本框属性改为可以修改
	result=pAddEdit->SetReadOnly(FALSE);
	UpdateData(FALSE);

}

void CEx27View::OnRecordDelete() 
{
	// TODO: Add your command handler code here
	try//删除当前数据
	{
		m_pSet->Delete();
	}
	catch (CDBException *e)//捕捉删除出现的错误操作
	{
		AfxMessageBox(e->m_strError);
		e->Delete();
		m_pSet->MoveFirst();
		UpdateData(FALSE);
		return;
	}
	if(m_pSet->IsEOF())//如果在最后一个空记录处则移动至最后一个记录处
		m_pSet->MoveLast();
	if(m_pSet->IsBOF())//如果表为空则移除Null标记
		m_pSet->SetFieldNull(NULL);
	
	UpdateData(FALSE);	

}

void CEx27View::OnRecordUpdate() 
{
	// TODO: Add your command handler code here
	m_pSet->Edit();//开始修改已有记录
	UpdateData(TRUE);//从文本框获取输入数据
	if(m_pSet->CanUpdate())//如果输入数据符合要求则更新
	{
		m_pSet->Update();
	}

}

void CEx27View::OnUpdateRecordDelete(CCmdUI* pCmdUI) 
{
	// TODO: Add your command update UI handler code here
	//如果不在记录尾部则使菜单选项属性变为"可使用"
	pCmdUI->Enable(!m_pSet->IsEOF());

}

void CEx27View::OnUpdateRecordUpdate(CCmdUI* pCmdUI) 
{
	// TODO: Add your command update UI handler code here
	//如果不在记录尾部则使菜单选项属性变为"可使用"
	pCmdUI->Enable(!m_pSet->IsEOF());

}

BOOL CEx27View::OnMove(UINT nIDMoveCommand) 
{
	// TODO: Add your specialized code here and/or call the base class
	if(m_AddRecord)//如果是添加记录为真,则移动前会将当前记录添加进去
	{
		m_AddRecord=FALSE;
		UpdateData(TRUE);
		//更新数据
		if(m_pSet->CanUpdate())
			m_pSet->Update();
		//将增加的记录移动到最后,并重新设置下一此操作
		if(!m_pSet->IsEOF())
			m_pSet->MoveLast();
		m_pSet->Requery();
		UpdateData(FALSE);
		//将第一个字段恢复为只读
		CEdit * pAddEdit=(CEdit *)GetDlgItem(IDC_EDIT1);
		pAddEdit->SetReadOnly(TRUE);
		return TRUE;
	}

	UpdateData(FALSE);

	return CRecordView::OnMove(nIDMoveCommand);
}