promotesale.cpp

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

// PromoteSale.cpp: implementation of the CPromoteSale class.
//
//////////////////////////////////////////////////////////////////////

#include "stdafx.h"
#include "ClientRelationship.h"
#include "PromoteSale.h"

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

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

CPromoteSale::CPromoteSale()
{

}

CPromoteSale::~CPromoteSale()
{

}

CString CPromoteSale::GetPromoteSaleID()
{
	return promoteSaleID;
}

COleDateTime	CPromoteSale::GetPromoteSaleDate()
{
	return promoteSaleDate;
}

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

CString	CPromoteSale::GetPromoteSaleAddress()
{
	return promoteSaleAddress;
}

CString	CPromoteSale::GetPromoteSaleContent()
{
	return promoteSaleContent;
}

void CPromoteSale::SetPromoteSaleID(CString vPromoteSaleID)
{
	promoteSaleID=vPromoteSaleID;
}

void CPromoteSale::SetPromoteSaleDate(COleDateTime vPromoteSaleDate)
{
	promoteSaleDate=vPromoteSaleDate;
}

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

void CPromoteSale::SetPromoteSaleAddress(CString vPromoteSaleAddress)
{
	promoteSaleAddress=vPromoteSaleAddress;
}

void CPromoteSale::SetPromoteSaleContent(CString vPromoteSaleContent)
{
	promoteSaleContent=vPromoteSaleContent;
}


void CPromoteSale::sqlInsert()
{
	CString strSQL;

	strSQL="select * from promoteSale";
	_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("promoteSaleID",_variant_t(promoteSaleID));
		m_pRecordset->PutCollect("promoteSaleDate",_variant_t(promoteSaleDate));
		m_pRecordset->PutCollect("chargePerson",_variant_t(chargePerson.Left(50)));
		m_pRecordset->PutCollect("promoteSaleAddress",_variant_t(promoteSaleAddress.Left(50)));
	//	m_pRecordset->PutCollect("promoteSaleProduct",_variant_t(promoteSaleProduct.Left(50)));
		m_pRecordset->PutCollect("promoteSaleContent",_variant_t(promoteSaleContent.Left(50)));	
		
		m_pRecordset->Update();
	}
}

void CPromoteSale::sqlUpdate(CString cPromoteSaleID)
{
	CString strSQL;


	strSQL="select * from promoteSale where promoteSaleID='";
	strSQL+=promoteSaleID+"'";
	_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("promoteSaleDate",_variant_t(promoteSaleDate));
		m_pRecordset->PutCollect("chargePerson",_variant_t(chargePerson.Left(50)));
		m_pRecordset->PutCollect("promoteSaleAddress",_variant_t(promoteSaleAddress.Left(50)));
	//	m_pRecordset->PutCollect("promoteSaleProduct",_variant_t(promoteSaleProduct.Left(50)));
		m_pRecordset->PutCollect("promoteSaleContent",_variant_t(promoteSaleContent.Left(50)));	
		
		m_pRecordset->Update();
	}
}

void CPromoteSale::sqlDelete(CString cPromoteSaleID)
{
	CString strSQL;
	strSQL="delete from promoteSale where promoteSaleID='";
	strSQL=strSQL+cPromoteSaleID+"'";
	(((CClientRelationshipApp*)AfxGetApp())->m_pConn)->Execute((_bstr_t)strSQL,NULL,adCmdText);

}

void CPromoteSale::GetData(CString cPromoteSaleID)
{
	CString strSQL;

	strSQL="select * from promoteSale where promoteSaleID='";
	strSQL+=cPromoteSaleID+"'";
	_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(!(m_pRecordset->adoEOF))
	{
		promoteSaleDate= m_pRecordset->GetCollect("promoteSaleDate");
		chargePerson= ((CClientRelationshipApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("chargePerson"));
		promoteSaleAddress= ((CClientRelationshipApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("promoteSaleAddress"));
	//	promoteSaleProduct= ((CClientRelationshipApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("promoteSaleProduct"));
		promoteSaleContent= ((CClientRelationshipApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("promoteSaleContent"));	
	}
}