?? inhabitantsdoc.cpp
字號:
// 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("小區(qū)居民管理系統(tǒng)");
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;
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -