libraryview.cpp

图书管理系统,数据结构思想,用 C++编写,经测试,可用

		strTime=publishTime.Format(VAR_DATEVALUEONLY);
		m_ListView.SetItemText(i,4,strTime);
		
		m_ListView.SetItemText(i,5,m_BookSet.m_press);
		if(m_BookSet.m_borrowed)
			borrowed="是";
		else
			borrowed="否";
		m_ListView.SetItemText(i,6,borrowed);
		
		m_BookSet.MoveNext();
		i++;
	}
	
	if(m_ListView.GetItemCount()!=0)
		m_ListView.SetHotItem(0);
	
	m_BookSet.Close();
	
}

void CLibraryView::UserShow()
{
	//在列表中显示用户的信息
	int 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();
	while(!m_UserSet.IsEOF())
	{
		m_ListView.InsertItem(i,m_UserSet.m_userid);
		m_ListView.SetItemText(i,1,m_UserSet.m_identity);
		m_ListView.SetItemText(i,2,m_UserSet.m_username);
		m_ListView.SetItemText(i,3,m_UserSet.m_password);
		m_ListView.SetItemText(i,4,m_UserSet.m_sex);
		m_ListView.SetItemText(i,5,m_UserSet.m_type);
		m_ListView.SetItemText(i,6,m_UserSet.m_starttime.Format("%Y-%m-%d"));
		//格式化借书本数
		ltoa(m_UserSet.m_borrownum,buffer,10);
		m_ListView.SetItemText(i,7,buffer);
		m_ListView.SetItemText(i,8,m_UserSet.m_address);
		
		m_UserSet.MoveNext();
		i++;
	}
	
	if(m_ListView.GetItemCount()!=0)
		m_ListView.SetHotItem(0);
	
	m_UserSet.Close();
	
}

void CLibraryView::ManagerShow()
{
	//在列表中显示管理员的信息
	int i=0;
	
	if(!m_ManagerSet.IsOpen())
	{
		m_ManagerSet.m_strFilter="";
		m_ManagerSet.m_strSort="managerid";
		m_ManagerSet.Open();
		m_ManagerSet.MoveFirst();
	}
	
	m_ListView.DeleteAllItems();
	while(!m_ManagerSet.IsEOF())
	{
		m_ListView.InsertItem(i,m_ManagerSet.m_managerid);
		m_ListView.SetItemText(i,1,m_ManagerSet.m_managername);
		m_ListView.SetItemText(i,2,m_ManagerSet.m_password);
		m_ListView.SetItemText(i,3,m_ManagerSet.m_logintime.Format("%Y-%m-%d %H:%M:%S"));
		m_ListView.SetItemText(i,4,m_ManagerSet.m_logouttime.Format("%Y-%m-%d %H:%M:%S"));
		
		m_ManagerSet.MoveNext();
		i++;
	}

	if(m_ListView.GetItemCount()!=0)
		m_ListView.SetHotItem(0);

	m_ManagerSet.Close();
	
}

void CLibraryView::BorrowShow()
{
	//在列表中显示用户的借书纪录
	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")
		{
			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);
			
			m_ListView.SetItemText(i,4,m_BorrowSet.m_manageid);
			m_ListView.SetItemText(i,5,m_BorrowSet.m_borrowtime.Format("%Y-%m-%d"));
			m_ListView.SetItemText(i,6,m_BorrowSet.m_returntime.Format("%Y-%m-%d"));
		}
		m_BorrowSet.MoveNext();
		i++;
		
	}

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

void CLibraryView::InitBookShow()
{
	//初始化图书管理浏览列表
	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.InsertColumn(6,"借出");
	
	m_ListView.SetColumnWidth(0,100);
	m_ListView.SetColumnWidth(1,200);
	m_ListView.SetColumnWidth(2,100);
	m_ListView.SetColumnWidth(3,80);
	m_ListView.SetColumnWidth(4,100);
	m_ListView.SetColumnWidth(5,150);
	m_ListView.SetColumnWidth(6,50);

}

void CLibraryView::InitUserShow()
{
	//初始化用户管理浏览列表
	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.InsertColumn(6,"办证日期");
	m_ListView.InsertColumn(7,"已借本数");
	m_ListView.InsertColumn(8,"家庭住址");
	
	m_ListView.SetColumnWidth(0,100);
	m_ListView.SetColumnWidth(1,150);
	m_ListView.SetColumnWidth(2,100);
	m_ListView.SetColumnWidth(3,80);
	m_ListView.SetColumnWidth(4,50);
	m_ListView.SetColumnWidth(5,80);
	m_ListView.SetColumnWidth(6,100);
	m_ListView.SetColumnWidth(7,80);
	m_ListView.SetColumnWidth(8,150);

}

void CLibraryView::InitManagerShow()
{
	//初始化管理员管理浏览列表
	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,150);

}

void CLibraryView::InitBorrowShow()
{
	//初始化借阅管理浏览列表
	m_ListView.DeleteAllItems();
	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.InsertColumn(6,"应还日期");
	
	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);
	m_ListView.SetColumnWidth(5,100);
	m_ListView.SetColumnWidth(6,100);

}

void CLibraryView::OnSelchangeSelectTab(NMHDR* pNMHDR, LRESULT* pResult) 
{
	// TODO: Add your control notification handler code here
	//当属性页的选项发生变化时，列表中的纪录也随之发生变化
	InitListView();
	ListShow();
	
	*pResult = 0;
}

void CLibraryView::SaveLogoutTime()
{
	//纪录管理员的登出时间
	CTime m_LogoutTime;

	m_LogoutTime=CTime::GetCurrentTime();
	CLibraryApp *myApp=(CLibraryApp*)AfxGetApp();
	m_ManagerID=myApp->m_LoginID;

	m_ManagerSet.m_strFilter="managerid='"+m_ManagerID+"'";
	m_ManagerSet.Open();
	m_ManagerSet.Edit();
	m_ManagerSet.m_logouttime=m_LogoutTime;
	m_ManagerSet.Update();
	m_ManagerSet.Close();
	
}

void CLibraryView::OnDestroy() 
{
	CRecordView::OnDestroy();
	
	// TODO: Add your message handler code here
	//纪录管理员的登出时间
	SaveLogoutTime();
	
}

void CLibraryView::OnMoveFirst() 
{
	// TODO: Add your command handler code here
	//把浏览列表中的光标移动到第一条纪录
	m_ListView.SetHotItem(0);
	m_ListView.SetItemState(0,LVIS_FOCUSED,1);
	m_ListView.SetItemState(0,LVIS_SELECTED,2);

}

void CLibraryView::OnMovePrev() 
{
	// TODO: Add your command handler code here
	//把浏览列表中的光标往前移动一条纪录
	int nItem;
	nItem=m_ListView.GetHotItem()-1;
	if(nItem>=0)
	{
		m_ListView.SetHotItem(nItem);
		m_ListView.SetItemState(nItem,LVIS_FOCUSED,1);
		m_ListView.SetItemState(nItem,LVIS_SELECTED,2);	
	}
	
}

void CLibraryView::OnMoveNext() 
{
	// TODO: Add your command handler code here
	//把浏览列表中的光标往后移动一条纪录
	int nItem;
	int sumItem;
	sumItem=m_ListView.GetItemCount();
	nItem=m_ListView.GetHotItem()+1;
	if(nItem<=sumItem)
	{
		m_ListView.SetHotItem(nItem);
		m_ListView.SetItemState(nItem,LVIS_FOCUSED,1);
		m_ListView.SetItemState(nItem,LVIS_SELECTED,2);	
	}
	
}

void CLibraryView::OnMoveLast() 
{
	// TODO: Add your command handler code here
	//把浏览列表中的光标移动到最后一条纪录
	int nItem;
	nItem=m_ListView.GetItemCount()-1;
	m_ListView.SetHotItem(nItem);
	m_ListView.SetItemState(nItem,LVIS_FOCUSED,1);
	m_ListView.SetItemState(nItem,LVIS_SELECTED,2);	
		
}