// CourseDlg.cpp : implementation file
//

#include "stdafx.h"
#include "ExMIS.h"
#include "CourseDlg.h"

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

/////////////////////////////////////////////////////////////////////////////
// CCourseDlg dialog

//狀態欄,字符串
static UINT indicators[] =
{
	IDS_STATUS_DATA,		//添加的自定義自符串
	ID_SEPARATOR,           // status line indicator
	ID_INDICATOR_CAPS,
	ID_INDICATOR_NUM,
	ID_INDICATOR_SCRL,
	IDS_STATUS_SPACE,				//加空格
};

CCourseDlg::CCourseDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CCourseDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CCourseDlg)
	m_strName = _T("");
	m_strID = _T("");
	m_strType = _T("");
	m_strCollege = _T("");
	m_strCredit = _T("");
	m_strHours = _T("");
	//}}AFX_DATA_INIT

	//為樹指定圖標
	m_TreeBootImage.Create (IDB_BITMAP_TREE,20,1,ILC_COLOR32);
}


void CCourseDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CCourseDlg)
	DDX_Control(pDX, IDC_COMBO_COLLEGE, m_ctrlCollege);
	DDX_Control(pDX, IDC_LIST, m_ctrlList);
	DDX_Control(pDX, IDC_TREE, m_ctrlTree);
	DDX_Text(pDX, IDC_EDIT_NAME, m_strName);
	DDX_Text(pDX, IDC_EDIT_ID, m_strID);
	DDX_CBString(pDX, IDC_COMBO_TYPE, m_strType);
	DDX_CBString(pDX, IDC_COMBO_COLLEGE, m_strCollege);
	DDX_Text(pDX, IDC_EDIT_CREDIT, m_strCredit);
	DDX_Text(pDX, IDC_EDIT_HOURS, m_strHours);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CCourseDlg, CDialog)
	//{{AFX_MSG_MAP(CCourseDlg)
	ON_COMMAND(ID_ITEM_ADD, OnItemAdd)
	ON_BN_CLICKED(ID_ITEM_DELETE, OnItemDelete)
	ON_BN_CLICKED(ID_ITEM_EDIT, OnItemEdit)
	ON_COMMAND(ID_ITEM_QUIT, OnItemQuit)
	ON_COMMAND(ID_ITEM_HELP, OnItemHelp)
	ON_COMMAND(ID_ITEM_REFRESH, OnItemRefresh)
	ON_BN_CLICKED(ID_ITEM_SAVE, OnItemSave)
	ON_BN_CLICKED(ID_ITEM_SEARCH, OnItemSearch)
	ON_NOTIFY(TVN_SELCHANGED, IDC_TREE, OnSelchangedTree)
	ON_NOTIFY(LVN_COLUMNCLICK, IDC_LIST, OnColumnclickList)
	ON_NOTIFY(NM_CLICK, IDC_LIST, OnClickList)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CCourseDlg message handlers

BOOL CCourseDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
		
	//添加工具欄和狀態欄
	CRect	rect;
	GetClientRect(rect);
	
	m_wndToolBar.Create(this);
	m_wndToolBar.LoadToolBar(IDR_MENU_DATA);

	m_wndStatusBar.Create(this);
	m_wndStatusBar.SetIndicators(indicators,sizeof(indicators)/sizeof(UINT));
	m_wndStatusBar.SetPaneStyle(2,SBPS_STRETCH);

	m_wndToolBar.MoveWindow(0,0,rect.right,48);
	m_wndStatusBar.MoveWindow(0,rect.bottom-20,rect.right,20);


	//初始化樹形控件,設置圖標
	m_ctrlTree.SetImageList(&m_TreeBootImage,TVSIL_NORMAL);	

	//設置列表控件的樣式
	m_ctrlList.ModifyStyle(0,LVS_REPORT|LVS_SHOWSELALWAYS|LVS_SINGLESEL);
	m_ctrlList.SetExtendedStyle(LVS_EX_FULLROWSELECT|LVS_EX_GRIDLINES|LVS_EX_HEADERDRAGDROP);

	//打開院系數據集,提趣學生表的所有信息
	m_pRS.ADOOpen();
	//調用刷新記錄
	OnItemRefresh();
	
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CCourseDlg::OnItemRefresh() 
{
	//添加課程到列表中,暫存SQL語句,供排序使用
	m_strSQL="SELECT * FROM CourseTab";
	m_pRS.ADOExcute(m_strSQL);

	//添加院系、教師到樹控件中
	AddTreeNodes();
	//添加課程到列表中
	AddListItems();

	//為院系控件添加院系列表,此處建立了一個臨時的RecordSet實例
	MyRecordSet rs;
	rs.ADOOpen(m_pRS.m_strDBType);
	rs.ADOExcute("SELECT CollegeID FROM CollegeTab");
	while(!rs.ADOEOF())
	{
		m_ctrlCollege.AddString(rs.GetFieldString(0));
		rs.MoveNext();
	}
	rs.ADOConnectionClose();	//釋放資源
}

void CCourseDlg::AddTreeNodes() 
{
	//刪除所有結點控件中的項目
	m_ctrlTree.DeleteAllItems();
	//添加根結點即學生表的信息
	hRootItem=m_ctrlTree.InsertItem("課程基本信息",0,2,TVI_ROOT,TVI_LAST);
	m_pRS.MoveFirst();		//指向第一條
	while(!m_pRS.ADOEOF())
	{
		//添加院系到根節點中
		HTREEITEM hCollege=AddDistinctNode(hRootItem,m_pRS.GetFieldString("CollegeID"));
		//添加班級到院系節點中
		HTREEITEM hClass=AddDistinctNode(hCollege,m_pRS.GetFieldString("CourseType"));		
		m_pRS.MoveNext();
	}
}

void CCourseDlg::AddListItems() 
{
	//清列表框的頭
	int nCount=0;
	CHeaderCtrl *pHeaderCtrl=m_ctrlList.GetHeaderCtrl();
	if(pHeaderCtrl!=NULL)
		nCount=pHeaderCtrl->GetItemCount();
	for(int i=0;i<nCount;i++)
		m_ctrlList.DeleteColumn(0);
	m_ctrlList.DeleteAllItems();
	
	//取出字段名顯示到列表頭中
	for(i=0;i<m_pRS.nFieldCols;i++)
	{
		m_ctrlList.InsertColumn(i,m_pRS.GetFieldName(i),LVCFMT_LEFT,110);
	}	

	//取出字段值放到列表行中
	int nItem=0;
	while(!m_pRS.ADOEOF())
	{
		m_ctrlList.InsertItem(nItem,m_pRS.GetFieldString(0));
		for(int i=1;i<m_pRS.nFieldCols;i++)
			m_ctrlList.SetItemText(nItem,i,m_pRS.GetFieldString(i));		

		m_pRS.MoveNext();
	}
}

//如果該值[strValue],在指定結點的子結點中不存在，則將此值添加到其子結點中；
HTREEITEM	CCourseDlg::AddDistinctNode(HTREEITEM hParent,CString strValue)
{
	HTREEITEM hItem=m_ctrlTree.GetChildItem(hParent);
	while(hItem)
	{
		CString strItemText = m_ctrlTree.GetItemText(hItem);
		if(strItemText == strValue)
		return hItem;	//已經存在該值的子結點，則返回
		hItem = m_ctrlTree.GetNextSiblingItem(hItem);
	}
	//遍歷了所有子結點，沒有找到該值，則添加并返回
	return m_ctrlTree.InsertItem(strValue,1,2,hParent,TVI_LAST);
}

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

	//取得當前選中的節點
	HTREEITEM hSelItem=m_ctrlTree.GetSelectedItem();
	//取得先中節點的根節點
	HTREEITEM hParentItem=m_ctrlTree.GetParentItem(hSelItem);

	//判斷選中的的是根節點,還是學院二級子節點。并取回根節點
	CString strSql,str,strCondition;	//SQL語句
	strSql="SELECT * FROM CourseTab";	//

	if(hParentItem!=NULL)
	{
		HTREEITEM hOldParent=m_ctrlTree.GetParentItem(hParentItem);
		if(hOldParent!=NULL)
		{
			//選中的是課程類型結點,添加院系條件和課程類型條件
			strCondition.Format(" Where CollegeID='%s' AND CourseType='%s'",m_ctrlTree.GetItemText(hParentItem),m_ctrlTree.GetItemText(hSelItem));
		}else{
			//選中的是院系結點,添加院系條件
			strCondition.Format(" Where CollegeID='%s'",m_ctrlTree.GetItemText(hSelItem));
		}
	
	}else{
		//選中的是根節結點，沒有過濾條件
		strCondition="";
	}

	//加上篩選條件, 
	strSql+=strCondition;
	//將SQL語句暫存, 以供排序使用；
	m_strSQL=strSql;	
	//提取數據集

	m_pRS.ADOExcute(strSql);
	AddListItems();
}

void CCourseDlg::OnClickList(NMHDR* pNMHDR, LRESULT* pResult) 
{
	*pResult = 0;

	int i=m_ctrlList.GetSelectionMark();
	m_strID=m_ctrlList.GetItemText(i,0);
	m_strName=m_ctrlList.GetItemText(i,1);
	m_strType=m_ctrlList.GetItemText(i,2);
	m_strHours=m_ctrlList.GetItemText(i,3);
	m_strCredit=m_ctrlList.GetItemText(i,4);
	m_strCollege=m_ctrlList.GetItemText(i,6);
	UpdateData(false);
}

void CCourseDlg::OnColumnclickList(NMHDR* pNMHDR, LRESULT* pResult) 
{
	NM_LISTVIEW* pNMListView = (NM_LISTVIEW*)pNMHDR;	
	*pResult = 0;

	//單擊表頭列時排序,可有兩種方法,一種是比較調整所有對應行的值排序
	//這里使用了獲取列名并重新填充的方法
	//獲取表頭列中的文字,由于沒有直接的函數,所以需要分兩步
	//取得選中的列索引:Info.iSubItem,行索引為:Info.iItem
	CPoint   pt;   
	::GetCursorPos(&pt);
	m_ctrlList.ScreenToClient(&pt);   
	LVHITTESTINFO Info;   
	Info.pt = pt;   
	Info.flags = LVHT_ABOVE;
	m_ctrlList.SubItemHitTest(&Info);	
	//取得列頭中的值即:col.pszText
	LVCOLUMN   col;	
	col.mask=LVCF_TEXT;
	col.cchTextMax =20;
	char buff[20];
	col.pszText=buff;
	m_ctrlList.GetColumn(Info.iSubItem,&col);
	
	//耶得值之后,為SQL語句增加排序條件,并重新填充
	CString strSQL=m_strSQL+" ORDER BY "+col.pszText;
	m_pRS.ADOExcute(strSQL);
	AddListItems();
}

void CCourseDlg::OnItemAdd() 
{
	//清空,準備錄入
	m_strID="";
	m_strName="";
	m_strType="";
	m_strHours="";
	m_strCredit="";
	m_strCollege="";
	UpdateData(false);
}

void CCourseDlg::OnItemSearch() 
{
	UpdateData(true);
	//查找指定學號的項,并放入列表框中
	m_pRS.ADOExcute("SELECT * FROM CourseTab WHERE CourseID='"+m_strID+"'");
	AddListItems();
	UpdateData(false);
}

void CCourseDlg::OnItemSave() 
{
	UpdateData(true);
	// 添加記錄
	CString sql;
	sql.Format("INSERT INTO CourseTab(CourseID,CourseName,CourseType,CourseHours,CourseCredit,CollegeID) Values('%s','%s','%s','%s','%s','%s')",
		m_strID,m_strName,m_strType,m_strHours,m_strCredit,m_strCollege);

	if(m_pRS.ADOExcuteNoQuery(sql)==1){	
		AfxMessageBox("增加記錄成功!");
		//增加完記錄后,馬上查找顯示;
		OnItemSearch();
	}else{
		AfxMessageBox("增加記錄失敗,可能是重復的編號!");
	}
}

void CCourseDlg::OnItemEdit() 
{
	// 保存編輯
	UpdateData(true);
	CString sql;
	sql.Format("UPDATE CourseTab SET CourseName='%s',CourseType='%s',CourseHours='%s',CourseCredit='%s',CollegeID='%s' WHERE CourseID='%s'",
		m_strName,m_strType,m_strHours,m_strCredit,m_strCollege,m_strID);

	if(m_pRS.ADOExcuteNoQuery(sql)==1){	
		AfxMessageBox("編輯記錄成功!");
		//編輯完記錄后,馬上查找顯示;
		OnItemSearch();
	}else{
		AfxMessageBox("編輯記錄失敗!");
	}
}

void CCourseDlg::OnItemDelete() 
{
	if(AfxMessageBox("您確認要刪除嗎?",MB_OKCANCEL)==IDOK)
	{
		UpdateData(true);
		CString sql;
		sql.Format("DELETE * FROM CourseTab WHERE CourseID='%s'",m_strID);

		if(m_pRS.ADOExcuteNoQuery(sql)==1){	
			AfxMessageBox("刪除記錄成功!");
			//刪除列表項中造中的記錄			
			m_ctrlList.DeleteItem(m_ctrlList.GetSelectionMark());
		}else{
			AfxMessageBox("刪除記錄失敗!");
		}
	}
}

void CCourseDlg::OnItemQuit() 
{
	// TODO: Add your command handler code here
	CDialog::OnOK();
}

void CCourseDlg::OnItemHelp() 
{
	// TODO: Add your command handler code here
	AfxMessageBox("5");
}