// BossNoteCtrl.cpp : implementation file
//

#include "stdafx.h"
#include "SQL.h"
#include "BossNoteCtrl.h"
#include "Boss.h"
#include "Note.h"

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

/////////////////////////////////////////////////////////////////////////////
// CBossNoteCtrl dialog


CBossNoteCtrl::CBossNoteCtrl(CWnd* pParent /*=NULL*/)
	: CDialog(CBossNoteCtrl::IDD, pParent)
{
	//{{AFX_DATA_INIT(CBossNoteCtrl)
	m_ndaty = _T("");
	m_nmanager = _T("");
	m_nname = _T("");
	m_nplace = _T("");
	m_pno = _T("");
	//}}AFX_DATA_INIT
}


void CBossNoteCtrl::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CBossNoteCtrl)
// 	DDX_Control(pDX, IDCANCEL, m_bossnotectrl);
	DDX_Text(pDX, IDC_NDATY, m_ndaty);
	DDX_Text(pDX, IDC_NMANAGER, m_nmanager);
	DDX_Text(pDX, IDC_NNAME, m_nname);
	DDX_Text(pDX, IDC_NPLACE, m_nplace);
	DDX_Text(pDX, IDC_PNO, m_pno);// 
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CBossNoteCtrl, CDialog)
	//{{AFX_MSG_MAP(CBossNoteCtrl)
	ON_BN_CLICKED(IDC_BUTTON1, OnADD)
	ON_BN_CLICKED(IDC_BUTTON4, OnDelete)
	ON_BN_CLICKED(IDC_BUTTON5, OnChan)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CBossNoteCtrl message handlers

void CBossNoteCtrl::OnADD() 
{
	// TODO: Add your control notification handler code here
	UpdateData(true);
    CNote m_bossnotectr(&m_db);
	CString str;
	str = "select * from Note2";
	if (!m_bossnotectr.Open(CRecordset::dynaset,str)) {
		AfxMessageBox("數(shù)據(jù)庫打開失敗！");
		return;
	}
	m_bossnotectr.AddNew();
	m_bossnotectr.m_Pno = m_pno;
	m_bossnotectr.m_Ndaty = m_ndaty;
	m_bossnotectr.m_Nmanager = m_nmanager;
	m_bossnotectr.m_Nname = m_nname;
	m_bossnotectr.m_Nplace = m_nplace;

	 m_bossnotectr.Update();
     AfxMessageBox("修改成功！請(qǐng)退出！");
}

void CBossNoteCtrl::OnDelete() 
{
	// TODO: Add your control notification handler code here
    UpdateData(true);
	CNote m_bossnotectr(&m_db);
	CString str;
	str.Format("select * from Note2 where Pno = '%s'",m_pno);
	if (! m_bossnotectr.Open(CRecordset::dynaset,str)) {
		AfxMessageBox("");
		return;
	}
	 m_bossnotectr.Delete();

	 m_bossnotectr.Close();
	 AfxMessageBox("修改成功！請(qǐng)退出！");
	
}

void CBossNoteCtrl::OnChan() 
{
	// TODO: Add your control notification handler code here
	UpdateData(true);
	CNote m_bossnotectr(&m_db);
	CString str;
	str.Format("select * from Note2 where Pno = '%s'",m_pno);
	if (!m_bossnotectr.Open(CRecordset::dynaset,str)) {
		AfxMessageBox("數(shù)據(jù)庫打開失敗！");
		return;
	}
	m_bossnotectr.Edit();
    m_bossnotectr.m_Pno = m_pno;
	if (!m_ndaty.IsEmpty()) {
		m_bossnotectr.m_Ndaty = m_ndaty;
	}
	if (!m_nmanager.IsEmpty()) {
		m_bossnotectr.m_Nmanager = m_nmanager;
	}
	if (!m_nname.IsEmpty()) {
		m_bossnotectr.m_Nname = m_nname;
	}
	if (!m_nplace.IsEmpty()) {
		m_bossnotectr.m_Nplace = m_nplace; 
	}
	 m_bossnotectr.Update();
	 AfxMessageBox("修改成功！請(qǐng)退出！");
}