coursedlg.cpp

陕西理工学院计算机系教师信息管理系统的设计与实现

// CourseDlg.cpp : implementation file
//

#include "stdafx.h"
#include "TeacherMIS.h"
#include "CourseDlg.h"
#include "columns.h"
#include "column.h"
#include "AddCourseDlg.h"
#include "Course.h"

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

/////////////////////////////////////////////////////////////////////////////
// CCourseDlg dialog


CCourseDlg::CCourseDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CCourseDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CCourseDlg)
	m_strName = _T("");
	m_strID = _T("");
	//}}AFX_DATA_INIT
}


void CCourseDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CCourseDlg)
	DDX_Control(pDX, IDC_ADODC1, m_adodcCourse);
	DDX_Control(pDX, IDC_DATAGRID1, m_datagridCourse);
	DDX_Text(pDX, IDC_EDIT_NAME, m_strName);
	DDX_Text(pDX, IDC_EDIT_ID, m_strID);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CCourseDlg, CDialog)
	//{{AFX_MSG_MAP(CCourseDlg)
	ON_BN_CLICKED(IDC_BUTTON_ADDCOURSE, OnButtonAddcourse)
	ON_BN_CLICKED(IDC_BUTTON_QUERY, OnButtonQuery)
	ON_BN_CLICKED(IDC_BUTTON_ID, OnButtonId)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CCourseDlg message handlers





void CCourseDlg::ResetCol()
{
	CColumns allCols;
	CColumn onecol;
	allCols=m_datagridCourse.GetColumns();
	//设置各列标题和宽度
	onecol=allCols.GetItem(COleVariant(long(0)));
	onecol.SetCaption("课程号");
	onecol.SetWidth(50);
	onecol=allCols.GetItem(COleVariant(long(1)));
	onecol.SetCaption("课程名");
	onecol.SetWidth(100);
	onecol=allCols.GetItem(COleVariant(long(2)));
	onecol.SetCaption("学时");
	onecol.SetWidth(50);
	onecol=allCols.GetItem(COleVariant(long(3)));
	onecol.SetCaption("学分");
	onecol.SetWidth(50);
	onecol=allCols.GetItem(COleVariant(long(4)));
	onecol.SetCaption("上课教室");
	onecol.SetWidth(100);
}

void CCourseDlg::OnButtonQuery() 
{
	// TODO: Add your control notification handler code here
	UpdateData(TRUE);
	
	if (m_strName.IsEmpty()) 
	{
		MessageBox("请输入课程名!");
		return;
	}

	CString strSQL="select * from tbCourse where Name like'%"+m_strName+"%'";
	//如果没有课程名，给出提示
	//使用Course类
 	CCourse  name;
    if (name.HaveName(m_strName)<0) 
	{
		MessageBox("该门课程不存在!");
 		return;
    }
	m_adodcCourse.SetRecordSource(strSQL);
	m_adodcCourse.Refresh();
	ResetCol();	
}

void CCourseDlg::OnButtonAddcourse() 
{
	// TODO: Add your control notification handler code here
	CAddCourseDlg dlg;
	//如果添加了记录，则刷新数据
	if (dlg.DoModal()==IDOK)
	{
		m_adodcCourse.Refresh();
		ResetCol();
	}	
}

BOOL CCourseDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	ResetCol();
	// TODO: Add extra initialization here
	
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CCourseDlg::OnButtonId() 
{
	// TODO: Add your control notification handler code here
	UpdateData(TRUE);
	if (m_strID.IsEmpty()) 
	{
		MessageBox("请输入课程编号!");
			return;
	}
	CString strSQL;
	strSQL.Format("select * from tbCourse where CourseID='%s'",m_strID);
	//如果没有该课程名，给出提示
	//使用Course类
 	CCourse  TchID;
    if (TchID.HaveID(m_strID)<0) 
	{
		MessageBox("该编号不存在!");
 		return;
	}
	m_adodcCourse.SetRecordSource(strSQL);
	m_adodcCourse.Refresh();
	ResetCol();	
}