// Depart.cpp : implementation file
//

#include "stdafx.h"
#include "SQL.h"
#include "Depart.h"
#include "DepartSet.h"

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

/////////////////////////////////////////////////////////////////////////////
// CDepart dialog


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


void CDepart::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CDepart)
	DDX_Control(pDX, IDC_LIST1, m_departctrl);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CDepart, CDialog)
	//{{AFX_MSG_MAP(CDepart)
	ON_NOTIFY(NM_CLICK, IDC_LIST1, OnDepartlist)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CDepart message handlers

BOOL CDepart::OnInitDialog()
{
	CDialog::OnInitDialog();
    
	m_departctrl.InsertColumn(0,"職工號(hào)",LVCFMT_LEFT,100);
	m_departctrl.InsertColumn(1,"姓名",LVCFMT_LEFT,100);
	m_departctrl.InsertColumn(2,"性別",LVCFMT_LEFT,100);
	m_departctrl.InsertColumn(3,"年齡",LVCFMT_LEFT,100);
	m_departctrl.InsertColumn(4,"合同號(hào)",LVCFMT_LEFT,100);
	m_departctrl.InsertColumn(5,"部門(mén)",LVCFMT_LEFT,100);
	m_departctrl.InsertColumn(6,"職務(wù)",LVCFMT_LEFT,100);
	m_departctrl.InsertColumn(7,"備注",LVCFMT_LEFT,100);
    
   CString st;
   st.Format("select * from Employee where Eno = '%s' ",Id);
   CDepartSet m_departSet(&m_db);
   if(!m_departSet.Open(CRecordset::dynaset,st))
   {
	   AfxMessageBox("數(shù)據(jù)庫(kù)打開(kāi)失敗!");
	   return false;
   }
   CString department;
   m_departSet.GetFieldValue((short)5,department);
   m_departSet.Close();


   CDepartSet  m_DepartSet(&m_db);
   CString str = "select * from Employee";
   

   if(!m_DepartSet.Open(CRecordset::dynaset,str))
   {
	   AfxMessageBox("數(shù)據(jù)庫(kù)打開(kāi)失敗!");
	   return false;
   }
   m_DepartSet.MoveFirst();
   int nItem;
   while(!m_DepartSet.IsEOF())
   {
	   CString eno,ename,esex,eage,econtract,esector,eduty,eother;
	   m_DepartSet.GetFieldValue((short)5,esector);
	   if(esector == department)
	   {
          m_DepartSet.GetFieldValue((short)0,eno);
	      m_DepartSet.GetFieldValue((short)1,ename);
	      m_DepartSet.GetFieldValue((short)2,esex);
	      m_DepartSet.GetFieldValue((short)3,eage);
	      m_DepartSet.GetFieldValue((short)4,econtract);
	      m_DepartSet.GetFieldValue((short)6,eduty);
	      m_DepartSet.GetFieldValue((short)7,eother);
          
		  nItem = m_departctrl.InsertItem(0,eno);
		  m_departctrl.SetItemText(nItem,1,ename);
		  m_departctrl.SetItemText(nItem,2,esex);
		  m_departctrl.SetItemText(nItem,3,eage);
		  m_departctrl.SetItemText(nItem,4,econtract);
		  m_departctrl.SetItemText(nItem,5,esector);
		  m_departctrl.SetItemText(nItem,6,eduty);
		  m_departctrl.SetItemText(nItem,7,eother);
		  
	   }
	   m_DepartSet.MoveNext();
	}
   return true;

}


void CDepart::OnDepartlist(NMHDR* pNMHDR, LRESULT* pResult) 
{
	// TODO: Add your control notification handler code here
	
	*pResult = 0;
}