bookmod.cpp

本源码为图书管理系统

// BOOKMOD.cpp : implementation file
//

#include "stdafx.h"
#include "TSG.h"
#include "BOOKMOD.h"
#include "bookinfo.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

/////////////////////////////////////////////////////////////////////////////
// BOOKMOD dialog


BOOKMOD::BOOKMOD(CWnd* pParent /*=NULL*/)
	: CDialog(BOOKMOD::IDD, pParent)
{
	//{{AFX_DATA_INIT(BOOKMOD)
	m_bid = 0;
	m_bname = _T("");
	m_bzuozhe = _T("");
	m_bpublic = _T("");
	m_bzongshu = 0;
	m_bleft = 0;
	m_bprice = 0;
	//}}AFX_DATA_INIT
}


void BOOKMOD::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(BOOKMOD)
	DDX_Text(pDX, IDC_EDIT101, m_bid);
	DDX_Text(pDX, IDC_EDIT102, m_bname);
	DDX_Text(pDX, IDC_EDIT103, m_bzuozhe);
	DDX_Text(pDX, IDC_EDIT104, m_bpublic);
	DDX_Text(pDX, IDC_EDIT106, m_bzongshu);
	DDX_Text(pDX, IDC_EDIT107, m_bleft);
	DDX_Text(pDX, IDC_EDIT105, m_bprice);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(BOOKMOD, CDialog)
	//{{AFX_MSG_MAP(BOOKMOD)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// BOOKMOD message handlers

void BOOKMOD::OnOK() 
{
	
	UpdateData(TRUE);
	CString strSQL;
    strSQL.Format("update  bookinfo set 书号=%d,书名=\'%s\',作者=\'%s\',出版社=\'%s\',价格=%d,总数=%d,库存数=%d where 书号=%d",m_bid,m_bname,m_bzuozhe,m_bpublic,m_bprice,m_bzongshu,m_bleft,m_bid);
	m_database.ExecuteSQL(strSQL);
	m_database.Close();
	CDialog::OnOK();
}