innumberdlg.cpp

基于VB的数据库教材管理系统设计 有源码

// InnumberDlg.cpp : implementation file
//

#include "stdafx.h"
#include "BookManager.h"
#include "InnumberDlg.h"
#include "BookIMSet.h"

#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

/////////////////////////////////////////////////////////////////////////////
// CInnumberDlg dialog


CInnumberDlg::CInnumberDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CInnumberDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CInnumberDlg)
	m_innumber = 0;
	//}}AFX_DATA_INIT
}


void CInnumberDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CInnumberDlg)
	DDX_Control(pDX, IDC_innumber, m_ctr_innumber);
	DDX_Text(pDX, IDC_innumber, m_innumber);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CInnumberDlg, CDialog)
	//{{AFX_MSG_MAP(CInnumberDlg)
	ON_BN_CLICKED(IDC_innumok, Oninnumok)
	ON_BN_CLICKED(IDC_innumcancel, Oninnumcancel)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CInnumberDlg message handlers

void CInnumberDlg::Oninnumok() 
{
	// TODO: Add your control notification handler code here
	m_ctr_innumber.SetFocus();
	UpdateData(TRUE);
	if(m_innumber==0)
	{
	   MessageBox("请输入要入库书籍的数量！");
	   m_ctr_innumber.SetFocus();
	}
    if(m_innumber<=0)
	{
	   MessageBox("没有输入入库数量或输入为负！","入库数量输入错误",MB_OK);
	}
   
        
	CBookManagerApp* app=(CBookManagerApp*)::AfxGetApp();
	
	CString strSQL;
	CBookIMSet recordset;
	strSQL.Format("select * from bookIM where book_id='%s'",app->temp);
	if(!recordset.Open(AFX_DB_USE_DEFAULT_TYPE,strSQL))
	{
	   MessageBox("打开数据库失败！","数据库错误",MB_OK);
	   return;
	}
	recordset.Edit();
	recordset.m_number+=m_innumber;
	recordset.Update();
	recordset.Close();
	MessageBox("书籍入库添加成功！");
	CDialog::OnOK();
}


void CInnumberDlg::Oninnumcancel() 
{
	// TODO: Add your control notification handler code here
	CDialog::OnCancel();
}