scoredlg.cpp

student manager system

// ScoreDlg.cpp : implementation file
//

#include "stdafx.h"
#include "StuManage.h"
#include "ScoreDlg.h"
#include "Columns.h"
#include "Column.h"

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

/////////////////////////////////////////////////////////////////////////////
// CScoreDlg dialog

extern CStuManageApp theApp;

CScoreDlg::CScoreDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CScoreDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CScoreDlg)
	m_nScore = 0;
	m_strCourseId = _T("");
	m_strRemark = _T("");
	m_strId = _T("");
	m_strName = _T("");
	m_nLookType = -1;
	m_strCourseName = _T("");
	//}}AFX_DATA_INIT
}


void CScoreDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CScoreDlg)
	DDX_Control(pDX, IDC_DATAGRID_SCORE, m_dgScore);
	DDX_Control(pDX, IDC_DATAGRID_RESULT, m_dgResult);
	DDX_Text(pDX, IDC_EDIT_SCORE, m_nScore);
	DDX_Text(pDX, IDC_EDIT_SCORE_COURSEID, m_strCourseId);
	DDX_Text(pDX, IDC_EDIT_REMARK, m_strRemark);
	DDX_Text(pDX, IDC_EDIT_SCORE_ID, m_strId);
	DDX_Text(pDX, IDC_EDIT_SCORE_NAME, m_strName);
	DDX_Radio(pDX, IDC_RADIO_STUDENTID, m_nLookType);
	DDX_Text(pDX, IDC_EDIT_COURSE_NAME, m_strCourseName);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CScoreDlg, CDialog)
	//{{AFX_MSG_MAP(CScoreDlg)
	ON_BN_CLICKED(IDC_PUTIN_SCORE_BTN, OnPutinScoreBtn)
	ON_BN_CLICKED(IDC_MODIFY_SCORE_BTN, OnModifyScoreBtn)
	ON_BN_CLICKED(IDC_LOOKFOR_SCORE_BTN, OnLookforScoreBtn)
	ON_BN_CLICKED(ID_EXECUTE_SCORE_BTN, OnExecuteScoreBtn)
	ON_BN_CLICKED(IDC_DEL_SCORE_BTN, OnDelScoreBtn)
	ON_EN_CHANGE(IDC_EDIT_SCORE_ID, OnChangeEditScoreId)
	ON_EN_CHANGE(IDC_EDIT_SCORE_COURSEID, OnChangeEditScoreCourseid)
	ON_BN_CLICKED(ID_LOOKFOR_SCORE_BTN, OnLookforScoreBtn)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CScoreDlg message handlers

BOOL CScoreDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	m_nLookType = 0;
	// TODO: Add extra initialization here
	m_pRecordset.CreateInstance("ADODB.Recordset");
	m_pRecordset->Open("SELECT * FROM Score",_variant_t((IDispatch *)theApp.m_pConnection,true),adOpenDynamic,adLockPessimistic,adCmdText);       
	
	m_dgScore.SetRefDataSource(NULL);
	m_dgScore.SetRefDataSource((LPUNKNOWN)m_pRecordset);
	m_dgScore.SetColumnHeaders(2) ;

	_variant_t var;
	var = long(0);
	m_dgScore.GetColumns().GetItem(var).SetCaption("学号");
	m_dgScore.GetColumns().GetItem(var).SetWidth(50);
	var = long(1);
	m_dgScore.GetColumns().GetItem(var).SetCaption("姓名");
	m_dgScore.GetColumns().GetItem(var).SetWidth(50);
	var = long(2);
	m_dgScore.GetColumns().GetItem(var).SetCaption("课程编号");
	m_dgScore.GetColumns().GetItem(var).SetWidth(50);
	var = long(3);
	m_dgScore.GetColumns().GetItem(var).SetCaption("课程名称");
	m_dgScore.GetColumns().GetItem(var).SetWidth(50);
	var = long(4);
	m_dgScore.GetColumns().GetItem(var).SetCaption("分数");
	m_dgScore.GetColumns().GetItem(var).SetWidth(30);
	var = long(5);
	m_dgScore.GetColumns().GetItem(var).SetCaption("备注");
	m_dgScore.GetColumns().GetItem(var).SetWidth(50);
	
	m_dgScore.Refresh();
	
	UpdateData(FALSE);
	
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CScoreDlg::OnPutinScoreBtn() 
{
	// TODO: Add your control notification handler code here
	if(theApp.m_Level != 1)
	{
		AfxMessageBox("您无权录入成绩");
		return;
	}
	m_nScore = 0;
	m_strCourseId = "";
	m_strRemark = "";
	m_strId = "";
	m_strName = "";
	m_strCourseName = "";
	AfxMessageBox("请输入新的成绩记录");
	action = 1;	
	UpdateData(FALSE);
}

void CScoreDlg::OnModifyScoreBtn() 
{
	// TODO: Add your control notification handler code here
	if(theApp.m_Level != 1)
	{
		AfxMessageBox("您无权修改成绩");
		return;
	}
	if(AfxMessageBox("确定修改此成绩吗？",MB_YESNO)==IDYES)	
		action = 2;
}

void CScoreDlg::OnLookforScoreBtn() 
{
	// TODO: Add your control notification handler code here	
	UpdateData(TRUE);
	if(m_nLookType == 0)
	{
		m_strId = "";
		AfxMessageBox("请输入您要查找的学号");
		return;
	}
	
	else if(m_nLookType == 1)
	{
		m_strCourseId = "";
		AfxMessageBox("请输入您要查找的课程号");
		return;
	}
		
	UpdateData(FALSE);
}

void CScoreDlg::OnExecuteScoreBtn() 
{
	// TODO: Add your control notification handler code here
	UpdateData(TRUE);
	
	CString sql,str,studentid,courseid;
	sql = "select * from Score ";
	m_pRecordset.CreateInstance("ADODB.Recordset");
	m_pRecordset->Open((_variant_t)sql,_variant_t((IDispatch *)theApp.m_pConnection,true),adOpenDynamic,adLockPessimistic,adCmdText);       
	
	switch(action)
	{
	case 1:		
		m_pRecordset->AddNew();
		m_pRecordset->PutCollect("CourseID",(_variant_t)m_strCourseId);
		m_pRecordset->PutCollect("Remark",(_variant_t)m_strRemark);
		m_pRecordset->PutCollect("ID",(_variant_t)m_strId);
		m_pRecordset->PutCollect("Name",(_variant_t)m_strName);
		m_pRecordset->PutCollect("CourseName",(_variant_t)m_strCourseName);		
		str.Format("%d",m_nScore);
		m_pRecordset->PutCollect("Score",(_variant_t)str);
		
		m_pRecordset->Update();	
		break;

	case 2:	
		if(m_pRecordset->GetRecordCount()!=0)
		{
			m_pRecordset->MoveFirst();
			while(!m_pRecordset->adoEOF)
			{
				studentid=m_pRecordset->GetCollect("ID").bstrVal;
				courseid = m_pRecordset->GetCollect("CourseID").bstrVal;
				if(studentid.CompareNoCase(m_strId) == 0	&& courseid.CompareNoCase(m_strCourseId) == 0)
				{
					m_pRecordset->PutCollect("Remark",(_variant_t)m_strRemark);						
					str.Format("%d",m_nScore);
					m_pRecordset->PutCollect("Score",(_variant_t)str);					
				}
				m_pRecordset->MoveNext();			
			}
		}		
		break;
	case 3:
		if(m_pRecordset->GetRecordCount()!=0)
		{
			m_pRecordset->MoveFirst();
			while(!m_pRecordset->adoEOF)
			{
				studentid=m_pRecordset->GetCollect("ID").bstrVal;
				courseid = m_pRecordset->GetCollect("CourseID").bstrVal;
				if(studentid.CompareNoCase(m_strId) == 0	&& courseid.CompareNoCase(m_strCourseId) == 0)			
					m_pRecordset->Delete(adAffectCurrent);					
				m_pRecordset->MoveNext();			
			}
		}		
		break;		
		
	default:
		break;
	}

	m_pRecordset->Close();

	OnInitDialog();
	UpdateData(FALSE);
	action = 0;
}

void CScoreDlg::OnDelScoreBtn() 
{
	// TODO: Add your control notification handler code here
	if(theApp.m_Level != 1)
	{
		AfxMessageBox("您无权删除成绩");
		return;
	}
	if(AfxMessageBox("确定删除此成绩吗？",MB_YESNO)==IDYES)	
		action = 3;
}

void CScoreDlg::OnChangeEditScoreId() 
{
	// TODO: Add your control notification handler code here
	UpdateData(TRUE);
	CString sql,str;
	if(m_nLookType != 0)
		return;
	sql = "select * from Score where ID = '"+m_strId+"' ";

	m_pRecordset_result.CreateInstance("ADODB.Recordset");
	m_pRecordset_result->Open((_variant_t)sql,_variant_t((IDispatch *)theApp.m_pConnection,true),adOpenDynamic,adLockPessimistic,adCmdText);       	
		
	m_dgResult.SetRefDataSource(NULL);
	m_dgResult.SetRefDataSource((LPUNKNOWN)m_pRecordset_result);
	m_dgResult.SetColumnHeaders(2) ;

	_variant_t var;
	var = long(0);
	m_dgResult.GetColumns().GetItem(var).SetCaption("学号");
	m_dgResult.GetColumns().GetItem(var).SetWidth(50);
	var = long(1);
	m_dgResult.GetColumns().GetItem(var).SetCaption("姓名");
	m_dgResult.GetColumns().GetItem(var).SetWidth(50);
	var = long(2);
	m_dgResult.GetColumns().GetItem(var).SetCaption("课程编号");
	m_dgResult.GetColumns().GetItem(var).SetWidth(50);
	var = long(3);
	m_dgResult.GetColumns().GetItem(var).SetCaption("课程名称");
	m_dgResult.GetColumns().GetItem(var).SetWidth(50);
	var = long(4);
	m_dgResult.GetColumns().GetItem(var).SetCaption("分数");
	m_dgResult.GetColumns().GetItem(var).SetWidth(30);
	var = long(5);
	m_dgResult.GetColumns().GetItem(var).SetCaption("备注");
	m_dgResult.GetColumns().GetItem(var).SetWidth(50);
	

	m_dgResult.Refresh();
	
	UpdateData(FALSE);	
}

void CScoreDlg::OnChangeEditScoreCourseid() 
{
	// TODO: Add your control notification handler code here
	UpdateData(TRUE);
	CString sql,str;
	
	if(m_nLookType != 1)
		return;
	sql = "select * from Score where CourseID = '"+m_strCourseId+"' ";
	
	m_pRecordset_result.CreateInstance("ADODB.Recordset");
	m_pRecordset_result->Open((_variant_t)sql,_variant_t((IDispatch *)theApp.m_pConnection,true),adOpenDynamic,adLockPessimistic,adCmdText);       	
	
	m_dgResult.SetRefDataSource(NULL);
	m_dgResult.SetRefDataSource((LPUNKNOWN)m_pRecordset_result);
	m_dgResult.SetColumnHeaders(2) ;	

	_variant_t var;
	var = long(0);
	m_dgResult.GetColumns().GetItem(var).SetCaption("学号");
	m_dgResult.GetColumns().GetItem(var).SetWidth(50);
	var = long(1);
	m_dgResult.GetColumns().GetItem(var).SetCaption("姓名");
	m_dgResult.GetColumns().GetItem(var).SetWidth(50);
	var = long(2);
	m_dgResult.GetColumns().GetItem(var).SetCaption("课程编号");
	m_dgResult.GetColumns().GetItem(var).SetWidth(50);
	var = long(3);
	m_dgResult.GetColumns().GetItem(var).SetCaption("课程名称");
	m_dgResult.GetColumns().GetItem(var).SetWidth(50);
	var = long(4);
	m_dgResult.GetColumns().GetItem(var).SetCaption("分数");
	m_dgResult.GetColumns().GetItem(var).SetWidth(30);
	var = long(5);
	m_dgResult.GetColumns().GetItem(var).SetCaption("备注");
	m_dgResult.GetColumns().GetItem(var).SetWidth(50);

	m_dgResult.Refresh();
	
	UpdateData(FALSE);	
	
}