modifycourseinfermation.cpp

学生成绩管理系统

// modifycourseinfermation.cpp : implementation file
//

#include "stdafx.h"
#include "mystudent.h"
#include "modifycourseinfermation.h"

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

/////////////////////////////////////////////////////////////////////////////
// Cmodifycourseinfermation dialog


Cmodifycourseinfermation::Cmodifycourseinfermation(CWnd* pParent /*=NULL*/)
	: CDialog(Cmodifycourseinfermation::IDD, pParent)
{
	//{{AFX_DATA_INIT(Cmodifycourseinfermation)
	m_cno = _T("");
	m_cname = _T("");
	m_cno1 = _T("");
	m_cname1 = _T("");
	m_hours = _T("");
	m_credit = _T("");
	m_cclass = _T("");
	m_copen = _T("");
	//}}AFX_DATA_INIT
}


void Cmodifycourseinfermation::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(Cmodifycourseinfermation)
	DDX_Text(pDX, IDC_EDIT1, m_cno);
	DDX_Text(pDX, IDC_EDIT2, m_cname);
	DDX_Text(pDX, IDC_STATIC1, m_cno1);
	DDX_Text(pDX, IDC_STATIC2, m_cname1);
	DDX_Text(pDX, IDC_STATIC3, m_hours);
	DDX_Text(pDX, IDC_STATIC4, m_credit);
	DDX_CBString(pDX, IDC_COMBO3, m_cclass);
	DDX_CBString(pDX, IDC_COMBO4, m_copen);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(Cmodifycourseinfermation, CDialog)
	//{{AFX_MSG_MAP(Cmodifycourseinfermation)
	ON_BN_CLICKED(IDC_BUTTON2, OnButton2)
	ON_BN_CLICKED(IDC_BUTTON3, OnButton3)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// Cmodifycourseinfermation message handlers

void Cmodifycourseinfermation::OnOK() 
{
	// TODO: Add extra validation here
	UpdateData(true);
	CDatabase m_database;
	Ccourse course;
	if(course.IsOpen())
		course.Close();
	CString sql;
	sql.Format("select * from course where cno='%s' or cname='%s'",m_cno,m_cname);
	course.m_pDatabase=&m_database;
	course.Open(AFX_DB_USE_DEFAULT_TYPE,sql);
	if(course.IsEOF())
	{
		MessageBox("没有该课程的信息！","提示");
		return;
	}
	else
	{
		m_cno1.Format("%s",course.m_cno);
		m_cname1.Format("%s",course.m_cname);
		m_cclass.Format("%s",course.m_cclass);
		m_copen.Format("%s",course.m_copen);
		m_hours.Format("%s",course.m_hours);
		m_credit.Format("%s",course.m_credit);
		UpdateData(false);
	}
	
	//CDialog::OnOK();
}

void Cmodifycourseinfermation::OnButton2() 
{
	// TODO: Add your control notification handler code here

	UpdateData(true);
	CDatabase m_database;
	Ccourse course;
	if(course.IsOpen())
		course.Close();
	CString sql;
	sql.Format("select * from course where cno='%s' or cname='%s'",m_cno,m_cname);
	course.m_pDatabase=&m_database;
	course.Open(AFX_DB_USE_DEFAULT_TYPE,sql);
	if(course.IsEOF())
	{
		MessageBox("请输入正确的信息！","提示");
		return;
	}
	else
	{
		sql.Format("update course set cclass='%s',copen='%s' where cno='%s'",
			m_cclass,m_copen,m_cno1);
		m_database.ExecuteSQL(sql);
		sql.Format("你对课程名为%s的修改已成功！",course.m_cno);
		MessageBox(sql);
		CDialog::OnOK();
	}



	
}

void Cmodifycourseinfermation::OnButton3() 
{
	// TODO: Add your control notification handler code here
		UpdateData(true);
	CDatabase m_database;
	Ccourse course;
	Cscore score;
	if(course.IsOpen())
		course.Close();
	CString sql;
	sql.Format("select * from course where cno='%s' or cname='%s'",m_cno,m_cname);
	course.m_pDatabase=&m_database;
	course.Open(AFX_DB_USE_DEFAULT_TYPE,sql);
	if(course.IsEOF())
	{
		MessageBox("请输入正确的信息！","提示");
		return;
	}
	else
	{
		sql.Format("select * from score where course='%s'",course.m_cname);
		score.m_pDatabase=&m_database;
		score.Open(AFX_DB_USE_DEFAULT_TYPE,sql);
		sql.Format("delete score where course='%s'",course.m_cname);
		m_database.ExecuteSQL(sql);
		sql.Format("delete course where cno='%s' or cname='%s'",m_cno,m_cname);
		m_database.ExecuteSQL(sql);
		MessageBox("删除成功！","提示");
	}
	CDialog::OnOK();
	
}