?? delmemberdlg.cpp
字號(hào):
// DelMemberDlg.cpp : implementation file
//
#include "stdafx.h"
#include "SuperMarket.h"
#include "DelMemberDlg.h"
#include "afxdb.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif
/////////////////////////////////////////////////////////////////////////////
// CDelMemberDlg dialog
CDelMemberDlg::CDelMemberDlg(CWnd* pParent /*=NULL*/)
: CDialog(CDelMemberDlg::IDD, pParent)
{
//{{AFX_DATA_INIT(CDelMemberDlg)
m_date = _T("");
m_discount = _T("");
m_hynumber = _T("");
m_hyname = _T("");
m_momey = _T("");
//}}AFX_DATA_INIT
}
void CDelMemberDlg::DoDataExchange(CDataExchange* pDX)
{
CDialog::DoDataExchange(pDX);
//{{AFX_DATA_MAP(CDelMemberDlg)
DDX_Text(pDX, IDC_Date, m_date);
DDX_Text(pDX, IDC_discount, m_discount);
DDX_Text(pDX, IDC_HYNUMBER, m_hynumber);
DDX_Text(pDX, IDC_hyname, m_hyname);
DDX_Text(pDX, IDC_momey, m_momey);
//}}AFX_DATA_MAP
}
BEGIN_MESSAGE_MAP(CDelMemberDlg, CDialog)
//{{AFX_MSG_MAP(CDelMemberDlg)
ON_BN_CLICKED(IDC_BUTTON1, OnButton1)
//}}AFX_MSG_MAP
END_MESSAGE_MAP()
/////////////////////////////////////////////////////////////////////////////
// CDelMemberDlg message handlers
void CDelMemberDlg::OnButton1()
{
// TODO: Add your control notification handler code here
UpdateData();
CDatabase dbTemp;
CString str0,str1,str2,str3,str4;
dbTemp.OpenEx("Driver={Microsoft Access Driver (*.mdb)};DBQ=超市管理數(shù)據(jù)庫(kù).mdb;");
CRecordset rs( &dbTemp);
rs.Open(AFX_DB_USE_DEFAULT_TYPE,"select * From 會(huì)員信息表 where 會(huì)員編號(hào)='"+m_hynumber+"'");
if(rs.IsEOF())
{
MessageBox("輸入的會(huì)員編號(hào)不存在,請(qǐng)重新輸入!");
}
else
{
rs.GetFieldValue((short)1,str1);
rs.GetFieldValue((short)2,str2);
rs.GetFieldValue((short)3,str3);
rs.GetFieldValue((short)4,str4);
m_hyname=str1;
m_momey=atof(str2);
m_date=str3;
m_discount=str4;
UpdateData(false);
}
}
void CDelMemberDlg::OnOK()
{
// TODO: Add extra validation here
CDatabase dbTemp;
CString strSQL;
UpdateData();
dbTemp.OpenEx("Driver={Microsoft Access Driver (*.mdb)};DBQ=超市管理數(shù)據(jù)庫(kù).mdb;");
strSQL="delete from 會(huì)員信息表 where 會(huì)員編號(hào)='"+m_hynumber+"'";
dbTemp.ExecuteSQL(strSQL);
MessageBox("刪除成功!");
m_hynumber="";
m_hyname="";
m_momey="";
m_discount="";
m_date="";
UpdateData(false);
dbTemp.Close();
}
?? 快捷鍵說(shuō)明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -