dlgaddbook.cpp

书库管理 使用时要输入密码

// DlgAddBook.cpp : 实现文件
//

#include "stdafx.h"
#include "BookManage.h"
#include "DlgAddBook.h"
#include ".\dlgaddbook.h"
#include "dlglendbook.h"

// CDlgAddBook 对话框
extern CBookManageApp theApp;
IMPLEMENT_DYNAMIC(CDlgAddBook, CDialog)
CDlgAddBook::CDlgAddBook(CWnd* pParent /*=NULL*/)
	: CDialog(CDlgAddBook::IDD, pParent)
	, m_sBookName(_T(""))
	, m_sAuthor(_T(""))
	, m_sBianHao(_T(""))
	, m_sPublic(_T(""))
	, m_sTime(_T(""))
	, m_nStatus(1)
	, m_Yshu(_T(""))
{
}

CDlgAddBook::~CDlgAddBook()
{
}

void CDlgAddBook::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	DDX_Text(pDX, IDC_EDIT_BOOKNAME, m_sBookName);
	DDX_Text(pDX, IDC_EDIT_AUTHOR, m_sAuthor);
	DDX_Text(pDX, IDC_EDIT_BIANHAO, m_sBianHao);
	DDX_Text(pDX, IDC_EDIT_PUBLIC, m_sPublic);
	DDX_Text(pDX, IDC_EDIT_TIME, m_sTime);
	DDX_Text(pDX, IDC_STATUS, m_nStatus);
	DDX_Text(pDX, IDC_YESHU, m_Yshu);
}


BEGIN_MESSAGE_MAP(CDlgAddBook, CDialog)
	ON_BN_CLICKED(ID_ADD, OnBnClickedAdd)
END_MESSAGE_MAP()


// CDlgAddBook 消息处理程序

void CDlgAddBook::OnBnClickedAdd()
{
	// TODO: 在此添加控件通知处理程序代码
	UpdateData(TRUE);
/*		CString SQLstr,status,ss;
	status.Format("%d",m_nStatus);
	char* ch="fdsafsd";
	ss.Format("%s",ch);
	
	
	//SQLstr="insert into BookManager (书名,作者,书籍编号,出版社,出版时间,状态) values("+m_sBookName+"','"+m_sAuthor+"','"+m_sBianHao+"','"+m_sPublic+"','"+m_sTime+"','"+status+"')";//

	SQLstr="insert into cc (name) values("+ss+")";

	try
	{
	_variant_t RecordsAffected;
	theApp.m_pConnection->Execute((_bstr_t)SQLstr,&RecordsAffected,adCmdText);
	AfxMessageBox("成功插入1条数据！");
	}
	catch(_com_error e)
	{
		AfxMessageBox("添加纪录失败！!");
		return;
	}
*/
	if(m_sBookName.IsEmpty()||m_sAuthor.IsEmpty()||m_sBianHao.IsEmpty()||m_sPublic.IsEmpty()||m_sTime.IsEmpty()||m_Yshu.IsEmpty())
	{
		AfxMessageBox("请输入数据！");
		return;
	}
	
	_RecordsetPtr  m_pRecordset;
	try
	{

		
		m_pRecordset.CreateInstance (__uuidof(Recordset));

		m_pRecordset->Open("SELECT * FROM BookManager",                // 查询DemoTable表中所有字段
							theApp.m_pConnection.GetInterfacePtr(),	 // 获取库接库的IDispatch指针
							adOpenDynamic,
							adLockOptimistic,
							adCmdText);

		m_sBookName.Format("%s%s%s","《",m_sBookName,"》");
		m_pRecordset->AddNew();
		m_pRecordset->PutCollect("书名", _variant_t(m_sBookName));
		m_pRecordset->PutCollect("作者", _variant_t(m_sAuthor));
		m_pRecordset->PutCollect("书籍编号", _variant_t(m_sBianHao));
		m_pRecordset->PutCollect("出版社", _variant_t(m_sPublic));
		m_pRecordset->PutCollect("出版时间", _variant_t(m_sTime));
		m_pRecordset->PutCollect("状态", _variant_t(m_nStatus));
		m_pRecordset->PutCollect("页数", _variant_t(m_Yshu));
		m_pRecordset->PutCollect("借阅人", _variant_t("无"));
	
		m_pRecordset->Update();

/*
	_CommandPtr    m_commandptr;
	m_commandptr.CreateInstance (__uuidof(Command));
		
	m_commandptr->ActiveConnection =theApp.m_pConnection ;

	m_commandptr->CommandText = _bstr_t(SQLstr);
	m_commandptr->CommandType =adCmdText;	
	m_commandptr->Execute(NULL,NULL,adCmdUnknown);
	*/

	AfxMessageBox("成功插入1条数据！");
	}

	catch(_com_error e)
	{
		AfxMessageBox("添加纪录失败！!");
		return;
	}
	m_pRecordset->Close();
	m_pRecordset = NULL;

}