adddvdinfo.cpp

影碟出租系统 利用mfc编程 与数据库连接

// ADDDVDInfo.cpp : implementation file
//

#include "stdafx.h"
#include "Rent.h"
#include "ADDDVDInfo.h"
#include "connectionDB.h"


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

/////////////////////////////////////////////////////////////////////////////
// CADDDVDInfo dialog


CADDDVDInfo::CADDDVDInfo(CWnd* pParent /*=NULL*/)
	: CDialog(CADDDVDInfo::IDD, pParent)
{
	//{{AFX_DATA_INIT(CADDDVDInfo)
	m_Date = _T("");
	m_Id = _T("");
	m_Name = _T("");
	m_Note = _T("");
	m_Num = _T("");
	m_Place = _T("");
	//}}AFX_DATA_INIT
}

BOOL CADDDVDInfo::OnInitDialog()
{
	CDialog::OnInitDialog();

	return TRUE;
}

void CADDDVDInfo::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CADDDVDInfo)
	DDX_Control(pDX, IDC_EDIT_PLACE, m_EditPlace);
	DDX_Control(pDX, IDC_EDIT_NUM, m_EditNum);
	DDX_Control(pDX, IDC_EDIT_NOTE, m_EditNote);
	DDX_Control(pDX, IDC_EDIT_NAME, m_EditName);
	DDX_Control(pDX, IDC_EDIT_ID, m_EditId);
	DDX_Control(pDX, IDC_EDIT_DATE, m_EditDate);
	DDX_Text(pDX, IDC_EDIT_DATE, m_Date);
	DDX_Text(pDX, IDC_EDIT_ID, m_Id);
	DDX_Text(pDX, IDC_EDIT_NAME, m_Name);
	DDX_Text(pDX, IDC_EDIT_NOTE, m_Note);
	DDX_Text(pDX, IDC_EDIT_NUM, m_Num);
	DDX_Text(pDX, IDC_EDIT_PLACE, m_Place);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CADDDVDInfo, CDialog)
	//{{AFX_MSG_MAP(CADDDVDInfo)
	ON_BN_CLICKED(ID_REWRITE, OnRewrite)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CADDDVDInfo message handlers

void CADDDVDInfo::OnOK() 
{
	// TODO: Add extra validation here
	UpdateData(TRUE);
	CConnectionDB connectionDBPtr;
	pConnection=connectionDBPtr.GetConnectionPtr();
	_RecordsetPtr pDVDRecord;
	pDVDRecord.CreateInstance(__uuidof(Recordset));
	HRESULT hr;
	if(m_Id.IsEmpty()||m_Name.IsEmpty()||m_Date.IsEmpty()||m_Place.IsEmpty()||m_Num.IsEmpty())
	{
		MessageBox("请输入完整的数据");
		return;
		
	}
	try
	{
		hr=pDVDRecord->Open(_variant_t("DVDInfo"),pConnection.GetInterfacePtr(),
						adOpenDynamic,adLockOptimistic,adCmdTable);
		if(SUCCEEDED(hr))
		{//添加字段值
			pDVDRecord->AddNew();
			pDVDRecord->PutCollect("DVDID",_variant_t(m_Id));
			pDVDRecord->PutCollect("DVDName",_variant_t(m_Name));
			pDVDRecord->PutCollect("OutDate",_variant_t(m_Date));
			pDVDRecord->PutCollect("Place",_variant_t(m_Place));
			pDVDRecord->PutCollect("DVDNum",_variant_t(m_Num));
			if(!m_Note.IsEmpty())
				pDVDRecord->PutCollect("Note",_variant_t(m_Note));
			pDVDRecord->Update();//更新数据库
		}
		else
		{
			AfxMessageBox("open error");
			return;
		}
	}
	catch(_com_error *e)
	{
		AfxMessageBox(e->ErrorMessage());
		return;
	}
	pDVDRecord->Close();
	pDVDRecord=NULL;
//	delete &connectionDBPtr;

	CDialog::OnOK();
}

void CADDDVDInfo::OnRewrite() 
{
	// TODO: Add your control notification handler code here
	m_Date = _T("");
	m_Id = _T("");
	m_Name = _T("");
	m_Note = _T("");
	m_Num = _T("");
	m_Place = _T("");
	UpdateData(FALSE);
}