preview.cpp

报表打印实例

// Preview.cpp : implementation file
//

#include "stdafx.h"
#include "MainReport.h"
#include "Preview.h"
#include "ADOConn.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

/////////////////////////////////////////////////////////////////////////////
// CPreview dialog


CPreview::CPreview(CWnd* pParent /*=NULL*/)
	: CDialog(CPreview::IDD, pParent)
{
	//{{AFX_DATA_INIT(CPreview)
		// NOTE: the ClassWizard will add member initialization here
	//}}AFX_DATA_INIT
}


void CPreview::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CPreview)
		// NOTE: the ClassWizard will add DDX and DDV calls here
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CPreview, CDialog)
	//{{AFX_MSG_MAP(CPreview)
	ON_WM_CTLCOLOR()
	ON_WM_PAINT()
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CPreview message handlers

BOOL CPreview::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	sarrays[0][0]="书名";
	sarrays[0][1]="作者";
	sarrays[0][2]="出版社";
	sarrays[0][3]="数量";
	sarrays[0][4]="单价";
	sarrays[0][5]="金额";
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	CString sql;
	sql.Format("select* from tushubiao where 出版社 = '%s'",table);
	_RecordsetPtr m_pRecordset;
	m_pRecordset=m_AdoConn.GetRecordSet((_bstr_t)sql);
	int i=1;
	while(!m_pRecordset->adoEOF)
	{
		sarrays[i][0] = (char*)(_bstr_t)m_pRecordset->GetCollect("书名");
		sarrays[i][1] = (char*)(_bstr_t)m_pRecordset->GetCollect("作者");
		sarrays[i][2] = (char*)(_bstr_t)m_pRecordset->GetCollect("出版社");
		sarrays[i][3] = (char*)(_bstr_t)m_pRecordset->GetCollect("数量");
		sarrays[i][4] = (char*)(_bstr_t)m_pRecordset->GetCollect("单价");
		sarrays[i][5] = (char*)(_bstr_t)m_pRecordset->GetCollect("金额");
		i++;
		m_AdoConn.m_pRecordset->MoveNext();
	}
	m_AdoConn.ExitConnect();
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

HBRUSH CPreview::OnCtlColor(CDC* pDC, CWnd* pWnd, UINT nCtlColor) 
{
	HBRUSH hbr = CDialog::OnCtlColor(pDC, pWnd, nCtlColor);
	
	// TODO: Change any attributes of the DC here
	CBrush m_brush (RGB(255,255,255));	
	CRect m_rect;
	GetClientRect(m_rect);	
	pDC->FillRect(m_rect,&m_brush);
	// TODO: Return a different brush if the default is not desired
	return m_brush;
}

void CPreview::OnPaint() 
{
	CPaintDC dc(this); // device context for painting
	
	// TODO: Add your message handler code here
	CRect m_rect;
	GetClientRect(m_rect);	
	CDC* pDC = GetDC();
	screenx = pDC->GetDeviceCaps(LOGPIXELSX);
	screeny = pDC->GetDeviceCaps(LOGPIXELSY);
	DrawReport(m_rect,GetDC(),false);
	// Do not call CDialog::OnPaint() for painting messages
}

void CPreview::DrawReport(CRect rect, CDC *pDC, BOOL isprinted)
{
	titlefont.CreatePointFont(240,"宋体",pDC);
	bodyfont.CreatePointFont(100,"宋体",pDC);
	double ratex,ratey;
	if (!isprinted) //预览
	{
		ratex = 1;
		ratey = 1;
	}
	else //打印
	{
		int printx,printy;
		printx = pDC->GetDeviceCaps(LOGPIXELSX);
		printy = pDC->GetDeviceCaps(LOGPIXELSY);
		ratex = (double)(printx)/screenx;
		ratey = (double)(printy)/screeny;
		pDC->StartDoc("printinformation");
	}
	rect.DeflateRect(0,int(30*ratey),0,0);
	pDC->SelectObject(&titlefont);
	pDC->DrawText("主明细报表",rect,DT_CENTER);
	pDC->SelectObject(&bodyfont);
	int sum1=0,sum2=0;
	CString str1,str2;
	pDC->TextOut(int(15*ratex),int(70*ratey),"出版社：");
	pDC->TextOut(int(75*ratex),int(70*ratey),sarrays[1][2]);
	
	for (int i = 0;i<6;i++)
	{
		pDC->MoveTo(int(10*ratex),int((90+i*30)*ratey));
		pDC->LineTo(int(550*ratex),int((90+i*30)*ratey));
		pDC->TextOut(int( 15*ratex),int((100+i*30)*ratey),sarrays[i][0]);
		pDC->TextOut(int(245*ratex),int((100+i*30)*ratey),sarrays[i][1]);
		pDC->TextOut(int(345*ratex),int((100+i*30)*ratey),sarrays[i][3]);
		pDC->TextOut(int(425*ratex),int((100+i*30)*ratey),sarrays[i][4]);
		pDC->TextOut(int(505*ratex),int((100+i*30)*ratey),sarrays[i][5]);
		sum1 += atoi(sarrays[i][3]);
		sum2 += atoi(sarrays[i][5]);	
	}
	str1.Format("%d",sum1);
	str2.Format("%d",sum2);
	pDC->TextOut(int(245*ratex),int((70+i*30)*ratey),"合计数量：");
	pDC->TextOut(int(345*ratex),int((70+i*30)*ratey),str1);
	pDC->TextOut(int(415*ratex),int((70+i*30)*ratey),"合计金额：");
	pDC->TextOut(int(505*ratex),int((70+i*30)*ratey),str2);
	if (!isprinted)
	{
		pDC->EndDoc();
	}
	titlefont.DeleteObject();
	bodyfont.DeleteObject();
}