studentview.cpp

一个ＭＦＣ写的学生管理系统

// studentView.cpp : CstudentView 类的实现
//

#include "stdafx.h"
#include "student.h"

#include "studentSet.h"
#include "studentDoc.h"
#include "studentView.h"
#include "DIALOG1.h"

#ifdef _DEBUG
#define new DEBUG_NEW
#endif


// CstudentView

IMPLEMENT_DYNCREATE(CstudentView, CRecordView)

BEGIN_MESSAGE_MAP(CstudentView, CRecordView)
	// 标准打印命令
	ON_COMMAND(ID_FILE_PRINT, &CRecordView::OnFilePrint)
	ON_COMMAND(ID_FILE_PRINT_DIRECT, &CRecordView::OnFilePrint)
	ON_COMMAND(ID_FILE_PRINT_PREVIEW, &CRecordView::OnFilePrintPreview)
	ON_COMMAND(ID_ADDRECORD, &CstudentView::OnAddrecord)
	ON_BN_CLICKED(IDC_BUTTON_ADDREC, &CstudentView::OnBnClickedButtonAddrec)
	ON_BN_CLICKED(IDC_BUTTON_DELETEREC, &CstudentView::OnBnClickedButtonDeleterec)
	ON_COMMAND(ID_SORTBYNAME, &CstudentView::OnSortbyname)
	ON_COMMAND(ID_SORTBYSET, &CstudentView::OnSortbyset)
	ON_BN_CLICKED(IDC_BUTTON_SORTBYNAME, &CstudentView::OnBnClickedButtonSortbyname)
	ON_BN_CLICKED(IDC_BUTTON_SORTBYSET, &CstudentView::OnBnClickedButtonSortbyset)
	ON_BN_CLICKED(IDC_BUTTON_YW, &CstudentView::OnBnClickedButtonYw)
	ON_COMMAND(ID_SORTBYSX, &CstudentView::OnSortbysx)
	ON_COMMAND(ID_SORTBYENG, &CstudentView::OnSortbyeng)
	ON_COMMAND(ID_FILTERBYNAME, &CstudentView::OnFilterbyname)
	ON_COMMAND(ID_FILTERBYSET, &CstudentView::OnFilterbyset)
	ON_BN_CLICKED(IDC_BUTTON_FILTERBYNAME, &CstudentView::OnBnClickedButtonFilterbyname)
	ON_BN_CLICKED(IDC_BUTTON_FILTERBYSET, &CstudentView::OnBnClickedButtonFilterbyset)
END_MESSAGE_MAP()

// CstudentView 构造/析构

CstudentView::CstudentView()
	: CRecordView(CstudentView::IDD)
{
	m_pSet = NULL;
	// TODO: 在此处添加构造代码
	m_bAdding = FALSE;

}

CstudentView::~CstudentView()
{
}

void CstudentView::DoDataExchange(CDataExchange* pDX)
{
	CRecordView::DoDataExchange(pDX);
	// 可以在此处插入 DDX_Field* 函数以将控件“连接”到数据库字段，例如
	// DDX_FieldText(pDX, IDC_MYEDITBOX, m_pSet->m_szColumn1, m_pSet);
	// DDX_FieldCheck(pDX, IDC_MYCHECKBOX, m_pSet->m_bColumn2, m_pSet);
	// 有关更多信息，请参阅 MSDN 和 ODBC 示例
	DDX_FieldText(pDX, IDC_EDIT_MAKENUM, m_pSet->column1, m_pSet);
    DDX_FieldText(pDX, IDC_EDIT_NUM, m_pSet->column2, m_pSet);
	DDX_FieldText(pDX, IDC_EDIT_NAME, m_pSet->column3, m_pSet);
	DDX_FieldText(pDX, IDC_EDIT_SEX, m_pSet->column4, m_pSet);
	DDX_FieldText(pDX, IDC_EDIT_YW, m_pSet->column5, m_pSet);
	DDX_FieldText(pDX, IDC_EDIT_SX, m_pSet->column6, m_pSet);
	DDX_FieldText(pDX, IDC_EDIT_ENG, m_pSet->column7, m_pSet);
}

BOOL CstudentView::PreCreateWindow(CREATESTRUCT& cs)
{
	// TODO: 在此处通过修改
	//  CREATESTRUCT cs 来修改窗口类或样式

	return CRecordView::PreCreateWindow(cs);
}

void CstudentView::OnInitialUpdate()
{
	m_pSet = &GetDocument()->m_studentSet;
	CRecordView::OnInitialUpdate();

}


// CstudentView 打印

BOOL CstudentView::OnPreparePrinting(CPrintInfo* pInfo)
{
	// 默认准备
	return DoPreparePrinting(pInfo);
}

void CstudentView::OnBeginPrinting(CDC* /*pDC*/, CPrintInfo* /*pInfo*/)
{
	// TODO: 添加额外的打印前进行的初始化过程
}

void CstudentView::OnEndPrinting(CDC* /*pDC*/, CPrintInfo* /*pInfo*/)
{
	// TODO: 添加打印后进行的清除过程
}


// CstudentView 诊断

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

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

CstudentDoc* CstudentView::GetDocument() const // 非调试版本是内联的
{
	ASSERT(m_pDocument->IsKindOf(RUNTIME_CLASS(CstudentDoc)));
	return (CstudentDoc*)m_pDocument;
}
#endif //_DEBUG


// CstudentView 数据库支持
CRecordset* CstudentView::OnGetRecordset()
{
	return m_pSet;
}



// CstudentView 消息处理程序

void CstudentView::OnAddrecord()
{
	// TODO: 在此添加命令处理程序代码
	m_pSet->AddNew();
	m_bAdding = TRUE;
	CEdit*pCtrl = (CEdit*)GetDlgItem(IDC_EDIT_NUM);
	int nResult = pCtrl->SetReadOnly(FALSE);
	UpdateData(FALSE);
}


BOOL CstudentView::OnMove(UINT nIDMoveCommand)
{
	// TODO: 在此添加专用代码和/或调用基类
	if(m_bAdding)
	{
		m_bAdding = FALSE;

		UpdateData(TRUE);

		if(m_pSet->CanUpdate())
		{
			m_pSet->Update();
		}

		m_pSet->Requery();

		UpdateData(FALSE);

		CEdit*pCtrl = (CEdit*)GetDlgItem(IDC_EDIT_NUM);
		pCtrl->SetReadOnly(TRUE);
		return TRUE;
	}

	return CRecordView::OnMove(nIDMoveCommand);
}


void CstudentView::OnBnClickedButtonAddrec()
{
	// TODO: 在此添加控件通知处理程序代码
    m_pSet->AddNew();
	m_bAdding = TRUE;
	CEdit*pCtrl = (CEdit*)GetDlgItem(IDC_EDIT_NUM);
	int nResult = pCtrl->SetReadOnly(FALSE);
	UpdateData(FALSE);
}

void CstudentView::OnBnClickedButtonDeleterec()
{
	// TODO: 在此添加控件通知处理程序代码
	m_pSet->Delete();
	m_pSet->MoveNext();
	//记录指针末尾
	if(m_pSet->IsEOF())
	{
		m_pSet->MoveLast();
	}
	//记录指针开头
	if(m_pSet->IsBOF())
	{
		//将记录字段设为空
		m_pSet->SetFieldNull(NULL);
	}
	UpdateData(FALSE);
}

void CstudentView::OnSortbyname()
{
	// TODO: 在此添加命令处理程序代码
	m_pSet->m_strSort = "姓名";
	m_pSet->Requery();
	UpdateData(FALSE);
}

void CstudentView::OnSortbyset()
{
	// TODO: 在此添加命令处理程序代码
	m_pSet->m_strSort = "性别";
	m_pSet->Requery();
	UpdateData(FALSE);

}

void CstudentView::OnBnClickedButtonSortbyname()
{
	// TODO: 在此添加控件通知处理程序代码
	m_pSet->m_strSort = "姓名";
	m_pSet->Requery();
	UpdateData(FALSE);
}

void CstudentView::OnBnClickedButtonSortbyset()
{
	// TODO: 在此添加控件通知处理程序代码
	m_pSet->m_strSort = "性别";
	m_pSet->Requery();
	UpdateData(FALSE);

}

void CstudentView::OnBnClickedButtonYw()
{
	// TODO: 在此添加控件通知处理程序代码
	m_pSet->m_strSort = "语文成绩";
	m_pSet->Requery();
	UpdateData(FALSE);
}

void CstudentView::OnSortbysx()
{
	// TODO: 在此添加命令处理程序代码
	m_pSet->m_strSort = "数学成绩";
	m_pSet->Requery();
	UpdateData(FALSE);
}

void CstudentView::OnSortbyeng()
{
	// TODO: 在此添加命令处理程序代码
	m_pSet->m_strSort = "英语成绩";
	m_pSet->Requery();
	UpdateData(FALSE);
}

void CstudentView::OnFilterbyname()
{
	// TODO: 在此添加命令处理程序代码
	DIALOG1 dlg;
	CString strFilter;
	
	if(IDOK == dlg.DoModal())
	{
		strFilter = L"姓名 like '%"+ dlg.m_strFilter +L"%'";
		m_pSet->m_strFilter = strFilter;
		m_pSet->Requery();
	    UpdateData(FALSE);
	}

}

void CstudentView::OnFilterbyset()
{
	// TODO: 在此添加命令处理程序代码
	DIALOG1 dlg;
	CString strFilter;
	
	if(IDOK == dlg.DoModal())
	{
		strFilter = L"性别 = '" + dlg.m_strFilter +L"'";
		
		m_pSet->m_strFilter = strFilter;
		m_pSet->Requery();
		UpdateData(FALSE);
	}

}

void CstudentView::OnBnClickedButtonFilterbyname()
{
	// TODO: 在此添加控件通知处理程序代码
	DIALOG1 dlg;
	CString strFilter;
	
	if(IDOK == dlg.DoModal())
	{
		strFilter = L"姓名 like '%"+ dlg.m_strFilter +L"%'";
		m_pSet->m_strFilter = strFilter;
		m_pSet->Requery();
	    UpdateData(FALSE);
	}

}

void CstudentView::OnBnClickedButtonFilterbyset()
{
	// TODO: 在此添加控件通知处理程序代码
	DIALOG1 dlg;
	CString strFilter;
	
	if(IDOK == dlg.DoModal())
	{
		strFilter = L"性别 = '" + dlg.m_strFilter +L"'";
		
		m_pSet->m_strFilter = strFilter;
		m_pSet->Requery();
		UpdateData(FALSE);
	}
}