khl.cpp

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

// khl.cpp : implementation file
//

#include "stdafx.h"
#include "khmanager.h"
#include "khl.h"
#include "ado.h"

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

/////////////////////////////////////////////////////////////////////////////
// khl dialog


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


void khl::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(khl)
	DDX_Control(pDX, IDC_LIST1, m_list);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(khl, CDialog)
	//{{AFX_MSG_MAP(khl)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// khl message handlers

BOOL khl::OnInitDialog() 
{
	CDialog::OnInitDialog();
		

m_list.ModifyStyle(0L,LVS_SHOWSELALWAYS);	
m_list.SetExtendedStyle(LVS_EX_GRIDLINES);
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 khl::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();
}