rewritedlg.cpp

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

// RewriteDlg.cpp : implementation file
//

#include "stdafx.h"
#include "Rent.h"
#include "RewriteDlg.h"
#include "connectiondb.h"

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

/////////////////////////////////////////////////////////////////////////////
// CRewriteDlg dialog


CRewriteDlg::CRewriteDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CRewriteDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CRewriteDlg)
	m_VDate = _T("");
	m_VName = _T("");
	m_VNote = _T("");
	m_VNum = _T("");
	m_VPlace = _T("");
	m_EditDate = FALSE;
	m_EditName = FALSE;
	m_EditNote = FALSE;
	m_EditNum = FALSE;
	m_EditPlace = FALSE;
	//}}AFX_DATA_INIT
}

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

	m_EditDate = FALSE;
	m_EditName = FALSE;
	m_EditNote = FALSE;
	m_EditNum = FALSE;
	m_EditPlace = FALSE;
	m_CDate.EnableWindow(FALSE);
	m_CName.EnableWindow(FALSE);
	m_CNote.EnableWindow(FALSE);
	m_CNum.EnableWindow(FALSE);
	m_CPlace.EnableWindow(FALSE);

	return TRUE;

}



void CRewriteDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CRewriteDlg)
	DDX_Control(pDX, IDC_PLACE, m_CPlace);
	DDX_Control(pDX, IDC_NUM, m_CNum);
	DDX_Control(pDX, IDC_NOTE, m_CNote);
	DDX_Control(pDX, IDC_NAME, m_CName);
	DDX_Control(pDX, IDC_DATE, m_CDate);
	DDX_Text(pDX, IDC_DATE, m_VDate);
	DDX_Text(pDX, IDC_NAME, m_VName);
	DDX_Text(pDX, IDC_NOTE, m_VNote);
	DDX_Text(pDX, IDC_NUM, m_VNum);
	DDX_Text(pDX, IDC_PLACE, m_VPlace);
	DDX_Check(pDX, IDC_EDITDATE, m_EditDate);
	DDX_Check(pDX, IDC_EDITNAME, m_EditName);
	DDX_Check(pDX, IDC_EDITNOTE, m_EditNote);
	DDX_Check(pDX, IDC_EDITNUM, m_EditNum);
	DDX_Check(pDX, IDC_EDITPLACE, m_EditPlace);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CRewriteDlg, CDialog)
	//{{AFX_MSG_MAP(CRewriteDlg)
	ON_BN_CLICKED(IDC_EDITNAME, OnEditname)
	ON_BN_CLICKED(IDC_EDITDATE, OnEditdate)
	ON_BN_CLICKED(IDC_EDITPLACE, OnEditplace)
	ON_BN_CLICKED(IDC_EDITNUM, OnEditnum)
	ON_BN_CLICKED(IDC_EDITNOTE, OnEditnote)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CRewriteDlg message handlers

void CRewriteDlg::OnEditname() 
{
	// TODO: Add your control notification handler code here
	if(m_EditName==FALSE)
	{
		m_EditName=TRUE;
		m_CName.EnableWindow(TRUE);
	}
	else
	{
		m_EditName=FALSE;
		m_CName.EnableWindow(FALSE);
	}
	
}

void CRewriteDlg::OnEditdate() 
{
	// TODO: Add your control notification handler code here
	if(m_EditDate==FALSE)
	{
		m_EditDate=TRUE;
		m_CDate.EnableWindow(TRUE);
	}
	else
	{
		m_EditDate=FALSE;
		m_CDate.EnableWindow(FALSE);
	}
}

void CRewriteDlg::OnEditplace() 
{
	// TODO: Add your control notification handler code here
	if(m_EditPlace==FALSE)
	{
		m_EditPlace=TRUE;
		m_CPlace.EnableWindow(TRUE);
	}
	else
	{
		m_EditPlace=FALSE;
		m_CPlace.EnableWindow(FALSE);
	}
}

void CRewriteDlg::OnEditnum() 
{
	// TODO: Add your control notification handler code here
	if(m_EditNum==FALSE)
	{
		m_EditNum=TRUE;
		m_CNum.EnableWindow(TRUE);
	}
	else
	{
		m_EditNum=FALSE;
		m_CNum.EnableWindow(FALSE);
	}	
}

void CRewriteDlg::OnEditnote() 
{
	// TODO: Add your control notification handler code here
	if(m_EditNote==FALSE)
	{
		m_EditNote=TRUE;
		m_CNote.EnableWindow(TRUE);
	}
	else
	{
		m_EditNote=FALSE;
		m_CNote.EnableWindow(FALSE);
	}		
}

void CRewriteDlg::OnOK() 
{
	// TODO: Add extra validation here
	UpdateData(TRUE);
	if(!m_EditDate&&!m_EditName&&!m_EditNote&&!m_EditNum&&!m_EditPlace)
	{
		MessageBox("请选择要修改的项目!","提示",MB_OK);
		return;
	}
	CConnectionDB connection;
	pConnection=connection.GetConnectionPtr();
	_RecordsetPtr pRecordset;
	pRecordset.CreateInstance(__uuidof(Recordset));
	CString strValue;
	CString strSQL;
	strSQL.Format("select * from DVDInfo where DVDId = '%d'",dvdId);
	HRESULT hr;
	try
	{
		hr=pRecordset->Open(_variant_t(strSQL),pConnection.GetInterfacePtr(),
							adOpenDynamic,adLockOptimistic,adCmdText);
		if(SUCCEEDED(hr))
		{
			if(m_EditName)
			{
				strValue=m_VName;
				pRecordset->PutCollect("DVDName",_variant_t(strValue));
				pRecordset->Update();
			}
			if(m_EditDate)
			{
				strValue=m_VDate;
				pRecordset->PutCollect("OutDate",_variant_t(strValue));
				pRecordset->Update();
			}
			if(m_EditPlace)
			{
				strValue=m_VPlace;
				pRecordset->PutCollect("Place",_variant_t(strValue));
				pRecordset->Update();
			}
			if(m_EditNum)
			{
				strValue=m_VNum;
				pRecordset->PutCollect("DVDNum",_variant_t(strValue));
				pRecordset->Update();
			}
			if(m_EditNote)
			{
				strValue=m_VNote;
				pRecordset->PutCollect("Note",_variant_t(strValue));
				pRecordset->Update();
			}
			if(!m_EditDate&&!m_EditName&&!m_EditNote&&!m_EditNum&&!m_EditPlace)
			{
				MessageBox("请选择要修改的项目!","提示",MB_OK);
				return;
			}
		}
		else
		{
			MessageBox("error");
			return;
		}
	}
	catch(_com_error *e)
	{
		MessageBox(e->ErrorMessage());
		return;
	}
	pRecordset->Close();
	pRecordset=NULL;

	CDialog::OnOK();
}