jdzldlg.cpp

旅行社的业务帮助系统

// JDZLDlg.cpp : implementation file
//

#include "stdafx.h"
#include "LXS.h"
#include "JDZLDlg.h"

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

/////////////////////////////////////////////////////////////////////////////
// CJDZLDlg dialog


CJDZLDlg::CJDZLDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CJDZLDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CJDZLDlg)
	m_dh = _T("");
	m_jdmc = _T("");
	m_lxr = _T("");
	m_szcs = _T("");
	m_jdzljdmc = _T("");
	//}}AFX_DATA_INIT
}


void CJDZLDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CJDZLDlg)
	DDX_Control(pDX, IDC_jdzlLIST, m_jdzllist);
	DDX_Text(pDX, IDC_dh, m_dh);
	DDX_Text(pDX, IDC_jdmc, m_jdmc);
	DDX_Text(pDX, IDC_lxr, m_lxr);
	DDX_Text(pDX, IDC_szcs, m_szcs);
	DDX_Text(pDX, IDC_jdzljdmc, m_jdzljdmc);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CJDZLDlg, CDialog)
	//{{AFX_MSG_MAP(CJDZLDlg)
	ON_BN_CLICKED(IDC_jdzlbc, Onjdzlbc)
	ON_BN_CLICKED(IDC_jdzlsc, Onjdzlsc)
	ON_BN_CLICKED(IDC_jdzlcx, Onjdzlcx)
	ON_NOTIFY(NM_CLICK, IDC_jdzlLIST, OnClickjdzlLIST)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CJDZLDlg message handlers

BOOL CJDZLDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
		// TODO: Add extra initialization here
	m_jdzllist.InsertColumn(0,"景点名称",LVCFMT_LEFT,80);
	m_jdzllist.InsertColumn(1,"所在城市",LVCFMT_LEFT,100);
	m_jdzllist.InsertColumn(2,"联系人",LVCFMT_LEFT,100);
	m_jdzllist.InsertColumn(3,"联系电话",LVCFMT_LEFT,100);
	m_jdzllist.InsertColumn(4,"说明",LVCFMT_LEFT,100);
	m_jdzllist.SetExtendedStyle(LVS_EX_FULLROWSELECT|LVS_EX_GRIDLINES);
	ListAll();
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CJDZLDlg::ListAll()
{
m_jdzllist.DeleteAllItems();
	if(!m_rs.IsOpen())
		m_rs.Open();
	int i=0;
	//m_rs.MoveFirst();

	while(!m_rs.IsEOF())
	{
		m_jdzllist.InsertItem(i,m_rs.m_jqmc);
        m_jdzllist.SetItemText(i,1,m_rs.m_szcs);
		m_jdzllist.SetItemText(i,2,m_rs.m_lxr);
		m_jdzllist.SetItemText(i,3,m_rs.m_dh);
		m_jdzllist.SetItemText(i,4,m_rs.m_sm);
		m_rs.MoveNext();
		i++;
	}
}

void CJDZLDlg::Onjdzlbc() 
{
	// TODO: Add your control notification handler code here
		POSITION pos=m_jdzllist.GetFirstSelectedItemPosition();
	int m_CurUser=m_jdzllist.GetNextSelectedItem(pos);
	UpdateData(TRUE);
	if(m_rs.IsOpen())
		m_rs.Close();
	m_rs.Open();

	if(m_rs.IsEOF())
	{
		m_rs.Close();
		AfxMessageBox("没有该记录，不能修改！");
		return;
	}
	try
	{
			m_rs.Edit();
			m_rs.m_jqmc=m_jdmc;
			m_rs.m_szcs=m_szcs;
			m_rs.m_lxr=m_lxr;
			m_rs.m_dh=m_dh;
	if(m_rs.CanUpdate())
	m_rs.Update();
      AfxMessageBox("保存成功！");
	}
	catch(CDBException* e)
	{
		AfxMessageBox(e->m_strError,MB_ICONEXCLAMATION);
		e->Delete();
	}
		m_jdzllist.SetItemText(m_CurUser,0,m_jdmc);
		m_jdzllist.SetItemText(m_CurUser,1,m_szcs);
		m_jdzllist.SetItemText(m_CurUser,2,m_lxr);
		m_jdzllist.SetItemText(m_CurUser,3,m_dh);
		
}

void CJDZLDlg::Onjdzlsc() 
{
	// TODO: Add your control notification handler code here
		if(m_rs.IsOpen())
		m_rs.Close();
	m_rs.Open();
	if(m_rs.IsEOF())
	{
		AfxMessageBox("没有该记录!");
		return;
	}
	int index=m_jdzllist.GetNextItem(-1,LVNI_SELECTED);
	m_jdzllist.DeleteItem(index);
	try
	{
		m_rs.Delete();

	}
	catch(CDBException * e)
	{
		AfxMessageBox(e->m_strError,MB_ICONEXCLAMATION);
		e->Delete();
		return;
	}
	try
	{
		m_rs.Requery();
	}
	catch(CDBException * e)
	{
	   AfxMessageBox("Can not Requery!",MB_ICONEXCLAMATION);
	   e->Delete();
	}	 
	m_rs.Close();
}

void CJDZLDlg::Onjdzlcx() 
{
	// TODO: Add your control notification handler code here
		UpdateData(TRUE);
	if(m_rs.IsOpen())
	m_rs.Close();
	m_rs.m_strFilter="jqmc like '%"+m_jdzljdmc+"%'";
	m_rs.Open();
	if(m_rs.IsEOF())
	{AfxMessageBox("没有符合条件的记录！");
	return;
	}
	m_jdzllist.DeleteAllItems();
	if(!m_rs.IsOpen())
		m_rs.Open();
	int i=0;
	m_rs.MoveLast();
	while(!m_rs.IsBOF())
	{
		m_jdzllist.InsertItem(i,m_rs.m_jqmc);
        m_jdzllist.SetItemText(i,1,m_rs.m_szcs);
		m_jdzllist.SetItemText(i,2,m_rs.m_lxr);
		m_jdzllist.SetItemText(i,3,m_rs.m_dh);
		i++;
		m_rs.MovePrev();
	}
		m_rs.Close();
}

void CJDZLDlg::OnClickjdzlLIST(NMHDR* pNMHDR, LRESULT* pResult) 
{
	// TODO: Add your control notification handler code here
		int index=m_jdzllist.GetNextItem(-1,LVNI_SELECTED);
	if (index!=-1)
	{
		m_jdmc=m_jdzllist.GetItemText(index,0);
		m_szcs=m_jdzllist.GetItemText(index,1);
		m_lxr=m_jdzllist.GetItemText(index,2);
		m_dh=m_jdzllist.GetItemText(index,3);
		
	
	}
	UpdateData(FALSE);
	*pResult = 0;
	*pResult = 0;
}