classmdlg.cpp

这是一个学生管理系统 包含学生基本信息 选课信息 宿舍信息 教师信息 课程信息 班机信息 教师信息等录入 查询 修改删除等强大功能

// ClassMdlg.cpp : implementation file
//

#include "stdafx.h"
#include "Student.h"
#include "ClassMdlg.h"

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

/////////////////////////////////////////////////////////////////////////////
// CClassMdlg dialog


CClassMdlg::CClassMdlg(CWnd* pParent /*=NULL*/)
	: CDialog(CClassMdlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CClassMdlg)
	m_classno = _T("");
	m_minno = _T("");
	m_name = _T("");
	m_teachno = _T("");
	m_minno = _T("");
	//}}AFX_DATA_INIT
}


void CClassMdlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CClassMdlg)
	DDX_Text(pDX, IDC_EDIT_CLASSNO, m_classno);
	DDV_MaxChars(pDX, m_classno, 4);
	DDX_Text(pDX, IDC_EDIT_NAME, m_name);
	DDV_MaxChars(pDX, m_name, 40);
	DDX_Text(pDX, IDC_EDIT_MANAGER_NO, m_teachno);
	DDV_MaxChars(pDX, m_teachno, 4);
	DDX_Text(pDX, IDC_EDIT_MONITOR_NO, m_minno);
	DDV_MaxChars(pDX, m_minno, 8);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CClassMdlg, CDialog)
	//{{AFX_MSG_MAP(CClassMdlg)
	ON_BN_CLICKED(IDC_BTN_NEXT, OnBtnNext)
	ON_BN_CLICKED(IDC_BTN_PREV, OnBtnPrev)
	ON_BN_CLICKED(IDC_BTN_RETURN, OnBtnReturn)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CClassMdlg message handlers

void CClassMdlg::OnBtnNext() 
{
	// TODO: Add your control notification handler code here
	m_pClass->MoveNext();
	if(m_pClass->IsEOF())
		m_pClass->MoveLast();
	UpdateField(FALSE);
}

void CClassMdlg::OnBtnPrev() 
{
	// TODO: Add your control notification handler code here
	m_pClass->MovePrev();
	UpdateField(FALSE);
}

void CClassMdlg::OnCancel() 
{
	// TODO: Add extra cleanup here
	CDialog::OnCancel();
}

void CClassMdlg::OnOK() 
{
	// TODO: Add extra validation here
	CModifydlg modify;
	int result=modify.DoModal();
	if(result == IDCANCEL)
		return;
	if(m_kind == 1)//教师
		UpdateField(true);
	else MessageBox("你无权修改数据!");
}

void CClassMdlg::OnBtnReturn() 
{
	// TODO: Add your control notification handler code here
	UpdateField(FALSE);
}

BOOL CClassMdlg::OnInitDialog() //**
{
	CString strSQL;
	BOOL Success;
	CClassSet rs;
	
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	try{
		strSQL="select Class_no,Name,Monitor,Manager from Class";
		Success=rs.Open(AFX_DB_USE_DEFAULT_TYPE,strSQL);
		if(!Success)
		{
			MessageBox("班级表打开失败!");
			this->OnCancel();
			return TRUE;
		}
		UpdateField(FALSE);

		if(m_kind == 1) //教师可以修改
		{
			this->GetDlgItem(IDC_EDIT_NAME)->EnableWindow(true);
			this->GetDlgItem(IDC_EDIT_MONITOR_NO)->EnableWindow(true);
			this->GetDlgItem(IDC_EDIT_TEACHER_NO)->EnableWindow(true);
		}
		rs.Close();
	}
	catch(CDBException *pe){
		AfxMessageBox(pe->m_strError);
		pe->Delete();
	}

	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CClassMdlg::UpdateField(BOOL bSave)
{
	CString strTemp;
	CString strExpress,strSQL,strField;
	
	if(bSave)
	{
		this->UpdateData(true);
		//m_name.TrimRight();
		strExpress.Format("name=\'%s\'",m_name);
		strSQL="update group1.Class set "+strExpress;
		strExpress.Format("Monitor=\'%s\'",m_minno);
		strSQL+=","+strExpress;
		strExpress.Format("Manager=\'%s\'",m_teachno);
		strSQL+=","+strExpress;
		m_pDB->ExecuteSQL(strSQL);
		m_pClass->Requery();
		UpdateField(FALSE);
	}
	else
	{
		m_pClass->GetFieldValue("NAME",m_name);
		m_pClass->GetFieldValue("MONITOR",m_minno);
		m_pClass->GetFieldValue("MANAGER",m_teachno);

		this->UpdateData(bSave);
	}
}