// 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();
}