khlytjdlg.cpp

旅行社的业务帮助系统

// KHLYTJDlg.cpp : implementation file
//

#include "stdafx.h"
#include "LXS.h"
#include "KHLYTJDlg.h"

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

/////////////////////////////////////////////////////////////////////////////
// CKHLYTJDlg dialog


CKHLYTJDlg::CKHLYTJDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CKHLYTJDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CKHLYTJDlg)
	m_combkhly = -1;
	//}}AFX_DATA_INIT
}


void CKHLYTJDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CKHLYTJDlg)
	DDX_Control(pDX, IDC_COMBO1, m_comb);
	DDX_Control(pDX, IDC_LIST1, m_listview);
	DDX_CBIndex(pDX, IDC_COMBO1, m_combkhly);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CKHLYTJDlg, CDialog)
	//{{AFX_MSG_MAP(CKHLYTJDlg)
	ON_BN_CLICKED(IDC_BUTTON1, OnKHLYXX)
	ON_WM_CTLCOLOR()
//ON_NOTIFY_REFLECT(NM_CUSTOMDRAW, OnCustomDraw) 

	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CKHLYTJDlg message handlers

void CKHLYTJDlg::OnKHLYXX() 
{
	// TODO: Add your control notification handler code here
CString   str; 
m_comb.GetLBText(m_comb.GetCurSel(),str);
CString strSql=CString("select * from KHXX where khly like '")+str+"'";
if(m_rs.IsOpen())
m_rs.Close();
m_rs.Open(KHXXSet::snapshot,strSql);
m_listview.DeleteAllItems();
m_rs.MoveFirst();

int i=0;
while (!m_rs.IsEOF())
{m_listview.InsertItem(i,m_rs.m_khbh);
m_listview.SetItemText(i,1,m_rs.m_khxm);
m_listview.SetItemText(i,2,m_rs.m_khlxfs);
m_listview.SetItemText(i,3,m_rs.m_xb);
m_listview.SetItemText(i,4,m_rs.m_zjlx);
m_listview.SetItemText(i,5,m_rs.m_zjh);
m_listview.SetItemText(i,6,m_rs.m_khlx);
m_listview.SetItemText(i,7,m_rs.m_csrq);
m_listview.SetItemText(i,8,m_rs.m_gzdw);
m_listview.SetItemText(i,9,m_rs.m_khly);
m_listview.SetItemText(i,10,m_rs.m_khzz);

m_rs.MoveNext();

}	

}

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

m_listview.InsertColumn(0,"客户编号",LVCFMT_CENTER,80);
m_listview.InsertColumn(1,"客户姓名",LVCFMT_CENTER,80);
m_listview.InsertColumn(2,"联系方式",LVCFMT_CENTER,80);
m_listview.InsertColumn(3,"性别",LVCFMT_CENTER,80);
m_listview.InsertColumn(4,"证件类型",LVCFMT_CENTER,80);
m_listview.InsertColumn(5,"证件号",LVCFMT_CENTER,80);
m_listview.InsertColumn(6,"客户类型",LVCFMT_CENTER,80);
m_listview.InsertColumn(7,"出生日期",LVCFMT_CENTER,80);
m_listview.InsertColumn(8,"工作单位",LVCFMT_CENTER,100);
m_listview.InsertColumn(9,"客户来源",LVCFMT_CENTER,80);
m_listview.InsertColumn(10,"住址",LVCFMT_CENTER,100);

SetWindowLong(m_listview.m_hWnd,GWL_STYLE,WS_CHILD|WS_VISIBLE|WS_BORDER|LVS_REPORT);
m_listview.SetExtendedStyle(LVS_EX_FULLROWSELECT|LVS_EX_GRIDLINES);	
	// TODO: Add extra initialization here
m_db.Open(_T("lxsDSN"));
m_rs.m_pDatabase=&m_db;

if(!m_rs.IsOpen())
m_rs.Open();
m_rs.MoveFirst();

int i=0;
while (!m_rs.IsEOF())
{m_listview.InsertItem(i,m_rs.m_khbh);
m_listview.SetItemText(i,1,m_rs.m_khxm);
m_listview.SetItemText(i,2,m_rs.m_khlxfs);
m_listview.SetItemText(i,3,m_rs.m_xb);
m_listview.SetItemText(i,4,m_rs.m_zjlx);
m_listview.SetItemText(i,5,m_rs.m_zjh);
m_listview.SetItemText(i,6,m_rs.m_khlx);
m_listview.SetItemText(i,7,m_rs.m_csrq);
m_listview.SetItemText(i,8,m_rs.m_gzdw);
m_listview.SetItemText(i,9,m_rs.m_khly);
m_listview.SetItemText(i,10,m_rs.m_khzz);

m_rs.MoveNext();

}	
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}


HBRUSH CKHLYTJDlg::OnCtlColor (CDC * pDC , CWnd * pWnd , UINT nCtlColor)
{
	HBRUSH hbr = CDialog::OnCtlColor (pDC, pWnd,nCtlColor);
/*HBRUSH m_hBrush1; 
HBRUSH m_hBrush2; 
HBRUSH m_hBrush3; 
 //Draw red text for all edit controls .
//if (nCtlColor==CTLCOLOR_DLG)
//pDC ->SetBkColor(RGB(143,188,139));
//pDC ->SetBkColor(RGB(255,0,0));
/*if(nCtlColor==CTLCOLOR_DLG) 
pDC->SetBkColor(RGB(100,150,200)); 
hbr=m_hBrush1;
if (nCtlColor==CTLCOLOR_STATIC)
pDC ->SetTextColor(RGB(255,0,0));

switch(nCtlColor)
{
case CTLCOLOR_STATIC:
	{pDC ->SetTextColor(RGB(255,0,0));
hbr=m_hBrush1;
	}

case CTLCOLOR_DLG:
	{pDC ->SetBkColor(RGB(143,188,139));
hbr=m_hBrush2;

	}

}
*/
if (nCtlColor==CTLCOLOR_STATIC)
pDC ->SetTextColor(RGB(100,150,200));

return hbr;
}