📄 searchresultdlg.cpp

📁 学校图书馆信息化计划核心----图书管理系统vc版V2.0
💻 CPP
字号:
// SearchResultDlg.cpp : implementation file
//

#include "stdafx.h"
#include "library.h"
#include "SearchResultDlg.h"
#include "ReaderDlg.h"
#include "BookLibSet.h"
#include "BookingSet.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

/////////////////////////////////////////////////////////////////////////////
// CSearchResultDlg dialog

CBookLibSet m_book2;
CBookingSet m_booking2;
int count;
CString bookid2="";
CSearchResultDlg::CSearchResultDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CSearchResultDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CSearchResultDlg)
	m_type = _T("");
	m_id = _T("");
	m_result = _T("");
	//}}AFX_DATA_INIT
}


void CSearchResultDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CSearchResultDlg)
	DDX_Control(pDX, IDC_MSFLEXGRID1, m_grid_result);
	DDX_Text(pDX, IDC_type, m_type);
	DDX_Text(pDX, IDC_ID, m_id);
	DDX_Text(pDX, IDC_Result, m_result);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CSearchResultDlg, CDialog)
	//{{AFX_MSG_MAP(CSearchResultDlg)
	ON_BN_CLICKED(IDC_Booking, OnBooking)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CSearchResultDlg message handlers

BOOL CSearchResultDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
   m_book2.Open();
   UpdateData();
   m_book2.Close();
   m_type="检索方式：";
   switch(type)
   {
   case 2:m_book2.m_strFilter="Bookname='"+content+"'";
	   m_type+="按书名检索";break;
   case 4:m_book2.m_strFilter="Bookauthor='"+content+"'";
	   m_type+="按作者检索";break;
   case 3:m_book2.m_strFilter="Bookid='"+content+"'";
	   m_type+="按书目号检索";break;
   case 0:m_book2.m_strFilter="Bookconcern='"+content+"'";
	   m_type+="按出版社检索";break;
   case 1:m_book2.m_strFilter="Typeid='"+content+"'";
	   m_type+="按登陆号检索";break;
   }
   m_id="检索关键字："+content;
   m_book2.Open();
   m_grid_result.SetCols(6);
   m_grid_result.SetRows(50);
   m_grid_result.SetRow(0);
   m_grid_result.SetCol(0);
   m_grid_result.SetText("书目登录号");
   m_grid_result.SetCol(1);
   m_grid_result.SetText("书名");
   m_grid_result.SetCol(2);
   m_grid_result.SetText("作者");
   m_grid_result.SetCol(3);
   m_grid_result.SetText("出版社");
   m_grid_result.SetCol(4);
   m_grid_result.SetText("入库日期");
   m_grid_result.SetCol(5);
   m_grid_result.SetText("借阅状态");
   int irow=1;
   count=m_book2.GetRecordCount();
   if(count!=0)
   {m_book2.MoveFirst();
      while(!m_book2.IsEOF())
	  {
	   m_grid_result.SetRow(irow);
	   m_grid_result.SetCol(0);
	   m_grid_result.SetText(m_book2.m_Bookid);
	   m_grid_result.SetCol(1);
	   m_grid_result.SetText(m_book2.m_Bookname);
	   m_grid_result.SetCol(2);
	   m_grid_result.SetText(m_book2.m_Bookauthor);
	   m_grid_result.SetCol(3);
	   m_grid_result.SetText(m_book2.m_Bookconcern);
	   m_grid_result.SetCol(4);
	   CString str;
	   str.Format(_T("%04d-%02d-%02d"),m_book2.m_Inputdate.GetYear(),m_book2.m_Inputdate.GetMonth(),m_book2.m_Inputdate.GetDay());
	   m_grid_result.SetText(str);
	   m_grid_result.SetCol(5);	   
	   
        if(m_book2.m_Status==1)
			str="可供出借";
		else if(m_book2.m_Status==2)
			str="已被预约";
		else  str="已借出";
	   m_grid_result.SetText(str);
	   irow++;
	   m_book2.MoveNext();
	  }
	  count=irow-1;
   }
   CString re;
   re.Format("%d",count);
   m_result="搜索结果"+re+" 本书";
   m_book2.Close();
   UpdateData(false);
	
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

BEGIN_EVENTSINK_MAP(CSearchResultDlg, CDialog)
    //{{AFX_EVENTSINK_MAP(CSearchResultDlg)
	ON_EVENT(CSearchResultDlg, IDC_MSFLEXGRID1, -605 /* MouseDown */, OnMouseDownMsflexgrid1, VTS_I2 VTS_I2 VTS_I4 VTS_I4)
	//}}AFX_EVENTSINK_MAP
END_EVENTSINK_MAP()

void CSearchResultDlg::OnMouseDownMsflexgrid1(short Button, short Shift, long x, long y) 
{
	// TODO: Add your control notification handler code here
	int i=m_grid_result.GetMouseRow();
	m_grid_result.SetRow(i);
	m_grid_result.SetCol(0);
	bookid2=m_grid_result.GetText();	
}

void CSearchResultDlg::OnBooking() 
{
	// TODO: Add your control notification handler code here
	if(bookid2=="")
		MessageBox("请先选择需要预约的书目!");
	else
	{
		m_book2.Open();
		UpdateData();
		m_book2.Close();
		m_book2.m_strFilter="Bookid='"+bookid2+"'";
		m_book2.Open();
	  	if(m_book2.m_Status==2)
		   MessageBox("此书已被人预约!");
		else if(m_book2.m_Status==0)
			MessageBox("此书已出借，不能预约!");
	   else 
	   {
		   m_book2.Edit();
		   m_book2.m_Status=2;
      time_t now;
	  now=time(0);
	  struct tm *pnow;
      pnow=localtime(&now);
	  m_booking2.Open();
	  m_booking2.AddNew();
	  m_booking2.m_Bookid_booking=m_book2.m_Bookid;
	  m_booking2.m_Bookingdate=now;
	  m_booking2.m_Bookname_booking=m_book2.m_Bookname;
	  m_booking2.m_ReaderId_booking=readerid;
	  m_booking2.Update();
	  m_booking2.Requery(); 
	  MessageBox("预约成功!");
	  m_booking2.Close();
	  m_book2.Update();
	  m_book2.Requery();
	  }
	  UpdateData(false);
	  m_book2.Close();
	  //refresh the display
	   m_book2.Open();
   UpdateData();
   m_book2.Close();
   m_type="检索方式：";
   switch(type)
   {
   case 1:m_book2.m_strFilter="Bookname='"+content+"'";
	   m_type+="按书名检索";break;
   case 3:m_book2.m_strFilter="Bookauthor='"+content+"'";
	   m_type+="按作者检索";break;
   case 2:m_book2.m_strFilter="Bookid='"+content+"'";
	   m_type+="按书目号检索";break;
   case 0:m_book2.m_strFilter="Bookconcern='"+content+"'";
	   m_type+="按出版社检索";break;
   }
   m_id="检索关键字："+content;
   m_book2.Open();
   m_grid_result.SetCols(6);
   m_grid_result.SetRows(50);
   m_grid_result.SetRow(0);
   m_grid_result.SetCol(0);
   m_grid_result.SetText("书目登录号");
   m_grid_result.SetCol(1);
   m_grid_result.SetText("书名");
   m_grid_result.SetCol(2);
   m_grid_result.SetText("作者");
   m_grid_result.SetCol(3);
   m_grid_result.SetText("出版社");
   m_grid_result.SetCol(4);
   m_grid_result.SetText("入库日期");
   m_grid_result.SetCol(5);
   m_grid_result.SetText("借阅状态");
   int irow=1;
   count=m_book2.GetRecordCount();
   if(count!=0)
   {m_book2.MoveFirst();
      while(!m_book2.IsEOF())
	  {
	   m_grid_result.SetRow(irow);
	   m_grid_result.SetCol(0);
	   m_grid_result.SetText(m_book2.m_Bookid);
	   m_grid_result.SetCol(1);
	   m_grid_result.SetText(m_book2.m_Bookname);
	   m_grid_result.SetCol(2);
	   m_grid_result.SetText(m_book2.m_Bookauthor);
	   m_grid_result.SetCol(3);
	   m_grid_result.SetText(m_book2.m_Bookconcern);
	   m_grid_result.SetCol(4);
	   CString str;
	   str.Format(_T("%04d-%02d-%02d"),m_book2.m_Inputdate.GetYear(),m_book2.m_Inputdate.GetMonth(),m_book2.m_Inputdate.GetDay());
	   m_grid_result.SetText(str);
	   m_grid_result.SetCol(5);	   
	   
        if(m_book2.m_Status==1)
			str="可供出借";
		else if(m_book2.m_Status==2)
			str="已被预约";
		else  str="已借出";
	   m_grid_result.SetText(str);
	   irow++;
	   m_book2.MoveNext();
	  }
	  count=irow-1;
   }
   m_book2.Close();
	} //OnInitDialog();
}
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -