personadd.cpp

本源码为图书管理系统

// personadd.cpp : implementation file
//

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

/////////////////////////////////////////////////////////////////////////////
// personadd dialog


personadd::personadd(CWnd* pParent /*=NULL*/)
	: CDialog(personadd::IDD, pParent)
{
	//{{AFX_DATA_INIT(personadd)
	m_pid = 0;
	m_pname = _T("");
	m_psex = _T("");
	m_pyuan = _T("");
	m_pli = _T("");
	//}}AFX_DATA_INIT
}


void personadd::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(personadd)
	DDX_Text(pDX, IDC_EDIT1, m_pid);
	DDX_Text(pDX, IDC_EDIT2, m_pname);
	DDX_Text(pDX, IDC_EDIT3, m_psex);
	DDX_Text(pDX, IDC_EDIT4, m_pyuan);
	DDX_Text(pDX, IDC_EDIT5, m_pli);
	//}}AFX_DATA_MAP
}


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

/////////////////////////////////////////////////////////////////////////////
// personadd message handlers

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

	int i=1;
	int flag=0;
	while(!flag){
		personinfo m_recordset(&m_database);
		strSQL.Format("select * from personinfo where 学号=%d",i);
		m_recordset.Open(AFX_DB_USE_DEFAULT_TYPE,strSQL);
		if(m_recordset.GetRecordCount()==0){
			strSQL.Format("insert into personinfo values(%d,\'%s\',\'%s\',\'%s\',\'%s\')",m_pid,m_pname,m_psex,m_pyuan,m_pli);
			m_database.ExecuteSQL(strSQL);
			m_database.Close();
			CDialog::OnOK();
			flag=1;
		}
		i++;
		
	}
	
	CDialog::OnOK();
}