queryresultdlg.cpp

VC下基于SQL的图书管理系统源代码

// QueryResultDlg.cpp : implementation file
//

#include "stdafx.h"
#include "BookAdmi.h"
#include "QueryResultDlg.h"
#include "BookInfo.h"
#include "DetailDisDlg.h"
#include "adodc.h"
#include "_recordset.h"

#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

/////////////////////////////////////////////////////////////////////////////
// QueryResultDlg dialog


QueryResultDlg::QueryResultDlg(CWnd* pParent /*=NULL*/)
	: CDialog(QueryResultDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(QueryResultDlg)
	//}}AFX_DATA_INIT
}


void QueryResultDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(QueryResultDlg)
	DDX_Control(pDX, IDOK, m_ok);
	DDX_Control(pDX, IDC_DATAGRID1, m_datagrid);
	DDX_Control(pDX, IDC_ADODC1, m_adodc);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(QueryResultDlg, CDialog)
	//{{AFX_MSG_MAP(QueryResultDlg)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// QueryResultDlg message handlers

BEGIN_EVENTSINK_MAP(QueryResultDlg, CDialog)
    //{{AFX_EVENTSINK_MAP(QueryResultDlg)
	ON_EVENT(QueryResultDlg, IDC_DATAGRID1, -601 /* DblClick */, OnDblClickDatagrid1, VTS_NONE)
	//}}AFX_EVENTSINK_MAP
END_EVENTSINK_MAP()

void QueryResultDlg::OnDblClickDatagrid1() 
{
	//BookInfo m_bk;
//	m_bk.GetData(m_datagrid.GetItem(0));
	//ADOConn m_adodc;

	if(m_adodc.GetRecordset().GetEof()==1)
	{
		MessageBox("没有数据");
		return;
	}
	CString strDetail;
	switch(m_QueryStyle)
	{
	case 1:
		strDetail="作者姓名:"+m_datagrid.GetItem(0)+"\r\n";
		strDetail+="电话号码:"+m_datagrid.GetItem(1)+"\r\n";
		strDetail+="邮政编码:"+m_datagrid.GetItem(2)+"\r\n";
		//strDetail+="电话:"+m_datagrid.GetItem(3)+"\r\n";
		strDetail+="定价:"+m_datagrid.GetItem(3)+"\r\n";
		strDetail+="页数:"+m_datagrid.GetItem(4)+"\r\n";
		strDetail+="著作权年限:"+m_datagrid.GetItem(5)+"\r\n";
		break;
	case 2:
		strDetail="作者姓名:"+m_datagrid.GetItem(0)+"\r\n";
		strDetail+="作者地址:"+m_datagrid.GetItem(1)+"\r\n";
		strDetail+="图书名称:"+m_datagrid.GetItem(2)+"\r\n";
		strDetail+="出版日期:"+m_datagrid.GetItem(3)+"\r\n";
		strDetail+="出版号:"+m_datagrid.GetItem(4)+"\r\n";
		strDetail+="出版社名称:"+m_datagrid.GetItem(5)+"\r\n";
		break;
	case 3:
		strDetail="图书分类名称:"+m_datagrid.GetItem(0)+"\r\n";
		strDetail+="作者编号:"+m_datagrid.GetItem(1)+"\r\n";
		strDetail+="图书名称:"+m_datagrid.GetItem(2)+"\r\n";
		strDetail+="出版日期:"+m_datagrid.GetItem(3)+"\r\n";
		break;
	default:
		strDetail="图书名称:"+m_datagrid.GetItem(0)+"\r\n";
		strDetail+="作者姓名:"+m_datagrid.GetItem(1)+"\r\n";
		strDetail+="出版日期:"+m_datagrid.GetItem(2)+"\r\n";
		strDetail+="出版号:"+m_datagrid.GetItem(3)+"\r\n";
		strDetail+="出版社名称:"+m_datagrid.GetItem(4)+"\r\n";
	}
	UpdateData(false);
	DetailDisDlg dlg;
	dlg.m_DetailEdit=strDetail;	
	dlg.DoModal();
	/*	dlg.m_DetailEdit="图书名称："+m_bk.a_BookName+"\r\n";
	dlg.m_DetailEdit+="图书分类号："+m_bk.a_BookClaId+"\r\n";
	dlg.m_DetailEdit+="图书编号："+m_bk.a_BookId+"\r\n";
	dlg.m_DetailEdit+="作者编号："+m_bk.a_AuthorId+"\r\n";
	dlg.m_DetailEdit+="出版日期："+m_bk.a_PubDate+"\r\n";
	dlg.m_DetailEdit+="出版号："+m_bk.a_PubNumber+"\r\n";
	dlg.m_DetailEdit+="出版社："+m_bk.a_PubCompany+"\r\n";
	dlg.m_DetailEdit+="定价："+m_bk.a_BookPrice+"\r\n";
	dlg.m_DetailEdit+="页数："+m_bk.a_PageAmount+"\r\n";
	dlg.m_DetailEdit+="著作权年限："+m_bk.a_Copyright+"\r\n";*/
}

void QueryResultDlg::OnOK() 
{
	OnDblClickDatagrid1();
}

BOOL QueryResultDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();	
	// TODO: Add extra initialization here
	CString sql;
//m_QueryStyle=1;
	switch(m_QueryStyle)
	{
	case 1:
		sql="SELECT TOP 100 PERCENT T_author.AuthorName 作者姓名, T_author.Tel 电话,T_author.PostNum 邮编, T_book.BookPrice 定价, T_book.PageAmount 页数, T_book.Copyright 著作权年限 FROM T_book INNER JOIN T_author ON T_book.AuthorId = T_author.AuthorId where BookClaId like '%"+m_keyword+"%'";
		//MessageBox("");
		break;
	case 2:
		sql="SELECT TOP 100 PERCENT T_author.AuthorName 作者姓名, T_author.AuthorAdr 地址,T_book.BookName 图书名称, T_book.PubDate 出版日期, T_book.PubNum 出版号,  T_book.PubCompany 出版社 FROM T_book INNER JOIN T_author ON T_book.AuthorId = T_author.AuthorId where AuthorName like '"+m_keyword+"%'";
		break;
	case 3:
		//sql="SELECT TOP 100 PERCENT T_book.BookName, T_book.BookClaId, T_author.AuthorName, T_book.AuthorId, T_book.PubDate FROM T_book INNER JOIN T_author ON T_book.AuthorId = T_author.AuthorId where BookId like '"+m_keyword+"%'";

	default:
		sql="SELECT TOP 100 PERCENT T_book.BookName 图书名称,T_author.AuthorName 作者姓名, T_book.PubDate 出版日期, T_book.PubNum 出版号, T_book.PubCompany 出版社 FROM T_book INNER JOIN T_author ON T_book.AuthorId = T_author.AuthorId where T_book.BookName like '%"+m_keyword+"%'";
	}
	//sql="SELECT TOP 100 PERCENT T_book.BookName, T_book.BookClaId, T_author.AuthorName, T_book.AuthorId, T_book.PubDate FROM T_book INNER JOIN T_author ON T_book.AuthorId = T_author.AuthorId where BookId like '"+m_keyword+"%'";
	//sql="SELECT TOP 100 PERCENT T_book.BookName,T_author.AuthorName, T_book.PubDate, T_book.PubNum, T_book.PubCompany FROM T_book INNER JOIN T_author ON T_book.AuthorId = T_author.AuthorId where T_book.BookName like '%"+m_keyword+"%'";
	m_adodc.SetRecordSource(sql);//"select * from t_book where BookId like '"+m_keyword+"%'");
	m_adodc.Refresh();
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

//DEL void QueryResultDlg::OnButton1() 
//DEL {
//DEL BookInfo yy;
//DEL yy.sql_update("11");
//DEL m_adodc.Refresh();		
//DEL }