xltjdlg.cpp

旅行社的业务帮助系统

// XLTJDlg.cpp : implementation file
//

#include "stdafx.h"
#include "LXS.h"
#include "XLTJDlg.h"

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

/////////////////////////////////////////////////////////////////////////////
// CXLTJDlg dialog


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


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


BEGIN_MESSAGE_MAP(CXLTJDlg, CDialog)
	//{{AFX_MSG_MAP(CXLTJDlg)
	ON_BN_CLICKED(IDC_BUTTON1, Onxlqycx)
	ON_WM_CTLCOLOR()
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CXLTJDlg message handlers

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

int i=0;
while (!m_rs.IsEOF())
{m_listview.InsertItem(i,m_rs.m_xlbh);
m_listview.SetItemText(i,1,m_rs.m_xlmc);
m_listview.SetItemText(i,2,m_rs.m_xlqy);
m_listview.SetItemText(i,3,m_rs.m_sfd);
m_listview.SetItemText(i,4,m_rs.m_mdd);
m_listview.SetItemText(i,5,m_rs.m_crbj);
m_listview.SetItemText(i,6,m_rs.m_etbj);
m_listview.SetItemText(i,7,m_rs.m_wfjt);
m_listview.SetItemText(i,8,m_rs.m_jqmc);
m_listview.SetItemText(i,9,m_rs.m_xcts);
m_listview.SetItemText(i,10,m_rs.m_xllx);
m_listview.SetItemText(i,11,m_rs.m_xlrcap);
m_listview.SetItemText(i,12,m_rs.m_fjsm);

m_rs.MoveNext();

}		
}

BOOL CXLTJDlg::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,80);
m_listview.InsertColumn(9,"行程天数",LVCFMT_CENTER,80);
m_listview.InsertColumn(10,"线路类型",LVCFMT_CENTER,80);
m_listview.InsertColumn(11,"线路日程安排",LVCFMT_CENTER,200);
m_listview.InsertColumn(12,"附加说明",LVCFMT_CENTER,200);

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_xlbh);
m_listview.SetItemText(i,1,m_rs.m_xlmc);
m_listview.SetItemText(i,2,m_rs.m_xlqy);
m_listview.SetItemText(i,3,m_rs.m_sfd);
m_listview.SetItemText(i,4,m_rs.m_mdd);
m_listview.SetItemText(i,5,m_rs.m_crbj);
m_listview.SetItemText(i,6,m_rs.m_etbj);
m_listview.SetItemText(i,7,m_rs.m_wfjt);
m_listview.SetItemText(i,8,m_rs.m_jqmc);
m_listview.SetItemText(i,9,m_rs.m_xcts);
m_listview.SetItemText(i,10,m_rs.m_xllx);
m_listview.SetItemText(i,11,m_rs.m_xlrcap);
m_listview.SetItemText(i,12,m_rs.m_fjsm);

m_rs.MoveNext();

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

HBRUSH CXLTJDlg::OnCtlColor(CDC* pDC, CWnd* pWnd, UINT nCtlColor) 
{
	HBRUSH hbr = CDialog::OnCtlColor(pDC, pWnd, nCtlColor);
	if (nCtlColor==CTLCOLOR_STATIC)
pDC ->SetTextColor(RGB(100,150,200));

	// TODO: Change any attributes of the DC here
	
	// TODO: Return a different brush if the default is not desired
	return hbr;
}