📄 clientmodify.cpp
字号:
// ClientModify.cpp : implementation file
//
#include "stdafx.h"
#include "SuperMarket.h"
#include "ClientModify.h"
#include "_recordset.h"
#include "COMDEF.H"
#include "Columns.h"
#include "Column.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif
/////////////////////////////////////////////////////////////////////////////
// CClientModify dialog
CClientModify::CClientModify(CWnd* pParent /*=NULL*/)
: CDialog(CClientModify::IDD, pParent)
{
//{{AFX_DATA_INIT(CClientModify)
m_intID = 0;
m_intquantity = 0;
m_Menoy = 0.0f;
//}}AFX_DATA_INIT
}
void CClientModify::DoDataExchange(CDataExchange* pDX)
{
CDialog::DoDataExchange(pDX);
//{{AFX_DATA_MAP(CClientModify)
DDX_Control(pDX, IDC_DATACOMBO1, m_datacombo1);
DDX_Text(pDX, IDC_EDIT1, m_intID);
DDX_Text(pDX, IDC_EDIT2, m_intquantity);
DDX_Control(pDX, IDC_ADODC2, m_adodc);
DDX_Text(pDX, IDC_EDIT3, m_Menoy);
//}}AFX_DATA_MAP
}
BEGIN_MESSAGE_MAP(CClientModify, CDialog)
//{{AFX_MSG_MAP(CClientModify)
//}}AFX_MSG_MAP
END_MESSAGE_MAP()
/////////////////////////////////////////////////////////////////////////////
// CClientModify message handlers
void CClientModify::OnOK()
{
// TODO: Add extra validation here
bool flag=true;
UpdateData(true);
while(flag)
{
if(m_intID==0)
{
AfxMessageBox("请根据表输入你要购买的商品号");
return;
}
UpdateData(true);
m_pRecordset.CreateInstance(__uuidof(Recordset));
_variant_t var;
try
{
m_pRecordset->Open("SELECT*FROM Shopping",
theApp.m_pConnection.GetInterfacePtr(),
adOpenDynamic,
adLockOptimistic,
adCmdText);
// MessageBox("BBBBBBBBBBBBBBBBBBBBBB");
}
catch(_com_error*e)
{
AfxMessageBox(e->ErrorMessage());
}
CString proname = m_datacombo1.GetText();
try
{
m_pRecordset->AddNew();
m_pRecordset->PutCollect("Cid",_variant_t(strCid));
m_pRecordset->PutCollect("ProName",_variant_t(proname));
var.iVal=m_intquantity;
m_pRecordset->PutCollect("ProQu",var.iVal);
m_pRecordset->PutCollect("Menoy",_variant_t(m_Menoy));
m_pRecordset->PutCollect("Data",_variant_t(COleDateTime::GetCurrentTime() ));
m_pRecordset->Update();
m_pRecordset->Close();
//**********************************
if(MessageBox("你已经购买成功,是否继续购买?\n 是请按 ‘是’,\n 否请按‘否’!",NULL,
MB_YESNO|MB_ICONQUESTION)==IDYES)
{
flag=true;
m_intID=0;
m_intquantity=0;
m_Menoy=0;
UpdateData(false);
}
else
{
flag=false;
}
//*******************************
}
catch(_com_error*e)
{
AfxMessageBox(e->ErrorMessage());
}
}
CDialog::OnOK();
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -