studentdlg.cpp

一个简单的学生信息管理系统

// Studentdlg.cpp : implementation file
//

#include "stdafx.h"
#include "swb.h"
#include "Studentdlg.h"
#include "EditTeacher.h"
#include "Modifydlg.h"
#include "SortList.h"
#include "Finddlg.h"
#include "DODELETE.h"


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

/////////////////////////////////////////////////////////////////////////////
// CStudentdlg dialog
CString SQLQueryAll; //全局变量

CStudentdlg::CStudentdlg(CWnd* pParent /*=NULL*/)
	: CDialog(CStudentdlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CStudentdlg)
		// NOTE: the ClassWizard will add member initialization here
	//}}AFX_DATA_INIT
}


void CStudentdlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CStudentdlg)
	DDX_Control(pDX, IDC_COMBO3, m_combo3);
	DDX_Control(pDX, IDC_LIST3, m_list3);
	DDX_Control(pDX, IDC_LIST1, m_list2);
	DDX_Control(pDX, IDC_LIST2, m_list1);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CStudentdlg, CDialog)
	ON_WM_CONTEXTMENU()
	//{{AFX_MSG_MAP(CStudentdlg)
	ON_BN_CLICKED(IDC_SHOW, OnShow)
	ON_NOTIFY(LVN_COLUMNCLICK, IDC_LIST2, OnColumnclickList2)
	ON_BN_CLICKED(IDC_APPEND, OnAPPEND)
	ON_NOTIFY(NM_CLICK, IDC_LIST2, OnClickList2)
	ON_BN_CLICKED(IDC_DELETE, OnDelete)
	ON_BN_CLICKED(IDC_EDIT, OnEdit)
	ON_BN_CLICKED(IDC_FIND, OnFind)
	ON_NOTIFY(NM_CLICK, IDC_LIST3, OnClickList3)
	ON_NOTIFY(NM_CLICK, IDC_LIST1, OnClickList1)
	ON_CBN_SELCHANGE(IDC_COMBO3, OnSelchangeCombo3)
	ON_NOTIFY(NM_RCLICK, IDC_LIST1, OnRclickList1)
	ON_NOTIFY(NM_RCLICK, IDC_LIST2, OnRclickList2)
	ON_NOTIFY(NM_RCLICK, IDC_LIST3, OnRclickList3)
	ON_COMMAND(ID_EDIT_RSHOW, OnEditRshow)
	ON_COMMAND(ID_EDIT_EAPPEND, OnEditEappend)
	ON_COMMAND(ID_EDIT_RDELETE, OnEditRdelete)
	ON_COMMAND(ID_EDIT_REDIT, OnEditRedit)
	ON_COMMAND(ID_EDIT_RSEARCH, OnEditRsearch)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CStudentdlg message handlers



BOOL CStudentdlg::OnInitDialog() 
{
	CDialog::OnInitDialog();


	nCurSel=nCurSel1=nCurSel2=-1;
	// TODO: Add extra initialization here
	m_combo3.SetCurSel(1);

	m_list1.InsertColumn(0,"学号");
	m_list1.InsertColumn(1,"姓名");
	m_list1.InsertColumn(2,"语文");
	m_list1.InsertColumn(3,"数学");
	m_list1.InsertColumn(4,"英语");
	m_list1.InsertColumn(5,"物理");
	m_list1.InsertColumn(6,"化学");
	m_list1.SetColumnWidth(0,100);
	m_list1.SetColumnWidth(1,100);
	m_list1.SetColumnWidth(2,70);
	m_list1.SetColumnWidth(3,70);
	m_list1.SetColumnWidth(4,70);
	m_list1.SetColumnWidth(5,70);
	m_list1.SetColumnWidth(6,70);

//	 m_list1.SetExtendedStyle(LVS_EX_GRIDLINES);
//	 m_list1.ModifyStyle(0,LVS_REPORT|LVS_SINGLESEL|LVS_SHOWSELALWAYS);
     m_list1.SetExtendedStyle(LVS_EX_FULLROWSELECT|LVS_EX_GRIDLINES|LVS_EX_HEADERDRAGDROP);
     m_list1.SetTextColor(RGB(0,0,255));                  //显示字体的颜色
//     DWORD dwStyle = m_list1.GetStyle();
//     dwStyle |= LVS_EX_GRIDLINES |LVS_EX_FULLROWSELECT|LVS_SHOWSELALWAYS ;
//     m_list1.SetExtendedStyle(dwStyle);
     m_list1.SetBkColor(RGB(240,247,233));             //选中此列的颜色
     m_list1.SetTextBkColor(RGB(240,247,233));           //背景颜色


	 m_list2.InsertColumn(0,"科目");
	 m_list2.InsertColumn(1,"学科总分");
	 m_list2.InsertColumn(2,"平均分");
	 m_list2.InsertColumn(3,"及格人数");
	 m_list2.SetColumnWidth(0,100);
	 m_list2.SetColumnWidth(1,100);
	 m_list2.SetColumnWidth(2,100);
	 m_list2.SetColumnWidth(3,100);
	 
	 m_list2.SetExtendedStyle(LVS_EX_FULLROWSELECT|LVS_EX_GRIDLINES|LVS_EX_HEADERDRAGDROP);
     m_list2.SetTextColor(RGB(0,0,255));
	 m_list2.SetBkColor(RGB(240,247,233));
	 m_list2.SetTextBkColor(RGB(240,247,233)); 

	 m_list3.InsertColumn(0,"科目");
	 m_list3.InsertColumn(1,"任课老师");
	 m_list3.SetColumnWidth(0,80);
	 m_list3.SetColumnWidth(1,100);
	 m_list3.SetExtendedStyle(LVS_EX_FULLROWSELECT|LVS_EX_GRIDLINES|LVS_EX_HEADERDRAGDROP);
     m_list3.SetTextColor(RGB(0,0,255));
	 m_list3.SetBkColor(RGB(240,247,233));
	 m_list3.SetTextBkColor(RGB(240,247,233)); 

	 
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CStudentdlg::OnShow() 
{

	CString m_class;
	m_combo3.GetLBText(m_combo3.GetCurSel(),m_class);
	m_list1.DeleteAllItems();
	_variant_t var;
	CString num,name,yuwen,shuxue,yingyu,wuli,huaxue,kong;
   	m_pConnection.CreateInstance(__uuidof(Connection));
	m_pRecordset.CreateInstance(__uuidof(Recordset));

	try{
		m_pConnection->Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=swb.mdb","","",adModeUnknown);
		if(m_class=="一班")
			m_pRecordset->Open("SELECT * FROM student1",m_pConnection.GetInterfacePtr(),adOpenDynamic,adLockOptimistic,adCmdText);
		if(m_class=="二班")
			m_pRecordset->Open("SELECT * FROM student2",m_pConnection.GetInterfacePtr(),adOpenDynamic,adLockOptimistic,adCmdText);


        int totalscore[5];
		int average[5];
		int passnum[5];
		
		int j;
		for(j=0;j<5;j++)
		{
			totalscore[j]=0;
			average[j]=0;
			passnum[j]=0;
		} 


		if(!m_pRecordset->BOF)
			m_pRecordset->MoveFirst();
		else
		{
			AfxMessageBox("表内没有记录~!");
			return;
		}
		int i=0;
		while(!m_pRecordset->adoEOF)
		{
		var=m_pRecordset->GetCollect("学号");
		if(var.vt!=VT_NULL)
			num=(LPCSTR)_bstr_t(var);
		var=m_pRecordset->GetCollect("姓名");
		if(var.vt!=VT_NULL)
     		name=(LPCSTR)_bstr_t(var);
        var=m_pRecordset->GetCollect("语文");
		if(var.vt!=VT_NULL)
			yuwen=(LPCSTR)_bstr_t(var);
		totalscore[0]+=var.lVal;
		if(var.lVal>=60)  passnum[0]++;
        var=m_pRecordset->GetCollect("数学");
		if(var.vt!=VT_NULL)
			shuxue=(LPCSTR)_bstr_t(var);
		totalscore[1]+=var.lVal;
		if(var.lVal>=60)  passnum[1]++;
	    var=m_pRecordset->GetCollect("英语");
		if(var.vt!=VT_NULL)
			yingyu=(LPCSTR)_bstr_t(var);
		totalscore[2]+=var.lVal;
		if(var.lVal>=60)  passnum[2]++;
	    var=m_pRecordset->GetCollect("物理");
		if(var.vt!=VT_NULL)
			wuli=(LPCSTR)_bstr_t(var);
		totalscore[3]+=var.lVal;
		if(var.lVal>=60)  passnum[3]++;
	    var=m_pRecordset->GetCollect("化学");
		if(var.vt!=VT_NULL)
			huaxue=(LPCSTR)_bstr_t(var); 
		totalscore[4]+=var.lVal;
		if(var.lVal>=60)  passnum[4]++;

		for(j=0;j<5;j++)
			average[j]=totalscore[j]/5;

		
		m_list1.InsertItem(i,"0");
		m_list1.SetItemText(i,0,num);
		m_list1.SetItemText(i,1,name);
		m_list1.SetItemText(i,2,yuwen);
		m_list1.SetItemText(i,3,shuxue);
		m_list1.SetItemText(i,4,yingyu);
		m_list1.SetItemText(i,5,wuli);
		m_list1.SetItemText(i,6,huaxue);
		m_pRecordset->MoveNext();
		i++;

		}

		CString obj[5]={"语文","数学","英语","物理","化学"};
		CString zongfen,pingjun,renshu;
		

		m_list2.DeleteAllItems();
		for(i=0;i<5;i++)
		{

			zongfen.Format("%d",totalscore[i]);
			pingjun.Format("%d",average[i]);
			renshu.Format("%d",passnum[i]);
			CString kemu=obj[i];
			m_list2.InsertItem(i,"0");
			m_list2.SetItemText(i,0,kemu);
			m_list2.SetItemText(i,1,zongfen);
			m_list2.SetItemText(i,2,pingjun);
			m_list2.SetItemText(i,3,renshu);

		}
		m_pRecordset->Close();
	    m_pConnection->Close();
		m_pRecordset=NULL;
		m_pConnection=NULL;


		
        m_pConnection.CreateInstance(__uuidof(Connection));
	    m_pRecordset.CreateInstance(__uuidof(Recordset));
		m_pConnection->Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=swb.mdb","","",adModeUnknown);
		m_pRecordset->Open("SELECT * FROM teacher",m_pConnection.GetInterfacePtr(),adOpenDynamic,adLockOptimistic,adCmdText);
		
		m_list3.DeleteAllItems();
		CString str_teacher,str_subject;

        i=0;
		m_pRecordset->MoveFirst();
		while(!m_pRecordset->adoEOF)
		{
			

			var=m_pRecordset->GetCollect("科目");
			if(var.vt!=VT_NULL)
				str_subject=(LPCSTR)_bstr_t(var);
			var=m_pRecordset->GetCollect("任课老师");
			if(var.vt!=VT_NULL)
				str_teacher=(LPCSTR)_bstr_t(var);

			
			

			m_list3.InsertItem(i,"0");
			m_list3.SetItemText(i,0,str_subject);
			m_list3.SetItemText(i,1,str_teacher);
			m_pRecordset->MoveNext();
			i++;
		}
		
		




	m_pRecordset->Close();
    m_pConnection->Close();
	m_pRecordset=NULL;
	m_pConnection=NULL;
	nCurSel=-1;
	nCurSel2=-1;
	SQLQueryAll.Empty();

	}
	catch(_com_error* e)
	{
		AfxMessageBox(e->ErrorMessage());
	}
	

}





void CStudentdlg::Ssort(int SortCol)
{

	
	CString iId,SQLQuery,SortNum,m_class;
	switch(SortCol)
	{
		case(0):
			iId="学号";
			break;
		case(1):
			iId="姓名";
			break;
		case(2):
			iId="语文";
			break;
		case(3):
			iId="数学";
			break;
		case(4):
			iId="英语";
			break;
		case(5):
			iId="物理";
			break;
		case(6):
			iId="化学";
			break;
	}
	

	if(m_list1.m_fAsc)
		SortNum="ASC";
	else
		SortNum="DESC";
	m_combo3.GetLBText(m_combo3.GetCurSel(),m_class);
	if(SQLQueryAll=="")
	{
		if(m_class=="一班")
			SQLQuery = "SELECT * FROM student1 order by "+iId+" "+SortNum+"";
		if(m_class=="二班")
			SQLQuery = "SELECT * FROM student2 order by "+iId+" "+SortNum+"";
	}
	else
	{
		SQLQuery=SQLQueryAll+"order by "+iId+" "+SortNum+"";
	}

	m_list1.DeleteAllItems();
	_variant_t var;
	CString num,name,yuwen,shuxue,yingyu,wuli,huaxue,kong;
   	m_pConnection.CreateInstance(__uuidof(Connection));
	m_pRecordset.CreateInstance(__uuidof(Recordset));

	try{
		m_pConnection->Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=swb.mdb","","",adModeUnknown);
		m_pRecordset->Open(_variant_t(SQLQuery),m_pConnection.GetInterfacePtr(),adOpenDynamic,adLockOptimistic,adCmdText);


		if(!m_pRecordset->BOF)
			m_pRecordset->MoveFirst();
		else
		{
			AfxMessageBox("表内没有记录~!");
			return;
		}
		int i=0;
		while(!m_pRecordset->adoEOF)
		{
		var=m_pRecordset->GetCollect("学号");
		if(var.vt!=VT_NULL)
			num=(LPCSTR)_bstr_t(var);
		var=m_pRecordset->GetCollect("姓名");
		if(var.vt!=VT_NULL)
     		name=(LPCSTR)_bstr_t(var);
        var=m_pRecordset->GetCollect("语文");
		if(var.vt!=VT_NULL)
			yuwen=(LPCSTR)_bstr_t(var);
        var=m_pRecordset->GetCollect("数学");
		if(var.vt!=VT_NULL)
			shuxue=(LPCSTR)_bstr_t(var);
        var=m_pRecordset->GetCollect("英语");
		if(var.vt!=VT_NULL)
			yingyu=(LPCSTR)_bstr_t(var);
	    var=m_pRecordset->GetCollect("物理");
		if(var.vt!=VT_NULL)
			wuli=(LPCSTR)_bstr_t(var);
	    var=m_pRecordset->GetCollect("化学");
		if(var.vt!=VT_NULL)
			huaxue=(LPCSTR)_bstr_t(var); 
		
		m_list1.InsertItem(i,"0");
		m_list1.SetItemText(i,0,num);
		m_list1.SetItemText(i,1,name);
		m_list1.SetItemText(i,2,yuwen);
		m_list1.SetItemText(i,3,shuxue);
		m_list1.SetItemText(i,4,yingyu);
		m_list1.SetItemText(i,5,wuli);
		m_list1.SetItemText(i,6,huaxue);
		m_pRecordset->MoveNext();
		i++;

		}


	nCurSel=-1;

	}
	catch(_com_error* e)
	{
		AfxMessageBox(e->ErrorMessage());
	}
	SQLQueryAll=="";



}


void CStudentdlg::OnColumnclickList2(NMHDR* pNMHDR, LRESULT* pResult) 
{
	NM_LISTVIEW* pNMListView = (NM_LISTVIEW*)pNMHDR;


    
	if( pNMListView->iSubItem == m_list1.m_nSortedCol )
		m_list1.m_fAsc = !m_list1.m_fAsc;
	
	else
	{
		m_list1.m_fAsc = TRUE;
		m_list1.m_nSortedCol = pNMListView->iSubItem;
		
	}
		
    Ssort(pNMListView->iSubItem);





	*pResult = 0;
}

#include "ADDdlg.h"
void CStudentdlg::OnAPPEND() 
{
	CADDdlg dlg;
	CString m_class;
    m_combo3.GetLBText(m_combo3.GetCurSel(),m_class);