student2view.cpp

是自己做的一个小的学生管理系统.希望对大家有用

// student2View.cpp : implementation of the CStudent2View class
//

#include "stdafx.h"
#include "student2.h"

#include "student2Set.h"
#include "student2Doc.h"
#include "student2View.h"
#include "Student.h"
#include "Dept.h"
#include "Banji.h"
#include "College.h"
#include "ScoreDlg.h"
#include "Paiming.h"
#include "MainFrm.h"
#include "Entry.h"

#include "XiugaiDlag.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

/////////////////////////////////////////////////////////////////////////////
// CStudent2View

IMPLEMENT_DYNCREATE(CStudent2View, CRecordView)

BEGIN_MESSAGE_MAP(CStudent2View, CRecordView)
//{{AFX_MSG_MAP(CStudent2View)
ON_BN_CLICKED(IDC_BUTTON_View, OnBUTTONView)
ON_BN_CLICKED(IDC_REC_ADD, OnRecAdd)
ON_BN_CLICKED(IDC_REC_EDIT, OnRecEdit)
ON_BN_CLICKED(IDC_REC_DEL, OnRecDel)
ON_BN_CLICKED(IDC_BUTTONFind, OnBUTTONFind)
ON_BN_CLICKED(IDC_BUTTONFinddel, OnBUTTONFinddel)
ON_BN_CLICKED(IDC_BUTTON_EXIT, OnButtonExit)
ON_NOTIFY(TVN_SELCHANGED, IDC_TREE, OnSelchangedTree)
ON_BN_CLICKED(IDC_BUTTON_SORT, OnButtonSort)
ON_BN_CLICKED(IDC_BUTTON_ENTRY, OnButtonEntry)
	ON_WM_CTLCOLOR()
	//}}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()

/////////////////////////////////////////////////////////////////////////////
// CStudent2View construction/destruction

CStudent2View::CStudent2View()
: CRecordView(CStudent2View::IDD)
{
	//{{AFX_DATA_INIT(CStudent2View)
	m_pSet = NULL;
	m_StrQuery = _T("");
	m_score = _T("");
	m_scorno = _T("");
	m_xueyuan1 = _T("");
	m_deptname1 = _T("");
	m_stuname = _T("");
	m_stuno = _T("");
	m_zzmm = _T("");
	m_dhhm = _T("");
	m_jtzz = _T("");
	//}}AFX_DATA_INIT
	// TODO: add construction code here
	m_strSQL=_T("");
	m_stuid=_T("");
	m_name=_T("");
	m_sex=_T("");
	m_chengji=0;
	m_xuefen=0;
	m_xueyuan=_T("");
	m_deptname=_T("");
	m_class=_T("");
	m_political=_T("");
	m_address=_T("");
	m_tel=_T("");
	m_birthday=_T("");
	m_banjino=0;
}

CStudent2View::~CStudent2View()
{
}

void CStudent2View::DoDataExchange(CDataExchange* pDX)
{
	CRecordView::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CStudent2View)
	DDX_Control(pDX, IDC_EDIT_SHOW, m_show);
	DDX_Control(pDX, IDC_TREE1, m_tcTest);
	DDX_Text(pDX, IDC_EDIT7, m_StrQuery);
	DDX_Text(pDX, IDC_EDIT3, m_score);
	DDX_Text(pDX, IDC_EDIT4, m_scorno);
	DDX_Text(pDX, IDC_EDIT5, m_xueyuan1);
	DDX_Text(pDX, IDC_EDIT6, m_deptname1);
	DDX_Text(pDX, IDC_EDIT2, m_stuname);
	DDX_Text(pDX, IDC_EDIT1, m_stuno);
	DDX_Text(pDX, IDC_ZZMM, m_zzmm);
	DDX_Text(pDX, IDC_DHHM, m_dhhm);
	DDX_Text(pDX, IDC_JTZZ, m_jtzz);
	//}}AFX_DATA_MAP
	DDX_Control(pDX,IDC_DATAGRID,m_DataGrid);
}

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

void CStudent2View::OnInitialUpdate()
{
	m_pSet = &GetDocument()->m_student2Set;
	CRecordView::OnInitialUpdate();
	GetParentFrame()->RecalcLayout();
	ResizeParentToFit();
	
	//CEntry dlg;	
	
	m_show.SetWindowText(STR_EDIT_SHOW);
	InitTreeList();   //初始化TreeList控件
	//	m_pSet->m_stuno="";
	//	UpdateData(FALSE);
	UpdateData(TRUE);   //连接数据库
	try
	{
		m_Connection.CreateInstance(__uuidof(Connection));
		m_Recordset.CreateInstance(__uuidof(Recordset));
		
		m_Connection->Open("DSN=studentsn","","",-1);
	}
	catch(_com_error &e)
	{
		MessageBox(e.Description());
	}
	catch(...){}
	UpdateData(FALSE);
}

/////////////////////////////////////////////////////////////////////////////
// CStudent2View printing

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

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

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

/////////////////////////////////////////////////////////////////////////////
// CStudent2View diagnostics

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

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

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

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


/////////////////////////////////////////////////////////////////////////////
// CStudent2View message handlers
void CStudent2View::InitTreeList()    //初始化TreeList控件
{
	// 清空原有项目
	m_tcTest.DeleteAllItems(); 
	
	HTREEITEM root=m_tcTest.InsertItem("西安工程大学",0,0);
	// 学院查询
	CString strCollageQuery;
	strCollageQuery = "SELECT * FROM college ORDER BY collegeno ASC";
	CDatabase db1;
	CCollege xy(&db1);
	xy.Open(AFX_DB_USE_DEFAULT_TYPE, strCollageQuery);
	// 插入学院名
	while(!xy.IsEOF())
	{		
		HTREEITEM subroot = m_tcTest.InsertItem(xy.m_collegename,1,1,root);
		//设置学院ID
		m_tcTest.SetItemData(subroot,xy.m_collegeno);
		// 查询学院下专业
		//CString strCollageQuery;
		strCollageQuery.Format("SELECT * FROM dept WHERE collegeno = %d",xy.m_collegeno);
		
		CDatabase db2;
		CDept zy(&db2);
		zy.Open(AFX_DB_USE_DEFAULT_TYPE,strCollageQuery);
		
		HTREEITEM zhuanye;
        //插入专业
		while(!zy.IsEOF())
		{
			// 插入专业
			zhuanye = m_tcTest.InsertItem(zy.m_deptname,1,1,subroot);
			// 设置专业ID
			m_tcTest.SetItemData(zhuanye, zy.m_deptno);
			
			CString strClassQuery;
			strClassQuery.Format("SELECT * FROM class WHERE deptno = %d",
				zy.m_deptno);
			
			CDatabase db3;
			CBanji bj(&db3);
			bj.Open(AFX_DB_USE_DEFAULT_TYPE, strClassQuery);
			//插入班级
			while(!bj.IsEOF())
			{
				HTREEITEM banji = m_tcTest.InsertItem(bj.m_classname,zhuanye);
				// 设置班级ID
				m_tcTest.SetItemData(banji, bj.m_classno);
				bj.MoveNext();
			}
			
			db3.Close();
			zy.MoveNext();
		}
		db2.Close();
		xy.MoveNext();
	}	
	db1.Close();
}

void CStudent2View::OnBUTTONView()    //浏览所有记录按钮命令消息处理函数
{
	// TODO: Add your control notification handler code here
	if(m_flag==1)
	{
		switch(m_tcTest.GetItemData(hItem))
		{
		case 101:
			m_strSQL.Format("select * from student WHERE classno = %d",101);
			break;
		case 102:
			m_strSQL.Format("select * from student WHERE classno = %d",102);
			break;
		case 103:
			m_strSQL.Format("select * from student WHERE classno = %d",103);
			break;
		case 104:
			m_strSQL.Format("select * from student WHERE classno = %d",104);
			break;
		case 105:
			m_strSQL.Format("select * from student WHERE classno = %d",105);
			break;
		case 106:
			m_strSQL.Format("select * from student WHERE classno = %d",106);
			break;
		default:
			m_strSQL.Format("select * from student WHERE classno = %d",5664);
			break;
		}
		
		try
		{
			m_Recordset.CreateInstance(__uuidof(Recordset));
			UpdateData(TRUE);
			m_Connection->CursorLocation=adUseClient;
			m_Recordset->Open(m_strSQL.GetBuffer(0),
				m_Connection.GetInterfacePtr(),
				adOpenDynamic,
				adLockOptimistic,adCmdText);
		}
		catch(_com_error &e)
		{
			MessageBox(e.Description());
		}
		catch(...){}
		
		m_DataGrid.SetRefDataSource((LPUNKNOWN)m_Recordset);
		m_DataGrid.Refresh();
		UpdateData(FALSE);
	}
	else 
		AfxMessageBox("请选择你的班级！");
}

void CStudent2View::OnRecAdd()    //添加按钮命令消息处理函数
{
	// TODO: Add your control notification handler code here
	CScoreDlg dlg;
	CString strsex,strdata;
	
	if(dlg.DoModal()!=IDOK)return;
	m_stuid=dlg.m_xuehao;
	m_name=dlg.m_xingming;
	m_chengji=dlg.m_chengji;
	
	m_sex=dlg.m_xingbie;
	
	m_xueyuan=dlg.m_xystr;
	m_deptname=dlg.m_deptname;
	m_xuefen=dlg.m_xuefen;
	m_class=dlg.m_banji;

	if(dlg.m_banji=="计算机1班")m_banjino=101;		
	else if(dlg.m_banji=="计算机2班")m_banjino=102;
	else if (dlg.m_banji=="计算机3班")m_banjino=103;
	else if (dlg.m_banji=="计算机4班")m_banjino=104;		
	else if (dlg.m_banji=="计算机5班")m_banjino=105;		
	else if(dlg.m_banji=="计算机6班")m_banjino=106;
	else if(dlg.m_banji=="教育1班")m_banjino=201;
	else if(dlg.m_banji=="教育2班")m_banjino=202;
	else if(dlg.m_banji=="信科1班")m_banjino=301;
	else if(dlg.m_banji=="信科2班")m_banjino=302;
	else if(dlg.m_banji=="工业设计1班")m_banjino=401;
	else if(dlg.m_banji=="工业设计2班")m_banjino=402;
	else if(dlg.m_banji=="机械及自动化1班")m_banjino=501;