bookadd.cpp

本源码为图书管理系统

// bookadd.cpp : implementation file
//

#include "stdafx.h"
#include "TSG.h"
#include "bookadd.h"
#include "bookinfo.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

/////////////////////////////////////////////////////////////////////////////
// bookadd dialog


bookadd::bookadd(CWnd* pParent /*=NULL*/)
	: CDialog(bookadd::IDD, pParent)
{
	//{{AFX_DATA_INIT(bookadd)
	m_bookid = 0;
	m_bookname = _T("");
	m_zuozhe = _T("");
	m_bookpulic = _T("");
	m_price = 0;
	m_zongshu = 0;
	m_bookleft = 0;
	//}}AFX_DATA_INIT
}


void bookadd::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(bookadd)
	DDX_Text(pDX, IDC_EDIT1, m_bookid);
	DDX_Text(pDX, IDC_EDIT2, m_bookname);
	DDX_Text(pDX, IDC_EDIT3, m_zuozhe);
	DDX_Text(pDX, IDC_EDIT4, m_bookpulic);
	DDX_Text(pDX, IDC_EDIT5, m_price);
	DDX_Text(pDX, IDC_EDIT6, m_zongshu);
	DDX_Text(pDX, IDC_EDIT7, m_bookleft);
	//}}AFX_DATA_MAP
}


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

/////////////////////////////////////////////////////////////////////////////
// bookadd message handlers

void bookadd::OnOK() 
{
	// TODO: Add extra validation here
	UpdateData(TRUE);
	CString strSQL;

	int i=1;
	int flag=0;
	while(!flag){
		bookinfo m_recordset(&m_database);
		strSQL.Format("select * from bookinfo where 书号=%d",i);
		m_recordset.Open(AFX_DB_USE_DEFAULT_TYPE,strSQL);
		if(m_recordset.GetRecordCount()==0){
			strSQL.Format("insert into bookinfo values(%d,\'%s\',\'%s\',\'%s\',%d,%d,%d)",m_bookid,m_bookname,m_zuozhe,m_bookpulic,m_price,m_zongshu,m_bookleft);
			m_database.ExecuteSQL(strSQL);
			m_database.Close();
			CDialog::OnOK();
			flag=1;
		}
		i++;
		
	}
	CDialog::OnOK();

}