classinfermation.cpp

学生成绩管理系统

// classinfermation.cpp : implementation file
//

#include "stdafx.h"
#include "mystudent.h"
#include "classinfermation.h"

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

/////////////////////////////////////////////////////////////////////////////
// Cclassinfermation dialog


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


void Cclassinfermation::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(Cclassinfermation)
	DDX_Control(pDX, IDC_DATETIMEPICKER1, m_entertime);
	DDX_Control(pDX, IDC_COMBO1, m_studyyear);
	DDX_Text(pDX, IDC_EDIT1, m_classno);
	DDX_Text(pDX, IDC_EDIT2, m_depart);
	DDX_Text(pDX, IDC_EDIT3, m_special);
	//}}AFX_DATA_MAP
}


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

/////////////////////////////////////////////////////////////////////////////
// Cclassinfermation message handlers

BOOL Cclassinfermation::OnInitDialog() //初始化对话框
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	m_studyyear.AddString("2年制");
	m_studyyear.AddString("3年制");
	m_studyyear.AddString("4年制");
	m_studyyear.AddString("5年制");
	m_studyyear.SetCurSel(2);
	
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void Cclassinfermation::OnOK() 
{
	// TODO: Add extra validation here
	UpdateData();
	CDatabase m_database;
	Cclassinfo classinfo;
	if(m_classno.IsEmpty()||m_depart.IsEmpty()||m_special.IsEmpty())
	{
		MessageBox("请输入相应的数据","提示");
		return;
	}
	CString sql,str_studyyear,str_time;
	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_studyyear.GetCurSel();
	m_studyyear.GetLBText(index,str_studyyear);
//	`````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````
	sql.Format("insert into classinfo values('%s','%s','%s','%s','%s')",
		m_classno,m_depart,m_special,str_studyyear,str_time);

	m_database.ExecuteSQL(sql);
	MessageBox("保存成功!","提示");

	CDialog::OnOK();
}