?? addmemberdlg.cpp
字號:
// AddMemberDlg.cpp : implementation file
//
#include "stdafx.h"
#include "SuperMarket.h"
#include "AddMemberDlg.h"
#include "afxdb.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif
/////////////////////////////////////////////////////////////////////////////
// CAddMemberDlg dialog
CAddMemberDlg::CAddMemberDlg(CWnd* pParent /*=NULL*/)
: CDialog(CAddMemberDlg::IDD, pParent)
{
//{{AFX_DATA_INIT(CAddMemberDlg)
m_date = 0;
m_discount = _T("");
m_hyname = _T("");
m_hynumber = _T("");
m_memey = 0.0f;
//}}AFX_DATA_INIT
}
void CAddMemberDlg::DoDataExchange(CDataExchange* pDX)
{
CDialog::DoDataExchange(pDX);
//{{AFX_DATA_MAP(CAddMemberDlg)
DDX_DateTimeCtrl(pDX, IDC_DATETIMEPICKER, m_date);
DDX_Text(pDX, IDC_discount, m_discount);
DDX_Text(pDX, IDC_hyname, m_hyname);
DDX_Text(pDX, IDC_HYNUMBER, m_hynumber);
DDX_Text(pDX, IDC_memey, m_memey);
//}}AFX_DATA_MAP
}
BEGIN_MESSAGE_MAP(CAddMemberDlg, CDialog)
//{{AFX_MSG_MAP(CAddMemberDlg)
//}}AFX_MSG_MAP
END_MESSAGE_MAP()
/////////////////////////////////////////////////////////////////////////////
// CAddMemberDlg message handlers
void CAddMemberDlg::OnOK()
{
// TODO: Add extra validation here
CString str0,str1,str2;
CString strSQL;
CDatabase dbTemp;
UpdateData();
if(m_hynumber=="")
{
MessageBox("請輸入會員編號!");
}
else
if(m_hyname=="")
{
MessageBox("請輸入會員名稱!");
}
else
if(m_discount=="")
{
MessageBox("請輸入優惠折扣!");
}
else
{
dbTemp.OpenEx("Driver={Microsoft Access Driver (*.mdb)};DBQ=超市管理數據庫.mdb;");
CRecordset rs( &dbTemp);
rs.Open(AFX_DB_USE_DEFAULT_TYPE,"select * From 會員信息表 where 會員編號='"+m_hynumber+"'");
if(!rs.IsEOF()) //如果是舊產品,更新庫存
{
MessageBox("會員編號已存在,請輸入另外一個會員編號!");
m_date = 0;
m_discount = _T("");
m_hyname = _T("");
m_hynumber = _T("");
m_memey = 0.0f;
UpdateData(false);
}
else //如果是新產品,添加商品信息
{
str0.Format("%d-%d-%d",m_date.GetYear(),m_date.GetMonth(),m_date.GetDay());
str1.Format("%f",m_memey);
strSQL="insert into 會員信息表 values('"+m_hynumber+"','"+m_hyname+"','"+str1+"','"+str0+"','"+m_discount+"')";
dbTemp.ExecuteSQL(strSQL);
MessageBox("添加成功!"); //初始化窗口
m_date = 0;
m_hynumber = _T("");
UpdateData(false);
}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -