study.cpp

研究生信息管理系统 基于VC++6.0 MFC 内附ACCESS数据库文件 一个完成工程文件 编译通过后可直接运行 （需装有SP5以上补丁）

// STUDY.cpp : implementation file
//

#include "stdafx.h"
#include "YJSYS_HD.h"
#include "STUDY.h"

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

/////////////////////////////////////////////////////////////////////////////
// CSTUDY dialog
extern CYJSYS_HDApp theApp;



CSTUDY::CSTUDY(CWnd* pParent /*=NULL*/)
	: CDialog(CSTUDY::IDD, pParent)
{
	//{{AFX_DATA_INIT(CSTUDY)
	m_nQSTYLE = -1;
	m_strClass = _T("");
	m_strCode = _T("");
	m_strLesson = _T("");
	m_strScore = _T("");
	//}}AFX_DATA_INIT
}


void CSTUDY::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CSTUDY)
	DDX_Control(pDX, IDC_DATAGRID_SCOREQ, m_dgSCOREQList);
	DDX_Radio(pDX, IDC_RADIO_QSTYLE1, m_nQSTYLE);
	DDX_Text(pDX, IDC_SCOREQEDIT_CLASS, m_strClass);
	DDX_Text(pDX, IDC_SCOREQEDIT_CODE, m_strCode);
	DDX_Text(pDX, IDC_SCOREQEDIT_LESSON, m_strLesson);
	DDX_Text(pDX, IDC_SCOREQEDIT_SCORE, m_strScore);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CSTUDY, CDialog)
	//{{AFX_MSG_MAP(CSTUDY)
	ON_BN_CLICKED(IDC_SCOREQBTN_QUERY, OnScoreqbtnQuery)
	ON_BN_CLICKED(IDC_SCOREQBTN_SCORE, OnScoreqbtnScore)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CSTUDY message handlers

void CSTUDY::OnScoreqbtnQuery() 
{
	// TODO: Add your control notification handler code here
	CString sql,str;
	UpdateData(true);
	if(-1 == m_nQSTYLE)
	{
		MessageBox("请选择查询方式"); return;
	} 
	if(0 == m_nQSTYLE)//查询某一学生的全部课程信息
	{
		if("" == m_strCode)
		{
			MessageBox("请输入你的学号");     return;
		}
		else
		{			
		sql.Format("select CODE,NAME,LESSON_NAME,MARK,MARK_BUKAO,SCORE from View_mark_gl where CODE = '"+m_strCode+"'");		
		}
	
	}
	else//1 == m_nQSTYLE
	{
		if("" == m_strLesson || "" == m_strClass)
		{
			MessageBox("请填写完整查询信息"); return;		
		}
		else
		{
			sql.Format("select CODE,NAME,LESSON_NAME,MARK,MARK_BUKAO,SCORE from View_mark_gl where CLASS_CODE = '"+m_strClass+"' and LESSON_CODE = '"+m_strLesson+"'");
		}
	}
	m_pRecordset_View_mark.CreateInstance("ADODB.Recordset");
	m_pRecordset_View_mark->Open((_variant_t)sql,_variant_t((IDispatch *)theApp.m_pconnection,true),adOpenDynamic,adLockPessimistic,adCmdText);      
    
	m_dgSCOREQList.SetRefDataSource(NULL);
	m_dgSCOREQList.SetRefDataSource((LPUNKNOWN)m_pRecordset_View_mark);
	m_dgSCOREQList.SetColumnHeaders(2) ;

	m_dgSCOREQList.Refresh();
	UpdateData(false);
}

void CSTUDY::OnScoreqbtnScore() 
{
	// TODO: Add your control notification handler code here
	CString str,str2;
	int i;
	m_pRecordset_View_mark->MoveFirst();
	while(!m_pRecordset_View_mark->rsEOF)
	{	str = m_pRecordset_View_mark->GetCollect("MARK").bstrVal;
		if("" != str)
		{
	        str2 = m_pRecordset_View_mark->GetCollect("SCORE").bstrVal;
			i+= atoi(str2);
		}	
	
	}
    SetDlgItemInt(IDC_SCOREQEDIT_SCORE,i);
	
}