scoredlg.cpp

是自己做的一个小的学生管理系统.希望对大家有用

// ScoreDlg.cpp : implementation file
//

#include "stdafx.h"
#include "student2.h"
#include "ScoreDlg.h"
#include "Student.h"
#include "College.h"
#include "Dept.h"
#include "Banji.h"

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

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


CScoreDlg::CScoreDlg(CWnd* pParent /*=NULL*/)
: CDialog(CScoreDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CScoreDlg)
	m_chengji = 0;
	m_dianhua = _T("");
	m_jiatingzhuzhi = _T("");
	m_xuefen = 0;
	m_xingming = _T("");
	m_zhenzhimianmao = _T("");
	m_xuehao = _T("");
	m_xingbie = _T("");
	m_banji = _T("");
	m_xystr = _T("");
	m_deptname = _T("");
	//}}AFX_DATA_INIT
}


void CScoreDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CScoreDlg)
	DDX_Control(pDX, IDC_COMBO_BJ, m_bjctrl);
	DDX_Control(pDX, IDC_COMBO_ZY, m_zyctrl);
	DDX_Control(pDX, IDC_COMBO_XY, m_xyctrl);
	DDX_Control(pDX, IDC_DATETIMEPICKER1, m_time);
	DDX_Text(pDX, IDC_EDIT_CJ, m_chengji);
	DDX_Text(pDX, IDC_EDIT_DH, m_dianhua);
	DDX_Text(pDX, IDC_EDIT_JTZZ, m_jiatingzhuzhi);
	DDX_Text(pDX, IDC_EDIT_XF, m_xuefen);
	DDX_Text(pDX, IDC_EDIT_XM, m_xingming);
	DDX_Text(pDX, IDC_EDIT_ZZMM, m_zhenzhimianmao);
	DDX_Text(pDX, IDC_EDIT_XH, m_xuehao);
	DDX_CBString(pDX, IDC_COMBO_SEX, m_xingbie);
	DDX_CBString(pDX, IDC_COMBO_BJ, m_banji);
	DDX_CBString(pDX, IDC_COMBO_XY, m_xystr);
	DDX_CBString(pDX, IDC_COMBO_ZY, m_deptname);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CScoreDlg, CDialog)
//{{AFX_MSG_MAP(CScoreDlg)
ON_CBN_SELCHANGE(IDC_COMBO_XY, OnSelchangeComboXy)
ON_CBN_SELCHANGE(IDC_COMBO_ZY, OnSelchangeComboZy)
//}}AFX_MSG_MAP
END_MESSAGE_MAP()

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

void CScoreDlg::OnOK() 
{
	// TODO: Add extra validation here
	//UpdateData(FALSE);
	
	
	CDialog::OnOK();
}

void CScoreDlg::OnSelchangeComboXy() 
{
	// TODO: Add your control notification handler code here
	m_zyctrl.ResetContent();
	CString strTemp; 
	m_xyctrl.GetWindowText(strTemp);
	
	CString strCollegeQuery;	
	strCollegeQuery.Format("SELECT * FROM college WHERE collegename ='%s'",strTemp);
	CDatabase db1;
	CCollege col(&db1);
    col.Open(AFX_DB_USE_DEFAULT_TYPE,strCollegeQuery);
	
	CString strdeptQuery;
	strdeptQuery.Format("SELECT * FROM dept WHERE collegeno = %d",col.m_collegeno);
	CDatabase db2;
	CDept dep(&db2);
	dep.Open(AFX_DB_USE_DEFAULT_TYPE,strdeptQuery);
	
	int count = dep.GetRecordCount();
	
	if(count>0)
	{
		dep.MoveFirst();
		CString value;
		while(!dep.IsEOF())
		{
			
			dep.GetFieldValue("deptname",dep.m_deptname);
			strTemp.Format("%s",dep.m_deptname);
			m_zyctrl.AddString(strTemp);  
			
			dep.MoveNext();			
		}
	}
	dep.Close();
	col.Close();
	//UpdateData(false); 
}


void CScoreDlg::OnSelchangeComboZy() 
{
	// TODO: Add your control notification handler code here
	m_bjctrl.ResetContent();
	
	CString strTemp; 
	m_zyctrl.GetWindowText(strTemp);	
	
	CString strdeptQuery;	
	strdeptQuery.Format("SELECT * FROM dept WHERE deptname ='%s'",strTemp);
	CDatabase db1;
	CDept spec(&db1);
    spec.Open(AFX_DB_USE_DEFAULT_TYPE,strdeptQuery);

	CString strClassQuery;
	strClassQuery.Format("SELECT * FROM class WHERE deptno = %d",spec.m_deptno);
	CDatabase db2;
	CBanji cla(&db2);
	cla.Open(AFX_DB_USE_DEFAULT_TYPE,strClassQuery);
	
	int count = cla.GetRecordCount();
	
	if(count>0)
	{
		cla.MoveFirst();
		CString value;
		while(!cla.IsEOF())
		{			
			cla.GetFieldValue("classname",cla.m_classname);
			strTemp.Format("%s",cla.m_classname);
			m_bjctrl.AddString(strTemp);  
			
			cla.MoveNext();			
		}
	}
	cla.Close();
	spec.Close();
	//UpdateData(false);
}