// PasBuildDlg.cpp : implementation file
//

#include "stdafx.h"
#include "VirtualTeacher.h"
#include "PasBuildDlg.h"

#include "COMDEF.H"
#include "Columns.h"
#include "Column.h"
#include "PasEditDlg.h"
#include "_recordset.h"
#include "Passages.h"

extern CUsers curUser;

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

/////////////////////////////////////////////////////////////////////////////
// CPasBuildDlg dialog


CPasBuildDlg::CPasBuildDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CPasBuildDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CPasBuildDlg)
		// NOTE: the ClassWizard will add member initialization here
	//}}AFX_DATA_INIT
}


void CPasBuildDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CPasBuildDlg)
	DDX_Control(pDX, IDC_TYPE_COMBO, m_combo);
	DDX_Control(pDX, IDC_TREE1, m_tree);
	DDX_Control(pDX, IDC_ADODC1, m_Adodc);
	DDX_Control(pDX, IDC_DATAGRID1, m_datagrid);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CPasBuildDlg, CDialog)
	//{{AFX_MSG_MAP(CPasBuildDlg)
	ON_BN_CLICKED(IDC_ADD_BUTTON, OnAddButton)
	ON_BN_CLICKED(IDC_MODI_BUTTON, OnModiButton)
	ON_BN_CLICKED(IDC_DEL_BUTTON, OnDelButton)
	ON_NOTIFY(TVN_SELCHANGED, IDC_TREE1, OnSelchangedTree1)
	ON_CBN_SELCHANGE(IDC_TYPE_COMBO, OnSelchangeTypeCombo)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CPasBuildDlg message handlers

BOOL CPasBuildDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here

	//裝入課程信息
	cou.Load_course();
	//添加根節點
	m_treeImageList.Create(16,16,FALSE,1,0);  //創建CImageList控件
	//裝入ICON資源
	HICON hIcon = ::LoadIcon(AfxGetResourceHandle(), MAKEINTRESOURCE(IDI_ICON1));
	m_treeImageList.Add(hIcon);  //將ICON資源添加到CImageList控件中
	//將CImageList控件與Tree控件相關聯	
	m_tree.SetImageList(&m_treeImageList, LVSIL_NORMAL);
	m_root = m_tree.InsertItem("課程建設");  //添加根節點
	//調用AddtoTree() 函數，將所有課程信息添加到Tree控件中	
	AddtoTree(m_root, 0);
	m_tree.Expand(m_root, TVE_EXPAND); //展開根節點
	//選中根節點
	m_tree.SelectItem(m_root);

	//設置文本內容屬性
	m_combo.SetCurSel(0);

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

void CPasBuildDlg::AddtoTree(HTREEITEM m_node, int TypeId)
{
	//使用遞歸方法將課程添加到TreeView控件中
	int i;
	HTREEITEM m_child;
	//依次訪問dep對象中的課程數組，查找滿足條件的記錄添加到Tree控件中
	for(i=0; i<cou.a_TypeID.GetSize(); i++)
	{
		//@@@@ 打開a_TypeId數組中等于TypeId的元素
		//@@@@ 表明此元素為當前根節點的子節點，因此將其添加到Tree控件中，新節點為m_child
		//@@@@ 使用SetItemData()函數將課程編號值也保存在新節點中
		//@@@@ 以新節點為根節點，再次遞歸調用AddtoTree()函數，將其子節點添加到Tree控件中
		if (TypeId == atoi(cou.a_TypeID.GetAt(i)))
		{
			m_child = m_tree.InsertItem(cou.a_CourseName.GetAt(i), m_node);
			m_tree.SetItemData(m_child, atol(cou.a_CourseID.GetAt(i)));
			AddtoTree(m_child, atoi(cou.a_CourseID.GetAt(i)));
		}
	}
}

void CPasBuildDlg::Refresh_Data()
{
	UpdateData(TRUE);
	//從Tree控件中讀取課程編號信息
	int iCouId;
	HTREEITEM node;
	node = m_tree.GetSelectedItem();
	iCouId = m_tree.GetItemData(node);
	
	//根據課程編號設置SELECT語句
	CString cCouId;
	cCouId.Format("%d", iCouId);
	CString cSource ="SELECT Pas_ID,Pas_Name AS 文本名稱, Memo AS 備注 FROM Passages WHERE Course_ID=" +cCouId;
    
	//讀取文本內容類型狀態值，并根據它生成SELECT語句的條件
	int iType = m_combo.GetCurSel();
	CString cType;
	cType.Format("%d", iType);
	if (iType > 0)
		cSource += " AND FT=" + cType;

	//刷新ADO Data控件的記錄源
	m_Adodc.SetRecordSource(cSource);
	m_Adodc.Refresh();
    
	//設置列寬度
	_variant_t vIndex;
	vIndex = long(0);
	m_datagrid.GetColumns().GetItem(vIndex).SetWidth(0);
	vIndex = long(1);
	m_datagrid.GetColumns().GetItem(vIndex).SetWidth(100);
	vIndex = long(2);
	m_datagrid.GetColumns().GetItem(vIndex).SetWidth(100);
	
}

void CPasBuildDlg::OnAddButton() 
{
	// TODO: Add your control notification handler code here
	UpdateData(TRUE);

	HTREEITEM node;  //用于保存當前節點
	node = m_tree.GetSelectedItem(); //取得當前節點值
	int iCouId;
	iCouId = m_tree.GetItemData(node);
	if (iCouId == 0)  //不能在根節點添加文本文件
	{
		MessageBox("請選擇課程");
		return;
	}

	CPasEditDlg dlg;
	//初始化變量
	dlg.PasId = 0;  //文本編號為0，表示添加
	dlg.CouId = iCouId; //課程編號
	int iFT;  //根據當前的文本內容類型狀態設置編輯對話框中的文本內容類型
	iFT = m_combo.GetCurSel();
	if (iFT == 0)
		dlg.iFT = 1;
	else
		dlg.iFT = iFT;
	
	if (dlg.DoModal() == IDOK)
		Refresh_Data();

}

void CPasBuildDlg::OnModiButton() 
{
	// TODO: Add your control notification handler code here
    UpdateData(TRUE);

	if (m_Adodc.GetRecordset().GetEof())
	{
		MessageBox("請選擇要修改的記錄!");
		return;
	}
	//讀取選擇文本的記錄
	CPassages pas;
	pas.GetData(m_datagrid.GetItem(0));
	//將文本數據讀取到編輯對話框中
	CPasEditDlg dlg;
	dlg.PasId = pas.GetPas_ID();
	dlg.PasName = pas.GetPas_Name();
	dlg.CouId = pas.GetCourse_ID();
    dlg.m_PasName = pas.GetPas_Name();
	dlg.m_Words = pas.GetWords();
	dlg.m_Memo = pas.GetMemo();
	dlg.iFT = pas.GetFT();
	
	if (dlg.DoModal() == IDOK)
		Refresh_Data();
	
}

void CPasBuildDlg::OnDelButton() 
{
	// TODO: Add your control notification handler code here
	if (m_Adodc.GetRecordset().GetEof())
	{
		MessageBox("請選擇要刪除的記錄!");
		return;
	}
	//讀取選擇的文本記錄
	if (MessageBox("是否刪除當前記錄？","請確認", MB_YESNO) == IDYES)
	{
		CPassages pas;
		pas.sql_delete(m_datagrid.GetItem(0));
		Refresh_Data();
	}	
	
	
}

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

void CPasBuildDlg::OnSelchangedTree1(NMHDR* pNMHDR, LRESULT* pResult) 
{
	NM_TREEVIEW* pNMTreeView = (NM_TREEVIEW*)pNMHDR;
	// TODO: Add your control notification handler code here
	Refresh_Data();
	
	*pResult = 0;
}


void CPasBuildDlg::OnSelchangeTypeCombo() 
{
	// TODO: Add your control notification handler code here
	Refresh_Data();
	
}