transaction.cpp

这是一个企业办公管理系统。实现了文件的制作、修改、传递、、保存、销毁、存档等一系列操作。为windows系统认证模式

// Transaction.cpp: implementation of the CTransaction class.
//
//////////////////////////////////////////////////////////////////////

#include "stdafx.h"
#include "Office.h"
#include "Transaction.h"

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

//////////////////////////////////////////////////////////////////////
// Construction/Destruction
//////////////////////////////////////////////////////////////////////

CTransaction::CTransaction()
{

}

CTransaction::~CTransaction()
{

}

CString CTransaction::GetTransactionType()
{
	return transactionType;
}

COleDateTime CTransaction::GetTransactionDate()
{
	return transactionDate;
}

CString CTransaction::GetTransactionSubject()
{
	return transactionSubject;
}

CString CTransaction::GetContent()
{
	return content;
}

void CTransaction::SetTransactionType(CString vTransactionType)
{
	transactionType=vTransactionType;
}
void CTransaction::SetTransactionDate(COleDateTime vTransactionDate)
{
	transactionDate=vTransactionDate;
}

void CTransaction::SetTransactionSubject(CString vTransactionSubject)
{
	transactionSubject=vTransactionSubject;
}

void CTransaction::SetContent(CString vContent)
{
	content=vContent;
}

void CTransaction::sqlInsert()
{
	CString strSQL;

	strSQL="select * from transactionRecord";  //构造sql查询语句
	_RecordsetPtr m_pRecordset; //记录集
	HRESULT hTRes;
	hTRes = m_pRecordset.CreateInstance(_T("ADODB.Recordset")); //创建实例				
	hTRes = m_pRecordset->Open((LPTSTR)strSQL.GetBuffer(130), 
			((COfficeApp*)AfxGetApp())->m_pConn.GetInterfacePtr(),
			adOpenDynamic,adLockPessimistic,adCmdText);//执行查询，并打开记录集
	if(SUCCEEDED(hTRes))
	{
		m_pRecordset->AddNew();//添加新的记录

		CString str;
		m_pRecordset->PutCollect("transactionType",_variant_t(transactionType)); //事务类别
		m_pRecordset->PutCollect("transactionSubject",_variant_t(transactionSubject));//事务主题
		m_pRecordset->PutCollect("transactionDate",_variant_t(transactionDate)); //事务日期
		m_pRecordset->PutCollect("content",_variant_t(content)); //事务内容

		m_pRecordset->Update();//将记录插入到数据库
	}
}

void CTransaction::sqlDelete(CString vTransactionSubject)
{
	CString strSQL;
	strSQL="delete from transactionRecord where transactionSubject='"; //构造删除记录的sql语句
	strSQL=strSQL+vTransactionSubject+"'";
	(((COfficeApp*)AfxGetApp())->m_pConn)->Execute((_bstr_t)strSQL,NULL,adCmdText);//执行删除
}

void CTransaction::sqlUpdate(CString vTransactionSubject)
{
	CString strSQL;

	strSQL="select * from transactionRecord where transactionSubject='";
	strSQL=strSQL+vTransactionSubject+"'"; //构造查询语句
	_RecordsetPtr m_pRecordset;
	HRESULT hTRes;
	hTRes = m_pRecordset.CreateInstance(_T("ADODB.Recordset"));				
	hTRes = m_pRecordset->Open((LPTSTR)strSQL.GetBuffer(130),
			((COfficeApp*)AfxGetApp())->m_pConn.GetInterfacePtr(),
			adOpenDynamic,adLockPessimistic,adCmdText); //打开查询结果记录集
	if(!(m_pRecordset->adoEOF))
	{
		//设定各个字段的新的值
		CString str;
		m_pRecordset->PutCollect("transactionType",_variant_t(transactionType));//事务类别
	//	m_pRecordset->PutCollect("transactionSubject",_variant_t(transactionSubject)); //事务主题
		m_pRecordset->PutCollect("transactionDate",_variant_t(transactionDate)); //事务日期
		m_pRecordset->PutCollect("content",_variant_t(content)); //事务内容
		m_pRecordset->Update(); //更新
	}
}
void CTransaction::GetData(CString vTransactionSubject)
{
	CString strSQL;

	strSQL="select * from transactionRecord where transactionSubject='";
	strSQL=strSQL+vTransactionSubject+"'";//构造查询符合条件记录的sql语句
	_RecordsetPtr m_pRecordset;
	HRESULT hTRes;
	hTRes = m_pRecordset.CreateInstance(_T("ADODB.Recordset"));				
	hTRes = m_pRecordset->Open((LPTSTR)strSQL.GetBuffer(130),
			((COfficeApp*)AfxGetApp())->m_pConn.GetInterfacePtr(),
			adOpenDynamic,adLockPessimistic,adCmdText);//执行查询，打开结果记录集
	if(SUCCEEDED(hTRes))
	{
		//获取记录集中的数据
		CString str;
		transactionSubject= ((COfficeApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("transactionSubject"));//事务主题
		transactionType= ((COfficeApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("transactionType"));//事务类别
		transactionDate= m_pRecordset->GetCollect("transactionDate");//事务日期
		content= ((COfficeApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("content"));//事务内容		
	}
}