stuinfermation.cpp

学生成绩管理系统

// stuinfermation.cpp : implementation file
//

#include "stdafx.h"
#include "mystudent.h"
#include "stuinfermation.h"

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

/////////////////////////////////////////////////////////////////////////////
// Cstuinfermation dialog


Cstuinfermation::Cstuinfermation(CWnd* pParent /*=NULL*/)
	: CDialog(Cstuinfermation::IDD, pParent)
{
	//{{AFX_DATA_INIT(Cstuinfermation)
	m_birthday = 0;
	m_stuname = _T("");
	m_stuno = _T("");
	m_native = _T("");
	m_homeadd = _T("");
	m_classno = _T("");
	//}}AFX_DATA_INIT
}


void Cstuinfermation::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(Cstuinfermation)
	DDX_Control(pDX, IDC_COMBO1, m_xb);
	DDX_DateTimeCtrl(pDX, IDC_DATETIMEPICKER1, m_birthday);
	DDX_Text(pDX, IDC_EDIT1, m_stuname);
	DDX_Text(pDX, IDC_EDIT3, m_stuno);
	DDX_Text(pDX, IDC_EDIT6, m_native);
	DDX_Text(pDX, IDC_EDIT7, m_homeadd);
	DDX_Text(pDX, IDC_EDIT8, m_classno);
	//}}AFX_DATA_MAP
}


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

/////////////////////////////////////////////////////////////////////////////
// Cstuinfermation message handlers

BOOL Cstuinfermation::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	m_xb.AddString("男");m_xb.AddString("女");m_xb.SetCurSel(0);
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void Cstuinfermation::OnOK() 
{
	// TODO: Add extra validation here
	UpdateData();
	CDatabase m_database;//连接数据库
	Cstudentset student;
	Cclassinfo classinfo;
	if(m_stuname.IsEmpty() || m_stuno.IsEmpty() )
	{
		//如果资料不全就提示错误
		MessageBox("请输入相应的数据!","提示");
		return;
	} 
	CString sql,str_xb,str_time;
	sql.Format("select * from student where stuno='%s'",m_stuno);
	student.m_pDatabase=&m_database;
	student.Open(AFX_DB_USE_DEFAULT_TYPE,sql);
	if(!student.IsEOF())//判断是否重学号
	{
		MessageBox("学号不能重复!" ,"提示");
		return;
	}

	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;
	}
	int index=m_xb.GetCurSel();
	m_xb.GetLBText(index,str_xb);
	GetDlgItemText(IDC_DATETIMEPICKER1,str_time);//
//	str_birth.Format("%d-%d-%d",m_birthday.GetYear(),m_birthday.GetMonth(),m_birthday.GetDay());
	sql.Format("insert into student values('%s','%s','%s','%s','%s','%s','%s')",
		m_stuname,m_stuno,str_xb,str_time,m_native,m_homeadd,m_classno);
	m_database.ExecuteSQL(sql);
	MessageBox("保存成功!","提示");
	CDialog::OnOK();
}