-
大小: 3.35MB文件類型: .rar金幣: 2下載: 0 次發(fā)布日期: 2023-09-14
- 語言: 其他
- 標簽:
資源簡介
含源代碼和詳細的實驗報告
一、 功能要求
在構(gòu)造系統(tǒng)時,首先從需求出發(fā)構(gòu)造數(shù)據(jù)庫表,然后再由數(shù)據(jù)庫表結(jié)合需求劃分系統(tǒng)功能模塊。這樣,就把一個大的系統(tǒng)分解成了幾個小系統(tǒng)。這里把系統(tǒng)的層次劃分為了四個部分:圖書維護,人員信息管理,圖書借閱管理,信息查詢。能夠?qū)崿F(xiàn)以下功能:
1、進行新書入庫、現(xiàn)有圖書信息修改;
2、能夠?qū)崿F(xiàn)對讀者基本信息的查詢和編輯管理;
3、能夠進行超期罰款功能;
4、能夠進行借閱信息的查詢功能;
5、能夠?qū)崿F(xiàn)模糊查詢和精確查詢

代碼片段和文件信息
//?DlgBorrow.cpp?:?implementation?file
//
#include?“stdafx.h“
#include?“l(fā)ibr.h“
#include?“DlgBorrow.h“
#include?“l(fā)ibrSet.h“
#include?“LibrBorrowSet.h“
#include?“LibrBookSet.h“
#ifdef?_DEBUG
#define?new?DEBUG_NEW
#undef?THIS_FILE
static?char?THIS_FILE[]?=?__FILE__;
#endif
//////////////////////////////////////////////////////////////////////////
extern?CLibrSet*?lsM;
extern?CLibrBorrowSet*?lbrsM;
extern?CLibrBookSet*?lbksM;
extern?CString?strAdmM;
//////////
extern?CString?dateToCString(CDBVariant&);
extern?void?runSQL(CString?strSQL);
/////////////////////////////////////////////////////////////////////////////
//?CDlgBorrow?dialog
CDlgBorrow::CDlgBorrow(CWnd*?pParent?/*=NULL*/)
:?CDialog(CDlgBorrow::IDD?pParent)
{
//{{AFX_DATA_INIT(CDlgBorrow)
//?NOTE:?the?ClassWizard?will?add?member?initialization?here
//}}AFX_DATA_INIT
}
void?CDlgBorrow::DoDataExchange(CDataExchange*?pDX)
{
CDialog::DoDataExchange(pDX);
//{{AFX_DATA_MAP(CDlgBorrow)
//?NOTE:?the?ClassWizard?will?add?DDX?and?DDV?calls?here
//}}AFX_DATA_MAP
}
BEGIN_MESSAGE_MAP(CDlgBorrow?CDialog)
//{{AFX_MSG_MAP(CDlgBorrow)
ON_BN_CLICKED(IDC_BTNBORROW?OnBtnBorrow)
ON_BN_CLICKED(IDC_BTNRETURN?OnBtnReturn)
//}}AFX_MSG_MAP
END_MESSAGE_MAP()
/////////////////////////////////////////////////////////////////////////////
//?CDlgBorrow?message?handlers
void?CDlgBorrow::OnBtnBorrow()?
{
//?TODO:?Add?your?control?notification?handler?code?here
CString?strBkName?strBkID?strRdID;
((CEdit*)GetDlgItem(IDC_EDITBOOKID))->GetWindowText(strBkID);
((CEdit*)GetDlgItem(IDC_EDITREADERID))->GetWindowText(strRdID);
if?(?!ifBorrowAble(strBkName)?)
return;
if?(?lbrsM->IsOpen()?)
lbrsM->Close();
lbrsM->m_strFilter?=?““;
lbrsM->Open();
if?(?!lbrsM->IsEOF()?)
lbrsM->MoveLast();
CString?strCurDate;
CTime?ctCurDate;
ctCurDate?=?ctCurDate.GetCurrentTime();
strCurDate?=?ctCurDate.Format(“%Y-%m-%d“);
if?(?!lbrsM->CanAppend()?)
{
MessageBox(“不行!“);
return;
}
lbrsM->AddNew();
lbrsM->SetFieldNull(?NULL?FALSE);
lbrsM->m_brAdmID?=?strAdmM;
lbrsM->m_brBookID?=?strBkID;
lbrsM->m_brBookOutDate?=?ctCurDate;
ctCurDate?+=?CTimeSpan(60000);
lbrsM->m_brBookLimiDate?=?ctCurDate;
lbrsM->m_brBookInDate?=?0;
lbrsM->m_brBookName?=?strBkName;
lbrsM->m_brDState?=?“借出“;
lbrsM->m_brReadID?=?strRdID;
lbrsM->m_brFine?=?“無“;
if?(?!lbrsM->CanUpdate()?)
MessageBox(“無法更新!“);
if?(?!?lbrsM->Update()?||?!lbrsM->Requery()??)
{
MessageBox(“更新數(shù)據(jù)時出錯!“);
return?;
}
if?(?!doBorrowWork(strBkID)?)
return;
lbrsM->MoveLast();
MessageBox(“借書成功!“);
}
void?CDlgBorrow::OnBtnReturn()?
{
//?TODO:?Add?your?control?notification?handler?code?here
CString?strBkName?strBkID?strRdID;
((CEdit*)GetDlgItem(IDC_EDITBOOKID))->GetWindowText(strBkID);
((CEdit*)GetDlgItem(IDC_EDITREADERID))->GetWindowText(strRdID);
if?(?!ifReturnAble(strBkName)?)
return;
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件??????46780??2008-09-18?17:33??圖書館管系統(tǒng)?數(shù)據(jù)庫課程設(shè)計\gaoming\Debug\DlgBorrow.obj
?????文件??????10872??2008-09-18?17:33??圖書館管系統(tǒng)?數(shù)據(jù)庫課程設(shè)計\gaoming\Debug\DlgBorrow.sbr
?????文件??????28561??2008-09-18?17:33??圖書館管系統(tǒng)?數(shù)據(jù)庫課程設(shè)計\gaoming\Debug\DlgLoad.obj
?????文件???????6280??2008-09-18?17:33??圖書館管系統(tǒng)?數(shù)據(jù)庫課程設(shè)計\gaoming\Debug\DlgLoad.sbr
?????文件??????20296??2008-09-18?17:33??圖書館管系統(tǒng)?數(shù)據(jù)庫課程設(shè)計\gaoming\Debug\DlgPay.obj
?????文件???????5441??2008-09-18?17:33??圖書館管系統(tǒng)?數(shù)據(jù)庫課程設(shè)計\gaoming\Debug\DlgPay.sbr
?????文件??????33274??2008-09-18?17:33??圖書館管系統(tǒng)?數(shù)據(jù)庫課程設(shè)計\gaoming\Debug\DlgReturn.obj
?????文件???????6734??2008-09-18?17:33??圖書館管系統(tǒng)?數(shù)據(jù)庫課程設(shè)計\gaoming\Debug\DlgReturn.sbr
?????文件??????12539??2008-09-18?17:33??圖書館管系統(tǒng)?數(shù)據(jù)庫課程設(shè)計\gaoming\Debug\DlgShowBook.obj
?????文件???????3223??2008-09-18?17:33??圖書館管系統(tǒng)?數(shù)據(jù)庫課程設(shè)計\gaoming\Debug\DlgShowBook.sbr
?????文件?????188458??2008-09-19?12:57??圖書館管系統(tǒng)?數(shù)據(jù)庫課程設(shè)計\gaoming\Debug\Libr.exe
?????文件?????550144??2008-09-19?12:57??圖書館管系統(tǒng)?數(shù)據(jù)庫課程設(shè)計\gaoming\Debug\Libr.ilk
?????文件??????32021??2008-09-18?17:33??圖書館管系統(tǒng)?數(shù)據(jù)庫課程設(shè)計\gaoming\Debug\Libr.obj
?????文件????7173532??2008-09-18?17:33??圖書館管系統(tǒng)?數(shù)據(jù)庫課程設(shè)計\gaoming\Debug\Libr.pch
?????文件?????623616??2008-09-19?12:57??圖書館管系統(tǒng)?數(shù)據(jù)庫課程設(shè)計\gaoming\Debug\Libr.pdb
?????文件??????11144??2008-09-18?17:33??圖書館管系統(tǒng)?數(shù)據(jù)庫課程設(shè)計\gaoming\Debug\Libr.res
?????文件??????13520??2008-09-18?17:33??圖書館管系統(tǒng)?數(shù)據(jù)庫課程設(shè)計\gaoming\Debug\Libr.sbr
?????文件??????20836??2008-09-18?17:33??圖書館管系統(tǒng)?數(shù)據(jù)庫課程設(shè)計\gaoming\Debug\LibrBookSet.obj
?????文件???????4498??2008-09-18?17:33??圖書館管系統(tǒng)?數(shù)據(jù)庫課程設(shè)計\gaoming\Debug\LibrBookSet.sbr
?????文件??????18436??2008-09-18?17:33??圖書館管系統(tǒng)?數(shù)據(jù)庫課程設(shè)計\gaoming\Debug\LibrBorrowSet.obj
?????文件???????4293??2008-09-18?17:33??圖書館管系統(tǒng)?數(shù)據(jù)庫課程設(shè)計\gaoming\Debug\LibrBorrowSet.sbr
?????文件??????14439??2008-09-18?17:33??圖書館管系統(tǒng)?數(shù)據(jù)庫課程設(shè)計\gaoming\Debug\LibrDoc.obj
?????文件???????3840??2008-09-18?17:33??圖書館管系統(tǒng)?數(shù)據(jù)庫課程設(shè)計\gaoming\Debug\LibrDoc.sbr
?????文件??????18029??2008-09-18?17:33??圖書館管系統(tǒng)?數(shù)據(jù)庫課程設(shè)計\gaoming\Debug\librSet.obj
?????文件???????4144??2008-09-18?17:33??圖書館管系統(tǒng)?數(shù)據(jù)庫課程設(shè)計\gaoming\Debug\librSet.sbr
?????文件??????41202??2008-09-18?17:33??圖書館管系統(tǒng)?數(shù)據(jù)庫課程設(shè)計\gaoming\Debug\LibrView.obj
?????文件??????15726??2008-09-18?17:33??圖書館管系統(tǒng)?數(shù)據(jù)庫課程設(shè)計\gaoming\Debug\LibrView.sbr
?????文件??????19736??2008-09-18?17:33??圖書館管系統(tǒng)?數(shù)據(jù)庫課程設(shè)計\gaoming\Debug\MainFrm.obj
?????文件???????4439??2008-09-18?17:33??圖書館管系統(tǒng)?數(shù)據(jù)庫課程設(shè)計\gaoming\Debug\MainFrm.sbr
?????文件??????16131??2008-09-18?17:33??圖書館管系統(tǒng)?數(shù)據(jù)庫課程設(shè)計\gaoming\Debug\PropSearchSheep.obj
............此處省略64個文件信息
評論
共有 條評論