?? bossnotectrl.cpp
字號(hào):
// 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)退出!");
}
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -