addbook.cpp

基于access数据库的图书馆管理系统

// ADDBOOK.cpp : implementation file
//

#include "stdafx.h"
#include "课程设计.h"
#include "ADDBOOK.h"

#include "ADOConn.h"

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

/////////////////////////////////////////////////////////////////////////////
// CADDBOOK dialog


CADDBOOK::CADDBOOK(CWnd* pParent /*=NULL*/)
	: CDialog(CADDBOOK::IDD, pParent)
{
	//{{AFX_DATA_INIT(CADDBOOK)
	m_author = _T("");
	m_num = _T("");
	m_name = _T("");
	m_press = _T("");
	m_price = 0.0f;
	m_date = _T("");
	//}}AFX_DATA_INIT
}


void CADDBOOK::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CADDBOOK)
	DDX_Text(pDX, IDC_EDIT_BOOK_AUTHOR, m_author);
	DDX_Text(pDX, IDC_EDIT_BOOK_NMB, m_num);
	DDX_Text(pDX, IDC_EDIT_BOOK_NAME, m_name);
	DDX_Text(pDX, IDC_EDIT_BOOK_CONCERN, m_press);
	DDX_Text(pDX, IDC_EDIT_BOOK_MONEY, m_price);
	DDX_Text(pDX, IDC_EDIT_BOOK_DATE, m_date);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CADDBOOK, CDialog)
	//{{AFX_MSG_MAP(CADDBOOK)
	ON_BN_CLICKED(IDC_BTN_CANCEL, OnBtnCancel)
	ON_BN_CLICKED(IDC_BTN_ADD, OnBtnAdd)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CADDBOOK message handlers

void CADDBOOK::OnBtnCancel() 
{
	// TODO: Add your control notification handler code here
	OnOK();
}

void CADDBOOK::OnBtnAdd() 
{
	// TODO: Add your control notification handler code here
	UpdateData();
	if (WSEEN_CHECK())
	{
       sql_insert();
	   OnOK();
	}
   
}

void CADDBOOK::sql_insert()
{
  ADOConn m_adoconn;
  m_adoconn.OnInitDBConnect();
  _bstr_t sql;
  CString price,press,name,date,num,author;
  num = "'"+m_num+"'";
  name = "'"+m_name+"'";
  price.Format("%-9.2f",m_price);
  price = "'"+price+"'";
  author = "'"+m_author+"'";
  date = "'"+m_date+"'";
  press = "'"+m_press+"'";
  sql = "insert into 书目信息表(书名,作者,书号,出版社,出版日期,定价) values("+name+","+author+","+num+","+press+","+date+ ","+price+")";
  m_adoconn.ExecuteSQL(sql);
  CTime tNow;
  CString Now;
  tNow = CTime::GetCurrentTime();
  Now = tNow.Format("%y-%m-%d");
  Now = "'"+Now+"'";
  sql = "insert into 馆藏图书信息表(图书ID,入馆日期,是否在库) values("+num+","+Now+","+"'1'"+")";
  m_adoconn.ExecuteSQL(sql);
  m_adoconn.ExitConnect();
}

void CADDBOOK::sql_update()
{
  ADOConn m_adoconn;
  m_adoconn.OnInitDBConnect();
  _bstr_t sql;
  CTime tNow;
  CString Now;
  tNow = CTime::GetCurrentTime();
  Now = tNow.Format("%y-%m-%d"); 
// sql = 
  m_adoconn.ExecuteSQL(sql);
  m_adoconn.ExitConnect();
}

BOOL CADDBOOK::WSEEN_CHECK()
{
    ADOConn m_adoc;
	m_adoc.OnInitDBConnect();
    CString booknum;
	booknum = "'"+m_num+"'";
	_bstr_t vSQL;
	vSQL = "select * from 书目信息表  where 书号 = "+booknum;
	_RecordsetPtr m_pRecordset;
	m_pRecordset = m_adoc.GetRecordSet(vSQL);
	
	if (m_pRecordset->adoEOF >= 0)
	{
		AfxMessageBox("书号已存在！");
		m_adoc.ExitConnect();
		return 0;
	}
	else
	{
		m_adoc.ExitConnect();
      	return 1;
	}
	
	return 1;
}