inhabitantsdoc.cpp

VC6.0下开发的Access数据库小区管理系统

// INhabitantsDoc.cpp : implementation of the CINhabitantsDoc class
//

#include "stdafx.h"
#include "INhabitants.h"

#include "INhabitantsDoc.h"

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

/////////////////////////////////////////////////////////////////////////////
// CINhabitantsDoc

IMPLEMENT_DYNCREATE(CINhabitantsDoc, CDocument)

BEGIN_MESSAGE_MAP(CINhabitantsDoc, CDocument)
	//{{AFX_MSG_MAP(CINhabitantsDoc)
		// NOTE - the ClassWizard will add and remove mapping macros here.
		//    DO NOT EDIT what you see in these blocks of generated code!
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CINhabitantsDoc construction/destruction

CINhabitantsDoc::CINhabitantsDoc()
{
	// TODO: add one-time construction code here

}

CINhabitantsDoc::~CINhabitantsDoc()
{
}

BOOL CINhabitantsDoc::OnNewDocument()
{
	if (!CDocument::OnNewDocument())
		return FALSE;

	// TODO: add reinitialization code here
	// (SDI documents will reuse this document)
	HRESULT result = m_dbHouse.Open();

	if(FAILED(result))
		AfxMessageBox("open database failed!");

	SetTitle("小区居民管理系统");

	return TRUE;
}



/////////////////////////////////////////////////////////////////////////////
// CINhabitantsDoc serialization

void CINhabitantsDoc::Serialize(CArchive& ar)
{
	if (ar.IsStoring())
	{
		// TODO: add storing code here
	}
	else
	{
		// TODO: add loading code here
	}
}

/////////////////////////////////////////////////////////////////////////////
// CINhabitantsDoc diagnostics

#ifdef _DEBUG
void CINhabitantsDoc::AssertValid() const
{
	CDocument::AssertValid();
}

void CINhabitantsDoc::Dump(CDumpContext& dc) const
{
	CDocument::Dump(dc);
}
#endif //_DEBUG

/////////////////////////////////////////////////////////////////////////////
// CINhabitantsDoc commands
void CINhabitantsDoc::DeleteContents() 
{
	m_dbHouse.Close();
	m_dbHouse.m_session.Close();
	
	CDocument::DeleteContents();
}

int CINhabitantsDoc::AddUser(USER &user)
{
	CString strSql;
	strSql.Format("select * from house where sectionname = '%s' and buildingnum = %d and cellnum = %d and roomnum = %d", 
		user.strSectionName, user.nBuildingnum, user.nCellnum, user.nRoomnum);
	CCommand<CAccessor<ChouseAccessor> > dbHouse;
	long * pCount = new long;
	if(dbHouse.Open(m_dbHouse.m_session, strSql, NULL, pCount) != S_OK){
		AfxMessageBox("error");
		delete pCount;
		return -1;
	}
	if(dbHouse.MoveFirst() == S_OK){
		delete pCount;
		dbHouse.Close();
		return 0;
	}
	delete pCount;
	dbHouse.Close();

	m_dbHouse.MoveLast();
	_tcscpy(m_dbHouse.m_sectionname, user.strSectionName);
	m_dbHouse.m_buildingnum = user.nBuildingnum;
	m_dbHouse.m_cellnum = user.nCellnum;
	m_dbHouse.m_roomnum = user.nRoomnum;
	_tcscpy(m_dbHouse.m_housemaster, user.strName);
	_tcscpy(m_dbHouse.m_beeppager, user.strBeeppager);
	_tcscpy(m_dbHouse.m_email, user.strEmail);
	_tcscpy(m_dbHouse.m_housetel, user.strHouseTel);
	_tcscpy(m_dbHouse.m_mobile, user.strMobile);
	_tcscpy(m_dbHouse.m_office, user.strOffice);
	_tcscpy(m_dbHouse.m_officetel, user.strOfficeTel);
	HRESULT hResult = m_dbHouse.Insert();
	if(FAILED(hResult)){
		AfxMessageBox(_T("Error inserting the current record"));
		return -1;
	}
	return 1;
}

BOOL CINhabitantsDoc::DeleteUser(CString strSql)
{
	CCommand<CAccessor<ChouseAccessor> > dbHouse;
	long * pCount = new long;
	if(dbHouse.Open(m_dbHouse.m_session, strSql, NULL, pCount, 
		DBGUID_DEFAULT, FALSE) != S_OK){
		AfxMessageBox("error");
		delete pCount;
		return FALSE;
	}
	delete pCount;
	dbHouse.Close();
	return TRUE;
}