clientreserve.cpp

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

// ClientReserve.cpp: implementation of the CClientReserve class.
//
//////////////////////////////////////////////////////////////////////

#include "stdafx.h"
#include "ClientRelationship.h"
#include "ClientReserve.h"

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

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

CClientReserve::CClientReserve()
{

}

CClientReserve::~CClientReserve()
{

}
CString CClientReserve::GetClientReserveID()
{
	return clientReserveID;
}

COleDateTime	CClientReserve::GetReserveTime()
{
	return reserveTime;
}

CString	CClientReserve::GetReserveStyle()
{
	return reserveStyle;
}

CString	CClientReserve::GetAttendStaff()
{
	return attendStaff;
}

CString	CClientReserve::GetClientName()
{
	return clientName;
}

CString	CClientReserve::GetClientStaff()
{
	return clientStaff;
}

CString	CClientReserve::GetTelephone()
{
	return telephone;
}

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

CString	CClientReserve::GetAddress()
{
	return address;
}

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

int		CClientReserve::GetRemindNum()
{
	return remindNum;
}

BOOL	CClientReserve::GetIs_everyDay()
{
	return is_everyDay;
}
	
void CClientReserve::SetClientReserveID(CString vClientReserveID)
{
	clientReserveID=vClientReserveID;
}

void CClientReserve::SetReserveTime(COleDateTime vReserveTime)
{
	reserveTime=vReserveTime;
}

void CClientReserve::SetReserveStyle(CString vReserveStyle)
{
	reserveStyle=vReserveStyle;
}

void CClientReserve::SetAttendStaff(CString vAttendStaff)
{
	attendStaff=vAttendStaff;
}

void CClientReserve::SetClientName(CString vClientName)
{
	clientName=vClientName;
}

void CClientReserve::SetClientStaff(CString vClientStaff)
{
	clientStaff=vClientStaff;
}

void CClientReserve::SetTelephone(CString vTelephone)
{
	telephone=vTelephone;
}

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

void CClientReserve::SetAddress(CString vAddress)
{
	address=vAddress;
}

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

void CClientReserve::SetRemindNum(int vRemindNum)
{
	remindNum=vRemindNum;
}

void CClientReserve::SetIs_everyDay(BOOL vIs_everyDay)
{
	is_everyDay=vIs_everyDay;
}

void CClientReserve::sqlInsert()
{
	CString strSQL;

	strSQL="select * from clientReserve";
	_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();
		CString str;
		m_pRecordset->PutCollect("clientReserveID",_variant_t(clientReserveID));
		m_pRecordset->PutCollect("reserveTime",_variant_t(reserveTime));
		m_pRecordset->PutCollect("reserveStyle",_variant_t(reserveStyle.Left(50)));
		m_pRecordset->PutCollect("attendStaff",_variant_t(attendStaff.Left(50)));
		m_pRecordset->PutCollect("clientName",_variant_t(clientName.Left(50)));
		m_pRecordset->PutCollect("clientStaff",_variant_t(clientStaff.Left(50)));
		m_pRecordset->PutCollect("telephone",_variant_t(telephone.Left(50)));
		m_pRecordset->PutCollect("subject",_variant_t(subject.Left(50)));
		m_pRecordset->PutCollect("address",_variant_t(address.Left(100)));
		m_pRecordset->PutCollect("content",_variant_t(content.Left(50)));
		str.Format("%d",remindNum);
		m_pRecordset->PutCollect("remindNum",_variant_t(str));
//		if(is_everyDay==true)
//			m_pRecordset->PutCollect("isEveryDay",_variant_t("T"));
//		else
//			m_pRecordset->PutCollect("isEveryDay",_variant_t("F"));
	
		m_pRecordset->Update();
	}
}

void CClientReserve::sqlUpdate(CString cClientReserveID)
{
	CString strSQL;

	strSQL="select * from clientReserve where clientReserveID='";
	strSQL=strSQL+cClientReserveID+"'";
	_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))
	{	
		CString str;
		m_pRecordset->PutCollect("clientReserveID",_variant_t(cClientReserveID));
		m_pRecordset->PutCollect("reserveTime",_variant_t(reserveTime));
		m_pRecordset->PutCollect("reserveStyle",_variant_t(reserveStyle.Left(50)));
		m_pRecordset->PutCollect("attendStaff",_variant_t(attendStaff.Left(50)));
		m_pRecordset->PutCollect("clientName",_variant_t(clientName.Left(50)));
		m_pRecordset->PutCollect("clientStaff",_variant_t(clientStaff.Left(50)));
		m_pRecordset->PutCollect("telephone",_variant_t(telephone.Left(50)));
		m_pRecordset->PutCollect("subject",_variant_t(subject.Left(50)));
		m_pRecordset->PutCollect("address",_variant_t(address.Left(100)));
		m_pRecordset->PutCollect("content",_variant_t(content.Left(50)));
		str.Format("%d",remindNum);
		m_pRecordset->PutCollect("remindNum",_variant_t(str));
//		if(is_everyDay==true)
//			m_pRecordset->PutCollect("isEveryDay",_variant_t("T"));
//		else
//			m_pRecordset->PutCollect("isEveryDay",_variant_t("F"));
	
		m_pRecordset->Update();
	}
}
void CClientReserve::sqlDelete(CString cClientReserveID)
{
	CString strSQL;
	strSQL="delete from clientReserve where clientReserveID='";
	strSQL=strSQL+cClientReserveID+"'";
	(((CClientRelationshipApp*)AfxGetApp())->m_pConn)->Execute((_bstr_t)strSQL,NULL,adCmdText);

}

void CClientReserve::GetData(CString cClientReserveID)
{
	CString strSQL;

	strSQL="select * from clientReserve where clientReserveID='";
	strSQL=strSQL+cClientReserveID+"'";
	_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))
	{	
		reserveTime= m_pRecordset->GetCollect("reserveTime");
		reserveStyle= ((CClientRelationshipApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("reserveStyle"));
		attendStaff= ((CClientRelationshipApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("attendStaff"));
		clientName= ((CClientRelationshipApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("clientName"));
		clientStaff= ((CClientRelationshipApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("clientStaff"));
		telephone= ((CClientRelationshipApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("telephone"));
		subject= ((CClientRelationshipApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("subject"));
		address= ((CClientRelationshipApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("address"));
		content= ((CClientRelationshipApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("content"));		
		remindNum= atoi(((CClientRelationshipApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("remindNum")));
	//	is_everyDay= ((CClientRelationshipApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("isEveryDay"));
		
	}
}