?? 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();
//使價格只保留兩位小數(shù)
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,"專業(yè)號");
m_ListView.InsertColumn(3,"電話號碼");
m_ListView.InsertColumn(4,"已借本數(shù)");
//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];//用于存放格式化后的借書本數(shù)
if(!m_UserSet.IsOpen())
{
m_UserSet.m_strSort="userid";
m_UserSet.m_strFilter="";
m_UserSet.Open();
m_UserSet.MoveFirst();
}
m_ListView.DeleteAllItems();
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -