advertise.cpp

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

// Advertise.cpp: implementation of the CAdvertise class.
//
//////////////////////////////////////////////////////////////////////

#include "stdafx.h"
#include "ClientRelationship.h"
#include "Advertise.h"

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

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

CAdvertise::CAdvertise()
{

}

CAdvertise::~CAdvertise()
{

}
CString CAdvertise::GetAdvertiseID()
{
	return advertiseID;
}

COleDateTime	CAdvertise::GetFormDate()
{
	return formDate;
}

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

float	CAdvertise::GetTrueInput()
{
	return trueInput;
}

CString	CAdvertise::GetPlanCompany()
{
	return planCompany;
}

CString	CAdvertise::GetProductName()
{
	return productName;
}

CString	CAdvertise::GetInputCondition()
{
	return inputCondition;
}

CString	CAdvertise::GetRemark()
{
	return remark;
}


void CAdvertise::SetAdvertiseID(CString vAdvertiseID)
{
	advertiseID=vAdvertiseID;
}

void CAdvertise::SetFormDate(COleDateTime vFormDate)
{
	formDate=vFormDate;
}

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

void CAdvertise::SetTrueInput(float vTrueInput)
{
	trueInput=vTrueInput;
}

void CAdvertise::SetPlanCompany(CString vPlanCompany)
{
	planCompany=vPlanCompany;
}

void CAdvertise::SetProductName(CString vProductName)
{
	productName=vProductName;
}

void CAdvertise::SetInputCondition(CString vInputCondition)
{
	inputCondition=vInputCondition;
}

void CAdvertise::SetRemark(CString vRemark)
{
	remark=vRemark;
}

void CAdvertise::sqlInsert()
{
	CString strSQL;

	strSQL="select * from advertise";
	_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("advertiseID",_variant_t(advertiseID));
		m_pRecordset->PutCollect("formDate",_variant_t(formDate));
		m_pRecordset->PutCollect("chargePerson",_variant_t(chargePerson.Left(50)));
		m_pRecordset->PutCollect("trueInput",_variant_t(trueInput));
		m_pRecordset->PutCollect("planCompany",_variant_t(planCompany.Left(50)));
		m_pRecordset->PutCollect("productName",_variant_t(productName.Left(50)));
		m_pRecordset->PutCollect("inputCondition",_variant_t(inputCondition.Left(50)));
		m_pRecordset->PutCollect("remark",_variant_t(remark.Left(50)));
		
		m_pRecordset->Update();
	}
}

void CAdvertise::sqlUpdate(CString cAdvertiseID)
{
	CString strSQL;
	
	strSQL="select * from advertise where advertiseID='";
	strSQL+=cAdvertiseID+"'";
	_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("formDate",_variant_t(formDate));
		m_pRecordset->PutCollect("chargePerson",_variant_t(chargePerson.Left(50)));
		m_pRecordset->PutCollect("trueInput",_variant_t(trueInput));
		m_pRecordset->PutCollect("planCompany",_variant_t(planCompany.Left(50)));
		m_pRecordset->PutCollect("productName",_variant_t(productName.Left(50)));
		m_pRecordset->PutCollect("inputCondition",_variant_t(inputCondition.Left(50)));
		m_pRecordset->PutCollect("remark",_variant_t(remark.Left(50)));
		
		m_pRecordset->Update();
	}
}

void CAdvertise::sqlDelete(CString cAdvertiseID)
{
	CString strSQL;
	strSQL="delete from advertise where advertiseID='";
	strSQL=strSQL+cAdvertiseID+"'";
	(((CClientRelationshipApp*)AfxGetApp())->m_pConn)->Execute((_bstr_t)strSQL,NULL,adCmdText);

}

void CAdvertise::GetData(CString cAdvertiseID)
{
	CString strSQL;
	strSQL="select * from advertise where advertiseID='";
	strSQL+=cAdvertiseID+"'";
	_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))
	{
		formDate= m_pRecordset->GetCollect("formDate");
		chargePerson= ((CClientRelationshipApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("chargePerson"));
		trueInput= m_pRecordset->GetCollect("trueInput");
		planCompany= ((CClientRelationshipApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("planCompany"));
		productName= ((CClientRelationshipApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("productName"));
		inputCondition= ((CClientRelationshipApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("inputCondition"));
		remark= ((CClientRelationshipApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("remark"));

	}
}