qlxr.cpp

主要功能 客户管理系统主要由基础信息维护、客户信息维护、客户服务、信息查询、系统管理和帮助信息等几个功能模块组成

// qlxr.cpp : implementation file
//

#include "stdafx.h"
#include "khmanager.h"
#include "qlxr.h"
#include "ado.h"
#include "xlxr.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

/////////////////////////////////////////////////////////////////////////////
// qlxr dialog


qlxr::qlxr(CWnd* pParent /*=NULL*/)
: CDialog(qlxr::IDD, pParent)
{
	//{{AFX_DATA_INIT(qlxr)
	//}}AFX_DATA_INIT
}


void qlxr::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(qlxr)
	DDX_Control(pDX, IDC_EDIT1, m_edit);
	DDX_Control(pDX, IDC_LIST1, m_list);
	DDX_Control(pDX, IDC_COMBO2, m_com2);
	DDX_Control(pDX, IDC_COMBO1, m_com1);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(qlxr, CDialog)
//{{AFX_MSG_MAP(qlxr)
ON_BN_CLICKED(IDC_BUTTON2, OnButton2)
ON_BN_CLICKED(IDC_BUTTON1, OnButton1)
ON_CBN_SELCHANGE(IDC_COMBO1, OnSelchangeCombo1)
ON_NOTIFY(NM_DBLCLK, IDC_LIST1, OnDblclkList1)
//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// qlxr message handlers

BOOL qlxr::OnInitDialog() 
{
	CDialog::OnInitDialog();
	this->m_com1.AddString("联系人编号");
	this->m_com1.AddString("企业名称");
	this->m_com1.AddString("联系人姓名");
	this->m_com1.AddString("联系人性别");
	this->m_com1.AddString("年龄");
	this->m_com1.AddString("职位");
	this->m_com1.AddString("办公电话");
	this->m_com1.AddString("电子邮件");
	this->m_com1.AddString("手机");
	this->m_com2.AddString("like");
	this->m_com2.AddString("=");
	//	this->m_com2.AddString(">");
	//	this->m_com2.AddString("<");
	//	this->m_com2.AddString("<>");
	//	this->m_com2.AddString(">=");
	//	this->m_com2.AddString("<=");
	m_list.SetExtendedStyle(LVS_EX_GRIDLINES|
		LVS_EX_FULLROWSELECT|
		LVS_EX_HEADERDRAGDROP|
		LVS_EX_ONECLICKACTIVATE);
	m_list.InsertColumn(0,"联系人编号");
	m_list.InsertColumn(1,"企业名称");
	m_list.InsertColumn(2,"联系人姓名");
	m_list.InsertColumn(3,"联系人性别");
	m_list.InsertColumn(4,"年龄");
	m_list.InsertColumn(5,"职位");
	m_list.InsertColumn(6,"办公电话");
	m_list.InsertColumn(7,"电子邮件");
	m_list.InsertColumn(8,"手机");
	m_list.SetColumnWidth(0,100);
	m_list.SetColumnWidth(1,100);
	m_list.SetColumnWidth(2,100);
	m_list.SetColumnWidth(3,100);
	m_list.SetColumnWidth(4,100);
	m_list.SetColumnWidth(5,100);
	m_list.SetColumnWidth(6,100);
	m_list.SetColumnWidth(7,100);
	m_list.SetColumnWidth(8,100);
	this->loadlist();
	
	return TRUE;  // return TRUE unless you set the focus to a control
	// EXCEPTION: OCX Property Pages should return FALSE
}

void qlxr::OnButton2() 
{
	this->EndDialog(true);	
}

void qlxr::OnButton1() 
{
	m_list.DeleteAllItems();
	ado rst;
	CString sql,edit1,com1,com2;
	this->m_edit.GetWindowText(edit1);
	this->m_com2.GetWindowText(com2);
	this->m_com1.GetWindowText(com1);
	if(edit1.IsEmpty())
	{MessageBox("请输入","提示");
	return;
	}
	if(com1.IsEmpty())
	{MessageBox("请输入","提示");
	return;
	}
	if(com2.IsEmpty())
	{MessageBox("请输入","提示");
	return;
	}
	if(com2 == "=")
		sql.Format("select * from tb_Client_lxrxx where %s %s '%s'",ssel,com2,edit1);
	else
		sql.Format("select * from tb_Client_lxrxx where %s %s '%s%s%s'",ssel,com2,"%",edit1,"%");
	rst.Open(sql,adCmdText);
	int recordcount=rst.GetRecordCount();
	int ii;
	for(ii=1;ii<=recordcount;ii++)
	{
		m_list.InsertItem(ii-1,"");
		m_list.SetItemText(ii-1,0,rst.GetFieldValue("lxrxx_id"));
		m_list.SetItemText(ii-1,1,rst.GetFieldValue("lxrxx_qymc"));
		m_list.SetItemText(ii-1,2,rst.GetFieldValue("lxrxx_xm"));
		m_list.SetItemText(ii-1,3,rst.GetFieldValue("lxrxx_xb"));
		m_list.SetItemText(ii-1,4,rst.GetFieldValue("lxrxx_nl"));
		m_list.SetItemText(ii-1,5,rst.GetFieldValue("lxrxx_zw"));
		m_list.SetItemText(ii-1,6,rst.GetFieldValue("lxrxx_bgdh"));
		m_list.SetItemText(ii-1,7,rst.GetFieldValue("lxrxx_Email"));
		m_list.SetItemText(ii-1,8,rst.GetFieldValue("lxrxx_sj"));
		rst.Move(ii);
	}
	rst.close();
	
}
void qlxr::loadlist()
{
	ado rst;
	rst.Open("select * from tb_Client_lxrxx",adCmdText);
	int recordcount=rst.GetRecordCount();
	int ii;
	for(ii=1;ii<=recordcount;ii++)
	{
		m_list.InsertItem(ii-1,"");
		m_list.SetItemText(ii-1,0,rst.GetFieldValue("lxrxx_id"));
		m_list.SetItemText(ii-1,1,rst.GetFieldValue("lxrxx_qymc"));
		m_list.SetItemText(ii-1,2,rst.GetFieldValue("lxrxx_xm"));
		m_list.SetItemText(ii-1,3,rst.GetFieldValue("lxrxx_xb"));
		m_list.SetItemText(ii-1,4,rst.GetFieldValue("lxrxx_nl"));
		m_list.SetItemText(ii-1,5,rst.GetFieldValue("lxrxx_zw"));
		m_list.SetItemText(ii-1,6,rst.GetFieldValue("lxrxx_bgdh"));
		m_list.SetItemText(ii-1,7,rst.GetFieldValue("lxrxx_Email"));
		m_list.SetItemText(ii-1,8,rst.GetFieldValue("lxrxx_sj"));
		rst.Move(ii);
	}
	rst.close();
}

void qlxr::OnSelchangeCombo1() 
{
	switch(m_com1.GetCurSel())
	{
	case 0:
		ssel="lxrxx_id";
		break;
	case 1:
		ssel="lxrxx_qymc";
		break;
	case 2:
		ssel="lxrxx_xm";
		break;
	case 3:
		ssel="lxrxx_xb";
		break;
	case 4:
		ssel="lxrxx_nl";
		break;
	case 5:
		ssel="lxrxx_zw";
		break;
	case 6:
		ssel="lxrxx_bgdh";
		break;
	case 7:
		ssel="lxrxx_Email";
		break;
	case 8:
		ssel="lxrxx_sj";
		break;
	}
	
}

void qlxr::OnDblclkList1(NMHDR* pNMHDR, LRESULT* pResult) 
{
	int i=m_list.GetHotItem();
	if(i<0)
	{return;}
	xlxr l;
	ado rst;
	CString ss;
	ss.Format("select * from tb_Client_lxrxx where lxrxx_id='%s'",m_list.GetItemText(i,0));
	rst.rstOpen(ss);
	
	l.edit1=rst.GetFieldValue("lxrxx_id");
	l.com1=rst.GetFieldValue("lxrxx_qymc");
	l.edit2=rst.GetFieldValue("lxrxx_xm");
	l.com2=rst.GetFieldValue("lxrxx_xb");
	l.edit3=rst.GetFieldValue("lxrxx_nl");
	l.com3=rst.GetFieldValue("lxrxx_zw");
	l.edit4=rst.GetFieldValue("lxrxx_bgdh");
	l.edit5=rst.GetFieldValue("lxrxx_Email");
	l.edit6=rst.GetFieldValue("lxrxx_sj");
	l.date1=rst.GetFieldValue("lxrxx_csny");
	
	l.edit7=rst.GetFieldValue("lxrxx_grjj");
	l.date2=rst.GetFieldValue("lxrxx_djrq");
	l.edit8=rst.GetFieldValue("lxrxx_xxdjr");
	l.edit9=rst.GetFieldValue("lxrxx_bz");
	rst.close();
	l.DoModal();
	*pResult = 0;
}