dialog3.cpp

自己 写的 玩下 还有 很多 功能要 大家一起 开发

// Dialog3.cpp : implementation file
//

#include "stdafx.h"
#include "图书管理系统.h"
#include "Dialog3.h"
#include <stdlib.h>

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

/////////////////////////////////////////////////////////////////////////////
// CDialog3 dialog

extern CMyApp theApp;
CDialog3::CDialog3(CWnd* pParent /*=NULL*/)
	: CDialog(CDialog3::IDD, pParent)
{
	//{{AFX_DATA_INIT(CDialog3)
	//}}AFX_DATA_INIT
}


void CDialog3::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CDialog3)
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CDialog3, CDialog)
	//{{AFX_MSG_MAP(CDialog3)
	ON_WM_CTLCOLOR()
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CDialog3 message handlers

BOOL CDialog3::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	m_pRecordset1.CreateInstance(__uuidof(Recordset));
	m_pRecordset2.CreateInstance(__uuidof(Recordset));
///////////////////////////////////////////////////////////////////////////////////////////////////
	try
	{
    m_pRecordset1->Open("SELECT * FROM DemoTable",theApp.m_pConnection.GetInterfacePtr(),
	adOpenDynamic,adLockOptimistic,adCmdText);
	m_pRecordset2->Open("SELECT * FROM Reader",theApp.m_pConnection.GetInterfacePtr(),
	adOpenDynamic,adLockOptimistic,adCmdText);
		
	}
	catch(_com_error *e)
	{
		AfxMessageBox(e->ErrorMessage());
	}
////////////////////////////////////////////////////////////////////////////////////////////////	

	_variant_t var;
	bktotal=readtotal=bkintotal=0;
	CString strbkFlag;

	try
	{
		if(!m_pRecordset1->BOF)
			m_pRecordset1->MoveFirst();
		else
		{
			AfxMessageBox("表内数据为空");
			return 0;
		}
		while(!m_pRecordset1->adoEOF )
		{     
		     var = m_pRecordset1->GetCollect("BkFlag");
			if(var.vt != VT_NULL)
			{	
				strbkFlag=(LPCSTR)_bstr_t(var);
				if(strbkFlag!="")
				{
					bkintotal++;
				}
			} 
			bktotal++;
             m_pRecordset1->MoveNext();
		}
        
	}
	catch(_com_error *e)
	{
		AfxMessageBox(e->ErrorMessage());
	}
/////////////////////////////////////////////////////////////////////////////////////	
	try
	{
		if(!m_pRecordset2->BOF)
			m_pRecordset2->MoveFirst();
		else
		{
			AfxMessageBox("表内数据为空");
			return 0;
		}
		while(!m_pRecordset2->adoEOF )
		{     
			readtotal++;
            m_pRecordset2->MoveNext();
		}
        
	}
	catch(_com_error *e)
	{
		AfxMessageBox(e->ErrorMessage());
	}
  char 	m_BkTotal;
  char 	m_ReadTotal;
  char 	m_BkinTotal;
    bkintotal=bktotal-bkintotal;
 //  m_BkTotal=(char)bktotal;
    itoa(bktotal,&m_BkTotal,10);
    itoa(bkintotal,&m_BkinTotal,10);
    itoa(readtotal,&m_ReadTotal,10);
	SetDlgItemText(IDC_EDIT1,&m_BkTotal);
    SetDlgItemText(IDC_EDIT3,&m_BkinTotal);
	SetDlgItemText(IDC_EDIT2,&m_ReadTotal);
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

HBRUSH CDialog3::OnCtlColor(CDC* pDC, CWnd* pWnd, UINT nCtlColor) 
{
	HBRUSH hbr = CDialog::OnCtlColor(pDC, pWnd, nCtlColor);
	
	// TODO: Change any attributes of the DC here
	if(nCtlColor==CTLCOLOR_LISTBOX)
	{
		//pDC->SetBkMode(TRANSPARENT);
		pDC->SetTextColor(RGB(0,0,0));
		pDC->SetBkColor(RGB(233,233,220));
		HBRUSH b=CreateSolidBrush(RGB(233,233,220));
		return b;
	}
	else if(nCtlColor==CTLCOLOR_SCROLLBAR)
	{
		//pDC->SetBkMode(TRANSPARENT);
		pDC->SetTextColor(RGB(0,0,0));
		pDC->SetBkColor(RGB(233,233,220));
		HBRUSH b=CreateSolidBrush(RGB(233,233,220));
		return b;
	}
	else if(nCtlColor==CTLCOLOR_EDIT)
	{
		//pDC->SetBkMode(TRANSPARENT);
		pDC->SetTextColor(RGB(0,0,0));
		pDC->SetBkColor(RGB(233,233,220));
		HBRUSH b=CreateSolidBrush(RGB(233,233,220));
		return b;
	}
	else if(nCtlColor==CTLCOLOR_STATIC)
	{
		pDC->SetTextColor(RGB(0,0,0));
		pDC->SetBkColor(RGB(160,180,220));
		HBRUSH b=CreateSolidBrush(RGB(160,180,220));
		return b;
	}
	else if(nCtlColor==CTLCOLOR_DLG)
	{
		pDC->SetTextColor(RGB(0,0,0));
		pDC->SetBkColor(RGB(160,180,220));
		HBRUSH b=CreateSolidBrush(RGB(160,180,220));
		return b;
	}
	
	// TODO: Return a different brush if the default is not desired
	return hbr;
}