jhistory2.cpp

“图书馆书籍检索与借阅管理系统”软件旨在为在校学生提供一个功能全面、使用方便的个人数据库系统

// JHistory2.cpp : implementation file
//

#include "stdafx.h"
#include "work.h"
#include "JHistory2.h"
#include "CommonData.h"

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

/////////////////////////////////////////////////////////////////////////////
// CJHistory2 dialog


CJHistory2::CJHistory2(CWnd* pParent /*=NULL*/)
	: CDialog(CJHistory2::IDD, pParent)
{
	//{{AFX_DATA_INIT(CJHistory2)
		// NOTE: the ClassWizard will add member initialization here
	//}}AFX_DATA_INIT
}


void CJHistory2::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CJHistory2)
	DDX_Control(pDX, IDC_JHistory2_LIST, m_JHistory2_List);
	//}}AFX_DATA_MAP
}


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

/////////////////////////////////////////////////////////////////////////////
// CJHistory2 message handlers

BOOL CJHistory2::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here

	LV_COLUMN h;
	h.mask=LVCF_FMT|LVCF_TEXT|LVCF_WIDTH;
	h.fmt=LVCFMT_CENTER;
	h.cx=110;

	h.pszText="书目名称";
	m_JHistory2_List.InsertColumn(0,&h);
	h.pszText="条码号";
	m_JHistory2_List.InsertColumn(1,&h);
	h.pszText="借书时间";
	m_JHistory2_List.InsertColumn(2,&h);
	h.pszText="应还时间";
	m_JHistory2_List.InsertColumn(3,&h);

	_RecordsetPtr m_pRecordset;
	m_pRecordset.CreateInstance("ADODB.Recordset");
	CString QueryString;
	QueryString="SELECT * FROM Book_Borrow_Infor WHERE BSNumber ='"+CCommonData::userNumber+"'";
	try
	{
		m_pRecordset->Open((LPCTSTR)QueryString,_variant_t((IDispatch *)m_pConnection,true),adOpenStatic,adLockOptimistic,adCmdText);
	}
	catch(_com_error& e)
	{
		MessageBox(e.Description());
	}

	bool have=false;
	int i=0;
	if(!m_pRecordset->BOF)
	{
		m_pRecordset->MoveFirst();
		while(!m_pRecordset->adoEOF)
		{
			CString BIsReturned,BBorrowDate,BReturnDate,tiaoma,bookname,BPreDate;
			BIsReturned=(LPCTSTR)_bstr_t(m_pRecordset->GetCollect("BIsReturned"));
			tiaoma=(LPCTSTR)_bstr_t(m_pRecordset->GetCollect("BNTiaoMa"));
			BPreDate=(LPCTSTR)_bstr_t(m_pRecordset->GetCollect("BPreDate"));
			have=true;

			if(BPreDate=="3000-1-1")
			{
			//得到书籍名称
				_RecordsetPtr m_pRecordset1;
				CString QueryString1="SELECT * FROM Book_Infor WHERE BNTiaoMa='"+tiaoma+"'";
				m_pRecordset1.CreateInstance("ADODB.Recordset");
				m_pRecordset1->Open((LPCTSTR)QueryString1,_variant_t((IDispatch *)m_pConnection,true),adOpenStatic,adLockOptimistic,adCmdText);
				m_pRecordset1->MoveFirst();
				bookname=(LPCTSTR)_bstr_t(m_pRecordset1->GetCollect("BName"));
				m_pRecordset1->Close();

				//借阅归还日期
				BBorrowDate=(LPCTSTR)_bstr_t(m_pRecordset->GetCollect("BBorrowDate"));
				BReturnDate=(LPCTSTR)_bstr_t(m_pRecordset->GetCollect("BReturnDate"));

				//插入
				m_JHistory2_List.InsertItem(i,bookname);
				m_JHistory2_List.SetItemText(i,1,tiaoma);
				m_JHistory2_List.SetItemText(i,2,BBorrowDate);
				m_JHistory2_List.SetItemText(i,3,BReturnDate);

				i++;
			}
			m_pRecordset->MoveNext();
		}
	}
	
	if(have==false)
	{
		MessageBox("当前无借阅书籍!");
	}

	m_pRecordset->Close();
	
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}