sccalculate.cpp

学生选课系统

// SCCalculate.cpp : implementation file
//

#include "stdafx.h"
#include "SC.h"
#include "SCCalculate.h"

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

/////////////////////////////////////////////////////////////////////////////
// CSCCalculate dialog


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


void CSCCalculate::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CSCCalculate)
	DDX_Control(pDX, IDC_SCCLIST, m_SCClist);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CSCCalculate, CDialog)
	//{{AFX_MSG_MAP(CSCCalculate)
		// NOTE: the ClassWizard will add message map macros here
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CSCCalculate message handlers

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

	m_SCClist.SetExtendedStyle(LVS_EX_FLATSB|LVS_EX_GRIDLINES|LVS_EX_FULLROWSELECT);
	m_SCClist.InsertColumn(0,"学号(Sno)",LVCFMT_CENTER,50,0);

	m_AdoConn.OnInitADOConn();
	_bstr_t sql;
	sql="SELECT DISTINCT Sno FROM SC";
	m_pRecordset=m_AdoConn.GetRecordSet(sql);
	int i=0;
	while(m_AdoConn.m_pRecordset->adoEOF==0)
	{
		m_SCClist.InsertItem(i,"");
		m_SCClist.SetItemText(i,0,(char*)(_bstr_t)m_pRecordset->GetCollect("Sno"));
		m_pRecordset->MoveNext();
		i++;
	}

	sql="SELECT DISTINCT Course.Cno,Cname FROM Course,SC WHERE Course.Cno=SC.Cno";
	m_pRecordset=m_AdoConn.GetRecordSet(sql);
	int j=1;
	
	while(m_AdoConn.m_pRecordset->adoEOF==0)
	{
		CString temp=(char*)(_bstr_t)m_pRecordset->GetCollect("Cname");
		m_SCClist.InsertColumn(j,temp,LVCFMT_CENTER,100,j);
		ADOConn m_AdoConn2;
		m_AdoConn2.OnInitADOConn();
		_RecordsetPtr m_pRecordset2;
		temp=(char*)(_bstr_t)m_pRecordset->GetCollect("Cno");
		
		sql="CREATE TABLE SC_TEMP(Sno FLOAT,Cno INT,Grade INT,RANK INT)";
		m_AdoConn2.ExecuteSQL(sql);
		sql="INSERT INTO SC_TEMP(Sno,Cno,Grade) SELECT * FROM SC WHERE Cno="+temp;
		m_AdoConn2.ExecuteSQL(sql);
		i=1;
		//sql="CREATE UNIQUE INDEX TEMPGrade ON TEMP TEMP(Grade ASC)";
		//m_AdoConn.ExecuteSQL(sql);
		sql="SELECT * FROM SC_TEMP ORDER BY Grade DESC";
		m_pRecordset2=m_AdoConn2.GetRecordSet(sql);
		while(m_AdoConn2.m_pRecordset->adoEOF==0)
		{
			CString temp1=(char*)(_bstr_t)m_pRecordset2->GetCollect("Sno");
			CString temp2;
			
			temp2.Format("%d",i);
			//MessageBox(temp2);
			sql="UPDATE SC_TEMP SET RANK="+temp2+" WHERE Sno="+temp1;
			m_AdoConn2.ExecuteSQL(sql);
			m_pRecordset2->MoveNext();
			i++;
		} 
		sql="SELECT * FROM SC_TEMP";
		m_pRecordset2=m_AdoConn2.GetRecordSet(sql);
		
		while(m_AdoConn2.m_pRecordset->adoEOF==0)
		{
			CListCtrl *s=(CListCtrl*)GetDlgItem(IDC_SCCLIST);
			CString temp3=(char*)(_bstr_t)m_pRecordset2->GetCollect("Sno");
			int k=0;
			while(k!=s->GetItemCount()-1&&temp3!=s->GetItemText(k,0))
			{
				k++;
			}
			
			m_SCClist.SetItemText(k,j,(char*)(_bstr_t)m_pRecordset2->GetCollect("RANK"));
			m_pRecordset2->MoveNext();
			
		}
		sql="DELETE FROM SC_TEMP";
		m_AdoConn2.ExecuteSQL(sql);
		sql="DROP TABLE SC_TEMP";
		m_AdoConn2.ExecuteSQL(sql);
		m_AdoConn2.ExitConnect();
		m_pRecordset->MoveNext();
		j++;
		
	}

	//统计全局信息
	m_SCClist.InsertColumn(j,"平均分",LVCFMT_CENTER,100,j);
	m_SCClist.InsertColumn(j+1,"总分",LVCFMT_CENTER,100,j+1);
	m_SCClist.InsertColumn(j+2,"总排名",LVCFMT_CENTER,100,j+2);

	sql="SELECT Sno,AVG(Grade),SUM(Grade) FROM SC GROUP BY Sno ORDER BY SUM(Grade) DESC";
	m_pRecordset=m_AdoConn.GetRecordSet(sql);
	i=1;
	while(m_AdoConn.m_pRecordset->adoEOF==0)
	{
		CListCtrl *s=(CListCtrl*)GetDlgItem(IDC_SCCLIST);
		CString temp3=(char*)(_bstr_t)m_pRecordset->GetCollect("Sno");
		int k=0;
		while(k!=s->GetItemCount()-1&&temp3!=s->GetItemText(k,0))
		{
			k++;
		}
		temp3.Format("%d",i);
		//MessageBox((char*)(_bstr_t)m_pRecordset->Fields->Item[(long)1]->Value);
		m_SCClist.SetItemText(k,j,(char*)(_bstr_t)m_pRecordset->Fields->Item[(long)1]->Value);
		m_SCClist.SetItemText(k,j+1,(char*)(_bstr_t)m_pRecordset->Fields->Item[(long)2]->Value);
		m_SCClist.SetItemText(k,j+2,temp3);
		m_pRecordset->MoveNext();
		i++;
	}

	m_AdoConn.ExitConnect();

	return TRUE;
}