searchclient.cpp

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

// SearchClient.cpp : implementation file
//

#include "stdafx.h"
#include "ClientRelationship.h"
#include "SearchClient.h"
#include "ClientInforForm.h"
#include "ClientProductForm.h"
#include "ClientStaffForm.h"
#include "ClientContactForm.h"

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

/////////////////////////////////////////////////////////////////////////////
// CSearchClient dialog


CSearchClient::CSearchClient(CWnd* pParent /*=NULL*/)
	: CDialog(CSearchClient::IDD, pParent)
{
	//{{AFX_DATA_INIT(CSearchClient)
	m_clientID = _T("");
	m_contactPerson = _T("");
	m_clientName = _T("");
	m_address = _T("");
	m_manageRange = _T("");
	m_manageProduct = _T("");
	m_industryCharacter = _T("");
	m_scale = _T("");
	m_clientLevel = _T("");
	//}}AFX_DATA_INIT
}


void CSearchClient::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CSearchClient)
	DDX_Control(pDX, IDC_clientLevel, m_clientLevelCombo);
	DDX_Control(pDX, IDC_scale, m_scaleCombo);
	DDX_Control(pDX, IDC_industryCharacter, m_industryCharacterCombo);
	DDX_Control(pDX, IDC_manageProduct, m_manageProductCombo);
	DDX_Control(pDX, IDC_manageRange, m_manageRangeCombo);
	DDX_Control(pDX, IDC_address, m_addressCombo);
	DDX_Control(pDX, IDC_clientName, m_clientNameCombo);
	DDX_Control(pDX, IDC_contactPerson, m_contactPersonCombo);
	DDX_Control(pDX, IDC_clientID, m_clientIDCombo);
	DDX_Control(pDX, IDC_LIST1, m_list);
	DDX_CBString(pDX, IDC_clientID, m_clientID);
	DDX_CBString(pDX, IDC_contactPerson, m_contactPerson);
	DDX_CBString(pDX, IDC_clientName, m_clientName);
	DDX_CBString(pDX, IDC_address, m_address);
	DDX_CBString(pDX, IDC_manageRange, m_manageRange);
	DDX_CBString(pDX, IDC_manageProduct, m_manageProduct);
	DDX_CBString(pDX, IDC_industryCharacter, m_industryCharacter);
	DDX_CBString(pDX, IDC_scale, m_scale);
	DDX_CBString(pDX, IDC_clientLevel, m_clientLevel);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CSearchClient, CDialog)
	//{{AFX_MSG_MAP(CSearchClient)
	ON_BN_CLICKED(IDC_clientStaff, OnClientStaff)
	ON_BN_CLICKED(IDC_clientProduct, OnClientProduct)
	ON_BN_CLICKED(IDC_clientContact, OnClientContact)
	ON_BN_CLICKED(IDC_search, OnSearch)
	ON_NOTIFY(NM_CLICK, IDC_LIST1, OnClickList1)
	ON_NOTIFY(NM_DBLCLK, IDC_LIST1, OnDblclkList1)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CSearchClient message handlers

void CSearchClient::OnClientStaff() 
{
	CClientStaffForm dlg;
	if(dlg.DoModal()==IDOK)
	{
	}
	
}

void CSearchClient::OnClientProduct() 
{
	CClientProductForm dlg;
	if(dlg.DoModal()==IDOK)
	{
	}
	
}

void CSearchClient::OnClientContact() 
{
	CClientContactForm dlg;
	if(dlg.DoModal()==IDOK)
	{
	}
	
}

void CSearchClient::OnSearch() 
{
	UpdateData(true);

	CString strSQL;
	_RecordsetPtr m_pRecordset;
	HRESULT hTRes;
	hTRes = m_pRecordset.CreateInstance(_T("ADODB.Recordset"));	
	//构造sql语句
	strSQL="select * from client ";
	int flag=0;
	if(m_clientID!="")
	{
		strSQL+="where clientID='"+m_clientID+"' ";  //客户编号
		flag=1;
	}

	if(m_contactPerson!=""&&flag==1) //联系人
	{
		strSQL+=" and contactPerson='"+m_contactPerson+"' ";
	}
	else if(m_contactPerson!=""&&flag==0)
	{
		strSQL+="where contactPerson='"+m_contactPerson+"' ";
		flag=1;
	}
	if(m_clientName!=""&&flag==1)//单位名称
	{
		strSQL+=" and clientName='"+m_clientName+"' ";
	}
	else if(m_clientName!=""&&flag==0)
	{
		strSQL+="where clientName='"+m_clientName+"' ";
		flag=1;
	}
	if(m_address!=""&&flag==1)//地址
	{
		strSQL+=" and address='"+m_address+"' ";
	}
	else if(m_address!=""&&flag==0)
	{
		strSQL+="where address='"+m_address+"' ";
		flag=1;
	}
	if(m_manageRange!=""&&flag==1)//经营范围
	{
		strSQL+=" and manageRange='"+m_manageRange+"' ";
	}
	else if(m_manageRange!=""&&flag==0)
	{
		strSQL+="where manageRange='"+m_manageRange+"'";
		flag=1;
	}
	if(m_manageProduct!=""&&flag==1) //经营产品
	{
		strSQL+=" and manageProduct='"+m_manageProduct+"' ";
	}
	else if(m_manageProduct!=""&&flag==0)
	{
		strSQL+="where manageProduct='"+m_manageProduct+"' ";
		flag=1;
	}
	if(m_industryCharacter!=""&&flag==1)//行业性质
	{
		strSQL+=" and industryCharacter='"+m_industryCharacter+"' ";
	}
	else if(m_industryCharacter!=""&&flag==0)
	{
		strSQL+="where industryCharacter='"+m_industryCharacter+"' ";
		flag=1;
	}
	if(m_scale!=""&&flag==1)//规模
	{
		strSQL+=" and scale='"+m_scale+"' ";
	}
	else if(m_scale!=""&&flag==0)
	{
		strSQL+="where scale='"+m_scale+"' ";
		flag=1;
	}
	if(m_clientLevel!=""&&flag==1)//客户级别
	{
		strSQL+=" and clientLevel='"+m_clientLevel+"' ";
	}
	else if(m_clientLevel!=""&&flag==0)
	{
		strSQL+="where clientLevel='"+m_clientLevel+"' ";
		flag=1;
	}
	hTRes = m_pRecordset->Open((LPTSTR)strSQL.GetBuffer(130),
			((CClientRelationshipApp*)AfxGetApp())->m_pConn.GetInterfacePtr(),
			adOpenDynamic,adLockPessimistic,adCmdText);//打开查询结果记录集
	m_list.DeleteAllItems();
	int i=0;
	//将记录集中的所有记录插入到列表框中
	while(!(m_pRecordset->adoEOF))
	{
		CString str;
		m_list.InsertItem(i, ((CClientRelationshipApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("clientID")));//客户编号
		m_list.SetItemText(i,1, ((CClientRelationshipApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("clientName")));//单位名称
		COleDateTime bookinDate = m_pRecordset->GetCollect("bookinDate");//登记日期
		str.Format("%d-%d-%d",bookinDate.GetYear(),bookinDate.GetMonth(),bookinDate.GetDay());//将登记日期转换成字符串
		m_list.SetItemText(i,3,str);
		m_list.SetItemText(i,4,((CClientRelationshipApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("clientLevel")));//客户级别
		m_list.SetItemText(i,2, ((CClientRelationshipApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("contactPerson")));//联系人
		m_list.SetItemText(i,5, ((CClientRelationshipApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("areaID")));//地区
		m_list.SetItemText(i,6, ((CClientRelationshipApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("address")));//地址