searchclassinfermation.cpp

学生成绩管理系统

// searchclassinfermation.cpp : implementation file
//

#include "stdafx.h"
#include "mystudent.h"
#include "searchclassinfermation.h"

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

/////////////////////////////////////////////////////////////////////////////
// Csearchclassinfermation dialog


Csearchclassinfermation::Csearchclassinfermation(CWnd* pParent /*=NULL*/)
	: CDialog(Csearchclassinfermation::IDD, pParent)
{
	//{{AFX_DATA_INIT(Csearchclassinfermation)
	m_classno = _T("");
	m_depart = _T("");
	m_special = _T("");
	m_studyyear = _T("");
	m_entertime = _T("");
	//}}AFX_DATA_INIT
}


void Csearchclassinfermation::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(Csearchclassinfermation)
	DDX_Text(pDX, IDC_EDIT1, m_classno);
	DDX_Text(pDX, IDC_EDIT2, m_depart);
	DDX_Text(pDX, IDC_EDIT3, m_special);
	DDX_Text(pDX, IDC_EDIT4, m_studyyear);
	DDX_Text(pDX, IDC_EDIT5, m_entertime);
	//}}AFX_DATA_MAP
}


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

/////////////////////////////////////////////////////////////////////////////
// Csearchclassinfermation message handlers

void Csearchclassinfermation::OnOK() 
{
	// TODO: Add extra validation here

	UpdateData(true);
	CDatabase m_database;//连接数据库
	Cclassinfo classinfo;
	if(classinfo.IsOpen())
		classinfo.Close();
	CString sql;
	sql.Format("select * from classinfo where classno='%s'",m_classno);
	classinfo.m_pDatabase=&m_database;
	classinfo.Open(AFX_DB_USE_DEFAULT_TYPE,sql);
	if(classinfo.IsEOF())
	{
		MessageBox("没有该班级的信息！","提示");
		return;
	}
	else
	{
		m_depart.Format("%s",classinfo.m_depart);
		m_special.Format("%s",classinfo.m_special);
		m_studyyear.Format("%s",classinfo.m_studyyear);
		sql.Format("%d-%d-%d",classinfo.m_entertime.GetYear(),classinfo.m_entertime.GetMonth(),classinfo.m_entertime.GetDay());
		m_entertime.Format("%s",sql);
		UpdateData(false);

	}





	
//	CDialog::OnOK();
}