// XibieManage.cpp : implementation file
//

#include "stdafx.h"
#include "cj.h"
#include "XibieManage.h"

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

/////////////////////////////////////////////////////////////////////////////
// CXibieManage dialog


CXibieManage::CXibieManage(CWnd* pParent /*=NULL*/)
	: CDialog(CXibieManage::IDD, pParent)
{
	//{{AFX_DATA_INIT(CXibieManage)
	m_xibiename = _T("");
	m_sXibieID = _T("");
	//}}AFX_DATA_INIT
}


void CXibieManage::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CXibieManage)
	DDX_Control(pDX, IDC_cob_XibieID, m_xibieID);
	DDX_Text(pDX, IDC_EDIT_XibieName, m_xibiename);
	DDX_CBString(pDX, IDC_cob_XibieID, m_sXibieID);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CXibieManage, CDialog)
	//{{AFX_MSG_MAP(CXibieManage)
	ON_CBN_SELCHANGE(IDC_cob_XibieID, OnSelchangecobXibieID)
	ON_BN_CLICKED(IDC_Delete, OnDelete)
	ON_BN_CLICKED(IDC_Find, OnFind)
	ON_BN_CLICKED(IDC_Modif, OnModif)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CXibieManage message handlers

BOOL CXibieManage::OnInitDialog() 
{
	CDialog::OnInitDialog();
	if(!m_database.Open(_T("student")))  return false;
	CRecordset rs(&m_database);
	CString str;
    rs.Open(CRecordset::forwardOnly,"select 系別ID from 系別");
	 while(!rs.IsEOF())
	 {
		 rs.GetFieldValue("系別ID",str);
		 m_xibieID.AddString(str);
		 rs.MoveNext();
	 }
	 rs.Close();

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

void CXibieManage::OnSelchangecobXibieID() 
{
	CRecordset rs(&m_database);
	 m_xibieID.GetLBText(m_xibieID.GetCurSel(),strXibieID);
	 rs.Open(CRecordset::forwardOnly,"select 系別名稱 from 系別 where 系別ID='"+strXibieID+"'");
	 if(!rs.IsEOF())
	 {
		 rs.GetFieldValue("系別名稱",strname);
		 m_xibiename=strname;
		 UpdateData(FALSE);
	 }
	 rs.Close();
	
}

void CXibieManage::OnDelete() 
{
	// TODO: Add your control notification handler code here
	
}

void CXibieManage::OnFind() 
{
	// TODO: Add your control notification handler code here
	
}

void CXibieManage::OnModif() 
{
	// TODO: Add your control notification handler code here
	
}

void CXibieManage::OnOK() 
{
	CRecordset rs(&m_database);
	UpdateData();
	if(m_sXibieID.IsEmpty()||m_xibiename.IsEmpty())
	{
		MessageBox("操作有誤！您不能添加空信息！","系統(tǒng)提示：",MB_OK|MB_ICONASTERISK);
	}
	else
	{
		rs.Open(CRecordset::forwardOnly,
			"select * from 系別 where 系別ID='"+m_sXibieID+"' or 系別名稱='"+m_xibiename+"'");
			icount=rs.GetRecordCount();
		rs.Close();
		if(icount!=0)
		{
			MessageBox("操作有誤！已經(jīng)存在重復(fù)信息！","系統(tǒng)提示：",MB_OK|MB_ICONASTERISK);
		}
		else
		{
			SQL="insert into 系別 (系別ID,系別名稱) \
                values('"+m_sXibieID+"','"+m_xibiename+"')";
			    m_database.ExecuteSQL(SQL);
				MessageBox("完成操作！","系統(tǒng)提示：",MB_OK|MB_ICONASTERISK);
                UpData();
		}
	
}
}

void CXibieManage::UpData()
{
   m_xibieID.ResetContent();
   CRecordset rs(&m_database);
	CString str;
    rs.Open(CRecordset::forwardOnly,"select 系別ID from 系別");
	 while(!rs.IsEOF())
	 {
		 rs.GetFieldValue("系別ID",str);
		 m_xibieID.AddString(str);
		 rs.MoveNext();
	 }
	 rs.Close();
	 m_xibiename=_T("");
	 m_sXibieID=_T("");
	 UpdateData(FALSE);
	
}