collegeqdlg.cpp

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

// CollegeQdlg.cpp : implementation file
//

#include "stdafx.h"
#include "Student.h"
#include "CollegeQdlg.h"

#include "CollegeSet.h"

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

/////////////////////////////////////////////////////////////////////////////
// CCollegeQdlg dialog


CCollegeQdlg::CCollegeQdlg(CWnd* pParent /*=NULL*/)
	: CDialog(CCollegeQdlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CCollegeQdlg)
	m_name = _T("");
	//}}AFX_DATA_INIT
}


void CCollegeQdlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CCollegeQdlg)
	DDX_Control(pDX, IDC_LIST_COLLEGEQ, m_college_list);
	DDX_Text(pDX, IDC_COLLEGE_NAME, m_name);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CCollegeQdlg, CDialog)
	//{{AFX_MSG_MAP(CCollegeQdlg)
	ON_BN_CLICKED(IDC_BTN_QUERY, OnBtnQuery)
	ON_BN_CLICKED(IDC_BTN_DELETE, OnBtnDelete)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CCollegeQdlg message handlers

void CCollegeQdlg::OnBtnQuery() 
{
	// TODO: Add your control notification handler code here
	UpdateData();
	CDialog::OnCancel();
   
	CCollegeSet pcollege;

	//CDlgLogin *dl;
    CString strSQL;
	try{
		if(!m_name.IsEmpty()){
			strSQL="select * from college where pcollege.m_Name=m_name";
		}
		    
		else{
			AfxMessageBox("请输入要查询的学院!");
			return;
		}
	//AfxMessageBox("打开数据库!");
	if(!pcollege.Open(AFX_DB_USE_DEFAULT_TYPE,strSQL))
	{
		 AfxMessageBox("打开数据库失败!");
		return;
	}
	m_college_list.DeleteAllItems();//将表中原有的记录全部删掉
	int i=0;
	while(!pcollege.IsEOF())
	{
	    m_college_list.InsertItem(i,pcollege.m_College_no);
		m_college_list.SetItemText(i,1,pcollege.m_Name);
		m_college_list.SetItemText(i,2,pcollege.m_Phone);
        m_college_list.SetItemText(i,3,pcollege.m_President);
		m_college_list.SetItemText(i,4,pcollege.m_Introduction);
		i++;
		pcollege.MoveNext();
	}
	pcollege.Close();
	}
	catch(CDBException *pe){
		AfxMessageBox(pe->m_strError);
		pe->Delete();
	}
	
}

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

void CCollegeQdlg::OnBtnDelete() 
{
	// TODO: Add your control notification handler code here
	
}

BOOL CCollegeQdlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	m_college_list.InsertColumn(0,"学院编号");
	m_college_list.InsertColumn(1,"名称");
	m_college_list.InsertColumn(2,"办公电话");
	m_college_list.InsertColumn(3,"院长编号");
    m_college_list.InsertColumn(3,"学院简介");

	m_college_list.SetColumnWidth(0,60);
	m_college_list.SetColumnWidth(1,60);
	m_college_list.SetColumnWidth(2,60);
    m_college_list.SetColumnWidth(3,60);
	m_college_list.SetColumnWidth(4,140);
	m_college_list.SetExtendedStyle(LVS_EX_FULLROWSELECT|LVS_EX_GRIDLINES);	

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