libview.cpp

小图书馆管理系统

	while(!m_UserSet.IsEOF())
	{
		m_ListView.InsertItem(i,m_UserSet.m_userid);
		m_ListView.SetItemText(i,1,m_UserSet.m_username);
		m_ListView.SetItemText(i,2,m_UserSet.m_majorid);
		m_ListView.SetItemText(i,3,m_UserSet.m_phone);
		//格式化借书本数
		ltoa(m_UserSet.m_borrownum,buffer,10);
		m_ListView.SetItemText(i,4,buffer);
		
		m_UserSet.MoveNext();
		i++;
	}
	
	if(m_ListView.GetItemCount()!=0)
		m_ListView.SetHotItem(0);
	
	m_UserSet.Close();
}

void CLibView::OnLateShow() 
{
	
	// TODO: Add your command handler code here
	InitBorrowShow();
	BorrowShow(1);
}

void CLibView::OnBorrow() 
{
	// TODO: Add your command handler code here
	CBorrowDlg m_dlg;
	m_dlg.DoModal();	
	//m_dlg.m_Button.SetWindowText("借出");
}

void CLibView::OnRecord() 
{
	// TODO: Add your command handler code here
	 InitBorrowShow();
     BorrowShow(0);
}

void CLibView::OnReturn() 
{
	// TODO: Add your command handler code here
	CReturnDlg m_dlg;
    //m_dlg.m_Button.SetWindowText("归还");
	m_dlg.DoModal();
}

void CLibView::OnSum() 
{
	// TODO: Add your command handler code here
	isSum=1;
	m_1="输入专业号";
	m_Check.SetWindowText("统计");
	UpdateData(false);
}

void CLibView::OnCheck() 
{
	// TODO: Add your control notification handler code here
    UpdateData();
	if (isSum==0)
	{
		if (FindBook()==0)
		{
		AfxMessageBox("对不起!没有找到你所要的");		
		}	   
	}
	else        
		if (CheckValid())
		{
         InitMajorShow();
	     MajorShow();
		} 
}

void CLibView::OnSearch() 
{
	// TODO: Add your command handler code here
	isSum=0;
	m_1="输入书名:";
    UpdateData(false);
	m_Check.SetWindowText("全库检索");
}
BOOL CLibView::CheckValid()
{  
	//检查输入的合法性
    m_UserSet.Open();
	m_UserSet.m_strFilter="majorid='"+m_Edit+"'";
	m_UserSet.Requery();
	if(m_UserSet.GetRecordCount()==0)
	{
		AfxMessageBox("您的专业号输入有误，请重新输入！");
	    GetDlgItem(IDC_EDIT1)->SetFocus();
		m_UserSet.Close();
		return false;
	}
    m_UserSet.Close();
    return true;
}
void CLibView::CheckDate()
{
    CRefreshDate m_Refresh;
    m_Refresh.Open();
    m_Refresh.MoveFirst();
//	m_Refresh.m_refreshdate
    CTimeSpan m_span;
    CTime CurrentTime;
	CurrentTime=CTime::GetCurrentTime();
	m_span=CurrentTime-m_Refresh.m_refreshdate;
	long span=m_span.GetDays();
    m_Refresh.Edit();
    m_Refresh.m_refreshdate=CurrentTime;
	m_Refresh.Update();
	//chang return date
     m_BorrowSet.Open();
      m_BorrowSet.MoveFirst();
  	while(!m_BorrowSet.IsEOF())
	{
 		 if ( (m_BorrowSet.m_userid!="null")&&
            (m_BorrowSet.m_remaindate<999) )
		{
        m_BorrowSet.Edit();
     	m_BorrowSet.m_remaindate-=span;	
        m_BorrowSet.Update();
		}
      m_BorrowSet.MoveNext();
	}
	///////////////
     m_BorrowSet.Close();
     m_Refresh.Close();

}

void CLibView::InitMajorShow()
{

     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.InsertColumn(6,"被借次数");

	m_ListView.SetColumnWidth(0,80);
	m_ListView.SetColumnWidth(1,200);
	m_ListView.SetColumnWidth(2,100);
	m_ListView.SetColumnWidth(3,80);
	m_ListView.SetColumnWidth(4,100);
	m_ListView.SetColumnWidth(5,80);
    m_ListView.SetColumnWidth(6,100);
	m_ListView.DeleteAllItems();
	//初始化图书借的次数
	if(!m_BookSet.IsOpen())
	{
		m_BookSet.m_strSort="bookid";
		m_BookSet.m_strFilter="";
		m_BookSet.Open();
		m_BookSet.MoveFirst();
	}
    while(!m_BookSet.IsEOF())
	{
        m_BookSet.Edit();
	    m_BookSet.m_borrowtimes=0;
        m_BookSet.Update();
        m_BookSet.MoveNext();	
	}
	//累计借书次数
	if(!m_UserSet.IsOpen()) m_UserSet.Open();
	if(!m_BorrowSet.IsOpen())
	{
     m_BorrowSet.Open();
     m_BorrowSet.m_strFilter="";
     m_BorrowSet.MoveFirst();  
	}
       	while(!m_BorrowSet.IsEOF())
		{
		  if (m_BorrowSet.m_userid!="null")
		  {   
            m_UserSet.m_strFilter="userid='"+m_BorrowSet.m_userid+"'";	
            m_UserSet.Requery();
			if (m_UserSet.m_majorid==m_Edit)
			{
			  m_BookSet.m_strFilter="bookid='"+m_BorrowSet.m_bookid+"'";	
              m_BookSet.Requery();
 	          m_BookSet.Edit();
              m_BookSet.m_borrowtimes++;
             if( !m_BookSet.Update() );
			}
		  }  
    	  m_BorrowSet.MoveNext();		
		}
	m_UserSet.Close(); 
    m_BorrowSet.Close();
	m_BookSet.Close();

}
void CLibView::MajorShow()
{//在列表中按专业显示用户的借书纪录
	char buffer[20];
	int strLength;
	COleDateTime publishTime;
	CString strTime;
	CString bookPrice;
	int i=0;
       m_BookSet.m_strSort="borrowtimes DESC";         
        m_BookSet.m_strFilter="";
		m_BookSet.Open();
		m_BookSet.MoveFirst();	

	while(!m_BookSet.IsEOF())
	{
        //AfxMessageBox(m_BookSet.m_bookid);
		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);
		ltoa(m_BookSet.m_borrowtimes,buffer,10);
		m_ListView.SetItemText(i,6,buffer);

		m_BookSet.MoveNext();
		i++;
	}
	
	if(m_ListView.GetItemCount()!=0)
		m_ListView.SetHotItem(0);
   m_BookSet.Close();

}
int CLibView::FindBook()
{
//初始化管理员管理浏览列表
    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 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())
	{   
		if (m_BookSet.m_bookname.FindOneOf(m_Edit)!=-1)
		{

		  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);
		  i++;
		}
		m_BookSet.MoveNext();		
	}
	
	if(m_ListView.GetItemCount()!=0)
	{
		m_ListView.SetHotItem(0);
        m_BookSet.Close();
	    return m_ListView.GetItemCount();
	}	
	m_BookSet.Close();
    return 0;
}