20028324view.cpp

关于学生信息管理系统的一个小程序,适合用与应付实习,供大家使用!

// 20028324View.cpp : implementation of the CMy20028324View class
//

#include "stdafx.h"
#include "20028324.h"

#include "20028324Set.h"
#include "20028324Doc.h"
#include "20028324View.h"

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

#include "StdDlg.h"
#include "ClassDlg.h"
#include "LsDlg.h"
#include "DelDlg.h"
#include "DelStdDlg.h"
extern BOOL IsSuper;
/////////////////////////////////////////////////////////////////////////////
// CMy20028324View

IMPLEMENT_DYNCREATE(CMy20028324View, CRecordView)

BEGIN_MESSAGE_MAP(CMy20028324View, CRecordView)
//{{AFX_MSG_MAP(CMy20028324View)
ON_BN_CLICKED(IDC_BUTTON_BROWSE, OnButtonBrowse)
	ON_BN_CLICKED(IDC_BUTTON_LOOKUP, OnButtonLookup)
	ON_COMMAND(ID_MENU_ADDSTUDENT, OnMenuAddstudent)
	ON_COMMAND(ID_MENU_ADDCLASS, OnMenuAddclass)
	ON_COMMAND(ID_MENU_ADDLESSON, OnMenuAddlesson)
	ON_COMMAND(ID_MENU_DELLESSON, OnMenuDellesson)
	ON_COMMAND(ID_MENU_DELSTUDENT, OnMenuDelstudent)
	ON_NOTIFY(NM_DBLCLK, IDC_LIST2, OnDblclkList2)
	ON_UPDATE_COMMAND_UI(ID_MENU_ADDCLASS, OnUpdateMenuAddclass)
	ON_UPDATE_COMMAND_UI(ID_MENU_ADDLESSON, OnUpdateMenuAddlesson)
	ON_UPDATE_COMMAND_UI(ID_MENU_ADDSTUDENT, OnUpdateMenuAddstudent)
	ON_UPDATE_COMMAND_UI(ID_MENU_DELLESSON, OnUpdateMenuDellesson)
	ON_UPDATE_COMMAND_UI(ID_MENU_DELSTUDENT, OnUpdateMenuDelstudent)
	ON_COMMAND(ID_LES, OnLes)
	//}}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()

/////////////////////////////////////////////////////////////////////////////
// CMy20028324View construction/destruction

CMy20028324View::CMy20028324View()
: CRecordView(CMy20028324View::IDD)
{
	//{{AFX_DATA_INIT(CMy20028324View)
	m_pSet = NULL;
	m_number = 0;
	m_check1 = FALSE;
	//}}AFX_DATA_INIT
	// TODO: add construction code here
	
}

CMy20028324View::~CMy20028324View()
{
}

void CMy20028324View::DoDataExchange(CDataExchange* pDX)
{
	CRecordView::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CMy20028324View)
	DDX_Control(pDX, IDC_LIST3, m_list3);
	DDX_Control(pDX, IDC_LIST2, m_list2);
	DDX_Control(pDX, IDC_LIST1, m_list1);
	DDX_Text(pDX, IDC_EDIT1, m_number);
	DDX_Check(pDX, IDC_CHECK1, m_check1);
	//}}AFX_DATA_MAP
}

BOOL CMy20028324View::PreCreateWindow(CREATESTRUCT& cs)
{
	// TODO: Modify the Window class or styles here by modifying
	//  the CREATESTRUCT cs
	
	return CRecordView::PreCreateWindow(cs);
}


void CMy20028324View::OnInitialUpdate()
{
	m_pSet = &GetDocument()->m_my20028324Set;
	CRecordView::OnInitialUpdate();
	GetParentFrame()->RecalcLayout();
	ResizeParentToFit();
	
//	CWnd* pMain = AfxGetMainWnd();
//	CMenu* pCmdUI=pMain->GetMenu();
//	pCmdUI->EnableMenuItem(ID_MENU_DELSTUDENT,MF_BYPOSITION);
//	CCmdUI *p=(CCmdUI*)
//	pCmdUI->DeleteMenu(0,ID_MENU_ADDLESSON);
	m_list1.SetTextColor(RGB (0, 0, 0));//设置文本自体颜色
	//	m_list1.SetTextBkColor(RGB (200, 200, 200));//设置文本背景颜色
	//	m_list1.SetBkColor(RGB(200,200,200));//设置列表控件背景颜色
	m_list1.SetExtendedStyle(LVS_EX_FULLROWSELECT|LVS_EX_GRIDLINES);//给LIST添加网格
	m_list1.InsertColumn(0,"学号",LVCFMT_LEFT,65);//给LIST添加各列
	m_list1.InsertColumn(1,"姓名",LVCFMT_LEFT,65);
	m_list1.InsertColumn(2,"性别",LVCFMT_LEFT,65);
	m_list1.InsertColumn(3,"出生年月",LVCFMT_LEFT,75);
	m_list1.InsertColumn(4,"专业",LVCFMT_LEFT,65);
	m_list1.InsertColumn(5,"联系电话",LVCFMT_LEFT,85);
	///////////////
	
	m_list2.SetTextColor(RGB (0, 0, 0));//设置文本自体颜色
	//	m_list1.SetTextBkColor(RGB (200, 200, 200));//设置文本背景颜色
	//	m_list1.SetBkColor(RGB(200,200,200));//设置列表控件背景颜色
	m_list2.SetExtendedStyle(LVS_EX_FULLROWSELECT|LVS_EX_GRIDLINES);//给LIST添加网格
	m_list2.InsertColumn(0,"学号",LVCFMT_LEFT,65);//给LIST添加各列
	m_list2.InsertColumn(1,"课程号",LVCFMT_LEFT,65);
	m_list2.InsertColumn(2,"成绩",LVCFMT_LEFT,85);
	m_list2.InsertColumn(3,"学期",LVCFMT_LEFT,65);
	
	
	m_list3.SetTextColor(RGB (0, 0, 0));//设置文本自体颜色
	//	m_list1.SetTextBkColor(RGB (200, 200, 200));//设置文本背景颜色
	//	m_list1.SetBkColor(RGB(200,200,200));//设置列表控件背景颜色
	m_list3.SetExtendedStyle(LVS_EX_FULLROWSELECT|LVS_EX_GRIDLINES);//给LIST添加网格
	m_list3.InsertColumn(0,"课程号",LVCFMT_LEFT,65);//给LIST添加各列
	m_list3.InsertColumn(1,"课程名",LVCFMT_LEFT,65);
	m_list3.InsertColumn(2,"学分",LVCFMT_LEFT,65);
	
}

/////////////////////////////////////////////////////////////////////////////
// CMy20028324View printing

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

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

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

/////////////////////////////////////////////////////////////////////////////
// CMy20028324View diagnostics

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

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

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

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


/////////////////////////////////////////////////////////////////////////////
// CMy20028324View message handlers

void CMy20028324View::OnButtonBrowse() 
{
	// TODO: Add your control notification handler code here
	if(!m_Sset.IsOpen())//student 表的浏览
		m_Sset.Open();
	m_list1.DeleteAllItems();
	int n = 0;
	while(!m_Sset.IsEOF())
	{
		m_list1.InsertItem(n,"");
		CString s;
		s.Format("%d",m_Sset.m_column1);
		m_list1.SetItemText(n,0,s);
		m_list1.SetItemText(n,1,m_Sset.m_column2);
		m_list1.SetItemText(n,2,m_Sset.m_column3);
		m_list1.SetItemText(n,3,m_Sset.m_column4);
		m_list1.SetItemText(n,4,m_Sset.m_column5);
		m_list1.SetItemText(n,5,m_Sset.m_column6);
		m_Sset.MoveNext();
		n++;	
	}
	m_Sset.Close(); 
	//class 表的浏览
	if(!m_Cset.IsOpen())
		m_Cset.Open();
	m_list2.DeleteAllItems();
	n = 0;
	while(!m_Cset.IsEOF())
	{
		m_list2.InsertItem(n,"");
		CString s;
		s.Format("%d",m_Cset.m_column1);
		m_list2.SetItemText(n,0,s);
		s.Format("%d",m_Cset.m_column2);
		m_list2.SetItemText(n,1,s);
		s.Format("%f",m_Cset.m_column3);
		m_list2.SetItemText(n,2,s);
		m_list2.SetItemText(n,3,m_Cset.m_column4);
		m_Cset.MoveNext();
		n++;	
	}
	m_Cset.Close(); 
	//lesson 表的浏览
	if(!m_Lset.IsOpen())
		m_Lset.Open();
	m_list3.DeleteAllItems();
	n = 0;
	while(!m_Lset.IsEOF())
	{
		m_list3.InsertItem(n,"");
		CString s;
		s.Format("%d",m_Lset.m_column1);
		m_list3.SetItemText(n,0,s);	
		m_list3.SetItemText(n,1,m_Lset.m_column2);
		s.Format("%.1f",m_Lset.m_column3);
		m_list3.SetItemText(n,2,s);
		m_Lset.MoveNext();
		n++;	
	}
	m_Lset.Close(); 
	
}

void CMy20028324View::OnButtonLookup() 
{
	// TODO: Add your control notification handler code here
	UpdateData(true);

	m_list1.DeleteAllItems();
	m_list2.DeleteAllItems();
	m_list3.DeleteAllItems();
	if(!m_Sset.IsOpen())
	{
		m_Sset.Open();
	}
	while(!m_Sset.IsEOF())
	{
		if(m_Sset.m_column1==m_number)
		{	
			m_list1.InsertItem(0,"");
			CString s;
			s.Format("%d",m_Sset.m_column1);
			m_list1.SetItemText(0,0,s);
			m_list1.SetItemText(0,1,m_Sset.m_column2);
			m_list1.SetItemText(0,2,m_Sset.m_column3);
			m_list1.SetItemText(0,3,m_Sset.m_column4);
			m_list1.SetItemText(0,4,m_Sset.m_column5);
			m_list1.SetItemText(0,5,m_Sset.m_column6);
			break;
		}
		m_Sset.MoveNext();
	}
	if(m_Sset.IsEOF())
	{
		MessageBox("无此学号！");
		m_Sset.Close();
		return;	
	}
	else
	{
		if(!m_Cset.IsOpen())
			m_Cset.Open();
		int n=0;
		while(!m_Cset.IsEOF())
		{
			if(m_Cset.m_column1==m_number)
			{	
				m_list2.InsertItem(n,"");
				CString s;
				s.Format("%d",m_Cset.m_column1);
				m_list2.SetItemText(n,0,s);
				s.Format("%d",m_Cset.m_column2);
				m_list2.SetItemText(n,1,s);
				s.Format("%f",m_Cset.m_column3);
				m_list2.SetItemText(n,2,s);
				m_list2.SetItemText(n,3,m_Cset.m_column4);
				n++;
			}
			m_Cset.MoveNext();
		}
		m_Cset.Close();
	}
	m_Sset.Close();
	if(!m_Lset.IsOpen())
		m_Lset.Open();
	int n=0;
	while(!m_Lset.IsEOF())
	{
		m_list3.InsertItem(n,"");
		CString s;
		s.Format("%d",m_Lset.m_column1);
		m_list3.SetItemText(n,0,s);	
		m_list3.SetItemText(n,1,m_Lset.m_column2);
		s.Format("%.1f",m_Lset.m_column3);
		m_list3.SetItemText(n,2,s);
		m_Lset.MoveNext();
		n++;