couinfomana.cpp

分管理员和学生界面

// CouInfoMana.cpp : implementation file
//

#include "stdafx.h"
#include "教学管理系统.h"
#include "CouInfoMana.h"

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

/////////////////////////////////////////////////////////////////////////////
// CCouInfoMana dialog


CCouInfoMana::CCouInfoMana(CWnd* pParent /*=NULL*/)
	: CDialog(CCouInfoMana::IDD, pParent)
{
	//{{AFX_DATA_INIT(CCouInfoMana)
	number = _T("");
	name = _T("");
	period = _T("");
	inputnumber = _T("");
	credit = 0.0f;
	//}}AFX_DATA_INIT
}


void CCouInfoMana::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CCouInfoMana)
	DDX_Text(pDX, IDC_COURSE_NO, number);
	DDX_Text(pDX, IDC_COURSE_NAME, name);
	DDX_Text(pDX, IDC_COURSE_TIME, period);
	DDX_Text(pDX, IDC_COURSE_INPUT, inputnumber);
	DDX_Text(pDX, IDC_COURSE_CREDIT, credit);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CCouInfoMana, CDialog)
	//{{AFX_MSG_MAP(CCouInfoMana)
	ON_BN_CLICKED(IDC_COURSE_QUERY, OnCourseQuery)
	ON_BN_CLICKED(IDC_COURSE_ADD, OnCourseAdd)
	ON_BN_CLICKED(IDC_COURSE_MODIFY, OnCourseModify)
	ON_BN_CLICKED(IDC_COURSE_DELETE, OnCourseDelete)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CCouInfoMana message handlers

void CCouInfoMana::OnCourseQuery() 
{
	// TODO: Add your control notification handler code here
	UpdateData(TRUE);
	if(inputnumber.IsEmpty())
	{
		AfxMessageBox("请输入课程号");
		return;
	}
	connection.Initialize();
	CString student;
	student.Format("select * from 课程 where 课程号='%s'",inputnumber);
	connection.Connect(student);
	if(connection.m_pRecordset->adoEOF)
	{
		AfxMessageBox("没有该课程的资料");
		number="";
		name="";
		period="";
		credit=0;
		UpdateData(FALSE);
		connection.Unitialize();	
		return;
	}
	connection.m_pRecordset->MoveFirst();
	while(!connection.m_pRecordset->adoEOF)
	{     
		_variant_t TheValue; 
		
        TheValue = connection.m_pRecordset->Fields->GetItem("课程号")->Value;
		number=TheValue.bstrVal;
		
		TheValue = connection.m_pRecordset->Fields->GetItem("课程名称")->Value;
		name=TheValue.bstrVal;
		
		TheValue = connection.m_pRecordset->Fields->GetItem("学时")->Value;
		period=TheValue.bstrVal;
		
		TheValue= connection.m_pRecordset->Fields->GetItem("学分")->Value;
		credit=TheValue.fltVal;
        UpdateData(FALSE);

		connection.m_pRecordset->MoveNext();
	}	
    connection.Unitialize();
}

void CCouInfoMana::OnCourseAdd() 
{
	// TODO: Add your control notification handler code here
	CString student; 
	UpdateData(TRUE);
	if(number.IsEmpty())
	{
		AfxMessageBox("请输入课程号");
		return;
	}
	if(name.IsEmpty())
	{
		name="空";
	}
	if(period.IsEmpty())
		period="空";
	connection.Initialize();
	student.Format("select * from 课程 where 课程号='%s'",number);
	connection.Connect(student);
	if(!(connection.m_pRecordset->adoEOF))
	{
		AfxMessageBox("已有该课程号的资料,不可重复录入");
		connection.Unitialize();
		return;
	} 
	CString s;
	s.Format("%.1f",credit);
	connection.m_pRecordset->AddNew();///添加新记录 
	connection.m_pRecordset->PutCollect("课程号",_variant_t(number));
	connection.m_pRecordset->PutCollect("课程名称",_variant_t(name));
	connection.m_pRecordset->PutCollect("学时",_variant_t(period));
	connection.m_pRecordset->PutCollect("学分",_variant_t(s));
	connection.m_pRecordset->Update();
	connection.Unitialize();
	MessageBox("课程录入成功");
}

void CCouInfoMana::OnCourseModify() 
{
	// TODO: Add your control notification handler code here
	UpdateData(TRUE);
	if(number.IsEmpty())
	{
		AfxMessageBox("请输入课程号");
		return;
	}
	connection.Initialize();
	CString student; 
	CString s;
	s.Format("%.1f",credit);
	student.Format("select * from 课程 where 课程号='%s'",number);
	connection.Connect(student);
	if(connection.m_pRecordset->adoEOF)
	{
		AfxMessageBox("没有该课程的资料,修改失败");
		connection.Unitialize();
		return;
	}
	connection.m_pRecordset->Fields->GetItem(_variant_t("课程号"))->Value=_bstr_t(number);
	connection.m_pRecordset->Fields->GetItem(_variant_t("课程名称"))->Value=_bstr_t(name);
	connection.m_pRecordset->Fields->GetItem(_variant_t("学时"))->Value=_bstr_t(period);
	connection.m_pRecordset->Fields->GetItem(_variant_t("学分"))->Value=_bstr_t(s);
	connection.m_pRecordset->Update();
	MessageBox("资料修改成功");
	connection.Unitialize();
}

void CCouInfoMana::OnCourseDelete() 
{
	// TODO: Add your control notification handler code here
	CString sSql; 
	UpdateData(TRUE);
	if(inputnumber.IsEmpty())
	{
		AfxMessageBox("请输入课程号");
		return;
	}
	connection.Initialize();
    sSql.Format("select * from 课程 where 课程号='%s'",number);
    connection.Connect(sSql);
	if((connection.m_pRecordset->adoEOF))
	{
		AfxMessageBox("没有该课程号的资料");
		connection.Unitialize();
		return;
	}
    if(AfxMessageBox("确定删除该课程吗?",MB_YESNO) == IDYES)
	{
		connection.m_pRecordset->Delete(adAffectCurrent);///删除当前记录
		connection.m_pRecordset->Update();
		connection.Unitialize();
		try
		{	
			connection.Initialize();
			sSql.Format("select * from 教学 where 课程号='%s'",number);
			connection.Connect(sSql);
			connection.m_pRecordset->MoveFirst();
			while(!(connection.m_pRecordset->adoEOF))
			{
				connection.m_pRecordset->Delete(adAffectCurrent);///删除当前记录
				connection.m_pRecordset->Update();
				connection.m_pRecordset->MoveLast();
			}
			connection.Unitialize();
		}catch(_com_error e){}
		try			
		{	
			connection.Initialize();
			sSql.Format("select * from 选修 where 课程号='%s'",number);
			connection.Connect(sSql);
			connection.m_pRecordset->MoveFirst();
			while(!(connection.m_pRecordset->adoEOF))
			{
				connection.m_pRecordset->Delete(adAffectCurrent);///删除当前记录
				connection.m_pRecordset->Update();
				connection.m_pRecordset->MoveLast();
			}
			connection.Unitialize();
		}catch(_com_error e){}
		try
		{	
			connection.Initialize();
			sSql.Format("select * from 成绩 where 课程号='%s'",number);
			connection.Connect(sSql);
			connection.m_pRecordset->MoveFirst();
			while(!(connection.m_pRecordset->adoEOF))
			{
				connection.m_pRecordset->Delete(adAffectCurrent);///删除当前记录
				connection.m_pRecordset->Update();
				connection.m_pRecordset->MoveLast();
			}
			connection.Unitialize();
		}catch(_com_error e){}
		try
		{	
			connection.Initialize();
			sSql.Format("select * from 选修 where 课程号='%s'",number);
			connection.Connect(sSql);
			connection.m_pRecordset->MoveFirst();
			while(!(connection.m_pRecordset->adoEOF))
			{
				connection.m_pRecordset->Delete(adAffectCurrent);///删除当前记录
				connection.m_pRecordset->Update();
				connection.m_pRecordset->MoveLast();
			}
			connection.Unitialize();
		}catch(_com_error e){}
		number="";
		name="";
		period="";
		credit=0;
		UpdateData(FALSE);	
		MessageBox("删除成功");
	}
}

void CCouInfoMana::OnCancel() 
{
	// TODO: Add extra cleanup here
	EndDialog(0);
}