insertbookcladlg.cpp

VC下基于SQL的图书管理系统源代码

// InsertBookClaDlg.cpp : implementation file
//

#include "stdafx.h"
#include "BookAdmi.h"
#include "InsertBookClaDlg.h"
#include "BookClaInfo.h"
#include "ADOConn.h"

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

/////////////////////////////////////////////////////////////////////////////
// InsertBookClaDlg dialog


InsertBookClaDlg::InsertBookClaDlg(CWnd* pParent /*=NULL*/)
	: CDialog(InsertBookClaDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(InsertBookClaDlg)
	m_BookClaIdEdit = _T("");
	m_BookClaNameEdit = _T("");
	//}}AFX_DATA_INIT
}


void InsertBookClaDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(InsertBookClaDlg)
	DDX_Text(pDX, IDC_EDIT1, m_BookClaIdEdit);
	DDX_Text(pDX, IDC_EDIT2, m_BookClaNameEdit);
	//}}AFX_DATA_MAP
}


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

/////////////////////////////////////////////////////////////////////////////
// InsertBookClaDlg message handlers

void InsertBookClaDlg::OnOK() 
{
	UpdateData(true);
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	_bstr_t vSQL;
	vSQL="SELECT * from t_bookcla where BookClaId='"+m_BookClaIdEdit+"'";
	_RecordsetPtr m_pRecordset;
	m_pRecordset=m_AdoConn.GetRecordSet(vSQL);
	if(!m_pRecordset->adoEOF)
	{
		MessageBox("此图书分类号已存在!!");
		return;
	}
	if(BookClaInfoError())
	{
		MessageBox(ErrorStr+"输入有误!!");
		return;
	}
	BookClaInfo BInfo;
	BInfo.a_BookClaId=m_BookClaIdEdit;
	BInfo.a_BookClaName=m_BookClaNameEdit;
	BInfo.sql_insert();	
	MessageBox("数据录入成功!!");
}

bool InsertBookClaDlg::BookClaInfoError()
{
	if(m_BookClaIdEdit=="")
	{
		ErrorStr="图书分类号";
		return(true);
	}
	if(m_BookClaNameEdit=="")
	{
		ErrorStr="图书分类名称";
		return(true);
	}	
	return(false);
}