teachdlg.cpp

student manage system

// TeachDlg.cpp : implementation file
//

#include "stdafx.h"
#include "StudentScore.h"
#include "TeachDlg.h"

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

/////////////////////////////////////////////////////////////////////////////
// CTeachDlg dialog


CTeachDlg::CTeachDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CTeachDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CTeachDlg)
	//}}AFX_DATA_INIT
}


void CTeachDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CTeachDlg)
	DDX_Control(pDX, IDC_TEACH_TEACHER, m_cTeacher);
	DDX_Control(pDX, IDC_TEACH_COURSE, m_cCourse);
	DDX_Control(pDX, IDC_LIST_TEACH, m_list);
	DDX_Control(pDX, ID_TEACH_EDIT, m_bEdit);
	DDX_Control(pDX, ID_TEACH_DEL, m_bDel);
	DDX_Control(pDX, ID_TEACH_CONFIRM, m_bConfirm);
	DDX_Control(pDX, ID_TEACH_ADD, m_bAdd);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CTeachDlg, CDialog)
	//{{AFX_MSG_MAP(CTeachDlg)
	ON_NOTIFY(NM_CLICK, IDC_LIST_TEACH, OnClickListTeach)
	ON_BN_CLICKED(ID_TEACH_ADD, OnTeachAdd)
	ON_BN_CLICKED(ID_TEACH_EDIT, OnTeachEdit)
	ON_BN_CLICKED(ID_TEACH_DEL, OnTeachDel)
	ON_BN_CLICKED(ID_TEACH_CONFIRM, OnTeachConfirm)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CTeachDlg message handlers

BOOL CTeachDlg::OnInitDialog()
{
	CDialog::OnInitDialog();
	//初始化里CList 控件的和header
	m_list.InsertColumn(0,"授课编号");
    m_list.InsertColumn(1,"课程名称");
    m_list.InsertColumn(2,"教师名称");
	//设置header的宽度
    RECT rectList;
	m_list.GetWindowRect(&rectList);
	int wid=rectList.right-rectList.left-4;
	for(int i=0;i<3;i++)
		m_list.SetColumnWidth(i,wid/3);
    m_list.SetExtendedStyle(LVS_EX_FULLROWSELECT);
    if(!m_database.IsOpen())
	{
		m_database.Open(_T("studentscore"));
	}
	m_recordSet.m_pDatabase=&m_database;
	//将所有的课程名称添加到课程下拉列表中
    CString strSQL;
	strSQL.Format("select * from course where active_status='Y'");
	m_recordSet.Open(CRecordset::forwardOnly,strSQL);
	for(int j=0;j<m_recordSet.GetRecordCount();j++){
		CString temp;
		m_recordSet.GetFieldValue("course_name",temp);
        m_cCourse.AddString(temp);
		m_recordSet.MoveNext();
	}
	m_recordSet.Close();
	//将所有的教师名添加到教师列表中
	strSQL.Format("select * from teacher where active_status='Y'");
	m_recordSet.Open(CRecordset::forwardOnly,strSQL);
	for(int k=0;k<m_recordSet.GetRecordCount();k++){
		CString temp;
		m_recordSet.GetFieldValue("teacher_name",temp);
		m_cTeacher.AddString(temp);
		m_recordSet.MoveNext();
	}
	m_recordSet.Close();
	//调用refreshList()初始化CList中的数据
	RefreshList();
    //调用ResetButton()方法，使按钮处于初始状态
	ResetButton();
	return TRUE;

}

void CTeachDlg::OnClickListTeach(NMHDR* pNMHDR, LRESULT* pResult) 
{
	// TODO: Add your control notification handler code here
	
	*pResult = 0;
}

void CTeachDlg::RefreshList()
{
	//删除CList的所有内容
	m_list.DeleteAllItems();
	//打开记录集
	CString strSQL;
	strSQL.Format("select * from teach,teacher,course where teacher.teacher_no=teach.teacher_no and course.course_no=teach.course_no and teach.active_status='Y'");
    m_recordSet.Open(CRecordset::forwardOnly,strSQL);
	//将记录集显示到 CList中
	for(int i=0;i<m_recordSet.GetRecordCount();i++){
		CString temp;
		m_recordSet.GetFieldValue("teach_id",temp);
		m_list.InsertItem(i,temp);
		m_recordSet.GetFieldValue("course_name",temp);
		m_list.SetItemText(i,1,temp);
        m_recordSet.GetFieldValue("teacher_name",temp);
		m_list.SetItemText(i,2,temp);
        m_recordSet.MoveNext();
	}
	//关闭数据库
	m_recordSet.Close();

}

void CTeachDlg::ResetButton()
{
	//设置不可用
	m_cCourse.EnableWindow(false);
    m_cTeacher.EnableWindow(false);
	//设置确定按钮不可用
	m_bConfirm.EnableWindow(false);
	//设置添加、删除、编辑按钮可用状态
	m_bAdd.EnableWindow(true);
	m_bDel.EnableWindow(true);
	m_bEdit.EnableWindow(true);
}

void CTeachDlg::OnTeachAdd() 
{
	//设置id=0表示添加新记录
	id="0";
	//设置添加后可用的控件
	m_cCourse.EnableWindow(true);
    m_cTeacher.EnableWindow(true);
	m_bConfirm.EnableWindow(true);
	//设置添加后不可用的控件
    m_bAdd.EnableWindow(false);
	m_bEdit.EnableWindow(false);
	m_bDel.EnableWindow(false);	
}

void CTeachDlg::OnTeachEdit() 
{
	//得到CList当前所选的行号
	int row=m_list.GetSelectionMark();
	CString s,strSQL;
	//将当前行的第一列的值赋给s
	s=m_list.GetItemText(row,0);
	if(s=="")//如果s为空，则表示没有选中行
	{
		MessageBox("请选择一行！");
	}
	else//如果有选中一行
	{
		//获得所选行的行号
		int row=m_list.GetSelectionMark();
		CString s;
		//将第1列的值赋给临时字符串s中
		s=m_list.GetItemText(row,0);
		id=s;
		s=m_list.GetItemText(row,1);
		m_cCourse.SelectString(0,s);
        s=m_list.GetItemText(row,2);
		m_cTeacher.SelectString(0,s);
		//设置修改按钮后其它控件的状态
		m_bConfirm.EnableWindow(true);
		m_bAdd.EnableWindow(false);
		m_bEdit.EnableWindow(false);
		m_bDel.EnableWindow(false);
		m_cCourse.EnableWindow(true);
		m_cTeacher.EnableWindow(true);
	}
	
}

void CTeachDlg::OnTeachDel() 
{
	//得到CList当前所选的行号
	int row=m_list.GetSelectionMark();
	CString s,strSQL;
	//将当前行的第一列的值赋给s
	s=m_list.GetItemText(row,0);
	if(s=="")//如果s为空，则表示没有选中行
	{
		MessageBox("请选择一行！");
	}
	else
	{
		//弹出窗口询问是否删除数据
		if(MessageBox("确定要删除记录吗?","删除询问",MB_OKCANCEL|MB_ICONQUESTION)==IDOK)
		{
			//删除SQL语句
			strSQL.Format("update teach set active_status='N' where teach_id=%s",s);
			//执行SQL语句
			m_database.ExecuteSQL(strSQL);
			//更新CList数据
			RefreshList();
		}
	}
	
}

void CTeachDlg::OnTeachConfirm() 
{
	CString course,teacher,course_no,teacher_no;
	//分别获得控件中的值
	m_cTeacher.GetWindowText(teacher);
	m_cCourse.GetWindowText(course);
	CString strSQL;
	//查出该教师的编号
	strSQL.Format("select * from teacher where active_status='Y' and teacher_name='%s'",teacher);
	CRecordset m_recordSet=&m_database;
	m_recordSet.Open(CRecordset::forwardOnly,strSQL);
    m_recordSet.GetFieldValue("teacher_no",teacher_no);
	m_recordSet.Close();
	//查出该课程的课程号 
    strSQL.Format("select * from course where active_status='Y' and course_name='%s'",course);
	m_recordSet.Open(CRecordset::forwardOnly,strSQL);
    m_recordSet.GetFieldValue("course_no",course_no);;
	m_recordSet.Close();
	//如果id为0,则认为是添加记录
	if(this->id=="0")
	{
		//添加SQL语句
		strSQL.Format("insert into teach(teacher_no,course_no,active_status) values('%s','%s','Y')",teacher_no,course_no);
		//执行添加操作
		m_database.ExecuteSQL(strSQL);
	}
	else if(id!="")//否则为修改记录
	{
		//修改SQL语句
		strSQL.Format("update teach set teacher_no='%s',course_no='%s' where teach_id=%s",teacher_no,course_no,id);
		//执行修改操作
		m_database.ExecuteSQL(strSQL);
	}
	id="";
	RefreshList();
	ResetButton();

}

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