newsissue.cpp

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

// NewsIssue.cpp: implementation of the CNewsIssue class.
//
//////////////////////////////////////////////////////////////////////

#include "stdafx.h"
#include "ClientRelationship.h"
#include "NewsIssue.h"

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

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

CNewsIssue::CNewsIssue()
{

}

CNewsIssue::~CNewsIssue()
{

}

CString CNewsIssue::GetNewsIssueID()
{
	return newsIssueID;
}

COleDateTime	CNewsIssue::GetIssueDate()
{
	return issueDate;
}

CString	CNewsIssue::GetIssuePerson()
{
	return issuePerson;
}

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

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

void CNewsIssue::SetNewsIssueID(CString vNewsIssueID)
{
	newsIssueID=vNewsIssueID;
}

void CNewsIssue::SetIssueDate(COleDateTime vIssueDate)
{
	issueDate=vIssueDate;
}

void CNewsIssue::SetIssuePerson(CString vIssuePerson)
{
	issuePerson=vIssuePerson;
}

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

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

void CNewsIssue::sqlInsert()
{
	CString strSQL;

	strSQL="select * from newsIssue";
	_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("newsIssueID",_variant_t(newsIssueID));
		m_pRecordset->PutCollect("issueDate",_variant_t(issueDate));
		m_pRecordset->PutCollect("issuePerson",_variant_t(issuePerson.Left(50)));
		m_pRecordset->PutCollect("subject",_variant_t(subject.Left(50)));
		m_pRecordset->PutCollect("content",_variant_t(content.Left(50)));	
		
		m_pRecordset->Update();
	}
}

void CNewsIssue::sqlUpdate(CString cNewsIssueID)
{
	CString strSQL;
	
	strSQL="select * from newsIssue where newsIssueID='";
	strSQL+=cNewsIssueID+"'";
	_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("issueDate",_variant_t(issueDate));
		m_pRecordset->PutCollect("issuePerson",_variant_t(issuePerson.Left(50)));
		m_pRecordset->PutCollect("subject",_variant_t(subject.Left(50)));
		m_pRecordset->PutCollect("content",_variant_t(content.Left(50)));	
		
		m_pRecordset->Update();
	}
}

void CNewsIssue::sqlDelete(CString cNewsIssueID)
{
	CString strSQL;
	strSQL="delete from newsIssue where newsIssueID='";
	strSQL=strSQL+cNewsIssueID+"'";
	(((CClientRelationshipApp*)AfxGetApp())->m_pConn)->Execute((_bstr_t)strSQL,NULL,adCmdText);
}

void CNewsIssue::GetData(CString cNewsIssueID)
{
	CString strSQL;
	strSQL="select * from newsIssue where newsIssueID='";
	strSQL+=cNewsIssueID+"'";
	_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))
	{
		issueDate= m_pRecordset->GetCollect("issueDate");
		issuePerson= ((CClientRelationshipApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("issuePerson"));
		subject= ((CClientRelationshipApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("subject"));
		content= ((CClientRelationshipApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("content"));	
	}
}