stugra.cpp

sadfsdafsd sadfsdafsd sadfsdafsd sadfsdafsd sadfsdafsd sadfsdafsd sadfsdafsd

// Stugra.cpp : implementation file
//

#include "stdafx.h"
#include "教学管理系统.h"
#include "Stugra.h"

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

/////////////////////////////////////////////////////////////////////////////
// Stugra dialog


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


void Stugra::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(Stugra)
	DDX_Control(pDX, IDC_LIST1, list);
	//}}AFX_DATA_MAP
}

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

	// TODO:  在此添加额外的初始化
	DWORD dwExStyle=LVS_EX_FULLROWSELECT | LVS_EX_GRIDLINES | LVS_EX_HEADERDRAGDROP ;  
    list.SetExtendedStyle(dwExStyle);
	list.InsertColumn(0,"总评成绩",LVCFMT_CENTER,80);
	list.InsertColumn(0,"考试成绩",LVCFMT_CENTER,80);
	list.InsertColumn(0,"平时成绩",LVCFMT_CENTER,80);
    list.InsertColumn(0,"学分",LVCFMT_CENTER,50);
    list.InsertColumn(0,"学时",LVCFMT_CENTER,50);
	list.InsertColumn(0,"课程名称",LVCFMT_CENTER,150);
	list.InsertColumn(0,"课程号",LVCFMT_CENTER,70);

	connection2.Initialize();
	float s1;
	CString student,s,number,name,period,a,b,c,d,teachernumber;
	student.Format("select * from 成绩 where 学号='%s' order by 课程号 desc",ID);
	connection2.Connect(student);
	if(connection2.m_pRecordset->adoEOF)
	{
		connection2.Unitialize();
		AfxMessageBox("你尚未选课");
		return false;
	}
	connection2.m_pRecordset->MoveFirst();
	while(!connection2.m_pRecordset->adoEOF)
	{  
		_variant_t TheValue;  CString usual,test,final;
		TheValue = connection2.m_pRecordset->Fields->GetItem("课程号")->Value;
		number=TheValue.bstrVal;

		TheValue = connection2.m_pRecordset->Fields->GetItem("平时成绩")->Value;
		usual=TheValue.bstrVal;
 
		TheValue = connection2.m_pRecordset->Fields->GetItem("考试成绩")->Value;
		test=TheValue.bstrVal;

		TheValue = connection2.m_pRecordset->Fields->GetItem("总评成绩")->Value;
		final=TheValue.bstrVal;
		
		connection.Initialize();
		student.Format("select * from 课程 where 课程号='%s' ",number);
		connection.Connect(student);
		connection.m_pRecordset->MoveFirst();
		if(!connection.m_pRecordset->adoEOF)
		{     
			_variant_t TheValue; 
			TheValue = connection.m_pRecordset->Fields->GetItem("课程名称")->Value;
			name=TheValue.bstrVal;

			TheValue = connection.m_pRecordset->Fields->GetItem("学时")->Value;
			period=TheValue.bstrVal;
			
			TheValue= connection.m_pRecordset->Fields->GetItem("学分")->Value;
			s1=TheValue.fltVal;
			s.Format("%.1f",s1);
		}
        connection.Initialize();
		int nIndex= list.InsertItem(0,number);
        list.SetItemText(nIndex,1,name);
        list.SetItemText(nIndex,2,period);
        list.SetItemText(nIndex,3,s);
		list.SetItemText(nIndex,4,usual);
		list.SetItemText(nIndex,5,test);
		list.SetItemText(nIndex,6,final);
		connection2.m_pRecordset->MoveNext();
	}    
	connection2.Unitialize();
	return TRUE;  // return TRUE unless you set the focus to a control
	// 异常: OCX 属性页应返回 FALSE
}

BEGIN_MESSAGE_MAP(Stugra, CDialog)
	//{{AFX_MSG_MAP(Stugra)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// Stugra message handlers

void Stugra::OnCancel() 
{
	// TODO: Add extra cleanup here
	EndDialog(0);
}