jhistory1.cpp

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

// JHistory1.cpp : implementation file
//

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

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

/////////////////////////////////////////////////////////////////////////////
// CJHistory1 dialog


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


void CJHistory1::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CJHistory1)
	DDX_Control(pDX, IDC_JHistory1_LIST, m_JHistory1_List);
	//}}AFX_DATA_MAP
}


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

/////////////////////////////////////////////////////////////////////////////
// CJHistory1 message handlers

BOOL CJHistory1::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_JHistory1_List.InsertColumn(0,&h);
	h.pszText="条码号";
	m_JHistory1_List.InsertColumn(1,&h);
	h.pszText="借书时间";
	m_JHistory1_List.InsertColumn(2,&h);
	h.pszText="应还时间";
	m_JHistory1_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;
			BIsReturned=(LPCTSTR)_bstr_t(m_pRecordset->GetCollect("BIsReturned"));
			tiaoma=(LPCTSTR)_bstr_t(m_pRecordset->GetCollect("BNTiaoMa"));
			if(BIsReturned=="0")
			{
				have=true;
				//得到书籍名称
				_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_JHistory1_List.InsertItem(i,bookname);
				m_JHistory1_List.SetItemText(i,1,tiaoma);
				m_JHistory1_List.SetItemText(i,2,BBorrowDate);
				m_JHistory1_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
}