teachmqdlg.cpp

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

// TeachMQdlg.cpp : implementation file
//

#include "stdafx.h"
#include "Student.h"
#include "TeachMQdlg.h"

#include "TeacherSet.h"
#include "InstrucSet.h"

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

/////////////////////////////////////////////////////////////////////////////
// CTeachMQdlg dialog


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


void CTeachMQdlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CTeachMQdlg)
	DDX_Control(pDX, IDC_LIST_TEACHQ, m_stuQery_List);
	DDX_Text(pDX, IDC_EDIT_NAME, m_name);
	DDV_MaxChars(pDX, m_name, 40);
	DDX_Text(pDX, IDC_EDIT_TEACH_NO, m_teach_no);
	DDV_MaxChars(pDX, m_teach_no, 40);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CTeachMQdlg, CDialog)
	//{{AFX_MSG_MAP(CTeachMQdlg)
	ON_BN_CLICKED(IDC_BTN_PERSON, OnBtnPerson)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CTeachMQdlg message handlers

BOOL CTeachMQdlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	m_stuQery_List.InsertColumn(0,"教师编号");
	m_stuQery_List.InsertColumn(1,"姓名");
	m_stuQery_List.InsertColumn(2,"性别");
	m_stuQery_List.InsertColumn(3,"联系电话");
    m_stuQery_List.InsertColumn(4,"职称");
	m_stuQery_List.InsertColumn(5,"所在学院编号");
	m_stuQery_List.InsertColumn(6,"所在系编号");

 	m_stuQery_List.InsertColumn(7,"课程编号");
	m_stuQery_List.InsertColumn(8,"教室编号");
	m_stuQery_List.InsertColumn(9,"班级编号");
	m_stuQery_List.InsertColumn(10,"授课时间");
    

	m_stuQery_List.SetColumnWidth(0,80);
	m_stuQery_List.SetColumnWidth(1,60);
	m_stuQery_List.SetColumnWidth(2,60);
    m_stuQery_List.SetColumnWidth(3,100);
	m_stuQery_List.SetColumnWidth(4,100);
    m_stuQery_List.SetColumnWidth(5,100);
	m_stuQery_List.SetColumnWidth(6,100);

	m_stuQery_List.SetColumnWidth(0,100);
	m_stuQery_List.SetColumnWidth(1,100);
	m_stuQery_List.SetColumnWidth(2,100);
    m_stuQery_List.SetColumnWidth(3,100);
	m_stuQery_List.SetColumnWidth(4,100);
	m_stuQery_List.SetExtendedStyle(LVS_EX_FULLROWSELECT|LVS_EX_GRIDLINES);
	
	
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CTeachMQdlg::OnBtnPerson() 
{
	// TODO: Add your control notification handler code here
	CTeacherSet pteacher;
	CInstrucSet pinst;
	try{

	CString strSQL1,strSQL2,strSQL3;
	if(!m_teach_no.IsEmpty()){
	    strSQL1="select * from teacher where pteacher.m_Stu_no=m_teach_no";
		
	}
	else {
		if(m_name.IsEmpty()){
			AfxMessageBox("请输入所要查询的教师的学号或姓名!");return;}
		strSQL1="select * from teacher where pteacher.m_Name=m_name";
	}
        
	//AfxMessageBox("打开数据库!");
	if(!pteacher.Open(AFX_DB_USE_DEFAULT_TYPE,strSQL1))
	{
		 AfxMessageBox("打开数据库失败!");
		return;
	}
	m_stuQery_List.DeleteAllItems();//将表中原有的记录全部删掉
	int i=0;
	while(!pteacher.IsEOF())
	{
		strSQL2="select * from instruction where pinst.m_Teacher_no=pteacher.m_teach_no";

        if(!pinst.Open(AFX_DB_USE_DEFAULT_TYPE,strSQL2)){ 
			AfxMessageBox("打开数据库失败!");
		return;
		}
	   
	   //插入基本信息的内容
	    m_stuQery_List.InsertItem(i,pteacher.m_Teacher_no);
		m_stuQery_List.SetItemText(i,1,pteacher.m_Name);
		m_stuQery_List.SetItemText(i,2,pteacher.m_Sex);
		m_stuQery_List.SetItemText(i,3,pteacher.m_Phone);
		m_stuQery_List.SetItemText(i,4,pteacher.m_Post);
		m_stuQery_List.SetItemText(i,5,pteacher.m_College_no);
		m_stuQery_List.SetItemText(i,6,pteacher.m_Depart_no);

		m_stuQery_List.SetItemText(i,7,pinst.m_Course_no);
		m_stuQery_List.SetItemText(i,8,pinst.m_Classroom_no);
		m_stuQery_List.SetItemText(i,9,pinst.m_Class_no);
		m_stuQery_List.SetItemText(i,10,pinst.m_Instruct_time);
		i++;
		pinst.Close();

		pteacher.MoveNext();
	}
	pteacher.Close();
	}
	catch(CDBException *pe){
		AfxMessageBox(pe->m_strError);
		pe->Delete();
	}	
}

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