courseinfermation.cpp

学生成绩管理系统

// courseinfermation.cpp : implementation file
//

#include "stdafx.h"
#include "mystudent.h"
#include "courseinfermation.h"

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

/////////////////////////////////////////////////////////////////////////////
// Ccourseinfermation dialog


Ccourseinfermation::Ccourseinfermation(CWnd* pParent /*=NULL*/)
	: CDialog(Ccourseinfermation::IDD, pParent)
{
	//{{AFX_DATA_INIT(Ccourseinfermation)
	m_cname = _T("");
	m_cno = _T("");
	//}}AFX_DATA_INIT
}


void Ccourseinfermation::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(Ccourseinfermation)
	DDX_Control(pDX, IDC_COMBO4, m_credit);
	DDX_Control(pDX, IDC_COMBO3, m_hours);
	DDX_Control(pDX, IDC_COMBO2, m_copen);
	DDX_Control(pDX, IDC_COMBO1, m_cclass);
	DDX_Text(pDX, IDC_EDIT1, m_cname);
	DDX_Text(pDX, IDC_EDIT2, m_cno);
	//}}AFX_DATA_MAP
}


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

/////////////////////////////////////////////////////////////////////////////
// Ccourseinfermation message handlers

BOOL Ccourseinfermation::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	
	m_copen.AddString("第一学期");
	m_copen.AddString("第二学期");
	m_copen.AddString("第三学期");
	m_copen.AddString("第四学期");
	m_copen.AddString("第五学期");
	m_copen.AddString("第六学期");
	m_copen.AddString("第七学期");
	m_copen.AddString("第八学期");
	m_copen.SetCurSel(0);

	m_credit.AddString("1学分");
	m_credit.AddString("2学分");
	m_credit.AddString("3学分");
	m_credit.AddString("4学分");
	m_credit.SetCurSel(0);

	m_hours.AddString("16学时");
	m_hours.AddString("32学时");
	m_hours.AddString("48学时");
	m_hours.AddString("64学时");
	m_hours.SetCurSel(0);

	m_cclass.AddString("必修课");
	m_cclass.AddString("选修课");
	m_cclass.SetCurSel(0);
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void Ccourseinfermation::OnOK() 
{
	// TODO: Add extra validation here
	 UpdateData();
	 CDatabase m_database;
	 Ccourse course;
	 if(m_cno.IsEmpty() || m_cname.IsEmpty() )
	{
		//如果资料不全就提示错误
		MessageBox("请输入相应的数据!","提示");
		return;
	} 
	CString sql,str_cclass,str_copen,str_hours,str_credit;
	sql.Format("select * from course where cno='%s'",m_cno);
	course.m_pDatabase=&m_database;
	course.Open(AFX_DB_USE_DEFAULT_TYPE,sql);
	if(!course.IsEOF())//判断是否重课程号
	{
		MessageBox("课程号不能重复!" ,"提示");
		return;
	}
	int index1=m_cclass.GetCurSel();
	m_cclass.GetLBText(index1,str_cclass);

	int index2=m_copen.GetCurSel();
	m_copen.GetLBText(index2,str_copen);

	int index3=m_hours.GetCurSel();
	m_hours.GetLBText(index3,str_hours);

	int index4=m_credit.GetCurSel();
	m_credit.GetLBText(index4,str_credit);

	sql.Format("insert into course values('%s','%s','%s','%s','%s','%s')",
		m_cno,m_cname,str_cclass,str_copen,str_hours,str_credit);

	//sql.Format("insert into course values('%s','%s','%s','%s','%s','%s')",
//				m_cno,m_cname,str_cclass,str_copen,str_hours,str_credit);
	m_database.ExecuteSQL(sql);
	MessageBox("保存成功!","提示");
	CDialog::OnOK();

}