dialog4.cpp

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

// Dialog4.cpp : implementation file
//

#include "stdafx.h"
#include "图书管理系统.h"
#include "Dialog4.h"

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

/////////////////////////////////////////////////////////////////////////////
// CDialog4 dialog

extern CMyApp theApp;
CDialog4::CDialog4(CWnd* pParent /*=NULL*/)
	: CDialog(CDialog4::IDD, pParent)
{
	//{{AFX_DATA_INIT(CDialog4)
	m_outdata = _T("");
	m_readID = _T("");
	m_ReadNum = _T("");
	//}}AFX_DATA_INIT
}


void CDialog4::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CDialog4)
	DDX_Text(pDX, IDC_OUTDATA, m_outdata);
	DDX_Text(pDX, IDC_ReadID, m_readID);
	DDX_Text(pDX, IDC_READNUM, m_ReadNum);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CDialog4, CDialog)
	//{{AFX_MSG_MAP(CDialog4)
	ON_BN_CLICKED(IDC_BTN_REMU, OnBtnRemu)
	ON_WM_CTLCOLOR()
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CDialog4 message handlers

void CDialog4::OnBtnRemu() 
{
	// TODO: Add your control notification handler code here
	UpdateData();
	if(m_readID==""||m_ReadNum=="" ||m_outdata=="")
	{
		AfxMessageBox("请把信息填完整!");
	}
	_variant_t var;
	CString strEdID;
	strEdID="";
	try
	{
		if(!m_pRecordset2->BOF)
			m_pRecordset2->MoveFirst();
		else
		{
			AfxMessageBox("表内数据为空");
			return ;
		}
		while(!m_pRecordset2->adoEOF )
		{
			var = m_pRecordset2->GetCollect("EdID");
			if(var.vt != VT_NULL)
			{	
				strEdID = (LPCSTR)_bstr_t(var);			
			}
			if(m_readID==strEdID)
			{
				try
				{
					if(!m_pRecordset1->BOF)
						m_pRecordset1->MoveFirst();
					else
					{
						AfxMessageBox("表内数据为空");
						return ;
					}
					while(!m_pRecordset1->adoEOF )
					{
						var = m_pRecordset1->GetCollect("BkFlag");
						if(var.vt != VT_NULL)
						{	
							strEdID = (LPCSTR)_bstr_t(var);			
						}
						if(m_readID==strEdID)
						{
							try
							{
								m_pRecordset2->PutCollect("EdID", _variant_t(m_readID));
								m_pRecordset2->PutCollect("EdNum", _variant_t(m_ReadNum));
								m_pRecordset1->PutCollect("BkData", _variant_t(m_outdata));
								m_pRecordset2->Update();
								AfxMessageBox("修改成功!");
								return ;
							}
							catch(_com_error *e)
							{
								AfxMessageBox(e->ErrorMessage());
							}	
						}
						else
							m_pRecordset1->MoveNext();
					}
				}
				catch(_com_error *e)
				{
					AfxMessageBox(e->ErrorMessage());
				}	
			}
		
		else
			m_pRecordset2->MoveNext();
	}
	AfxMessageBox("读者不存在!");
	return;
}
catch(_com_error *e)
{
	AfxMessageBox(e->ErrorMessage());
}
}

BOOL CDialog4::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());
	}
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

HBRUSH CDialog4::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;
}