libview.cpp

音像管理系统

	m_ListView.DeleteAllItems();
	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(true);
	if (isSum==0)
	{
		if (Findmovie()==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=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);
	



	//在列表中显示用户的信息
	 int i=0;
	char buffer[20];//用于存放格式化后的租碟数
	if(!m_UserSet.IsOpen())
	{
		m_UserSet.m_strSort="userid";
		m_UserSet.m_strFilter="majorid='"+m_Edit+"'";
		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_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();
    m_BorrowSet.Close();
	m_movieSet.Close();

}
void CLibView::MajorShow()
{//在列表中按权限显示用户的租碟纪录
	char buffer[20];
	int strLength;
	COleDateTime time;
	CString strTime;
	CString moviePrice;
	int i=0;
       m_movieSet.m_strSort="borrowtimes DESC";         
        m_movieSet.m_strFilter="";
		m_movieSet.Open();
		m_movieSet.MoveFirst();	

	while(!m_movieSet.IsEOF())
	{
        //AfxMessageBox(m_movieSet.m_movieid);
		m_ListView.InsertItem(i,m_movieSet.m_movieid);
		m_ListView.SetItemText(i,1,m_movieSet.m_moviename);
		m_ListView.SetItemText(i,2,m_movieSet.m_performer);
		
		moviePrice=m_movieSet.m_price;
		strLength=moviePrice.GetLength();
		//使价格只保留两位小数
		moviePrice=moviePrice.Left(strLength-2);
		m_ListView.SetItemText(i,3,moviePrice);
		strTime=time.Format(VAR_DATEVALUEONLY);
		m_ListView.SetItemText(i,4,m_movieSet.m_director );
		ltoa(m_movieSet.m_remain,buffer,10);
		m_ListView.SetItemText(i,5,buffer);
		ltoa(m_movieSet.m_borrowtimes,buffer,10);
		m_ListView.SetItemText(i,6,buffer);

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

}
int CLibView::Findmovie()
{
//初始化管理员管理浏览列表
    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);
	//在列表中显示影碟的信息
	int i=0;
	int strLength;
	char buffer[20];
	COleDateTime time;
	CString strTime;
	CString moviePrice;
	if(!m_movieSet.IsOpen())
	{
		m_movieSet.m_strSort="movieid";
		m_movieSet.m_strFilter="";
		m_movieSet.Open();
		m_movieSet.MoveFirst();
	}
	
	m_ListView.DeleteAllItems();
	while(!m_movieSet.IsEOF())
	{   
		if (m_movieSet.m_moviename.FindOneOf(m_Edit)!=-1)
		{

		  m_ListView.InsertItem(i,m_movieSet.m_movieid);
		  m_ListView.SetItemText(i,1,m_movieSet.m_moviename);
		  m_ListView.SetItemText(i,2,m_movieSet.m_performer);
		
	    	moviePrice=m_movieSet.m_price;
		  strLength=moviePrice.GetLength();
		  //使价格只保留两位小数
		  moviePrice=moviePrice.Left(strLength-2);
		  m_ListView.SetItemText(i,3,moviePrice);
		  strTime=time.Format(VAR_DATEVALUEONLY);
		  m_ListView.SetItemText(i,4,m_movieSet.m_director );
		  ltoa(m_movieSet.m_remain,buffer,10);
		  m_ListView.SetItemText(i,5,buffer);
		  i++;
		}
		m_movieSet.MoveNext();		
	}
	
	if(m_ListView.GetItemCount()!=0)
	{
		m_ListView.SetHotItem(0);
        m_movieSet.Close();
	    return m_ListView.GetItemCount();
	}	
	m_movieSet.Close();
    return 0;
}

void CLibView::OnStnClickedText()
{
	// TODO: 在此添加控件通知处理程序代码
}

void CLibView::OnLvnItemchangedList1(NMHDR *pNMHDR, LRESULT *pResult)
{
	LPNMLISTVIEW pNMLV = reinterpret_cast<LPNMLISTVIEW>(pNMHDR);
	// TODO: 在此添加控件通知处理程序代码
	*pResult = 0;
}