marketplan.cpp

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

// MarketPlan.cpp: implementation of the CMarketPlan class.
//
//////////////////////////////////////////////////////////////////////

#include "stdafx.h"
#include "ClientRelationship.h"
#include "MarketPlan.h"

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

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

CMarketPlan::CMarketPlan()
{

}

CMarketPlan::~CMarketPlan()
{

}

CString	CMarketPlan::GetMarketPlanID()
{
	return marketPlanID;
}

COleDateTime	CMarketPlan::GetExecuteDate()
{
	return executeDate;
}

COleDateTime	CMarketPlan::GetEndDate()
{
	return endDate;
}

CString	CMarketPlan::GetJoinStaff()
{
	return joinStaff;
}

CString	CMarketPlan::GetPlanTitle()
{
	return planTitle;
}

CString	CMarketPlan::GetPlanStep()
{
	return planStep;
}

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

CString	CMarketPlan::GetPlanSummary()
{
	return planSummary;
}

void CMarketPlan::SetMarketPlanID(CString vMarketPlanID)
{
	marketPlanID=vMarketPlanID;
}

void CMarketPlan::SetExecuteDate(COleDateTime vExecuteDate)
{
	executeDate=vExecuteDate;
}

void CMarketPlan::SetEndDate(COleDateTime vEndDate)
{
	endDate=vEndDate;
}

void CMarketPlan::SetJoinStaff(CString vJoinStaff)
{
	joinStaff=vJoinStaff;
}

void CMarketPlan::SetPlanTitle(CString vPlanTitle)
{
	planTitle=vPlanTitle;
}

void CMarketPlan::SetPlanStep(CString vPlanStep)
{
	planStep=vPlanStep;
}

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

void CMarketPlan::SetPlanSummary(CString vPlanSummary)
{
	planSummary=vPlanSummary;
}

void CMarketPlan::sqlInsert()
{
	CString strSQL;

	strSQL="select * from marketPlan";
	_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("marketPlanID",_variant_t(marketPlanID));
		m_pRecordset->PutCollect("executeDate",_variant_t(executeDate));
		m_pRecordset->PutCollect("endDate",_variant_t(endDate));
		m_pRecordset->PutCollect("joinStaff",_variant_t(joinStaff.Left(50)));
		m_pRecordset->PutCollect("planTitle",_variant_t(planTitle.Left(50)));
		m_pRecordset->PutCollect("planStep",_variant_t(planStep.Left(50)));
		m_pRecordset->PutCollect("content",_variant_t(content.Left(50)));
		m_pRecordset->PutCollect("executeSummary",_variant_t(planSummary.Left(50)));
		
		m_pRecordset->Update();
	}
}

void CMarketPlan::sqlUpdate(CString cMarketPlanID)
{
	CString strSQL;

	strSQL="select * from marketPlan where marketPlanID='";
	strSQL+=cMarketPlanID+"'";
	_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("executeDate",_variant_t(executeDate));
		m_pRecordset->PutCollect("endDate",_variant_t(endDate));
		m_pRecordset->PutCollect("joinStaff",_variant_t(joinStaff.Left(50)));
		m_pRecordset->PutCollect("planTitle",_variant_t(planTitle.Left(50)));
		m_pRecordset->PutCollect("planStep",_variant_t(planStep.Left(50)));
		m_pRecordset->PutCollect("content",_variant_t(content.Left(50)));
		m_pRecordset->PutCollect("executeSummary",_variant_t(planSummary.Left(50)));
		
		m_pRecordset->Update();
	}
}

void CMarketPlan::sqlDelete(CString cMarketPlanID)
{
	CString strSQL;
	strSQL="delete from marketPlan where marketPlanID='";
	strSQL=strSQL+cMarketPlanID+"'";
	(((CClientRelationshipApp*)AfxGetApp())->m_pConn)->Execute((_bstr_t)strSQL,NULL,adCmdText);

}

void CMarketPlan::GetData(CString cMarketPlanID)
{
	CString strSQL;

	strSQL="select * from marketPlan where marketPlanID='";
	strSQL+=cMarketPlanID+"'";
	_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))
	{
		executeDate= m_pRecordset->GetCollect("executeDate");
		endDate= m_pRecordset->GetCollect("endDate");
		joinStaff= ((CClientRelationshipApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("joinStaff"));
		planTitle= ((CClientRelationshipApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("planTitle"));
		planStep= ((CClientRelationshipApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("planStep"));
		content= ((CClientRelationshipApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("content"));
		planSummary= ((CClientRelationshipApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("executeSummary"));
		
	}
}