add_ka_num.cpp

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

// Add_Ka_NUM.cpp : implementation file
//

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

#include "ADOConn.h"

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

/////////////////////////////////////////////////////////////////////////////
// CAdd_Ka_NUM dialog


CAdd_Ka_NUM::CAdd_Ka_NUM(CWnd* pParent /*=NULL*/)
	: CDialog(CAdd_Ka_NUM::IDD, pParent)
{
	//{{AFX_DATA_INIT(CAdd_Ka_NUM)
	m_name = _T("");
	m_num = _T("");
	//}}AFX_DATA_INIT
}


void CAdd_Ka_NUM::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CAdd_Ka_NUM)
	DDX_Text(pDX, IDC_EDIT_NAME, m_name);
	DDX_Text(pDX, IDC_EDIT_NMB, m_num);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CAdd_Ka_NUM, CDialog)
	//{{AFX_MSG_MAP(CAdd_Ka_NUM)
	ON_BN_CLICKED(IDC_BTN_CANCEL, OnBtnCancel)
	ON_BN_CLICKED(IDC_BTN_LOGIN, OnBtnLogin)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CAdd_Ka_NUM message handlers

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

void CAdd_Ka_NUM::OnBtnLogin() 
{
	// TODO: Add your control notification handler code here
	UpdateData();
	if (m_name == "")
	{
		AfxMessageBox("持卡人不能为空！");
	}
	if (m_num == "")
	{
		AfxMessageBox("卡号不能为空！");
	}

    if (!sql_check())
    {
		AfxMessageBox("对不起，这卡号已被占！");
    }
    else
	{
		if (m_name != ""&&m_num != "")
		{
			sql_insert();
			OnOK();
		}
	}

}

void CAdd_Ka_NUM::sql_insert()
{
 ADOConn m_adoconn;
  m_adoconn.OnInitDBConnect();
  _bstr_t sql;
  CString num,name;
  num = "'"+m_num+"'";
  name = "'"+m_name+"'";
  sql = "insert into 借书卡表(卡号,持卡人,超时,借书数) values("+num+","+name+",0,0)";
  m_adoconn.ExecuteSQL(sql);
  m_adoconn.ExitConnect();
}

BOOL CAdd_Ka_NUM::sql_check()
{
	ADOConn m_adoconn;
	m_adoconn.OnInitDBConnect();
	_bstr_t sql;
	CString num,name;
	num = "'"+m_num+"'";
	sql = "select * from 借书卡表 where 卡号 = " + num;
	_RecordsetPtr m_pRecordset;
	m_pRecordset = m_adoconn.GetRecordSet(sql);
	if (m_pRecordset->adoEOF < 0)
	{
		m_adoconn.ExitConnect();
		return 1;
	}
	else
	{
		m_adoconn.ExitConnect();
		return 0;
	}
	
}