score.cpp

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

// SCORE.cpp : implementation file
//

#include "stdafx.h"
#include "YJSYS_HD.h"
#include "SCORE.h"

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

/////////////////////////////////////////////////////////////////////////////
// CSCORE dialog
extern CYJSYS_HDApp theApp;

CSCORE::CSCORE(CWnd* pParent /*=NULL*/)
	: CDialog(CSCORE::IDD, pParent)
{
	//{{AFX_DATA_INIT(CSCORE)
	m_strLessonCode = _T("");
	m_strTeach = _T("");
	//}}AFX_DATA_INIT
}


void CSCORE::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CSCORE)
	DDX_Text(pDX, IDC_SCORELREDIT_LESSON, m_strLessonCode);
	DDX_Text(pDX, IDC_SCORELREDIT_TEACH, m_strTeach);
	DDX_Control(pDX, IDC_DATAGRID_SCORELR, m_dgScoreList);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CSCORE, CDialog)
	//{{AFX_MSG_MAP(CSCORE)
	ON_BN_CLICKED(IDC_SCORELRBTN_LR, OnScorelrbtnLr)
	ON_BN_CLICKED(IDC_SCOREBTN_COMMIT, OnScorebtnCommit)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CSCORE message handlers

BOOL CSCORE::OnInitDialog() 
{
	CDialog::OnInitDialog();
	// TODO: Add extra initialization here
	




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

void CSCORE::OnScorelrbtnLr() 
{
	// TODO: Add your control notification handler code here
	CString sql,str_teach,str_lesson,str_lesson_name;
	int i=0;

	UpdateData(true);
	if("" == m_strLessonCode || "" == m_strTeach)
	{
		MessageBox("请输入完整信息"); return;
	}
	sql = "select * from lesson_teach";
	m_pRecordset_lesson_teach.CreateInstance("ADODB.Recordset");//建立数据集
	m_pRecordset_lesson_teach->Open((_variant_t)sql,_variant_t((IDispatch *)theApp.m_pconnection,true),adOpenDynamic,adLockPessimistic,adCmdText);       	
	
	m_pRecordset_lesson_teach->MoveFirst();
	while(!m_pRecordset_lesson_teach->rsEOF)
	{
		str_teach=m_pRecordset_lesson_teach->GetCollect("TEACH_CODE").bstrVal;
		str_lesson=m_pRecordset_lesson_teach->GetCollect("LESSON_CODE").bstrVal;
       	if(m_strTeach == str_teach && m_strLessonCode == str_lesson)
		{
			str_lesson_name = m_pRecordset_lesson_teach->GetCollect("LESSON_NAME").bstrVal;
			i=1;  break;
		}
		m_pRecordset_lesson_teach->MoveNext();
	}
	if(!i)
	{
		MessageBox("你输入的信息不可进行相关操作，请核实你的权限和信息");	
		return;
	}
	
	sql.Format( "select CODE,LESSON_NAME2,MARK,MARK_BUKAO from PYFA_DEDAIL where LESSON_NAME2 = '"+str_lesson_name+"'");
	m_pRecordset_PYFA_DEDAIL.CreateInstance("ADODB.Recordset");//建立数据集
	m_pRecordset_PYFA_DEDAIL->Open((_variant_t)sql,_variant_t((IDispatch *)theApp.m_pconnection,true),adOpenDynamic,adLockPessimistic,adCmdText);       	
    
	if(m_pRecordset_PYFA_DEDAIL->GetRecordCount() == 0)
	{
		MessageBox("没有相关学生记录，请查实");
		return;
	}

	m_dgScoreList.SetRefDataSource(NULL);
	m_dgScoreList.SetRefDataSource((LPUNKNOWN)m_pRecordset_PYFA_DEDAIL);
	m_dgScoreList.SetColumnHeaders(2) ;	
}

void CSCORE::OnScorebtnCommit() 
{
	// TODO: Add your control notification handler code here
	m_dgScoreList.ReBind();
	m_pRecordset_PYFA_DEDAIL->Update();
	
}