【正文】 G_BORROW,READER_ID FROM READER。// mSqlStr = mSqlStr + 39。// if (!(AFX_DB_USE_DEFAULT_TYPE, mSqlStr))if (!(AFX_DB_USE_DEFAULT_TYPE)){AfxMessageBox(數(shù)據(jù)表打開(kāi)錯(cuò)誤!)。return。} = READER_ID=39。 + m_strReaderID。 = + 39。()。if (!()){if ( == Y){江西理工大學(xué)應(yīng)用科學(xué)學(xué)院畢業(yè)設(shè)計(jì)43mSqlStr = SELECT * FROM BORROW WHERE READER_ID= 39。 + m_strReaderID。mSqlStr = mSqlStr + 39。if (!(AFX_DB_USE_DEFAULT_TYPE,mSqlStr)){()。AfxMessageBox(數(shù)據(jù)表打開(kāi)錯(cuò)誤!)。return。}// Add some code to determine the num of book which this reader borrowed.m_bCanBorrow = TRUE。()。}}()。if (!m_bCanBorrow){AfxMessageBox(讀者不能借書(shū)！)。return。}mSqlStr = SELECT * FROM BOOK WHERE BOOK_ID=39。 + m_strBookID。mSqlStr = mSqlStr + 39。if(!(AFX_DB_USE_DEFAULT_TYPE, mSqlStr)){AfxMessageBox(數(shù)據(jù)表打開(kāi)錯(cuò)誤！)。return 。}if (!())陳敏峰：圖書(shū)管理系統(tǒng)44{if ( == Y){m_bCanLendOut = TRUE。}else{AfxMessageBox(此書(shū)不外借！ )。()。return。}}else{AfxMessageBox(無(wú)此書(shū)！)。()。return。}()。CMainFrame *pWnd。pWnd = (CMainFrame *)thisGetParent()。CString m_strUserID。m_strUserID = pWndm_strUserID 。// mSqlStr = INSERT INTO BORROW (READER_ID, BOOK_ID, BORROW_DATE, B_CLERK_ID) VALUES(39。mSqlStr = INSERT INTO BORROW (READER_ID, BOOK_ID, B_CLERK_ID) VALUES(39。mSqlStr = mSqlStr + m_strReaderID。mSqlStr = mSqlStr + 39。,39。mSqlStr = mSqlStr + m_strBookID。江西理工大學(xué)應(yīng)用科學(xué)學(xué)院畢業(yè)設(shè)計(jì)45mSqlStr = mSqlStr + 39。,39。// mSqlStr = mSqlStr + 39。, SYSDATE,39。mSqlStr = mSqlStr + m_strUserID。mSqlStr = mSqlStr + 39。)。CDatabase mDB。if (!(_T(Library))){AfxMessageBox(無(wú)法打開(kāi)數(shù)據(jù)庫(kù)！)。return。}try{(mSqlStr)。}catch(CDBException e){AfxMessageBox(執(zhí)行錯(cuò)！)。return。}()。AfxMessageBox(操作成功！ )。}void CLendOutDlg::OnCancel() { CDialog::OnCancel()。}BOOL CLendOutDlg::OnInitDialog() {CDialog::OnInitDialog()。return TRUE。 // return TRUE unless you set the focus to a control // EXCEPTION: OCX Property Pages should return FALSE陳敏峰：圖書(shū)管理系統(tǒng)46}167。 圖書(shū)歸還模塊的實(shí)現(xiàn)圖 圖書(shū)歸還界面流程說(shuō)明：輸入圖書(shū)代碼以完成操作。代碼說(shuō)明：實(shí)現(xiàn)還書(shū)功能的代碼如下：int CReturnBookDlg::QryBorrow(){int result。CTime m_ReturnDate_tmp。CString m_strtmp。CTime m_Current_Time=CTime::GetCurrentTime()。CTimeSpan m_TimeSpan_tmp(30,24,59,59)。UpdateData(true)。if (strcmp(m_Book_ID,)==0) return 0。 == and BOOK_ID=39。+m_Book_ID+39。江西理工大學(xué)應(yīng)用科學(xué)學(xué)院畢業(yè)設(shè)計(jì)47if (!()){AfxMessageBox(數(shù)據(jù)打開(kāi)失?。?。return 1。}()。if (()!=0) {m_ReaderName= 。m_BorrowDate=(%Y, %B %d) 。m_ReturnDate_tmp=+m_TimeSpan_tmp。m_ReturnDate=(%Y,%B %d)。if (m_ReturnDate_tmpm_Current_Time){m_TimeSpan_tmp=CTime::GetCurrentTime()m_ReturnDate_tmp。m_Days=()。UpdateData(false)。Insert_Fine()。result=1。}else{UpdateData(false)。Insert_History()。//正常還書(shū)result=2。}()。return result。陳敏峰：圖書(shū)管理系統(tǒng)48}else{return 0。}}void CReturnBookDlg::OnKillfocusEDITBookID() {int rs。CWnd *pWnd。CString m_strtmp。rs=QryBorrow()。if(rs==1){(超期%d 天，還書(shū)處理正常完成。是否繼續(xù)處理還書(shū)流程？,m_Days)。if(::MessageBox(thism_hWnd,m_strtmp,提示 ,MB_YESNO)==IDYES)SetTxtNull()。elseCDialog::OnClose()。}else if(rs==2){if(::MessageBox(thism_hWnd,還書(shū)處理正常完成,提示,MB_YESNO)==IDYES)SetTxtNull()。elseCDialog::OnClose()。}else if(rs==0)江西理工大學(xué)應(yīng)用科學(xué)學(xué)院畢業(yè)設(shè)計(jì)49{if (m_Book_ID == )return。::MessageBox(thism_hWnd,該書(shū)號(hào)信息不存在！ ,警告,MB_OK)。} // TODO: Add your control notification handler code herepWnd=GetDlgItem(IDC_EDITBook_ID)。pWndSetFocus()。}void CReturnBookDlg::OnCancel() {// TODO: Add extra cleanup hereCDialog::OnCancel()。}int CReturnBookDlg::Insert_Fine(){CDatabase mdb。CString m_strsql。CTime m_CurrentTime。m_CurrentTime=CTime::GetCurrentTime()。(insert into fine(Reader_ID,amount,days,fine_date) values( \39。%s\39。,%f,%d,(m_Days*),m_Days)。m_strsql=m_strsql+,39。+(%Y,%B %d)+39。)。if(!(_T(Library))){AfxMessageBox(數(shù)據(jù)庫(kù)打開(kāi)出錯(cuò))。return 0。}try{陳敏峰：圖書(shū)管理系統(tǒng)50()。(m_strsql)。m_strsql = UPDATE READER SET FLAG_BORROW=39。N39。 WHERE READER_ID=39。 +。m_strsql = m_strsql + 39。(m_strsql)。()。return 1。}catch(CDBException e){AfxMessageBox(數(shù)據(jù)庫(kù)執(zhí)行出錯(cuò))。return 0。}}int CReturnBookDlg::Insert_History(){CDatabase mdb。CString m_strsql。if(!(_T(library))){AfxMessageBox(數(shù)據(jù)庫(kù)執(zhí)行出錯(cuò))。return 0。}m_strsql=INSERT INTO HISTORY (READER_ID,BOOK_ID,BORROW_DATE,RETURN_DATE) VALUES (39。++39。m_strsql=m_strsql+,39。++39。m_strsql=m_strsql+,39。+m_BorrowDate+39。m_strsql=m_strsql+,39。+(CTime::GetCurrentTime()).Format(%Y,%B %d)+39。)。江西理工大學(xué)應(yīng)用科學(xué)學(xué)院畢業(yè)設(shè)計(jì)51try{()。(m_strsql)。()。}catch(CDBException e){AfxMessageBox(數(shù)據(jù)庫(kù)執(zhí)行出錯(cuò))。return 0。}return 1。}int CReturnBookDlg::SetTxtNull(){CWnd *pWnd。m_Book_ID=。m_BorrowDate=。m_Days=0。m_ReaderName=。m_ReturnDate=。UpdateData(false)。pWnd=GetDlgItem(IDC_EDITBook_ID)。// pWndSetFocus()。return 1。}int CReturnBookDlg::setTxtDisable(){CWnd *pWnd。陳敏峰：圖書(shū)管理系統(tǒng)52pWnd=GetDlgItem(IDC_EDITReaderName)。pWndEnableWindow(false)。pWnd=GetDlgItem(IDC_EDITBorrowDate)。pWndEnableWindow(false)。pWnd=GetDlgItem(IDC_EDITReturnDate)。pWndEnableWindow(false)。pWnd=GetDlgItem(IDC_EDITDays)。pWndEnableWindow(false)。return 1。}BOOL CReturnBookDlg::OnInitDialog(){CDialog::OnInitDialog()。// setTxtDisable()。return true。}167。 繳納罰金模塊的實(shí)現(xiàn)流程說(shuō)明：輸入讀者條碼以完成操作。代碼實(shí)現(xiàn)：void CFineDlg::OnConfirm() {// TODO: Add your control notification handler code here// UpdateData(TRUE)。// CWnd *pWnd。// pWnd = GetDlgItem(IDC_READER_ID)。江西理工大學(xué)應(yīng)用科學(xué)學(xué)院畢業(yè)設(shè)計(jì)53// pWndGetWindowText(m_strReaderId)。if (()){AfxMessageBox(請(qǐng)輸入讀者編碼！)。return。}CString mSqlStr。CDatabase mDB。if(!(_T(library)))AfxMessageBox(數(shù)據(jù)庫(kù)打開(kāi)出錯(cuò))。mSqlStr = UPDATE READER SET FLAG_BORROW=39。Y39。 WHERE READER_ID=39。 + m_szReaderID。mSqlStr = mSqlStr + 39。try{(mSqlStr)。}catch(CDBException e){AfxMessageBox(執(zhí)行錯(cuò)！)。return。}mSqlStr = DELETE FROM FINE WHERE READER_ID=39。 + m_szReaderID。陳敏峰：圖書(shū)管理系統(tǒng)54mSqlStr = mSqlStr + 3