addimdlg.cpp

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

// AddimDlg.cpp : implementation file
//

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


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

/////////////////////////////////////////////////////////////////////////////
// CAddimDlg dialog


CAddimDlg::CAddimDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CAddimDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CAddimDlg)
	m_str_bookid = _T("");
	m_str_authorname = _T("");
	m_str_bookname = _T("");
	m_str_department = _T("");
	m_str_note = _T("");
	m_number = 0;
	m_price = 0.0f;
	m_str_publishment = _T("");
	m_str_sureid = _T("");
	m_str_version = _T("");
	//}}AFX_DATA_INIT
}


void CAddimDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CAddimDlg)
	DDX_Control(pDX, IDC_Add_bookid, m_ctr_bookid);
	DDX_Control(pDX, IDC_Add_sureid, m_ctr_sureid);
	DDX_Text(pDX, IDC_Add_bookid, m_str_bookid);
	DDX_Text(pDX, IDC_Add_authorname, m_str_authorname);
	DDX_Text(pDX, IDC_Add_bookname, m_str_bookname);
	DDX_Text(pDX, IDC_Add_department, m_str_department);
	DDX_Text(pDX, IDC_Add_note, m_str_note);
	DDX_Text(pDX, IDC_Add_number, m_number);
	DDX_Text(pDX, IDC_Add_price, m_price);
	DDX_Text(pDX, IDC_Add_publishment, m_str_publishment);
	DDX_Text(pDX, IDC_Add_sureid, m_str_sureid);
	DDX_Text(pDX, IDC_Add_version, m_str_version);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CAddimDlg, CDialog)
	//{{AFX_MSG_MAP(CAddimDlg)
	ON_BN_CLICKED(IDC_Addok, OnAddok)
	ON_BN_CLICKED(IDC_Addcancel, OnAddcancel)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CAddimDlg message handlers

void CAddimDlg::OnAddok() 
{
	// TODO: Add your control notification handler code here
	UpdateData(TRUE);
	if(m_str_bookid.IsEmpty())
	{
	   MessageBox("书籍条码不能为空！");
	   m_ctr_bookid.SetFocus();
	   return;
	}
	else if(m_str_sureid.IsEmpty())
	{
	   MessageBox("请输入验证用的书籍条码项！");
	   m_ctr_sureid.SetFocus();
	   return;
	}
	CString strSQL;
	CBookIMSet recordset;
	strSQL.Format("select * from bookIM where book_id='%s'",m_str_bookid);
	if(!recordset.Open(AFX_DB_USE_DEFAULT_TYPE,strSQL))
	{
		MessageBox("打开数据库失败！","数据库错误",MB_OK);
		return;
	}
	recordset.AddNew();
	recordset.m_book_id=m_str_bookid;
	recordset.m_book_name=m_str_bookname;
	recordset.m_author=m_str_authorname;
	recordset.m_department=m_str_department;
    recordset.m_number=m_number;
	recordset.m_note=m_str_note;
	recordset.m_version=m_str_version;
	recordset.m_price=m_price;
	recordset.m_publishment=m_str_publishment;
	recordset.Update();
	recordset.Close();
	MessageBox("IM add successful completely!");
	int k=MessageBox("要继续操作吗？","选择操作",MB_OKCANCEL);
	if(k==1)
	{
	   m_str_bookid.Empty();
	   m_str_sureid.Empty();
	   m_str_bookname.Empty();
	   m_str_note.Empty();
	   m_str_publishment.Empty();
	   m_str_department.Empty();
	   m_number=0;
	   m_price=0.0;
	   m_ctr_bookid.SetFocus();
	   UpdateData(FALSE);
	}
	else
	{
		CDialog::OnOK();
	}

}

void CAddimDlg::OnAddcancel() 
{
	// TODO: Add your control notification handler code here
	
	
}