projectexhibit.cpp

关于客户关系管理系统的源码

// ProjectExhibit.cpp: implementation of the CProjectExhibit class.
//
//////////////////////////////////////////////////////////////////////

#include "stdafx.h"
#include "ClientRelationship.h"
#include "ProjectExhibit.h"

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

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

CProjectExhibit::CProjectExhibit()
{

}

CProjectExhibit::~CProjectExhibit()
{

}
CString CProjectExhibit::GetProjectExhibitID()
{
	return projectExhibitID;
}

COleDateTime	CProjectExhibit::GetExhibitDate()
{
	return exhibitDate;
}

CString	CProjectExhibit::GetChargePerson()
{
	return chargePerson;
}

CString	CProjectExhibit::GetExhibitProject()
{
	return exhibitProject;
}

CString	CProjectExhibit::GetAddress()
{
	return address;
}

CString	CProjectExhibit::GetSummary()
{
	return summary;
}
	
void CProjectExhibit::SetProjectExhibitID(CString vProjectExhibitID)
{
	projectExhibitID=vProjectExhibitID;	
}

void CProjectExhibit::SetExhibitDate(COleDateTime vExhibitDate)
{
	exhibitDate=vExhibitDate;
}

void CProjectExhibit::SetChargePerson(CString vChargePerson)
{
	chargePerson=vChargePerson;
}

void CProjectExhibit::SetExhibitProject(CString vExhibitProject)
{
	exhibitProject=vExhibitProject;
}

void CProjectExhibit::SetAddress(CString vAddress)
{
	address=vAddress;
}

void CProjectExhibit::SetSummary(CString vSummary)
{
	summary=vSummary;
}

void CProjectExhibit::sqlInsert()
{
	CString strSQL;

	strSQL="select * from projectExhibit";
	_RecordsetPtr m_pRecordset;
	HRESULT hTRes;
	hTRes = m_pRecordset.CreateInstance(_T("ADODB.Recordset"));				
	hTRes = m_pRecordset->Open((LPTSTR)strSQL.GetBuffer(130),
			((CClientRelationshipApp*)AfxGetApp())->m_pConn.GetInterfacePtr(),
			adOpenDynamic,adLockPessimistic,adCmdText);
	if(SUCCEEDED(hTRes))
	{
		m_pRecordset->AddNew();

		m_pRecordset->PutCollect("projectExhibitID",_variant_t(projectExhibitID));
		m_pRecordset->PutCollect("exhibitDate",_variant_t(exhibitDate));
		m_pRecordset->PutCollect("chargePerson",_variant_t(chargePerson.Left(50)));
		m_pRecordset->PutCollect("exhibitProject",_variant_t(exhibitProject.Left(50)));
		m_pRecordset->PutCollect("address",_variant_t(address.Left(50)));
		m_pRecordset->PutCollect("summary",_variant_t(summary.Left(50)));
		
		m_pRecordset->Update();
	}
}

void CProjectExhibit::sqlUpdate(CString cProjectExhibitID)
{
	CString strSQL;

	strSQL="select * from projectExhibit where projectExhibitID='";
	strSQL+=cProjectExhibitID+"'";
	_RecordsetPtr m_pRecordset;
	HRESULT hTRes;
	hTRes = m_pRecordset.CreateInstance(_T("ADODB.Recordset"));				
	hTRes = m_pRecordset->Open((LPTSTR)strSQL.GetBuffer(130),
			((CClientRelationshipApp*)AfxGetApp())->m_pConn.GetInterfacePtr(),
			adOpenDynamic,adLockPessimistic,adCmdText);
	if(SUCCEEDED(hTRes))
	{
		m_pRecordset->PutCollect("exhibitDate",_variant_t(exhibitDate));
		m_pRecordset->PutCollect("chargePerson",_variant_t(chargePerson.Left(50)));
		m_pRecordset->PutCollect("exhibitProject",_variant_t(exhibitProject.Left(50)));
		m_pRecordset->PutCollect("address",_variant_t(address.Left(50)));
		m_pRecordset->PutCollect("summary",_variant_t(summary.Left(50)));
		
		m_pRecordset->Update();
	}
}

void CProjectExhibit::sqlDelete(CString cProjectExhibitID)
{
	CString strSQL;
	strSQL="delete from projectExhibit where projectExhibitID='";
	strSQL=strSQL+cProjectExhibitID+"'";
	(((CClientRelationshipApp*)AfxGetApp())->m_pConn)->Execute((_bstr_t)strSQL,NULL,adCmdText);

}

void CProjectExhibit::GetData(CString cProjectExhibitID)
{
	CString strSQL;

	strSQL="select * from projectExhibit where projectExhibitID='";
	strSQL+=cProjectExhibitID+"'";
	_RecordsetPtr m_pRecordset;
	HRESULT hTRes;
	hTRes = m_pRecordset.CreateInstance(_T("ADODB.Recordset"));				
	hTRes = m_pRecordset->Open((LPTSTR)strSQL.GetBuffer(130),
			((CClientRelationshipApp*)AfxGetApp())->m_pConn.GetInterfacePtr(),
			adOpenDynamic,adLockPessimistic,adCmdText);
	if(SUCCEEDED(hTRes))
	{		
		exhibitDate= m_pRecordset->GetCollect("exhibitDate");
		chargePerson= ((CClientRelationshipApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("chargePerson"));
		exhibitProject= ((CClientRelationshipApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("exhibitProject"));
		address= ((CClientRelationshipApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("address"));
		summary= ((CClientRelationshipApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("summary"));
	}
}