// TeacherDlg.cpp : implementation file
//

#include "stdafx.h"
#include "StudentScore.h"
#include "TeacherDlg.h"
#include "TeacherSet.h"

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

/////////////////////////////////////////////////////////////////////////////
// CTeacherDlg dialog


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


void CTeacherDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CTeacherDlg)
	DDX_Control(pDX, IDC_TEACHER_NO, m_strNo);
	DDX_Control(pDX, IDC_TEACHER_AGE, m_strAge);
	DDX_Control(pDX, IDC_TEACHER_NAME, m_strName);
	DDX_Control(pDX, IDC_TEACHER_LEVEL, m_strLevel);
	DDX_Control(pDX, ID_TEACHER_CONFIRM, m_bConfirm);
	DDX_Control(pDX, IDC_LIST_TEACHER, m_list);
	DDX_Control(pDX, ID_TEACHER_EDIT, m_bEdit);
	DDX_Control(pDX, ID_TEACHER_DEL, m_bDel);
	DDX_Control(pDX, ID_TEACHER_ADD, m_bAdd);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CTeacherDlg, CDialog)
	//{{AFX_MSG_MAP(CTeacherDlg)
	ON_NOTIFY(NM_CLICK, IDC_LIST_TEACHER, OnClickListTeacher)
	ON_BN_CLICKED(ID_TEACHER_ADD, OnTeacherAdd)
	ON_BN_CLICKED(ID_TEACHER_EDIT, OnTeacherEdit)
	ON_BN_CLICKED(ID_TEACHER_DEL, OnTeacherDel)
	ON_BN_CLICKED(ID_TEACHER_CONFIRM, OnTeacherConfirm)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CTeacherDlg message handlers

BOOL CTeacherDlg::OnInitDialog()
{
	CDialog::OnInitDialog();
	//初始化里CList 控件的和header
    m_list.InsertColumn(0,"記錄號");
	m_list.InsertColumn(1,"編號");
    m_list.InsertColumn(2,"姓名");
    m_list.InsertColumn(3,"性別");
	m_list.InsertColumn(4,"年齡");
    m_list.InsertColumn(5,"職稱");
	//設置header的寬度
    RECT rectList;
	m_list.GetWindowRect(&rectList);
	int wid=rectList.right-rectList.left-4;
	for(int i=0;i<6;i++)
		m_list.SetColumnWidth(i,wid/6);
    m_list.SetExtendedStyle(LVS_EX_FULLROWSELECT);
	//調用refreshList()初始化CList中的數據
	RefreshList();
	//為職稱的下拉列表添加item
	m_strLevel.AddString("教授");
	m_strLevel.AddString("副教授");
	m_strLevel.AddString("講師");
	m_strLevel.AddString("助教");
	//設置第一個item為選中狀態
	m_strLevel.SelectString(0,"教授");
	//為年齡的下拉列表添加item
	for(int j=1;j<100;j++)
	{
		CString s;
		s.Format("%d",j);
		m_strAge.AddString(s);
	}
	//設置第一個item為選中狀態
	m_strLevel.SelectString(0,"1");
	//初始化單選按鈕
	femaleRadio=(CButton*)this->GetDlgItem(IDC_RADIO_TEACHER_FEMALE);
    maleRadio=(CButton*)this->GetDlgItem(IDC_RADIO_TEACHER_MALE);
    //調用ResetButton()方法，使按鈕處于初始狀態
	ResetButton();
	return TRUE;

}

void CTeacherDlg::RefreshList()
{
	//刪除CList的所有內容
	m_list.DeleteAllItems();
	//打開記錄集
    m_teacherSet.Open();
	//設置查詢條件
    m_teacherSet.m_strFilter="active_status='Y'";
	//執行查詢
    m_teacherSet.Requery();
	//將記錄集顯示到 CList中
	for(int i=0;i<m_teacherSet.GetRecordCount();i++){
		CString temp;
        m_teacherSet.GetFieldValue("teacher_id",temp);
		m_list.InsertItem(i,temp);
		m_list.SetItemText(i,1,m_teacherSet.m_teacher_no);
		m_list.SetItemText(i,2,m_teacherSet.m_teacher_name);
		m_list.SetItemText(i,3,m_teacherSet.m_teacher_sex);
		m_teacherSet.GetFieldValue("teacher_age",temp);
		m_list.SetItemText(i,4,temp);
		m_list.SetItemText(i,5,m_teacherSet.m_teacher_level);
        m_teacherSet.MoveNext();
	}
	//關閉數據庫
	m_teacherSet.Close();

}

void CTeacherDlg::ResetButton()
{
	//設置不可用
	m_strNo.EnableWindow(false);
    m_strName.EnableWindow(false);
	m_strLevel.EnableWindow(false);
	m_strAge.EnableWindow(false);
	femaleRadio->EnableWindow(false);
	maleRadio->EnableWindow(false);
	//設置確定按鈕不可用
	m_bConfirm.EnableWindow(false);
	//設置添加、刪除、編輯按鈕可用狀態
	m_bAdd.EnableWindow(true);
	m_bDel.EnableWindow(true);
	m_bEdit.EnableWindow(true);

}

void CTeacherDlg::OnClickListTeacher(NMHDR* pNMHDR, LRESULT* pResult) 
{
	//當選中CList中某一行時，將CList中的數據也顯示到編輯框中
	//獲得所選行的行號
	int row=m_list.GetSelectionMark();
	CString s;
	//將第2列的值賦給臨時字符串s中
	s=m_list.GetItemText(row,1);
	//相應的編輯框顯示該值
	m_strNo.SetWindowText(s);
    s=m_list.GetItemText(row,2);
	m_strName.SetWindowText(s);
    s=m_list.GetItemText(row,3);
    //設置單選按鈕選中狀態
	if(s=="女")
	{
		femaleRadio->SetCheck(true);
		maleRadio->SetCheck(false);
	}
    else
	{
		femaleRadio->SetCheck(false);
		maleRadio->SetCheck(true);
	}
    //設置年齡的下拉列表值
	s=m_list.GetItemText(row,4);
    int i=m_strAge.FindString(0,s);
    m_strAge.SelectString(i,s);
	s=m_list.GetItemText(row,5);
    i=m_strLevel.FindString(0,s);
    m_strLevel.SelectString(i,s);
	*pResult = 0;
}

void CTeacherDlg::OnTeacherAdd() 
{
	//設置輸入框為可編輯狀態并清空輸入框中的值
	m_strNo.EnableWindow(true);
	m_strNo.SetWindowText("");
	m_strName.EnableWindow(true);
    m_strName.SetWindowText("");
	m_strAge.EnableWindow(true);
	m_strAge.SelectString(0,"20");
	m_strLevel.EnableWindow(true);
	m_strLevel.SelectString(0,"教授");
	femaleRadio->EnableWindow(true);
	maleRadio->EnableWindow(true);
	//打開記錄集
    m_teacherSet.Open();
	//添加新記錄
	m_teacherSet.AddNew();
	//設置點擊確定按鈕后，其他按鈕的狀態
	m_bConfirm.EnableWindow(true);
    m_bAdd.EnableWindow(false);
	m_bEdit.EnableWindow(false);
	m_bDel.EnableWindow(false);
	
}

void CTeacherDlg::OnTeacherEdit() 
{
	//得到CList當前所選的行號
	int row=m_list.GetSelectionMark();
	CString s,strSQL;
	//將當前行的第一列的值賦給s
	s=m_list.GetItemText(row,0);
	if(s=="")//如果s為空，則表示沒有選中行
	{
		MessageBox("請選擇一行！");
	}
	else//如果有選中一行
	{
		//定義查詢條件，相當于where
		strSQL.Format("teacher_id=%s",s);
		//打開記錄集
		m_teacherSet.Open();
		//設置查詢條件
		m_teacherSet.m_strFilter=strSQL;
		//執行查詢
		m_teacherSet.Requery();
		//游標指定到該行所在的記錄上，執行修改
		m_teacherSet.Edit();
		//設置點擊修改按鈕后其他按鈕的狀態
		m_bConfirm.EnableWindow(true);
		m_bAdd.EnableWindow(false);
		m_bEdit.EnableWindow(false);
		m_bDel.EnableWindow(false);
		m_strName.EnableWindow(true);
		femaleRadio->EnableWindow(true);
		maleRadio->EnableWindow(true);
		m_strNo.EnableWindow(true);
		m_strLevel.EnableWindow(true);
		m_strAge.EnableWindow(true);
	}
	
}

void CTeacherDlg::OnTeacherDel() 
{
	//得到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)
		{
			//查詢所選行所在的記錄
			strSQL.Format("teacher_id=%s",s);
			m_teacherSet.Open();
			m_teacherSet.m_strFilter=strSQL;
			m_teacherSet.Requery();
			m_teacherSet.Edit();
			//設置active_status="N";
			m_teacherSet.m_active_status="N";
			//更新數據庫
			m_teacherSet.Update();
			//關閉數據庫
			m_teacherSet.Close();
			//更新CList數據
			RefreshList();
		}
	}
	
}

void CTeacherDlg::OnTeacherConfirm() 
{
	CString no,name,level,strSex;
	//得到輸入編輯框的值
	m_strNo.GetWindowText(no);
	m_strName.GetWindowText(name);
	//將CString類型轉化為int型
	int age;
	CString s;
    m_strAge.GetWindowText(s);
	age=atoi(s);
	//取得單選按紐的狀態
	int sex=this->GetCheckedRadioButton(IDC_RADIO_TEACHER_FEMALE,IDC_RADIO_TEACHER_MALE);
	if(sex==IDC_RADIO_TEACHER_FEMALE)
		strSex="女";
	else
		strSex="男";
	m_strLevel.GetWindowText(level);
    //
	if(name=="")//如果教師姓名為空
	{
		MessageBox("請輸入教師姓名");
	}
	else
	{
		//設置記錄添加或編輯后的值
        m_teacherSet.m_teacher_no=no;
		m_teacherSet.m_teacher_name=name;
		m_teacherSet.m_teacher_sex=strSex;
		m_teacherSet.m_teacher_age=age;
		m_teacherSet.m_teacher_level=level;
		m_teacherSet.m_active_status="Y";
		//更新記錄集
		m_teacherSet.Update();
		//關閉記錄集
		m_teacherSet.Close();
		//更新列表數據
		RefreshList();
		//按鈕恢復初始狀態
		ResetButton();
	}
	
}

void CTeacherDlg::OnCancel() 
{
	if(m_teacherSet.IsOpen())//如果記錄集打開，則關閉記錄集
		m_teacherSet.Close();
	ResetButton();
	CDialog::OnCancel();
}