qkh.cpp

客户管理系统 系统使用了全新的客户关系管理理念

// qkh.cpp : implementation file
//

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


/////////////////////////////////////////////////////////////////////////////
// qkh dialog


qkh::qkh(CWnd* pParent /*=NULL*/)
	: CDialog(qkh::IDD, pParent)
{
	//{{AFX_DATA_INIT(qkh)
		// NOTE: the ClassWizard will add member initialization here
	//}}AFX_DATA_INIT
}


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


BEGIN_MESSAGE_MAP(qkh, CDialog)
	//{{AFX_MSG_MAP(qkh)
	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()

/////////////////////////////////////////////////////////////////////////////
// qkh message handlers

BOOL qkh::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_com1.AddString("法人代表");
	this->m_com1.AddString("开户银行");
	this->m_com1.AddString("银行账号");
	this->m_com1.AddString("纳税号");
	this->m_com1.AddString("客户IC卡号");
	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.ModifyStyle(0L,LVS_SHOWSELALWAYS);	
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.InsertColumn(9,"法人代表");
m_list.InsertColumn(10,"开户银行");
m_list.InsertColumn(11,"银行账号");
m_list.InsertColumn(12,"纳税号");
m_list.InsertColumn(13,"客户IC卡号");
m_list.InsertColumn(14,"公司网址");
m_list.InsertColumn(15,"公司电话");
m_list.InsertColumn(16,"公司传真");
m_list.InsertColumn(17,"主要联系人");
m_list.InsertColumn(18,"联系人电话");
m_list.InsertColumn(19,"客户级别");
m_list.InsertColumn(20,"备注信息");

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);
m_list.SetColumnWidth(9,100);
m_list.SetColumnWidth(10,100);
m_list.SetColumnWidth(11,100);
m_list.SetColumnWidth(12,100);
m_list.SetColumnWidth(13,100);
m_list.SetColumnWidth(14,100);
m_list.SetColumnWidth(15,100);
m_list.SetColumnWidth(16,100);
m_list.SetColumnWidth(17,100);
m_list.SetColumnWidth(18,100);
m_list.SetColumnWidth(19,100);
m_list.SetColumnWidth(20,100);	
m_list.EnableAutomation();
this->loadlist();
	
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}
void qkh::loadlist()
{
	ado rst;
	rst.Open("select * from tb_khxx",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("khxx_id"));
m_list.SetItemText(ii-1,1,rst.GetFieldValue("khxx_mc"));
m_list.SetItemText(ii-1,2,rst.GetFieldValue("khxx_qyxz"));
m_list.SetItemText(ii-1,3,rst.GetFieldValue("khxx_qylx"));
m_list.SetItemText(ii-1,4,rst.GetFieldValue("khxx_qyzx"));
m_list.SetItemText(ii-1,5,rst.GetFieldValue("khxx_qydz"));
m_list.SetItemText(ii-1,6,rst.GetFieldValue("khxx_szsf"));
m_list.SetItemText(ii-1,7,rst.GetFieldValue("khxx_szcs"));
m_list.SetItemText(ii-1,8,rst.GetFieldValue("khxx_gsyb"));
m_list.SetItemText(ii-1,9,rst.GetFieldValue("khxx_frdb"));
m_list.SetItemText(ii-1,10,rst.GetFieldValue("khxx_khyh"));
m_list.SetItemText(ii-1,11,rst.GetFieldValue("khxx_yhzh"));
m_list.SetItemText(ii-1,12,rst.GetFieldValue("khxx_nsh"));
m_list.SetItemText(ii-1,13,rst.GetFieldValue("khxx_ICcard"));
m_list.SetItemText(ii-1,14,rst.GetFieldValue("khxx_gswz"));
m_list.SetItemText(ii-1,15,rst.GetFieldValue("khxx_gsdh"));
m_list.SetItemText(ii-1,16,rst.GetFieldValue("khxx_gscz"));
m_list.SetItemText(ii-1,17,rst.GetFieldValue("khxx_lxr"));
m_list.SetItemText(ii-1,18,rst.GetFieldValue("khxx_lxrdh"));
m_list.SetItemText(ii-1,19,rst.GetFieldValue("khxx_khjb"));
m_list.SetItemText(ii-1,20,rst.GetFieldValue("khxx_bz"));
rst.Move(ii);
}
rst.close();
}

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

void qkh::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(com2.IsEmpty())
		{MessageBox("请输入","提示");
			return;
		}
		if(com1.IsEmpty())
		{MessageBox("请输入","提示");
			return;
		}
	sql.Format("select * from tb_khxx where %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("khxx_id"));
m_list.SetItemText(ii-1,1,rst.GetFieldValue("khxx_mc"));
m_list.SetItemText(ii-1,2,rst.GetFieldValue("khxx_qyxz"));
m_list.SetItemText(ii-1,3,rst.GetFieldValue("khxx_qylx"));
m_list.SetItemText(ii-1,4,rst.GetFieldValue("khxx_qyzx"));
m_list.SetItemText(ii-1,5,rst.GetFieldValue("khxx_qydz"));
m_list.SetItemText(ii-1,6,rst.GetFieldValue("khxx_szsf"));
m_list.SetItemText(ii-1,7,rst.GetFieldValue("khxx_szcs"));
m_list.SetItemText(ii-1,8,rst.GetFieldValue("khxx_gsyb"));
m_list.SetItemText(ii-1,9,rst.GetFieldValue("khxx_frdb"));
m_list.SetItemText(ii-1,10,rst.GetFieldValue("khxx_khyh"));
m_list.SetItemText(ii-1,11,rst.GetFieldValue("khxx_yhzh"));
m_list.SetItemText(ii-1,12,rst.GetFieldValue("khxx_nsh"));
m_list.SetItemText(ii-1,13,rst.GetFieldValue("khxx_ICcard"));
m_list.SetItemText(ii-1,14,rst.GetFieldValue("khxx_gswz"));
m_list.SetItemText(ii-1,15,rst.GetFieldValue("khxx_gsdh"));
m_list.SetItemText(ii-1,16,rst.GetFieldValue("khxx_gscz"));
m_list.SetItemText(ii-1,17,rst.GetFieldValue("khxx_lxr"));
m_list.SetItemText(ii-1,18,rst.GetFieldValue("khxx_lxrdh"));
m_list.SetItemText(ii-1,19,rst.GetFieldValue("khxx_khjb"));
m_list.SetItemText(ii-1,20,rst.GetFieldValue("khxx_bz"));
rst.Move(ii);
}

rst.close();
}




void qkh::OnSelchangeCombo1() 
{
	switch(m_com1.GetCurSel())
	{
	case 0:
		
		ssel="khxx_id";
		break;
		case 1:
			ssel="khxx_mc";
		break;
		case 2:
			ssel="khxx_qyxz";
		break;
		case 3:
			ssel="khxx_qylx";
		break;
		case 4:
			ssel="khxx_qyzx";
		break;
		case 5:
			ssel="khxx_qydz";
		break;
		case 6:
			ssel="khxx_szsf";
		break;
		case 7:
			ssel="khxx_szcs";
		break;
		case 8:
			ssel="khxx_gsyb";
		break;
		case 9:
			ssel="khxx_frdb";
		break;
		case 10:
			ssel="khxx_khyh";
		break;
		case 11:
			ssel="khxx_yhzh";
		break;
		case 12:
			ssel="khxx_nsh";
		break;
		case 13:
			ssel="khxx_ICcard";
		break;
		case 14:
			ssel="khxx_gswz";
		break;
		case 15:
			ssel="khxx_gsdh";
		break;
		case 16:
			ssel="khxx_gscz";
		break;
		case 17:
			ssel="khxx_lxr";
		break;
		case 18:
			ssel="khxx_lxrdh";
		break;
		case 19:
			ssel="khxx_khjb";
		break;
		case 20:
			ssel="khxx_bz";
		break;
	}
	
}

void qkh::OnDblclkList1(NMHDR* pNMHDR, LRESULT* pResult) 
{
	int i=m_list.GetHotItem();
	if(i<0)
	{return;}
	xkh k;
	ado rst;
	CString ss;
	ss.Format("select * from tb_khxx where khxx_id='%s'",m_list.GetItemText(i,0));
	rst.rstOpen(ss);

k.edit1=rst.GetFieldValue("khxx_id");
k.edit8=rst.GetFieldValue("khxx_mc");
k.com1=rst.GetFieldValue("khxx_qyxz");
k.com2=rst.GetFieldValue("khxx_qylx");
k.com5=rst.GetFieldValue("khxx_qyzx");
k.edit2=rst.GetFieldValue("khxx_qydz");
k.com3=rst.GetFieldValue("khxx_szsf");
k.edit9=rst.GetFieldValue("khxx_szcs");
k.edit3=rst.GetFieldValue("khxx_gsyb");
k.edit10=rst.GetFieldValue("khxx_frdb");
k.edit12=rst.GetFieldValue("khxx_khyh");
k.edit4=rst.GetFieldValue("khxx_yhzh");
k.edit11=rst.GetFieldValue("khxx_nsh");
k.edit13=rst.GetFieldValue("khxx_ICcard");
k.edit5=rst.GetFieldValue("khxx_gswz");
k.edit14=rst.GetFieldValue("khxx_gsdh");
k.edit6=rst.GetFieldValue("khxx_gscz");
k.edit15=rst.GetFieldValue("khxx_lxr");
k.edit7=rst.GetFieldValue("khxx_lxrdh");
k.com4=rst.GetFieldValue("khxx_khjb");
k.edit16=rst.GetFieldValue("khxx_bz");
	rst.close();
	k.DoModal();
	*pResult = 0;
}