readerdlg.cpp

学校图书馆信息化计划核心----图书管理系统vc版V2.0

			{
	        	iRow=1;
	             m_bookinged.MoveFirst();
            	   while(!m_bookinged.IsEOF())
				   {
	                	CString str;
	                	str.Format("预约%d",iRow);		
                		m_grid_booking.SetRow(iRow);
                 		m_grid_booking.SetCol(0);
                  		m_grid_booking.SetText(str);
                		m_grid_booking.SetCol(1);
                 		m_grid_booking.SetText(m_bookinged.m_Bookid_booking);
                		m_grid_booking.SetCol(2);
                		m_grid_booking.SetText(m_bookinged.m_Bookname_booking);
                 		str.Format(_T("%04d-%02d-%02d"),m_bookinged.m_Bookingdate.GetYear(),m_bookinged.m_Bookingdate.GetMonth(),m_bookinged.m_Bookingdate.GetDay());
                		m_grid_booking.SetCol(3);
                  		m_grid_booking.SetText(str);	
                		iRow++;
                 		m_bookinged.MoveNext();
				   } 
			}
	
           	UpdateData(false);
            m_bookinged.Close(); 
       }
     }	
}

void CReaderDlg::OnReset() 
{
	// TODO: Add your control notification handler code here
	m_readerid="";
	m_password="";
	UpdateData(false);
	
}

void CReaderDlg::OnNew() 
{
	// TODO: Add your control notification handler code here
	CNewReaderDlg NewDlg;
	NewDlg.DoModal();
}

BEGIN_EVENTSINK_MAP(CReaderDlg, CDialog)
    //{{AFX_EVENTSINK_MAP(CReaderDlg)
	ON_EVENT(CReaderDlg, IDC_MSFLEXGRID2, -605 /* MouseDown */, OnMouseDownMsflexgrid2, VTS_I2 VTS_I2 VTS_I4 VTS_I4)
	//}}AFX_EVENTSINK_MAP
END_EVENTSINK_MAP()

void CReaderDlg::OnMouseDownMsflexgrid2(short Button, short Shift, long x, long y) 
{
	// TODO: Add your control notification handler code here
	int i=m_grid_booking.GetMouseRow();
	m_grid_booking.SetRow(i);
	m_grid_booking.SetCol(1);
	bookid=m_grid_booking.GetText();
	
}

void CReaderDlg::OnCancelBooking() 
{
	// TODO: Add your control notification handler code here
	if(bookid=="")
		MessageBox("请先选择取消预约的书目!");
	else
	{
		m_bookinged.Open();
		UpdateData();
		m_bookinged.Close();
		m_bookinged.m_strFilter="Bookid_booking='"+bookid+"'";
		m_bookinged.Open();
		CRecordsetStatus status;
		m_bookinged.GetStatus(status);
	    m_bookinged.Delete();
		if(status.m_lCurrentRecord==0)
			m_bookinged.MoveNext();
		else 
			m_bookinged.MoveFirst();
		m_bookinged.Close();
		m_books.Open();
		UpdateData();
		m_books.Close();
		m_books.m_strFilter="Bookid='"+bookid+"'";
		m_books.Open();
		if(!m_books.IsEOF()){
			m_books.Edit();
			m_books.m_Status=1;
	        MessageBox("取消预约成功!");
		    m_books.Update();
			m_books.Requery();
		}
		UpdateData(false);
	   	m_books.Close();

	//display new table	
	m_bookinged.Open();
	UpdateData(true);
	m_bookinged.Close();
    m_bookinged.m_strFilter="ReaderId_booking='"+m_readerid+"'";
	m_bookinged.Open();
	int count=m_bookinged.GetRecordCount();
	number=0;
	if(count!=0)
	{
		m_bookinged.MoveFirst();
		while(!m_bookinged.IsEOF())
		{number++;m_bookinged.MoveNext();}
	}
	int iRow=1;
	if(count!=0)
	{
		iRow=1;
	    m_bookinged.MoveFirst();
	    while(!m_bookinged.IsEOF())
		{
	    CString str;
	   str.Format("预约%d",iRow);		
	   m_grid_booking.SetRow(iRow);
	   m_grid_booking.SetCol(0);
	   m_grid_booking.SetText(str);
	   m_grid_booking.SetCol(1);
	   m_grid_booking.SetText(m_bookinged.m_Bookid_booking);
	   m_grid_booking.SetCol(2);
	   m_grid_booking.SetText(m_bookinged.m_Bookname_booking);
	   str.Format(_T("%04d-%02d-%02d"),m_bookinged.m_Bookingdate.GetYear(),m_bookinged.m_Bookingdate.GetMonth(),m_bookinged.m_Bookingdate.GetDay());
	   m_grid_booking.SetCol(3);
	    m_grid_booking.SetText(str);	
		iRow++;
		m_bookinged.MoveNext();
		}
		 UpdateData(false);
	}

   	m_grid_booking.SetRow(number+1);
	m_grid_booking.SetCol(0);
	m_grid_booking.SetText("");
	m_grid_booking.SetCol(1);
	m_grid_booking.SetText("");
	m_grid_booking.SetCol(2);
	m_grid_booking.SetText("");
	m_grid_booking.SetCol(3);
	m_grid_booking.SetText("");
	m_grid_booking.SetCol(4);
	m_grid_booking.SetText("");
	m_grid_booking.SetCol(5);
	m_grid_booking.SetText("");
 	m_bookinged.Close();	
	 bookid="";
	 UpdateData(false);
	}

	
}

void CReaderDlg::OnSelchangeCOMBOSearchType() 
{
	// TODO: Add your control notification handler code here
	UpdateData();
	if(m_content=="")
		MessageBox("字段不能为空!");
	else {
		CSearchResultDlg resultdlg;
		resultdlg.content=m_content;
		resultdlg.readerid=m_readerid;
		resultdlg.type=m_searchtype.GetCurSel();
	    resultdlg.typedata=m_searchtype.GetItemData(resultdlg.type);
		resultdlg.DoModal();
	}
	flag_status=1;
	UpdateData(false);
	m_bookloan.Open();
	UpdateData(true);
	m_bookloan.Close();
    m_bookloan.m_strFilter="ReaderId_loan='"+m_readerid+"'";
	m_bookloan.Open();  
	CString status="正常";
	int iRow=1;
	int count=m_bookloan.GetRecordCount();
	CString str;
	str.Format("%d",count);
	if(count!=0)
	{
		m_bookloan.MoveFirst();
	
	    while(!m_bookloan.IsEOF())
		{
		CString str1;
		str.Format("记录%d",iRow);
		m_grid_loan.SetRow(iRow);m_grid_loan.SetCol(0);
		m_grid_loan.SetText(str);
		m_grid_loan.SetCol(1);
		m_grid_loan.SetText(m_bookloan.m_Bookid_loan);
		m_grid_loan.SetCol(2);
		m_grid_loan.SetText(m_bookloan.m_Bookname_loan);
		m_grid_loan.SetCol(3);
	
		str1.Format(_T("%04d-%02d-%02d"),m_bookloan.m_Loandate.GetYear(),m_bookloan.m_Loandate.GetMonth(),m_bookloan.m_Loandate.GetDay());
		m_grid_loan.SetText(str1);
		m_grid_loan.SetCol(4);
		str1.Format(_T("%04d-%02d-%02d"),m_bookloan.m_Backdate.GetYear(),m_bookloan.m_Backdate.GetMonth(),m_bookloan.m_Backdate.GetDay());
		m_grid_loan.SetText(str1);
		m_grid_loan.SetCol(5);
		CTime now;
         now=time(0);
   		if(now>m_bookloan.m_Backdate)
		{   status="超期";flag_status=0;}
		else status="正常";
		m_grid_loan.SetText(status);
		iRow++;
		m_bookloan.MoveNext();
		}
	}

	if(flag_status==1) status="正常";
	else status="超期";
	m_status="状态："+status;
	UpdateData(false);
	m_bookloan.Close();
		//预约 	
    m_bookinged.Open();
	UpdateData(true);
	m_bookinged.Close();
    m_bookinged.m_strFilter="ReaderId_booking='"+m_readerlogin.m_ReaderId+"'";
	m_bookinged.Open();
	count=m_bookinged.GetRecordCount();
	if(count!=0)
	{
		iRow=1;
	   m_bookinged.MoveFirst();
	   while(!m_bookinged.IsEOF())
	   {
		CString str;
		str.Format("预约%d",iRow);		
		m_grid_booking.SetRow(iRow);
		m_grid_booking.SetCol(0);
		m_grid_booking.SetText(str);
		m_grid_booking.SetCol(1);
		m_grid_booking.SetText(m_bookinged.m_Bookid_booking);
		m_grid_booking.SetCol(2);
		m_grid_booking.SetText(m_bookinged.m_Bookname_booking);
		str.Format(_T("%04d-%02d-%02d"),m_bookinged.m_Bookingdate.GetYear(),m_bookinged.m_Bookingdate.GetMonth(),m_bookinged.m_Bookingdate.GetDay());
		m_grid_booking.SetCol(3);
		m_grid_booking.SetText(str);	
		iRow++;
		m_bookinged.MoveNext();
	   } 
	}
	UpdateData(false);
    m_bookinged.Close(); 

	
}

void CReaderDlg::OnModify() 
{
	// TODO: Add your control notification handler code here
	 UpdateData();
	CModifyReaderDlg modlg;
		modlg.m_readerid=m_readerid;
		modlg.DoModal();
		UpdateData();
    m_message=modlg.m_name;
	m_message+="同学,欢迎你!";
    m_readerid_text=modlg.m_grade;
	m_major="专业：";
	m_majorname=modlg.m_major;
	m_email="Email:"+modlg.m_email;
	m_grade="年级： "+modlg.m_grade;
/*	if(m_readerlogin.m_Readermajor=="")
		m_majorname="未填";
    else m_majorname=modlg.m_major;
    if(m_readerlogin.m_Email=="")
		m_email="Email:  未填";
	else m_email="Email: "+modlg.m_email;
	if(m_readerlogin.m_Readergrade=="")
		m_grade="年级： 未填";
	else m_grade="年级： "+modlg.m_grade;*/
	UpdateData(false);


}