addarguedlg.cpp

银行管理系统,在VisualC++中操作SQL数据库进行银行帐号的创建,删除,修改,转帐,存款,取款,生成密码卡等操作.

// AddArgueDlg.cpp : 实现文件
//

#include "stdafx.h"
#include "BankSystem.h"
#include "AddArgueDlg.h"
#include ".\addarguedlg.h"


// AddArgueDlg 对话框

IMPLEMENT_DYNAMIC(AddArgueDlg, CDialog)
AddArgueDlg::AddArgueDlg(CWnd* pParent /*=NULL*/)
	: CDialog(AddArgueDlg::IDD, pParent)
	, m_topic(_T(""))
	, m_content(_T(""))
{
}

AddArgueDlg::~AddArgueDlg()
{
}

void AddArgueDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	DDX_Text(pDX, IDC_EDIT1, m_topic);
	DDX_Text(pDX, IDC_EDIT2, m_content);
}


BEGIN_MESSAGE_MAP(AddArgueDlg, CDialog)
	ON_BN_CLICKED(IDC_Add, OnBnClickedAdd)
	ON_BN_CLICKED(IDC_Cancel, OnBnClickedCancel)
END_MESSAGE_MAP()


// AddArgueDlg 消息处理程序

void AddArgueDlg::OnBnClickedAdd()
{
	// TODO: 在此添加控件通知处理程序代码
	CString strQuery="SELECT * FROM argue";
	


	try{
		pRst=pConn->Execute(_bstr_t(strQuery),NULL,adCmdText);
	}
	catch(_com_error &e)
	{
		MessageBox(e.ErrorMessage()); 
		return ;
	}
	
	UpdateData();
	
	

	try
	{
		pRst.CreateInstance("ADODB.Recordset");
		pRst->Open(_bstr_t(strQuery),_variant_t((IDispatch*)pConn,true),adOpenStatic,adLockOptimistic,adCmdText);
		

	pRst->AddNew();
	pRst->put_Collect(_variant_t("topic"),_variant_t(m_topic));
	pRst->put_Collect(_variant_t("content"),_variant_t(m_content));
	pRst->put_Collect(_variant_t("uname"),_variant_t(UserName));
	pRst->Update();
	}
	catch(_com_error &e)
	{
		MessageBox(e.ErrorMessage()); 
		return ;
	}

	AfxMessageBox("投诉成功");

}

void AddArgueDlg::OnBnClickedCancel()
{
	// TODO: 在此添加控件通知处理程序代码
	OnOK();
}