新建 文本文档.txt

实现一个图书馆管理系统

	bookset->m_strFilter="";
	if(!m_bookno.IsEmpty())
		bookset->m_strFilter=bookset->m_strFilter+"BookNo='"+m_bookno+"'";
	if(bookset->m_strFilter.IsEmpty() && !m_bookname.IsEmpty())
		bookset->m_strFilter="Name='"+m_bookname+"'";
	else if(!bookset->m_strFilter.IsEmpty() &&!m_bookname.IsEmpty())
		bookset->m_strFilter+=" and Name='"+m_bookname+"'";
	else
	{
		if(bookset->m_strFilter.IsEmpty() && !m_author.IsEmpty())
			bookset->m_strFilter="Author='"+m_author+"'";
		else if(!bookset->m_strFilter.IsEmpty() && !m_author.IsEmpty())
			bookset->m_strFilter+=" and Author='"+m_author+"'";
		else
		{
			if(bookset->m_strFilter.IsEmpty() && !m_publishhouse.IsEmpty())
				bookset->m_strFilter="PublishHouse='"+m_publishhouse+"'";
			else if(!bookset->m_strFilter.IsEmpty() && !m_publishhouse.IsEmpty())
				bookset->m_strFilter+=" and PublishHouse='"+m_publishhouse+"'";
		}
	}
	if(m_bookno.IsEmpty() && m_bookname.IsEmpty() && m_author.IsEmpty() && m_publishhouse.IsEmpty())
		MessageBox("查询条件不能为空！");
	else
	{
		MessageBox(bookset->m_strFilter);
		bookset->Open();
		bookset->Requery();
		if(bookset->GetRecordCount()==0)
			MessageBox("很抱歉！\n没有找到符合您要求的书！");
		else
		{
			m_info.SetItemText(0,0,bookset->m_BookNo);
			m_info.SetItemText(0,1,bookset->m_Name);
			m_info.SetItemText(0,2,bookset->m_Author);
			m_info.SetItemText(0,3,bookset->m_PublishingHouse);
			m_info.SetItemText(0,4,bookset->m_PublishingDate);
			m_info.SetItemText(0,5,bookset->m_State);
		}
	}