// CollegeDlg.cpp : implementation file
//

#include "stdafx.h"
#include "ExMIS.h"
#include "CollegeDlg.h"

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

/////////////////////////////////////////////////////////////////////////////
// CCollegeDlg dialog


CCollegeDlg::CCollegeDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CCollegeDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CCollegeDlg)
	m_strMemo = _T("");
	m_strID = _T("");
	//}}AFX_DATA_INIT
}


void CCollegeDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CCollegeDlg)
	DDX_Control(pDX, IDC_LIST, m_ctrlList);
	DDX_Text(pDX, IDC_EDIT_MEMO, m_strMemo);
	DDX_Text(pDX, IDC_EDIT_ID, m_strID);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CCollegeDlg, CDialog)
	//{{AFX_MSG_MAP(CCollegeDlg)
	ON_NOTIFY(NM_CLICK, IDC_LIST, OnClickList)
	ON_BN_CLICKED(IDC_BUTTON_ADD, OnButtonAdd)
	ON_BN_CLICKED(IDC_BUTTON_DEL, OnButtonDel)
	ON_BN_CLICKED(IDC_BUTTON_EDIT, OnButtonEdit)
	ON_BN_CLICKED(IDC_BUTTON_CLEAR, OnButtonClear)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CCollegeDlg message handlers

BOOL CCollegeDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();

	//添加的代碼
	m_ctrlList.InsertColumn(0,"院系名");
	m_ctrlList.SetExtendedStyle(LVS_EX_FULLROWSELECT|LVS_EX_GRIDLINES);
	m_ctrlList.SetColumnWidth(0,160);

	//打開ADO的連接
	m_pRS.ADOOpen();

	//在列表中顯示院系;
	ShowListItems();
	
	return TRUE;
}

void CCollegeDlg::ShowListItems()
{
	m_ctrlList.DeleteAllItems();
	m_pRS.ADOExcute("SELECT CollegeID FROM CollegeTab");
	int i=0;
	while(!m_pRS.ADOEOF()){	
		m_ctrlList.InsertItem(i++,m_pRS.GetFieldString(0));
		m_pRS.MoveNext();
	}
	m_ctrlList.SetRedraw(TRUE);
}

void CCollegeDlg::OnClickList(NMHDR* pNMHDR, LRESULT* pResult) 
{	
	*pResult = 0;	
	//添加的代碼:從數據庫中獲取選擇用戶名的資料	
	CString strSQL;
	int i = m_ctrlList.GetSelectionMark();
	CString str=m_ctrlList.GetItemText(i,0);
	strSQL.Format("SELECT * FROM CollegeTab WHERE CollegeID='%s'",str);
	m_pRS.ADOExcute(strSQL);
	if(m_pRS.nFieldRows!=1)
	{
		AfxMessageBox("數據庫查找錯誤!");
		return ;
	}
	m_strID=m_pRS.GetFieldString("CollegeID");
	m_strMemo=m_pRS.GetFieldString("CollegeMemo");
	UpdateData(false);
}

void CCollegeDlg::OnButtonClear() 
{
	// 清空
	m_strID="";
	m_strMemo="";
	UpdateData(false);	
}

void CCollegeDlg::OnButtonAdd() 
{
	// 添加
	UpdateData(true);
	CString sql;
	sql.Format("INSERT INTO CollegeTab(CollegeID,CollegeMemo) Values('%s','%s')",m_strID,m_strMemo);

	if(m_pRS.ADOExcuteNoQuery(sql)==1){	
		AfxMessageBox("增加記錄成功!");
		//增加完記錄后,馬上刷新顯示;
		ShowListItems();
	}else{
		AfxMessageBox("增加記錄失敗,可能是重復的院系名,可選擇保存編輯!");
	}
}

void CCollegeDlg::OnButtonEdit() 
{
	// 編輯
	UpdateData(true);
	CString sql;
	sql.Format("UPDATE CollegeTab SET CollegeID='%s',CollegeMemo='%s' WHERE CollegeID='%s'",m_strID,m_strMemo,m_strID);

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

void CCollegeDlg::OnButtonDel() 
{
	// 刪除,此操作不能恢復,一般都需要確認一下
	if(AfxMessageBox("您確認要刪除嗎?",MB_OKCANCEL)==IDOK)
	{
		UpdateData(true);
		CString sql;
		sql.Format("DELETE * FROM CollegeTab WHERE CollegeID='%s'",m_strID);

		if(m_pRS.ADOExcuteNoQuery(sql)==1){	
			AfxMessageBox("刪除記錄成功!");
			//刷新顯示;
			ShowListItems();
		}else{
			AfxMessageBox("刪除記錄失敗!");
		}
	}
}