libview.cpp

小图书馆管理系统

// LibView.cpp : implementation of the CLibView class
//
#include "stdafx.h"
#include "Lib.h"
#include "MainFrm.h"
#include "LibSet.h"
#include "LibDoc.h"
#include "LibView.h"
#include "BorrowSet.h"
#include "UserSet.h"
#include "BookSet.h"
#include "Borrowdlg.h"
#include "ReturnDlg.h"
#include "RefreshDate.h"

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

/////////////////////////////////////////////////////////////////////////////
// CLibView

IMPLEMENT_DYNCREATE(CLibView, CRecordView)

BEGIN_MESSAGE_MAP(CLibView, CRecordView)
	//{{AFX_MSG_MAP(CLibView)
	ON_COMMAND(ID_BOOK_SHOW, OnBookShow)
	ON_COMMAND(ID_USER_SHOW, OnUserShow)
	ON_COMMAND(ID_LATE_SHOW, OnLateShow)
	ON_COMMAND(ID_BORROW, OnBorrow)
	ON_COMMAND(ID_RECORD, OnRecord)
	ON_COMMAND(ID_RETURN, OnReturn)
	ON_COMMAND(ID_SUM, OnSum)
	ON_BN_CLICKED(IDC_BUTTON1, OnCheck)
	ON_COMMAND(ID_SEARCH, OnSearch)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CLibView construction/destruction

CLibView::CLibView()
	: CRecordView(CLibView::IDD)
{
	//{{AFX_DATA_INIT(CLibView)
	m_pSet = NULL;
	m_1 = _T("");
	m_Edit = _T("");
	//}}AFX_DATA_INIT
	// TODO: add construction code here
    isSum=0;
}

CLibView::~CLibView()
{
}

void CLibView::DoDataExchange(CDataExchange* pDX)
{
	CRecordView::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CLibView)
	DDX_Control(pDX, IDC_BUTTON1, m_Check);
	DDX_Control(pDX, IDC_LIST1, m_ListView);
	DDX_Text(pDX, IDC_TEXT, m_1);
	DDX_Text(pDX, IDC_EDIT1, m_Edit);
	//}}AFX_DATA_MAP
}

BOOL CLibView::PreCreateWindow(CREATESTRUCT& cs)
{
	// TODO: Modify the Window class or styles here by modifying
	//  the CREATESTRUCT cs

	return CRecordView::PreCreateWindow(cs);
}

void CLibView::OnInitialUpdate()
{
	m_pSet = &GetDocument()->m_libSet;
	CRecordView::OnInitialUpdate();
	GetParentFrame()->RecalcLayout();
	ResizeParentToFit();
	//刷新借期列表
    CheckDate();
    //初始化列表
    m_Count=0;
   m_1="输入书名:";
   isSum=0;
   UpdateData(false);
   InitBorrowShow();
    BorrowShow(0);
}
/////////////////////////////////////////////////////////////////////////////
// CLibraryView printing

BOOL CLibView::OnPreparePrinting(CPrintInfo* pInfo)
{
	// default preparation
	return DoPreparePrinting(pInfo);
}
;
/////////////////////////////////////////////////////////////////////////////
// CLibView diagnostics

#ifdef _DEBUG
void CLibView::AssertValid() const
{
	CRecordView::AssertValid();
}

void CLibView::Dump(CDumpContext& dc) const
{
	CRecordView::Dump(dc);
}

CLibDoc* CLibView::GetDocument() // non-debug version is inline
{
	ASSERT(m_pDocument->IsKindOf(RUNTIME_CLASS(CLibDoc)));
	return (CLibDoc*)m_pDocument;
}
#endif //_DEBUG

/////////////////////////////////////////////////////////////////////////////
// CLibView database support
CRecordset* CLibView::OnGetRecordset()
{
	return m_pSet;
}


/////////////////////////////////////////////////////////////////////////////
// CLibView message handlers
void CLibView::InitBorrowShow()
{
	//初始化借阅管理浏览列表
    for (int i=0;i<m_Count;i++) m_ListView.DeleteColumn(0);
	m_Count=5;
	m_ListView.SetExtendedStyle(LVS_EX_FULLROWSELECT|LVS_EX_GRIDLINES);
	m_ListView.InsertColumn(0,"借书证号");
	m_ListView.InsertColumn(1,"姓名");
	m_ListView.InsertColumn(2,"书号");
	m_ListView.InsertColumn(3,"书名");
	m_ListView.InsertColumn(4,"剩余借期");
	
	m_ListView.SetColumnWidth(0,100);
	m_ListView.SetColumnWidth(1,100);
	m_ListView.SetColumnWidth(2,100);
	m_ListView.SetColumnWidth(3,150);
	m_ListView.SetColumnWidth(4,100);


}

void CLibView::BorrowShow(int style)
{
	char buffer[20];
	//在列表中显示用户的借书纪录
	int i=0;
	m_BorrowSet.m_strSort="userid";
	m_BorrowSet.m_strFilter="";
	m_BorrowSet.Open();
	if(m_BorrowSet.GetRecordCount()==0)
	{
		m_BorrowSet.Close();
		return;
	}

	m_BorrowSet.MoveFirst();
	m_UserSet.Open();
	m_BookSet.Open();
    m_ListView.DeleteAllItems();
	while(!m_BorrowSet.IsEOF())
	{
		if (  (m_BorrowSet.m_userid!="null")&&
			 ((style==0)||
		((m_BorrowSet.m_remaindate<100)&&(style==1)&&(m_BorrowSet.m_remaindate<0)) ))
		{
			m_ListView.InsertItem(i,m_BorrowSet.m_userid);
			m_UserSet.m_strFilter="userid='"+m_BorrowSet.m_userid+"'";
			m_UserSet.Requery();
			m_ListView.SetItemText(i,1,m_UserSet.m_username);
			m_ListView.SetItemText(i,2,m_BorrowSet.m_bookid);
			m_BookSet.m_strFilter="bookid='"+m_BorrowSet.m_bookid+"'";
			m_BookSet.Requery();
			m_ListView.SetItemText(i,3,m_BookSet.m_bookname);
			//
			if (m_BorrowSet.m_remaindate==1000)
				m_ListView.SetItemText(i,4,"已损坏");
			 else
             if (m_BorrowSet.m_remaindate==999)
				m_ListView.SetItemText(i,4,"已归还");
 			 else
			 {
			  ltoa(m_BorrowSet.m_remaindate,buffer,10);
			  m_ListView.SetItemText(i,4,buffer);
			 }
			
  /////////////////////////////////////
          i++; 
		}
		m_BorrowSet.MoveNext();
		
		
	}

	m_UserSet.Close();
	m_BookSet.Close();
	m_BorrowSet.Close();
	
}

void CLibView::OnBookShow() 
{
    //初始化管理员管理浏览列表
    for (int i=0;i<m_Count;i++) m_ListView.DeleteColumn(0);
	m_Count=6;
    m_ListView.SetExtendedStyle(LVS_EX_FULLROWSELECT|LVS_EX_GRIDLINES);
	m_ListView.InsertColumn(0,"书号");
	m_ListView.InsertColumn(1,"书名");
	m_ListView.InsertColumn(2,"作者");
	m_ListView.InsertColumn(3,"价格");
	m_ListView.InsertColumn(4,"出版社");
	m_ListView.InsertColumn(5,"库本剩余");
	
	m_ListView.SetColumnWidth(0,100);
	m_ListView.SetColumnWidth(1,200);
	m_ListView.SetColumnWidth(2,100);
	m_ListView.SetColumnWidth(3,80);
	m_ListView.SetColumnWidth(4,150);
	m_ListView.SetColumnWidth(5,80);
	//在列表中显示图书的信息
	i=0;
	int strLength;
	char buffer[20];
	COleDateTime publishTime;
	CString borrowed;
	CString strTime;
	CString bookPrice;
	
	if(!m_BookSet.IsOpen())
	{
		m_BookSet.m_strSort="bookid";
		m_BookSet.m_strFilter="";
		m_BookSet.Open();
		m_BookSet.MoveFirst();
	}
	
	m_ListView.DeleteAllItems();
	while(!m_BookSet.IsEOF())
	{
		m_ListView.InsertItem(i,m_BookSet.m_bookid);
		m_ListView.SetItemText(i,1,m_BookSet.m_bookname);
		m_ListView.SetItemText(i,2,m_BookSet.m_author);
		
		bookPrice=m_BookSet.m_price;
		strLength=bookPrice.GetLength();
		//使价格只保留两位小数
		bookPrice=bookPrice.Left(strLength-2);
		m_ListView.SetItemText(i,3,bookPrice);
		strTime=publishTime.Format(VAR_DATEVALUEONLY);
		m_ListView.SetItemText(i,4,m_BookSet.m_press);
		ltoa(m_BookSet.m_remain,buffer,10);
		m_ListView.SetItemText(i,5,buffer);
		
		m_BookSet.MoveNext();
		i++;
	}
	
	if(m_ListView.GetItemCount()!=0)
		m_ListView.SetHotItem(0);
	
	m_BookSet.Close();

		
}
/////////////////////////////////////////////////////////////////////////////
void CLibView::OnUserShow() 
{   
	// TODO: Add your command handler code here
		// TODO: Add your command handler code here
    	//初始化用户管理浏览列表
     for (int i=0;i<m_Count;i++) m_ListView.DeleteColumn(0);
    m_Count=5;
	m_ListView.SetExtendedStyle(LVS_EX_FULLROWSELECT|LVS_EX_GRIDLINES);
	m_ListView.InsertColumn(0,"借书证号");
	m_ListView.InsertColumn(1,"姓名");
	m_ListView.InsertColumn(2,"专业号");
	m_ListView.InsertColumn(3,"电话号码");
	m_ListView.InsertColumn(4,"已借本数");
	//m_ListView.InsertColumn(5,"");

	m_ListView.SetColumnWidth(0,100);
	m_ListView.SetColumnWidth(1,150);
	m_ListView.SetColumnWidth(2,100);
	m_ListView.SetColumnWidth(3,100);
	m_ListView.SetColumnWidth(4,200);
	



	//在列表中显示用户的信息
	 i=0;
	char buffer[20];//用于存放格式化后的借书本数
	if(!m_UserSet.IsOpen())
	{
		m_UserSet.m_strSort="userid";
		m_UserSet.m_strFilter="";
		m_UserSet.Open();
		m_UserSet.MoveFirst();
	}
	
	m_ListView.DeleteAllItems();