policypublish.cpp

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

// PolicyPublish.cpp: implementation of the CPolicyPublish class.
//
//////////////////////////////////////////////////////////////////////

#include "stdafx.h"
#include "ClientRelationship.h"
#include "PolicyPublish.h"

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

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

CPolicyPublish::CPolicyPublish()
{

}

CPolicyPublish::~CPolicyPublish()
{

}

CString CPolicyPublish::GetPolicyPublishID()
{
	return policyPublishID;
}

COleDateTime	CPolicyPublish::GetPublishDate()
{
	return publishDate;
}

CString	CPolicyPublish::GetSubject()
{
	return subject;
}

CString	CPolicyPublish::GetBriefContent()
{
	return briefContent;
}

CString	CPolicyPublish::GetInfluence()
{
	return influence;
}

void CPolicyPublish::SetPolicyPublishID(CString vPolicyPublishID)
{
	policyPublishID=vPolicyPublishID;
}

void CPolicyPublish::SetPublishDate(COleDateTime vPublishDate)
{
	publishDate=vPublishDate;
}

void CPolicyPublish::SetSubject(CString vSubject)
{
	subject=vSubject;
}

void CPolicyPublish::SetBriefContent(CString vBriefContent)
{
	briefContent=vBriefContent;
}

void CPolicyPublish::SetInfluence(CString vInfluence)
{
	influence=vInfluence;
}

void CPolicyPublish::sqlInsert()
{
	CString strSQL;

	strSQL="select * from policyPublish";
	_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("policyPublishID",_variant_t(policyPublishID));
		m_pRecordset->PutCollect("publishDate",_variant_t(publishDate));
		m_pRecordset->PutCollect("subject",_variant_t(subject.Left(50)));
		m_pRecordset->PutCollect("briefContent",_variant_t(briefContent.Left(50)));
		m_pRecordset->PutCollect("influence",_variant_t(influence.Left(50)));
	
		
		m_pRecordset->Update();
	}
}

void CPolicyPublish::sqlUpdate(CString cPolicyPublishID)
{
	CString strSQL;	

	strSQL="select * from policyPublish where policyPublishID='";
	strSQL=strSQL+cPolicyPublishID+"'";
	_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))
	{		
	//	m_pRecordset->PutCollect("policyPublishID",_variant_t(policyPublishID));
		m_pRecordset->PutCollect("publishDate",_variant_t(publishDate));
		m_pRecordset->PutCollect("subject",_variant_t(subject.Left(50)));
		m_pRecordset->PutCollect("briefContent",_variant_t(briefContent.Left(50)));
		m_pRecordset->PutCollect("influence",_variant_t(influence.Left(50)));	
		
		m_pRecordset->Update();
	}
}

void CPolicyPublish::sqlDelete(CString cPolicyPublishID)
{
	CString strSQL;
	strSQL="delete from policyPublish where policyPublishID='";
	strSQL=strSQL+cPolicyPublishID+"'";
	(((CClientRelationshipApp*)AfxGetApp())->m_pConn)->Execute((_bstr_t)strSQL,NULL,adCmdText);
}

void CPolicyPublish::GetData(CString cPolicyPublishID)
{
	CString strSQL;


	strSQL="select * from policyPublish where policyPublishID='";
	strSQL=strSQL+cPolicyPublishID+"'";
	_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))
	{		
		policyPublishID= atoi(((CClientRelationshipApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("policyPublishID")));
		publishDate= m_pRecordset->GetCollect("publishDate");
		subject= ((CClientRelationshipApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("subject"));
		briefContent= ((CClientRelationshipApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("briefContent"));
		influence= ((CClientRelationshipApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("influence"));	
		
		m_pRecordset->Update();
	}
}